Jaime Villegas created the topic: SQL Sentence to select items by Tag
I need to create reports of the hits for each article of our sponsors. I am using the component Alter Reports to create the report using SQL sentences.
So we associate every sponsor with a K2 tag, for example articles published of BOSCH are tagged with the K2 tag BOSCH.
The K2 tags are not included in the k2_items table, so it is more difficult to select those articles.
May you help me with the SQL sentence to select items using tags?