PHP MYSQL Opposite selection
$line = @mysql_query("SELECT * FROM clips, userclips
WHERE userclips.userid='$id' AND
userclips.clipid=clips.id ORDER BY clips.title");

$line = @mysql_query("SELECT DISTINCT * FROM clips, userclips
WHERE userclips.userid!='$id' AND userclips.clipid=clips.id ORDER BY clips.title");

$line = @mysql_query("SELECT DISTINCT * FROM clips WHERE clips.id
 NOT IN (SELECT clipid FROM userclips WHERE userid='$id') ORDER BY clips.title");

SELECT * FROM clips, userclips
WHERE userclips.userid!='$id'
ORDER BY clips.title

Select * from  clips where id NOT IN
(
 SELECT clips.id FROM clips, userclips
 WHERE userclips.userid='$id' AND
 userclips.clipid=clips.id ORDER BY clips.title
)