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.
+64 9 525 4575 Product Compare (0)

Griffiths Equipment

Ajax Filter

Cable
CABLE BATTERY MARINE 2B&S 30M
CABLE BATTERY MARINE 2B&S 30M
[ 5802M-30BK ]
CABLE BATTERY MARINE 2B&S 30M
[ 5802M-30BK ]

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

BATTERY CABLE MARINE 2B&S 30M
BATTERY CABLE MARINE 2B&S 30M
[ 5802M-30RD ]
BATTERY CABLE MARINE 2B&S 30M
[ 5802M-30RD ]

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

BATTERY CABLE MARINE 8B&S 30M
BATTERY CABLE MARINE 8B&S 30M
[ 5808M-30BK ]
BATTERY CABLE MARINE 8B&S 30M
[ 5808M-30BK ]

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

BATTERY CABLE MARINE 8B&S 30M
BATTERY CABLE MARINE 8B&S 30M
[ 5808M-30RD ]
BATTERY CABLE MARINE 8B&S 30M
[ 5808M-30RD ]

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

SINGLE CORE MARINE 2MM 30M BLU
SINGLE CORE MARINE 2MM 30M BLU
[ 5812M-30BE ]
SINGLE CORE MARINE 2MM 30M BLU
[ 5812M-30BE ]

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

CABLE SINGLE MARINE 2MM BLACK
CABLE SINGLE MARINE 2MM BLACK
[ 5812M-30BK ]
CABLE SINGLE MARINE 2MM BLACK
[ 5812M-30BK ]

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

SINGLE CORE MARINE 2MM 30M BRN
SINGLE CORE MARINE 2MM 30M BRN
[ 5812M-30BN ]
SINGLE CORE MARINE 2MM 30M BRN
[ 5812M-30BN ]

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

SINGLE CORE MARINE 2MM 30M GRN
SINGLE CORE MARINE 2MM 30M GRN
[ 5812M-30GN ]
SINGLE CORE MARINE 2MM 30M GRN
[ 5812M-30GN ]

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

CABLE SINGLE MARINE 2MM RED 30
CABLE SINGLE MARINE 2MM RED 30
[ 5812M-30RD ]
CABLE SINGLE MARINE 2MM RED 30
[ 5812M-30RD ]

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

SINGLE CORE MARINE 2MM 30M WHT
SINGLE CORE MARINE 2MM 30M WHT
[ 5812M-30WE ]
SINGLE CORE MARINE 2MM 30M WHT
[ 5812M-30WE ]

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

CABLE SINGLE MARINE 2MM YELLOW
CABLE SINGLE MARINE 2MM YELLOW
[ 5812M-30YW ]
CABLE SINGLE MARINE 2MM YELLOW
[ 5812M-30YW ]

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

CABLE SINGLE MARINE 4MM BLACK
CABLE SINGLE MARINE 4MM BLACK
[ 5814M-30BK ]
CABLE SINGLE MARINE 4MM BLACK
[ 5814M-30BK ]

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

CABLE SINGLE MARINE 4MM RED 30
CABLE SINGLE MARINE 4MM RED 30
[ 5814M-30RD ]
CABLE SINGLE MARINE 4MM RED 30
[ 5814M-30RD ]

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

CABLE SINGLE MARINE 6MM BLACK
CABLE SINGLE MARINE 6MM BLACK
[ 5816M-30BK ]
CABLE SINGLE MARINE 6MM BLACK
[ 5816M-30BK ]

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

CABLE SINGLE MARINE 6MM RED 30
CABLE SINGLE MARINE 6MM RED 30
[ 5816M-30RD ]
CABLE SINGLE MARINE 6MM RED 30
[ 5816M-30RD ]

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

MARINE TWIN CORE 4MM 30M RD/BK
MARINE TWIN CORE 4MM 30M RD/BK
[ 5824M-30TW ]
MARINE TWIN CORE 4MM 30M RD/BK
[ 5824M-30TW ]

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

CABLE TWIN CORE MARINE 6MM
CABLE TWIN CORE MARINE 6MM
[ 5826M-30TW ]
CABLE TWIN CORE MARINE 6MM
[ 5826M-30TW ]

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

CABLE 3 CORE MARINE 4MM 30M
CABLE 3 CORE MARINE 4MM 30M
[ 5834M-30WYB ]
CABLE 3 CORE MARINE 4MM 30M
[ 5834M-30WYB ]

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

TRAILER 5 CORE MARINE 2MM 30M
TRAILER 5 CORE MARINE 2MM 30M
[ 5852M-30ETC ]
TRAILER 5 CORE MARINE 2MM 30M
[ 5852M-30ETC ]

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

TRAILER 5 CORE MARINE 3MM 30M
TRAILER 5 CORE MARINE 3MM 30M
[ 5853M-30TC ]
TRAILER 5 CORE MARINE 3MM 30M
[ 5853M-30TC ]

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