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, c.attribs
                    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=136
 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.title DESC
 LIMIT 1
 OFFSET 0