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 '[[:<:]](Youre)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Youre)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](Youre)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](Youre)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](Youre)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](love)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](love)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](love)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](love)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](love)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]]((my)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]]((my)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]]((my)[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]]((my)[[:>:]]' ) OR 
t.note RLIKE '[[:<:]]((my)[[:>:]]'
) AND 
(
exists (select 0 from phrase_variant v where singer_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](life))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where singer_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](life))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_one.id=v.phrase_id AND v.value RLIKE '[[:<:]](life))[[:>:]]' ) OR 
exists (select 0 from phrase_variant v where song_two.id=v.phrase_id AND v.value RLIKE '[[:<:]](life))[[:>:]]' ) OR 
t.note RLIKE '[[:<:]](life))[[:>:]]'
) ORDER BY song_one.value LIMIT 100