House // Deep House // Big Room // EDM
30/06/2018
[Confirmed]

Holi Festival of Colours - Zurich

5 000
Outdoor
Single Day Event
It all started in Berlin a large number of people came together in Berlin for the first ever Holi Festival Of Colours in Europe and helped create an indescribable atmosphere on an unforgetable day. The Facebook community began to grow, the media interest was enormous and the spirit of the Festival was carried through Germany. This is how the Holi Festival of Colours established itself in the festival scene and marks the origin of the colour festivals in Germany and Europe.

Get Tickets for the Holi Festival

No Current Lineup

The current lineup is not out yet.

These are the acts that played on former editions of this festival.

June-2018
Dj Hype, Möwe, Honka, James Hype, Nicolas Haegl, Miss Ghyss, Johnny Roxx
July-2017
Animal Trainer, Moguai, Sola Plexus

Accommodation Map

Switzerland

Electronic Festivals is providing you with hotels and Airbnbs at the lowest prices available online.
Book your stay for Holi Festival of Colours - Zurich from the map below!

Youtube Video

Holi Festival of Colours Leverkusen 2013

FESTIVAL LINKS

URL Event: 
https://www.holifestival.com/ch/de/
Facebook Event: 
https://www.facebook.com/HoliFestivalOfColoursZuerich
Youtube Event Channel: 
https://www.youtube.com/user/HoliFestivalOfColors

Top 100 Lists


This PHP code updates the ticket nodes
SELECT a.zae_ber, a.zae_ef_id, a.zae_za_id, i.taz2_name, i.taz2_description, i.taz2_url, i.taz2_image, i.taz2_price, i.taz2_currencycode, drupal_field_data_field_ticket_id.entity_id FROM ab_ticket_events a INNER JOIN ab_tmp_abgleich_tickets_st2 i ON a.zae_za_id = i.taz2_id INNER JOIN drupal_field_data_field_ticket_id ON a.zae_za_id = drupal_field_data_field_ticket_id.field_ticket_id_value INNER JOIN drupal_field_data_field_ticket_price ON drupal_field_data_field_ticket_id.entity_id = drupal_field_data_field_ticket_price.entity_id WHERE a.zae_ignore != 1 AND i.taz2_price <> drupal_field_data_field_ticket_price.field_ticket_price_amount LIMIT 500

SELECT drupal_field_data_field_ticket_id.entity_id FROM drupal_field_data_field_ticket_id LEFT JOIN ab_ticket_events ON drupal_field_data_field_ticket_id.field_ticket_id_value = ab_ticket_events.zae_za_id LEFT JOIN ab_tmp_abgleich_tickets_st2 ON drupal_field_data_field_ticket_id.field_ticket_id_value = ab_tmp_abgleich_tickets_st2.taz2_id WHERE ab_ticket_events.zae_za_id IS NOT NULL AND ab_tmp_abgleich_tickets_st2.taz2_id IS NULL LIMIT 500

SELECT drupal_field_data_field_ticket_id.entity_id, maxDate.date2 FROM drupal_field_data_field_ticket_id LEFT JOIN (SELECT drupal_field_data_field_festival_id.entity_id as ticket_id, MAX(drupal_field_data_field_date.field_date_value2) as date2 FROM drupal_field_data_field_festival_id LEFT JOIN drupal_field_data_field_date ON (drupal_field_data_field_festival_id.field_festival_id_target_id = drupal_field_data_field_date.entity_id AND drupal_field_data_field_date.bundle='festivals') WHERE drupal_field_data_field_festival_id.bundle='tickets' GROUP BY ticket_id) as maxDate ON maxDate.ticket_id=drupal_field_data_field_ticket_id.entity_id WHERE maxDate.date2 < NOW()