No-Tactic, как то так
mysql_query("select `applications`.`id1`, `applications`.`id2` from `applications` join `duel` on (`applications`.`id1`=`duel`.`id1` or `applications`.`id2`=`duel`.`id2`) and `applications`.`id1`=$id and `duel`.`id1`=$id limit 1);