Skip to content

Instantly share code, notes, and snippets.

@vialde
Created October 14, 2015 13:55
Show Gist options
  • Save vialde/bbce96835690e19a0fe4 to your computer and use it in GitHub Desktop.
Save vialde/bbce96835690e19a0fe4 to your computer and use it in GitHub Desktop.
SELECT DISTINCT `wp1`.post_id
FROM wp_posts,wp_postmeta as wp1,wp_postmeta as wp2,wp_postmeta as wp3,wp_postmeta as wp4,wp_postmeta as wp5,wp_postmeta as wp6,wp_postmeta as wp7,wp_postmeta as wp8,wp_postmeta as wp9,wp_postmeta as wp10,wp_postmeta as wp11
WHERE wp_posts.ID = wp1.post_id AND wp1.post_id = wp2.post_id AND wp1.post_id = wp3.post_id AND wp1.post_id = wp4.post_id AND wp1.post_id = wp5.post_id AND wp1.post_id = wp6.post_id AND wp1.post_id = wp7.post_id AND wp1.post_id = wp8.post_id AND wp1.post_id = wp9.post_id AND wp1.post_id = wp10.post_id AND wp1.post_id = wp11.post_id
AND ((wp1.meta_key='state' AND wp1.meta_value='Idaho')) AND ((wp2.meta_key='county' AND wp2.meta_value='Butte') OR (wp2.meta_key='county' AND wp2.meta_value='Lemhi')) AND ((wp3.meta_key='access_issue' AND wp3.meta_value LIKE '%Paved Road%') OR (wp3.meta_key='access_issue' AND wp3.meta_value LIKE '%Gravel Road%') OR (wp3.meta_key='access_issue' AND wp3.meta_value LIKE '%Dirt Road%')) AND ((wp4.meta_key='slope' AND wp4.meta_value='Mostly Flat') OR (wp4.meta_key='slope' AND wp4.meta_value='Rolling') OR (wp4.meta_key='slope' AND wp4.meta_value='Sloped')) AND ((wp5.meta_key='zoning_general' AND wp5.meta_value LIKE '%Residential%') OR (wp5.meta_key='zoning_general' AND wp5.meta_value LIKE '%Agricultural%') OR (wp5.meta_key='zoning_general' AND wp5.meta_value LIKE '%Recreational%') OR (wp5.meta_key='zoning_general' AND wp5.meta_value LIKE '%Forest / Conservation%')) AND ((wp6.meta_key='uses' AND wp6.meta_value LIKE '%Camping%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Farming%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Fishing%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Homesite%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Hunting%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Investment%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Off-the-Grid%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Recreational%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Timberland%') OR (wp6.meta_key='uses' AND wp6.meta_value LIKE '%Waterfront%')) AND ((wp7.meta_key='base_price' AND wp7.meta_value BETWEEN 0 AND 1000) OR (wp7.meta_key='base_price' AND wp7.meta_value BETWEEN 1001 AND 5000) OR (wp7.meta_key='base_price' AND wp7.meta_value BETWEEN 5001 AND 10000) OR (wp7.meta_key='base_price' AND wp7.meta_value BETWEEN 10001 AND 999999)) AND ((wp8.meta_key='elevation' AND wp8.meta_value BETWEEN 0 AND 499) OR (wp8.meta_key='elevation' AND wp8.meta_value BETWEEN 500 AND 1999) OR (wp8.meta_key='elevation' AND wp8.meta_value BETWEEN 2000 AND 3999) OR (wp8.meta_key='elevation' AND wp8.meta_value BETWEEN 4000 AND 15000)) AND ((wp9.meta_key='size' AND wp9.meta_value BETWEEN 10 AND 999999)) AND (1=1) AND ((wp11.meta_key='status' AND wp11.meta_value != 'SOLD') AND (wp11.meta_key='status' AND wp11.meta_value != 'ARCHIVED'))
AND post_status = 'publish';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment