Database error: Invalid SQL: create temporary table shop_product_tmp type = heap select sp.productid,min(sp.price) as price from merchant_shop_product sp,merchant_shop s where sp.subcategoryid=298 and sp.shopid=s.id and sp.enable=1 and sp.status=1 and sp.price<>0 and sp.productid<>0 and s.valid=1 and (s.expired_date >='2024-05-02 21:38:35' or sp.time>='2023-11-04 21:38:35') group by sp.productid order by sp.price desc
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'type = heap select sp.productid,min(sp.price) as price from merchant_shop_produc' at line 1)
Session halted.