Cacher is the code snippet organizer for pro developers

SELECT * FROM mg_catalog_product_entity_media_gallery as mcpemg
LEFT JOIN  mg_catalog_product_entity_media_gallery_value mcpemgv on mcpemg.value_id = mcpemgv.value_id
LEFT JOIN mg_catalog_product_entity mcpe on mcpemgv.entity_id = mcpe.entity_id
WHERE mcpe.entity_id = 7901;