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-02-21 03:27:09' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-21 03:27:09' ) AND i.catid=14 AND c.language IN ('en-GB', '*') AND i.language IN ('en-GB', '*') GROUP BY tag.id
Array (  => stdClass Object ( [name] => Branding [id] => 1 )  => stdClass Object ( [name] => Naming [id] => 8 )  => stdClass Object ( [name] => Packaging Design [id] => 9 )  => stdClass Object ( [name] => Web Design [id] => 10 )  => stdClass Object ( [name] => Brand Communication [id] => 12 ) )
Rebranding to help Bee Naturalles communicate its lab expertise & knowledge of nature
Bringing a 60-year-old boutique printing company’s values to life in a meaningful way.
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
A lookbook looking to attract fashion designers’ and women’s wear manufacturers’ attention
Our first self-published illustrated short story is out now!
Album cover design of an up-and-coming composer that is like music to people’s ears
Building a brand identity for an architectural firm that conveys its design mentality to clients