Shay Malt

Ranking Over All16.097
Genre Ranking3.416
Points5

Shay Malt has currently no upcoming Dates.

Social Media

useful links



This PHP code copies festival lineups that are in the past into a new node type

Connection was OK!
SELECT drupal_node.nid, drupal_node.title, festival.endpoints_entity_id, old_lineup2.field_date_value, drupal_field_data_field_lineup_tags.field_lineup_tags_tid, drupal_taxonomy_term_data.name, drupal_location.country, drupal_field_data_field_visitors.field_visitors_value FROM drupal_node INNER JOIN drupal_field_data_endpoints old_lineup ON drupal_node.nid = old_lineup.endpoints_entity_id INNER JOIN drupal_field_data_endpoints festival ON old_lineup.entity_id = festival.entity_id INNER JOIN drupal_field_data_field_date old_lineup2 ON drupal_node.nid = old_lineup2.entity_id INNER JOIN drupal_field_data_field_lineup_tags ON drupal_node.nid = drupal_field_data_field_lineup_tags.entity_id INNER JOIN drupal_taxonomy_term_data ON drupal_field_data_field_lineup_tags.field_lineup_tags_tid = drupal_taxonomy_term_data.tid INNER JOIN drupal_field_data_field_visitors ON drupal_field_data_field_visitors.entity_id = festival.endpoints_entity_id INNER JOIN drupal_field_data_field_location ON drupal_field_data_field_location.entity_id = festival.endpoints_entity_id INNER JOIN drupal_location ON drupal_location.lid = drupal_field_data_field_location.field_location_lid WHERE drupal_node.type = 'old_lineups' AND festival.bundle = 'festivals_only' AND old_lineup2.bundle = 'old_lineups' AND drupal_field_data_field_lineup_tags.bundle = 'old_lineups' AND drupal_field_data_field_visitors.bundle = 'festivals' AND drupal_field_data_field_location.bundle = 'festivals' AND old_lineup.endpoints_entity_id = drupal_node.nid AND festival.endpoints_r_index = '1' AND NOT EXISTS ( SELECT drupal_field_data_field_dj_id.field_dj_id_tid FROM drupal_field_data_field_dj_id INNER JOIN drupal_field_data_field_festival_id ON drupal_field_data_field_dj_id.entity_id = drupal_field_data_field_festival_id.entity_id INNER JOIN drupal_field_data_field_date ON drupal_field_data_field_dj_id.entity_id = drupal_field_data_field_date.entity_id WHERE drupal_field_data_field_dj_id.field_dj_id_tid = drupal_field_data_field_lineup_tags.field_lineup_tags_tid AND old_lineup2.field_date_value = drupal_field_data_field_date.field_date_value AND festival.endpoints_entity_id = drupal_field_data_field_festival_id.field_festival_id_target_id AND drupal_field_data_field_dj_id.entity_type = 'taxonomy_term' AND drupal_field_data_field_dj_id.bundle = 'dj_points' AND drupal_field_data_field_festival_id.entity_type = 'taxonomy_term' AND drupal_field_data_field_festival_id.bundle = 'dj_points' AND drupal_field_data_field_date.entity_type = 'taxonomy_term' AND drupal_field_data_field_date.bundle = 'dj_points' ) ORDER BY old_lineup2.field_date_value ASC, drupal_node.nid ASC LIMIT 4000
SQL Abruf Old Lineup. Laufzeit:4

Anzahl zu Prüfender DJ Taggs: 0 Laufzeit:4

Ende des Skripts - Laufzeit:4

0 DJ Point Taxonomies wurden angelegt.
Connection was OK!
SELECT point_taxonomy.tid AS point_id, V1.tid, point_taxonomy.name AS name FROM drupal_taxonomy_term_data AS point_taxonomy LEFT JOIN ( SELECT drupal_taxonomy_term_data.tid AS tid, drupal_field_data_field_dj_id.field_dj_id_tid AS dj_id FROM drupal_taxonomy_term_data # get festival id INNER JOIN drupal_field_data_field_festival_id festival ON festival.entity_id = drupal_taxonomy_term_data.tid # get relation for festival id INNER JOIN drupal_field_data_endpoints festival_endpoint ON festival_endpoint.endpoints_entity_id = festival.field_festival_id_target_id # get old_lineup id for relation INNER JOIN drupal_field_data_endpoints old_lineup_endpoint ON old_lineup_endpoint.entity_id = festival_endpoint.entity_id # get point taxonomy date INNER JOIN drupal_field_data_field_date point_date ON drupal_taxonomy_term_data.tid = point_date.entity_id # get DJ id INNER JOIN drupal_field_data_field_dj_id ON drupal_field_data_field_dj_id.entity_id = drupal_taxonomy_term_data.tid # get date for old_lineup INNER JOIN drupal_field_data_field_date old_lineup_date ON old_lineup_date.entity_id = old_lineup_endpoint.endpoints_entity_id AND old_lineup_date.field_date_value = point_date.field_date_value #Lineup tags for given dj and old_lineup id INNER JOIN drupal_field_data_field_lineup_tags ON drupal_field_data_field_lineup_tags.entity_id=old_lineup_endpoint.endpoints_entity_id AND drupal_field_data_field_lineup_tags.field_lineup_tags_tid= drupal_field_data_field_dj_id.field_dj_id_tid WHERE point_date.entity_type = 'taxonomy_term' AND point_date.bundle = 'dj_points' AND drupal_field_data_field_dj_id.entity_type ='taxonomy_term' AND drupal_field_data_field_dj_id.bundle = 'dj_points' AND festival.entity_type = 'taxonomy_term' AND festival.bundle = 'dj_points' AND festival_endpoint.bundle = 'festivals_only' AND festival_endpoint.endpoints_r_index = '1' AND old_lineup_endpoint.bundle = 'festivals_only' AND old_lineup_endpoint.endpoints_r_index = '0' AND old_lineup_date.entity_type = 'node' AND old_lineup_date.bundle = 'old_lineups' AND old_lineup_date.entity_type = 'node' AND old_lineup_date.bundle = 'old_lineups' #vid 5 are the points AND drupal_taxonomy_term_data.vid ='5' ) as V1 ON point_taxonomy.tid = V1.tid WHERE point_taxonomy.vid ='5' AND V1.tid IS NULL LIMIT 200
SQL Abruf Old Lineup. Laufzeit:27

Laufzeit:27

According to your user settings, this Report will load a maximum of: 15 datasets.