88.00€

STRYDWOLF - Collection BOX (Lim10)
[BigBox]

***perfect christmas gift***
Photo cartoon box size: 330x290x130mm is limited to ony 10 hand-numbered copies !
Included:
- 2x Sticker
- T-Shirt Logo grey
- T-Shirt breast black
- CD: Ljocht ! 2009
- CD: Dunkle Wälder 2011
- CD: Aus alter Zeit 2012
- CDr: Leaves of Grass 2011
- CDr: Bonus exclusive 2012
- 3x Photo + 1x high colore Insert
- Postcard
- Original song sheet + signed by Willem Witte

*** only 1. box every customer ! ***

Tracklist:

Bonus CD

01. Zwarte lage blaket
02. Ontwaaki !
03. Sag mir wo du stehst
04. Dressed in black uniforms


Genre: Neofolk, Acoustic, Military Pop, Neoclassic
Like: Forseti, Death in june, Darkwood, Sonne Hagal, Of the Wand..., Sol Invictus

Status: only 3. copies available !!

SOUND FILE:
- http://www.youtube.com/watch?v=HeoFL_G4gek
- http://www.youtube.com/watch?v=aoAySpUGv2g
- http://www.youtube.com/watch?v=phaijLsHW48
- http://www.youtube.com/watch?v=aoAySpUGv2g
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'usr_ud04_237_5.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 = '601393' and opa.orders_id = opb.orders_id and opb.products_id != '601393' 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]