Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/a/agrotehnic/agrotehnic.com.ua/public_html/system/library/db/mysqli.php on line 18 Fatal error: Uncaught Exception: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *,m.mname as manufacturer, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' 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 FROM oc_product p LEFT JOIN (SELECT * FROM oc_product_description WHERE language_id = '1') pd ON p.product_id = pd.product_id LEFT JOIN (SELECT manufacturer_id,name as mname FROM oc_manufacturer) m ON p.manufacturer_id = m.manufacturer_id WHERE p.product_id IN (861,1739) in /home/a/agrotehnic/agrotehnic.com.ua/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home in /home/a/agrotehnic/agrotehnic.com.ua/public_html/system/library/db/mysqli.php on line 40