I have a custom product grid not associated with Craft Commerce. I am wondering, how can I query, in the SQL database, all entries and their related categories?
-
why would you write an SQL query instead of using craft techniques? (twig / element api) – Clark Nelson Feb 13 '20 at 19:19
-
Automated reporting purposes. – Akuden Feb 13 '20 at 19:53
The relations
table holds all of the information about relations between Craft elements (entries and categories in your case).
So you would use the sourceId
and targetId
columns of the relations
table and join on the id
columns of the entries
and categories
tables in your example.