SELECT SQL_CALC_FOUND_ROWS DISTINCT i.id FROM #__flexicontent_items_tmp AS i JOIN #__flexicontent_types AS ty ON i.type_id = ty.id JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN #__categories AS c ON c.id = i.catid WHERE 1 AND rel.catid IN ('50', '53', '173', '62', '262', '263', '266', '264', '265', '51', '52', '60', '63', '67', '68', '70', '71', '72', '79', '80', '84', '87', '88', '95', '97', '100', '268', '279', '281', '210', '94', '98', '99', '174', '211', '212', '213', '214', '280', '215', '81', '96') AND ( i.state IN (1, -5) ) AND ( ( i.publish_up is NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) ) AND ( ( i.publish_down is NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) ) AND (i .language = 'th-TH' OR i.language = '*') AND ty.access IN (0,1,4) AND c.access IN (0,1,4) AND i.access IN (0,1,4) ORDER BY i.created DESC, i.title ASC