SELECT SQL_CALC_FOUND_ROWS DISTINCT i.id FROM #__flexicontent_items_tmp AS i JOIN #__flexicontent_tags_item_relations AS tag ON tag.itemid = i.id JOIN #__flexicontent_tags AS tagtbl ON tagtbl.id = tag.tid AND tagtbl.published = 1 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 tag.tid = '7620' 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