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

*/

​

​