Thanks so much, awesome! Have a great weekend everyone! -- Gregor Martynus
On Sunday, 9. September 2012 at 14:28, Hydriz Wikipedia wrote: > Hi Gregor Martynus, > > Was done by hoo just now. Hope that will help you! :) > > On Sat, Sep 8, 2012 at 6:43 PM, John <phoenixoverr...@gmail.com > (mailto:phoenixoverr...@gmail.com)> wrote: > > I am CCing the toolserver user in question to see if they can re-run the > > query > > > > On Sat, Sep 8, 2012 at 6:09 AM, Gregor Martynus <gre...@martynus.net > > (mailto:gre...@martynus.net)> wrote: > > > Can anybody help or give me a hint whom I could ask? > > > > > > -- > > > Gregor Martynus > > > > > > On Friday, 7. September 2012 at 14:40, Gregor Martynus wrote: > > > > > > Yeah, that'd be great, just as user hoo did it for me around 2 months ago: > > > https://jira.toolserver.org/browse/DBQ-189?focusedCommentId=21514&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-21514 > > > > > > thanks a lot for your help! > > > > > > -- > > > Gregor Martynus > > > > > > On Friday, 7. September 2012 at 14:39, Hydriz Wikipedia wrote: > > > > > > 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 > > > (mailto:gre...@martynus.net)> wrote: > > > > > > Hey there, > > > > > > can anybody with access execute these 3 SQL queries and provide me the > > > results of it? > > > > > > --1 > > > SELECT 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'; > > > --2 > > > SELECT 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 > > > (mailto: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 > > > (mailto: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 > (http://donate.wikimedia.org/)
_______________________________________________ Xmldatadumps-l mailing list Xmldatadumps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l
