string(1036) "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-05-18 08:59' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-05-18 08:59' ) AND i.sectionid = 1 AND i.access <= 0 AND i.id IN (9827,9828,9829,9831,9833,9835,9836,9837,9838,9839,9843,9844,9845,9846,9856,9857,9858,9859,9860,9861,9864,9865,9866,9867,9927,9928,9929,9968,9969,10017,10018,10019,10067) AND it.field_id=23 AND it.value>0 ORDER BY i.title ASC "