Paul Kalkbrenner

Ranking Over All29
Genre Ranking17
Points120

Paul Kalkbrenner has currently no upcoming Dates.

Social Media

useful links



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()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