Error: Subquery returns more than 1 row
Error No: 1242
SELECT * FROM `oc_shop_subscription` WHERE `store_id` = (SELECT `store_id` FROM `oc_product` LEFT JOIN oc_product_to_store USING (product_id) WHERE `product_id`='4460' AND `store_id` != 0) AND `subscription_status_id` = '1' ORDER BY `subscription_id` DESC LIMIT 0,1
: in /home/u707186820/domains/sadua.shop/public_html/system/library/db/mysqli.php on line 78