Fatal error: Uncaught Exception: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT p.product_id, p.type, p.sku, p.quantity, p.multiple, p.image, p.manufacturer_id, p.price, p.tax_class_id, p.reco, p.minimum, pd.name, p.sort_order,
p.expire_of_new,
(SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT text FROM product_attribute pa WHERE pa.product_id = p.product_id AND pa.attribute_id = 51 AND pa.language_id = '1') AS attr,
(SELECT price FROM 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,
(SELECT loyalty FROM customer_group cg WHERE cg.customer_group_id = '1' LIMIT 1) AS loyalty
FROM product p
LEFT JOIN ocfilter_option_value_to_product v2p ON (p.product_id = v2p.product_id) in /var/www/dev2.luxury-farfor.su/system/library/db/mysqli.php on line 61