MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by bcs_product_vendor.priority' at line 1, occured in query: "SELECT bwcore_member.username, bwcore_member.avatar_url, bwcore_member.userid FROM bcs_product_vendor LEFT JOIN bwcore_member ON bcs_product_vendor.userid_vendor = bwcore_member.userid WHERE product_id = order by bcs_product_vendor.priority".