Keyword

SQL Sentence to select items by Tag

  • Jaime Villegas
  • Jaime Villegas's Avatar Topic Author
  • Offline
  • New Member
More
4 months 1 week ago #168444 by Jaime Villegas
Jaime Villegas created the topic: SQL Sentence to select items by Tag
Hello Guys,
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?

Thanks!

Please Log in or Create an account to join the conversation.

More
4 months 1 week ago #168460 by Krikor Boghossian
Krikor Boghossian replied the topic: SQL Sentence to select items by Tag

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

---
JoomlaWorks
www.joomlaworks.net/

Please Log in or Create an account to join the conversation.

Moderators: william white