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 "id", p.page_namespace "from NS", p.page_title "from", pl.pl_namespace "to NS", pl.pl_title "to", x.page_title
FROM page p
INNER JOIN pagelinks pl
	ON pl.pl_from = p.page_id
INNER JOIN (
	SELECT pp.page_id, pp.page_namespace, pp.page_title
  	FROM page pp
	WHERE pp.page_title LIKE "Mo%"
#		AND pp.page_namespace = pl.pl_namespace
#   	AND pp.page_title = pl.pl_title
) x
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_title
FROM page
WHERE page_namespace = 0
*/


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