queries.sh
ActivePublic
Actions

Authored by Eevans on Dec 1 2021, 1:20 AM.

Tags

None

Referenced Files

	F34797959: queries.sh
	Dec 1 2021, 1:22 AM

	F34797947: queries.sh
	Dec 1 2021, 1:20 AM

Subscribers

None

	for i in all-access desktop mobile-app mobile-web; do
	for j in {01..31}; do
	printf "SELECT * FROM \"local_group_default_T_top_pageviews\".data where \"_domain\" = 'analytics.wikimedia.org' AND project = 'en.wikipedia' AND access = '%s' AND year = '2021' AND month = '01' AND day = '%s';\n" "$i" "$j"
	done
	done

Eevans edited the content of this paste. (Show Details)

queries.shActivePublicActions