SELECT c.id, c.title, c.introtext, c.state, c.sectionid, c.catid, c.created, c.modified, c.created_by, c.images,
               s.title AS sectiontitle, ct.title AS cattitle, u.name AS author
        FROM jos_content as c
        LEFT JOIN jos_sections as s ON s.id=c.sectionid
        LEFT JOIN jos_categories AS ct ON ct.id=c.catid
        LEFT JOIN jos_users AS u ON u.id=c.created_by
 WHERE c.id=(71823)
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= now() )
              AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= now() )
              AND c.state != -1 AND c.state != 0
 ORDER BY c.created DESC
 LIMIT 1
 OFFSET 0