User:ToBeFree/SQL

This page is in the public domain / released under a CC0 1.0 Universal license: https://creativecommons.org/publicdomain/zero/1.0/legalcode

This page is in the public domain / released under a CC0 1.0 Universal license: https://creativecommons.org/publicdomain/zero/1.0/legalcode

Huge thanks to Reedy for introducing me to the magic world of MediaWiki's SQL tables.

Huggle

Identifying the ID of the "huggle" tag

This query has been written by Reedy at https://quarry.wmflabs.org/query/36907 and licensed under a CC0 1.0 Universal license: https://creativecommons.org/publicdomain/zero/1.0/legalcode 

use enwiki_p;
select ctd_id, ctd_name from change_tag_def WHERE ctd_name = 'huggle';

Huggle edits between two timestamps

https://quarry.wmflabs.org/query/36908 

USE enwiki_p;
SELECT rev_timestamp, actor_name FROM change_tag
LEFT JOIN revision ON change_tag.ct_rev_id = revision.rev_id
LEFT JOIN actor ON revision.rev_actor = actor.actor_id
WHERE ct_tag_id = 7 AND rev_timestamp BETWEEN '20190101000001' AND '20190201000001'
LIMIT 100;

Huggle users by activity

https://quarry.wmflabs.org/query/36909 

USE enwiki_p;
SELECT COUNT(x.actor_name), x.actor_name FROM (
    SELECT rev_timestamp, actor_name FROM change_tag
    LEFT JOIN revision ON change_tag.ct_rev_id = revision.rev_id
    LEFT JOIN actor ON revision.rev_actor = actor.actor_id
    WHERE ct_tag_id = 7 AND rev_timestamp BETWEEN '20190101000001' AND '20190201000001'
) AS x;

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.