SELECT scweb,scseo,pl,iMP_vSClass.class AS class
FROM iMP_vShared
LEFT JOIN iMP_co ON iMP_co.id=iMP_vShared.cid
LEFT JOIN iMP_lotM ON labbr=lot
LEFT JOIN iMP_vSClass ON iMP_vSClass.class=iMP_vShared.class AND iMP_vShared.subclass=iMP_vSClass.subclass
WHERE scseo IS NOT NULL AND list='Public' AND status='Live' AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') AND status IN('Live','Pend') AND list='Public' AND iMP_co.id=1
GROUP BY scweb
ORDER by scseo

IN FRAME OVERHAUL AT 470,970 MILES!!! READY TO GO FOR LONG TIMEFULL SERVICE LEASE RETURN. GREAT SHAPE IN AND OUT. ALL MAINTENANCE RECORDS AVAILABLE.FOR MORE INFORMATION CONTACT STEPHANIE HEIDELBACH @...