Some usefull SQL-Querys for Wordpress

Wordpress-SQL-Snippets.sql

#get all published posts with their tags and categorys
SELECT *
  FROM wp_posts 
    LEFT JOIN wp_term_relationships
      ON wp_posts.ID=wp_term_relationships.object_id
    LEFT JOIN wp_terms
      ON wp_term_relationships.term_taxonomy_id=wp_terms.term_id
  WHERE post_status='publish';

#get all published posts for a given tag-id or category-id
SELECT *
  FROM wp_posts
  LEFT JOIN wp_term_relationships
    ON wp_posts.ID=wp_term_relationships.object_id
  WHERE post_status='publish'
    AND wp_term_relationships.term_taxonomy_id=1;