SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
DELETE
FROM jos_session
WHERE ( time < '1329978550' )
SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
UPDATE `jos_session`
SET `time`='1329980050',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1329979632;s:18:\"session.timer.last\";i:1329979988;s:17:\"session.timer.now\";i:1329980014;s:24:\"session.client.forwarded\";s:14:\"38.107.179.244\";s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":20:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:4:\"gmid\";s:1:\"0\";s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:67:\"/var/www/_DEV/MonEcoleReims/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"9639f19addaf70ed652292cb24984782\";}'
WHERE session_id='ef3b350eb3d887db06a0f802c93dfa31'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT DISTINCTROW a.folder AS type, a.element AS name, a.params
FROM jos_plugins AS a
LEFT JOIN jos_gmacl AS gi
ON a.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "plugin"
WHERE a.published >= 1
AND (gi.aro IN ( 0 ) OR a.access <= 0)
ORDER BY a.ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT access
FROM jos_menu
WHERE id='16'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 16)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jos_categories AS c
INNER JOIN jos_sections AS s
ON s.id = c.section
WHERE c.id = 248
LIMIT 0, 1
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'item'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='own'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='36'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='category'
AND axo='248'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='36'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='category'
AND axo='248'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'item'
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND (a.id IN (0) OR a.access <= 0)
AND a.catid = 248
AND ( a.state = 1 OR ( a.state >= 0
AND a.id IN(0)) )
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 06:54:10' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:54:10' )
ORDER BY a.created DESC, a.created DESC
LIMIT 0, 9
SELECT access
FROM jos_categories
WHERE id='248'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'item'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='own'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='36'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='category'
AND axo='248'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='36'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='category'
AND axo='248'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'item'
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND (a.id IN (0) OR a.access <= 0)
AND a.catid = 248
AND ( a.state = 1 OR ( a.state >= 0
AND a.id IN(0)) )
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 06:54:10' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:54:10' )
ORDER BY a.created DESC, a.created DESC
SELECT access
FROM jos_categories
WHERE id='248'
SELECT access
FROM jos_sections
WHERE id='36'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='add'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='submit'
AND arosection='users'
AND aro IN (0)
AND axosection='category'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='submit'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='delete'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='deleteown'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='own'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='publish'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893650
SELECT g.id, a.termalias AS tterm, g.catid
FROM jos_glossary_aliases AS a
INNER JOIN jos_glossary AS g
ON a.termid = g.id
WHERE g.published != 0
AND a.tfirst IN ('') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('')
ORDER BY length(tterm) DESC
SELECT access
FROM jos_categories
WHERE id='248'
SELECT access
FROM jos_sections
WHERE id='36'
SELECT t.id,t.name,t.hits
FROM jos_tag_term AS t
LEFT JOIN jos_tag_term_content AS c
ON c.tid=t.id
WHERE c.cid=1186
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'ae4d227e8a188c3cba6480ed2a52297d'
AND sha1hash = 'e5a269ec1cf3e39a4aeec179437d5cd9daa11ce0'
AND stamp < 1329893650
SELECT g.id, a.termalias AS tterm, g.catid
FROM jos_glossary_aliases AS a
INNER JOIN jos_glossary AS g
ON a.termid = g.id
WHERE g.published != 0
AND a.tfirst IN ('Programme', 'Européen', '2010', 'de', 'la', 'Caisse', 'des', 'Ecoles', 'Publiques', 'Reims') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('Programme', 'Européen', '2010', 'de', 'la', 'Caisse', 'des', 'Ecoles', 'Publiques', 'Reims')
ORDER BY length(tterm) DESC
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('ae4d227e8a188c3cba6480ed2a52297d', 'e5a269ec1cf3e39a4aeec179437d5cd9daa11ce0', 1329980050, '<h3>Programme Européen 2010 de la Caisse des Ecoles Publiques de Reims</h3>\r\n')
SELECT access
FROM jos_content
WHERE id='1186'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='own'
SELECT access
FROM jos_categories
WHERE id='248'
SELECT access
FROM jos_sections
WHERE id='36'
SELECT t.id,t.name,t.hits
FROM jos_tag_term AS t
LEFT JOIN jos_tag_term_content AS c
ON c.tid=t.id
WHERE c.cid=580
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'a71fc6e1c286920253138289c57e5255'
AND sha1hash = '74ab5958e052143336622524d6c41ce53152258a'
AND stamp < 1329893650
SELECT g.id, a.termalias AS tterm, g.catid
FROM jos_glossary_aliases AS a
INNER JOIN jos_glossary AS g
ON a.termid = g.id
WHERE g.published != 0
AND a.tfirst IN ('La', 'Ville', 'de', 'Reims', 'offre', 'la', 'possibilité', 'à', 'tous', 'les', 'enfants', 'inscrits', 'dans', 'une', 'école', 'publique', 'élémentaire', 'ou', 'maternelle', 'participer', 'gratuitement', 'aux', 'différents', 'temps', 'périscolaires', 'Elle', 'a', 'souhaité', 'se', 'positionner', 'comme', 'partenaire', 'éducatif', 'en', 'inscrivant', 'actions', 'des', 'services', 'intervenant', 'sur', 'un', 'projet', 'partagé', 'avec', 'l', 'Éducation', 'Nationale', 'familles', 'et', 'ensemble', 'partenaires') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('La', 'Ville', 'de', 'Reims', 'offre', 'la', 'possibilité', 'à', 'tous', 'les', 'enfants', 'inscrits', 'dans', 'une', 'école', 'publique', 'élémentaire', 'ou', 'maternelle', 'participer', 'gratuitement', 'aux', 'différents', 'temps', 'périscolaires', 'Elle', 'a', 'souhaité', 'se', 'positionner', 'comme', 'partenaire', 'éducatif', 'en', 'inscrivant', 'actions', 'des', 'services', 'intervenant', 'sur', 'un', 'projet', 'partagé', 'avec', 'l', 'Éducation', 'Nationale', 'familles', 'et', 'ensemble', 'partenaires')
ORDER BY length(tterm) DESC
SELECT id, tterm, tletter, tdefinition
FROM jos_glossary
WHERE id IN (354)
SELECT *
FROM jos_glossary
WHERE id = 354
SELECT termid, termalias
FROM jos_glossary_aliases
WHERE termid IN (354)
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('a71fc6e1c286920253138289c57e5255', '74ab5958e052143336622524d6c41ce53152258a', 1329980050, '<p><img src=\"images/stories/arton243.jpg\" border=\"0\" hspace=\"10\" vspace=\"5\" width=\"150\" align=\"left\" /></p>\r\n<p><strong>La Ville de Reims offre la possibilité à tous les enfants inscrits dans une école publique élémentaire ou maternelle de la Ville de participer gratuitement aux différents temps périscolaires.</strong></p>\r\n<div>Elle a souhaité se positionner comme <a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/P/Partenaire-%C3%A9ducatif-354/&tmpl=component\" title=\"Qualifie la position des acteurs éducatifs lorsqu'ils sont associés dans la conception projet éducatif (projet d'établissement de zone d'éducation prioritaire éducatif local) ou qu'ils sont en charge collectivement de la gestion d'un établissement scolaire ou d'un dispositif (contractuel) éducatif Sont considérés comme partenaires éducatifs « extérieurs » par les professionnels de l'Education Nationale les acteurs qui ne sont pas dans une position de rattachement direct (comme le sont les enseignants les personnels non enseignants et les parents d'élèves) avec l'établissement scolaire \" target=\"_blank\">partenaire éducatif</a> en inscrivant les actions des différents services de la Ville intervenant sur les temps périscolaires dans un projet éducatif partagé avec l\'Éducation Nationale, les familles et l\'ensemble des partenaires.</div>\r\n')
SELECT access
FROM jos_content
WHERE id='580'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='own'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'module'
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND (m.id IN (0) OR m.access <= 0 OR m.client_id = 1)
AND m.client_id = 0
AND ( mm.menuid = 16 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT access
FROM jos_menu
WHERE id='24'
SELECT access
FROM jos_menu
WHERE id='29'
SELECT access
FROM jos_menu
WHERE id='27'
SELECT access
FROM jos_menu
WHERE id='28'
SELECT access
FROM jos_menu
WHERE id='22'
SELECT access
FROM jos_menu
WHERE id='23'
SELECT *
FROM jos_rafcloud_stat
WHERE published=1
ORDER BY counter DESC
LIMIT 25
SELECT word
FROM jos_rafcloud_stat
WHERE id='60'
SELECT word
FROM jos_rafcloud_stat
WHERE id='198'
SELECT word
FROM jos_rafcloud_stat
WHERE id='238'
SELECT word
FROM jos_rafcloud_stat
WHERE id='114'
SELECT word
FROM jos_rafcloud_stat
WHERE id='150'
SELECT word
FROM jos_rafcloud_stat
WHERE id='35'
SELECT word
FROM jos_rafcloud_stat
WHERE id='22'
SELECT word
FROM jos_rafcloud_stat
WHERE id='178'
SELECT word
FROM jos_rafcloud_stat
WHERE id='170'
SELECT word
FROM jos_rafcloud_stat
WHERE id='229'
SELECT word
FROM jos_rafcloud_stat
WHERE id='61'
SELECT word
FROM jos_rafcloud_stat
WHERE id='54'
SELECT word
FROM jos_rafcloud_stat
WHERE id='44'
SELECT word
FROM jos_rafcloud_stat
WHERE id='177'
SELECT word
FROM jos_rafcloud_stat
WHERE id='37'
SELECT word
FROM jos_rafcloud_stat
WHERE id='302'
SELECT word
FROM jos_rafcloud_stat
WHERE id='121'
SELECT word
FROM jos_rafcloud_stat
WHERE id='34'
SELECT word
FROM jos_rafcloud_stat
WHERE id='168'
SELECT word
FROM jos_rafcloud_stat
WHERE id='438'
SELECT word
FROM jos_rafcloud_stat
WHERE id='15'
SELECT word
FROM jos_rafcloud_stat
WHERE id='2'
SELECT word
FROM jos_rafcloud_stat
WHERE id='1'
SELECT word
FROM jos_rafcloud_stat
WHERE id='17'
SELECT word
FROM jos_rafcloud_stat
WHERE id='16'
SELECT access
FROM jos_menu
WHERE id='15'
SELECT access
FROM jos_menu
WHERE id='16'
SELECT access
FROM jos_menu
WHERE id='17'
SELECT access
FROM jos_menu
WHERE id='18'
SELECT access
FROM jos_menu
WHERE id='21'
SELECT *
FROM jos_acymailing_config
SELECT *
FROM jos_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC