Rose cultivars in Category:Roses at Roseraie de Bagatelle

This query is marked as a draft This query has been published by Vahurzpu.

This query makes the assumption that any category starting with "Rosa_'" is a rose cultivar category. This is true at the moment, but could concievably become false. Also, if any cultivars don't use this scheme, it will fail.

Some of the results are also Wikimedia category QIDs rather than rose cultivar QIDs directly; following the category's main topic links requires a different query.

SQL

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_at_Roseraie_de_Bagatelle"
  AND page.page_namespace = 6
)
AND categorylinks.cl_to LIKE "Rosa_'%"
AND page_props.pp_propname = "wikibase_item"

AخA
 
use commonswiki_p;SELECT DISTINCT categorylinks.cl_to, page_props.pp_valueFROM categorylinksINNER JOIN page ON categorylinks.cl_to = page.page_titleINNER JOIN page_props ON page_props.pp_page = page.page_idWHERE 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_at_Roseraie_de_Bagatelle"  AND page.page_namespace = 6)AND categorylinks.cl_to LIKE "Rosa_'%"AND page_props.pp_propname = "wikibase_item"

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...