Error: Query failed, SQL error was 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 'and BuildNumber = 0 group by Parts.ID limit 20' at line 6 On this SQL: select StatusID, Parts.ID as PartID, group_concat(Alias) as ManufacturerAliases, Name as Manufacturer, Quality from Parts join Manufacturers on Parts.ManufacturerID = Manufacturers.ID join ManufacturerAliases on Parts.ManufacturerID = ManufacturerAliases.ManufacturerID join QualityEstimate on Parts.ID = QualityEstimate.ID where and BuildNumber = 0 group by Parts.ID limit 20;