编辑代码

SELECT
  i.ItemID
FROM
  masterdb.`item_channel_w1` w
  JOIN iteminfo i ON i.`ItemID` = w.itemid
  AND w.channelcode = 'op'
where
  w.statusid = 1
  and i.statusid = 404
GROUP BY
  i.ItemID