FIRST-TO-MARKET - NEW PRODUCT LEADER
Be ahead. Check out these must-stock new products from the 1st to Market Leader.
WordPress database error: [FUNCTION pgfilt5_newdesign.digits does not exist]SELECT p.partnumber,pm.partTypename,TRIM(ma.MakeName) AS make,TRIM(mo.ModelName) AS model FROM applications a
JOIN pgfilt5_vcdb_master.make ma ON a.MakeID = ma.MakeID
JOIN pgfilt5_vcdb_master.model mo ON a.ModelID = mo.ModelID
JOIN partNumberInfo p ON a.part_id=p.part_id
JOIN parttype_master pm ON p.PartTerminologyID=pm.PartTerminologyID
WHERE p.PartTerminologyID IN (5340) AND a.YearID='2026' AND p.partnumber NOT LIKE 'MG%' AND p.partnumber NOT IN('NRO','NSO','NR')
GROUP BY p.partnumber
ORDER BY CAST(digits(p.partnumber) as UNSIGNED) DESC
