errorSELECT * FROM profile as p, registration as r WHERE p.userid= r.userid AND `approved`=1 AND `visible`=1 AND r.email!='' AND `gender`='male' AND `confirm`='1' order by r.last_visit DESC limit 120, 20Column 'confirm' in where clause is ambiguous