VARUNNA - Pietra di Legno CD (Lim300)

Limited edition of strictly 300 copies in 3-panel Eko Digipack sealed in cellophane !

Info: Brand new, second album by the Italian Neofolk act! Pietra e Legno is a wonderfull mosaique of modern and ancient times. The powerful ballads and the crooner mood make this a masterpiece of Folk release! This is the best expression of Italian Folk today, walking in the footsteps of the great masters of Italian 60ies music. The last track ‘Una Vita’ features Lina Baby Doll (DEUTSCH NEPAL) ...


01. Betta
02. Pietra e Legno
03. Con Me
04. Caserme Rosse
05. Gli anni dorati
06. Italia
07. Praga
08. Una Vita

Genre: Neofolk, Acoustic, Military Pop, Neoclassic
Like: Darkwood , Forseti, Sonne Hagal, Of the Wand and the Moon, Fire & Ice, Sol Invictus

Status: Only 6. copies !
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 = '602420' and opa.orders_id = opb.orders_id and opb.products_id != '602420' 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