Amlin Cup 2013-2014
_CMN_PRINT
Résultats - J06 (16.01.2014) Sélectionner Journée:

vendredi 17 janvier 2014
  FCGGrenoble-ABRBayonne 34 : 16 Résumé
dimanche 19 janvier 2014
  LWSLondon Wasps-VIAViadana 64 : 17  

« Journée Préc.   03 04 05 06

Classement

Cl.   Equipe Points Brit Matchs G N P points Diff. DESC
1 (1) LWS London Wasps 27  15 285:76  209 
2 (2) ABR Bayonne 15  3 219:118  101 
3 (3) FCG Grenoble 12  0 118:158  -40 
4 (4) VIA Viadana -10 86:356  -270 



« Journée Préc.   03 04 05 06

logo fcg shop

 

2014-09-26-FCGSHOP

FACEBOOK

Gio APLON Gio APLON

Né le : 06.10.1982
Position : 3/4 Aile
Taille : 175 cm
Poids : 78 kg

publicite-260

 

logo fcg newsletter


Informations

Application afterLoad: 0.000 seconds, 0.74 MB
Application afterInitialise: 0.019 seconds, 3.22 MB
Application afterRoute: 0.024 seconds, 5.48 MB
Application afterDispatch: 0.066 seconds, 6.80 MB
Application afterRender: 0.144 seconds, 7.35 MB

Utilisation de la mémoire

7807576

