On Tue, Jul 22, 2008 at 6:37 PM,
<vyznev(a)svn.wikimedia.org> wrote:
+ // need to resort and
relimit after union
+ $sql = "(" . implode( ") UNION (", $subsql )
. ") ORDER BY rc_timestamp DESC LIMIT {$limit}";
Does this actually work in MySQL 4? I think you need to retrieve them
all and do the ordering in PHP, the way it's done in WhatLinksHere.
Well, Special:RecentChanges already uses a similar trick (grep for
"($sqlNew) UNION ($sqlOld)"), so I assumed it works. Haven't actually
tested it on MySQL 4, though.