https://bugzilla.wikimedia.org/show_bug.cgi?id=37225
MZMcBride <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #47 from MZMcBride <[email protected]> 2012-06-25 00:02:01 UTC --- (In reply to comment #44) > SELECT trc.* from recentchanges trc, ( SELECT rc_cur_id, MIN(rc_id) AS > rc_id_min, MIN(COALESCE(rc_new_len,0)) from recentchanges WHERE rc_new_len>0 > AND rc_type<=1 GROUP BY 1 HAVING MIN(COALESCE(rc_new_len,0))>0 ) trcmin WHERE > (trc.rc_old_len=0 OR trc.rc_old_len IS NULL) AND trc.rc_type<=1 AND > trc.rc_cur_id=trcmin_rc_cur_id AND trc.rc_id>trcmin.rc_id_min This query had a minor typo in it ("trcmin_rc_cur_id" --> "trcmin.rc_cur_id"). Here are the results from enwiki_p (warning: 8004 results): <http://p.defau.lt/?Z52AerNoGQ3hKM77IYNa5g>. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
