Eq 1 : Nationale 1 Messieurs

Time: 0.564298 / SQL: 0.16267s for 203 queries / Net Memory: 14011968 / Peak: 14411536

Initialize Database

Done Initializing Database

initialize internal global cache

done initializing global cache

Loading Modules

SET @xt_ZEROTIME = NOW() - INTERVAL 150 YEAR,@xt_FUTURETIME = NOW() + INTERVAL 5 YEAR

SET @CG_ZEROTIME = NOW() - INTERVAL 150 YEAR,@CG_FUTURETIME = NOW() + INTERVAL 5 YEAR

SELECT * FROM ping_module_customgs

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (1,150,81,103,82,94,98,108,109,173,57,33,162,171,305,306) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_module_smarty_plugins ORDER BY module

SELECT module_mode FROM ping_module_lise_instances WHERE module_name = 'LISEDirigeants' LIMIT  1

SELECT item_id,url FROM ping_module_lisedirigeants_item WHERE url != ''

End of Loading Modules

Initialize Smarty

Done Initialing Smarty

cms_content_cache: begin load needed content objects

cms_content_cache: end loading needed content objects

SELECT tpl_id,design_id FROM ping_layout_design_tplassoc
                   WHERE tpl_id IN (379,344,346,361,380,354,391,353,359,357) ORDER BY tpl_id

SELECT * FROM ping_layout_templates WHERE id IN (379,344,346,361,380,354,391,353,359,357)

SELECT * FROM ping_content WHERE content_id = 319 LIMIT  1

SELECT * FROM ping_content_props WHERE content_id = 319

SELECT * FROM ping_content WHERE content_id = 205 LIMIT  1

SELECT SQL_CALC_FOUND_ROWS * FROM ping_module_seoboost_settings LIMIT 0, 1000

SELECT FOUND_ROWS() LIMIT  1

process template top

SELECT count(*) AS nb FROM ping_module_rssmgr_items WHERE published =1

SELECT title, description,link,source, pubDate, date_publication, FROM_UNIXTIME(date_publication, '%d-%m-%Y') AS date_pub, enclosure, sticky, published, useDefaultImage FROM ping_module_rssmgr_items WHERE published = 1 AND source >0 ORDER BY date_publication DESC LIMIT 0, 4

SELECT title FROM ping_module_rssmgr_channels WHERE id = '2'

SELECT defaultImageOnly FROM ping_module_rssmgr_channels WHERE id = '2'

SELECT defaultImage FROM ping_module_rssmgr_channels WHERE id = '2'

SELECT title FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT defaultImageOnly FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT defaultImage FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT title FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT defaultImageOnly FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT defaultImage FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT title FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT defaultImageOnly FROM ping_module_rssmgr_channels WHERE id = '4'

SELECT defaultImage FROM ping_module_rssmgr_channels WHERE id = '4'

Start Navigator default action

SELECT * FROM ping_content_props WHERE content_id = 205

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (298,220,206,208,209,210,211,229,232,234,238,258,259,288,304,312) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (298,220,206,208,209,210,211,229,232,234,238,258,259,288,304,312) ORDER BY content_id

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (237,300,301,302,303,311,313,315,365) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (237,300,301,302,303,311,313,315,365) ORDER BY content_id

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (222,255,309) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (222,255,309) ORDER BY content_id

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (221,240,241,242,243,244,245,246,247,248,249,250,251,252,253,269) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (221,240,241,242,243,244,245,246,247,248,249,250,251,252,253,269) ORDER BY content_id

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (275,270,271,272,273,274,223,310,219) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (275,270,271,272,273,274,223,310,219) ORDER BY content_id

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (207,268,216,218,217,227,254,257,267,317,318) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (207,216,227,257,267,317,318) ORDER BY content_id

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (268,218,217,254) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (268,218,217,254) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (268,218,217,254) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (268,218,217,254) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (214,215,213) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (214,215,213) ORDER BY content_id

End Navigator default action

calling module LISE from event ContentPostCompile

Start Navigator breadcrumbs action

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (126,263,117,204,320,359,119,122,139,141,200,233,235,276,294,295) ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (126,263,117,204,320,359,119,122,139,141,200,233,235,276,294,295) ORDER BY content_id

End Navigator breadcrumbs action

