Untitled query #77923

SQL

SELECT CONCAT('# {{/সম্পাদনা|',page_title,'}} পাতায়'),
#       page_namespace,
       CONCAT(el_to_domain_index, el_to_path, el_id, ' রয়েছে') AS url
FROM externallinks
JOIN page ON page_id = el_from
WHERE el_to_domain_index LIKE 'http://en.banglapedia.org/%' OR el_to_domain_index LIKE 'https://en.banglapedia.org/%'
AND page_namespace=0
  
FROM
(
  SELECT n, mainquery.*,
         SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(el_to_domain_index, '://', -1), '.', n), '.', -1) AS part
   FROM numbers
   JOIN mainquery
     ON CHAR_LENGTH(el_to_domain_index) - CHAR_LENGTH(REPLACE(el_to_domain_index, '.', '')) >= n - 1
) AS sq
GROUP BY el_id
#ORDER BY page_title;

;
SQL

Checking query status...
