Untitled query #72607

SQL

SELECT  SUM(CASE WHEN LOWER(page_content) LIKE '%far-right%' THEN 1 ELSE 0 END) AS far_right_count,  SUM(CASE WHEN LOWER(page_content) LIKE '%far-left%' THEN 1 ELSE 0 END) AS far_left_countFROM  (SELECT    p.page_id,    p.page_title,    CONVERT(p.page_title USING utf8) AS page_content  FROM    page AS p  JOIN    categorylinks AS cl ON p.page_id = cl.cl_from  WHERE    p.page_namespace = 0 AND    cl.cl_to = 'American_biographies') AS subquery;SELECT  SUM(CASE WHEN LOWER(page_content) LIKE '%far-right%' THEN 1 ELSE 0 END) AS far_right_count,  SUM(CASE WHEN LOWER(page_content) LIKE '%far-left%' THEN 1 ELSE 0 END) AS far_left_countFROM  (SELECT    p.page_id,    p.page_title,    CONVERT(p.page_title USING utf8) AS page_content  FROM    page AS p  JOIN    categorylinks AS cl ON p.page_id = cl.cl_from  WHERE    p.page_namespace = 0 AND    cl.cl_to = 'American_biographies') AS subquery;
SQL

Checking query status...
