I am attempting to mine data based on:
I.e. Show me these specific events with this / these specific tag(s).
Here is / are my event(s):
SELECT DATE_FORMAT(start_date, '%M %d, %Y') ,
catid = '54' AND
start_date = '2018-07-05 00:00:00'
Here is my tag:
SELECT * FROM #__tags WHERE title = 'SOME TAG TITLE'
I am lost in the many to many relationship of the Joomla tags and in my own lack of knowledge. Specifically using join statements and pulling the two together.
My desired result is simply an event
#__dpcalendar_events that contains 'SOME TAG TITLE' from #__tags.
Anybody care to help out a noob?