2002 Subaru Forester: Engine Cylinder Head Bolt Set
Displaying 1 to 4 (of 4 products)
SELECT a.`product_weight`, (CASE -- FREE SHIPPING BY SHIP METHOD WHEN a.`ship_method` IN ('free-ground') THEN 0.00 -- FREE SHIPPING BY PART TYPE WHEN e.`product_type_id` IS NOT NULL AND e.`product_type` != '' AND e.`product_type` IN ('sdfwerjsdflsdfsfNOTENABLEDsdfsdfsdf') THEN 0.00 -- FREE SHIPPING BY CATEGORY NAME WHEN a.`product_id` IN ( SELECT f.`products_id` FROM `stockw7_osc`.`products_to_categories` f WHERE f.`categories_id` IN ( SELECT g.`categories_id` FROM `stockw7_osc`.`categories_description` g WHERE g.`categories_name` IN ('sdfwerjsdflsdfsfNOTENABLEDsdfsdfsdf') ) ) THEN 0.00 -- FEDEX GROUND & USPS FIRST CLASS WHEN a.`ship_method` IN ('fedex-ground', 'usps-firstclass') THEN ROUND(((a.`ship_cost` * (1 - (c.`cfg_value` * .01))) + b.`cfg_value`), 2) -- NOT APPLICABLE ELSE -1 END) as 'shipping_price', a.`ship_method` FROM ( `ckd_products_data`.`product_weights` a, `ckd_products_data`.`ship_model_config` b, `ckd_products_data`.`ship_model_config` c ) -- FREE SHIPPING BY PART TYPE LEFT JOIN `ckd_products_data`.`product_type_relations` d ON a.`product_id` = d.`product_id` LEFT JOIN `ckd_products_data`.`product_types` e ON d.`product_type_id` = e.`product_type_id` WHERE a.`product_id` = '333885' AND -- a.`ship_cost` > 0 AND b.`cfg_name` = 'FedexStaticPriceIncreaseSet_OSC' AND c.`cfg_name` = 'FedexPassedDiscountPctSet_OSC' LIMIT 1
[TEP STOP]