Hi Gregor Martynus,
Was done by hoo just now. Hope that will help you! :)
On Sat, Sep 8, 2012 at 6:43 PM, John <phoenixoverride(a)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 <gregor(a)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=…
> 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 <gregor(a)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(a)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(a)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: