(Anthere <anthere6(a)yahoo.com>)m>):
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.
--
Lee Daniel Crocker <lee(a)piclab.com> <http://www.piclab.com/lee/>
"All inventions or works of authorship original to me, herein and past,
are placed irrevocably in the public domain, and may be used or modified
for any purpose, without permission, attribution, or notification."--LDC