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 URL DESC LIMIT 20
MySQL Error: 1054 (Unknown column 'URL' in 'order clause')
Session halted.