SELECT tag.name, tag.id FROM #__k2_tags as tag INNER JOIN #__k2_tags_xref tags_xref ON tags_xref.tagID = tag.id RIGHT JOIN #__k2_items as i ON tags_xref.itemID = i.id RIGHT JOIN #__k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-10-10 07:42:10' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-10-10 07:42:10' ) AND i.catid=4 GROUP BY tag.id
Array
(
[0] => stdClass Object
(
[name] => Eκπαίδευση
[id] => 1
)
[1] => stdClass Object
(
[name] => Ψυχολογία
[id] => 2
)
[2] => stdClass Object
(
[name] => Με άλλη ματιά
[id] => 4
)
[3] => stdClass Object
(
[name] => Άρθρα
[id] => 5
)
[4] => stdClass Object
(
[name] => My brainy
[id] => 7
)
)