SELECT COUNT(DISTINCT(iMP_vShared.id))
FROM (iMP_vShared, iMP_vSpec)
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_vSClass.subclass=iMP_vShared.subclass
WHERE iMP_vShared.id=iMP_vSpec.id AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') AND ((status IN('Live','Order') AND list='Public' AND utype='New') OR (status IN('Live','Order','Pend') AND list='Public' AND utype='Used')) AND iMP_co.id>0
