select a.companyid,a.companytitle,a.management_name,a.image,a.management_name2,a.magazine_id,a.image2,c.cat_id from companies a, vendor_select b, magazine_details c where a.companyid=b.vid and a.magazine_id=c.sno and b.catid = 0 and b.position!=0 and a.image2!='' and c.status != 0 and a.web_id = 27 and b.web_id = 27 and c.web_id = 27 order by b.position=0,b.position asc limit 4

SELECT rnkid,rnktitle,rankpicname,weburl,rankyear,mag_id,app_status FROM ranking where mag_id=(select sno from magazine_details where label2='April' and year=2019 and status != 0 and web_id = 27) and app_status=1 and web_id = 27

| Construction Tech Review Tech

× Home

Construction Tech Safety and Compliance BIM

BIM

News Magazine Conference Newsletter Subscribe About Us

BIM Europe
Safety and Compliance Europe
BIM APAC
Construction Tech Europe
Construction Bid and Estimation
Flooring Tech
Modular Construction
Compliance and Safety
Project Management
Construction Tech Startup
HVAC
Building Automation System
Construction Monitoring
Material and Cost Estimation
Building Information Modeling
Intelligent Building
Roofing Tech

☰

Construction Bid and Estimation
Flooring Tech
Modular Construction
Compliance and Safety
More
- Project Management
  Construction Tech Startup
  HVAC
  Building Automation System
  Construction Monitoring
  Material and Cost Estimation
  Building Information Modeling
  Intelligent Building
  Roofing Tech

Construction Tech Review Weekly Brief

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

Construction Tech Review Weekly Brief

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

Home Magazine

THANK YOU FOR SUBSCRIBING

Past Issues

March 2020
Digitalization of the Construction Industry
Contents
Magazine Archive

Subscribe Now

View Digital Version

Top

This content is copyright protected

However, if you would like to share the information in this article, you may use the link below:

https://www.constructiontechreview.com/magazine/2019/April

THANK YOU FOR SUBSCRIBING

Past Issues

Contents