Untitled query #32087

SQL

#use metawiki_p;
#select * from sites;
use enwiki_p;
#SELECT page.page_namespace, page.page_title
#FROM page_props
#JOIN page ON
#  page.page_id = page_props.pp_page
#WHERE pp_propname='graph_specs'
#LIMIT 1;

SELECT page.page_namespace, page.page_title
WHERE page_title like 'User:AKosiaris_(WMF)%';

SELECT page.page_namespace, page.page_title, page_props.pp_value
FROM page_props
JOIN page ON
  page.page_id = page_props.pp_page
WHERE pp_propname='graph_specs'
AND page_title like 'User:AKosiaris_(WMF)%';
SQL

Checking query status...
