pro CDr 12 track (75min) comes in two different artwork, each 50 copies = total limited & hand-numbered to 100 copies.

Info: GENOCIDE LOLITA the champions from the United States of the power electronic is back with six new gigantic and breathtaking songs.
TSIDMZ (Thule Sehnsucht In Der MaschinenZeit) is an Italian post-atomic/electro-martial and Industrial project with numerous influences from various genres within the field of Electronic Music.

- This unusual split CD is for all lovers of power electronic noise and martial recommended -


01. Genocide Lolita- Prison Planet 2013
02. Genocide Lolita- Kali Gaga
03. Genocide Lolita- Indignationalist
04. Genocide Lolita- Mind Fucked
05. Genocide Lolita- Revenge
06. Genocide Lolita- Solved Nothing
07. Genocide Lolita- Prison Planet 2013 (bonus Video edit)
08.TSIDMZ - Ahmadinejad speech
09. TSIDMZ - The Fourth Political Theory (Propaganda mix. Voice by A. Dugin)
10. TSIDMZ - Sweet Candy Bullets (TSIDMZ remix. Original song written by Chemical Waves)
11. TSIDMZ - Abandoned Life (feat Kenji Siratori)
12. TSIDMZ - Revolvere

Genre: Power Electronic, Martial Industrial
Like: Genocide Organ, Haus Arafna, Sektion B, Karjalan Sissit, Striider, BloodSoil

- https://soundcloud.com/skullline/genocide-lolita-prison-planet
- http://www.reverbnation.com/artist/artist_videos/2494662
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 = '601733' and opa.orders_id = opb.orders_id and opb.products_id != '601733' 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