insert into `quinte` select `Num_ordre`,`premier`,`deuxieme`,`troisieme`,`quatrieme`,`cinquieme`,`email` from toutes_combinaisons_quinte


georges.goli@orange.com


contact : 08-34-77-98 jean cjzrche protocole

KOUAKOU 01 05 03 37
ABALI 08 87 73 84 / 

delete FROM `toutes_combinaisons_TIERCE` WHERE  `Num_ordre` <> 279

delete FROM `toutes_combinaisons_quinte` WHERE  `Num_ordre` <> 220
-------------------------------------------------

select * FROM `toutes_combinaisons_tierce` 
  WHERE `premier`      =10
  AND `deuxieme`      =7
  AND `troisieme`    = 13

***************************
86/37/14
*****************

02 05 59 79 KAPO
*******************************


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



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



SELECT * FROM `toutes_combinaisons_tierce` WHERE EMAIL='KOKANP@HOTMAIL.COM' ORDER BY OCCURENCE

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


SELECT * FROM `toutes_combinaisons_quinte` WHERE EMAIL='A' ORDER BY `etape_valide`


SELECT * FROM `toutes_combinaisons_quinte` WHERE EMAIL='KOKANP@HOTMAIL.COM' ORDER BY `etape_valide`

5.3330222,-4.0293565,15


	77 96 96 41 chantou
robert 40 31 63 35
--------------------------

SELECT * FROM etape_courante

SELECT DISTINCT `numero_etape`,`occurence` FROM `combinaisons_tierce_eliminees` 


SELECT DISTINCT `numero_etape`,`occurence` FROM `combinaisons_quinte_eliminees` 

       UPDATE toutes_combinaisons_quinte SET etape_valide = 0 ;
       UPDATE `kokanturf`.`etape_courante` SET `etape` = 1 ;
       TRUNCATE TABLE `combinaisons_quinte_eliminees` ;



------------POUR RE INJECTER LA COMBIANISON GAGNANTE----------------------

       DELETE FROM  valeuretapeinitialzero ;
       UPDATE toutes_combinaisons_tierce SET etape_valide = 0 ;
       UPDATE `kokanturf`.`etape_courante` SET `etape` = 
      ( select numero_etape from combinaisons_tierce_eliminees where numero_etape = ( select min(numero_etape) from combinaisons_tierce_eliminees ) );
        TRUNCATE TABLE `combinaisons_tierce_eliminees` ;



 	DELETE FROM  valeuretapeinitialzero ;
       UPDATE toutes_combinaisons_quinte SET etape_valide = 0 ;
       UPDATE `kokanturf`.`etape_courante` SET `etape` = 
      ( select numero_etape from combinaisons_quinte_eliminees where numero_etape = ( select min(numero_etape) from combinaisons_quinte_eliminees ) );
        TRUNCATE TABLE `combinaisons_quinte_eliminees` ;


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

       
	insert into toutes_combinaisons_quinte 
( `Num_ordre`, `premier`, `deuxieme`, `troisieme`,quatrieme,cinquieme, `email`, `occurence`)
	SELECT `Num_ordre`, `premier`, `deuxieme`, `troisieme`,quatrieme,cinquieme, `email`, `occurence`
  FROM  combinaisons_quinte_eliminees 	
	 WHERE `premier`     = 14
 		   AND `deuxieme`    = 9
		    AND `troisieme`  = 3
                     AND `quatrieme`  = 13
                      AND `cinquieme`  =1

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



update `VALEURETAPEINITIALZERO` set type_course ='XXXXX' WHERE  
ETAPE NOT IN ( SELECT numero_etape from combinaisons_quinte_eliminees )


update `VALEURETAPEINITIALZERO` set type_course ='QUINTE'