Ошибка при выполнении запроса Select, "Операнд должен содержать 1 колонок".

Как можно по быстрому поправить и в чем дело?

Select x.id_dish, x.dish_name
from dish x
where x.dish_name not in
(select y.id_dish
from recipe y)
or x.id_dish in
(select z.id_dish,
count(z.id_product) as 'z.products_in_dish'
from recipe z
Group By x.id_dish
Having count(x.id_dish)=1
and 'z.id_product' in
(select a.id_product
from product a
where
a.product_calories<50))