SELECT *, CASE WHEN `name` LIKE "spring valley%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("spring valley") AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("spring valley") AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("spring valley") AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "IL" AND (locality IN ("spring valley") OR locality IS NULL) AND slide_location IN ("city-banner") AND active = 1 ORDER BY `rank` DESC LIMIT 1
[1] matching rows / [0.00 msec]
Blog ID 12
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat = "professional-services" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.01 msec]
Blog ID 12
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat = "lodging" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND (sub_cat = "bed and breakfast,campground" OR sub_cat IS NULL) AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.01 msec]
Blog ID 12
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat = "dining" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.01 msec]
Blog ID 12
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat = "lodging" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.01 msec]
Blog ID 12
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat = "shopping" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.01 msec]
Blog ID 12
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat = "local-real-estate" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND (sub_cat = "residential" OR sub_cat IS NULL) AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.01 msec]
Blog ID 12
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IL" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.01 msec]
Blog ID 12
Blah
Street View data not found for this location.
LET'S GET TOGETHER
JOIN OUR NEWSLETTER
RELAX AND READ OUR NEWSLETTER AT YOUR LEISURE. WE PUBLISH AUTHENTIC STORIES FROM HUNDREDS OF COMMUNITIES.
