Untitled query #23548

SQL

USE cswiki_p;
SELECT DISTINCT SUBSTRING_INDEX(pl_title, '_(', 1) AS title, IF(page_title IS NULL, 0, 1) AS page_exists
FROM pagelinks
LEFT JOIN page ON page_title = pl_title AND page_namespace = pl_namespace
WHERE pl_namespace = 0 AND pl_title LIKE '%&_(film)' ESCAPE '&';
SELECT DISTINCT pl_title, SUBSTRING_INDEX(pl_title, '_(', 1) AS title, IF(page_title IS NULL, 0, 1) AS page_exists
FROM pagelinks
LEFT JOIN page ON page_title = pl_title AND page_namespace = pl_namespace
WHERE pl_namespace = 0 AND pl_title LIKE '%&_(film,%)' ESCAPE '&';
/*SELECT * FROM (
  #SELECT DISTINCT SUBSTRING_INDEX(page_title, '_(', 1) AS title, 1 AS page_exists
  #FROM page
  #WHERE page_namespace = 0 AND page_title LIKE '%&_(film)' ESCAPE '&'
  #UNION
  SELECT DISTINCT SUBSTRING_INDEX(pl_title, '_(', 1) AS title, IF(page_title IS NULL, 0, 1) AS page_exists
  FROM pagelinks
  LEFT JOIN page ON page_title = pl_title AND page_namespace = pl_namespace
  WHERE pl_namespace = 0 AND pl_title LIKE '%&_(film)' ESCAPE '&'
) AS simple, (
  #SELECT DISTINCT page_title, SUBSTRING_INDEX(page_title, '_(', 1) AS title, 1 AS page_exists
  #FROM page
  #WHERE page_namespace = 0 AND page_title LIKE '%&_(film,%)' ESCAPE '&'
  #UNION
  SELECT DISTINCT pl_title, SUBSTRING_INDEX(pl_title, '_(', 1) AS title, IF(page_title IS NULL, 0, 1) AS page_exists
  FROM pagelinks
  LEFT JOIN page ON page_title = pl_title AND page_namespace = pl_namespace
  WHERE pl_namespace = 0 AND pl_title LIKE '%&_(film,%)' ESCAPE '&'
) AS complex
WHERE simple.title = complex.title
LIMIT 1;*/
SQL

Checking query status...
