select am.article_id as id,am.article_homepage_headline as home_name,am.article_short_description as short_description,am.article_page_url as page_url,am.article_image as image1,am.article_image1 as image2,am.article_date1 as date_time,am.article_story_label as story_label,am.article_location as location,am.article_image_caption as image_caption,am.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,am.article_byline as author1_name,CONCAT(LOWER(am.article_byline),'-',(select author_id from author_master where author_name=am.article_byline and active='Y' order by author_id desc limit 1)) as author1_url,am.article_byline1 as author2_name,CASE WHEN am.article_byline1 IS NOT NULL THEN CONCAT(LOWER(am.article_byline1),'-',(select author_id from author_master where author_name=am.article_byline1 and active='Y' order by author_id desc limit 1)) ELSE NULL END AS author2_url,'article' as page from article_master_206m am where am.category_id=(select category_master_id from category_master where category_master_name='News') and am.sub_category_id=(select sub_category_master_id from sub_category_master where sub_category_master_name='India News') and (am.article_date <='2024-04-24' and am.article_epoch<=1713933681) and am.active='Y' order by am.article_epoch desc limit 0,19
