تصنيفات إلى بوابات

SQL

use arwiki_p;
select concat (SUBSTRING_INDEX(`page_title`, '_', 1)), concat (SUBSTRING_INDEX(`page_title`, '_', 2)),
concat (SUBSTRING_INDEX(`page_title`, '_', 3)) , count(SUBSTRING_INDEX(`page_title`, '_', 1)), 
count(SUBSTRING_INDEX(`page_title`, '_', 2)), count (SUBSTRING_INDEX(`page_title`, '_', 3))
from page
where page_namespace = 14
and page_is_redirect = 0
and concat('',SUBSTRING_INDEX(`page_title`, '_', 1) * 1) <> SUBSTRING_INDEX(`page_title`, '_', 1)
group by SUBSTRING_INDEX(`page_title`, '_', 1)
order by count(*) desc
limit 5000;

SQL

Checking query status...