EXPLORE US

SELECT *, CASE WHEN `sub_cat` IS NULL AND `cat` = "professional-services" AND `locality` = "comfort" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` = "professional-services" AND `locality` = "comfort" 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` = "comfort" AND `logo_file_name` IS NOT NULL THEN 6 WHEN `sub_cat` IS NOT NULL AND `cat` = "professional-services" AND `locality` = "comfort" 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..