వార్తలు / కథనాలు
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 = '1101' and priority_isthumb = true 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 = '1101' and priority_isthumb = true order by priority_news_position desc, publish_createdon desc limit 2
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 = '1101' and priority_isthumb = false 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 = '1101' and priority_isthumb = false order by priority_news_position desc, publish_createdon desc limit 15
