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 <= '2021-02-25 18:33:40' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-02-25 18:33:40' ) 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
)
)
Creating the visual identity for a Swiss-made innovative daily balancer
We inspired by nature’s landscape for the total rebranding of an old winery
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
Rebranding to help Bee Naturalles communicate its lab expertise & knowledge of nature
We invest on our creative side to show-off a Pastime Center of Children Creativity that potentiates kids’ experimental tendency
Training the “mind” through a clothing collection exclusively designed for pilates
Bringing a 60-year-old boutique printing company’s values to life in a meaningful way.