select a.id,a.name,a.price,a.stock,a.stint,a.brand,b.property_1,b.property_2,b.property_3,b.property_4,b.property_5,b.property_7,b.property_8,b.delivery_time from mb_product AS a JOIN mb_defind_1 AS b ON a.id=b.product_id where a.name ='' and b.property_2 ='' and a.id <> '0' and a.status=1 and a.is_shelves=1 and a.member_id= LIMIT 0,8You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,8' at line 1