Created
October 14, 2015 13:55
-
-
Save vialde/bbce96835690e19a0fe4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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