Requète SQL avec condition where

Résolu
LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   -  
LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   -
Bonjour,
J'ai une requète qui me retourne le nombre de répétition par an. 
	// Nombre de répétitions par année
	$sql = "SELECT YEAR(cdc_repetitions.drepet) AS annee, COUNT(cdc_repetitions.idrep) AS nbrep
			FROM cdc_repetitions
			GROUP BY annee
			ORDER BY annee";
	$result = executeQuery($sql,$datas);

	echo '<div class="nb_repetition"><h1>Nombre de répétitions par année</h1>';
	echo '<table border="0" cellpadding="0" cellspacing="0">';
	echo '<tr><td class="c1">Année</td><td class="c2">Nombre</td></tr>';

	while ($donnees = $result->fetch()) {
		echo '<tr><td class="c3">'.$donnees->annee.'</td><td class="c4">'.$donnees->nbrep.'</td></tr>';
	}
	echo '</table>';
	echo '</div>';

Mais je souhaite pouvoir afficher uniquement le nombre de répétitions par an si la valeur d'une colonne est à 2.
J'ai une table cdc_assister avec un champ idloc soit 1 soit 2
J'ai fait cela mais le résultat n'est pas bon.
Merci pour votre aide. 
	$sql = "SELECT YEAR(cdc_repetitions.drepet) AS annee, COUNT(cdc_repetitions.idrep) AS nbrep
			FROM cdc_repetitions,cdc_assister,cdc_locaux
			WHERE cdc_locaux.idloc = cdc_assister.idloc
			AND cdc_repetitions.idrep = cdc_assister.idrep
			AND cdc_assister.idloc = 2
			GROUP BY annee
			ORDER BY annee";
	$result = executeQuery($sql,$datas);

	echo '<div class="nb_repetition"><h1>Nombre de répétitions par année</h1>';
	echo '<table border="0" cellpadding="0" cellspacing="0">';
	echo '<tr><td class="c1">Année</td><td class="c2">Nombre</td></tr>';

	while ($donnees = $result->fetch()) {
		echo '<tr><td class="c3">'.$donnees->annee.'</td><td class="c4">'.$donnees->nbrep.'</td></tr>';
	}
	echo '</table>';
	echo '</div>';

13 réponses

  1.
    jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
     
    Bonjour,

    Que donne cette requête : 
    SELECT YEAR(R.drepet) AS annee, 
       COUNT(R.idrep) AS nbrep
FROM cdc_repetitions R
LEFT JOIN cdc_assister A ON A.idrep = R.idrep AND A.idloc = 2
LEFT JOIN cdc_locaux L ON L.idloc = A.idloc
GROUP BY annee
ORDER BY annee


    NB: Pense à tester tes requêtes directement dans ta BDD via phpmyadmin plutôt que directement dans ton code....

    0
  2. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    Bonjour,
    Ca me retourne cette erreur. 
    Erreur ! SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cdc_repetitions.drepet' in 'field list'
    0
    1. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      Change le début de la requête 
      SELECT YEAR(R.drepet) AS annee, 
       COUNT(R.idrep) AS nbrep

      Sachant que je me suis servi de ta requête à toi...
      Si ça ne fonctionne toujours pas après ça, donne nous un dump de tes tables (structure + données )
      0
  3. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    Par contre cela me retourne un résultat qui n'a rien à voir avec la réalité.
    Voici la structure de mes tables.
    Merci 
    mysql> show full columns from cdc_repetitions;
+--------+---------+-----------+------+-----+---------+----------------+---------------------------------+-----------------------+
| Field  | Type    | Collation | Null | Key | Default | Extra          | Privileges                      | Comment               |
+--------+---------+-----------+------+-----+---------+----------------+---------------------------------+-----------------------+
| idrep  | int(11) | NULL      | NO   | PRI | NULL    | auto_increment | select,insert,update,references | ID de la répétition   |
| drepet | date    | NULL      | NO   |     | NULL    |                | select,insert,update,references | Date de la répétition |
+--------+---------+-----------+------+-----+---------+----------------+---------------------------------+-----------------------+
2 rows in set (0.01 sec)
mysql> show full columns from cdc_locaux;
+---------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+---------------------------+
| Field   | Type        | Collation       | Null | Key | Default | Extra          | Privileges                      | Comment                   |
+---------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+---------------------------+
| idloc   | int(11)     | NULL            | NO   | PRI | NULL    | auto_increment | select,insert,update,references | ID du local de répétition |
| local   | varchar(40) | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references | Désignation du local      |
| cpostal | char(5)     | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references | Code postal du local      |
| ville   | varchar(25) | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references | Ville du local            |
+---------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+---------------------------+
4 rows in set (0.02 sec)
mysql> show full columns from cdc_assister;
+--------+---------+-----------+------+-----+---------+-------+---------------------------------+---------------------------+
| Field  | Type    | Collation | Null | Key | Default | Extra | Privileges                      | Comment                   |
+--------+---------+-----------+------+-----+---------+-------+---------------------------------+---------------------------+
| idpers | int(11) | NULL      | NO   | PRI | NULL    |       | select,insert,update,references | ID du répétant            |
| idrep  | int(11) | NULL      | NO   | PRI | NULL    |       | select,insert,update,references | ID de la répétition       |
| idloc  | int(11) | NULL      | NO   | PRI | NULL    |       | select,insert,update,references | ID du local de répétition |
+--------+---------+-----------+------+-----+---------+-------+---------------------------------+---------------------------+
3 rows in set (0.01 sec)
    0
    1. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      Je t'ai demandé un DUMP (structure + données ) 
       mysqldump -u user -p maBase > maBase_backup.sql

      Ensuite tu colles le contenu du fichier sql sur le forum entre balises de code sql.
      0
  4. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    Bonjour
    Comme j'ouvre une console Mysql pour la commande s'il te plait.
    Merci
    0
    1. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      Partons de ton message précédent...
      Tu as posté : 
      mysql> show full columns from cdc_repetitions;

      Tu as donc :
      1 - Ouvert une console
      2 - ouvert la connexion à la bdd
      3 - Tapé la ligne de code 
       show full columns from cdc_repetitions;


      Pour faire le DUMP ...
      Tu reprends l'étape 1 : Ouvrir la console
      Puis tu tapes directement la ligne de code que je t'ai donné (en remplaçant les variables par TES valeurs )
      0

  5. Vous n’avez pas trouvé la réponse que vous recherchez ?

    Posez votre question
  6. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    en fait c'est la console de wampserver que je me suis servi et utiliser en local donc...
    0
    1. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      tu ouvres une invite de commande msdos.... une "cmd" ... une console quoi....
      0
    2. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      Ou sinon tu passes par ton phpmyadmin et tu génères un export .... c'est pareil.
      0
  7. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    --
-- Structure de la table `cdc_assister`
--

