FROM tblNews, ( SELECT guid, max(updated) AS max FROM tblNews WHERE approved = true AND hidden = false GROUP BY guid ) AS latestnews WHERE tblNews.approved = true AND tblNews.deleted = false AND latestnews.guid = tblNews.guid AND latestnews.max = tblNews.updated AND tblNews.guid IN ()