SELECT *, CASE WHEN `name` LIKE "San Angelo%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "San Angelo" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "San Angelo" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "San Angelo" 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_62_slides` WHERE (locality IN ("San Angelo") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND active = 1 ORDER BY `rank` DESC LIMIT 12 [3] matching rows / [0.00 msec] Blog ID 62 Blah

San Angelo

SELECT *, CASE WHEN `name` LIKE "San Angelo%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "San Angelo" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "San Angelo" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "San Angelo" 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_62_slides` WHERE (locality IN ("San Angelo") OR locality IS NULL) AND (cat IS NULL) AND (name = "home-bot") AND active = 1 ORDER BY `rank` DESC LIMIT 20 [5] matching rows / [0.00 msec] Blog ID 62 Blah
[instagram-feed num=9 cols=3 colsmobile=3 showheader=false showfollow=true type=user user=exploreus.ky]