Query Run
SELECT CONCAT('بوابة_',main.page_title), COUNT(*) - 1 as sub_page_count, ... 9 months ago
SELECT main.page_title, COUNT(*) - 1 as sub_page_count, (SELECT... 9 months ago
SELECT main.page_title FROM page AS p INNER JOIN ( SELECT page_title ... 9 months ago
SELECT main.page_title, COUNT(*) - 1 as sub_page_count, (SELECT... 9 months ago