Russian Collectibles, Antiques and Memorabilia - home of WWMilitary.com
WISH LIST lll SHIPPING POLICY lll PRIVACY POLICY lll RETURN POLICY lllPAYMENT POLICY
 
ANTIQUES
BOOKS AND REFERENCE->
EDGED WEAPONS
GERMAN MILITARIA->
IMPERIAL RUSSIA->
JAPANESE MILITARIA
SOVIET BADGES->
SOVIET MILITARIA->
SOVIET ORDERS & MEDALS->
WORLD MILITARIA->
View All Products
Russian Book "Badges of Russia, Volume I" by S Patrikeev and A B
Russian Book "Badges of Russia, Volume I" by S Patrikeev and A B
$219.00
 
Advanced Search
1 x Book Badges of Russia, Volume II, S Patrikeev & A Boynovich, Mos
1 x 19th Century Russian Imperial Naval Dagger
1 x Soviet International Soldier - Afghanistan Medal
1 x Sportsmanship Military Badge, 3rd cl, 1950 type
1 x Engineering Institute graduate, circa 1970s
1 x Medal for Reclaiming of Non-Black Soil Region
1 x Excellent Serviceman of MOOP Internal Army
1 x Arts and Human Sciences Institute graduate badge
1 x Soviet Medal for Valiant Labor
1 x Soviet Military Sportsmanship, 1st cl, 1950 type
1 x 300th Anniversary of the Reunification of Russia and Ukraine
1 x Kuibyshev Hydroelectric Complex Construction Badge
$2,141.00
All Products
ERROR:Please click here to restart site

1054 - Unknown column 'p.products_id' in 'on clause'

SELECT s.specials_new_products_price, p.products_id, p.products_model, p.products_price, pd.products_name FROM products p, products_description pd LEFT JOIN specials s ON p.products_id=s.products_id WHERE p.products_id = pd.products_id AND p.products_status = 1 AND pd.language_id = 1 ORDER BY pd.products_name

[TEP STOP]

Product Name Model Price