SELECT DISTINCT(article.page_title)

FROM page AS article

JOIN page AS talk on article.page_title = talk.page_title

WHERE article.page_namespace = 0

AND article.page_is_redirect = 0

AND talk.page_namespace = 1

AND talk.page_is_redirect = 0

AND article.page_title LIKE "%assacre%"

AND (article.page_title IN (

    SELECT page_title

    FROM page

    JOIN categorylinks AS israel ON page_id = israel.cl_from AND israel.cl_to = "WikiProject_Israel_articles"

    JOIN categorylinks AS palestine ON page_id = palestine.cl_from AND palestine.cl_to = "WikiProject_Palestine_articles"

    WHERE page_namespace = 1

    AND page_is_redirect = 0

)

OR article.page_title IN (

  SELECT DISTINCT(page_title)

  FROM page

  JOIN templatelinks ON tl_from = page_id

  JOIN linktarget ON tl_target_id = lt_id

  WHERE page_namespace = 1

  AND page_is_redirect = 0

  AND lt_title in ('ArbCom_Arab-Israeli_enforcement', 'Contentious_topics/Arab-Israeli_talk_notice')

  AND lt_namespace = 10

  AND tl_from_namespace = 1

))