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-11-12 12:57:15' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-12 12:57:15' ) 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
        )

)



BACK TO TOP

Based in Greece

Discuss a new project

Evaggelos Spiliopoulos
Let’s stay connected!

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