How to write sql query to get the posts from a custom taxonomy term name

Question

I hope someone will help me.............

I have a

• Post Type ----> Dealers
• Taxonomy ----> State

how to write a sql query in this format

$catinfo1 = $wpdb->get_results("select t.*,(select count(tr.object_id) from $wpdb->term_relationships tr join $wpdb->posts p on p.ID=tr.object_id where tt.term_taxonomy_id=tr.term_taxonomy_id and p.post_status='publish') pcount from $wpdb->terms t join $wpdb->term_taxonomy tt on tt.term_id=t.term_id where tt.taxonomy=\"fueltype\" and tt.parent=0 order by t.name");

Answer 1

@Sisir linked you to the appropriate place, if you had read the question/answer and the linked Codex documentation you'd have seen that you could do something like the following:

$args = array(
    'post_type' => 'dealers'
    'tax_query' => array(
        array(
            'taxonomy' => 'state',
            'field' => 'slug',
            'terms' => array('bob','angela','john','smith','jan','doe','etc...')
        )
    )
);
$query = new WP_Query( $args );

Note the multiple state terms being queried, not the single specific one.