startSection('wisra_basic_content'); ?> @parentXYZABC
Standings Background Pattern Standings Background Pattern

Récapitulatif

0) $timo.=$hr.':'; $sec=$sec-$hr*3600; $mn=floor($sec/60); if ($mn>0) $timo.=(($mn<9)?'0':'').$mn.':'; else $timo.='00:'; $sec=$sec-$mn*60; if ($sec>0) $timo.=(($sec<9)?'0':'').$sec; else $timo.='00'; return $timo; } if ($__a==2016 || $__a==2017) { /*======================== // Old one ==============================*/ // Les gagnants ?>

Les gagnants

0 AND A.dossart>0 ORDER BY A.time_21_km LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND A.dossart>0 ORDER BY A.time_21_km LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND A.dossart>0 ORDER BY A.time_7_km LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND A.dossart>0 ORDER BY A.time_7_km LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?>
Nom & Prénom Nom Pays Pays Course Course Sexe Sexe Temps Tps
21Km Homme
21km Dame
7km Homme
7km Dame

Participation

    0 AND A.dossart>0 GROUP BY payspy ORDER BY nbr DESC; "; $arg = array('an'=>$__a); $infoss = $db->select($req, $arg, true); foreach ($infoss as $infos) if (!empty($infos['pays'])) { $pays_nbr++; ?>
0 AND dossart>0 AND payspy=4) AS wil_nbr, (SELECT COUNT(DISTINCT comune) FROM participant WHERE annee=:an AND course=1 AND time_21_km>0 AND dossart>0 AND payspy=4 AND wilaya=6) AS com_nbr, (SELECT COUNT(*) FROM participant WHERE annee=:an AND course=1 AND sexxxx=1 AND time_21_km>0 AND dossart>0) AS hmn_nbr, (SELECT COUNT(*) FROM participant WHERE annee=:an AND course=1 AND sexxxx!=1 AND time_21_km>0 AND dossart>0) AS fmn_nbr, (SELECT COUNT(*) FROM participant WHERE annee=:an AND course=2 AND sexxxx=1 AND time_7_km>0 AND dossart>0) AS hpn_nbr, (SELECT COUNT(*) FROM participant WHERE annee=:an AND course=2 AND sexxxx!=1 AND time_7_km>0 AND dossart>0) AS fpn_nbr, (SELECT COUNT(*) FROM participant WHERE annee=:an AND enfant=1) AS cpn_nbr; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?>
Nombre de pays participants
Nombre de wilayas (S-M)
Nombre de communes de Béjaia (S-M)
21Km Hommes
21Km Dames
Participants 21Km
7Km Hommes
7Km Dames
Participants 7Km
Enfants 3Km
Total des participants
0 AND dossart>0 AND ageage>0) AS hma_nbr, (SELECT AVG(ageage) FROM participant WHERE annee=:an AND sexxxx!=1 AND course=1 AND time_21_km>0 AND dossart>0 AND ageage>0) AS fma_nbr, (SELECT AVG(ageage) FROM participant WHERE annee=:an AND sexxxx=1 AND course=2 AND time_7_km>0 AND dossart>0 AND ageage>0) AS hpa_nbr, (SELECT AVG(ageage) FROM participant WHERE annee=:an AND sexxxx!=1 AND course=2 AND time_7_km>0 AND dossart>0 AND ageage>0) AS fpa_nbr; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); if (!empty($donnee)) { ?>

Moyenne d'ages

Course 21Km Hommes
ans
Course 21Km Dames
ans
Course 7Km Hommes
ans
Course 7Km Dames
ans

Les plus agés

0 AND A.dossart>0 ORDER BY A.ageage DESC LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND A.dossart>0 ORDER BY A.ageage DESC LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?>
Nom & Prénom Nom Pays Pays Course Course Sexe Sexe Age Age Temps Tps
21km Homme ans
21km Dame ans

Les gagnants

0 AND B.dossard>0 ORDER BY B.time_course LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND B.dossard>0 ORDER BY B.time_course LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND B.dossard>0 ORDER BY B.time_course LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND B.dossard>0 ORDER BY B.time_course LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?>
Nom & Prénom Nom Pays Pays Course Course Sexe Sexe Temps Tps
<?php echo utf8_encode($donnee['pays']);?> 21km Homme
<?php echo utf8_encode($donnee['pays']);?> 21km Dame
<?php echo utf8_encode($donnee['pays']);?> 7km Homme
<?php echo utf8_encode($donnee['pays']);?> 7km Dame

Participation

    0 AND B.dossard>0 GROUP BY payspy ORDER BY nbr DESC; "; $arg = array('an'=>$__a); $infoss = $db->select($req, $arg, true); foreach ($infoss as $infos) if (!empty($infos['pays'])) { $pays_nbr++; ?>
  • <?php echo utf8_encode($infos['pays']);?>
0 AND B.dossard>0 AND A.payspy=4) AS wil_nbr, (SELECT COUNT(DISTINCT A.comune) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND B.course=1 AND B.time_course>0 AND B.dossard>0 AND A.payspy=4 AND A.wilaya=6) AS com_nbr, (SELECT COUNT(*) FROM member A LEFT JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND B.course=1 AND A.sex=1 AND B.time_course>0 AND B.dossard>0) AS hmn_nbr, (SELECT COUNT(*) FROM member A LEFT JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND B.course=1 AND A.sex=0 AND B.time_course>0 AND B.dossard>0) AS fmn_nbr, (SELECT COUNT(*) FROM member A LEFT JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND B.course=2 AND A.sex=1 AND B.time_course>0 AND B.dossard>0) AS hpn_nbr, (SELECT COUNT(*) FROM member A LEFT JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND B.course=2 AND A.sex=0 AND B.time_course>0 AND B.dossard>0) AS fpn_nbr, (SELECT COUNT(*) FROM member A LEFT JOIN member_particip B ON B.membre=A.id WHERE B.annee=:an AND B.enfant=1) AS cpn_nbr; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> */?>
Nombre de pays participants
Nombre de wilayas (S-M)
Nombre de communes de Béjaia (S-M)
21Km Hommes
21Km Dames
Participants 21Km
7Km Hommes
7Km Dames
Participants 7Km
Total des participants
0 AND A.dossard>0 AND A.ageage>0) AS hma_nbr, (SELECT AVG(A.ageage) FROM member_particip A INNER JOIN member B ON B.id=A.membre WHERE A.annee=:an AND B.sex!=1 AND A.course=1 AND A.time_course>0 AND A.dossard>0 AND A.ageage>0) AS fma_nbr, (SELECT AVG(A.ageage) FROM member_particip A INNER JOIN member B ON B.id=A.membre WHERE A.annee=:an AND B.sex=1 AND A.course=2 AND A.time_course>0 AND A.dossard>0 AND A.ageage>0) AS hpa_nbr, (SELECT AVG(A.ageage) FROM member_particip A INNER JOIN member B ON B.id=A.membre WHERE A.annee=:an AND B.sex!=1 AND A.course=2 AND A.time_course>0 AND A.dossard>0 AND A.ageage>0) AS fpa_nbr; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); if (!empty($donnee)) { ?>

Moyenne d'ages

Course 21Km Hommes
ans
Course 21Km Dames
ans
Course 7Km Hommes
ans
Course 7Km Dames
ans

Les plus agés

0 AND B.dossard>0 ORDER BY B.ageage DESC LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?> 0 AND B.dossard>0 ORDER BY B.ageage DESC LIMIT 0,1; "; $arg = array('an'=>$__a); $donnee = $db->select($req, $arg, false); ?>
Nom & Prénom Nom Pays Pays Course Course Sexe Sexe Age Age Temps Tps
<?php echo utf8_encode($donnee['pays']);?> 21km Homme ans
<?php echo utf8_encode($donnee['pays']);?> 21km Dame ans
stopSection(); ?> startSection('wisra_css_content'); ?> stopSection(); ?> startSection('wisra_js_content'); ?> stopSection(); ?> runChild('layout', ['page_data' => array( 'plugins' => array(), 'title' => "Récapitulatif | Semi Marathon International de Béjaia", 'description' => "Récapitulatif, Semi Marathon International de la ville de Béjaia: course 21km, 7km et 3km pour enfants, handisports. organisé par l'Athlétic Méditerranéen Club Béjaia AMCB chaque année, a la vile de Béjaia - Algérie", 'keywords' => array("Récapitulatif", "Recapitulatif", "Récapitulatif Semi Marathon Bejaia", "Semi Marathon International de la ville de Béjaia", "Semi Marathon International de Béjaia", "Semi Marathon Béjaia", "SemiMarathon Béjaia", "Demi Marathon Béjaia", "Semi Marathon International Bejaia", "Semi", "Marathon", "Semi-Marathon", "International", "Semi-Marathon International", "Béjaia", "Semi-Marathon International Béjaia", "course 21km", "course 7km", "course 3km", "course enfants", "course handisports", "Athlétic Méditerranéen Club Béjaia", "Athlétic Club", "Athlétic Club Béjaia", "Athlétic Méditerranéen Club Béjaia", "AMCB", "la vile de Béjaia", "Algérie", "Béjaia Algérie"), 'facebook_integration' => false, 'google_maps_callback' => '', 'filters_header' => 1, 'filter_year' => $__a, 'filter_link' => 'recapitulatif' )]); } ?>