SELECT
                media_path  AS p,
                media_file  AS f,
                media_meta_legend AS u,
                media_meta_label AS l
            FROM
                media 
            LEFT JOIN
                media_meta
            ON  media_meta_media_fk = media_id
            WHERE
                media_path LIKE 'media/partenaires-2017/400-%'
            AND media_is_image
            AND media_active
            AND media_meta_lang_fk = 1
            ORDER BY
                media_order