SELECT * FROM wp_3_posts INNER JOIN wp_3_postmeta ON ( wp_3_posts.ID = wp_3_postmeta.post_id ) INNER JOIN wp_3_term_relationships ON ( wp_3_posts.ID = wp_3_term_relationships.object_id ) INNER JOIN wp_3_term_taxonomy ON ( wp_3_term_relationships.term_taxonomy_id = wp_3_term_taxonomy.term_taxonomy_id ) LEFT JOIN wp_3_terms ON ( wp_3_term_taxonomy.term_id = wp_3_terms.term_id ) WHERE wp_3_terms.name = 'iPhone' AND wp_3_term_taxonomy.taxonomy = 'ad_cat' AND wp_3_posts.post_status = 'publish' AND wp_3_posts.post_type = 'ad_listing' ORDER BY wp_3_postmeta.meta_value ASC LIMIT 0 , 30
$args=array( 'post_type' => 'ad_listing', 'taxonomy' => 'ad_cat', 'post_status' => 'publish', 'iphone' => $tax_term->slug, ); $my_query = new WP_Query($args);
There are currently 1 users browsing this thread. (0 members and 1 guests)