https://bugzilla.wikimedia.org/show_bug.cgi?id=59359
--- Comment #3 from Bugzilla Bug Importer (valhallasw) <[email protected]> --- ------------------------------------------------------------------------------- From: Maciej Jaros <[email protected]> Date: Mon, 18 Oct 2010 06:53:36 ------------------------------------------------------------------------------- Damn, I thought it might... Try this: UPDATE admin_stats SET registration_dt = (SELECT MIN(log_timestamp) FROM wikidb.logging WHERE log_user_text = admin_name AND log_type = 'newusers' AND log_action = 'create') ,admin_id = (SELECT MIN(log_user) FROM wikidb.logging WHERE log_user_text = admin_name AND log_type = 'newusers' AND log_action = 'create') ; Should work the same, but might be a lot slower. -- 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
