DECLARE

    vid numeric DEFAULT 452;

CURSOR cur IS
SELECT
c.id
FROM contest c
inner join tournament_contest tc ON (c.id = tc.contest_id)
left join video_contest vc ON (c.id = vc.contest_id)
WHERE
tc.tournament_id = 1
AND c.stats_inc_game_id IS NOT NULL
AND video_id IS NULL;

BEGIN
FOR rec IN cur LOOP
    DBMS_OUTPUT.put_line(rec.id);
    FOR idx IN 1..7 LOOP
        DBMS_OUTPUT.put_line(idx);
        INSERT INTO video_contest (id, contest_id, video_id) VALUES (vid, rec.id, idx);
        vid := vid + 1;
    END LOOP;
END LOOP;

END;