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 = '466' GROUP BY p.product_id Amp Kits & Cables
Griffiths Equipment
You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.
Amp Kits & Cables

AERPRO The RCA lead 2 male to 3.5MM stereo is suitable for connection between your computer, MP3, ..

AERPRO The AP940 is made using ultra-pure oxygen-free copper (OFC) wire wrapped in a flexible PVC ..

AERPRO The AP941 is made using ultra-pure oxygen-free copper (OFC) wire wrapped in a flexible PVC ..

AERPRO The AP942 is made using ultra-pure oxygen-free copper (OFC) wire wrapped in a flexible PVC ..

AERPRO The AP940/20 is made using ultra-pure oxygen-free copper (OFC) wire wrapped in a flexible P..

AERPRO The AP951 is made using ultra-pure oxygen-free copper (OFC) wire wrapped in a flexible PVC ..

AERPRO BASSIX power cables combine quality components to ensure you receive great performance from..

AERPRO These amplifier kits can handle serious power and include high quality components to enhanc..

AERPRO These amplifier kits can handle serious power and include high quality components to enhanc..

AERPRO BASSIX wiring kits offer great value for money and are packed full of installation essentia..

AERPRO BASSIX power cables combine quality components to ensure you receive great performance from..

AERPRO BASSIX power cables combine quality components to ensure you receive great performance from..

AERPRO BASSIX power cables combine quality components to ensure you receive great performance from..

AERPRO This power cable combines high quality components to ensure you receive blistering performa..

AERPRO MAXCOR power cables combine high quality components to ensure you receive blistering perfor..

AERPRO All MAXCOR RCA's are double shielded and twisted pair to minimise the risk of signal interf..

AERPRO MAXCOR RCA's are made from high quality components to ensure you receive blistering perform..

AERPRO MAXCOR RCA?s are made from high quality components to ensure you receive blistering perform..

AERPRO The RCA's are made from high quality components to ensure you receive blistering performanc..

AERPRO The RCA's are made from high quality components to ensure you receive blistering performanc..

AERPRO All MAXCOR RCA's are double shielded and twisted pair to minimise the risk of signal interf..