QUERY = SELECT 'doc' AS rs_feed, 'Documents' AS rs_type, gdc_title AS rs_title, gdc_visibility AS rs_visibility, 'documents.php?action=show&gdid' AS rs_link, gdc_id AS rs_id, gdc_created AS rs_created, DATE_FORMAT(gdc_created, "%d-%b-%Y") AS rs_created_stamp, u_firstname AS rs_firstname, u_lastname AS rs_lastname, CONCAT(gdc_id,'/',gdc_fn1) AS rs_doclink, gdc_sx1 AS rs_doctype FROM g_document left join ph_userinfo on gdc_created_by = u_alias WHERE gdc_project = "341" AND gdc_id IN (select MAX(gdc_id) FROM g_document WHERE gdc_project = "341" GROUP BY gdc_oldver) AND rs_visibility >= "40" ORDER BY rs_created DESC