CREATE TABLE `cdc_assister` (
  `idpers` int(11) NOT NULL COMMENT 'ID du répétant',
  `idrep` int(11) NOT NULL COMMENT 'ID de la répétition',
  `idloc` int(11) NOT NULL COMMENT 'ID du local de répétition'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table de relation : adhérents - assister - répétitions';

--
-- Déchargement des données de la table `cdc_assister`
--

INSERT INTO `cdc_assister` (`idpers`, `idrep`, `idloc`) VALUES
(1, 1, 1),
(1, 2, 1),
(1, 3, 1),
(1, 4, 1),
(1, 5, 1),
(1, 6, 1),
(1, 7, 1),
(1, 9, 1),
(1, 11, 1),
(1, 13, 1),
(1, 14, 1),
(1, 15, 1),
(1, 16, 1),
(1, 18, 1),
(1, 19, 1),
(1, 21, 1),
(1, 24, 1),
(1, 25, 1),
(1, 26, 1),
(1, 27, 1),
(1, 28, 1),
(1, 30, 1),
(1, 31, 1),
(1, 32, 1),
(1, 33, 1),
(1, 34, 1),
(1, 35, 1),
(1, 36, 1),
(1, 38, 1),
(1, 39, 1),
(1, 40, 1),
(1, 41, 1),
(1, 42, 1),
(1, 43, 1),
(1, 44, 1),
(1, 46, 1),
(1, 47, 1),
(1, 48, 1),
(1, 49, 1),
(1, 50, 1),
(1, 52, 1),
(1, 53, 1),
(1, 54, 1),
(1, 55, 1),
(1, 56, 1),
(1, 57, 1),
(1, 58, 1),
(1, 59, 1),
(1, 60, 1),
(1, 66, 1),
(1, 67, 1),
(1, 68, 1),
(1, 71, 1),
(1, 72, 1),
(1, 73, 1),
(1, 77, 1),
(1, 78, 1),
(1, 79, 1),
(1, 80, 1),
(1, 81, 1),
(1, 82, 1),
(1, 83, 1),
(1, 85, 1),
(1, 86, 1),
(1, 87, 1),
(1, 88, 2),
(1, 90, 1),
(1, 93, 1),
(1, 94, 1),
(1, 95, 2),
(1, 97, 1),
(1, 100, 1),
(1, 101, 1),
(1, 102, 1),
(1, 103, 1),
(1, 105, 1),
(1, 106, 2),
(1, 107, 2),
(1, 108, 1),
(1, 109, 1),
(1, 110, 1),
(1, 111, 1),
(1, 112, 1),
(1, 113, 1),
(1, 114, 1),
(1, 118, 1),
(1, 119, 1),
(1, 120, 1),
(1, 121, 1),
(1, 122, 1),
(1, 124, 1),
(1, 125, 1),
(1, 126, 1),
(1, 127, 1),
(1, 128, 1),
(1, 130, 1),
(1, 131, 1),
(1, 133, 1),
(1, 134, 1),
(1, 135, 1),
(1, 136, 1),
(1, 138, 2),
(1, 139, 1),
(1, 140, 1),
(1, 141, 1),
(2, 1, 1),
(2, 2, 1),
(2, 3, 1),
(2, 4, 1),
(2, 5, 1),
(2, 6, 1),
(2, 7, 1),
(2, 8, 1),
(2, 9, 1),
(2, 10, 1),
(2, 11, 1),
(2, 12, 1),
(2, 13, 1),
(2, 14, 1),
(2, 15, 1),
(2, 16, 1),
(2, 17, 1),
(2, 18, 1),
(2, 19, 1),
(2, 20, 1),
(2, 21, 1),
(2, 22, 1),
(2, 23, 1),
(2, 24, 1),
(2, 25, 1),
(2, 26, 1),
(2, 28, 1),
(2, 29, 1),
(2, 30, 1),
(2, 31, 1),
(2, 32, 1),
(2, 33, 1),
(2, 34, 1),
(2, 35, 1),
(2, 37, 1),
(2, 38, 1),
(2, 39, 1),
(2, 40, 1),
(2, 41, 1),
(2, 42, 1),
(2, 43, 1),
(2, 44, 1),
(2, 45, 1),
(2, 46, 1),
(2, 47, 1),
(2, 48, 1),
(2, 49, 1),
(2, 50, 1),
(2, 51, 1),
(2, 52, 1),
(2, 53, 1),
(2, 54, 1),
(2, 55, 1),
(2, 56, 1),
(2, 57, 1),
(2, 59, 1),
(2, 60, 1),
(2, 61, 1),
(2, 62, 1),
(2, 63, 1),
(2, 64, 1),
(2, 65, 1),
(2, 66, 1),
(2, 67, 1),
(2, 68, 1),
(2, 69, 1),
(2, 70, 1),
(2, 71, 1),
(2, 72, 1),
(2, 73, 1),
(2, 74, 1),
(2, 76, 1),
(2, 77, 1),
(2, 78, 1),
(2, 79, 1),
(2, 80, 1),
(2, 81, 1),
(2, 83, 1),
(2, 84, 2),
(2, 85, 1),
(2, 86, 1),
(2, 87, 1),
(2, 88, 2),
(2, 89, 1),
(2, 90, 1),
(2, 91, 2),
(2, 92, 1),
(2, 93, 1),
(2, 96, 1),
(2, 97, 1),
(2, 98, 1),
(2, 99, 2),
(2, 100, 1),
(2, 101, 1),
(2, 102, 1),
(2, 103, 1),
(2, 104, 2),
(2, 106, 2),
(2, 107, 2),
(2, 108, 1),
(2, 109, 1),
(2, 113, 1),
(2, 114, 1),
(2, 115, 1),
(2, 116, 1),
(2, 117, 1),
(2, 118, 1),
(2, 119, 1),
(2, 120, 1),
(2, 121, 1),
(2, 122, 1),
(2, 123, 1),
(2, 124, 1),
(2, 125, 1),
(2, 126, 1),
(2, 127, 1),
(2, 128, 1),
(2, 129, 1),
(2, 130, 1),
(2, 131, 1),
(2, 132, 1),
(2, 133, 1),
(2, 134, 1),
(2, 135, 1),
(2, 136, 1),
(2, 137, 2),
(2, 138, 2),
(2, 139, 1),
(2, 140, 1),
(2, 141, 1),
(3, 3, 1),
(3, 8, 1),
(3, 14, 1),
(4, 20, 1),
(4, 21, 1),
(4, 53, 1),
(4, 62, 1),
(4, 106, 2),
(4, 107, 2),
(13, 1, 1),
(13, 2, 1),
(13, 3, 1),
(13, 4, 1),
(13, 5, 1),
(13, 6, 1),
(13, 7, 1),
(13, 8, 1),
(13, 9, 1),
(13, 10, 1),
(13, 11, 1),
(13, 12, 1),
(13, 13, 1),
(13, 14, 1),
(13, 15, 1),
(13, 16, 1),
(13, 17, 1),
(13, 19, 1),
(13, 20, 1),
(13, 21, 1),
(13, 23, 1),
(13, 24, 1),
(13, 25, 1),
(13, 26, 1),
(13, 27, 1),
(13, 28, 1),
(13, 29, 1),
(13, 30, 1),
(13, 32, 1),
(13, 33, 1),
(13, 34, 1),
(13, 35, 1),
(13, 36, 1),
(13, 37, 1),
(13, 38, 1),
(13, 40, 1),
(13, 41, 1),
(13, 42, 1),
(13, 43, 1),
(13, 44, 1),
(13, 45, 1),
(13, 46, 1),
(13, 48, 1),
(13, 51, 1),
(13, 52, 1),
(13, 53, 1),
(13, 58, 1),
(13, 60, 1),
(13, 61, 1),
(13, 62, 1),
(13, 65, 1),
(13, 66, 1),
(13, 67, 1),
(13, 69, 1),
(13, 71, 1),
(13, 74, 1),
(13, 76, 1),
(13, 77, 1),
(13, 78, 1),
(13, 81, 1),
(13, 82, 1),
(13, 83, 1),
(13, 84, 2),
(13, 85, 1),
(13, 86, 1),
(13, 87, 1),
(13, 88, 2),
(13, 89, 1),
(13, 91, 2),
(13, 92, 1),
(13, 93, 1),
(13, 95, 2),
(13, 96, 1),
(13, 97, 1),
(13, 98, 1),
(13, 99, 2),
(13, 100, 1),
(13, 101, 1),
(13, 103, 1),
(13, 104, 2),
(13, 108, 1),
(13, 109, 1),
(13, 110, 1),
(13, 111, 1),
(13, 112, 1),
(13, 113, 1),
(13, 114, 1),
(13, 115, 1),
(13, 117, 1),
(13, 118, 1),
(13, 119, 1),
(13, 121, 1),
(13, 122, 1),
(13, 123, 1),
(13, 126, 1),
(13, 127, 1),
(13, 128, 1),
(13, 129, 1),
(13, 130, 1),
(13, 131, 1),
(13, 132, 1),
(13, 133, 1),
(13, 134, 1),
(13, 135, 1),
(13, 136, 1),
(13, 139, 1),
(13, 140, 1),
(21, 5, 1),
(21, 8, 1),
(21, 10, 1),
(21, 18, 1),
(21, 25, 1),
(21, 26, 1),
(21, 30, 1),
(21, 41, 1),
(21, 44, 1),
(21, 47, 1),
(21, 72, 1),
(21, 77, 1),
(21, 79, 1),
(21, 100, 1),
(21, 107, 2),
(21, 117, 1),
(21, 120, 1),
(22, 3, 1),
(22, 5, 1),
(22, 6, 1),
(22, 7, 1),
(22, 11, 1),
(22, 12, 1),
(22, 15, 1),
(22, 25, 1),
(22, 26, 1),
(22, 28, 1),
(22, 30, 1),
(22, 32, 1),
(22, 34, 1),
(22, 35, 1),
(22, 40, 1),
(22, 41, 1),
(22, 42, 1),
(22, 43, 1),
(22, 45, 1),
(22, 47, 1),
(22, 49, 1),
(22, 50, 1),
(22, 51, 1),
(22, 52, 1),
(22, 53, 1),
(22, 54, 1),
(22, 56, 1),
(22, 57, 1),
(22, 58, 1),
(22, 59, 1),
(22, 63, 1),
(22, 64, 1),
(22, 66, 1),
(22, 67, 1),
(22, 72, 1),
(22, 73, 1),
(22, 74, 1),
(22, 76, 1),
(22, 77, 1),
(22, 78, 1),
(22, 80, 1),
(22, 81, 1),
(22, 82, 1),
(22, 86, 1),
(22, 87, 1),
(22, 91, 2),
(22, 92, 1),
(22, 97, 1),
(22, 98, 1),
(22, 100, 1),
(22, 102, 1),
(22, 105, 1),
(22, 109, 1),
(22, 112, 1),
(22, 113, 1),
(22, 114, 1),
(22, 115, 1),
(22, 116, 1),
(22, 117, 1),
(22, 118, 1),
(22, 119, 1),
(22, 120, 1),
(22, 121, 1),
(22, 124, 1),
(22, 126, 1),
(22, 127, 1),
(22, 128, 1),
(22, 129, 1),
(22, 130, 1),
(22, 131, 1),
(22, 132, 1),
(22, 133, 1),
(22, 134, 1),
(22, 135, 1),
(22, 136, 1),
(22, 139, 1),
(22, 141, 1),
(27, 4, 1),
(27, 10, 1),
(27, 11, 1),
(27, 12, 1),
(27, 18, 1),
(27, 25, 1),
(27, 26, 1),
(27, 27, 1),
(27, 28, 1),
(27, 29, 1),
(27, 34, 1),
(27, 35, 1),
(27, 39, 1),
(27, 40, 1),
(27, 43, 1),
(27, 45, 1),
(27, 49, 1),
(27, 54, 1),
(27, 61, 1),
(27, 68, 1),
(27, 71, 1),
(27, 72, 1),
(27, 76, 1),
(27, 77, 1),
(27, 80, 1),
(27, 81, 1),
(27, 85, 1),
(27, 88, 2),
(27, 89, 1),
(27, 100, 1),
(27, 101, 1),
(27, 103, 1),
(27, 110, 1),
(27, 111, 1),
(27, 112, 1),
(27, 117, 1),
(27, 118, 1),
(27, 120, 1),
(27, 122, 1),
(27, 124, 1),
(27, 125, 1),
(27, 126, 1),
(27, 127, 1),
(27, 128, 1),
(27, 134, 1),
(27, 139, 1),
(28, 3, 1),
(28, 4, 1),
(28, 5, 1),
(28, 6, 1),
(28, 8, 1),
(28, 9, 1),
(28, 10, 1),
(28, 11, 1),
(28, 12, 1),
(28, 13, 1),
(28, 14, 1),
(28, 15, 1),
(28, 16, 1),
(28, 18, 1),
(28, 19, 1),
(28, 21, 1),
(28, 22, 1),
(28, 23, 1),
(28, 24, 1),
(28, 25, 1),
(28, 26, 1),
(28, 27, 1),
(28, 28, 1),
(28, 29, 1),
(28, 30, 1),
(28, 31, 1),
(28, 32, 1),
(28, 33, 1),
(28, 34, 1),
(28, 35, 1),
(28, 37, 1),
(28, 38, 1),
(28, 39, 1),
(28, 40, 1),
(28, 41, 1),
(28, 42, 1),
(28, 43, 1),
(28, 44, 1),
(28, 45, 1),
(28, 46, 1),
(28, 47, 1),
(28, 48, 1),
(28, 49, 1),
(28, 50, 1),
(28, 51, 1),
(28, 53, 1),
(28, 54, 1),
(28, 55, 1),
(28, 56, 1),
(28, 57, 1),
(28, 59, 1),
(28, 60, 1),
(28, 62, 1),
(28, 64, 1),
(28, 65, 1),
(28, 66, 1),
(28, 67, 1),
(28, 69, 1),
(28, 70, 1),
(28, 71, 1),
(28, 72, 1),
(28, 73, 1),
(28, 74, 1),
(28, 75, 1),
(28, 76, 1),
(28, 77, 1),
(28, 78, 1),
(28, 79, 1),
(28, 80, 1),
(28, 81, 1),
(28, 82, 1),
(28, 83, 1),
(28, 84, 2),
(28, 85, 1),
(28, 86, 1),
(28, 87, 1),
(28, 88, 2),
(28, 89, 1),
(28, 90, 1),
(28, 91, 2),
(28, 92, 1),
(28, 93, 1),
(28, 94, 1),
(28, 95, 2),
(28, 96, 1),
(28, 98, 1),
(28, 99, 2),
(28, 100, 1),
(28, 102, 1),
(28, 103, 1),
(28, 105, 1),
(28, 106, 2),
(28, 108, 1),
(28, 109, 1),
(28, 110, 1),
(28, 111, 1),
(28, 112, 1),
(28, 113, 1),
(28, 114, 1),
(28, 115, 1),
(28, 116, 1),
(28, 117, 1),
(28, 118, 1),
(28, 119, 1),
(28, 120, 1),
(28, 121, 1),
(28, 122, 1),
(28, 124, 1),
(28, 126, 1),
(28, 128, 1),
(28, 129, 1),
(28, 130, 1),
(28, 131, 1),
(28, 132, 1),
(28, 133, 1),
(28, 134, 1),
(28, 136, 1),
(28, 139, 1),
(28, 140, 1),
(28, 141, 1),
(30, 1, 1),
(30, 2, 1),
(30, 3, 1),
(30, 4, 1),
(30, 5, 1),
(30, 6, 1),
(30, 7, 1),
(30, 8, 1),
(30, 9, 1),
(30, 10, 1),
(30, 11, 1),
(30, 12, 1),
(30, 13, 1),
(30, 14, 1),
(30, 15, 1),
(30, 16, 1),
(30, 17, 1),
(30, 18, 1),
(30, 19, 1),
(30, 21, 1),
(30, 22, 1),
(30, 23, 1),
(30, 24, 1),
(30, 25, 1),
(30, 26, 1),
(30, 27, 1),
(30, 28, 1),
(30, 30, 1),
(30, 31, 1),
(30, 32, 1),
(30, 33, 1),
(30, 34, 1),
(30, 35, 1),
(30, 37, 1),
(30, 38, 1),
(30, 39, 1),
(30, 40, 1),
(30, 41, 1),
(30, 42, 1),
(30, 43, 1),
(30, 45, 1),
(30, 46, 1),
(30, 47, 1),
(30, 48, 1),
(30, 49, 1),
(30, 50, 1),
(30, 53, 1),
(30, 54, 1),
(30, 55, 1),
(30, 56, 1),
(30, 57, 1),
(30, 59, 1),
(30, 60, 1),
(30, 62, 1),
(30, 64, 1),
(30, 65, 1),
(30, 66, 1),
(30, 67, 1),
(30, 68, 1),
(30, 69, 1),
(30, 70, 1),
(30, 71, 1),
(30, 72, 1),
(30, 73, 1),
(30, 74, 1),
(30, 75, 1),
(30, 76, 1),
(30, 77, 1),
(30, 78, 1),
(30, 79, 1),
(30, 80, 1),
(30, 81, 1),
(30, 82, 1),
(30, 83, 1),
(30, 84, 2),
(30, 86, 1),
(30, 87, 1),
(30, 89, 1),
(30, 90, 1),
(30, 91, 2),
(30, 92, 1),
(30, 93, 1),
(30, 94, 1),
(30, 95, 2),
(30, 96, 1),
(30, 98, 1),
(30, 100, 1),
(30, 102, 1),
(30, 103, 1),
(30, 105, 1),
(30, 106, 2),
(30, 108, 1),
(30, 110, 1),
(30, 111, 1),
(30, 112, 1),
(30, 113, 1),
(30, 114, 1),
(30, 115, 1),
(30, 116, 1),
(30, 117, 1),
(30, 118, 1),
(30, 119, 1),
(30, 120, 1),
(30, 121, 1),
(30, 122, 1),
(30, 124, 1),
(30, 126, 1),
(30, 128, 1),
(30, 129, 1),
(30, 130, 1),
(30, 131, 1),
(30, 132, 1),
(30, 133, 1),
(30, 134, 1),
(30, 136, 1),
(30, 139, 1),
(30, 141, 1),
(57, 87, 1),
(57, 94, 1),
(57, 97, 1),
(57, 98, 1),
(57, 100, 1),
(57, 109, 1),
(57, 115, 1),
(57, 116, 1),
(57, 117, 1),
(57, 119, 1),
(57, 120, 1),
(57, 125, 1),
(80, 1, 1),
(80, 5, 1),
(80, 7, 1),
(80, 8, 1),
(80, 10, 1),
(80, 11, 1),
(80, 14, 1),
(80, 15, 1),
(80, 16, 1),
(80, 17, 1),
(80, 18, 1),
(80, 19, 1),
(80, 24, 1),
(80, 25, 1),
(80, 26, 1),
(80, 27, 1),
(80, 28, 1),
(80, 29, 1),
(80, 32, 1),
(80, 35, 1),
(80, 36, 1),
(80, 40, 1),
(80, 41, 1),
(80, 43, 1),
(80, 45, 1),
(80, 47, 1),
(80, 49, 1),
(80, 50, 1),
(80, 51, 1),
(80, 53, 1),
(80, 55, 1),
(80, 56, 1),
(80, 57, 1),
(80, 58, 1),
(80, 61, 1),
(80, 66, 1),
(80, 73, 1),
(80, 111, 1),
(91, 1, 1),
(91, 5, 1),
(91, 7, 1),
(91, 8, 1),
(91, 10, 1),
(91, 11, 1),
(91, 14, 1),
(91, 15, 1),
(91, 16, 1),
(91, 17, 1),
(91, 18, 1),
(91, 19, 1),
(91, 24, 1),
(91, 28, 1),
(91, 29, 1),
(91, 33, 1),
(91, 35, 1),
(91, 36, 1),
(91, 40, 1),
(91, 41, 1),
(91, 43, 1),
(91, 45, 1),
(91, 50, 1),
(91, 51, 1),
(91, 52, 1),
(91, 53, 1),
(91, 55, 1),
(91, 56, 1),
(91, 57, 1),
(91, 58, 1),
(91, 60, 1),
(91, 61, 1),
(91, 66, 1),
(91, 67, 1),
(91, 68, 1),
(91, 69, 1),
(91, 70, 1),
(91, 72, 1),
(91, 73, 1),
(91, 75, 1),
(91, 76, 1),
(91, 77, 1),
(91, 78, 1),
(91, 81, 1),
(91, 83, 1),
(91, 86, 1),
(91, 89, 1),
(91, 90, 1),
(91, 91, 2),
(91, 95, 2),
(91, 96, 1),
(91, 99, 2),
(91, 100, 1),
(91, 106, 2),
(91, 107, 2),
(91, 111, 1),
(91, 112, 1),
(100, 2, 1),
(100, 5, 1),
(100, 6, 1),
(100, 7, 1),
(100, 8, 1),
(100, 9, 1),
(100, 10, 1),
(100, 11, 1),
(100, 12, 1),
(100, 14, 1),
(100, 18, 1),
(100, 19, 1),
(100, 26, 1),
(100, 29, 1),
(100, 32, 1),
(100, 33, 1),
(100, 35, 1),
(100, 36, 1),
(100, 45, 1),
(100, 49, 1),
(100, 51, 1),
(100, 52, 1),
(100, 53, 1),
(100, 54, 1),
(100, 55, 1),
(100, 56, 1),
(100, 57, 1),
(100, 58, 1),
(100, 59, 1),
(100, 60, 1),
(100, 68, 1),
(100, 70, 1),
(100, 72, 1),
(100, 74, 1),
(100, 76, 1),
(100, 77, 1),
(100, 100, 1),
(100, 102, 1),
(100, 103, 1),
(100, 109, 1),
(100, 111, 1),
(100, 115, 1),
(100, 118, 1),
(100, 119, 1),
(100, 120, 1),
(100, 122, 1),
(100, 124, 1),
(100, 126, 1),
(100, 127, 1),
(100, 132, 1),
(100, 133, 1),
(100, 134, 1),
(100, 135, 1),
(100, 139, 1),
(100, 140, 1),
(106, 2, 1),
(106, 3, 1),
(106, 4, 1),
(106, 5, 1),
(106, 6, 1),
(106, 7, 1),
(106, 8, 1),
(106, 9, 1),
(106, 10, 1),
(106, 12, 1),
(106, 16, 1),
(106, 17, 1),
(106, 23, 1),
(106, 26, 1),
(106, 27, 1),
(106, 30, 1),
(106, 34, 1),
(106, 36, 1),
(106, 37, 1),
(106, 39, 1),
(106, 40, 1),
(106, 41, 1),
(106, 42, 1),
(106, 43, 1),
(106, 45, 1),
(106, 46, 1),
(106, 47, 1),
(106, 48, 1),
(106, 49, 1),
(106, 50, 1),
(106, 53, 1),
(106, 57, 1),
(106, 59, 1),
(106, 60, 1),
(106, 66, 1),
(106, 67, 1),
(106, 68, 1),
(106, 69, 1),
(106, 70, 1),
(106, 71, 1),
(106, 72, 1),
(106, 76, 1),
(106, 77, 1),
(106, 78, 1),
(106, 81, 1),
(106, 83, 1),
(106, 85, 1),
(106, 87, 1),
(106, 89, 1),
(106, 98, 1),
(106, 100, 1),
(106, 101, 1),
(106, 103, 1),
(106, 105, 1),
(106, 109, 1),
(106, 110, 1),
(106, 111, 1),
(106, 112, 1),
(106, 115, 1),
(106, 118, 1),
(106, 120, 1),
(106, 122, 1),
(106, 124, 1),
(106, 125, 1),
(106, 126, 1),
(106, 127, 1),
(106, 128, 1),
(106, 129, 1),
(106, 130, 1),
(106, 131, 1),
(106, 132, 1),
(106, 133, 1),
(106, 134, 1),
(106, 135, 1),
(106, 139, 1),
(106, 140, 1),
(106, 141, 1),
(110, 1, 1),
(110, 2, 1),
(110, 3, 1),
(110, 4, 1),
(110, 5, 1),
(110, 6, 1),
(110, 8, 1),
(110, 9, 1),
(110, 10, 1),
(110, 11, 1),
(110, 12, 1),
(110, 15, 1),
(110, 16, 1),
(110, 17, 1),
(110, 19, 1),
(110, 25, 1),
(110, 27, 1),
(110, 28, 1),
(110, 29, 1),
(110, 30, 1),
(110, 32, 1),
(110, 33, 1),
(110, 34, 1),
(110, 35, 1),
(110, 36, 1),
(110, 37, 1),
(110, 40, 1),
(110, 41, 1),
(110, 42, 1),
(110, 43, 1),
(110, 44, 1),
(110, 45, 1),
(110, 46, 1),
(110, 49, 1),
(110, 50, 1),
(110, 51, 1),
(110, 52, 1),
(110, 53, 1),
(110, 56, 1),
(110, 57, 1),
(110, 58, 1),
(110, 59, 1),
(110, 60, 1),
(110, 61, 1),
(110, 64, 1),
(110, 66, 1),
(110, 67, 1),
(110, 70, 1),
(110, 71, 1),
(110, 73, 1),
(110, 74, 1),
(110, 76, 1),
(110, 77, 1),
(110, 78, 1),
(110, 79, 1),
(110, 83, 1),
(110, 84, 2),
(110, 85, 1),
(110, 86, 1),
(110, 87, 1),
(110, 88, 2),
(110, 89, 1),
(110, 90, 1),
(110, 91, 2),
(110, 92, 1),
(110, 93, 1),
(110, 94, 1),
(110, 95, 2),
(110, 96, 1),
(110, 97, 1),
(110, 98, 1),
(110, 99, 2),
(110, 100, 1),
(110, 101, 1),
(110, 104, 2),
(110, 105, 1),
(110, 106, 2),
(110, 107, 2),
(110, 109, 1),
(110, 111, 1),
(110, 113, 1),
(110, 114, 1),
(110, 115, 1),
(110, 116, 1),
(110, 117, 1),
(110, 118, 1),
(110, 119, 1),
(110, 120, 1),
(110, 125, 1),
(110, 126, 1),
(110, 127, 1),
(110, 128, 1),
(110, 129, 1),
(110, 130, 1),
(110, 131, 1),
(110, 135, 1),
(110, 136, 1),
(110, 137, 2),
(110, 139, 1),
(110, 140, 1),
(111, 3, 1),
(111, 32, 1),
(111, 47, 1),
(111, 49, 1),
(111, 53, 1),
(113, 1, 1),
(113, 2, 1),
(113, 3, 1),
(113, 4, 1),
(113, 5, 1),
(113, 6, 1),
(113, 7, 1),
(113, 8, 1),
(113, 9, 1),
(113, 10, 1),
(113, 13, 1),
(113, 16, 1),
(113, 17, 1),
(113, 18, 1),
(113, 19, 1),
(113, 20, 1),
(113, 21, 1),
(113, 22, 1),
(113, 24, 1),
(113, 25, 1),
(113, 26, 1),
(113, 29, 1),
(113, 32, 1),
(113, 33, 1),
(113, 35, 1),
(113, 36, 1),
(113, 37, 1),
(113, 38, 1),
(113, 39, 1),
(113, 40, 1),
(113, 41, 1),
(113, 42, 1),
(113, 43, 1),
(113, 45, 1),
(113, 48, 1),
(113, 49, 1),
(113, 50, 1),
(113, 51, 1),
(113, 55, 1),
(113, 56, 1),
(113, 57, 1),
(113, 58, 1),
(113, 59, 1),
(113, 60, 1),
(113, 61, 1),
(113, 62, 1),
(113, 66, 1),
(113, 67, 1),
(113, 68, 1),
(113, 69, 1),
(113, 70, 1),
(113, 71, 1),
(113, 74, 1),
(113, 76, 1),
(113, 77, 1),
(113, 78, 1),
(113, 79, 1),
(113, 80, 1),
(113, 81, 1),
(113, 82, 1),
(113, 83, 1),
(113, 85, 1),
(113, 86, 1),
(113, 90, 1),
(113, 92, 1),
(113, 100, 1),
(113, 103, 1),
(113, 104, 2),
(113, 107, 2),
(113, 110, 1),
(117, 2, 1),
(117, 3, 1),
(117, 4, 1),
(117, 5, 1),
(117, 6, 1),
(117, 7, 1),
(117, 8, 1),
(117, 9, 1),
(117, 10, 1),
(117, 11, 1),
(117, 12, 1),
(117, 13, 1),
(117, 14, 1),
(117, 15, 1),
(117, 16, 1),
(117, 17, 1),
(117, 18, 1),
(117, 20, 1),
(117, 22, 1),
(117, 23, 1),
(117, 24, 1),
(117, 25, 1),
(117, 26, 1),
(117, 27, 1),
(117, 28, 1),
(117, 29, 1),
(117, 30, 1),
(117, 31, 1),
(117, 32, 1),
(117, 33, 1),
(117, 34, 1),
(117, 35, 1),
(117, 36, 1),
(117, 37, 1),
(117, 39, 1),
(117, 40, 1),
(117, 41, 1),
(117, 42, 1),
(117, 43, 1),
(117, 45, 1),
(117, 46, 1),
(117, 47, 1),
(117, 48, 1),
(117, 49, 1),
(117, 50, 1),
(117, 51, 1),
(117, 52, 1),
(117, 53, 1),
(117, 54, 1),
(117, 55, 1),
(117, 56, 1),
(117, 57, 1),
(117, 59, 1),
(117, 60, 1),
(117, 62, 1),
(117, 63, 1),
(117, 64, 1),
(117, 65, 1),
(117, 66, 1),
(117, 67, 1),
(117, 69, 1),
(117, 70, 1),
(117, 71, 1),
(117, 72, 1),
(117, 73, 1),
(117, 74, 1),
(117, 76, 1),
(117, 77, 1),
(117, 78, 1),
(117, 81, 1),
(117, 82, 1),
(117, 83, 1),
(117, 84, 2),
(117, 85, 1),
(117, 87, 1),
(117, 88, 2),
(117, 89, 1),
(117, 90, 1),
(117, 93, 1),
(117, 95, 2),
(117, 96, 1),
(117, 97, 1),
(117, 98, 1),
(117, 99, 2),
(117, 100, 1),
(117, 105, 1),
(117, 106, 2),
(117, 109, 1),
(117, 110, 1),
(117, 112, 1),
(117, 113, 1),
(117, 114, 1),
(117, 115, 1),
(117, 116, 1),
(117, 117, 1),
(117, 118, 1),
(117, 119, 1),
(117, 120, 1),
(117, 121, 1),
(117, 122, 1),
(117, 123, 1),
(117, 124, 1),
(117, 125, 1),
(117, 126, 1),
(117, 127, 1),
(117, 129, 1),
(117, 130, 1),
(117, 131, 1),
(117, 132, 1),
(117, 133, 1),
(117, 134, 1),
(117, 135, 1),
(117, 136, 1),
(117, 137, 2),
(117, 139, 1),
(117, 140, 1),
(117, 141, 1),
(119, 5, 1),
(119, 6, 1),
(119, 7, 1),
(119, 10, 1),
(119, 11, 1),
(119, 13, 1),
(119, 14, 1),
(119, 15, 1),
(119, 17, 1),
(119, 18, 1),
(119, 19, 1),
(119, 20, 1),
(119, 23, 1),
(119, 25, 1),
(119, 27, 1),
(119, 28, 1),
(119, 29, 1),
(119, 32, 1),
(119, 33, 1),
(119, 35, 1),
(119, 39, 1),
(119, 43, 1),
(119, 50, 1),
(119, 51, 1),
(119, 52, 1),
(119, 53, 1),
(119, 54, 1),
(119, 58, 1),
(119, 59, 1),
(119, 65, 1),
(119, 66, 1),
(119, 67, 1),
(119, 74, 1),
(119, 76, 1),
(119, 77, 1),
(119, 80, 1),
(119, 83, 1),
(119, 84, 2),
(119, 85, 1),
(119, 86, 1),
(119, 90, 1),
(119, 100, 1),
(119, 104, 2),
(119, 108, 1),
(119, 109, 1),
(119, 111, 1),
(119, 112, 1),
(119, 113, 1),
(119, 115, 1),
(119, 117, 1),
(119, 119, 1),
(119, 120, 1),
(119, 121, 1),
(119, 122, 1),
(119, 126, 1),
(119, 128, 1),
(119, 131, 1),
(119, 132, 1),
(119, 133, 1),
(119, 134, 1),
(119, 136, 1),
(119, 139, 1),
(119, 140, 1),
(120, 1, 1),
(120, 2, 1),
(120, 3, 1),
(120, 5, 1),
(120, 6, 1),
(120, 7, 1),
(120, 8, 1),
(120, 9, 1),
(120, 10, 1),
(120, 11, 1),
(120, 12, 1),
(120, 13, 1),
(120, 14, 1),
(120, 15, 1),
(120, 17, 1),
(120, 19, 1),
(120, 20, 1),
(120, 23, 1),
(120, 24, 1),
(120, 25, 1),
(120, 26, 1),
(120, 27, 1),
(120, 28, 1),
(120, 29, 1),
(120, 32, 1),
(120, 35, 1),
(120, 38, 1),
(120, 39, 1),
(120, 41, 1),
(120, 43, 1),
(120, 44, 1),
(120, 46, 1),
(120, 48, 1),
(120, 49, 1),
(120, 51, 1),
(120, 52, 1),
(120, 53, 1),
(120, 58, 1),
(120, 60, 1),
(120, 61, 1),
(120, 65, 1),
(120, 67, 1),
(120, 69, 1),
(120, 71, 1),
(120, 74, 1),
(120, 76, 1),
(120, 77, 1),
(120, 78, 1),
(120, 79, 1),
(120, 81, 1),
(120, 82, 1),
(120, 83, 1),
(120, 84, 2),
(120, 85, 1),
(120, 86, 1),
(120, 88, 2),
(120, 89, 1),
(120, 90, 1),
(120, 91, 2),
(120, 92, 1),
(120, 93, 1),
(120, 96, 1),
(120, 98, 1),
(120, 99, 2),
(120, 100, 1),
(120, 101, 1),
(120, 103, 1),
(120, 104, 2),
(120, 108, 1),
(120, 109, 1),
(120, 110, 1),
(120, 111, 1),
(120, 112, 1),
(120, 113, 1),
(120, 114, 1),
(120, 115, 1),
(120, 117, 1),
(120, 118, 1),
(120, 119, 1),
(120, 120, 1),
(120, 121, 1),
(120, 122, 1),
(120, 126, 1),
(120, 128, 1),
(120, 130, 1),
(120, 131, 1),
(120, 132, 1),
(120, 133, 1),
(120, 134, 1),
(120, 135, 1),
(120, 136, 1),
(120, 139, 1),
(120, 140, 1),
(124, 25, 1),
(124, 26, 1),
(124, 28, 1),
(124, 30, 1),
(124, 40, 1),
(124, 41, 1),
(124, 42, 1),
(124, 43, 1),
(124, 45, 1),
(124, 47, 1),
(124, 49, 1),
(124, 50, 1),
(124, 51, 1),
(124, 52, 1),
(124, 53, 1),
(124, 54, 1),
(124, 56, 1),
(124, 57, 1),
(124, 59, 1),
(124, 63, 1),
(124, 64, 1),
(124, 66, 1),
(124, 67, 1),
(124, 72, 1),
(124, 73, 1),
(124, 74, 1),
(124, 76, 1),
(124, 77, 1),
(124, 78, 1),
(124, 80, 1),
(124, 82, 1),
(124, 86, 1),
(124, 87, 1),
(124, 89, 1),
(124, 91, 2),
(124, 92, 1),
(124, 98, 1),
(124, 100, 1),
(124, 102, 1),
(124, 105, 1),
(124, 109, 1),
(124, 112, 1),
(124, 113, 1),
(124, 114, 1),
(124, 115, 1),
(124, 116, 1),
(124, 117, 1),
(124, 118, 1),
(124, 119, 1),
(124, 120, 1),
(124, 121, 1),
(124, 124, 1),
(124, 126, 1),
(124, 127, 1),
(124, 128, 1),
(124, 130, 1),
(124, 131, 1),
(124, 132, 1),
(124, 134, 1),
(124, 135, 1),
(124, 136, 1),
(124, 139, 1),
(127, 1, 1),
(127, 5, 1),
(127, 7, 1),
(127, 8, 1),
(127, 9, 1),
(127, 10, 1),
(127, 11, 1),
(127, 13, 1),
(127, 14, 1),
(127, 16, 1),
(127, 17, 1),
(127, 18, 1),
(127, 19, 1),
(127, 20, 1),
(127, 21, 1),
(127, 22, 1),
(127, 25, 1),
(127, 26, 1),
(127, 27, 1),
(127, 28, 1),
(127, 29, 1),
(127, 30, 1),
(127, 31, 1),
(127, 33, 1),
(127, 35, 1),
(127, 36, 1),
(127, 37, 1),
(127, 39, 1),
(127, 40, 1),
(127, 41, 1),
(127, 42, 1),
(127, 43, 1),
(127, 44, 1),
(127, 45, 1),
(127, 46, 1),
(127, 47, 1),
(127, 48, 1),
(127, 49, 1),
(127, 50, 1),
(127, 51, 1),
(127, 52, 1),
(127, 54, 1),
(127, 55, 1),
(127, 56, 1),
(127, 57, 1),
(127, 58, 1),
(127, 60, 1),
(127, 62, 1),
(127, 63, 1),
(127, 64, 1),
(127, 65, 1),
(127, 66, 1),
(127, 67, 1),
(127, 68, 1),
(127, 70, 1),
(127, 71, 1),
(127, 72, 1),
(127, 73, 1),
(127, 74, 1),
(127, 75, 1),
(127, 76, 1),
(127, 77, 1),
(127, 78, 1),
(127, 79, 1),
(127, 80, 1),
(127, 81, 1),
(127, 83, 1),
(127, 84, 2),
(127, 85, 1),
(127, 86, 1),
(127, 87, 1),
(127, 88, 2),
(127, 89, 1),
(127, 92, 1),
(127, 93, 1),
(127, 96, 1),
(127, 98, 1),
(127, 99, 2),
(127, 108, 1),
(127, 109, 1),
(127, 110, 1),
(127, 112, 1),
(127, 113, 1),
(127, 118, 1),
(127, 119, 1),
(127, 120, 1),
(127, 121, 1),
(127, 122, 1),
(127, 123, 1),
(127, 124, 1),
(127, 127, 1),
(127, 132, 1),
(127, 133, 1),
(127, 134, 1),
(127, 135, 1),
(127, 139, 1),
(127, 140, 1),
(127, 141, 1),
(152, 1, 1),
(152, 5, 1),
(152, 7, 1),
(152, 8, 1),
(152, 10, 1),
(152, 11, 1),
(152, 14, 1),
(152, 15, 1),
(152, 17, 1),
(152, 18, 1),
(152, 19, 1),
(152, 24, 1),
(152, 25, 1),
(152, 26, 1),
(152, 27, 1),
(152, 28, 1),
(152, 29, 1),
(152, 32, 1),
(152, 33, 1),
(152, 35, 1),
(152, 36, 1),
(152, 40, 1),
(152, 41, 1),
(152, 43, 1),
(152, 45, 1),
(152, 50, 1),
(152, 51, 1),
(152, 53, 1),
(152, 55, 1),
(152, 57, 1),
(152, 58, 1),
(152, 60, 1),
(152, 61, 1),
(152, 67, 1),
(152, 68, 1),
(152, 69, 1),
(152, 70, 1),
(152, 72, 1),
(152, 73, 1),
(152, 75, 1),
(152, 76, 1),
(152, 77, 1),
(152, 78, 1),
(152, 81, 1),
(152, 86, 1),
(152, 89, 1),
(152, 90, 1),
(152, 96, 1),
(152, 99, 2),
(152, 100, 1),
(152, 102, 1),
(152, 106, 2),
(152, 107, 2),
(152, 109, 1),
(152, 111, 1),
(152, 112, 1),
(152, 114, 1),
(152, 115, 1),
(152, 117, 1),
(152, 118, 1),
(152, 119, 1),
(152, 120, 1),
(152, 122, 1),
(152, 126, 1),
(152, 131, 1),
(152, 132, 1),
(152, 136, 1),
(152, 140, 1),
(152, 141, 1),
(154, 83, 1),
(154, 85, 1),
(154, 86, 1),
(154, 89, 1),
(154, 90, 1),
(154, 92, 1),
(154, 94, 1),
(154, 97, 1),
(154, 98, 1),
(154, 99, 2),
(154, 100, 1),
(154, 101, 1),
(154, 109, 1),
(154, 110, 1),
(154, 111, 1),
(154, 112, 1),
(154, 113, 1),
(154, 115, 1),
(154, 116, 1),
(154, 117, 1),
(154, 118, 1),
(154, 119, 1),
(154, 120, 1),
(154, 121, 1),
(154, 123, 1),
(154, 124, 1),
(154, 125, 1),
(154, 126, 1),
(154, 127, 1),
(154, 128, 1),
(154, 131, 1),
(154, 132, 1),
(154, 134, 1),
(154, 139, 1),
(154, 140, 1),
(155, 1, 1),
(155, 2, 1),
(155, 3, 1),
(155, 5, 1),
(155, 6, 1),
(155, 8, 1),
(155, 10, 1),
(155, 11, 1),
(155, 13, 1),
(155, 14, 1),
(155, 16, 1),
(155, 17, 1),
(155, 18, 1),
(155, 19, 1),
(155, 24, 1),
(155, 25, 1),
(155, 27, 1),
(155, 28, 1),
(155, 29, 1),
(155, 30, 1),
(155, 33, 1),
(155, 34, 1),
(155, 37, 1),
(155, 40, 1),
(155, 43, 1),
(155, 51, 1),
(155, 55, 1),
(155, 56, 1),
(155, 57, 1),
(156, 1, 1),
(156, 2, 1),
(156, 3, 1),
(156, 5, 1),
(156, 6, 1),
(156, 8, 1),
(156, 10, 1),
(156, 11, 1),
(156, 13, 1),
(156, 14, 1),
(156, 16, 1),
(156, 17, 1),
(156, 18, 1),
(156, 19, 1),
(156, 24, 1),
(156, 25, 1),
(156, 26, 1),
(156, 27, 1),
(156, 28, 1),
(156, 29, 1),
(156, 32, 1),
(156, 33, 1),
(156, 34, 1),
(156, 37, 1),
(156, 40, 1),
(156, 43, 1),
(156, 51, 1),
(156, 52, 1),
(156, 53, 1),
(156, 54, 1),
(156, 55, 1),
(156, 56, 1),
(156, 57, 1),
(156, 58, 1),
(156, 59, 1),
(156, 68, 1),
(161, 21, 1),
(161, 22, 1),
(161, 23, 1),
(161, 24, 1),
(161, 25, 1),
(161, 27, 1),
(161, 28, 1),
(161, 29, 1),
(161, 30, 1),
(161, 31, 1),
(161, 32, 1),
(161, 33, 1),
(161, 34, 1),
(161, 35, 1),
(161, 37, 1),
(161, 38, 1),
(161, 39, 1),
(161, 40, 1),
(161, 45, 1),
(161, 49, 1),
(161, 50, 1),
(161, 51, 1),
(161, 52, 1),
(161, 53, 1),
(161, 55, 1),
(161, 57, 1),
(161, 58, 1),
(161, 59, 1),
(161, 60, 1),
(161, 62, 1),
(161, 63, 1),
(161, 64, 1),
(161, 66, 1),
(161, 67, 1),
(161, 69, 1),
(161, 71, 1),
(161, 74, 1),
(161, 75, 1),
(161, 77, 1),
(161, 79, 1),
(161, 80, 1),
(161, 81, 1),
(161, 82, 1),
(161, 83, 1),
(161, 85, 1),
(161, 86, 1),
(161, 88, 2),
(161, 89, 1),
(161, 90, 1),
(161, 92, 1),
(161, 94, 1),
(161, 95, 2),
(161, 97, 1),
(161, 98, 1),
(161, 99, 2),
(161, 100, 1),
(161, 101, 1),
(161, 104, 2),
(161, 107, 2),
(161, 108, 1),
(161, 109, 1),
(161, 110, 1),
(161, 111, 1),
(161, 112, 1),
(161, 113, 1),
(161, 114, 1),
(161, 115, 1),
(161, 116, 1),
(161, 117, 1),
(161, 118, 1),
(161, 119, 1),
(161, 120, 1),
(161, 121, 1),
(161, 122, 1),
(161, 124, 1),
(161, 126, 1),
(161, 127, 1),
(161, 128, 1),
(161, 129, 1),
(161, 131, 1),
(161, 132, 1),
(161, 133, 1),
(161, 134, 1),
(161, 135, 1),
(161, 139, 1),
(161, 140, 1),
(161, 141, 1),
(162, 24, 1),
(162, 27, 1),
(162, 29, 1),
(162, 30, 1),
(162, 34, 1),
(162, 49, 1),
(162, 50, 1),
(162, 51, 1),
(162, 55, 1),
(162, 57, 1),
(162, 59, 1),
(163, 2, 1),
(163, 3, 1),
(163, 4, 1),
(163, 5, 1),
(163, 7, 1),
(163, 8, 1),
(163, 9, 1),
(163, 10, 1),
(163, 11, 1),
(163, 12, 1),
(163, 13, 1),
(163, 14, 1),
(163, 15, 1),
(163, 16, 1),
(163, 17, 1),
(163, 18, 1),
(163, 20, 1),
(163, 22, 1),
(163, 24, 1),
(163, 25, 1),
(163, 31, 1),
(163, 33, 1),
(163, 35, 1),
(163, 36, 1),
(163, 37, 1),
(163, 41, 1),
(163, 49, 1),
(163, 62, 1),
(163, 64, 1),
(163, 117, 1),
(163, 118, 1),
(163, 120, 1),
(163, 121, 1),
(163, 123, 1),
(163, 127, 1),
(163, 130, 1),
(163, 131, 1),
(163, 132, 1),
(163, 134, 1),
(163, 135, 1),
(163, 136, 1),
(163, 141, 1),
(164, 1, 1),
(164, 2, 1),
(164, 5, 1),
(164, 6, 1),
(164, 7, 1),
(164, 8, 1),
(164, 9, 1),
(164, 10, 1),
(164, 12, 1),
(164, 13, 1),
(164, 14, 1),
(164, 15, 1),
(164, 16, 1),
(164, 17, 1),
(164, 18, 1),
(164, 19, 1),
(164, 21, 1),
(164, 24, 1),
(164, 25, 1),
(164, 26, 1),
(164, 27, 1),
(164, 28, 1),
(164, 29, 1),
(164, 30, 1),
(164, 33, 1),
(164, 34, 1),
(164, 35, 1),
(164, 36, 1),
(164, 40, 1),
(164, 41, 1),
(164, 42, 1),
(164, 43, 1),
(164, 44, 1),
(164, 45, 1),
(164, 48, 1),
(164, 49, 1),
(164, 50, 1),
(164, 51, 1),
(164, 53, 1),
(164, 54, 1),
(164, 55, 1),
(164, 56, 1),
(164, 57, 1),
(164, 58, 1),
(164, 59, 1),
(164, 60, 1),
(164, 61, 1),
(164, 63, 1),
(164, 64, 1),
(164, 65, 1),
(164, 66, 1),
(164, 67, 1),
(164, 68, 1),
(164, 69, 1),
(164, 70, 1),
(164, 72, 1),
(164, 75, 1),
(164, 76, 1),
(164, 77, 1),
(164, 78, 1),
(164, 79, 1),
(164, 80, 1),
(164, 81, 1),
(164, 82, 1),
(164, 83, 1),
(164, 84, 2),
(164, 85, 1),
(164, 86, 1),
(164, 87, 1),
(164, 89, 1),
(164, 90, 1),
(164, 91, 2),
(164, 96, 1),
(164, 97, 1),
(164, 98, 1),
(164, 99, 2),
(164, 100, 1),
(164, 101, 1),
(164, 102, 1),
(164, 107, 2),
(164, 108, 1),
(164, 109, 1),
(164, 110, 1),
(164, 111, 1),
(164, 113, 1),
(164, 114, 1),
(164, 115, 1),
(164, 116, 1),
(164, 117, 1),
(164, 119, 1),
(164, 120, 1),
(164, 121, 1),
(164, 122, 1),
(164, 123, 1),
(164, 126, 1),
(164, 127, 1),
(164, 128, 1),
(164, 129, 1),
(164, 130, 1),
(164, 132, 1),
(164, 133, 1),
(164, 134, 1),
(164, 136, 1),
(164, 139, 1),
(164, 140, 1),
(164, 141, 1),
(165, 2, 1),
(165, 5, 1),
(165, 6, 1),
(165, 7, 1),
(165, 8, 1),
(165, 9, 1),
(165, 10, 1),
(165, 11, 1),
(165, 12, 1),
(165, 14, 1),
(165, 18, 1),
(165, 19, 1),
(165, 26, 1),
(165, 29, 1),
(165, 32, 1),
(165, 33, 1),
(165, 35, 1),
(165, 52, 1),
(165, 53, 1),
(165, 54, 1),
(165, 55, 1),
(165, 56, 1),
(165, 57, 1),
(165, 58, 1),
(165, 59, 1),
(165, 72, 1),
(165, 74, 1),
(165, 77, 1),
(165, 100, 1),
(165, 102, 1),
(165, 109, 1),
(165, 111, 1),
(165, 113, 1),
(165, 115, 1),
(165, 118, 1),
(165, 119, 1),
(165, 120, 1),
(165, 122, 1),
(165, 123, 1),
(165, 124, 1),
(165, 125, 1),
(165, 126, 1),
(165, 127, 1),
(165, 132, 1),
(165, 133, 1),
(165, 134, 1),
(165, 135, 1),
(165, 139, 1),
(165, 140, 1),
(171, 26, 1),
(171, 27, 1),
(171, 28, 1),
(171, 29, 1),
(171, 30, 1),
(171, 31, 1),
(171, 32, 1),
(171, 33, 1),
(171, 34, 1),
(171, 35, 1),
(171, 36, 1),
(171, 37, 1),
(171, 38, 1),
(171, 39, 1),
(171, 40, 1),
(171, 42, 1),
(171, 44, 1),
(171, 45, 1),
(171, 46, 1),
(171, 47, 1),
(171, 48, 1),
(171, 49, 1),
(171, 50, 1),
(171, 51, 1),
(171, 52, 1),
(171, 53, 1),
(171, 55, 1),
(171, 57, 1),
(171, 58, 1),
(171, 59, 1),
(171, 60, 1),
(171, 61, 1),
(171, 62, 1),
(171, 63, 1),
(171, 64, 1),
(171, 65, 1),
(171, 66, 1),
(171, 67, 1),
(171, 68, 1),
(171, 69, 1),
(171, 70, 1),
(171, 71, 1),
(171, 72, 1),
(171, 74, 1),
(171, 75, 1),
(171, 76, 1),
(171, 77, 1),
(171, 78, 1),
(171, 79, 1),
(171, 80, 1),
(171, 81, 1),
(171, 82, 1),
(171, 83, 1),
(171, 84, 2),
(171, 85, 1),
(171, 86, 1),
(171, 88, 2),
(171, 89, 1),
(171, 90, 1),
(171, 92, 1),
(171, 93, 1),
(171, 94, 1),
(171, 95, 2),
(171, 96, 1),
(171, 97, 1),
(171, 98, 1),
(171, 99, 2),
(171, 100, 1),
(171, 101, 1),
(171, 102, 1),
(171, 103, 1),
(171, 104, 2),
(171, 107, 2),
(171, 108, 1),
(171, 109, 1),
(171, 110, 1),
(171, 111, 1),
(171, 112, 1),
(171, 113, 1),
(171, 114, 1),
(171, 115, 1),
(171, 116, 1),
(171, 117, 1),
(171, 118, 1),
(171, 119, 1),
(171, 120, 1),
(171, 121, 1),
(171, 122, 1),
(171, 124, 1),
(171, 126, 1),
(171, 127, 1),
(171, 128, 1),
(171, 129, 1),
(171, 131, 1),
(171, 132, 1),
(171, 133, 1),
(171, 134, 1),
(171, 135, 1),
(171, 136, 1),
(171, 138, 2),
(171, 139, 1),
(171, 140, 1),
(171, 141, 1),
(172, 78, 1),
(172, 81, 1),
(172, 85, 1),
(172, 86, 1),
(172, 87, 1),
(172, 89, 1),
(172, 90, 1),
(172, 92, 1),
(172, 93, 1),
(172, 94, 1),
(172, 96, 1),
(172, 97, 1),
(172, 98, 1),
(172, 101, 1),
(172, 102, 1),
(172, 105, 1),
(172, 109, 1),
(172, 110, 1),
(172, 111, 1),
(172, 112, 1),
(172, 113, 1),
(172, 114, 1),
(172, 115, 1),
(172, 117, 1),
(172, 118, 1),
(172, 119, 1),
(172, 120, 1),
(172, 122, 1),
(172, 123, 1),
(172, 124, 1),
(172, 126, 1),
(172, 127, 1),
(172, 128, 1),
(172, 130, 1),
(172, 131, 1),
(172, 132, 1),
(172, 134, 1),
(172, 135, 1),
(172, 136, 1),
(172, 139, 1),
(172, 140, 1),
(172, 141, 1),
(173, 40, 1),
(173, 41, 1),
(173, 42, 1),
(173, 43, 1),
(173, 44, 1),
(173, 45, 1),
(173, 46, 1),
(173, 47, 1),
(173, 48, 1),
(173, 49, 1),
(173, 50, 1),
(173, 51, 1),
(173, 52, 1),
(173, 54, 1),
(173, 55, 1),
(173, 56, 1),
(173, 57, 1),
(173, 58, 1),
(173, 60, 1),
(173, 61, 1),
(173, 62, 1),
(173, 63, 1),
(173, 64, 1),
(173, 65, 1),
(173, 66, 1),
(173, 67, 1),
(173, 68, 1),
(173, 69, 1),
(173, 70, 1),
(173, 71, 1),
(173, 72, 1),
(173, 73, 1),
(173, 74, 1),
(173, 75, 1),
(173, 76, 1),
(173, 78, 1),
(173, 79, 1),
(173, 80, 1),
(173, 81, 1),
(173, 83, 1),
(173, 84, 2),
(173, 85, 1),
(173, 86, 1),
(173, 87, 1),
(173, 88, 2),
(173, 89, 1),
(173, 92, 1),
(173, 93, 1),
(173, 96, 1),
(173, 98, 1),
(173, 99, 2),
(173, 100, 1),
(173, 101, 1),
(173, 102, 1),
(173, 103, 1),
(173, 104, 2),
(173, 105, 1),
(173, 106, 2),
(173, 108, 1),
(173, 109, 1),
(173, 110, 1),
(173, 111, 1),
(173, 112, 1),
(173, 113, 1),
(173, 118, 1),
(173, 119, 1),
(173, 120, 1),
(173, 121, 1),
(173, 122, 1),
(173, 123, 1),
(173, 124, 1),
(173, 132, 1),
(173, 133, 1),
(173, 134, 1),
(173, 135, 1),
(173, 139, 1),
(173, 140, 1),
(173, 141, 1),
(175, 67, 1),
(175, 69, 1),
(175, 71, 1),
(175, 74, 1),
(175, 75, 1),
(175, 76, 1),
(175, 77, 1),
(175, 78, 1),
(175, 80, 1),
(175, 81, 1),
(175, 83, 1),
(175, 84, 2),
(175, 86, 1),
(175, 89, 1),
(175, 90, 1),
(175, 119, 1),
(175, 120, 1),
(175, 122, 1),
(175, 123, 1),
(175, 124, 1),
(175, 125, 1),
(175, 126, 1),
(175, 129, 1),
(175, 130, 1),
(175, 135, 1),
(175, 136, 1),
(175, 137, 2),
(175, 139, 1),
(176, 109, 1),
(176, 110, 1),
(176, 111, 1),
(176, 112, 1),
(176, 113, 1),
(176, 114, 1),
(176, 115, 1),
(176, 116, 1),
(176, 118, 1),
(176, 119, 1),
(176, 120, 1),
(176, 121, 1),
(176, 122, 1),
(176, 123, 1),
(176, 124, 1),
(176, 125, 1),
(176, 127, 1),
(176, 131, 1),
(176, 132, 1),
(176, 133, 1),
(176, 134, 1),
(176, 139, 1),
(176, 140, 1),
(177, 109, 1),
(177, 110, 1),
(177, 111, 1),
(177, 112, 1),
(177, 113, 1),
(177, 114, 1),
(177, 115, 1),
(177, 116, 1),
(177, 118, 1),
(177, 119, 1),
(177, 120, 1),
(177, 121, 1),
(177, 122, 1),
(177, 123, 1),
(177, 124, 1),
(177, 125, 1),
(177, 127, 1),
(177, 131, 1),
(177, 132, 1),
(177, 133, 1),
(177, 134, 1),
(177, 139, 1),
(177, 140, 1),
(178, 109, 1),
(178, 110, 1),
(178, 112, 1),
(178, 113, 1),
(178, 114, 1),
(178, 115, 1),
(178, 116, 1),
(178, 117, 1),
(178, 118, 1),
(178, 119, 1),
(178, 121, 1),
(178, 123, 1),
(178, 125, 1),
(178, 126, 1),
(178, 127, 1),
(178, 131, 1),
(178, 132, 1),
(178, 134, 1),
(178, 140, 1),
(184, 110, 1),
(184, 113, 1),
(184, 114, 1),
(184, 118, 1),
(184, 119, 1),
(184, 120, 1),
(184, 121, 1),
(184, 122, 1),
(184, 123, 1),
(184, 125, 1),
(184, 126, 1),
(184, 127, 1),
(184, 128, 1),
(184, 129, 1),
(184, 131, 1),
(184, 132, 1),
(184, 133, 1),
(184, 134, 1),
(184, 139, 1),
(184, 140, 1),
(184, 141, 1),
(186, 109, 1),
(186, 110, 1),
(186, 112, 1),
(186, 113, 1),
(187, 109, 1),
(187, 110, 1),
(187, 111, 1),
(187, 113, 1),
(187, 114, 1),
(187, 116, 1),
(187, 117, 1),
(187, 118, 1),
(187, 119, 1),
(187, 120, 1),
(187, 122, 1),
(187, 123, 1),
(187, 124, 1),
(187, 125, 1),
(187, 126, 1),
(187, 127, 1),
(187, 130, 1),
(187, 132, 1),
(187, 133, 1),
(187, 134, 1),
(187, 135, 1),
(187, 136, 1),
(187, 138, 2),
(187, 139, 1),
(187, 140, 1),
(187, 141, 1),
(188, 109, 1),
(188, 110, 1),
(188, 112, 1),
(188, 113, 1),
(188, 114, 1),
(188, 115, 1),
(188, 116, 1),
(188, 117, 1),
(188, 118, 1),
(188, 119, 1),
(188, 120, 1),
(188, 121, 1),
(188, 122, 1),
(188, 123, 1),
(188, 125, 1),
(188, 126, 1),
(188, 127, 1),
(188, 128, 1),
(188, 131, 1),
(188, 132, 1),
(188, 134, 1),
(188, 139, 1),
(188, 140, 1),
(188, 141, 1);

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

--
-- Structure de la table `cdc_locaux`
--

CREATE TABLE `cdc_locaux` (
  `idloc` int(11) NOT NULL COMMENT 'ID du local de répétition',
  `local` varchar(40) NOT NULL COMMENT 'Désignation du local',
  `cpostal` char(5) NOT NULL COMMENT 'Code postal du local',
  `ville` varchar(25) NOT NULL COMMENT 'Ville du local'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table des locaux de répétitions';

--
-- Déchargement des données de la table `cdc_locaux`
--

INSERT INTO `cdc_locaux` (`idloc`, `local`, `cpostal`, `ville`) VALUES
(1, 'Salle Mont Charvin', '73800', 'Cruet'),
(2, '', '73130', 'Sainte-Marie-de-Cuines');

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

--
-- Structure de la table `cdc_repetitions`
--

CREATE TABLE `cdc_repetitions` (
  `idrep` int(11) NOT NULL COMMENT 'ID de la répétition',
  `drepet` date NOT NULL COMMENT 'Date de la répétition'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table des répétitions';

--
-- Déchargement des données de la table `cdc_repetitions`
--

INSERT INTO `cdc_repetitions` (`idrep`, `drepet`) VALUES
(1, '2015-01-09'),
(2, '2015-01-16'),
(3, '2015-01-23'),
(4, '2015-02-13'),
(5, '2015-02-27'),
(6, '2015-03-06'),
(7, '2015-03-13'),
(8, '2015-03-27'),
(9, '2015-04-03'),
(10, '2015-04-10'),
(11, '2015-04-17'),
(12, '2015-04-24'),
(13, '2015-04-30'),
(14, '2015-05-07'),
(15, '2015-05-15'),
(16, '2015-05-22'),
(17, '2015-05-29'),
(18, '2015-06-05'),
(19, '2015-06-12'),
(20, '2015-06-26'),
(21, '2015-07-10'),
(22, '2015-07-17'),
(23, '2015-08-28'),
(24, '2015-09-04'),
(25, '2015-09-11'),
(26, '2015-09-25'),
(27, '2015-10-02'),
(28, '2015-10-09'),
(29, '2015-10-16'),
(30, '2015-10-23'),
(31, '2015-10-30'),
(32, '2015-11-10'),
(33, '2015-11-13'),
(34, '2015-11-17'),
(35, '2015-11-20'),
(36, '2015-11-27'),
(37, '2015-12-04'),
(38, '2015-12-11'),
(39, '2015-12-18'),
(40, '2016-01-08'),
(41, '2016-01-15'),
(42, '2016-01-22'),
(43, '2016-01-29'),
(44, '2016-02-05'),
(45, '2016-02-12'),
(46, '2016-02-26'),
(47, '2016-02-26'),
(48, '2016-03-04'),
(49, '2016-03-18'),
(50, '2016-03-25'),
(51, '2016-04-01'),
(52, '2016-04-08'),
(53, '2016-04-15'),
(54, '2016-04-22'),
(55, '2016-04-29'),
(56, '2016-05-13'),
(57, '2016-05-20'),
(58, '2016-05-27'),
(59, '2016-06-03'),
(60, '2016-06-17'),
(61, '2016-06-24'),
(62, '2016-07-12'),
(63, '2016-07-22'),
(64, '2016-07-29'),
(65, '2016-08-26'),
(66, '2016-09-09'),
(67, '2016-09-16'),
(68, '2016-09-23'),
(69, '2016-09-30'),
(70, '2016-10-07'),
(71, '2016-10-14'),
(72, '2016-10-21'),
(73, '2016-10-28'),
(74, '2016-11-04'),
(75, '2016-11-11'),
(76, '2016-11-18'),
(77, '2016-11-25'),
(78, '2016-12-02'),
(79, '2016-12-09'),
(80, '2016-12-16'),
(81, '2017-01-06'),
(82, '2017-01-13'),
(83, '2017-01-27'),
(84, '2017-02-03'),
(85, '2017-02-10'),
(86, '2017-02-17'),
(87, '2017-02-24'),
(88, '2017-03-03'),
(89, '2017-03-10'),
(90, '2017-03-17'),
(91, '2017-04-07'),
(92, '2017-04-14'),
(93, '2017-04-21'),
(94, '2017-04-28'),
(95, '2017-05-05'),
(96, '2017-05-12'),
(97, '2017-05-19'),
(98, '2017-05-26'),
(99, '2017-06-02'),
(100, '2017-06-09'),
(101, '2017-06-16'),
(102, '2017-06-23'),
(103, '2017-06-30'),
(104, '2017-07-07'),
(105, '2017-07-21'),
(106, '2017-07-28'),
(107, '2017-08-04'),
(108, '2017-08-25'),
(109, '2017-09-29'),
(110, '2017-09-01'),
(111, '2017-09-08'),
(112, '2017-09-15'),
(113, '2017-10-06'),
(114, '2017-10-13'),
(115, '2017-10-20'),
(116, '2017-10-27'),
(117, '2017-11-03'),
(118, '2017-11-10'),
(119, '2017-11-17'),
(120, '2017-11-24'),
(121, '2017-12-01'),
(122, '2017-12-08'),
(123, '2017-12-15'),
(124, '2018-01-05'),
(125, '2018-01-12'),
(126, '2018-01-19'),
(127, '2018-01-26'),
(128, '2018-02-09'),
(129, '2018-02-16'),
(130, '2018-02-23'),
(131, '2018-03-09'),
(132, '2018-03-23'),
(133, '2018-03-30'),
(134, '2018-04-06'),
(135, '2018-04-13'),
(136, '2018-04-20'),
(137, '2018-02-28'),
(138, '2018-04-25'),
(139, '2018-04-27'),
(140, '2018-05-04'),
(141, '2018-05-18');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `cdc_assister`
--
ALTER TABLE `cdc_assister`
  ADD PRIMARY KEY (`idpers`,`idrep`,`idloc`);

--
-- Index pour la table `cdc_locaux`
--
ALTER TABLE `cdc_locaux`
  ADD PRIMARY KEY (`idloc`);

--
-- Index pour la table `cdc_repetitions`
--
ALTER TABLE `cdc_repetitions`
  ADD PRIMARY KEY (`idrep`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `cdc_locaux`
--
ALTER TABLE `cdc_locaux`
  MODIFY `idloc` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID du local de répétition', AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `cdc_repetitions`
--
ALTER TABLE `cdc_repetitions`
  MODIFY `idrep` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID de la répétition', AUTO_INCREMENT=142;COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    0
  8. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
     
    Ceci fonctionne parfaitement 
    SELECT YEAR(R.drepet) AS annee, 
       COUNT(R.idrep) AS nbrep
FROM cdc_repetitions R
LEFT JOIN cdc_assister A ON A.idrep = R.idrep
LEFT JOIN cdc_locaux L ON L.idloc = A.idloc
WHERE  A.idloc = 2
GROUP BY annee
ORDER BY annee


    Ou si tu veux "décomposer", tu peux aussi faire: 
    SELECT T.* 
   ,COUNT(T.idrep) AS nbrep
FROM (
SELECT YEAR(R.drepet) AS annee
	,R.idrep
	,A.idloc
FROM cdc_repetitions R
LEFT JOIN cdc_assister A ON A.idrep = R.idrep
LEFT JOIN cdc_locaux L ON L.idloc = A.idloc
WHERE A.idloc = 2
	) T
GROUP BY T.annee
ORDER BY T.annee


    Ce qui, au final, retourne bien exactement le même résultat que ta requête initiale 
    SELECT YEAR(cdc_repetitions.drepet) AS annee, COUNT(cdc_repetitions.idrep) AS nbrep
FROM cdc_repetitions,cdc_assister,cdc_locaux
WHERE cdc_locaux.idloc = cdc_assister.idloc
	AND cdc_repetitions.idrep = cdc_assister.idrep
	AND cdc_assister.idloc = 2
GROUP BY annee
ORDER BY annee
    0
  9. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    Bonjour
    Le résultat n'est toujours pas bon. En fait j'ai regardé et il se trouve par exemple en 2018 nous avons eu 2 répétitions "idrep 137" et "idrep 138" avec la condition "idloc est à 2" et le résultat me retourne le tableau suivant.
    Année Nombre
    2018 8
    0
  10. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    J'ai essayé dans phpmyadmin et voici le résultat
    annee idrep idloc nbrep
    2017 88 2 88
    2018 138 2 8
    0
  11. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    En fait j'ai analyser le résultat de la requète et je me suis aperçu que nbrep corresponds au nombre de personnes présente pour chaque année au lieu du nombre de répétitions, c'est à dire 88 et 8
    0
    1. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      Si c'est le nombre de répétitions que tu veux uniquement... pas besoin de jointure ! 
      SELECT YEAR(R.drepet) AS annee, 
       COUNT(R.idrep) AS nbrep
FROM cdc_repetitions R
GROUP BY YEAR(R.drepet) 
ORDER BY YEAR(R.drepet)
      0
  12. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    oui c'est bien le nombre de répétitions par année que je souhaite mais avec une condition:
    WHERE cdc_assister.idloc = 2
    J'ai essayer mais cela ne le fait pas.
    0
    1. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      Ta base est mal conçue...
      Pourquoi avoir placé le idloc dans la table cdc_assister ?
      La localisation doit bien correspondre à la répétition....
      Je doute que pour une même répétition tu aies des gens dans différentes salles...... non ?
      0
    2. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      Si vraiment tu tiens à conserver tes tables comme ça ( ça serait une drôle d'idée....) voici la requête que tu sembles vouloir obtenir 
      SELECT T.* 
   ,COUNT(T.idrep) AS nbrep
FROM (
	SELECT YEAR(R.drepet) AS annee
		,R.idrep
		,A.idloc
	FROM cdc_repetitions R
	LEFT JOIN cdc_assister A ON A.idrep = R.idrep
	LEFT JOIN cdc_locaux L ON L.idloc = A.idloc
	WHERE A.idloc = 2
	GROUP BY R.idrep
		) T
GROUP BY T.annee
ORDER BY T.annee
      0
  13. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    Oui tu as raison j'aurai pu mettrre idloc dans la table cdc_repetitions pas bien réfléchis. Je vais voir si je peux faire cette modification sans trop de risque. Par contre ta requète fonctionne c'est bien ce que je souhaitais.
    Je ne comprends pas SELECT T.* si tu peux m'expliquer.
    Je te remercie.
    0
    1. jordane45 Messages postés 30426 Date d'inscription   Statut Modérateur Dernière intervention   4 830
       
      "T" c'est l'alias de la table dérivée ( provenant de la sous-requête utilisée dans le FROM )
      • c'est pour récupérer TOUS les champs ( à savoir.. ceux qui sont dans le SELECT de la table dérivée )

      Ici : 
      SELECT YEAR(R.drepet) AS annee
		,R.idrep
		,A.idloc
      0
  14. LaChaux78 Messages postés 585 Date d'inscription   Statut Membre Dernière intervention   32
     
    Bonjour,
    J'ai modifié mes deux tables comme tu me l'a dit et du coup le requète est beaucoup plus simple .
    Je te remercie.
    0

Discussions similaires

Téléphone en condition optimale...?
Elka_3079 -
Baleinotte -

2 réponses
Changer la couleur d'une cellule selon son texte
fantomex -
Picton -

5 réponses
enlever mode sécurisé huawei
faihere26 -
mpuissance4 -

1 réponse
Excel et cellules en couleur si texte
Jimmy -
Chap -

10 réponses
Où est la touche SHIFT sur mon clavier d'ordi ?
joe! -
fernando-_ytb -

18 réponses