12 requêtes achevées

  1. SELECT *
      FROM fcg_session
      WHERE session_id = '07efd550a94eecd322647a08844541d5'
  2. DELETE
      FROM fcg_session
      WHERE ( TIME < '1413903645' )
  3. SELECT *
      FROM fcg_session
      WHERE session_id = '07efd550a94eecd322647a08844541d5'
  4. INSERT INTO `fcg_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '07efd550a94eecd322647a08844541d5','1413904545','','0','1','0' )
  5. SELECT *
      FROM fcg_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM fcg_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT name,player_id,ripper_id,postreplace
      FROM fcg_avr_tags
  8. SELECT name,player_id,ripper_id,postreplace
      FROM fcg_avr_tags
  9. SELECT template
      FROM fcg_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 622)
      ORDER BY menuid DESC
      LIMIT 0, 1
  10. SELECT *
      FROM fcg_menu
      WHERE home = '1'
      ORDER BY ordering
      LIMIT 1
  11. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM fcg_modules AS m
      LEFT JOIN fcg_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 622 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  12. SELECT `value`
      FROM `fcg_admintools_storage`
      WHERE `key` = 'cparams'

29 requêtes legacy achevées

  1. SELECT *
      FROM fcg_joomleague
      WHERE id = '41'
  2. SELECT pp.id
      FROM fcg_joomleague_predictiongame_project AS pp
                 
      LEFT JOIN fcg_joomleague_predictiongame AS p
      ON p.id = pp.prediction_id
                 
      WHERE pp.project_id = 41
      AND p.published = 1
  3. SELECT r.matchcode
      FROM fcg_joomleague_rounds AS r, fcg_joomleague_matches AS m
                     
      WHERE r.project_id=41
                     
      AND m.round_id=r.id
                     
      AND ( m.match_date - INTERVAL 0 MINUTE < '2014-10-21 18:15:45' )
                     
      ORDER BY m.match_date DESC
      LIMIT 1
  4. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'overall.tpl'
                                                           
      AND project_id = 41
  5. SELECT *
      FROM fcg_joomleague
      WHERE id = '2'
  6. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'overall.tpl'
                                                           
      AND project_id = 2
  7. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_results.tpl'
                                                           
      AND project_id = 41
  8. SELECT *
      FROM fcg_joomleague
      WHERE id = '2'
  9. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_results.tpl'
                                                           
      AND project_id = 2
  10. SELECT DISTINCT matchcode, id, name, round_date_first, round_date_last
                           
      FROM fcg_joomleague_rounds
                           
      WHERE project_id = 41
      ORDER BY matchcode ASC
  11. SELECT matches.*, r.matchcode AS roundcode, r.name AS roundname  
      FROM fcg_joomleague_matches AS matches
                           
      INNER JOIN fcg_joomleague_rounds AS r
      ON matches.round_id = r.id
      WHERE  matches.project_id = 41
      AND r.matchcode = 6
      AND matches.published = 1
      GROUP BY matches.match_id
                           
      ORDER BY r.matchcode ASC, matches.match_date ASC, matches.match_number
  12. SELECT tl.id AS teamtoolid, tl.division_id, tl.standard_playground, tl.admin, tl.start_points, tl.info, tl.team_id, tl.checked_out, tl.checked_out_time, tl.picture, tl.project_id,
                         t.id, t.name, t.short_name, t.middle_name, t.description, t.club_id,
                         u.username, u.email,
                         c.email AS club_email, c.logo_small,c.logo_big,c.logo_middle, c.country, c.website,
                         d.name AS division_name, d.shortname AS division_shortname, d.parent_id AS parent_division_id,
                         plg.name AS playground_name, plg.short_name AS playground_short_name
                   
      FROM fcg_joomleague_team_joomleague tl
               
      LEFT JOIN fcg_joomleague_teams t
      ON tl.team_id = t.id
               
      LEFT JOIN fcg_users u
      ON tl.admin = u.id
               
      LEFT JOIN fcg_joomleague_clubs c
      ON t.club_id = c.id
               
      LEFT JOIN fcg_joomleague_divisions d
      ON d.id = tl.division_id
               
      LEFT JOIN fcg_joomleague_playgrounds plg
      ON plg.id = tl.standard_playground
                   
      WHERE tl.project_id = 41
      ORDER BY t.name
  13. SELECT *
      FROM fcg_joomleague_rounds
      WHERE id = '558'
  14. SELECT COUNT(event_id)
      FROM fcg_joomleague_match_events
                       
      WHERE match_id = 3193
  15. SELECT COUNT(id)
      FROM fcg_joomleague_match_players
      WHERE match_id ='3193'
      AND came_in = 1
  16. SELECT id, titre
      FROM `fcg_fcglive_match`
      WHERE id = 42
  17. SELECT COUNT(event_id)
      FROM fcg_joomleague_match_events
                       
      WHERE match_id = 3194
  18. SELECT COUNT(id)
      FROM fcg_joomleague_match_players
      WHERE match_id ='3194'
      AND came_in = 1
  19. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_table.tpl'
                                                           
      AND project_id = 41
  20. SELECT *
      FROM fcg_joomleague
      WHERE id = '2'
  21. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_table.tpl'
                                                           
      AND project_id = 2
  22. SELECT DISTINCT matchcode, id, name, round_date_first, round_date_last
                           
      FROM fcg_joomleague_rounds
                           
      WHERE project_id = 41
      ORDER BY matchcode ASC
  23. SELECT tl.id AS teamtoolid, tl.division_id, tl.standard_playground, tl.admin, tl.start_points, tl.info, tl.team_id, tl.checked_out, tl.checked_out_time, tl.picture, tl.project_id,
                         t.id, t.name, t.short_name, t.middle_name, t.description, t.club_id,
                         u.username, u.email,
                         c.email AS club_email, c.logo_small,c.logo_big,c.logo_middle, c.country, c.website,
                         d.name AS division_name, d.shortname AS division_shortname, d.parent_id AS parent_division_id,
                         plg.name AS playground_name, plg.short_name AS playground_short_name
                   
      FROM fcg_joomleague_team_joomleague tl
               
      LEFT JOIN fcg_joomleague_teams t
      ON tl.team_id = t.id
               
      LEFT JOIN fcg_users u
      ON tl.admin = u.id
               
      LEFT JOIN fcg_joomleague_clubs c
      ON t.club_id = c.id
               
      LEFT JOIN fcg_joomleague_divisions d
      ON d.id = tl.division_id
               
      LEFT JOIN fcg_joomleague_playgrounds plg
      ON plg.id = tl.standard_playground
                   
      WHERE tl.project_id = 41
      ORDER BY t.name
  24. SELECT id, round_date_first, round_date_last
                   
      FROM fcg_joomleague_rounds
                   
      WHERE matchcode >= 1+0
      AND matchcode <= 6
      AND project_id = 41
               
      ORDER BY matchcode
  25. SELECT m.match_id,
                                            m.matchpart1,
                                            m.matchpart2,
                                            t1.name AS team1,
                                            t2.name AS team2,
                                            m.matchpart1_result AS home_score,
                                            m.matchpart2_result AS away_score,
                                            m.matchpart1_bonus AS home_bonus,
                                            m.matchpart2_bonus AS away_bonus,
                                            m.matchpart1_legs AS l1,
                                            m.matchpart2_legs AS l2,
                                            m.match_result_type,
                                            m.alt_decision AS decision,
                                            m.matchpart1_result_decision AS home_score_decision,
                                            m.matchpart2_result_decision AS away_score_decision,
                                            r.matchcode AS matchcode,
                                            r.name AS round_name,
                                            m.id_live AS id_live
                                           
      FROM fcg_joomleague_matches m
                                           
      LEFT JOIN fcg_joomleague_teams AS t1
      ON m.matchpart1 = t1.id
                                           
      LEFT JOIN fcg_joomleague_teams AS t2
      ON m.matchpart2 = t2.id
                                           
      LEFT JOIN fcg_joomleague_rounds AS r
      ON m.round_id = r.id
                                           
      WHERE ((m.matchpart1_result IS NOT NULL
      AND
                                            m.matchpart2_result IS NOT NULL) OR
                                            (m.alt_decision=1))
      AND
                                            m.count_result
      AND
                                            m.published
      AND
                                            m.project_id=41
      AND m.round_id IN (556,559,561,562,560,558)
  26. SELECT id, round_date_first, round_date_last
                   
      FROM fcg_joomleague_rounds
                   
      WHERE matchcode >= 1+0
      AND matchcode <= 5
      AND project_id = 41
               
      ORDER BY matchcode
  27. SELECT m.match_id,
                                            m.matchpart1,
                                            m.matchpart2,
                                            t1.name AS team1,
                                            t2.name AS team2,
                                            m.matchpart1_result AS home_score,
                                            m.matchpart2_result AS away_score,
                                            m.matchpart1_bonus AS home_bonus,
                                            m.matchpart2_bonus AS away_bonus,
                                            m.matchpart1_legs AS l1,
                                            m.matchpart2_legs AS l2,
                                            m.match_result_type,
                                            m.alt_decision AS decision,
                                            m.matchpart1_result_decision AS home_score_decision,
                                            m.matchpart2_result_decision AS away_score_decision,
                                            r.matchcode AS matchcode,
                                            r.name AS round_name,
                                            m.id_live AS id_live
                                           
      FROM fcg_joomleague_matches m
                                           
      LEFT JOIN fcg_joomleague_teams AS t1
      ON m.matchpart1 = t1.id
                                           
      LEFT JOIN fcg_joomleague_teams AS t2
      ON m.matchpart2 = t2.id
                                           
      LEFT JOIN fcg_joomleague_rounds AS r
      ON m.round_id = r.id
                                           
      WHERE ((m.matchpart1_result IS NOT NULL
      AND
                                            m.matchpart2_result IS NOT NULL) OR
                                            (m.alt_decision=1))
      AND
                                            m.count_result
      AND
                                            m.published
      AND
                                            m.project_id=41
      AND m.round_id IN (556,559,561,562,560)
  28. SELECT info
      FROM fcg_joomleague_team_joomleague
      WHERE project_id = 41
  29. SELECT pt.*,
                 pl.firstname,pl.lastname, pl.birthday,
                 p.name AS projectname,
                 pos.name AS posname,
                 t.name AS teamname,
                 tt.id AS id_team
               
      FROM fcg_joomleague_playertool pt
           
      INNER JOIN fcg_joomleague_players pl
      ON pl.id = pt.player_id
           
      LEFT JOIN fcg_joomleague_positions pos
      ON pos.id = pt.position_id
           
      INNER JOIN fcg_joomleague_teams t
      ON pt.team_id = t.id
           
      INNER JOIN fcg_joomleague_team_joomleague tt
      ON tt.team_id = t.id
           
      INNER JOIN fcg_joomleague p
      ON pt.project_id = p.id
      WHERE  pt.project_id IN (46)
      AND tt.id IN (376)
      ORDER BY rand()
      LIMIT 1

Fichiers de langue chargés

Diagnostique des textes non traduits

Aucun

Textes non traduits

Aucun