Is iif(locate('|',genres)>1,left(genres(locate('|',genres)-1),genres) should be iif(locate('|',genres)>1,left(genres, locate('|',genres)-1),genres)
Is
iif(locate('|',genres)>1,left(genres(locate('|',genres)-1),genres)
should be
iif(locate('|',genres)>1,left(genres, locate('|',genres)-1),genres)