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 <= '2019-08-25 22:03:36' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-08-25 22:03:36' ) AND i.catid=12 AND c.language IN ('en-GB', '*') AND i.language IN ('en-GB', '*') GROUP BY tag.id
Array
(
    [0] => stdClass Object
        (
            [name] => New Client
            [id] => 7
        )

    [1] => stdClass Object
        (
            [name] => Stories
            [id] => 16
        )

    [2] => stdClass Object
        (
            [name] => Articles
            [id] => 17
        )

    [3] => stdClass Object
        (
            [name] => Publications
            [id] => 18
        )

)
e
All
All
New Client
Stories
Articles
Publications
BACK TO TOP

Based in Greece

Discuss a new project

Evaggelos Spiliopoulos
Stay updated:

This website uses cookies to manage authentication, navigation, and other functions. Accessing our website, you agree that we can use these types of cookies.

OK