100 fai



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


DELETE FROM valeuretape;




SELECT * FROM `toutes_combinaisons_tierce`  WHERE 

     `premier`     =  12
 AND `deuxieme`    = 10
 AND `troisieme`   =  18

**************************************************

SELECT * FROM  combinaisons_tierce_eliminees
WHERE 

     `premier`     =  12	
 AND `deuxieme`    =  10
 AND `troisieme`   =  18

*********************************************




 delete  FROM `toutes_combinaisons_tierce` WHERE EMAIL='A'


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


select * FROM `toutes_combinaisons_couple` WHERE 
( Num_ordre= 24
or
 Num_ordre= 28
 or
 Num_ordre= 109
)
 and email='A'

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

POUR RE INJECTER LA COMBIANISON GAGNANTE ET TESTER

insert into `toutes_combinaisons_tierce` ( `Num_ordre`, `premier`, `deuxieme`, `troisieme`, `email`, `occurence`)

SELECT  `Num_ordre`, `premier`, `deuxieme`, `troisieme`, `email`, `occurence` FROM  combinaisons_tierce_eliminees
WHERE `premier`     = 12
 AND `deuxieme`    =  10
 AND `troisieme`   =  18

-------------------------------------------------------------------

COUPLE A SUIVRE

SELECT `premier` FROM `toutes_combinaisons_couple` 
UNION
SELECT `DEUXIEME` FROM `toutes_combinaisons_couple` 
GROUP BY PREMIER