CHOOSE BRANCH    MHC KENWORTH-KANSAS CITYMHC KENWORTH-JACKSONMHC KENWORTH-KINGSPORTMHC KENWORTH-CHATTANOOGAMHC KENWORTH-KNOXVILLEMHC KENWORTH-NASHVILLEMHC TRUCK SOURCE-KANSAS CITYMHC KENWORTH-ODESSAMHC KENWORTH-SOUTH DALLASMHC KENWORTH/FORD-EL PASOMHC KENWORTH-TEXARKANAMHC KENWORTH-LONGVIEWMHC KENWORTH-WACOMHC KENWORTH-FT. WORTHMHC KENWORTH-DALLASMHC KENWORTH-TUPELOMHC KENWORTH-MEMPHISMHC FORD-MEMPHISMHC KENWORTH-SALINAMHC KENWORTH-SOUTH ATLANTAMHC KENWORTH-ATLANTAMHC KENWORTH-TULSAMHC KENWORTH-COLUMBIAMHC KENWORTH-ARDMOREMHC KENWORTH-OKLAHOMA CITYMHC KENWORTH-VAN BURENMHC KENWORTH-LITTLE ROCKMHC KENWORTH-CHEYENNEMHC KENWORTH-GRAND JUNCTIONMHC KENWORTH-GREELEYMHC KENWORTH-PUEBLOMHC KENWORTH-COLORADO SPRINGSMHC KENWORTH-DENVERMHC KENWORTH-JOPLINMHC KENWORTH/VOLVO-SPRINGDALEMHC KENWORTH-SPRINGFIELDMHC KENWORTH-OLATHE

 

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