--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: WOSlinker <>
Date: Sat, 05 Feb 2011 22:36:01

Thanks for running it. Unfortunatly, it didn't quite return the results I was
after as it listed all categories with template in the name. The exists part
didn't work properly. I think I should have put in an underscore rather than a

SELECT page_title  
FROM page AS p  
WHERE page_namespace = 14  
AND page_title like '%template%'  
AND NOT EXISTS (SELECT 1 FROM templatelinks AS tl  
WHERE tl.tl_from = p.page_id  
AND tl.tl_namespace = 10  
AND tl.tl_title = 'Template_category')

Could you run it again?

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to