SELECT `cat`, `sub_cat` FROM `wp_factual_businesses_live` WHERE region = "AL" AND locality = "carlton" AND sub_cat IS NOT NULL GROUP BY `cat`, `sub_cat`, `category_labels`,0.00 seconds - 0 rows
SELECT sub_cat, category_labels FROM `wp_factual_businesses_live` WHERE region = "AL" AND locality = "carlton" AND cat = "shopping" AND sub_cat IS NOT NULL AND `name` != 'redbox'
AND (website != '' AND website IS NOT NULL)
AND (business_blob IS NULL OR business_blob NOT LIKE '%inactive%')
AND (existence > 0.3 OR business_blob LIKE '%paid%')
AND (url_verified IS NULL OR url_verified != 'down')