Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /hermes/bosnaweb08a/b2675/ipw.polymerclayprojects/public_html/store/system/library/db/mysqli.php on line 18Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM ocproduct_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM ocproduct_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM ocproduct_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM ocstock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM ocweight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oclength_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM ocreview r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM ocreview r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM ocproduct p LEFT JOIN ocproduct_description pd ON (p.product_id = pd.product_id) LEFT JOIN ocproduct_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN ocmanufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '89' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /hermes/bosnaweb08a/b2675/ipw.polymerclayprojects/public_html/store/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /hermes/bosnaweb08a/b2675/ipw.polymerclayprojects/public_html/store/catalog/model/catalog/product.php on line 10
SILBERSCHNITT® Carbide Glass Cutter

Additional Savings

Additional 30% OFF. Use code JOURNAL30 at checkout.

Unlimited Blocks

There's no limit to how many blocks you can create.

Carbide cutting wheel 120°  for thin and/or hard glass - little cutting pressure required

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam iaculis egestas laoreet. Etiam faucibus massa sed risus lacinia in vulputate dolor imperdiet. Curabitur pharetra, purus a commodo dignissim, sapien nulla tempus nisi, et varius nulla urna at arcu.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam iaculis egestas laoreet. Etiam faucibus massa sed risus lacinia in vulputate dolor imperdiet. Curabitur pharetra, purus a commodo dignissim, sapien nulla tempus nisi, et varius nulla urna at arcuLorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam iaculis egestas laoreet. Etiam faucibus massa sed risus lacinia in vulputate dolor imperdiet. Curabitur pharetra, purus a commodo dignissim, sapien nulla tempus nisi, et varius nulla urna at arcu. 

SILBERSCHNITT® Carbide Glass Cutter

Free Shipping

This product qualifies for free air shipping.

  • Views: 979
  • Product Code: SILBERSCHNITTĀ® Carbide Glass Cutter
  • Availability: 1
0 Product(s) Sold
  • $20.00