Notice: Undefined variable: partNumberClause in /var/cache/backups/cse/php-cse/icon.php on line 501
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;