-

Select gallery_id,gallery_url,gallery_name,(select cm.category_master_name from category_master cm where cm.category_master_id=gm.category_id and cm.active='Y') as category_name,(select scm.sub_category_master_name from sub_category_master scm where scm.sub_category_master_id=gm.sub_category_id and scm.active='Y') as sub_category_name from gallery_master gm where gm.category_id=5 and gm.sub_category_id=2 and gm.gallery_id NOT IN('101024') and gm.active='Y' and DATE(gm.gallery_date1)<='2024-11-28' and gm.gallery_epoch<='1732797334' order by gm.gallery_epoch desc limit 1

Error