combinaison du 10/07/2022 4 -2 - 5 ========================================= insert into `quinte` select `Num_ordre`,`premier`,`deuxieme`,`troisieme`,`quatrieme`,`cinquieme`,`email` from toutes_combinaisons_quinte contact : 08-34-77-98 jean cjzrche protocole 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 ***************** 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` 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` ; SELECT * FROM etape_courante ------------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 ='KOKAN' where etape not in ( select numero_etape from combinaisons_tierce_eliminees ) update `VALEURETAPEINITIALZERO` set type_course ='XXXXX' WHERE ETAPE NOT IN ( SELECT numero_etape from combinaisons_quinte_eliminees ) ********************************************************************************************************************* CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne21` AS SELECT * FROM prono1 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne21`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne22` AS SELECT * FROM prono1 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne22`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne23` AS SELECT * FROM prono1 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne23`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne24` AS SELECT * FROM prono1 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne24`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne25` AS SELECT * FROM prono1 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne25`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne26` AS SELECT * FROM prono4 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne26`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne27` AS SELECT * FROM prono4 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne27`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne28` AS SELECT * FROM prono4 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne28`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne29` AS SELECT * FROM prono4 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne29`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne30` AS SELECT * FROM prono4 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne30`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne31` AS SELECT * FROM prono2 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne31`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne32` AS SELECT * FROM prono2 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne32`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne33` AS SELECT * FROM prono2 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne33`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne34` AS SELECT * FROM prono2 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne34`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne35` AS SELECT * FROM prono2 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne35`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne36` AS SELECT * FROM prono5 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne36`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne37` AS SELECT * FROM prono5 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne37`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne38` AS SELECT * FROM prono5 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne38`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne39` AS SELECT * FROM prono5 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne39`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne40` AS SELECT * FROM prono5 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne40`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne41` AS SELECT * FROM prono3 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne41`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne42` AS SELECT * FROM prono3 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne42`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne43` AS SELECT * FROM prono3 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne43`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne44` AS SELECT * FROM prono3 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne44`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne45` AS SELECT * FROM prono3 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne45`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne46` AS SELECT * FROM prono6 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne46`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne47` AS SELECT * FROM prono6 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne47`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne48` AS SELECT * FROM prono6 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne48`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne49` AS SELECT * FROM prono6 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne49`) ; CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW `complement_ligne50` AS SELECT * FROM prono6 WHERE pronostiqueur NOT IN ( SELECT pronostiqueur FROM `ligne50`) ;