Created
January 16, 2023 13:07
-
-
Save TheStaticTurtle/520d2d60fc7fa74dad9956266cfeca7f to your computer and use it in GitHub Desktop.
Sonarr - C'est pas sorcier (It's not rocket science) - SQL Querry rename TBA episodes
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import requests | |
from bs4 import BeautifulSoup | |
import re | |
data = requests.get("https://thetvdb.com/series/its-not-rocket-science/allseasons/official").content | |
soup = BeautifulSoup(data, 'html.parser') | |
print("BEGIN TRANSACTION;") | |
for h4 in soup.find_all("h4", {"class": "list-group-item-heading"}): | |
season_episode = h4.find_next("span").text.replace("\n"," ").strip() | |
title = h4.find_next("a").text.replace("\n"," ").strip() | |
season_episode_m = re.findall(r"[E|S](\d+)", season_episode) | |
if len(season_episode_m) != 2: | |
print(f"# Failed: {season_episode} / {season_episode_m.groups()}") | |
exit() | |
season = int(season_episode_m[0]) | |
episode = int(season_episode_m[1]) | |
print(f"UPDATE Episodes SET Title=\"{title}\" WHERE SeasonNumber={season} AND EpisodeNumber={episode};") | |
print("COMMIT;") |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN TRANSACTION; | |
UPDATE Episodes SET Title="La science et le patrimoine" WHERE SeasonNumber=1993 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Le look" WHERE SeasonNumber=1993 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Descendre dans les entrailles de la Terre" WHERE SeasonNumber=1993 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Le feu" WHERE SeasonNumber=1993 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="L'intelligence" WHERE SeasonNumber=1993 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="La drogue" WHERE SeasonNumber=1993 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="L'Homme de Tautavel" WHERE SeasonNumber=1993 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="La face cachée de la matière vivante" WHERE SeasonNumber=1993 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Le sommeil : 30 ans de travaux forcés" WHERE SeasonNumber=1993 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="L'univers par le bout de la lorgnette" WHERE SeasonNumber=1993 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Quand les gênes s'en mêlent" WHERE SeasonNumber=1993 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Le sixième continent" WHERE SeasonNumber=1993 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="La dictature de la beauté" WHERE SeasonNumber=1993 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Les plus petites machines du monde" WHERE SeasonNumber=1993 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="La cité des Sciences et de l'Industrie" WHERE SeasonNumber=1994 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="La tactique des zygomatiques" WHERE SeasonNumber=1994 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Main basse sur la planète" WHERE SeasonNumber=1994 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Le spatiopitheque" WHERE SeasonNumber=1994 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="J.O. comment fabriquer un record ?" WHERE SeasonNumber=1994 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Les mondes virtuels" WHERE SeasonNumber=1994 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="La planète bouillante" WHERE SeasonNumber=1994 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="La mémoire de glace" WHERE SeasonNumber=1994 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Drôles de savants et drôles de machines" WHERE SeasonNumber=1994 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="La science pourra-t-elle faire la pluie et le beau temps" WHERE SeasonNumber=1994 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Projet ouest France" WHERE SeasonNumber=1994 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Le Concorde" WHERE SeasonNumber=1994 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Le soleil en rayon" WHERE SeasonNumber=1994 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Le tunnel sous la Manche" WHERE SeasonNumber=1994 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="La planète sous haute surveillance" WHERE SeasonNumber=1994 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="La mémoire retrouvée" WHERE SeasonNumber=1994 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Coup de vent sur la planète" WHERE SeasonNumber=1994 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Insectes : le retour" WHERE SeasonNumber=1994 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Sécurité automobile" WHERE SeasonNumber=1994 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Des histoires pas très claires... De lune" WHERE SeasonNumber=1994 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Ils courent ils courent les robots" WHERE SeasonNumber=1994 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Fusée Ariane" WHERE SeasonNumber=1994 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Le son en concert" WHERE SeasonNumber=1994 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les plus gros navires du monde" WHERE SeasonNumber=1994 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Sur le plancher des vaches" WHERE SeasonNumber=1994 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Les tours infernales" WHERE SeasonNumber=1994 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Ma poubelle vaut de l'or" WHERE SeasonNumber=1994 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Silence, on coule ! Les sous-marins." WHERE SeasonNumber=1994 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="L'hôpital de la tête au pied" WHERE SeasonNumber=1994 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="Électricité : quand les branchés disjonctent" WHERE SeasonNumber=1994 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="Au feu, les pompiers !" WHERE SeasonNumber=1994 AND EpisodeNumber=31; | |
UPDATE Episodes SET Title="Une affaire qui roule" WHERE SeasonNumber=1994 AND EpisodeNumber=32; | |
UPDATE Episodes SET Title="Lucy, Néandertal, Cro-Magnon" WHERE SeasonNumber=1994 AND EpisodeNumber=33; | |
UPDATE Episodes SET Title="Tous à vos postes" WHERE SeasonNumber=1994 AND EpisodeNumber=34; | |
UPDATE Episodes SET Title="Les plus grands manèges du monde" WHERE SeasonNumber=1994 AND EpisodeNumber=35; | |
UPDATE Episodes SET Title="A boire et à manger" WHERE SeasonNumber=1994 AND EpisodeNumber=36; | |
UPDATE Episodes SET Title="Un château très très fort" WHERE SeasonNumber=1994 AND EpisodeNumber=37; | |
UPDATE Episodes SET Title="Clef à molette, smoking, cambouis" WHERE SeasonNumber=1995 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="A fond de train" WHERE SeasonNumber=1995 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Quand les déboussolés perdent le Nord" WHERE SeasonNumber=1995 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Tous au charbon, une mine comment ça marche" WHERE SeasonNumber=1995 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Homo Orbitus : comment aller dans l'espace et y vivre ?" WHERE SeasonNumber=1995 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Les Sorciers font du ski" WHERE SeasonNumber=1995 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Alerte avalanche !" WHERE SeasonNumber=1995 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Au bout du fil... le téléphone" WHERE SeasonNumber=1995 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Les bébés : l'histoire d'une naissance" WHERE SeasonNumber=1995 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Nos vêtements... de fil en aiguille" WHERE SeasonNumber=1995 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Remettons nos pendules à l'heure" WHERE SeasonNumber=1995 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="L'imprimerie noir sur blanc... et en couleur" WHERE SeasonNumber=1995 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Vol au dessus d'un nid d'avions" WHERE SeasonNumber=1995 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="La vie d'un fleuve (la Seine)" WHERE SeasonNumber=1995 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="La plongée sous marine, un bol d'air dans le grand bleu" WHERE SeasonNumber=1995 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Que fait la Police dans ses Laboratoires" WHERE SeasonNumber=1995 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Faire la pluie et le beau temps" WHERE SeasonNumber=1995 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Faire du sport, c'est physique et chimique" WHERE SeasonNumber=1995 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="La pêche en mer... du filet à la criée" WHERE SeasonNumber=1995 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Pleins feux sur le système solaire" WHERE SeasonNumber=1995 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="La forêt enchantée, ça vous branche ?" WHERE SeasonNumber=1995 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Une journée à la ferme" WHERE SeasonNumber=1995 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="L’école est finie" WHERE SeasonNumber=1995 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Du vent dans les voiles (le Belem)" WHERE SeasonNumber=1995 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Coup de projecteur sur la Lumière" WHERE SeasonNumber=1995 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Faire un disque... Ca vous chante ?" WHERE SeasonNumber=1995 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Les rapaces" WHERE SeasonNumber=1995 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Le sel, de la terre à la mer" WHERE SeasonNumber=1995 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Descente au cœur d'un glacier" WHERE SeasonNumber=1995 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="Qui tient les cordons de la Bourse ?" WHERE SeasonNumber=1995 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="Roulez branchés : les voitures électriques" WHERE SeasonNumber=1995 AND EpisodeNumber=31; | |
UPDATE Episodes SET Title="Les centrales nucléaires" WHERE SeasonNumber=1995 AND EpisodeNumber=32; | |
UPDATE Episodes SET Title="Les déchets nucléaires" WHERE SeasonNumber=1995 AND EpisodeNumber=33; | |
UPDATE Episodes SET Title="Le SIDA" WHERE SeasonNumber=1995 AND EpisodeNumber=34; | |
UPDATE Episodes SET Title="Les Ponts" WHERE SeasonNumber=1995 AND EpisodeNumber=35; | |
UPDATE Episodes SET Title="Tu veux ma photo ?" WHERE SeasonNumber=1995 AND EpisodeNumber=36; | |
UPDATE Episodes SET Title="Le sucre, la culture de la betterave" WHERE SeasonNumber=1995 AND EpisodeNumber=37; | |
UPDATE Episodes SET Title="L’année des Sorciers" WHERE SeasonNumber=1995 AND EpisodeNumber=38; | |
UPDATE Episodes SET Title="Le dire c'est bien, le fer c'est mieux" WHERE SeasonNumber=1996 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Livre dans tous ses etats" WHERE SeasonNumber=1996 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Ici l'onde : la radio" WHERE SeasonNumber=1996 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Grottes, gouffres et abîmes" WHERE SeasonNumber=1996 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Oeil pour oeil" WHERE SeasonNumber=1996 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="L'ordinateur, tout un programme !" WHERE SeasonNumber=1996 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Histoires de Coeur" WHERE SeasonNumber=1996 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Les Sorciers se mettent au verre" WHERE SeasonNumber=1996 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="La tour Eiffel" WHERE SeasonNumber=1996 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Atmosphère, atmosphère (la pollution de l'air)" WHERE SeasonNumber=1996 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Par ici la Monnaie" WHERE SeasonNumber=1996 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Quel trafic !" WHERE SeasonNumber=1996 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="La traversée du désert" WHERE SeasonNumber=1996 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="L'oasis, une escale dans le désert" WHERE SeasonNumber=1996 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Silence on tourne ! (le Cinéma)" WHERE SeasonNumber=1996 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="L'Europe" WHERE SeasonNumber=1996 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Les avions de chasse" WHERE SeasonNumber=1996 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les barrages" WHERE SeasonNumber=1996 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Le marais poitevin" WHERE SeasonNumber=1996 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Chasseurs d'Épaves - Archéologie" WHERE SeasonNumber=1996 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Fourmis formidables" WHERE SeasonNumber=1996 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Tous à vos postes" WHERE SeasonNumber=1996 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Du blé au pain" WHERE SeasonNumber=1996 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="L'ascension du Mont-Blanc" WHERE SeasonNumber=1996 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Voyage dans l'invisible" WHERE SeasonNumber=1996 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Tous en Piste (le Cirque)" WHERE SeasonNumber=1996 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Le métro" WHERE SeasonNumber=1996 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Les coulisses d'un journal télévisé" WHERE SeasonNumber=1996 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Vin sur vin" WHERE SeasonNumber=1996 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="Ca gaz" WHERE SeasonNumber=1996 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="L'eau : ça coule de source" WHERE SeasonNumber=1996 AND EpisodeNumber=31; | |
UPDATE Episodes SET Title="Les Sorciers taillent la route" WHERE SeasonNumber=1996 AND EpisodeNumber=32; | |
UPDATE Episodes SET Title="Une nuit à Rungis: le plus grand marché du monde" WHERE SeasonNumber=1996 AND EpisodeNumber=33; | |
UPDATE Episodes SET Title="L'or c'est l'or !" WHERE SeasonNumber=1996 AND EpisodeNumber=34; | |
UPDATE Episodes SET Title="Noël à Saint-Véran" WHERE SeasonNumber=1996 AND EpisodeNumber=35; | |
UPDATE Episodes SET Title="Réveillon sous la neige" WHERE SeasonNumber=1997 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Un bruit qui court" WHERE SeasonNumber=1997 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="L'aventure de l'électricité" WHERE SeasonNumber=1997 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Au nom de la Loi" WHERE SeasonNumber=1997 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Le grand schuss" WHERE SeasonNumber=1997 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Sélection pour les Jeux Olympiques d'hiver" WHERE SeasonNumber=1997 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Les âges de la Vie" WHERE SeasonNumber=1997 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Les coulisses du Muséum (l'évolution)" WHERE SeasonNumber=1997 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Les Sorciers ne manquent pas d'air (l'aérodynamisme)" WHERE SeasonNumber=1997 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Sierra Leone : quand un pays a faim" WHERE SeasonNumber=1997 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Sur la route de Ouagadougou" WHERE SeasonNumber=1997 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Les Bâtisseurs de Cathédrales" WHERE SeasonNumber=1997 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Les Espions" WHERE SeasonNumber=1997 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="La Transat en solitaire" WHERE SeasonNumber=1997 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Des Hommes de toutes les couleurs" WHERE SeasonNumber=1997 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Il était toon fois... le Dessin Animé" WHERE SeasonNumber=1997 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="La savane au fond des bois" WHERE SeasonNumber=1997 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Le Débarquement de Normandie" WHERE SeasonNumber=1997 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="La vie d'un cheval" WHERE SeasonNumber=1997 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Qui miel me suive (les abeilles)" WHERE SeasonNumber=1997 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Une journée au bord de la mer (coquillages et crustacés)" WHERE SeasonNumber=1997 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Pas de saison pour les fleurs" WHERE SeasonNumber=1997 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Les satellites" WHERE SeasonNumber=1997 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les fous de vélo" WHERE SeasonNumber=1997 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Sur les traces des dinosaures" WHERE SeasonNumber=1997 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="A pied, à mob, en voiture... (la sécurité routière)" WHERE SeasonNumber=1997 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="La tête dans les étoiles" WHERE SeasonNumber=1997 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Le Mont Saint-Michel, contre vents et marées" WHERE SeasonNumber=1997 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Le cèpe à Sorciers (les champignons)" WHERE SeasonNumber=1998 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Les hélicoptères" WHERE SeasonNumber=1998 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Dans la ligne de MIR" WHERE SeasonNumber=1998 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Le Pétrole" WHERE SeasonNumber=1998 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Les plate-formes pétrolières" WHERE SeasonNumber=1998 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Les crocodiles, larmes fatales" WHERE SeasonNumber=1998 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="L'écriture de A à Z" WHERE SeasonNumber=1998 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Le Stade de France" WHERE SeasonNumber=1998 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Comme une lettre à La Poste" WHERE SeasonNumber=1998 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Les lasers" WHERE SeasonNumber=1998 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Voyage dans le cyber-espace" WHERE SeasonNumber=1998 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Le tennis" WHERE SeasonNumber=1998 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Drôles d'oiseaux (le Parc Ornithologique du Marquenterre)" WHERE SeasonNumber=1998 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Les marées noires" WHERE SeasonNumber=1998 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Tout feu, tout flamme (les feux de forêt)" WHERE SeasonNumber=1998 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Accordons nos Violons ! (l'Orchestre Symphonique)" WHERE SeasonNumber=1998 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="La plage" WHERE SeasonNumber=1998 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les porte-avions" WHERE SeasonNumber=1998 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Les primates" WHERE SeasonNumber=1998 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les robots" WHERE SeasonNumber=1998 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Les papillons" WHERE SeasonNumber=1998 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="La Loire n°1 (des sources à Orléans)" WHERE SeasonNumber=1998 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="La Loire n° 2 (d'Orléans à l'estuaire)" WHERE SeasonNumber=1998 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les ours" WHERE SeasonNumber=1998 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Les motos" WHERE SeasonNumber=1998 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="L'Automne" WHERE SeasonNumber=1998 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Les maladies génétiques" WHERE SeasonNumber=1998 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Le port spatial de Kourou : 1ère partie" WHERE SeasonNumber=1998 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Le port spatial de Kourou : 2ème partie" WHERE SeasonNumber=1998 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="Joyeux sorciers ! (la Villette 1)" WHERE SeasonNumber=1998 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="Bonne année, bons sorciers (la Villette 2)" WHERE SeasonNumber=1999 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="La radioactivité" WHERE SeasonNumber=1999 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Les Templiers partent en Croisade" WHERE SeasonNumber=1999 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Les phares" WHERE SeasonNumber=1999 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Un ferry pour l'Angleterre" WHERE SeasonNumber=1999 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Paris s'éveille (des Origines à Napoléon)" WHERE SeasonNumber=1999 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Paris Lumière (d'Haussmann au Périphérique)" WHERE SeasonNumber=1999 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="La vie extraterrestre" WHERE SeasonNumber=1999 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Vive la Presse ! (la fabrication d'un journal)" WHERE SeasonNumber=1999 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Les médicaments" WHERE SeasonNumber=1999 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Les oeufs" WHERE SeasonNumber=1999 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Entre chiens et loups" WHERE SeasonNumber=1999 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="La Peinture" WHERE SeasonNumber=1999 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="La Restauration des Oeuvres d'Art" WHERE SeasonNumber=1999 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Spéciale Kosovo" WHERE SeasonNumber=1999 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="La Cartographie" WHERE SeasonNumber=1999 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Écologie d'une mare" WHERE SeasonNumber=1999 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les parfums" WHERE SeasonNumber=1999 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Les châteaux de la Loire : la Renaissance" WHERE SeasonNumber=1999 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les ballons : c'est gonflé !" WHERE SeasonNumber=1999 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="La Provence" WHERE SeasonNumber=1999 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="La pêche : qui est au bout du fil ?" WHERE SeasonNumber=1999 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Les polders : de la terre gagnée sur la mer" WHERE SeasonNumber=1999 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Parachute, parapente : le grand frisson" WHERE SeasonNumber=1999 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Les Sorciers décrochent la Lune" WHERE SeasonNumber=1999 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="La Guerre de 14-18" WHERE SeasonNumber=1999 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Le téléphone portable" WHERE SeasonNumber=1999 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Les aéroports 1" WHERE SeasonNumber=1999 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Les aéroports 2" WHERE SeasonNumber=1999 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="Dans les Coulisses de l'Opéra" WHERE SeasonNumber=1999 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="Cacao et chocolat" WHERE SeasonNumber=1999 AND EpisodeNumber=31; | |
UPDATE Episodes SET Title="Les Mayas" WHERE SeasonNumber=2000 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Les sorciers à la neige" WHERE SeasonNumber=2000 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Le café: les Sorciers veillent au grain" WHERE SeasonNumber=2000 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Viva Mexico" WHERE SeasonNumber=2000 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Le tunnel sous la Manche (l'Eurotunnel)" WHERE SeasonNumber=2000 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Les filières de la viande" WHERE SeasonNumber=2000 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Le naufrage de l'Erika : la marée était en noir" WHERE SeasonNumber=2000 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Le monde des sourds" WHERE SeasonNumber=2000 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Rotterdam : le plus grand port du monde" WHERE SeasonNumber=2000 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="La grande lessive" WHERE SeasonNumber=2000 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Le cerveau 1 : les Sorciers se prennent la tête" WHERE SeasonNumber=2000 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Le cerveau 2 : j'ai la mémoire qui flanche" WHERE SeasonNumber=2000 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Les Sorciers refont le monde (histoire géologique de la Terre)" WHERE SeasonNumber=2000 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Les Landes : sous la forêt, la plage" WHERE SeasonNumber=2000 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="La Camargue : entre sel et terre" WHERE SeasonNumber=2000 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="La télévision numérique" WHERE SeasonNumber=2000 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Paillottes et crustacés" WHERE SeasonNumber=2000 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les dauphins, mammifères malins" WHERE SeasonNumber=2000 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="La transhumance" WHERE SeasonNumber=2000 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les voitures de course : les Sorciers ont la formule" WHERE SeasonNumber=2000 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Les araignées" WHERE SeasonNumber=2000 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Les sous-marins nucléaires" WHERE SeasonNumber=2000 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="La dissuasion nucléaire" WHERE SeasonNumber=2000 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les hommes préhistoriques" WHERE SeasonNumber=2000 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Le Néolithique : un tournant pour l'Humanité" WHERE SeasonNumber=2000 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Venise : une cité sortie des eaux" WHERE SeasonNumber=2000 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Sauver Venise" WHERE SeasonNumber=2000 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Les Gaulois" WHERE SeasonNumber=2001 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Le Musée des Inventions" WHERE SeasonNumber=2001 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Le Foch" WHERE SeasonNumber=2001 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Les félins" WHERE SeasonNumber=2001 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Les produits laitiers" WHERE SeasonNumber=2001 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Le Tabac" WHERE SeasonNumber=2001 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Attention, ça glace !" WHERE SeasonNumber=2001 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Le dernier charbon" WHERE SeasonNumber=2001 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="La nutrition : mangeons équilibré !" WHERE SeasonNumber=2001 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Le clonage" WHERE SeasonNumber=2001 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Le plastique, ça nous emballe !" WHERE SeasonNumber=2001 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Le vol en impesanteur" WHERE SeasonNumber=2001 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="L'aluminium" WHERE SeasonNumber=2001 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Le bois : hêtre ou ne pas hêtre" WHERE SeasonNumber=2001 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Le sommeil a rendez-vous avec la Lune" WHERE SeasonNumber=2001 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Les amphibiens" WHERE SeasonNumber=2001 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="La pierre : les Sorciers font carrières" WHERE SeasonNumber=2001 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Voix de fête" WHERE SeasonNumber=2001 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Pompéi" WHERE SeasonNumber=2001 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les OGM : du rififi dans les gènes" WHERE SeasonNumber=2001 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Les dirigeables, navires du ciel" WHERE SeasonNumber=2001 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Face aux phasmes" WHERE SeasonNumber=2001 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Les volcans, le grand show" WHERE SeasonNumber=2001 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="L'Etna, sous haute surveillance" WHERE SeasonNumber=2001 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="L'escalade : la bonne voie" WHERE SeasonNumber=2001 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Les canaux" WHERE SeasonNumber=2001 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Sang pour Sang" WHERE SeasonNumber=2001 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Champagne ! Les Sorciers se font mousser" WHERE SeasonNumber=2001 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="La vanille: un goût qui vient de loin" WHERE SeasonNumber=2001 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="La Réunion : une île sortie de l'océan" WHERE SeasonNumber=2001 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="Un petit coin de France sous les tropiques" WHERE SeasonNumber=2001 AND EpisodeNumber=31; | |
UPDATE Episodes SET Title="La truffe : à la poursuite du diamant noir" WHERE SeasonNumber=2002 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="La Planète sous toutes ses latitudes" WHERE SeasonNumber=2002 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="L'Euro est Arrivé !" WHERE SeasonNumber=2002 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Comètes et astéroïdes" WHERE SeasonNumber=2002 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Le magnétisme" WHERE SeasonNumber=2002 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Ski, surf and sun" WHERE SeasonNumber=2002 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="La canne à sucre" WHERE SeasonNumber=2002 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Dent pour dent" WHERE SeasonNumber=2002 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Écoute ce que je vois (les aveugles)" WHERE SeasonNumber=2002 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="La magie des effets spéciaux" WHERE SeasonNumber=2002 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Attention aux usines à risques !" WHERE SeasonNumber=2002 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Les Grands Vaisseaux des Rois" WHERE SeasonNumber=2002 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="L'eau en danger" WHERE SeasonNumber=2002 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Quand les camions prennent le train (le ferroutage)" WHERE SeasonNumber=2002 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Les courses hippiques" WHERE SeasonNumber=2002 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="L'effet de serre : coup de chaud sur la planète" WHERE SeasonNumber=2002 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Nouvelles énergies : la planète carbure au vert" WHERE SeasonNumber=2002 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les gorges de l'Ardèche : quelle descente !" WHERE SeasonNumber=2002 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Les Feux d'Artifice, c'est le Bouquet !" WHERE SeasonNumber=2002 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les serpents : des reptiles qui ont du charme" WHERE SeasonNumber=2002 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Les termites" WHERE SeasonNumber=2002 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Au coeur de la forêt tropicale" WHERE SeasonNumber=2002 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="L'Auvergne : une région qui a du cratère" WHERE SeasonNumber=2002 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les ferries" WHERE SeasonNumber=2002 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Les tortues : quand les carapaces passent" WHERE SeasonNumber=2002 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Le vol à voile : ça plane pour les Sorciers !" WHERE SeasonNumber=2002 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Le trésor des tourbières" WHERE SeasonNumber=2002 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Les Amérindiens de Guyane, des Peuples Oubliés" WHERE SeasonNumber=2002 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Noël, c’est complètement dinde !" WHERE SeasonNumber=2002 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="La Cappadoce : une région féerique" WHERE SeasonNumber=2002 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="Istanbul, c'est Byzance !" WHERE SeasonNumber=2003 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Mystérieuse mangrove" WHERE SeasonNumber=2003 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Des Sorciers bien dans leur peau" WHERE SeasonNumber=2003 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Le jeu de Loi (Les institutions de la Vème République)" WHERE SeasonNumber=2003 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Quand la terre tremble (les séismes)" WHERE SeasonNumber=2003 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Bille en tête : le billard" WHERE SeasonNumber=2003 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Histoires de Banlieues" WHERE SeasonNumber=2003 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Les Recettes du Marketing" WHERE SeasonNumber=2003 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="La grande Arche de La Défense" WHERE SeasonNumber=2003 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Les Sorciers coupent le cheveu en quatre" WHERE SeasonNumber=2003 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Le secourisme : les gestes qui sauvent" WHERE SeasonNumber=2003 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="La sculpture : les Sorciers sur la sellette" WHERE SeasonNumber=2003 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Muscles et souplesse : c'est pas de la gonflette !" WHERE SeasonNumber=2003 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Les gastéropodes : opération escargot" WHERE SeasonNumber=2003 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Une seconde vie pour nos poubelles" WHERE SeasonNumber=2003 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="L'estuaire de la Gironde" WHERE SeasonNumber=2003 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Un moustique : ça trompe énormément" WHERE SeasonNumber=2003 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="L'esturgeon : le poisson aux oeufs d'or" WHERE SeasonNumber=2003 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Sous le Soleil de Versailles" WHERE SeasonNumber=2003 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Un zoo pas si bête !" WHERE SeasonNumber=2003 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="L'Islande, terre de glace et de feu" WHERE SeasonNumber=2003 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Le caoutchouc : les Sorciers mettent la gomme" WHERE SeasonNumber=2003 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Les chauves-souris : le monde à l'envers !" WHERE SeasonNumber=2003 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Roulez plus propre !" WHERE SeasonNumber=2003 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="L'huître, un coquillage bien élevé" WHERE SeasonNumber=2003 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Le bêtisier des Sorciers" WHERE SeasonNumber=2003 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Le Père Noël, On ne lui fait pas de cadeaux !" WHERE SeasonNumber=2003 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Islande, une île qui souffle le chaud et le froid" WHERE SeasonNumber=2003 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Le TGV" WHERE SeasonNumber=2004 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Le nanomonde se secoue les puces" WHERE SeasonNumber=2004 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Les pneus : les Sorciers mettent la pression" WHERE SeasonNumber=2004 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Dans le coton, tout est bon !" WHERE SeasonNumber=2004 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Manon, Charlotte, Pompadour... Histoires de pommes de terre" WHERE SeasonNumber=2004 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Avalanches : neige à haut risque" WHERE SeasonNumber=2004 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Le dico : la langue française, les Sorciers jouent sur les Mots" WHERE SeasonNumber=2004 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Les stations de ski : les Sorciers ouvrent la piste" WHERE SeasonNumber=2004 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="L'anesthésie : vous pouvez dormir tranquille !" WHERE SeasonNumber=2004 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Le viaduc de Millau : les Sorciers font le pont" WHERE SeasonNumber=2004 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Les mammouths : la parole est à la défense" WHERE SeasonNumber=2004 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Le parc de la Vanoise : la montagne à tous les étages" WHERE SeasonNumber=2004 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Poulpe Fiction" WHERE SeasonNumber=2004 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="IMAX : le cinéma en très grand format" WHERE SeasonNumber=2004 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Les ocres annoncent la couleur" WHERE SeasonNumber=2004 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Le Grand Palais épate la Galerie" WHERE SeasonNumber=2004 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Les grands aquariums : une fenêtre sur l'océan" WHERE SeasonNumber=2004 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Le Very Large Telescope : l'univers dans un miroir" WHERE SeasonNumber=2004 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="La Sécurité Routière : les Sorciers savent conduire !" WHERE SeasonNumber=2004 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les antibiotiques : les bactéries font de la résistance !" WHERE SeasonNumber=2004 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="L'huile d'olive : l'huile au trésors" WHERE SeasonNumber=2004 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Les cervidés : drôle de brame" WHERE SeasonNumber=2004 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="L'INA : la mémoire de l'audiovisuel" WHERE SeasonNumber=2004 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Étretat : Les Sorciers attaquent la falaise" WHERE SeasonNumber=2004 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Bière qui roule n'amasse pas mousse" WHERE SeasonNumber=2004 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Atacama un désert entre les Andes et le Pacifique" WHERE SeasonNumber=2004 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Le bambou : une herbe géante !" WHERE SeasonNumber=2005 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Nos poumons: source d'inspiration" WHERE SeasonNumber=2005 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Les perroquets" WHERE SeasonNumber=2005 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="La pêche : les poissons ont le mal de mer" WHERE SeasonNumber=2005 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Le cuivre : Les bons tuyaux" WHERE SeasonNumber=2005 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Les gares : les Sorciers mènent bon train" WHERE SeasonNumber=2005 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="La conservation des aliments, c'est dans la boîte !" WHERE SeasonNumber=2005 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Les mystères de l'univers" WHERE SeasonNumber=2005 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Internet : les pirates tissent leur toile" WHERE SeasonNumber=2005 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Les chiens de traîneau, marathoniens des neiges" WHERE SeasonNumber=2005 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Portrait de la population : d'où viennent les Français ?" WHERE SeasonNumber=2005 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Résister au froid" WHERE SeasonNumber=2005 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="L'adolescence : vive la crise" WHERE SeasonNumber=2005 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="La France souterraine" WHERE SeasonNumber=2005 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Fruits et Légumes, un Jardin Extraordinaire" WHERE SeasonNumber=2005 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="C'est le Printemps" WHERE SeasonNumber=2005 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Phoques et otaries : A qui la palme ?" WHERE SeasonNumber=2005 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les moteurs d'avion : ça va décoller !" WHERE SeasonNumber=2005 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Les coulisses d'un concert : faites parler les décibels" WHERE SeasonNumber=2005 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les algues : une forêt sous la mer" WHERE SeasonNumber=2005 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Pont du Gard et Arènes de Nîmes : L'architecture gallo-romaine" WHERE SeasonNumber=2005 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Transports en commun : quand la ville change d'air !" WHERE SeasonNumber=2005 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Hannetons, coccinelles et scarabées... les coléoptères" WHERE SeasonNumber=2005 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les coraux : les Sorciers cherchent la petite bête" WHERE SeasonNumber=2005 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Les récifs coralliens: trésors en péril !" WHERE SeasonNumber=2005 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Île d'Ouessant : les Sorciers sont à l'ouest" WHERE SeasonNumber=2005 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Ah, les vaches !" WHERE SeasonNumber=2005 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Forces aériennes : les Sorciers partent en mission" WHERE SeasonNumber=2005 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Inondations : les Sorciers prennent l'eau" WHERE SeasonNumber=2005 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="La Nouvelle-Calédonie : un caillou sous les tropiques" WHERE SeasonNumber=2005 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="Le squelette : les Sorciers tombent sur un os" WHERE SeasonNumber=2006 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Le rallye dans le désert : les Sorciers roulent des mécaniques !" WHERE SeasonNumber=2006 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="La Terre vue de l'espace" WHERE SeasonNumber=2006 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Piles et batteries : les Sorciers se mettent au courant" WHERE SeasonNumber=2006 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="La météo : le bulletin des Sorciers" WHERE SeasonNumber=2006 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="L'obésité : nous risquons gros !" WHERE SeasonNumber=2006 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Le béton : les Sorciers au pied du mur" WHERE SeasonNumber=2006 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="La photo numérique : les Sorciers prennent une bonne résolution" WHERE SeasonNumber=2006 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Les Sorciers se font la main" WHERE SeasonNumber=2006 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Les autoroutes : les Sorciers font sauter les bouchons (la circulation routière)" WHERE SeasonNumber=2006 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="De la caméra au téléviseur : le voyage de l'image" WHERE SeasonNumber=2006 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Les eaux minérales : les Sorciers prennent de la bouteille" WHERE SeasonNumber=2006 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="La réserve sous-marine de Port-Cros" WHERE SeasonNumber=2006 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Le sable : les Sorciers veillent au grain" WHERE SeasonNumber=2006 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Les coulisses du football" WHERE SeasonNumber=2006 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Les Sorciers en pincent pour les crustacés" WHERE SeasonNumber=2006 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Sécheresse : la France en alerte" WHERE SeasonNumber=2006 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les fortifications de Vauban" WHERE SeasonNumber=2006 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Mouettes, goélands et Cie : Les oiseaux de mer" WHERE SeasonNumber=2006 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les grands cétacés, des géants vulnérables" WHERE SeasonNumber=2006 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="L'odyssée des plantes" WHERE SeasonNumber=2006 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Les bananes : les Sorciers à plein régime" WHERE SeasonNumber=2006 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Les grippes : virus sous surveillance" WHERE SeasonNumber=2006 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Roller, skate et BMX : comme sur des roulettes !" WHERE SeasonNumber=2006 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Les cactus : un sujet épineux..." WHERE SeasonNumber=2006 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Les nouvelles thérapies : l'espoir est dans la cellule" WHERE SeasonNumber=2006 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Le recul des glaciers" WHERE SeasonNumber=2006 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Que faire de nos déchets nucléaires ?" WHERE SeasonNumber=2006 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="L'énergie nucléaire" WHERE SeasonNumber=2007 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Energie nucléaire 2 : les déchets" WHERE SeasonNumber=2007 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="L'histoire du climat" WHERE SeasonNumber=2007 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Bio-habitat : la maison se met au vert" WHERE SeasonNumber=2007 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Le budget de l'État : les Sorciers font les comptes" WHERE SeasonNumber=2007 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Baleines en danger, c'est assez" WHERE SeasonNumber=2007 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Les céramiques : les Sorciers tournent autour du pot" WHERE SeasonNumber=2007 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="L'aventure de l'électricité (2007)" WHERE SeasonNumber=2007 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="La bipédie, c'est le pied !" WHERE SeasonNumber=2007 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Joie, peur, tristesse, colère, que d'émotions !" WHERE SeasonNumber=2007 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="L'électroménager: les Sorciers font bon ménage" WHERE SeasonNumber=2007 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Les bonbons : c'est si bon ?!" WHERE SeasonNumber=2007 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Les Casques Bleus : des soldats pour la paix" WHERE SeasonNumber=2007 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Rats, souris, hamsters… Les rongeurs se font les dents" WHERE SeasonNumber=2007 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Les céphalopodes" WHERE SeasonNumber=2007 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Les grandes orgues: Les Sorciers ont un tuyau" WHERE SeasonNumber=2007 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Mètre, kilo, seconde : Les Sorciers prennent des mesures" WHERE SeasonNumber=2007 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les cités englouties d'Egypte" WHERE SeasonNumber=2007 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Police Scientifique : les Sorciers mènent l’Enquête" WHERE SeasonNumber=2007 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Au coeur de l'Empire Inca" WHERE SeasonNumber=2007 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Les Champs-Elysées : Histoire de la plus belle avenue du monde" WHERE SeasonNumber=2007 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Le papier : il n'a pas toujours la fibre écologique (2007)" WHERE SeasonNumber=2007 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Les Sorciers jouent les Robinsons Crusoe" WHERE SeasonNumber=2007 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les vers, seigneurs des anneaux" WHERE SeasonNumber=2007 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Les luthiers, de l'arbre au violon" WHERE SeasonNumber=2007 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="L'homme dans l'espace : histoire d'une conquête" WHERE SeasonNumber=2007 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="La Polynésie : bienvenue au paradis" WHERE SeasonNumber=2007 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Les Incas : l'Empire du Soleil" WHERE SeasonNumber=2007 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="L'hydrogène, combustible du futur" WHERE SeasonNumber=2008 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Greffes d'organes, le don c'est la vie !" WHERE SeasonNumber=2008 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Dans la peau d'un maire" WHERE SeasonNumber=2008 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Police scientifique, les sorciers jouent les experts" WHERE SeasonNumber=2008 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Poules et coqs en stock" WHERE SeasonNumber=2008 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Le SIDA : la lutte continue" WHERE SeasonNumber=2008 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Le Marathon de Paris" WHERE SeasonNumber=2008 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Les requins" WHERE SeasonNumber=2008 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Ski et réchauffement climatique : les stations sous les canons" WHERE SeasonNumber=2008 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Les banques : les Sorciers demandent des comptes" WHERE SeasonNumber=2008 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Il était un... très gros paquebot !" WHERE SeasonNumber=2008 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Cuisine de chefs, la science des saveurs" WHERE SeasonNumber=2008 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Orages : les Sorciers ont le coup de foudre" WHERE SeasonNumber=2008 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Le Pérou, à la découverte des Andes" WHERE SeasonNumber=2008 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Les Sorciers prennent la mouche" WHERE SeasonNumber=2008 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Perles de Tahiti, le secret des huîtres" WHERE SeasonNumber=2008 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Lumières de la ville : les Sorciers nous éclairent" WHERE SeasonNumber=2008 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Voyage au coeur de la matière" WHERE SeasonNumber=2008 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Franchir les Alpes : le plus grand tunnel du monde" WHERE SeasonNumber=2008 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Musée Grévin : des célébrités en chair et en cire" WHERE SeasonNumber=2008 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="La pisciculture : des poissons bien élevés" WHERE SeasonNumber=2008 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="La fécondation in vitro : un enfant nommé désir" WHERE SeasonNumber=2008 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Le diabète, sucres sous surveillance!" WHERE SeasonNumber=2008 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les Sorciers se renvoient l'ascenseur" WHERE SeasonNumber=2008 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="La Justice Pénale Internationale" WHERE SeasonNumber=2008 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Rhumes, otites, angines : des maladies plein la tête" WHERE SeasonNumber=2008 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Les vêtements du futur : les Sorciers sortent leurs griffes" WHERE SeasonNumber=2008 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Les calendriers, ça date !" WHERE SeasonNumber=2009 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Les grands voiliers de course : les Sorciers vont plus vite que le vent !" WHERE SeasonNumber=2009 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Paralysie: la vie en fauteuil roulant" WHERE SeasonNumber=2009 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Carcassonne: Une cité au temps des Chevaliers !" WHERE SeasonNumber=2009 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Du Normandie au Queen Mary : la légende des paquebots" WHERE SeasonNumber=2009 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Au rythme d'une croisière" WHERE SeasonNumber=2009 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Bibliothèque Nationale, la mémoire à livre ouvert !" WHERE SeasonNumber=2009 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Pesticides : attention danger" WHERE SeasonNumber=2009 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Bio et compagnie, vers une autre agriculture" WHERE SeasonNumber=2009 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Sécurité aérienne : les Sorciers contrôlent" WHERE SeasonNumber=2009 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Les prothèses : comment ça marche ?" WHERE SeasonNumber=2009 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Epilepsies : orages dans le cerveau" WHERE SeasonNumber=2009 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Tout numérique : télévision numérique et haute définition, les Sorciers s’adaptent" WHERE SeasonNumber=2009 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Energies de la mer : des océans au courant !" WHERE SeasonNumber=2009 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Le cannabis : fumer n’est pas jouer !" WHERE SeasonNumber=2009 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Théorie de l’évolution : de Darwin à la génétique" WHERE SeasonNumber=2009 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Le Soleil : les Sorciers en connaissent un rayon" WHERE SeasonNumber=2009 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Les exoplanètes : à la recherche d’autres mondes" WHERE SeasonNumber=2009 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Iles Canaries, les Sorciers explorent un paradis" WHERE SeasonNumber=2009 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Le système solaire revisité" WHERE SeasonNumber=2009 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Ostéopathie, Acupuncture : Comment ça marche ?" WHERE SeasonNumber=2009 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Les Méduses, qui s’y frotte s’y pique" WHERE SeasonNumber=2009 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Hérisson : une vie qui ne manque pas de piquant" WHERE SeasonNumber=2009 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="A380 : le nouveau géant du ciel" WHERE SeasonNumber=2009 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Un tour de France spécial géologie" WHERE SeasonNumber=2009 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="La Corse, toute une histoire" WHERE SeasonNumber=2009 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="La Corse : l’île aux mille beautés" WHERE SeasonNumber=2009 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="L’homme de Néandertal" WHERE SeasonNumber=2009 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Best of événements scientifiques 2009" WHERE SeasonNumber=2010 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Les Jeux de Hasard" WHERE SeasonNumber=2010 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Les Agrumes" WHERE SeasonNumber=2010 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Tous à la neige" WHERE SeasonNumber=2010 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="La Police Scientifique traque les Faussaires" WHERE SeasonNumber=2010 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="La Police Scientifique contre le Crime Organisé" WHERE SeasonNumber=2010 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Géologie de la France : les Sorciers font parler les Cailloux" WHERE SeasonNumber=2010 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Géologie de la France : les Sorciers en font des Montagnes" WHERE SeasonNumber=2010 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Drôles de drones" WHERE SeasonNumber=2010 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Presse et Internet : les Sorciers remontent à la source" WHERE SeasonNumber=2010 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Le Carbone : les Sorciers font leur bilan" WHERE SeasonNumber=2010 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="En route pour la jungle !" WHERE SeasonNumber=2010 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Rencontre avec les gorilles" WHERE SeasonNumber=2010 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Les pygmées : les génies de la forêt" WHERE SeasonNumber=2010 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Forêt du Congo : sur la piste des bois tropicaux" WHERE SeasonNumber=2010 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Risque sismique aux Antilles : des îles sous la menace d’une catastrophe" WHERE SeasonNumber=2010 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Voitures électriques : la batterie donne le rythme…" WHERE SeasonNumber=2010 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Le porte-avions Charles de Gaulle : les Sorciers sur le pont d’envol" WHERE SeasonNumber=2010 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Le Louvre, du château-fort au grand musée" WHERE SeasonNumber=2010 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Les trésors du grand Louvre" WHERE SeasonNumber=2010 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Chimie verte : des végétaux pour remplacer le pétrole" WHERE SeasonNumber=2010 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Mission internationale pour le Charles de Gaulle" WHERE SeasonNumber=2010 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Zimbabwe : de l'eau pour tous" WHERE SeasonNumber=2010 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Mer Méditerranée : des envahisseurs venus du chaud" WHERE SeasonNumber=2010 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="La mer morte ... morte de soif !" WHERE SeasonNumber=2010 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Voyage en 3D sur les traces du Petit Prince" WHERE SeasonNumber=2010 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Emission spéciale 2010" WHERE SeasonNumber=2011 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Mammifères, nés dans l’ombre des dinosaures" WHERE SeasonNumber=2011 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Le Cadre Noir : les Sorciers montent sur leurs grands chevaux" WHERE SeasonNumber=2011 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Rugby : Au coeur de la mêlée" WHERE SeasonNumber=2011 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Les Sorciers passent l’éponge... marine" WHERE SeasonNumber=2011 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Petra, une cité surgie en plein désert" WHERE SeasonNumber=2011 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Un dieu - trois religions" WHERE SeasonNumber=2011 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Judaïsme : Un peuple, une religion" WHERE SeasonNumber=2011 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Christianisme : Un dieu parmi les hommes" WHERE SeasonNumber=2011 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="L’Islam, de Mahomet à aujourd’hui" WHERE SeasonNumber=2011 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="La Méditerranée, de la plage aux abysses" WHERE SeasonNumber=2011 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Méditerranée : sous le béton la plage" WHERE SeasonNumber=2011 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Les nanotechnologies : où se cachent-elles ?" WHERE SeasonNumber=2011 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Tous allergiques ?" WHERE SeasonNumber=2011 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Le déclin des abeilles" WHERE SeasonNumber=2011 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="A l’heure des marées" WHERE SeasonNumber=2011 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Manèges : le grand frisson" WHERE SeasonNumber=2011 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Le grand voyage de l'électricité" WHERE SeasonNumber=2011 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Au feu !" WHERE SeasonNumber=2011 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="La fin des records ?" WHERE SeasonNumber=2011 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Tout un fromage" WHERE SeasonNumber=2011 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="D’où viennent nos fleurs ?" WHERE SeasonNumber=2011 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Au temps des Gaulois ..." WHERE SeasonNumber=2011 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Les sous-marins de la dissuasion" WHERE SeasonNumber=2011 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="Le grand retour du loup" WHERE SeasonNumber=2011 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Du Nouveau dans les Zoos" WHERE SeasonNumber=2011 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Sécurité Routière : tous responsables" WHERE SeasonNumber=2011 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="Au pays des jouets" WHERE SeasonNumber=2011 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Des dinosaures sous nos pieds" WHERE SeasonNumber=2012 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Alerte nucléaire !" WHERE SeasonNumber=2012 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Peur des araignées ?" WHERE SeasonNumber=2012 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="Vivre Cent Ans" WHERE SeasonNumber=2012 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Roissy : l'envolée du trafic" WHERE SeasonNumber=2012 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Nos maisons de demain" WHERE SeasonNumber=2012 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Des mers sous surveillance, les sauveteurs des mers" WHERE SeasonNumber=2012 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Alerte au froid, le trafic continue !" WHERE SeasonNumber=2012 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Notre eau maltraitée ?" WHERE SeasonNumber=2012 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Les secrets du chocolat" WHERE SeasonNumber=2012 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Le Mercantour, entre monts et merveilles" WHERE SeasonNumber=2012 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="Les aventuriers du solaire" WHERE SeasonNumber=2012 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Pandas superstars !" WHERE SeasonNumber=2012 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Le sommeil" WHERE SeasonNumber=2012 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="A quoi servent nos forêts ?" WHERE SeasonNumber=2012 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="Le verre dans tous ses états" WHERE SeasonNumber=2012 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Les troubles DYS" WHERE SeasonNumber=2012 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="Le mystère des grottes de l’Ardèche" WHERE SeasonNumber=2012 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="La maladie d’Alzheimer" WHERE SeasonNumber=2012 AND EpisodeNumber=19; | |
UPDATE Episodes SET Title="Du solaire au pays de l'or noir" WHERE SeasonNumber=2012 AND EpisodeNumber=20; | |
UPDATE Episodes SET Title="Lumières et illusions" WHERE SeasonNumber=2012 AND EpisodeNumber=21; | |
UPDATE Episodes SET Title="Notre coeur, muscle fragile" WHERE SeasonNumber=2012 AND EpisodeNumber=22; | |
UPDATE Episodes SET Title="Les pièges de la montagne" WHERE SeasonNumber=2012 AND EpisodeNumber=23; | |
UPDATE Episodes SET Title="Peut-on améliorer sa mémoire ?" WHERE SeasonNumber=2012 AND EpisodeNumber=24; | |
UPDATE Episodes SET Title="L'équilibre, le grand vertige" WHERE SeasonNumber=2012 AND EpisodeNumber=25; | |
UPDATE Episodes SET Title="Chiens experts" WHERE SeasonNumber=2012 AND EpisodeNumber=26; | |
UPDATE Episodes SET Title="Que fait-on des vieux avions ?" WHERE SeasonNumber=2012 AND EpisodeNumber=27; | |
UPDATE Episodes SET Title="De l'hydravion aux canadairs" WHERE SeasonNumber=2012 AND EpisodeNumber=28; | |
UPDATE Episodes SET Title="Pourquoi les requins attaquent ?" WHERE SeasonNumber=2012 AND EpisodeNumber=29; | |
UPDATE Episodes SET Title="Dans le secret des commandos" WHERE SeasonNumber=2012 AND EpisodeNumber=30; | |
UPDATE Episodes SET Title="La Réunion, dans les entrailles du volcan ..." WHERE SeasonNumber=2012 AND EpisodeNumber=31; | |
UPDATE Episodes SET Title="Le grand voyage des tortues de mer" WHERE SeasonNumber=2013 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Moustiques : Dangereux envahisseurs ?" WHERE SeasonNumber=2013 AND EpisodeNumber=2; | |
UPDATE Episodes SET Title="Thau : une lagune fragile" WHERE SeasonNumber=2013 AND EpisodeNumber=3; | |
UPDATE Episodes SET Title="La mer attaque la terre" WHERE SeasonNumber=2013 AND EpisodeNumber=4; | |
UPDATE Episodes SET Title="Les mystères des jumeaux" WHERE SeasonNumber=2013 AND EpisodeNumber=5; | |
UPDATE Episodes SET Title="Les hommes volants" WHERE SeasonNumber=2013 AND EpisodeNumber=6; | |
UPDATE Episodes SET Title="Les trésors des salins du midi" WHERE SeasonNumber=2013 AND EpisodeNumber=7; | |
UPDATE Episodes SET Title="Réparer l'oeil : un défi pour demain" WHERE SeasonNumber=2013 AND EpisodeNumber=8; | |
UPDATE Episodes SET Title="Oasis : les champs du désert" WHERE SeasonNumber=2013 AND EpisodeNumber=9; | |
UPDATE Episodes SET Title="Sahara, le plus grand des déserts" WHERE SeasonNumber=2013 AND EpisodeNumber=10; | |
UPDATE Episodes SET Title="Les acrobates du ciel" WHERE SeasonNumber=2013 AND EpisodeNumber=11; | |
UPDATE Episodes SET Title="La plage et ses dangers" WHERE SeasonNumber=2013 AND EpisodeNumber=12; | |
UPDATE Episodes SET Title="Vivre en plein désert" WHERE SeasonNumber=2013 AND EpisodeNumber=13; | |
UPDATE Episodes SET Title="Kourou : aux portes de l’Espace" WHERE SeasonNumber=2013 AND EpisodeNumber=14; | |
UPDATE Episodes SET Title="Le génie des fourmis" WHERE SeasonNumber=2013 AND EpisodeNumber=15; | |
UPDATE Episodes SET Title="La tour Eiffel des pieds à la tête" WHERE SeasonNumber=2013 AND EpisodeNumber=16; | |
UPDATE Episodes SET Title="Sahara, la grande traversée" WHERE SeasonNumber=2013 AND EpisodeNumber=17; | |
UPDATE Episodes SET Title="L'espace : les nouveaux défis" WHERE SeasonNumber=2013 AND EpisodeNumber=18; | |
UPDATE Episodes SET Title="Les chasseurs d'or" WHERE SeasonNumber=2014 AND EpisodeNumber=1; | |
UPDATE Episodes SET Title="Zimbabwe : lutte contre la faim" WHERE SeasonNumber=2014 AND EpisodeNumber=2; | |
COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment