Manami

Ranking Over All910
Genre Ranking246
Points28

Manami 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()
NODE HAS BEEN DELETED: 202691.
NODE HAS BEEN DELETED: 202692.
NODE HAS BEEN DELETED: 202693.
NODE HAS BEEN DELETED: 202694.