-
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=7 and gm.sub_category_id=12 and gm.gallery_id NOT IN('98843') and gm.active='Y' and DATE(gm.gallery_date1)<='2024-10-16' and gm.gallery_epoch<='1729088707' order by gm.gallery_epoch desc limit 1
Error