articole scurte

SQL

use rowiki_p;
/*
SELECT *
FROM archive
order by ar_timestamp desc
limit 40*//*
SELECT * from page where page_len < 1000 and page_namespace = 0 and page_is_redirect = 0
order by page_len asc
limit 1000*/
#SELECT count(*) from page where page_len < 1000 and page_namespace = 0 and page_is_redirect = 0
/*
USE rowiki_p;
SELECT pl_title, COUNT(pl_title)
FROM pagelinks
#JOIN categorylinks	ON pl_from = cl_from
WHERE pl_from_namespace = 0 and pl_namespace = 0
#	AND cl_type = "page"
#    AND cl_to = "Centura_de_asteroizi"#"Obiecte_astronomice_descoperite_în_1988"#"Obiecte_astronomice_descoperite_în_1988"
#  test  and pl_from = 1386302;#pl_title = "5430_Luu";
and pl_title like "Arondisment%"
	AND NOT EXISTS (
      SELECT *
      FROM page
      WHERE pl_title = page_title
      	AND page_namespace = 0
    )
    group by pl_title
    having COUNT(pl_title) > 4
ORDER BY COUNT(pl_title) desc
*/
select * from page where page_id = 1868118
SQL

Checking query status...
