https://bugzilla.wikimedia.org/show_bug.cgi?id=59392

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Ineuw <in...@aei.ca>
Date: Tue, 21 Feb 2012 09:00:00
-------------------------------------------------------------------------------

Please rerun this query as you did a year ago. The difference is that I
expanded the volume range from 1 to 50. All other parameters and details are
the same. Please see below, Thank you.

SELECT page.page_title FROM categorylinks INNER JOIN page ON page.page_id =
categorylinks.cl_from WHERE cl_to IN (  
'Popular_Science_Monthly_Volume_1',  
'Popular_Science_Monthly_Volume_2',  
/* ... */  
'Popular_Science_Monthly_Volume_50') AND page.page_namespace = 0;

SELECT dbq136.page_title, categorylinks.cl_to FROM u_hoo.dbq136 INNER JOIN page
ON dbq136.page_title = page.page_title INNER JOIN categorylinks ON
categorylinks.cl_from = page.page_id WHERE page.page_namespace = 0;

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to