20 Time-Saving WordPress SQL Query Snippets

https://speckyboy.com/wordpress-sql-query-snippets/
*********************************

Get tag and category posts WP SQL

https://stackoverflow.com/questions/43705815/get-tag-and-category-posts-wp-sql

*******************************

WordPress :: SQL query to output post_title, categories and tags

https://www.mindyourownwebsite.com.au/wordpress-sql-query-output-post_title-categories-tags/

****************************

Displaying Posts Using a Custom Select Query
https://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query

**********************

SQL query to extract all WordPress posts with categories

https://stackoverflow.com/questions/13071035/sql-query-to-extract-all-wordpress-posts-with-categories

WordPress: SQL to get all Categories

https://techblog.willshouse.com/2012/02/22/wordpress-sql-to-get-all-categories/