CHOOSE BRANCH    ARROW TRUCK SALES-CINCINATTIARROW TRUCK SALES-NEWARKARROW TRUCK SALES-PHILADELPHIAARROW TRUCK SALES-CHICAGOARROW TRUCK SALES-ATLANTAARROW TRUCK SALES-DALLASARROW TRUCK SALES-KANSAS CITYARROW TRUCK SALES-ST. LOUISARROW TRUCK SALES-LOS ANGELESARROW TRUCK SALES-STOCKTONARROW TRUCK SALES-FONTANAARROW TRUCK SALES-PHOENIXARROW REUCK SALES-SAN ANTONIOARROW TRUCK SALES-HOUSTONARROW TRUCK SALES-TORONTOARROW TRUCK SALES-TAMPAARROW TRUCK SALES-DENVER

 

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='27' AND status='Live' AND list='Public' ORDER BY year DESC, model LIMIT 0,20