Ryan Hudy wrote:
Just to make sure I'm on the same page, that would
mean this statement
using v 1.5:
select page_title, old_text from page, text, categorylinks, revision
where page_id=cl_from and cl_to='$cat' and page_latest=rev_id and
rev_text_id=old_id
would translate in v 1.4 to:
select cur_title, cur_text from cur, old, categorylinks where
cur_id=cl_from and cl_to='$cat'
Take out the 'old'. It's not used in that query and so would create a
Cartesian join (kaboom).
Also, don't forget to use the namespace fields; namespace and title
should always be treated as a pair.
-- brion vibber (brion @
pobox.com)