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-09-16 08:03:56' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-09-16 08:03:56' ) 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

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

Training the “mind” through a clothing collection exclusively designed for pilates

Telling the story of an everyday Greek ‘hero’ to tourists through packaging design

A name and oil package design destined to hit the Northern European deli market

Album cover design of an up-and-coming composer that is like music to people’s ears

Establishing an easily-recognizable artisanal personality for a new espresso blend

Creating a name and package design that underlines the purity of its content

Twelve Bees’ honey packaging speaks to the heart of raw foodists

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