SELECT
    id
FROM
    pictures
WHERE
    id NOT IN
(
    SELECT
        p.id
    FROM
        pictures as p
    LEFT JOIN
        ratings as r
    ON
        (p.id = r.picture_id)
    WHERE
        r.user_id = 1
);