Brands Vehicles
Lowest Prices
Free Returns
Online Since 2009
Shopping for

2019 GMC Sierra 2500 HD

X

Dorman 620-993 Engine Cooling Fan Shroud
for 2019 GMC Sierra 2500 HD

1146 - Table 'ckd_cnslt_par.asset_data' doesn't exist

SELECT DISTINCT a.`aaia_brand_name`, a.`part_num`, a.`codeid`, a.`filename`, b.`source_map_id`, b.`asset_source_line` FROM `ckd_cnslt_par`.`asset_data` a, `ckd_cnslt_par`.`asset_data_source_map` b WHERE a.`blacklisted` = 0 AND a.`aaia_brand_name` = b.`aaia_brand_name` AND a.`product_id` = '3642145' AND a.`codeid` LIKE 'P%' AND a.`codeid` != 'PDB' AND -- a.`codeid` NOT LIKE 'P04' AND a.`filename` != '' AND a.`filename` != '#N/A' -- DISABLE: -- AND 1=0 -- AND a.`part_num` = '82-1197' ORDER BY (CASE WHEN a.`codeid` = 'P04' THEN 0 ELSE 1 END) ASC, a.`codeid` ASC, a.`filename` ASC

[TEP STOP]