There was an SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and category.category_status = 1 and store_status = 1 and city.city_status = 1 a' at line 9 - SELECT `category`.`category_id`, `category`.`category_name`, `category`.`category_url` FROM (`category`) JOIN `deals` ON (`deals`.`category_id` = `category`.`category_id`) JOIN `deal_mapping` ON (`deal_mapping`.`deal_id` = `deals`.`deal_id`) JOIN `stores` ON (`stores`.`store_id` = `deal_mapping`.`store_id`) JOIN `city` ON (`city`.`city_id` = `stores`.`city_id`) JOIN `country` ON (`country`.`country_id` = `stores`.`country_id`) JOIN `users` ON (`users`.`user_id` = `deals`.`merchant_id`) WHERE deal_type = 1 and deal_status = 1 and (deals.maximum_deals_limit != 0 or deals.purchase_count <= deals.maximum_deals_limit or enddate > 1542531779) and stores.city_id = and category.category_status = 1 and store_status = 1 and city.city_status = 1 and country.country_status = 1 and startdate < 1542531779 and type = 1 GROUP BY `category`.`category_id`
No data found
Back To Top