Untitled query #9242

SQL

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 ;
SQL

Checking query status...
