Learning DB structure

SQL

USE cswiki_p;
#SHOW TABLES 
#DESCRIBE sites
#category: SELECT cat_title, cat_pages, cat_subcats, cat_files
#pagelinks: SELECT pl_from, pl_namespace, pl_title


SELECT p.page_id, p.page_namespace, p.page_title, pl.pl_namespace, pl.pl_title#, x.page_title
FROM page p
INNER JOIN pagelinks pl
	ON pl.pl_from = p.page_id
#LEFT OUTER JOIN (
#	SELECT pp.page_id, pp.page_namespace, pp.page_title
#  	FROM page pp) x ON x.page_namespace = pl.pl_namespace
#    		AND x.page_namespace = pl.pl_namespace
WHERE p.page_namespace = 0 # from Articles
	AND pl.pl_namespace = 0 # to Articles
	AND p.page_title = "Setrvačnost" # from this article
    #AND pl_title LIKE "Wa%"
--    AND x.page_title IS NULL
LIMIT 20;

/*
SELECT page_id, page_title
FROM page
WHERE page_title = "Setrvačnost"

SELECT page_id, page_title
FROM page
WHERE page_title LIKE "Q%"
LIMIT 50
*/
SQL

Checking query status...
