Amir Hossein Amini AmirHosseinAminiDev

💭

I m in touch in few minutes :)

Im a Back-end Developer and im programming with php and laravel framework . I love codes world... :)

robwent / select-posts-by-cat-id.sql

Created January 10, 2018 18:16

Select Wordpress posts by category ID

	SELECT * FROM wp_posts
	LEFT JOIN wp_term_relationships ON
	(wp_posts.ID = wp_term_relationships.object_id)
	LEFT JOIN wp_term_taxonomy ON
	(wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
	WHERE wp_posts.post_type = 'post'
	AND wp_term_taxonomy.taxonomy = 'category'
	AND wp_term_taxonomy.term_id = 48
	ORDER BY post_date DESC