SELECT *, CASE WHEN `name` LIKE "howey in the hills%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("howey in the hills") AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("howey in the hills") AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("howey in the hills") 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 = "FL" AND (locality IN ("howey in the hills") 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 4
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
Blah
Street View data not found for this location.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
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.
