SELECT CONCAT('Q', ips.ips_item_id) AS qid, 

CASE WHEN COUNT(DISTINCT ips.ips_site_id) > 1 THEN 'yes' ELSE 'no' END AS available_in_multiple_languages,  

COUNT(DISTINCT ips.ips_site_id) AS num_languages,  

MAX(CASE WHEN ips.ips_site_id = 'hewiki' THEN 1 ELSE 0 END) AS hebrew,  

MAX(CASE WHEN ips.ips_site_id = 'enwiki' THEN 1 ELSE 0 END) AS english,  

MAX(CASE WHEN ips.ips_site_id = 'ruwiki' THEN 1 ELSE 0 END) AS russian,  

MAX(CASE WHEN ips.ips_site_id = 'frwiki' THEN 1 ELSE 0 END) AS french 

FROM (SELECT * FROM wikidatawiki_p.wb_items_per_site) AS ips  

WHERE ips.ips_item_id IS NOT NULL  

GROUP BY ips.ips_item_id  

ORDER BY qid;