Links auf cnmnc.main.jp

SQL

SELECT CONCAT('https://cnmnc.main.jp', REGEXP_REPLACE(el_to_path, '#.*$', '')) AS "Link",
       COUNt(*) AS "Anzahl Verlinkung",
       GROUP_CONCAT(page_title SEPARATOR " ")
  FROM page, externallinks
 WHERE page_id = el_from 
   AND page_namespace = 0 
   AND el_to_domain_index IN ('https://jp.main.cnmnc.', 'http://jp.main.cnmnc.')
   AND REGEXP_REPLACE(el_to_path, '#.*$', '') NOT IN ('/cnmmn98.pdf',
                                                      '/tidyingupnames.pdf',
                                                      '/recent/164b_CNMNC_Newsletter_49-2019%28EJM%29.pdf',
                                                      '/recent/165a_CNMNC_Newsletter_50-2019%28MM%29.pdf',
                                                      '/recent/CNMNC%20Newsletter%2016.pdf',
                                                      '/recent/CNMNC%20Newsletter%2032-2016.pdf',
                                                      '/recent/CNMNC%20Newsletter%2034-2016.pdf',
                                                      '/recent/CNMNC_Newsletter_28-2015.pdf',
                                                      '/recent/Newsletter61_MGM_85_3.pdf',
                                                      '/recent/newsletter-64.pdf',
                                                      '/recent/newsletter-69.pdf')
 GROUP BY REGEXP_REPLACE(el_to_path, '#.*$', '')
 ORDER BY COUNT(*) DESC;
SQL

Checking query status...
