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 NelsonFeb 13, 2020 at 19:19
Automated reporting purposes.– AkudenFeb 13, 2020 at 19:53
relations table holds all of the information about relations between Craft elements (entries and categories in your case).
So you would use the
targetId columns of the
relations table and join on the
id columns of the
categories tables in your example.