Brands Vehicles
Lowest Prices
Free Returns
Online Since 2009
Shopping for

2012 GMC Yukon XL 2500

X

Mevotech GK6654 Steering Pitman Arm
for 2012 GMC Yukon XL 2500 6.0L V8 Flex OHV

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