USE plwikisource_p;

SELECT count(DISTINCT page_id) AS licznik_Ankrego

  FROM page JOIN templatelinks ON page_id=tl_from JOIN revision ON page_id=rev_page

  WHERE page_namespace = 0 AND tl_title='Proofreadpage_pagenum_template' AND tl_namespace=8;

​

SELECT count(DISTINCT page_id) as licznik_Phe

                    FROM

                        templatelinks,

                        page

                    WHERE

                        page_id=tl_from AND

                        tl_namespace = 100 AND

                        page_namespace = 0;

​

SELECT DISTINCT page_title as różnica_pomiędzy_A_P

                    FROM

                        templatelinks,

                        page

                    WHERE

                        page_id=tl_from AND

                        tl_namespace = 100 AND

                        page_namespace = 0 AND

                        page_id NOT IN (SELECT page_id

  FROM page JOIN templatelinks ON page_id=tl_from

  WHERE page_namespace = 0 AND tl_title='Proofreadpage_pagenum_template' AND tl_namespace=8

  GROUP BY page_id)

           LIMIT 1000 ;