Eq 10 : D29_D2 Messieurs - Phase 2 Poule 4D2 Messieurs -

Time: 0.652277 / SQL: 0.16885s for 203 queries / Net Memory: 14011864 / Peak: 14408056

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 = 247 LIMIT  1

SELECT * FROM ping_content_props WHERE content_id = 247

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 (319,221,240,241,242,243,244,245,246,248,249,250,251,252,253,269) AND active = 1 ORDER BY hierarchy

SELECT * FROM ping_content_props WHERE content_id IN (319,221,240,241,242,243,244,245,246,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 = 1010

SELECT date_event, equa, equb, renc_id, horaire, idepreuve, equip_id1, equip_id2, tour FROM ping_module_ping_poules_rencontres WHERE eq_id = 1010 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 = 1010 
    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 = 1010 ORDER BY cl.id ASC

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

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

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

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

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

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

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

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

  SELECT date_event, idpoule, iddiv, tour 
  FROM ping_module_ping_poules_rencontres AS ren 
  WHERE eq_id = 1010 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 = 1010

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '6700'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7103'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7115'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7038'

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 = 1010

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7145'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7037'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7112'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7126'

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 = 1010

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '6700'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7103'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7115'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7126'

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 = 1010

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7112'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7038'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7115'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7037'

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 = 1010

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '6700'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7103'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7145'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7126'

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 = 1010

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7115'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7103'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7038'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7112'

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 = 1010

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '6700'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7145'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7037'

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

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

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

    SELECT * 
    FROM ping_module_ping_equipes
    WHERE idequipe = '7126'

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