select distinct(box_position) from box_layout_content where category_id=10 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=10 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=40 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=40 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=37 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=37 and b.boxno=3 and b.box_position=3 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=70 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=70 and b.boxno=7 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=24 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=24 and b.boxno=7 and b.box_position=1 and home_priority!=0 and a.web_id = 27 and b.web_id = 27
Construction Tech Review | Leading Print & Digital Magazine for Construction Technology Insights
Be first to read the latest tech news, Industry Leader's Insights, and CIO interviews of medium and large enterprises exclusively from Construction Tech Review
ON THE DECK