SELECT a.row_id, a.sku, a.type_id
FROM `catalog_product_entity` AS a
LEFT JOIN `catalog_product_entity_media_gallery_value_to_entity` AS b
    ON a.row_id = b.row_id
WHERE b.value_id IS NULL;