Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Smile4ever
.
Toggle Highlighting
SQL
use nlwiki_p; #SELECT a.actor_name, l.* FROM logging l INNER JOIN actor a ON l.log_actor = a.actor_id #SELECT log_user_text, log_timestamp, CONCAT(SUBSTRING(log_timestamp, 1, 8), ' ', SUBSTRING(log_timestamp, 9, 2), ':', SUBSTRING(log_timestamp, 11, 2), ':', SUBSTRING(log_timestamp, 13, 2)) as timestamp_human, log_title FROM logging #WHERE log_type = 'patrol' #Enkel markeringen #AND log_namespace = '0' #Enkel hoofdnaamruimte #ORDER BY log_timestamp DESC #De meest recente bovenaan #LIMIT 100 SELECT log_user_text, COUNT(1) as aantal FROM logging WHERE log_type = 'patrol' #Enkel markeringen AND log_namespace = '0' #Enkel hoofdnaamruimte AND log_timestamp LIKE '2019%' GROUP BY log_user_text ORDER BY COUNT(1)
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...