SELECT id, saison, phase, numero_equipe, libequipe, libdivision, friendlyname, liendivision, idpoule, iddiv, type_compet, tag, idepreuve, calendrier, horaire, class_mini FROM ping_module_ping_equipes WHERE id = 1029

SELECT date_event, equa, equb, renc_id, horaire, idepreuve, equip_id1, equip_id2, tour FROM ping_module_ping_poules_rencontres WHERE eq_id = 1029 AND club = 1 AND affiche = 1 AND date_event >= CURRENT_DATE() ORDER BY tour ASC LIMIT 1

    SELECT * 
    FROM ping_module_ping_classement
    WHERE idequipe = 1029 
    AND numero = '03290229'
    

SELECT cl.clt, cl.joue,cl.equipe,cl.pts,cl.vic, cl.nul, cl.def, cl.pg, cl.pp, cl.pf, num_equipe, idclub, numero FROM ping_module_ping_classement AS cl  WHERE  cl.idequipe = 1029 ORDER BY cl.id ASC

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

  SELECT date_event, idpoule, iddiv, tour 
  FROM ping_module_ping_poules_rencontres AS ren 
  WHERE eq_id = 1029 GROUP BY date_event ORDER BY date_event ASC 

SELECT ren.club,ren.equa, ren.scorea, ren.equb, ren.scoreb, ren.renc_id, ren.equip_id1, ren.equip_id2, ren.uploaded FROM ping_module_ping_poules_rencontres AS ren WHERE ren.tour = '1' AND eq_id = 1029

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499125'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1688'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499126'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1538'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499127'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1641'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499128'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2747'

SELECT ren.club,ren.equa, ren.scorea, ren.equb, ren.scoreb, ren.renc_id, ren.equip_id1, ren.equip_id2, ren.uploaded FROM ping_module_ping_poules_rencontres AS ren WHERE ren.tour = '2' AND eq_id = 1029

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499129'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2824'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499130'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2359'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499131'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1689'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499132'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1451'

SELECT ren.club,ren.equa, ren.scorea, ren.equb, ren.scoreb, ren.renc_id, ren.equip_id1, ren.equip_id2, ren.uploaded FROM ping_module_ping_poules_rencontres AS ren WHERE ren.tour = '3' AND eq_id = 1029

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499133'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1688'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499134'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1538'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499135'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1641'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499136'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1451'

SELECT ren.club,ren.equa, ren.scorea, ren.equb, ren.scoreb, ren.renc_id, ren.equip_id1, ren.equip_id2, ren.uploaded FROM ping_module_ping_poules_rencontres AS ren WHERE ren.tour = '4' AND eq_id = 1029

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499137'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1689'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499138'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2747'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499139'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1641'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499140'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2359'

SELECT ren.club,ren.equa, ren.scorea, ren.equb, ren.scoreb, ren.renc_id, ren.equip_id1, ren.equip_id2, ren.uploaded FROM ping_module_ping_poules_rencontres AS ren WHERE ren.tour = '5' AND eq_id = 1029

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499141'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1688'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499142'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1538'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499143'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2824'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499144'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1451'

SELECT ren.club,ren.equa, ren.scorea, ren.equb, ren.scoreb, ren.renc_id, ren.equip_id1, ren.equip_id2, ren.uploaded FROM ping_module_ping_poules_rencontres AS ren WHERE ren.tour = '6' AND eq_id = 1029

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499145'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1641'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499146'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1538'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499147'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2747'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499148'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1689'

SELECT ren.club,ren.equa, ren.scorea, ren.equb, ren.scoreb, ren.renc_id, ren.equip_id1, ren.equip_id2, ren.uploaded FROM ping_module_ping_poules_rencontres AS ren WHERE ren.tour = '7' AND eq_id = 1029

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1688' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1538' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499149'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1688'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2824' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1641' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499150'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2824'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2359' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '2747' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499151'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '2359'

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1451' LIMIT 1

SELECT idclub FROM ping_module_ping_classement WHERE num_equipe = '1689' LIMIT 1

SELECT COUNT(*) AS nb FROM ping_module_ping_rencontres_parties WHERE fk_id = '6499152'

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '1451'

SELECT * FROM ping_module_linkmgr_categories WHERE upper(link_category) = "RESEAUX_SOCIAUX" ORDER BY cat_id ASC

