USE svwiki_p;

​

SELECT * FROM pagelinks INNER JOIN page ON pl_from = page_id WHERE

pl_title = 'Crawler-transporter'

AND pl_namespace = 0

​

/*

SELECT rc_namespace, rc_title, MAX(rc_timestamp) AS senast, COUNT(*) AS antal FROM recentchanges INNER JOIN actor ON rc_actor=actor_id WHERE

actor_name = 'ListeriaBot' 

/*

AND rc_timestamp > '20210817000000'

*/

/*

GROUP BY rc_namespace, rc_title

ORDER BY antal DESC

*/

​

​

/*

SELECT COUNT(*) AS antal FROM pagelinks WHERE

(pl_title = 'Osmia' OR pl_title = 'Murarbin_(Osmia)')

AND pl_namespace = 0

*/

​

/*

SELECT

CONCAT("# {{target | user =",actor_name,"| site = mediawiki.org }}") AS rev_user_text,

COUNT(actor_id) AS recent_user_editcount

FROM revision

JOIN actor_revision ON rev_actor=actor_id

JOIN page ON rev_page=page_id

WHERE actor_user IS NOT NULL

  AND page_namespace IN (0)

  AND rev_timestamp BETWEEN 20210101000000 AND 20210630235959

  AND actor_user NOT IN (select ug_user from user_groups where ug_group = 'bot')

GROUP BY actor_id

ORDER BY recent_user_editcount DESC

LIMIT 300;

*/

​

/*

SELECT SUBSTR(log_timestamp,1,6) AS month, COUNT(*) AS antal FROM logging WHERE

log_action = 'delete'

AND log_namespace = 0

AND log_timestamp > '20180101000000'

​

GROUP BY month

ORDER BY month

*/

​

/*

SELECT page_title, "§" x, rev_timestamp, "§" y, actor_name FROM page INNER JOIN revision ON page_id=rev_page INNER JOIN actor on rev_actor=actor_id

WHERE page_namespace = 4 

AND page_title LIKE 'Sidor_föreslagna_för_radering/%'

*/

​

/*

SELECT DISTINCT p1.page_namespace, p1.page_title, cl_to, pp_propname FROM categorylinks 

INNER JOIN page p1 ON cl_from=p1.page_id 

INNER JOIN category ON cl_to=cat_title

INNER JOIN page p2 ON cat_title=p2.page_title

INNER JOIN page_props ON p2.page_id=pp_page

WHERE ((p1.page_namespace = 2 AND p1.page_title LIKE '%/%') OR p1.page_namespace= 3)

AND p1.page_title NOT LIKE 'Lsjbot%'

*/

​