Untitled query #17569

SQL

USE svwiki_p;

SELECT COUNT(*) AS antal FROM pagelinks WHERE
(pl_title = 'Osmia' OR pl_title = 'Murarbin_(Osmia)')
/*
pl_title = 'Egentliga_insekter'
*/
AND pl_namespace = 0
/*
AND pl_from_namespace = 0
*/


/*
SELECT SUBSTR(log_timestamp,1,6) AS month, COUNT(*) AS antal FROM logging WHERE
log_action = 'delete'
AND log_namespace = 0
AND log_timestamp > '20000101000000'

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%'
*/
SQL

Checking query status...
