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 Models.Scale_ID='1' AND Models.Prototype='0' GROUP BY ForSale.ID ORDER BY ForSale.last_updated DESC LIMIT 1,SLIDESHOW_THUBMS
MySQL Error: 1327 (Undeclared variable: SLIDESHOW_THUBMS)
Session halted.