Cacher is the code snippet organizer for pro developers

SELECT ID, `post_date` ,  `post_title` ,  `post_content` ,  `guid`, `menu_order`  FROM  `wp_posts` as post
INNER JOIN wp_term_relationships rs ON rs.object_id = post.ID 
WHERE  `post_type` =  "product" 
AND rs.term_taxonomy_id  = 53