Taban Miniatures Shop

Kategorien

Startseite » Katalog » EDEN » Scenery elements & bases » EDE-OBJ-M01 » Die Frische Quelle
[EDE-OBJ-M01]

6.00EUR

Für eine grössere Darstellung
klicken Sie auf das Bild.

Resin casted scenery element, depicting a tree carved as a primitive totem above a spring of pure (well for the wasteland dwellers at least) water.
It can be used as an objective marker for the generic Eden mission n°1 : the pure spring, or as a pagan Idol for the related Matriarchy mission
44mm tall, base diameter 40mm.

Original sculpt M. "Mohand "Ait Mehdi"

6.00EUR

Dieses Produkt haben wir am Dienstag, 20. April 2010 in unseren Katalog aufgenommen.

1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '278' and opa.orders_id = opb.orders_id and opb.products_id != '278' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]