Week 2 Formative Code

SQL

USE simplewiki_p;
#SELECT page_id, COUNT(rev_id) as E, COUNT(DISTINCT rev_user) as U, page_len as L, page_title, page_namespace 

#Select p1.page_title, p2.page_title, p1.page_len, p2.page_len, page_id
#FROM page p1
#JOIN page p2
#ON p1.page_title = p2.page_title
#WHERE p1.page_namespace = "0"
#AND p2.page_namespace = "1"
#JOIN revision on rev_page = page_id 

#WHERE page_namespace = "1" or page_namespace = "0" 
#GROUP BY page_id 
#ORDER BY RAND() LIMIT 100;

#SHOW TABLES;
#DESCRIBE page_props

SELECT page_id, article_title, U, E, page_len AS L, T, page_namespace FROM
	(SELECT page_title AS article_title, page_len AS T,
     COUNT(DISTINCT rev_user) AS U,
     COUNT(rev_id) AS E
     FROM revision
     JOIN page ON rev_page = page_id
     WHERE LOWER(rev_user) NOT LIKE LOWER("%bot%") AND page_is_redirect = "0" AND page_namespace = "1"
     GROUP BY page_id
     ORDER BY RAND()
     LIMIT 1000)
     AS subq
     JOIN page
     WHERE page_title = article_title
     AND (page_namespace = "0"); #OR page_namespace = "1");
SQL

Checking query status...
