php - sql statement for querying wp posts from specific category -

php - sql statement for querying wp posts from specific category -

i want query wordpress posts specific category parent problem there no such column on wp_posts table need bring together skills on sql not need help , here query utilize querying posts

$query = "select c.* {$wpdb->prefix}posts p, {$wpdb->prefix}comments c p.id = c.comment_post_id , c.comment_approved > 0 , p.post_type = 'product' , p.post_status = 'publish' , p.comment_count > 0 order ".$order_by." limit 0, ". $number_of_comments; }

and here snippet found joining term_taxonomy_id

$answer = $wpdb->get_results("select post_title, post_content, term_taxonomy_id wp_posts left bring together wp_term_relationships on wp_posts.id = wp_term_relationships.object_id substring(post_title,1,1)='t' , term_taxonomy_id=6");

the proplem can't seem figure how utilize illustration on query neither thinking of simpler solutions can query specific parent category , help

you looking @ this:

global $wpdb; $wpdb->show_errors(); $ur=$wpdb->get_results( $wpdb->prepare( " select * $wpdb->posts p bring together $wpdb->term_relationships tr on p.id=tr.object_id // identify link column bring together $wpdb->term_taxonomy t on tr.term_taxonomy_id=t.term_taxonomy_id bring together $wpdb->terms ts on t.term_id = ts.term_id p.post_type = %d // utilize wild chars (define below, 1 equals carmarket) , p.post_status = %f , t.taxonomy= %s ", 'carmarket', 'publish', 'carmake' ) ); $wpdb->print_error(); var_dump($ur);

php mysql sql wordpress