SELECT products.*
,vendors.VendorName AS VendorName
,vendors.VendorFriendlyName AS VendorFriendlyName
,vendors.Priority AS VendorPriority
,vendors.Active AS VendorActive
FROM products
LEFT JOIN vendors
ON VendorID = vendors.ID
WHERE products.ID = '' b.ID ''
LIMIT 1
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 'b.ID '' LIMIT 1' at line 9