SQL request problem

Hey guys. Hope you will understand my English.
So, I have 2 taxonomies: city and street.

I need to get postmeta for one of my plugins.

Working code for only one taxonomy:

SELECT * 
FROM $wpdb->postmeta 
LEFT JOIN $wpdb->posts 
ON($wpdb->posts.ID = $wpdb->postmeta.post_id) 
LEFT JOIN $wpdb->term_relationships 
ON ($wpdb->postmeta.post_id = $wpdb->term_relationships.object_id) 
LEFT JOIN $wpdb->term_taxonomy 
ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) 
WHERE 
meta_key LIKE 'rwp_rating%' 
AND ($wpdb->term_taxonomy.taxonomy = 'city' AND $wpdb->term_taxonomy.term_id = '2') 

but if I append AND ($wpdb->term_taxonomy.taxonomy = 'street' AND $wpdb->term_taxonomy.term_id = '5')
it returns empty result

Also I tried to do that:

SELECT * FROM $wpdb->postmeta 
LEFT JOIN $wpdb->posts ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) 
LEFT JOIN $wpdb->term_relationships ON ($wpdb->postmeta.post_id = $wpdb->term_relationships.object_id) 
LEFT JOIN $wpdb->term_taxonomy as t1 ON ($wpdb->term_relationships.term_taxonomy_id = t1.term_taxonomy_id) 
LEFT JOIN $wpdb->term_taxonomy as t2 ON ($wpdb->term_relationships.term_taxonomy_id = t2.term_taxonomy_id) 
WHERE meta_key LIKE 'rwp_rating%' AND (t1.taxonomy = 'city' AND t1.term_id = '2') AND (t2.taxonomy = 'street' AND t2.term_id = '3331');

And it doesn’t working too.

p.s. I need to match both, like: city = 2 AND street = 2
not: city = 2 OR street = 2

• This topic was modified 8 years ago by Roman Sarvarov.
• This topic was modified 8 years ago by Roman Sarvarov.