Le Revers Sanglant - Feu CDr (Lim66)

Profi CDr limited to 66 hand-numbered copies !
Info: The winter 2004 marked the birth of the "Le Revers Sanglant"project. This is the third fultime album by skullLine :-) Created by Syphilis, the initial goal of the project, was to create a minimalist audio concept with cold and martial atmospheres. This new album "FEU" has matured to melodic military martial arts! For lovers of French music


01. Feu
02. Tout pour lart
03. Le choix
04. La mort
05. Vers le neant
06. Douleur finale
07. Le chateau de cendres
08. Une danse macabre
09. Ultime assaut

Genre: Dark Ambient , Martial Industrial
Like: Auswalht, Barbarossa Umtrunk, Das Brandopfer, Arditi, Stricta Doctrina, Le Silence des Ruines

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 = '602376' and opa.orders_id = opb.orders_id and opb.products_id != '602376' 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