PANTSER FABRIEK - Stahlzeit CDr 2nd (Lim100)

CDr 12tracks, second edit in plastic sleeve only 100 hand-numbered copies.
Info: First Demo album from PANSER FABRIEK from Den Haag (netherlands) - TIP !


01-Stahl, Meine Wahl
02-Come Closer
03-EBM Girl
04-In Your Face
06-Schneller, Härter, Stärker
07-Schau Mal!
08-Kopf Nach Oben
09-Küsse Mich Nicht
10-I Can See It In Your Eyes
11-Won't Obey (Version II)
12-No More Work (Bonus)

Genre: EBM, Oldschool, Elektro
Like: Nitzer Ebb, Pouppe Fabriekk, Jäger 90, Sturm Cafe, Frontal, NordarR

- https://www.youtube.com/watch?v=VcsB9_XzAO8&feature=youtu.be
- https://www.youtube.com/watch?v=VmVsRAEei-M
- https://www.youtube.com/watch?v=AXkmw-ObNpI
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 = '602394' and opa.orders_id = opb.orders_id and opb.products_id != '602394' 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