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
(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(a)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: