HS GDA N° 24 - LES FUSILS MAUSER TOME 2 1918-1945

HS GDA N° 24 - LES FUSILS MAUSER TOME 2 1918-1945

14.60€
ttc
Par L. Guillou. 80 p illustrées en couleur, 21 x 30 cm, broché.
Réf. 01AAL0359

* Les G98 modernisés
* Les carabines K98b et K98k
* Les K98k de snipers
* Le G40k
* Les Mauser étrangers
* Les Mauser du Volkssturm
* Les marquages ; fabrication ; et accessoires

Ce produit a été ajouté à notre catalogue le lundi 02 octobre, 2017.

Partager par Mail Partager sur Facebook Partager sur Twitter
Donner un avis

1032 - Can't find record in 'products_description'

SELECT p.products_id, pd.products_name, MATCH (pd.products_name, pd.products_description) AGAINST ('broché' IN BOOLEAN MODE) as 'score' FROM products_description pd, products p ,products_to_categories p2c WHERE pd.products_id = p.products_id AND p2c.products_id = p.products_id AND MATCH (pd.products_name, pd.products_description) AGAINST ('broché' IN BOOLEAN MODE) AND (p2c.categories_id= '159' or p2c.categories_id= '100014' or p2c.categories_id= '100148' or p2c.categories_id= '100223' or p2c.categories_id= '100239' or p2c.categories_id= '100202' or p2c.categories_id= '100165' or p2c.categories_id= '100119' or p2c.categories_id= '100092' or p2c.categories_id= '100054' or p2c.categories_id= '100029' or p2c.categories_id= '296' or p2c.categories_id= '273' or p2c.categories_id= '193' or p2c.categories_id= '192' or p2c.categories_id= '194' or p2c.categories_id= '195' or p2c.categories_id= '197' or p2c.categories_id= '198' or p2c.categories_id= '199' or p2c.categories_id= '200' or p2c.categories_id= '201' or p2c.categories_id= '202' or p2c.categories_id= '203' or p2c.categories_id= '100149' or p2c.categories_id= '100172' or p2c.categories_id= '100185' or p2c.categories_id= '158') AND p.products_status >0 AND pd.language_id = '1' ORDER BY 'score' DESC LIMIT 100;

[TEP STOP]