Links auf cnmnc.main.jp

SQL

SELECT CONCAT('https://cnmnc.main.jp', REGEXP_REPLACE(el_to_path, '#.*$', '')) AS "Link", COUNt(*) AS "Anzahl Verlinkung"
  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',
                                                      '/recent/CNMNC%20NEWSLETTER%2013.pdf',
                                                      '/recent/CNMNC%20NEWSLETTER%2014.pdf',
                                                      '/recent/CNMNC%20NEWSLETTER%2021.pdf',
                                                      '/recent/CNMNC%20NEWSLETTER%2022.pdf',
                                                      '/recent/CNMNC40%28MM%29.pdf',
                                                      '/recent/minerals2004.pdf',
                                                      '/recent/minerals2007.pdf',
                                                      '/recent/NEW%20MINERALS%20APPROVED%20IN%202009.pdf',
                                                      '/recent/NEW%20MINERALS%20APPROVED%20OCTOBER%20NOVEMBER%202013.pdf',
                                                      '/recent/newminerals2010.pdf'
                                                     )
 GROUP BY REGEXP_REPLACE(el_to_path, '#.*$', '')
 ORDER BY COUNT(*) DESC;
SQL

Checking query status...