SELECT l.*, lc.link_category FROM ping_module_linkmgr_links l LEFT JOIN ping_module_linkmgr_categories lc ON l.link_cat = lc.cat_id WHERE link_cat=14 AND link_status = "published" ORDER BY link_name ASC

SELECT * FROM ping_module_linkmgr_categories ORDER BY link_category ASC

SELECT content FROM ping_module_linkmgr_templates WHERE name='social_noli_fab'

SELECT * FROM ping_module_linkmgr_categories WHERE upper(link_category) = "COORDONNEES" ORDER BY cat_id ASC

SELECT l.*, lc.link_category FROM ping_module_linkmgr_links l LEFT JOIN ping_module_linkmgr_categories lc ON l.link_cat = lc.cat_id WHERE link_cat=13 AND link_status = "published" ORDER BY link_name ASC

SELECT * FROM ping_module_linkmgr_categories ORDER BY link_category ASC

SELECT content FROM ping_module_linkmgr_templates WHERE name='li_i_icon'

Start Navigator default action

SELECT * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (230,231,260,261,296,314,316) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (230,231,260,261,296,314,316) ORDER BY content_id

End Navigator default action

SELECT g.*, gp.hideparentlink, gp.editors, gt.*
        FROM ping_module_gallery g
        LEFT JOIN ping_module_gallery_props gp
        ON g.fileid=gp.fileid
        LEFT JOIN ping_module_gallery_templateprops gt
        ON gp.templateid=gt.templateid
        WHERE g.filename='' AND g.filepath=''

SELECT *
        FROM ping_module_gallery_templateprops
        WHERE template='Ritekhela accueil 2' OR templateid='Ritekhela accueil 2'

SELECT fd.*, fv.value
        FROM ping_module_gallery_fielddefs fd
        LEFT JOIN ping_module_gallery_fieldvals fv
        ON fd.fieldid = fv.fieldid AND fv.fileid = '1'
        WHERE fd.dirfield = 1 AND fd.public = 1 ORDER BY fd.sortorder ASC

SELECT
                g1.*, g2.filepath AS thumbpath, g2.filename AS thumbname
              FROM
                ping_module_gallery g1
              LEFT JOIN
                ping_module_gallery g2
              ON
                g1.defaultfile = g2.fileid
              WHERE
                g1.filepath=''

SELECT fd.*, fv.value
        FROM ping_module_gallery_fielddefs fd
        LEFT JOIN ping_module_gallery_fieldvals fv
        ON fd.fieldid = fv.fieldid AND fv.fileid = '40'
        WHERE fd.dirfield = 1 AND fd.public = 1 ORDER BY fd.sortorder ASC

SELECT fd.*, fv.value
        FROM ping_module_gallery_fielddefs fd
        LEFT JOIN ping_module_gallery_fieldvals fv
        ON fd.fieldid = fv.fieldid AND fv.fileid = '2'
        WHERE fd.dirfield = 0 AND fd.public = 1 ORDER BY fd.sortorder ASC

SELECT fd.*, fv.value
        FROM ping_module_gallery_fielddefs fd
        LEFT JOIN ping_module_gallery_fieldvals fv
        ON fd.fieldid = fv.fieldid AND fv.fileid = '81'
        WHERE fd.dirfield = 1 AND fd.public = 1 ORDER BY fd.sortorder ASC

SELECT fd.*, fv.value
        FROM ping_module_gallery_fielddefs fd
        LEFT JOIN ping_module_gallery_fieldvals fv
        ON fd.fieldid = fv.fieldid AND fv.fileid = '39'
        WHERE fd.dirfield = 0 AND fd.public = 1 ORDER BY fd.sortorder ASC

SELECT fd.*, fv.value
        FROM ping_module_gallery_fielddefs fd
        LEFT JOIN ping_module_gallery_fieldvals fv
        ON fd.fieldid = fv.fieldid AND fv.fileid = '7'
        WHERE fd.dirfield = 1 AND fd.public = 1 ORDER BY fd.sortorder ASC

SELECT * from ping_module_templates WHERE module_name = 'Gallery' and template_name = 'Ritekhela accueil 2' LIMIT  1

SELECT * from ping_module_templates WHERE module_name = 'Gallery' and template_name = 'Ritekhela accueil 2'

calling module Gallery from event ContentPostRender

calling module Livescoring from event ContentPostRender

calling module Showtime2 from event ContentPostRender

calling module LogWatch from event ContentPostRender