SELECT *
FROM  `wp_posts`
WHERE  `post_type` =  "post type name here"