SELECT * FROM `toutes_combinaisons_couple` WHERE EMAIL='A' ORDER BY OCCURENCE





      SELECT * FROM `toutes_combinaisons_tierce` WHERE EMAIL='A' ORDER BY OCCURENCE



SELECT * FROM `toutes_combinaisons_tierce`  WHERE 

     `premier`     =  4
 AND `deuxieme`    = 13
 AND `troisieme`   =  5






 delete  FROM `toutes_combinaisons_tierce` WHERE `Num_ordre`<> 4


///////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////


select * FROM `toutes_combinaisons_couple` WHERE 
( Num_ordre= 45 or
 Num_ordre=49 or
 Num_ordre=79 ) and email='A'

////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////