Deprecated: Creation of dynamic property cge_utils::$settings is deprecated in /home/agiwebco/www/clients/ping2.1.1/modules/CGExtensions/lib/class.cge_utils.php on line 75 Blog, les dernières actus - RP Fouesnant tennis de table
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 SQL_CALC_FOUND_ROWS
mn.*,
mnc.news_category_name,
mnc.long_name,
u.username,
u.first_name,
u.last_name
FROM ping_module_news mn
LEFT OUTER JOIN ping_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN ping_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
( mnc.news_category_id = '5' ) AND IF(start_time IS NULL AND end_time IS NULL,news_date <= NOW(),NOw() BETWEEN start_time AND end_time)ORDER BY mn.news_date desc LIMIT 0, 1000
SELECT A.news_id,A.fielddef_id,A.value FROM ping_module_news_fieldvals A
INNER JOIN ping_module_news_fielddefs B
ON A.fielddef_id = B.id
WHERE news_id IN (14,17,18,20)
ORDER BY A.news_id,B.item_order
SELECT news_category_id,COUNT(news_id) AS cnt FROM ping_module_news WHERE news_category_id IN (1,2,3,4,5,6,7) AND ( IFNULL(start_time, '1970-01-01 01:00:01') < '2026-08-18 01:25:31') AND (( IFNULL(end_time, '1970-01-01 01:00:01') = '1970-01-01 01:00:01') OR (end_time > '2026-08-18 01:25:31')) AND status = 'published' GROUP BY news_category_id
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 * FROM ping_content FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (298,220,206,208,209,211,229,232,234,238,258,259,288,304,312) AND active = 1 ORDER BY hierarchy
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 FORCE INDEX (ping_index_content_by_idhier) WHERE content_id IN (319,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 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 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 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 SQL_CALC_FOUND_ROWS
mn.*,
mnc.news_category_name,
mnc.long_name,
u.username,
u.first_name,
u.last_name
FROM ping_module_news mn
LEFT OUTER JOIN ping_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN ping_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
IF(start_time IS NULL AND end_time IS NULL,news_date <= NOW(),NOw() BETWEEN start_time AND end_time)ORDER BY mn.news_date desc LIMIT 0, 10
SELECT A.news_id,A.fielddef_id,A.value FROM ping_module_news_fieldvals A
INNER JOIN ping_module_news_fielddefs B
ON A.fielddef_id = B.id
WHERE news_id IN (10,11,12,19,21)
ORDER BY A.news_id,B.item_order
SELECT news_category_id,COUNT(news_id) AS cnt FROM ping_module_news WHERE news_category_id IN (1,2,3,4,5,6,7) AND ( IFNULL(start_time, '1970-01-01 01:00:01') < '2026-08-18 01:25:31') AND (( IFNULL(end_time, '1970-01-01 01:00:01') = '1970-01-01 01:00:01') OR (end_time > '2026-08-18 01:25:31')) AND status = 'published' GROUP BY news_category_id
SELECT news_category_id,COUNT(news_id) AS cnt FROM ping_module_news WHERE news_category_id IN (1,2,3,4,5,6,7) AND ( IFNULL(start_time, '1970-01-01 01:00:01') < '2026-08-18 01:25:31') AND (( IFNULL(end_time, '1970-01-01 01:00:01') = '1970-01-01 01:00:01') OR (end_time > '2026-08-18 01:25:31')) AND status = 'published' GROUP BY news_category_id
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 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_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 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 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