CHOOSE BRANCH    ATLAS TRUCK SALES, INC.

 

SELECT UTA_vShared.id AS id,year,make,UTA_vShared.class AS class,UPPER(model) AS model,UTA_vShared.subclass, description,rprice,shoprice,UPPER(scseo) AS scseo,photo,year(CURDATE()) AS CY,odmiles,fobcity,fobstate, odmiles,engmake,engdet,enghp,coname,cophone1,utype,owner FROM UTA_vShared LEFT JOIN UTA_vSClass ON UTA_vShared.subclass=UTA_vSClass.subclass LEFT JOIN UTA_vSpec ON UTA_vSpec.id=UTA_vShared.id LEFT JOIN UTA_br ON UTA_br.id=owner WHERE owner='4' AND status='Live' AND list='Public' ORDER BY year DESC, model LIMIT 0,20