LARP-armoury
LARP-armoury
LARP-armoury

You are here: » Home » Costumes » Headgear » G0386
Categories

Armour

Costumes
 Headgear
 Tunic/Shirt/Trousers
 Various
 Ladies
 Shoes

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
 
[G0386]

Jungfernkranz

Die schmückende Kopfbedeckung für die edle (unverheiratete) Dame.
Wattierter Kopfring aus edlem Baumwollsamt mit farblich passendem Schleier.
Durch einen vom Schleier verdeckten Gummizug am Hinterkopf universell für fast jeden Kopf passend.

Farben: Blau, Grün, Rot, Schwarz

Ausführung Lager Preis Menge  
Jungfernkranz blau sofort lieferbar  12,90 
Jungfernkranz grün sofort lieferbar  12,90 
Jungfernkranz rot sofort lieferbar  12,90 
Jungfernkranz schwarz sofort lieferbar  12,90 
alle Preise 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 = '1066' and opa.orders_id = opb.orders_id and opb.products_id != '1066' and opb.products_id = p.products_id and p.products_family != 'G0386' 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]