Untitled query #16567

SQL

use svwiki_p;
/*SELECT page_title, COUNT(*) AS Antal FROM page
INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id
#WHERE page_title='Brandy_Norwood'
WHERE (cl_to = 'Amerikanska_skådespelare' OR cl_to = 'Skådespelare_från_Kalifornien') AND page_namespace = 0
GROUP BY page_title
HAVING Antal > 1
ORDER BY page_title
LIMIT 100
*/
SHOW TABLES;

SELECT rc_title, rc_timestamp, el_to FROM recentchanges
INNER JOIN page ON page_title = rc_title
INNER JOIN externallinks ON el_from = page_id
WHERE rc_user_text = 'InternetArchiveBot' AND el_to LIKE '%wikimediafoundation%' AND page_namespace = 1
LIMIT 100
SQL

Checking query status...
