Hi guys,
I’m trying to pull a count of termIDs from one table and the term_name from another table.
Here’s the query that’s working to get the count:
SELECT value AS tid, COUNT(value) AS count FROM notifications_fields
WHERE field = ‘tid’ GROUP BY value ORDER BY count DESC;
Now I need to pull the term_name from the term_data table. Both tables (notifications_fields and term_data) have tid columns.
Thanks!
Kevin