Warning: include(common.php): failed to open stream: No such file or directory in /home/httpd/vhosts/utou.ch/subdomains/opendata/httpdocs/glam/magnus-toolserver/test.php on line 3 Warning: include(common.php): failed to open stream: No such file or directory in /home/httpd/vhosts/utou.ch/subdomains/opendata/httpdocs/glam/magnus-toolserver/test.php on line 3 Warning: include(): Failed opening 'common.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /home/httpd/vhosts/utou.ch/subdomains/opendata/httpdocs/glam/magnus-toolserver/test.php on line 3
SELECT p1.page_title AS title,p1.page_id AS id,p1.page_namespace AS namespace FROM page p1,categorylinks c1 WHERE p1.page_id=c1.cl_from AND c1.cl_to='German_scientists' UNION SELECT p1.page_title AS title,p1.page_id AS id,p1.page_namespace AS namespace FROM page p1,categorylinks c1,page p2,categorylinks c2 WHERE p1.page_id=c1.cl_from AND c1.cl_to=p2.page_title AND p2.page_namespace=14 AND p2.page_id=c2.cl_from AND c2.cl_to='German_scientists' AND c2.cl_type='subcat' UNION SELECT p1.page_title AS title,p1.page_id AS id,p1.page_namespace AS namespace FROM page p1,categorylinks c1,page p2,categorylinks c2,page p3,categorylinks c3 WHERE p1.page_id=c1.cl_from AND c1.cl_to=p2.page_title AND p2.page_namespace=14 AND p2.page_id=c2.cl_from AND c2.cl_to=p3.page_title AND c2.cl_type='subcat' AND p3.page_namespace=14 AND p3.page_id=c3.cl_from AND c3.cl_to='German_scientists' AND c3.cl_type='subcat' UNION SELECT p1.page_title AS title,p1.page_id AS id,p1.page_namespace AS namespace FROM page p1,categorylinks c1,page p2,categorylinks c2,page p3,categorylinks c3,page p4,categorylinks c4 WHERE p1.page_id=c1.cl_from AND c1.cl_to=p2.page_title AND p2.page_namespace=14 AND p2.page_id=c2.cl_from AND c2.cl_to=p3.page_title AND c2.cl_type='subcat' AND p3.page_namespace=14 AND p3.page_id=c3.cl_from AND c3.cl_to=p4.page_title AND c3.cl_type='subcat' AND p4.page_namespace=14 AND p4.page_id=c4.cl_from AND c4.cl_to='German_scientists' AND c4.cl_type='subcat' UNION SELECT p1.page_title AS title,p1.page_id AS id,p1.page_namespace AS namespace FROM page p1,categorylinks c1,page p2,categorylinks c2,page p3,categorylinks c3,page p4,categorylinks c4,page p5,categorylinks c5 WHERE p1.page_id=c1.cl_from AND c1.cl_to=p2.page_title AND p2.page_namespace=14 AND p2.page_id=c2.cl_from AND c2.cl_to=p3.page_title AND c2.cl_type='subcat' AND p3.page_namespace=14 AND p3.page_id=c3.cl_from AND c3.cl_to=p4.page_title AND c3.cl_type='subcat' AND p4.page_namespace=14 AND p4.page_id=c4.cl_from AND c4.cl_to=p5.page_title AND c4.cl_type='subcat' AND p5.page_namespace=14 AND p5.page_id=c5.cl_from AND c5.cl_to='German_scientists' AND c5.cl_type='subcat' ORDER BY title