where den yes koşulu çıkararak yapabilirin.Buyur

SELECT P.product_id,
P.product_title,
P.product_status,
P.product_author,
P.product_categories,
M.media_id,
M.media_thumb FROM zt_products P LEFT JOIN zt_media M ON P.product_id = M.own_id WHERE M.media_type = 'product'