SELECT
  a.itemid
FROM
  (
    SELECT
      itemid
    FROM
      masterdb.`iteminfo`
    WHERE
      spid IN (52866)
  ) a
  LEFT JOIN masterdb.`item_channel_w1` w ON a.itemid = w.itemid
WHERE
  w.itemid IS NULL