Mforns has submitted this change and it was merged.
Change subject: Fix cross-wiki upload script
......................................................................
Fix cross-wiki upload script
The recentchanges table only goes back 30 days, which is why we didn't
have any useful historical data. MatmaRex set me straight, and pointed
me to the change_tag table, which is less stupid than tag_summary.
Change-Id: Ic6fe5ef178094c934621b84c498e120b08918bfb
---
M multimedia/cross-wiki-uploads.sql
1 file changed, 7 insertions(+), 6 deletions(-)
Approvals:
Mforns: Verified; Looks good to me, approved
diff --git a/multimedia/cross-wiki-uploads.sql
b/multimedia/cross-wiki-uploads.sql
index e30ce96..9fc49dd 100644
--- a/multimedia/cross-wiki-uploads.sql
+++ b/multimedia/cross-wiki-uploads.sql
@@ -1,8 +1,9 @@
select date('{from_timestamp}') as date,
count(*) as {wiki_db}
- from {wiki_db}.tag_summary
- join {wiki_db}.recentchanges on
- ts_rc_id = rc_id
- where ts_tags="cross-wiki-upload" and
- rc_timestamp >= '{from_timestamp}' and
- rc_timestamp < '{to_timestamp}';
+ from {wiki_db}.change_tag
+ join {wiki_db}.logging on
+ ct_log_id = log_id
+ where ct_tag = "cross-wiki-upload" and
+ log_type = "upload" and
+ log_timestamp >= '{from_timestamp}' and
+ log_timestamp < '{to_timestamp}';
--
To view, visit https://gerrit.wikimedia.org/r/266224
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ic6fe5ef178094c934621b84c498e120b08918bfb
Gerrit-PatchSet: 2
Gerrit-Project: analytics/limn-multimedia-data
Gerrit-Branch: master
Gerrit-Owner: MarkTraceur <[email protected]>
Gerrit-Reviewer: MarkTraceur <[email protected]>
Gerrit-Reviewer: Mforns <[email protected]>
Gerrit-Reviewer: Milimetric <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
