USE svwiki_p;

​

SELECT * FROM logging

WHERE log_timestamp>'20190101000000'

AND log_type='newusers'

​

/*

SELECT cl_to, COUNT(cl_from) AS antal FROM categorylinks INNER JOIN page ON cl_from=page_id WHERE

cl_to LIKE 'Wikidataetiketter_på_främmande_språk_för_egenskapen%'

GROUP BY cl_to

ORDER BY antal DESC, cl_to

*/

​

/*

SELECT * FROM revision INNER JOIN actor ON rev_actor=actor_id WHERE rev_page=51500

*/