Untitled query #17569

SQL

USE svwiki_p;

SELECT page_titel, rev_timestamp, rev_actor FROM page INNER JOIN revision ON page_id=rev_page
WHERE page_namespace = 4 
AND page_title LIKE 'Sidor_föreslagna_för_radering/%'
LIMIT 100

/*
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...
