Untitled query #1276

SQL

# query by User:Vahurzpu
use commonswiki_p;
SELECT DISTINCT categorylinks.cl_to, page_props.pp_value
FROM categorylinks
INNER JOIN page ON categorylinks.cl_to = page.page_title
INNER JOIN page_props ON page_props.pp_page = page.page_id
WHERE categorylinks.cl_from IN
(
  SELECT page.page_id
  FROM categorylinks
  INNER JOIN page ON categorylinks.cl_from = page.page_id
  WHERE categorylinks.cl_to = "Roses_in_the_Kyoto_Botanical_Garden"
  AND page.page_namespace = 6
)
AND categorylinks.cl_to LIKE "Rosa_'%"
AND page_props.pp_propname = "wikibase_item"
SQL

Checking query status...
