EXPLORE US
Updated 769 days ago
SELECT *, CASE WHEN `sub_cat` IS NULL AND `cat` = "professional-services" AND `locality` = "bandera" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` = "professional-services" AND `locality` = "bandera" AND `logo_file_name` IS NULL THEN 9 WHEN `sub_cat` IS NULL AND `cat` = "professional-services" AND `locality` IS NULL AND `logo_file_name` IS NOT NULL THEN 8 WHEN `sub_cat` IS NULL AND `cat` = "professional-services" AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 7 WHEN `sub_cat` IS NOT NULL AND `cat` = "professional-services" AND `locality` = "bandera" AND `logo_file_name` IS NOT NULL THEN 6 WHEN `sub_cat` IS NOT NULL AND `cat` = "professional-services" AND `locality` = "bandera" AND `logo_file_name` IS NULL THEN 5 WHEN `sub_cat` IS NOT NULL AND `cat` = "professional-services" AND `locality` IS NULL AND `logo_file_name` IS NOT NULL THEN 4 WHEN `sub_cat` IS NOT NULL AND `cat` = "professional-services" AND `locality` IS NULL AND `logo_file_name` IS NULL..