Chris27 asks for help finding a Data Explorer query to retrieve posts by category, including subcategories, noting that while such data exists in admin reports, individual filtering is needed. JammyDodger responds by confirming whether the Data-Explorer plugin is installed and accessible via [YourSite]/admin/plugins/explorer, suggesting users can create custom queries. They also ask for clarification on the desired data, such as post counts by category, to assist with crafting the appropriate SQL query.
Hi everyone,
I was wondering if there was a query for posts by category. This information is available in the admin reports but I need to filter each category individually. I found mention of it here but can’t seem to find the Data Explorer Query. If anyone could help it would be greatly appreciated!
Are you still looking for help on this? If so…
[YourSite]/admin/plugins/explorer?From there you can create your own data-explorer queries if there isn’t a default one that suits. 
Clicking on the plus sign next to the search box will bring up the ‘add query’ options.
If you need help with the SQL query itself, could you be a little more specific in what data you’re looking to pull out? Is it a post count by category you’re looking for?
