select distinct chiens.`uid`,chiens.`lof`,chiens.`nom`,chiens.`affixe`,chiens.`sexe`,chiens.`date_confirmation`,chiens.`confirme` from chiens where (chiens.pere_uid in (select uid from chiens where pere_uid= or mere_uid=)
or chiens.mere_uid in (select uid from chiens where pere_uid= or mere_uid=)) and confirme!='REFUS' and confirme!='' ORDER BY lof LIMIT 0,25
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or mere_uid=)
or chiens.mere_uid in (select uid from chiens where pere_uid= or ' at line 1