Brands Vehicles
Lowest Prices
Free Returns
Online Since 2009
Shopping for

1997 Chevrolet C2500 Suburban

X

ACDelco 15-4615 A/C Compressor Clutch Pulley
for 1997 Chevrolet C2500 Suburban

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` = '320631' 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]