Items with many interwikis but without a Czech interwiki

SQL

use wikidatawiki_p; 
select  ips_item_id,  nn, en_title, cs_title
from 
(select ips_item_id, nn, cs_title
from
 (select ips_item_id, count(*) as nn
  from wb_items_per_site
  where ips_site_id in ('enwiki', 'dewiki', 'frwiki', 'eswiki', 'ruwiki', 'itwiki', 'jawiki', 'nlwiki', 
                        'ptwiki', 'plwiki', 'zhwiki', 'svwiki', 'shwiki', 'arwiki', 'fawiki', 'hewiki', 
                        'ukwiki', 'kowiki', 'huwiki', 'trwiki', 'cawiki', 'fiwiki', 'nowiki', 'cswiki',
                        'simplewiki', 'idwiki', 'srwiki', 'rowiki', 'dawiki', 'bgwiki', 'thwiki', 'skwiki', 
                        'eowiki', 'elwiki', 'euwiki', 'ltwiki', 'hrwiki', 'slwiki', 'etwiki', 'hywiki', 'mswiki', 
                        'glwiki', 'azwiki', 'kawiki', 'hiwiki', 'lvwiki', 'kkwiki', 'bewiki', 'mlwiki', 'bnwiki', 
                        'tawiki', 'sqwiki' )                      
  group by ips_item_id      
  having nn > 20) as grp left outer join
( select ips_item_id as ii, ips_site_page as cs_title
  from wb_items_per_site
  where ips_site_id = 'cswiki'   ) as cs 
  on ips_item_id = ii 
 ) as f  left outer join
( select ips_item_id as iii, ips_site_page as en_title
  from wb_items_per_site
  where ips_site_id = 'enwiki' ) as eng   
  on ips_item_id = iii
where  cs_title IS NULL 
limit 100;
SQL

Checking query status...
