[SQL] Presek selectov

SELECT p.* FROM $wpdb->posts p, $wpdb->postmeta m
WHERE p.post_type = 'post'
AND p.ID = m.post_id
AND m.meta_key = 'x1'
AND m.meta_value = 'x2'
AND (p.post_content LIKE '%$search%' OR p.post_title LIKE '%$search%')

INTERSECT

SELECT p.* FROM $wpdb->posts p, $wpdb->postmeta m
WHERE p.ID = m.post_id
AND m.meta_key = 'y1'
AND m.meta_value = 'y2'

INTERSECT
 
SELECT p.* FROM $wpdb->posts p, $wpdb->postmeta m
AND p.ID = m.post_id
AND m.meta_key = 'c1'
AND m.meta_value = 'c2'