Promote_all

Records not found...

-

(select am.article_id as id,am.article_homepage_headline as home_name,am.article_page_url as page_url,am.article_image as image1,am.article_story_label as story_label,am.is_paid as is_paid,(select category_master_name from category_master where category_master_id=am.category_id) as category_name,(select sub_category_master_name from sub_category_master where sub_category_master_id=am.sub_category_id) as sub_category_name,'article' as page,am.article_epoch as epoch from article_master_206m am where (am.article_date <='2024-04-26' and am.article_epoch<=1714075716) and am.active='Y' order by am.article_epoch desc limit 0,5) UNION ALL(select gm.gallery_id as id,gm.gallery_name_home as home_name,gm.gallery_url as page_url,gm.gallery_image as image1,gm.gallery_story_label as story_label,NULL as is_paid,(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,'photo' as page,gm.gallery_epoch as epoch from gallery_master gm where (gm.gallery_date <='2024-04-26' and gm.gallery_epoch<=1714075716) and gm.active='Y' order by gm.gallery_epoch desc limit 0,5) UNION ALL(select vm.video_id as id,vm.video_name_home as home_name,vm.video_url as page_url,vm.video_image as image1,vm.video_story_label as story_label,NULL as is_paid,(select category_master_name from category_master where category_master_id=vm.category_id) as category_name,(select sub_category_master_name from sub_category_master where sub_category_master_id=vm.sub_category_id) as sub_category_name,'video' as page,vm.video_epoch as epoch from video_master vm where (vm.video_date <='2024-04-26' and vm.video_epoch<=1714075716) and vm.active='Y' order by vm.video_epoch desc limit 0,5) UNION ALL(select lb.live_blog_id as id,lb.live_blog_homepage_headline as home_name,lb.live_blog_page_url as page_url,lb.live_blog_image as image1,lb.live_blog_story_label as story_label,NULL as is_paid,(select category_master_name from category_master where category_master_id=lb.category_id) as category_name,(select sub_category_master_name from sub_category_master where sub_category_master_id=lb.sub_category_id) as sub_category_name,'live-blog' as page,lb.live_blog_epoch as epoch from live_blog_master lb where (lb.live_blog_date <='2024-04-26' and lb.live_blog_epoch<=1714075716) and lb.active='Y' order by lb.live_blog_epoch desc limit 0,5)

Error