SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
            FROM `ps_image` i
             INNER JOIN ps_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
            INNER JOIN ps_image_product_lang ipl ON (i.id_image = ipl.id_image AND ipl.id_lang = 1)
            LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
            WHERE i.`id_product` = 23588
            ORDER BY `position`