nuria · March 7, 2020 00:43
diff --git a/commons-files-viewed-from-wikis.hql b/commons-files-viewed-from-wikis.hql
 use wmf;

 select distinct base_name
 from
 mediarequest
 where year=2019
 and month=12
 and day=1
 and hour=1
 and base_name like '%commons%'
 and (referer like '%wik%' or referer like '%internal%');
	use wmf;

	select distinct base_name
	from
	mediarequest
	where year=2019
	and month=12
	and day=1
	and hour=1
	and base_name like '%commons%'
	and (referer like '%wik%' or referer like '%internal%');