THE ANDREWS SISTERS (WITH RUSS MORGAN AND HIS ORCHESTRA) Заимствования в музыке, Плагиат
SQL: SELECT song_one.value AS song_one, song_two.value AS song_two, singer_one.value AS singer_one, singer_two.value AS singer_two, t.note, t.song_one_id, t.song_two_id, t.singer_one_id, t.singer_two_id, t.id, t.site, t.vote_pro, t.vote_con, t.created_time 
FROM twins t 
LEFT OUTER JOIN phrase song_one ON (t.song_one_id = song_one.id) 
LEFT OUTER JOIN phrase song_two ON (t.song_two_id = song_two.id) 
LEFT OUTER JOIN phrase singer_one ON (t.singer_one_id = singer_one.id) 
LEFT OUTER JOIN phrase singer_two ON (t.singer_two_id = singer_two.id) 
WHERE 1=1 AND t.approved=1 
AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](ANDREWS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](ANDREWS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](ANDREWS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](ANDREWS)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](ANDREWS)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](SISTERS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](SISTERS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](SISTERS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](SISTERS)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](SISTERS)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]]((WITH)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]]((WITH)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]]((WITH)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]]((WITH)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]]((WITH)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](RUSS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](RUSS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](RUSS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](RUSS)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](RUSS)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](MORGAN)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](MORGAN)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](MORGAN)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](MORGAN)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](MORGAN)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](AND)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](AND)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](AND)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](AND)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](AND)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](HIS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](HIS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](HIS)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](HIS)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](HIS)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](ORCHESTRA))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](ORCHESTRA))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](ORCHESTRA))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](ORCHESTRA))[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](ORCHESTRA))[[:>:]]'
) ORDER BY song_one.value LIMIT 100
Error: Got error 'parentheses not balanced' from regexp