Hi Gregor Martynus, Do you want these three queries outputted separately?
On Fri, Sep 7, 2012 at 8:36 PM, Gregor Martynus <gre...@martynus.net> wrote: > Hey there, > > can anybody with access execute these 3 SQL queries and provide me the > results of it? > > --1SELECT user_id, user_name, user_registration FROM user INNER JOIN logging > ON log_user = user_id WHERE LEFT(user_registration, 4) = 2012 AND user_id NOT > IN (SELECT ipb_user FROM ipblocks) AND log_type = 'newusers' AND log_action = > 'create'; > --2SELECT page_id, page_title, page_namespace, page_is_redirect FROM page; > --3 > INSERT INTO u_hoo.dbq189 SELECT user_name FROM user INNER JOIN logging ON > log_user = user_id WHERE LEFT(user_registration, 4) = 2012 AND user_id NOT IN > (SELECT ipb_user FROM ipblocks) AND log_type = 'newusers' AND log_action = > 'create';SELECT rev_id, rev_page, rev_comment, rev_user_text, rev_user, > rev_timestamp FROM revision INNER JOIN u_hoo.dbq189 ON rev_user_text = > dbq189.user_name WHERE rev_deleted = 0 AND rev_user != 0; > > > I need it for a study of a friend of mine, I really appreciate your help. > > I also made a ticket, but nobody reacted so far and it's a bit urgent: > https://jira.toolserver.org/browse/DBQ-195 > > > Thanks > – Gregor > > _______________________________________________ > Xmldatadumps-l mailing list > Xmldatadumps-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l > > -- Regards, Hydriz We've created the greatest collection of shared knowledge in history. Help protect Wikipedia. Donate now: http://donate.wikimedia.org
_______________________________________________ Xmldatadumps-l mailing list Xmldatadumps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l
