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
Hi Gregor Martynus,
Do you want these three queries outputted separately?
On Fri, Sep 7, 2012 at 8:36 PM, Gregor Martynus gregor@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
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=c...
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@martynus.net (mailto:gregor@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 (http://donate.wikimedia.org/)
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=c...
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@martynus.net (mailto:gregor@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 (http://donate.wikimedia.org/)
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@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=c...
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@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 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
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@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@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=c...
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@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 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
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 <phoenixoverride@gmail.com (mailto:phoenixoverride@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@martynus.net (mailto:gregor@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=c...
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@martynus.net (mailto:gregor@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@lists.wikimedia.org