Cover URL per SQL abfrage auslesen

[EikeBrandtWarneke]

SELECT media.path
FROM product
    LEFT JOIN product_media
        ON product.cover = product_media.id AND product.version_id = product_media.product_version_id AND product_media.version_id = LIVE_VERSION
    LEFT JOIN media
        ON product_media.media_id = media.id
WHERE
    product.version_id = LIVE_VERSION

Viele Grüße