Rose cultivars in Category:Roses at Roseraie de Bagatelle

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 categorylinks.cl_to FROM categorylinks 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)

AخA
 
use commonswiki_p;SELECT categorylinks.cl_to FROM categorylinks 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)

SQL

Checking query status...