update query setcover

UPDATE advertises_media
SET is_cover = true
WHERE (advertises_id, id) IN (
    SELECT advertises_id, MIN(id) as id
    FROM advertises_media
    GROUP BY advertises_id
);


UPDATE advertises_media
SET is_cover = true
WHERE (project_id, id) IN (
    SELECT project_id, MIN(id) as id
    FROM advertises_media
    GROUP BY project_id
);