Are you looking to sell your collection or have an inventory of models you want to get rid of? Please contact us, and our representatives in the US or Russia will contact you. We buy collections, used models, and unsold inventories.



Database error: Invalid SQL: SELECT Models.ID, Picture, Thumbnail, CatalogNumber, Pictures.Description AS PictureDescription, TRIM(CONCAT(IF(ISNULL(MModelName_en),' ',CONCAT(MMake_en,IF(MModels.Needs_dash,'-',' '),MModelName_en)),' ',Name_en)) AS Description, Manufacturer, Manufacturers.User_ID AS Manuf_UID, Scale, Price, ForSale.Notes, DATE_FORMAT(ForSale.last_updated,'%m/%d/%Y') AS LastUpdated, ForSale.ID AS FID FROM ForSale LEFT JOIN Models ON ForSale.Model_ID=Models.ID 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 Locations ON ForSale.Location_ID=Locations.ID LEFT JOIN Countries ON Locations.Country_ID=Countries.ID LEFT JOIN MModels ON Models.MModel_ID=MModels.ID LEFT JOIN MMake ON MModels.MMake_ID=MMake.ID WHERE 1 AND (Manufacturers.Country_ID in ('176', '21', '222', '109', '104', '122', '116')) AND Models.Prototype='0' GROUP BY ForSale.ID ORDER BY ForSale.last_updated DESC LIMIT -4,5
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-4,5' at line 1)
Session halted.