delete FROM `toutes_combinaisons_QUINTE` WHERE  `Num_ordre` <> 38
-------------------------------------------------

select * FROM `toutes_combinaisons_quinte` 
  WHERE `premier`      =5
  AND `deuxieme`      =10
  AND `troisieme`    = 6
  AND `quatrieme`     =1
  AND `cinquieme`     =2



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

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

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


	77 96 96 41 chantou

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

SELECT * FROM etape_courante



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

       DELETE FROM `valeuretape`; 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`     = 10
 		   AND `deuxieme`    = 8
		    AND `troisieme`  = 4
                     AND `quatrieme`  = 15
                      AND `cinquieme`  =9

************************************************************************************************************************
	02 54 44 27




stop a 

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

  	-- importer la table valeuretape;

	UPDATE `kokanturf`.`etape_courante` SET `etape` = 414;
	delete from toutes_combinaisons_tierce;
	insert into  toutes_combinaisons_tierce  select * from 000etape3;













  delete FROM `toutes_combinaisons_tierce` WHERE EMAIL='A';
  update `toutes_combinaisons_tierce` set email='A';
  UPDATE `kokanturf`.`etape_courante` SET `etape` = 41 ;








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

DROP TABLE `condition3etape5 (2)`, `condition3etape8`, `condition3etape9`, `condition3etape10`, `condition3etape11`, `condition3etape12`, `condition3etape13`, `condition3etape14`, `condition3etape15`, `condition3etape16`, `condition3etape17`, `condition3etape18`, `condition3etape19`, `condition3etape20`, `condition3etape21`, `condition3etape22`, `condition3etape23`, `condition3etape24`, `condition3etape25`, `condition3etape26`, `condition3etape27`, `condition3etape28`, `condition3etape29`, `condition3etape30`, `condition3etape31`, `condition3etape32`, `condition3etape33`, `condition3etape34`, `condition3etape35`, `condition3etape36`, `condition3etape37`, `condition3etape38`, `condition3etape39`, `condition3etape40`;

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

select `arrivee`.`date_course` AS `date_course`,`arrivee`.`premier` AS `premier`,`arrivee`.`deuxieme` AS `deuxieme`,`arrivee`.`troisieme` AS `troisieme`,`arrivee`.`quatrieme` AS `quatrieme`,`arrivee`.`cinquieme` AS `cinquieme` from `arrivee` where ((`arrivee`.`premier` <> 0) and (`arrivee`.`deuxieme` <> 0) and (`arrivee`.`troisieme` <> 0) and (`arrivee`.`quatrieme` <> 0) and (`arrivee`.`cinquieme` <> 0) and ((`arrivee`.`id` + (5 * 360)) > (select `arrivee`.`id` from `arrivee` where (`arrivee`.`date_course` = (select `preference`.`DATE_COURSE` from `preference` where (`preference`.`email` = 'KOKANP@HOTMAIL.COM'))))) and ((`arrivee`.`id` + (4 * 360)) < (select `arrivee`.`id` from `arrivee` where (`arrivee`.`date_course` = (select `preference`.`DATE_COURSE` from `preference` where (`preference`.`email` = 'KOKANP@HOTMAIL.COM'))))) 
and (`arrivee`.`date_course` <> (select `preference`.`DATE_COURSE` from `preference` where (`preference`.`email` = 'KOKANP@HOTMAIL.COM'))) 

and (`arrivee`.`date_course` < (select `preference`.`DATE_COURSE` from `preference` where (`preference`.`email` = 'KOKANP@HOTMAIL.COM')))) order by `arrivee`.`date_course` desc