4

select distinct(box_position) from box_layout_content where category_id=5 and home_priority!=0 and web_id = 27 order by box_position asc

select a.news_id,a.headline,a.source,a.description,a.image1,a.news_type,a.source2,a.source3,a.category_type,a.image2,b.boxno,b.type,b.news_id,a.short_desc,a.image3,a.image4,a.image5,a.image6,a.image7_home,a.person_name,a.person_designation,a.person_company,a.new_url_flag,a.crawl from news_data a,box_layout_content b where a.news_id=b.news_id and b.category_id=5 and b.boxno=6 and b.box_position=2 and home_priority!=0 and a.web_id = 27 and b.web_id = 27

select distinct(box_position) from box_layout_content where category_id=71 and home_priority!=0 and web_id = 27 order by box_position asc

select a.news_id,a.headline,a.source,a.description,a.image1,a.news_type,a.source2,a.source3,a.category_type,a.image2,b.boxno,b.type,b.news_id,a.short_desc,a.image3,a.image4,a.image5,a.image6,a.image7_home,a.person_name,a.person_designation,a.person_company,a.new_url_flag,a.crawl from news_data a,box_layout_content b where a.news_id=b.news_id and b.category_id=71 and b.boxno=8 and b.box_position=1 and home_priority!=0 and a.web_id = 27 and b.web_id = 27

select distinct(box_position) from box_layout_content where category_id=36 and home_priority!=0 and web_id = 27 order by box_position asc

select a.news_id,a.headline,a.source,a.description,a.image1,a.news_type,a.source2,a.source3,a.category_type,a.image2,b.boxno,b.type,b.news_id,a.short_desc,a.image3,a.image4,a.image5,a.image6,a.image7_home,a.person_name,a.person_designation,a.person_company,a.new_url_flag,a.crawl from news_data a,box_layout_content b where a.news_id=b.news_id and b.category_id=36 and b.boxno=6 and b.box_position=1 and home_priority!=0 and a.web_id = 27 and b.web_id = 27

select distinct(box_position) from box_layout_content where category_id=19 and home_priority!=0 and web_id = 27 order by box_position asc

select a.news_id,a.headline,a.source,a.description,a.image1,a.news_type,a.source2,a.source3,a.category_type,a.image2,b.boxno,b.type,b.news_id,a.short_desc,a.image3,a.image4,a.image5,a.image6,a.image7_home,a.person_name,a.person_designation,a.person_company,a.new_url_flag,a.crawl from news_data a,box_layout_content b where a.news_id=b.news_id and b.category_id=19 and b.boxno=8 and b.box_position=3 and home_priority!=0 and a.web_id = 27 and b.web_id = 27

Top