Tewiki: External links to Social media

SQL

use tewiki_p;
SET sql_mode='PIPES_AS_CONCAT';
select '# [['||el_to ||']]' as el_to, CONCAT('# ',GROUP_CONCAT(concat('[[',page_title,']]') SEPARATOR ', '),'') as page, COUNT(el_to) as cnt
from externallinks 
  inner join page
    on (page_id=el_from)
where page_namespace =0
and (el_to like '%.blogspot.%'  
  or el_to like '%.tumblr.%' 
  or el_to like '%geocities.%' 
  or el_to like '%.livejournal.%'
  or el_to like '%.tr.gg%'
  or el_to like '%.wordpress.com%'
  or el_to like '%.blogcu.com%'
  or el_to like '%.weebly.com%'
  or el_to like '%pinterest.com%'
  or el_to like '%facebook.%'
  or el_to like '%twitter.%'


)
GROUP BY el_to
ORDER BY cnt desc;
SQL

Checking query status...
