raw.txt
No One
Actions

Authored By

	Addshore
	Jul 29 2020, 10:11 AM

Size

579 B

Referenced Files

None

Subscribers

None

raw.txt
View Options

	SELECT
	COUNT(*) AS count,
	AVG(query_time) AS avgQueryTime,
	reflect("java.net.URLEncoder", "encode",query) AS urlEncodedQuery
	FROM event.wdqs_external_sparql_query
	WHERE year = 2020
	AND month = 07
	AND day = 22
	AND namespace = "wdq"
	GROUP BY query
	ORDER BY count DESC
	LIMIT 1000000

	SELECT
	COUNT(*) AS count,
	AVG(query_time) AS avgQueryTime,
	reflect("java.net.URLEncoder", "encode",query) AS urlEncodedQuery
	FROM event.wdqs_external_sparql_query
	WHERE year = 2020
	AND month = 07
	AND day = 22
	AND namespace = "wdq"
	GROUP BY query
	ORDER BY avgQueryTime DESC
	LIMIT 1000000