string(888) "SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie ON ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty ON ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__flexicontent_fields_item_relations AS it ON it.item_id = i.id LEFT JOIN #__categories AS c ON c.id = i.catid LEFT JOIN #__users AS u ON u.id = i.created_by WHERE rel.catid IN ('3') AND i.state IN (1, -5) AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-06-20 00:58' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-06-20 00:58' ) AND i.sectionid = 1 AND i.access <= 0 AND i.id IN (9876,9937,9938,10084) AND it.field_id=23 AND it.value>0 ORDER BY i.title ASC "