rendered paste bodyREPLACE INTO itm_event_artist
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 1),
length(substring_index(ies.djs,
',',
1 - 1)) + 1),
',', '') = ia.name
REPLACE INTO itm_event_artist
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 2),
length(substring_index(ies.djs,
',',
2 - 1)) + 1),
',', '') = ia.name
REPLACE INTO itm_event_artist
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 3),
length(substring_index(ies.djs,
',',
3 - 1)) + 1),
',', '') = ia.name
REPLACE INTO itm_event_artist
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 4),
length(substring_index(ies.djs,
',',
4 - 1)) + 1),
',', '') = ia.name
REPLACE INTO itm_event_artist
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 5),
length(substring_index(ies.djs,
',',
5 - 1)) + 1),
',', '') = ia.name