SCALE 43
Illustrated Online Encyclopedia and Shop
Home Search Encyclopedia Prototypes Shop Manufacturers News Contact us My Cart
| About Us | My Cart
E-Mail:
Password:
Register
Forgot password ?
Shop
Encyclopedia
Prototypes
Browse by:
- Make/model
- Manufacturer
- Scales
- Category
- Body type
- Drive type
- Purpose
My Collection
Links
Contact us
Quick search:


Advanced search
Register and Subscribe to Newsletters:
Name:
E-Mail:
Russian Scale Models
Military DieCast
SCALE 43
MBMC Russia
Minigrad Models
GM Art
SarLab
Minigrad
XCM
RO Master

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.