SELECT `skcwihblr_menus`.`menu_id`, `menu_name`, `menu_name_ar`, `menu_description`, `menu_photo`, `menu_price`, `menu_dine_in_price`, `menu_type`, `minimum_qty`, `menu_category_id`, `menu_priority`, `skcwihblr_categories`.`name` AS `category_name`, `skcwihblr_categories`.`parent_id` AS `parent_id`, `special_status`, `start_date`, `end_date`, `special_price`, `skcwihblr_menus`.`mealtime_id`, `skcwihblr_mealtimes`.`mealtime_name`, `skcwihblr_mealtimes`.`start_time`, `skcwihblr_mealtimes`.`end_time`, `mealtime_status`, `skcwihblr_locations`.`location_name`, IF(start_date <= CURRENT_DATE(), IF(end_date >= CURRENT_DATE(), "1", "0"), "0") AS is_special, IF(start_time <= CURRENT_TIME(), IF(end_time >= CURRENT_TIME(), "1", "0"), "0") AS is_mealtime
FROM `skcwihblr_menus`
LEFT JOIN `skcwihblr_categories` ON `skcwihblr_categories`.`category_id` = `skcwihblr_menus`.`menu_category_id`
LEFT JOIN `skcwihblr_menus_specials` ON `skcwihblr_menus_specials`.`menu_id` = `skcwihblr_menus`.`menu_id`
LEFT JOIN `skcwihblr_mealtimes` ON `skcwihblr_mealtimes`.`mealtime_id` = `skcwihblr_menus`.`mealtime_id`
LEFT JOIN `skcwihblr_locations` ON `skcwihblr_locations`.`location_id` = `skcwihblr_menus`.`location_id`
WHERE `menu_status` = '1'
AND `skcwihblr_categories`.`is_petpooja` = '0'
ORDER BY `menu_status` DESC, `skcwihblr_menus`.`menu_priority` ASC, `skcwihblr_menus`.`menu_category_id` ASC
 LIMIT 10000