SELECT
 page_namespace AS "ns",
 page_title AS "title",
 LENGTH(page_title) AS "title length",
 page_len AS "size",
 ROUND (   
  (
    CHAR_LENGTH(page_title)
      - CHAR_LENGTH( REPLACE ( page_title, "/", "") ) 
    ) / CHAR_LENGTH("/")        
  ) AS "count"
FROM page
WHERE page_namespace IN (2, 3)
AND ROUND (   
  (
    CHAR_LENGTH(page_title)
      - CHAR_LENGTH( REPLACE ( page_title, "/", "") ) 
    ) / CHAR_LENGTH("/")        
  ) > 7
ORDER BY count DESC
LIMIT 1000;