SELECT *, CASE WHEN `name` LIKE "north fort myers%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("north fort myers") AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("north fort myers") AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IN ("north fort myers") 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 ("north fort myers") 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.
