select distinct news_id, news_title_telugu, news_title_english, main_news_image, news_image, news_short_description, news_thumbimg, news_videolink, publish_createdon, news_videotype, news_videoinfo, news_tags_keywords,priority_news_position, news_sections,(case when (video_type is not null and video_type > 0) then 1 else 0 end) as video_type from ee_news_items join ee_publishing_status on (news_publishid=publish_id) left join ee_news_video_daywise on (video_news_id = news_id) join ee_news_priorities on (priority_news_id=news_id) where '2021-02-27' <= date(priority_validto) and news_isactive = 1 and news_status = 2 and priority_isactive = 'true' and priority_subsection_id = '1600' and priority_isthumb = false and news_id not in (121042619,121042607,121042593) union all select distinct news_id, news_title_telugu, news_title_english, '' as main_news_image, '' as news_image, news_short_description, '' as news_thumbimg, '', news_publish_createdon as publish_createdon, news_videotype, '' as news_videoinfo, news_tags_keywords, priority_news_position, news_subsections as news_sections,(case when (video_type is not null and video_type > 0) then 1 else 0 end) as video_type from siri_news_items left join siri_news_videos on (video_news_id = news_id) join siri_news_priorities on (priority_news_id=news_id) where '2021-02-27' <= date(priority_validto) and news_isactive = 1 and news_status = 2 and priority_isactive = 'true' and priority_subsection_id = '1600' and priority_isthumb = false and news_id not in (121042619,121042607,121042593) order by priority_news_position desc, publish_createdon desc limit 9