select gm.gallery_id as id,gm.gallery_name_home as home_name,gm.gallery_description as short_description,gm.gallery_url as page_url,gm.gallery_image as image1,gm.gallery_image1 as image2,gm.gallery_date1 as date_time,gm.gallery_story_label as story_label,gm.gallery_location as location,gm.gallery_image_caption as image_caption,(select category_master_name from category_master where category_master_id=gm.category_id) as category_name,(select sub_category_master_name from sub_category_master where sub_category_master_id=gm.sub_category_id) as sub_category_name,NULL as is_paid,gm.gallery_author as author1_name,CONCAT(LOWER(gm.gallery_author),'-',(select author_id from author_master where author_name=gm.gallery_author and active='Y' order by author_id desc limit 1)) as author1_url,NULL as author2_name,NULL as author2_url,'photo' as page from gallery_master gm where (gm.gallery_date <='2023-12-05' and gm.gallery_epoch<=1701744145) and (FIND_IN_SET('brett lee', gm.gallery_o_tags) or FIND_IN_SET('brett lee', gm.gallery_author)) and gm.active='Y' order by gm.gallery_epoch desc limit 0,5
