Duplicates in pictures table

select
p1.id as pix1_id,
p2.id as pix2_id
from
pixpair p1,
pixpair p2
where
p1.pic1_id = p2.pic2_id and p1.pic2_id = p2.pic1_id;
should show dupliacates..

select * from pixpair
where (pic1_id = _new_pic_id and pic2_id = allpics.id)
or (pic2_id = _new_pic_id and pic1.id = allpics.id) ) );