Amlin cup 2012-2013
_CMN_PRINT
Résultats - Amlin cup 9 Finale (18.05.2013 - 19.05.2013) Sélectionner Journée:


« Journée Préc.   06 07 08 09

Classement

Cl.   Equipe Points Brit Matchs G N P points Diff.
1 (1) SFR Stade Français 24  12 210:105  105 
2 (2) FCG Grenoble 20  8 173:81  92 
3 (3) LWS London Welsh 14  2 171:170 
4 (4) ICP I Cavalieri Prato -11 68:266  -198 


Equipe Favorite 

« Journée Préc.   06 07 08 09

logo fcg shop

 

2014-09-26-FCGSHOP

FACEBOOK

publicite-260

 

logo fcg newsletter


Informations

Application afterLoad: 0.000 seconds, 0.74 MB
Application afterInitialise: 0.018 seconds, 3.22 MB
Application afterRoute: 0.023 seconds, 5.48 MB
Application afterDispatch: 0.057 seconds, 6.79 MB
Application afterRender: 0.127 seconds, 7.31 MB

Utilisation de la mémoire

7770608

12 requêtes achevées

  1. SELECT *
      FROM fcg_session
      WHERE session_id = '65cc786144de6af42158389f5c16e368'
  2. DELETE
      FROM fcg_session
      WHERE ( TIME < '1413947247' )
  3. SELECT *
      FROM fcg_session
      WHERE session_id = '65cc786144de6af42158389f5c16e368'
  4. INSERT INTO `fcg_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '65cc786144de6af42158389f5c16e368','1413948147','','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 = 0)
      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 = 0 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  12. SELECT `value`
      FROM `fcg_admintools_storage`
      WHERE `key` = 'cparams'

24 requêtes legacy achevées

  1. SELECT id
      FROM fcg_menu
      WHERE link = 'index.php?option=com_joomleague'
      LIMIT 1
  2. SELECT *
      FROM fcg_joomleague
      WHERE id = '34'
  3. 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 = 34
      AND p.published = 1
  4. SELECT r.matchcode
      FROM fcg_joomleague_rounds AS r, fcg_joomleague_matches AS m
                     
      WHERE r.project_id=34
                     
      AND m.round_id=r.id
                     
      AND ( m.match_date - INTERVAL 0 MINUTE < '2014-10-22 06:22:27' )
                     
      ORDER BY m.match_date DESC
      LIMIT 1
  5. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'overall.tpl'
                                                           
      AND project_id = 34
  6. SELECT *
      FROM fcg_joomleague
      WHERE id = '2'
  7. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'overall.tpl'
                                                           
      AND project_id = 2
  8. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_results.tpl'
                                                           
      AND project_id = 34
  9. SELECT *
      FROM fcg_joomleague
      WHERE id = '2'
  10. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_results.tpl'
                                                           
      AND project_id = 2
  11. SELECT DISTINCT matchcode, id, name, round_date_first, round_date_last
                           
      FROM fcg_joomleague_rounds
                           
      WHERE project_id = 34
      ORDER BY matchcode ASC
  12. 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 = 34
      AND r.matchcode = 9
      AND matches.published = 1
      GROUP BY matches.match_id
                           
      ORDER BY r.matchcode ASC, matches.match_date ASC, matches.match_number
  13. 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 = 34
      ORDER BY t.name
  14. SELECT *
      FROM fcg_joomleague_rounds
      WHERE id = '419'
  15. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_table.tpl'
                                                           
      AND project_id = 34
  16. SELECT *
      FROM fcg_joomleague
      WHERE id = '2'
  17. SELECT params
      FROM fcg_joomleague_template_config
      WHERE template = 'show_table.tpl'
                                                           
      AND project_id = 2
  18. SELECT DISTINCT matchcode, id, name, round_date_first, round_date_last
                           
      FROM fcg_joomleague_rounds
                           
      WHERE project_id = 34
      ORDER BY matchcode ASC
  19. 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 = 34
      ORDER BY t.name
  20. SELECT id, round_date_first, round_date_last
                   
      FROM fcg_joomleague_rounds
                   
      WHERE matchcode >= 1+0
      AND matchcode <= 9
      AND project_id = 34
               
      ORDER BY matchcode
  21. 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=34
      AND m.round_id IN (411,412,413,514,515,516,417,418,419)
  22. SELECT id, round_date_first, round_date_last
                   
      FROM fcg_joomleague_rounds
                   
      WHERE matchcode >= 1+0
      AND matchcode <= 8
      AND project_id = 34
               
      ORDER BY matchcode
  23. 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=34
      AND m.round_id IN (411,412,413,514,515,516,417,418)
  24. SELECT info
      FROM fcg_joomleague_team_joomleague
      WHERE project_id = 34

Fichiers de langue chargés

Diagnostique des textes non traduits

Aucun

Textes non traduits

Aucun