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