CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_temporary` (PRIMARY KEY (`product_id`)) SELECT dcp.price, afv2.value AS PriceLevelXPrice, p.product_id, p.manufacturer_id, IF(p.quantity > 0, 6, p.stock_status_id) as stock_status_id, MIN(pd2.price) as discount, MIN(ps.price) as special, tax_p.sum_rate as tax_precent, tax_f.sum_rate as tax_fixed, AVG(rating) AS rating FROM oc_product p LEFT JOIN `oc_af_tax_fixed` tax_f ON p.tax_class_id = tax_f.tax_class_id LEFT JOIN `oc_af_tax_percent` tax_p ON p.tax_class_id = tax_p.tax_class_id INNER JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) INNER JOIN oc_category_path cp ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product_discount pd2 ON (pd2.product_id = p.product_id AND pd2.quantity = '1' AND (pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()) AND pd2.customer_group_id = '1') LEFT JOIN oc_product_special ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') LEFT JOIN oc_review r1 ON (r1.product_id = p.product_id AND r1.status = 1) INNER JOIN oc_product_to_store AS p2s ON p2s.product_id = p.product_id AND p2s.store_id = '0' LEFT JOIN dateline_customer_price dcp ON (p.product_id=dcp.product_id AND dcp.quantity=1 AND dcp.customer_id=0)LEFT JOIN oc_product_additional_field_value AS afv2 ON (p.product_id=afv2.product_id)LEFT JOIN oc_mpoints_additional_field_description AS afd2 ON (afv2.additional_field_id=afd2.additional_field_id AND afd2.name='PriceLevel1') WHERE p.date_available <= NOW() AND p.status = 1 AND cp.path_id = '559' GROUP BY p.product_id Cable
Griffiths Equipment
You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.
Cable

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features B..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features R..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features B..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features R..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features B..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features B..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features B..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features G..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features R..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features W..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features Y..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features B..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features R..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features B..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features R..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features R..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features R..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features W..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features E..

NARVA The Narva cable uses oxygen free copper and RoHS compliant polyvinyl-chloride. Features 5..