Untitled query #23548

SQL

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

Checking query status...
