SELECT a_id, a_id_word, a_headline, a_publish_date, a_abstract, a_author, a_has_video, a_has_audio FROM su_cat_sg_mappings, re_categories , re_category_sections_assoc , pr_sections , pr_article_section_assoc , pr_articles_search, pr_article_media_assoc WHERE csg_sg_id = 1 AND csg_cat_id = cat_id AND a_status = 1 AND a_process_status = 4 AND a_expiry_date >= 1719291600 AND cat_id = scat_cat_id AND scat_s_id = s_id AND s_id = ase_s_id AND ase_a_id = a_id AND cat_re_id = 42 AND ama_a_id = a_id AND ama_mt_id = 2 AND ama_p_id = ase_p_id AND s_id NOT IN (14903,14910,14911,14906,14904,14912,14909,14908,14907,14905) AND a_publish_date <= 1719291600 AND ase_s_id IN (13206,13207,13208,13209,13210,13211,14520,13212,13213,13832,13214,13215,13216,13217,13218,13219,14182,13220,13221,14501,13222,13223,14674,14186,14436,13224,13225,13226,13227,13228,13229,14519,14485,13230,14484,14878,14183,13350) GROUP BY a_id ORDER BY a_publish_date DESC LIMIT 0, 100