(Anthere anthere6@yahoo.com):
select l.cur_title, r.cur_title from cur l inner join links lnk on binary l.cur_title = binary lnk.l_from inner join cur r on binary r.cur_title = binary lnk.l_to where r.cur_text like '%#redirect%'
"where ... like '%..." is a no-no, especially on a join, as it will cause a full search of every record.