1 457 ---------------------------------------------------------------------------------------------------- insert into `condition3etape1` select `email`, `C1`, `C2`, `C3`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape2` select `email`, `C1`, `C2`, `C4`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape3` select `email`, `C1`, `C2`, `C5`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a; insert into `condition3etape4` select `email`, `C1`, `C3`, `C4`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a; insert into `condition3etape5` select `email`, `C1`, `C3`, `C5`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape6` select `email`, `C1`, `C4`, `C5`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape7` select `email`, `C2`, `C3`, `C4`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape8` select `email`, `C2`, `C3`, `C5`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a; insert into `condition3etape9` select `email`, `C2`, `C4`, `C5`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a; insert into `condition3etape10` select `email`, `C3`, `C4`, `C5`, null, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape11` select `email`, `C1`, `C2`, `C3`, C4, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape12` select `email`, `C2`, `C2`, `C3`, C5, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape13` select `email`, `C1`, `C2`, `C4`, C5, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a; insert into `condition3etape14` select `email`, `C1`, `C3`, `C4`, C5, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a; insert into `condition3etape15` select `email`, `C2`, `C3`, `C4`, C5, null, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; insert into `condition3etape16` select `email`, `C1`, `C2`, `C3`, C4, C5, `C6`, `C7`, `C8`, `C9`, `C10`, `C11`, `C12`, `C13`, `C14`, `C15`, `C16`, `C17`, `C18`, `C19`, `C20`, `Numero`, `SENS`, `VALEUR`, `OBSERVATION`, `confiance` from condition3etape1a ; ---------------------------------------------------------------------------------------------------- drop table conditions_compresse_bis ; drop table consensus ; drop table peel_categories ; drop table info; drop table pays; drop table preference; drop table preference_prono2_user; drop table preference_prono3_user ; drop table preference_prono4_user; drop table preference_prono5_user; drop table preference_visiteur ; drop table pronostiqueur ; drop table req_conditions ; drop table sens_conditions; drop table synthese_presse; drop table ticket_editors; drop table ticket_messages ; drop table tickets; drop table type_course ; drop table utilisateurs; drop table valeuretapeinitialzero; drop table; drop table drop table drop table ========================================= 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` = 13 AND `deuxieme` = 8 AND `troisieme` = 4 AND `quatrieme` = 3 AND `cinquieme` =10 **************************************************************************************************************** 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`) ;