LARP-armoury
LARP-armoury
LARP-armoury

You are here: » Home » Armour » Mail Armour » K0170
Categories

Armour
 Helmets
 Plate Armour
 Mail Armour
 Leather-Armour

Costumes

LARP-Weapons

Masks & Make-up

Jewelry

Books/Media

Do-it-Yourself

Various

 
Quick Find
 
Information
FAQ
Shipping Costs
Shipping Times
Payment Information
Privacy Notice
Conditions
Contact Us
Legal Notice
 
Languages
Deutsch English
 
Login Here
E-Mail address:

Password:
 

Not registered yet?
Password forgotten?
 
our Recommendation
www.larp-bogenbau.de - Handgefertigte LARP-Bögen und Bogenbaukurse für Kenner und Invividualisten
 
[K0170]

Kettenhemd lang brünniert

Langes Import-Kettenhemd mit aussergewöhnlich gutem Preis/-Qualitätssverhältnis mit brünnierten (geschwärzten) Kettenringen mit langen Armen..
Ringe: ca. 9 mm innen/ 1,6 mm stark
Gewicht: ca. 12 kg.
Umfang bis 115 cm

 Lagerstatus:  sofort lieferbar  149,00  Quantity:
inkl. MwSt zzgl. Versandkosten
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db196870x2004219.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '362' and opa.orders_id = opb.orders_id and opb.products_id != '362' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and (p.products_status = '1' or p.v_order > '0') and p.v_order != '99' group by p.products_id order by o.date_purchased desc limit 3

[TEP STOP]