Database error: Invalid SQL: SELECT Models.ID, Picture, Thumbnail, CatalogNumber, Pictures.Description AS PictureDescription, TRIM(CONCAT(IF(ISNULL(MModelName_),' ',CONCAT(MMake_,IF(MModels.Needs_dash,'-',' '),MModelName_)),' ',Name_)) AS Description, Manufacturer, Manufacturers.User_ID AS Manuf_UID, Scale, DATE_FORMAT(Models.last_updated,'%m/%d/%Y') as LastUpdated, COUNT(ForSale.ID) AS N_ForSale FROM Models LEFT JOIN Pictures ON Models.DefaultPicture_ID=Pictures.ID LEFT JOIN Manufacturers ON Models.Manufacturer_ID=Manufacturers.ID LEFT JOIN Scales ON Models.Scale_ID=Scales.ID LEFT JOIN ForSale ON ForSale.Model_ID=Models.ID LEFT JOIN MModels ON Models.MModel_ID=MModels.ID LEFT JOIN MMake ON MModels.MMake_ID=MMake.ID WHERE 1 AND Purpose_ID='7' GROUP BY Models.ID
MySQL Error: 1054 (Unknown column 'MModelName_' in 'field list')
Session halted.