MarkTraceur has uploaded a new change for review. https://gerrit.wikimedia.org/r/266224
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(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-multimedia-data refs/changes/24/266224/1 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: newchange Gerrit-Change-Id: Ic6fe5ef178094c934621b84c498e120b08918bfb Gerrit-PatchSet: 1 Gerrit-Project: analytics/limn-multimedia-data Gerrit-Branch: master Gerrit-Owner: MarkTraceur <mtrac...@member.fsf.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits