Q&A for Joomla! administrators, users, developers and designers
select top 200 a.title, a.body from posts a LEFT JOIN pendingflags b ON (a.id = b.id) WHERE b.id IS NULL