~ - Quarry

SQL

select 
  page_namespace, 
  page_title 
from 
  page 
  left join (
    select 
      lt_namespace, 
      lt_title, 
      count(*) as pocet_vyskytu 
    from 
      templatelinks 
      left join page on tl_from = page_id 
      left join linktarget on tl_target_id=lt_id
    where 
      concat(page_namespace, page_title) not like concat(lt_namespace, lt_title) 
      and concat(page_namespace, page_title) not like concat(lt_namespace, lt_title, '/doc') 
      and concat(page_namespace, page_title) not like '4Šablony/%' 
    group by 
      lt_namespace, 
      lt_title
  ) as tabulka_vyskytu on page_namespace = lt_namespace 
  and page_title = lt_title 
where 
  page_namespace like 10 
  and not page_is_redirect 
  and pocet_vyskytu like 1 
  and not page_title like '%/doc' 
  and not page_title like 'Vyznamenat/%' 
  and not page_title rlike 'Kalendář[A-ZŽŠČŘĎŤŇĚÁÉÍÓÚŮÝ].*' 
order by 
  page_title;
SQL

Checking query status...
