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 <= '2020-08-07 00:09:25' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-08-07 00:09:25' ) AND i.catid=14 AND c.language IN ('en-GB', '*') AND i.language IN ('en-GB', '*') GROUP BY tag.id
Array
(
    [0] => stdClass Object
        (
            [name] => Branding
            [id] => 1
        )

    [1] => stdClass Object
        (
            [name] => Naming
            [id] => 8
        )

    [2] => stdClass Object
        (
            [name] => Packaging Design
            [id] => 9
        )

    [3] => stdClass Object
        (
            [name] => Web Design
            [id] => 10
        )

    [4] => stdClass Object
        (
            [name] => Brand Communication
            [id] => 12
        )

)
e
All
All
Branding
Naming
Packaging Design
Web Design
Brand Communication

Designing a brand identity based on the rules of the architecture

Naming and brand identity creation for a baptismal handmade clothing collection that narrates its own one of a kind story

A website with an eye for women’s fashion and textiles

Two generations working together. One visual identity for both of them.

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