Лещенко. Автор музыки - А. Пахмутова (да простит меня она, если ошибаюсь) ,
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 '[[:<:]](Лещенко.)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Лещенко.)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](Лещенко.)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Лещенко.)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](Лещенко.)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](Автор)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Автор)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](Автор)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Автор)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](Автор)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](музыки)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](музыки)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](музыки)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](музыки)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](музыки)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](А.)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](А.)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](А.)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](А.)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](А.)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](Пахмутова)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Пахмутова)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](Пахмутова)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Пахмутова)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](Пахмутова)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]]((да)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]]((да)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]]((да)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]]((да)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]]((да)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](простит)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](простит)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](простит)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](простит)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](простит)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](меня)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](меня)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](меня)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](меня)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](меня)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](она,)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](она,)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](она,)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](она,)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](она,)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](если)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](если)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](если)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](если)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](если)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](ошибаюсь))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](ошибаюсь))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](ошибаюсь))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](ошибаюсь))[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](ошибаюсь))[[:>:]]'
) ORDER BY song_one.value LIMIT 100
Error: Got error 'parentheses not balanced' from regexp