Untitled query #16714

SQL

select 
  cat_title, 
  concat("P", l.term_entity_id) as property, 
  cat_pages, 
  l.term_text, 
  d.term_text 
from 
  category,
  wikidatawiki_p.wb_terms as l 
  LEFT JOIN wikidatawiki_p.wb_terms as d 
  ON 
    l.term_entity_id=d.term_entity_id 
    and l.term_entity_type=d.term_entity_type 
    and l.term_language=d.term_language 
    and d.term_type="description" 
 where 
   cat_title regexp "Page_utilisant_P[0-9]" 
   and cat_title=concat("Page_utilisant_P",l.term_entity_id) 
   and l.term_entity_type="property" 
   and l.term_language="en" 
   and l.term_type IN ("label") 
group by cat_title
SQL

Checking query status...
