Find images with description

SQL

#USE dewiki_p;
use commonswiki_p;
#SELECT pl_title, pl_namespace, page_namespace FROM pagelinks INNER JOIN page ON pl_from=page_id WHERE page_title = 'Wolgast' 
#show tables;
#describe image;
Select img_name, img_description, img_user_text from image where im_media_type='BITMAP' and img_major_mime = 'image' limit 100;
#describe imagelinks;
#describe page_props;
#select distinct pp_propname from page_props limit 100;
#select pp_value, pp_page  from page_props where pp_propname = "templatedata" limit 100;

SQL

Checking query status...