SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
DELETE
FROM jos_session
WHERE ( time < '1329978192' )
SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
UPDATE `jos_session`
SET `time`='1329979692',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1329979632;s:18:\"session.timer.last\";i:1329979632;s:17:\"session.timer.now\";i:1329979662;s:24:\"session.client.forwarded\";s:14:\"38.107.179.242\";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='18'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 18)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_sections
WHERE id = 38
LIMIT 0, 1
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'section'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
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='38'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='38'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'item'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'editown'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
SELECT 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, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE (a.id IN (0) OR a.access <= 0)
AND s.id = 38
AND (s.id IN (0) OR s.access <= 0)
AND (cc.id IN (0) OR cc.access <= 0)
AND s.published = 1
AND cc.published = 1
AND ( a.state = 1 OR ( a.state >= 0
AND ( a.catid IN(0) OR (a.catid IN(0)
AND a.created_by = 0) OR a.id IN(0))) )
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 06:48:12' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:48:12' )
ORDER BY a.created DESC
LIMIT 0, 9
SELECT access
FROM jos_sections
WHERE id='38'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'section'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
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='38'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='38'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'item'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'editown'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
SELECT 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, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE (a.id IN (0) OR a.access <= 0)
AND s.id = 38
AND (s.id IN (0) OR s.access <= 0)
AND (cc.id IN (0) OR cc.access <= 0)
AND s.published = 1
AND cc.published = 1
AND ( a.state = 1 OR ( a.state >= 0
AND ( a.catid IN(0) OR (a.catid IN(0)
AND a.created_by = 0) OR a.id IN(0))) )
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 06:48:12' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:48:12' )
ORDER BY a.created DESC
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'read'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
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='38'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='38'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'item'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'edit'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
SELECT axo
FROM jos_gmacl
WHERE acosection = 'com_content'
AND aco = 'editown'
AND arosection='users'
AND aro IN (0)
AND axosection = 'category'
SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
FROM jos_categories AS a
LEFT JOIN jos_content AS b
ON b.catid = a.id
AND ( b.state = 1 OR ( b.state >= 0
AND ( b.catid IN(0) OR (b.catid IN(0)
AND b.created_by = 0) OR b.id IN(0) ) ) )
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2012-02-23 06:48' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-23 06:48' )
AND (b.id IN (0) OR b.access <= 0)
WHERE a.section = 38
AND a.published = 1
AND (a.id IN (0) OR a.access <= 0)
GROUP BY a.id
HAVING numitems > 0
ORDER BY a.ordering
SELECT access
FROM jos_sections
WHERE id='38'
SELECT access
FROM jos_sections
WHERE id='38'
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='publish'
AND arosection='users'
AND aro IN (0)
AND axosection='content'
AND axo='all'
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 fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893292
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 fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893292
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 fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893292
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 fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893292
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 fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893292
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 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=1624
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893292
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_content
WHERE id='1624'
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 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=1562
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = '9c230d7588dd4e4d80a5c778986835a6'
AND sha1hash = '16db8918881a7d0a6dd58308ec234365f56e4d0f'
AND stamp < 1329893292
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_content
WHERE id='1562'
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 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=1507
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = '59690909ece3148ea93e4c2941a5459b'
AND sha1hash = 'e9944e5645a32dfeb7d55f9140b69c08d57a2013'
AND stamp < 1329893292
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 ('les', 'formulaires', 'd', 'inscriptions', 'des', 'enseignant', 'e', 's', 'ou', 'directeurs', 'trices', 'à', 'la', 'caisse', 'écoles') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('les', 'formulaires', 'd', 'inscriptions', 'des', 'enseignant', 'e', 's', 'ou', 'directeurs', 'trices', 'à', 'la', 'caisse', 'écoles')
ORDER BY length(tterm) DESC
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('59690909ece3148ea93e4c2941a5459b', 'e9944e5645a32dfeb7d55f9140b69c08d57a2013', 1329979692, '<h3></h3><h3>les formulaires d\'inscriptions des enseignant-e-s ou directeurs-trices à la caisse des écoles</h3><img src=\"images/stories/._arton1646.jpg\" width=\"150\" align=\"left\" hspace=\"10\" vspace=\"5\">\n')
SELECT access
FROM jos_content
WHERE id='1507'
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 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=630
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'd4e8fa89fc2aa99a73eeffdf628bfd4c'
AND sha1hash = 'b78cc7d0028c0862c5b0b464e04cb12255e548d2'
AND stamp < 1329893292
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 (' ', 'Année', 'scolaire', '2008', '2009', 'Pour', 'toute', 'inscription', 'vous', 'pouvez', 'présenter', 'Du', 'mardi', '18', 'mars', 'au', 'samedi', '14', 'juin', '2008dans', 'les', 'Antennes', 'Municipales', 'Lundi', 'h', '00', '17', '30 Mardi', 'jeudi', '8', '30', '12', 'Samedi', 'sauf l', 'antenne', 'Orgeval ', '+ Antenne', 'mobile', '06', '16', '39', '21', '02', 'lundi', 'avril', 'vendredi', '13', '2008au', 'Service', 'Éducation', 'de', 'la', 'Mairie', 'Reims', '4', 'rue', 'Jovin', '30Vendredi', 'tout', 'renseignement', 'complémentaire', 'téléphoner', 'au 03', '26', '77', '76', '31', 'ou', '33', 'DOCUMENTS', 'A', 'PRÉSENTER', 'Livret', 'famille', 'en', 'cas', 'séparation', 'jugement', 'divorce', 'précisant', 'résidence', 'l', 'enfant', 'et', 'autorité', 'parentale', 'Quittance', 'récente', 'loyer', 'd', 'E', 'D', 'F', 'Certificat', 'radiation', 'si', 'est', 'déjà', 'scolarisé', 'Carnet', 'santé', 'pour', 'le', 'contrôle', 'des', 'vaccins', 'Si', 'faite', 'dans', 'une', 'municipale', 'prévoir', 'photocopies', 'pages', 'vaccinations') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN (' ', 'Année', 'scolaire', '2008', '2009', 'Pour', 'toute', 'inscription', 'vous', 'pouvez', 'présenter', 'Du', 'mardi', '18', 'mars', 'au', 'samedi', '14', 'juin', '2008dans', 'les', 'Antennes', 'Municipales', 'Lundi', 'h', '00', '17', '30 Mardi', 'jeudi', '8', '30', '12', 'Samedi', 'sauf l', 'antenne', 'Orgeval ', '+ Antenne', 'mobile', '06', '16', '39', '21', '02', 'lundi', 'avril', 'vendredi', '13', '2008au', 'Service', 'Éducation', 'de', 'la', 'Mairie', 'Reims', '4', 'rue', 'Jovin', '30Vendredi', 'tout', 'renseignement', 'complémentaire', 'téléphoner', 'au 03', '26', '77', '76', '31', 'ou', '33', 'DOCUMENTS', 'A', 'PRÉSENTER', 'Livret', 'famille', 'en', 'cas', 'séparation', 'jugement', 'divorce', 'précisant', 'résidence', 'l', 'enfant', 'et', 'autorité', 'parentale', 'Quittance', 'récente', 'loyer', 'd', 'E', 'D', 'F', 'Certificat', 'radiation', 'si', 'est', 'déjà', 'scolarisé', 'Carnet', 'santé', 'pour', 'le', 'contrôle', 'des', 'vaccins', 'Si', 'faite', 'dans', 'une', 'municipale', 'prévoir', 'photocopies', 'pages', 'vaccinations')
ORDER BY length(tterm) DESC
SELECT id, tterm, tletter, tdefinition
FROM jos_glossary
WHERE id IN (271,241,327)
SELECT *
FROM jos_glossary
WHERE id = 327
SELECT termid, termalias
FROM jos_glossary_aliases
WHERE termid IN (327)
SELECT *
FROM jos_glossary
WHERE id = 271
SELECT termid, termalias
FROM jos_glossary_aliases
WHERE termid IN (271)
SELECT *
FROM jos_glossary
WHERE id = 241
SELECT termid, termalias
FROM jos_glossary_aliases
WHERE termid IN (241)
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('d4e8fa89fc2aa99a73eeffdf628bfd4c', 'b78cc7d0028c0862c5b0b464e04cb12255e548d2', 1329979692, '<p> </p>\r\n<p style=\"text-align: center;\"><span style=\"font-family: Verdana; font-size: x-small;\"><strong>Année scolaire 2008-2009</strong></span></p>\r\n<p> </p>\r\n<p align=\"center\"><span style=\"font-family: Verdana; font-size: x-small;\"><strong>Pour toute inscription </strong></span></p>\r\n<p> </p>\r\n<p align=\"center\"><strong><span style=\"font-family: Verdana; font-size: x-small;\">vous pouvez vous présenter :</span></strong></p>\r\n<p> </p>\r\n<p align=\"center\"><span style=\"font-family: Verdana; font-size: x-small;\"><strong>- Du mardi 18 mars 2008 au samedi 14 juin 2008<br /></strong></span><span style=\"font-family: Verdana; font-size: x-small;\"><strong>dans les Antennes Municipales</strong></span></p>\r\n<p><span style=\"font-family: Verdana; font-size: xx-small;\"><span style=\"font-family: Verdana; font-size: xx-small;\"> </span></span></p>\r\n<p> </p>\r\n<p align=\"center\"><span style=\"font-family: Verdana; font-size: xx-small;\"><span style=\"font-family: Verdana; font-size: xx-small;\"><strong>Lundi </strong>: 14 h 00-17 h 30 <br /><strong>Mardi au jeudi :</strong> 8 h 30-12 h 00 - 14 h 00-17 h 30<br /><strong> Samedi </strong>: 8 h 30-12 h 00 sauf l\'antenne Orgeval <br /> + Antenne mobile : 06.16.39.21.02 </span></span></p>\r\n<p> </p>\r\n<p align=\"center\"><span style=\"font-family: Verdana; font-size: xx-small;\"><span style=\"font-family: Verdana; font-size: xx-small;\"> </span></span><span style=\"font-family: Verdana; font-size: x-small;\"><strong>- Du lundi 14 avril 2008 au vendredi 13 juin 2008<br />au Service Éducation de la <a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/M/Mairie-327/&tmpl=component\" title=\"Lieu d'implantation de l'activité du Maire et du Conseil municipal la mairie est le siége des services centraux de l'administration municipale et du secrétaire général (ou Directeur général des services) Dans le langage courant le terme « mairie » désigne souvent à tord l'ensemble de l'organisation municipale (élus et services) en milieu urbain la Mairie prend la dénomination « d'hôtel de ville » et les antennes délocalisées des services centraux dans les quartiers l'appellation de « mairies de quartiers » Enfin Paris Lyon et Marseille sont dotées de « mairies d'arrondissement » \" target=\"_blank\">Mairie</a> de Reims </strong></span><span style=\"font-family: Verdana; font-size: x-small;\"><strong>4, rue Jovin</strong></span></p>\r\n<p> </p>\r\n<p align=\"center\"><span style=\"font-family: Verdana; font-size: xx-small;\"><strong>Lundi au jeudi :</strong> 8 h 30-12 h 00 - 13 h 30-17 h 30<br /><strong>Vendredi</strong> : 8 h 30-12 h 00 - 13 h 30-17 h 00</span></p>\r\n<p> </p>\r\n<p align=\"center\"><span style=\"font-family: Verdana; font-size: xx-small;\"><strong>Pour tout renseignement complémentaire, <br /></strong></span><span style=\"font-family: Verdana; font-size: xx-small;\"><strong><span style=\"font-size: x-small;\"><span style=\"font-size: xx-small;\">vous pouvez téléphoner au 03.26.77.76.31 ou 33</span><br /></span></strong></span></p>\r\n<p><span style=\"font-family: Verdana; font-size: xx-small;\"><strong> </strong></span><span style=\"font-family: Verdana; font-size: x-small;\"><strong> </strong></span></p>\r\n<p> </p>\r\n<p align=\"center\"><span style=\"font-family: Verdana; font-size: x-small;\"><strong><br />DOCUMENTS A PRÉSENTER<br /></strong></span></p>\r\n<p><span style=\"font-family: Verdana; font-size: x-small;\"><strong> </strong></span></p>\r\n<p> </p>\r\n<p align=\"justify\"><span style=\"font-family: Verdana; font-size: xx-small;\">- <strong>Livret de <a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/F/Famille-271/&tmpl=component\" title=\"Au sens démographique la famille rassemble plusieurs personnes unies par des liens de vie en couple et /ou de filiation directe (entre parent(s) et enfant(s)) La famille peut être limitée à un couple (marié pacsé ou en concubinage) Elle peut comporter un ou plusieurs enfants et dans ce cas si l'un au moins de ces enfants est issu d'une union précédente de l'un des deux conjoints on parle de famille recomposée On défini par ailleurs la famille monoparentale comme étant composée d'un seul parent vivant avec au moins un enfant Enfin plus récemment est apparue la notion de famille homoparentale comportant des conjoints (avec ou sans enfants) de même sexe La notion de famille renvoie également à une notion d'espace de vie de résidence familiale qui établit un lien entre elle et le territoire sur lequel elle vit Au plan éducatif les familles possèdent un ensemble de droits diversement codifiés et diversement respectés dans leurs pays \" target=\"_blank\">famille</a><br /></strong> (en cas de séparation jugement de divorce ou de séparation précisant la résidence de l\'<a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/E/Enfant-241/&tmpl=component\" title=\"Au sens de l'organisation des Nations unies (ONU) « un enfant s'entend de tout être humain âgé de moins de dix-huit ans sauf si la majorité est atteinte plus tôt en vertu de la législation qui lui est applicable » La limite d'âge supérieure est variable selon l'état l'institution l'organisation sociale les usages et évolue au fil de l'histoire Le mot « enfant » provenant du latin « infans » qui signifie « celui qui ne parle pas » ce qui reflète une conception originelle bien particulière de l'enfant et de son éducation (« soit sage et tais toi ! ») La déclaration universelle des droits de l'homme proclame que l'enfant a droit à une aide une assistance et une protection spéciale \" target=\"_blank\">enfant</a> et l\'autorité parentale)</span></p>\r\n<p> </p>\r\n<p align=\"justify\"><span style=\"font-family: Verdana; font-size: xx-small;\">- <strong>Quittance récente de loyer ou d\'E.D.F.</strong></span></p>\r\n<p> </p>\r\n<p align=\"justify\"><span style=\"font-family: Verdana; font-size: xx-small;\">- <strong>Certificat de radiation</strong> (si l\'<a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/E/Enfant-241/&tmpl=component\" title=\"Au sens de l'organisation des Nations unies (ONU) « un enfant s'entend de tout être humain âgé de moins de dix-huit ans sauf si la majorité est atteinte plus tôt en vertu de la législation qui lui est applicable » La limite d'âge supérieure est variable selon l'état l'institution l'organisation sociale les usages et évolue au fil de l'histoire Le mot « enfant » provenant du latin « infans » qui signifie « celui qui ne parle pas » ce qui reflète une conception originelle bien particulière de l'enfant et de son éducation (« soit sage et tais toi ! ») La déclaration universelle des droits de l'homme proclame que l'enfant a droit à une aide une assistance et une protection spéciale \" target=\"_blank\">enfant</a> est déjà scolarisé)</span></p>\r\n<p> </p>\r\n<p align=\"justify\"><span style=\"font-family: Verdana; font-size: xx-small;\">- <strong>Carnet de santé de l\'<a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/E/Enfant-241/&tmpl=component\" title=\"Au sens de l'organisation des Nations unies (ONU) « un enfant s'entend de tout être humain âgé de moins de dix-huit ans sauf si la majorité est atteinte plus tôt en vertu de la législation qui lui est applicable » La limite d'âge supérieure est variable selon l'état l'institution l'organisation sociale les usages et évolue au fil de l'histoire Le mot « enfant » provenant du latin « infans » qui signifie « celui qui ne parle pas » ce qui reflète une conception originelle bien particulière de l'enfant et de son éducation (« soit sage et tais toi ! ») La déclaration universelle des droits de l'homme proclame que l'enfant a droit à une aide une assistance et une protection spéciale \" target=\"_blank\">enfant</a><br /></strong> (pour le contrôle des vaccins)</span></p>\r\n<p> </p>\r\n<p align=\"justify\"><span style=\"font-family: Verdana; font-size: xx-small;\"><em>Si l\'inscription est faite dans une antenne municipale, prévoir les photocopies des pages vaccinations</em>.</span></p>')
SELECT access
FROM jos_content
WHERE id='630'
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 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=545
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = '2c3451b939cde2522dc106d677381a1d'
AND sha1hash = '29a4b0a04a00dc9e8c065fa10690632935585b18'
AND stamp < 1329893292
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_content
WHERE id='545'
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 = 18 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