26/10/2019
[Confirmed]

Terminal V

20 000
Indoor
Single Day Event
Terminal V returns in 2019 for The Reckoning. Expect immense production, the worlds electronic leading acts themed new stages and a brand new additional10000 capacity space, new to Terminal V, The Hangar. This is just the beginning….

Ticket Sale

Official Tickets - Festicket

Accommodation Map

United Kingdom

Electronic Festivals is providing you with hotels and Airbnbs at the lowest prices available online.
Book your stay for Terminal V from the map below!

Youtube Video

PATRICK TOPPING essential festival set at Terminal V



According to your user settings, this Report will load a maximum of: 15 datasets.
Currently logged in user:
Amount on the account:
Verbindung zur Datenbank d02317b1 aufgebaut

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()Verbindung zur Datenbank d02317b1 aufgebaut
SQL1:SELECT a.fte_ef_id, i.tif_ft_slug, i.tif_ft_url, i.tif_ft_logo, n.title FROM ab_tmp_import_festicket i LEFT JOIN ab_festicket_events a ON a.fte_ft_id = i.tif_ft_id LEFT JOIN drupal_field_data_field_festicket_shop ON a.fte_ef_id = drupal_field_data_field_festicket_shop.entity_id LEFT JOIN drupal_node n ON (a.fte_ef_id = n.nid AND 'festivals' = n.type) WHERE i.tif_ft_updflag = 'I' AND i.tif_ft_start_date >= NOW() AND i.tif_ft_status = 'purchasable' AND drupal_field_data_field_festicket_shop.field_festicket_shop_value IS NULL ORDER BY a.fte_ef_id,i.tif_ft_slug ASC LIMIT 20

SQL2:SELECT DISTINCT a.fte_ef_id, i.tif_ft_slug, i.tif_ft_url, i.tif_ft_logo, n.title FROM ab_tmp_import_festicket i LEFT JOIN ab_festicket_events a ON a.fte_ft_id = i.tif_ft_id LEFT JOIN drupal_field_data_field_festicket_shop ON a.fte_ef_id = drupal_field_data_field_festicket_shop.entity_id LEFT JOIN drupal_node n ON (a.fte_ef_id = n.nid AND 'festivals' = n.type) LEFT JOIN (SELECT drupal_field_data_field_festival_id.field_festival_id_target_id as t_ef_id FROM drupal_field_data_field_festival_id INNER JOIN drupal_field_data_field_ticket_company ON (drupal_field_data_field_festival_id.entity_id = drupal_field_data_field_ticket_company.entity_id AND drupal_field_data_field_ticket_company.entity_type = 'node' AND drupal_field_data_field_ticket_company.bundle = 'tickets' AND drupal_field_data_field_ticket_company.field_ticket_company_value='festicket') WHERE drupal_field_data_field_festival_id.entity_type = 'node' AND drupal_field_data_field_festival_id.bundle = 'tickets' ) AS inner_s ON a.fte_ef_id=inner_s.t_ef_id WHERE i.tif_ft_updflag = 'I' AND i.tif_ft_start_date >= NOW() AND i.tif_ft_status = 'purchasable' AND drupal_field_data_field_festicket_shop.field_festicket_shop_value IS NOT NULL AND t_ef_id IS NULL ORDER BY a.fte_ef_id,i.tif_ft_slug ASC LIMIT 20


Festival id. 68665 Slug:no-sleep-festival-2019 Url:https://www.festicket.com/festivals/no-sleep-festival/2019/shop/ Title:No Sleep Festival Logo:https://media.resources.festicket.com/www/photos/5399-logo.jpgTitle: No Sleep Festival Nach Bereinigung:No Sleep Festival
ich bin bei festival:68665 Slug:no-sleep-festival-2019
TICKET NODE HAS BEEN CREATED FOR FESTIVAL: 68665