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=85 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=85 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
Construction Tech Review | BIM, Construction Software & Jobsite Tech Magazine
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
Latest Issues