SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(8, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
Sorry! there is no item available in the selected category
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(23, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(12, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(26, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(16, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(24, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(20, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(21, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6
SELECT *
FROM `tblitems`
WHERE `status` = 1
AND `is_daily` = 0
AND find_in_set(25, category) and find_in_set(7, menu_type)
AND `tblitems`.`deleted_date` is null
ORDER BY `id`
LIMIT 6