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 
FROM page
JOIN revision on page_id = rev_page
GROUP by page_id
ORDER BY RAND() LIMIT 1000;

#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...
