QUERY = SELECT 'evt' AS rs_feed, 'Events' AS rs_type, gev_title AS rs_title, gev_visibility AS rs_visibility, 'documents.php?action=show&geid' AS rs_link, gev_id AS rs_id, gev_created AS rs_created, DATE_FORMAT(gev_created, "%d-%b-%Y") AS rs_created_stamp, u_firstname AS rs_firstname, u_lastname AS rs_lastname, CONCAT(gev_id,'/',gev_fn1) AS rs_doclink, gev_sx1 AS rs_doctype, DATE_FORMAT(gev_date, "%d-%b-%y") AS rs_data1, TIME_FORMAT(gev_time, "%H:%i") AS rs_data2, k_desc AS rs_data3 FROM g_event left join ph_userinfo on gev_created_by = u_alias, code WHERE gev_project = "341" AND k_type ="gev_zone" AND k_code = gev_zone AND rs_visibility >= "40" ORDER BY gev_date DESC, gev_time DESC