Database error: Invalid SQL: SELECT DISTINCT MMake.ID,Logo,LogoThumbnail,LogoDescription,MMake.MMake_ AS MMake,Country, COUNT(DISTINCT IF(ForSale.ID ,ForSale.ID,NULL)) AS ModelsForSale, COUNT(DISTINCT IF(Models.ID ,Models.ID,NULL)) AS ModelsInCatalog, COUNT(DISTINCT IF(Models.ID ,Models.ID,NULL)) AS PrototypesInCatalog FROM MMake LEFT JOIN MModels ON MModels.MMake_ID=MMake.ID LEFT JOIN Models ON Models.MModel_ID=MModels.ID LEFT JOIN ForSale ON ForSale.Model_ID=Models.ID LEFT JOIN Logos ON MMake.Logo_ID=Logos.ID LEFT JOIN Countries ON MMake.Country_ID=Countries.ID LEFT JOIN Manufacturers ON Models.Manufacturer_ID=Manufacturers.ID GROUP BY MMake.ID HAVING ModelsForSale!=0 OR ModelsInCatalog!=0 OR PrototypesInCatalog!=0
MySQL Error: 1054 (Unknown column 'MMake.MMake_' in 'field list')
Session halted.
|