Displaying 1 to 5 (of 5 products)
1146 - Table 'stockw7_osc.products_to_categories' doesn't exist
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` = '1812147' AND
-- a.`ship_cost` > 0 AND
b.`cfg_name` = 'FedexStaticPriceIncreaseSet_OSC' AND
c.`cfg_name` = 'FedexPassedDiscountPctSet_OSC'
LIMIT
1
[TEP STOP]