SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
DELETE
FROM jos_session
WHERE ( time < '1329978224' )
SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
UPDATE `jos_session`
SET `time`='1329979724',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1329979632;s:18:\"session.timer.last\";i:1329979662;s:17:\"session.timer.now\";i:1329979692;s:24:\"session.client.forwarded\";s:14:\"38.107.179.243\";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 *
FROM jos_sections
WHERE id = 36
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='36'
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 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 = 36
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:44' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:48:44' )
ORDER BY a.created DESC
LIMIT 0, 9
SELECT access
FROM jos_sections
WHERE id='36'
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='36'
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 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 = 36
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:44' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:48:44' )
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='36'
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 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 = 36
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='36'
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='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 < 1329893324
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 < 1329893324
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 = '7bee5554ca16b54eba6787b89d63fb63'
AND sha1hash = '2a1ffb619baa842d9365ec8fc3e8ab304270c695'
AND stamp < 1329893324
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 ('Comment', 'occuper', 'les', 'enfants', 'durant', 'petites', 'vacances') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('Comment', 'occuper', 'les', 'enfants', 'durant', 'petites', 'vacances')
ORDER BY length(tterm) DESC
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893324
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 < 1329893324
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 < 1329893324
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 < 1329893324
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 < 1329893324
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 < 1329893324
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=4090
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'add86abd73893d97513f00a0c6f1d9c6'
AND sha1hash = '68e5b9eac88b60be558ee3ebbaafe7600f3ce8d0'
AND stamp < 1329893324
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 ('A', 'FOND', 'LE', 'SKI', ' ') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('A', 'FOND', 'LE', 'SKI', ' ')
ORDER BY length(tterm) DESC
SELECT access
FROM jos_content
WHERE id='4090'
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=4088
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'eab6f01dd82dc8ff81a2321a83e8f8ca'
AND sha1hash = '08fa57195c5487721b2a936180078a56c9bf2dd4'
AND stamp < 1329893324
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 ('Le', 'Formulaire', 'enfin', 'Inscription', 'en', 'direct', 'live', 'à', 'la', 'cantoche', ' ') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('Le', 'Formulaire', 'enfin', 'Inscription', 'en', 'direct', 'live', 'à', 'la', 'cantoche', ' ')
ORDER BY length(tterm) DESC
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('eab6f01dd82dc8ff81a2321a83e8f8ca', '08fa57195c5487721b2a936180078a56c9bf2dd4', 1329979724, '<p>Le Formulaire enfin !!!!</p>\r\n<p>Inscription en direct live à la cantoche</p>\r\n<p> </p>\r\n')
SELECT access
FROM jos_content
WHERE id='4088'
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=1640
ORDER BY t.weight DESC,t.name
SELECT count(cid) AS ct
FROM jos_tag_term_content
WHERE tid=16
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = '9cac803b09d088fc1815b90a3f160393'
AND sha1hash = '82f66692c45be8d133935e51bfd21bfb3adc315b'
AND stamp < 1329893324
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', 'usagers', 'de', 'la', 'bibliothèque', 'municipale', 'peuvent', 'disposer', 'd', 'un', 'accès', 'à', 'près', '500', 'ressources', 'm', 'apprentissage', 'en', 'ligne', 'gratuites', 'et', 'qualité', 'dans', 'différents', 'domaines', 'Cet', 'espace', 'autoformation', 'destiné', 'aux', 'jeunes', 'adultes', 'est', 'accessible', 'sur', 'les', 'postes', 'Internet', 'des', 'bibliothèques', 'médiathèques', 'ou', 'encore', 'domicile', ' ', 'Réviser', 'le', 'code', 'route', 'se', 'remettre', 'niveau', 'anglais', 'avant', 'voyage', 's', 'initier', 'au', 'chinois', 'découvrir', 'l', 'informatique', 'rechercher', 'une', 'formation', 'emploi', 'apprendre', 'solfège', 'réviser', 'mathématiques', 'tout', 'amusant', 'repérer', 'bons', 'sites', 'bricolage', 'cuisine', 'c', 'possible', 'grâce', 'Autoformation', 'Le', 'secteur', 'Langues', 'littératures', '2°', 'étage', 'côté', 'cathédrale', 'médiathèque', 'Jean', 'Falala', 'proposait', 'déjà', 'gratuit', 'cabines', 'langues', 'partir', 'sélection', 'cédéroms', 'Aujourd', 'hui', 'véritable', 'qui', 'proposé', 'comme', 'Bibliothèque', 'toujours', 'gratuitement', 'Dans', 'esprit', 'accompagnement', 'scolaire', 'initiale', 'long', 'vie', 'complémentarité', 'avec', 'offre', 'documentaire', 'classique', 'bibliothécaires', 'ont', 'effet', 'sélectionné', ' Soutien', 'bureautique', 'langue', 'signes', 'musique', 'pratique', 'orientation', 'culture', 'générale', 'L', 'usager', 'peut', 'donc', 'avoir', 'éventail', 'propositions', 'tous', 'stades', 'son', 'parcours', 'personnel', 'professionnel', 'Modalités', 'pratiques', 'place', 'distance', 'fait', 'très', 'simplement', 'par', 'intermédiaire', 'liste', 'signets', 'organisés', 'autour', 'ces', 'grands', 'thèmes', 'accessible ', 'chez', 'soi', 'page', 'accueil', 'du', 'portail', 'internet', 'www', 'bm', 'reims', 'fr', 'n', 'a', 'qu', 'identifier', 'numéro', 'sa', 'carte', 'abonné', 'secret', 'pour', 'accéder', 'organisée', 'rubrique', 'navigation', 'bandeau', 'gauche', 'site', 'A', 'simple', 'réservation', 'tranche', 'horaire', 'auprès', 'pourront', 'même', 'connecter', 'intéressent', 'entraîner', 'isolant', 'dédiées', 'équipées', 'casques', 'Un', 'téléphone', '03', '26', '35', '69', '18', 'adresse', 'mail', 'bib', 'mairie', 'permettront', 'garder', 'contact', 'ce', 'service', 'Ils', 'également', 'déposer', 'leurs', 'avis', 'lignes', 'sélectionnées', 'boîte', 'contribuer', 'ainsi', 'enrichissement', 'catalogue', 'Ce', 'nouveau', 'veut', 'interactif', 'évolutif', 'Contact', 'plus', 'informations', 'Sonia', 'Mourlan', '0326356823', 'sonia', 'mourlan', 'frOu', 'Richard', 'Roy', '0326356814', 'richard', 'roy', 'frTags', 'soutien') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN (' ', 'Les', 'usagers', 'de', 'la', 'bibliothèque', 'municipale', 'peuvent', 'disposer', 'd', 'un', 'accès', 'à', 'près', '500', 'ressources', 'm', 'apprentissage', 'en', 'ligne', 'gratuites', 'et', 'qualité', 'dans', 'différents', 'domaines', 'Cet', 'espace', 'autoformation', 'destiné', 'aux', 'jeunes', 'adultes', 'est', 'accessible', 'sur', 'les', 'postes', 'Internet', 'des', 'bibliothèques', 'médiathèques', 'ou', 'encore', 'domicile', ' ', 'Réviser', 'le', 'code', 'route', 'se', 'remettre', 'niveau', 'anglais', 'avant', 'voyage', 's', 'initier', 'au', 'chinois', 'découvrir', 'l', 'informatique', 'rechercher', 'une', 'formation', 'emploi', 'apprendre', 'solfège', 'réviser', 'mathématiques', 'tout', 'amusant', 'repérer', 'bons', 'sites', 'bricolage', 'cuisine', 'c', 'possible', 'grâce', 'Autoformation', 'Le', 'secteur', 'Langues', 'littératures', '2°', 'étage', 'côté', 'cathédrale', 'médiathèque', 'Jean', 'Falala', 'proposait', 'déjà', 'gratuit', 'cabines', 'langues', 'partir', 'sélection', 'cédéroms', 'Aujourd', 'hui', 'véritable', 'qui', 'proposé', 'comme', 'Bibliothèque', 'toujours', 'gratuitement', 'Dans', 'esprit', 'accompagnement', 'scolaire', 'initiale', 'long', 'vie', 'complémentarité', 'avec', 'offre', 'documentaire', 'classique', 'bibliothécaires', 'ont', 'effet', 'sélectionné', ' Soutien', 'bureautique', 'langue', 'signes', 'musique', 'pratique', 'orientation', 'culture', 'générale', 'L', 'usager', 'peut', 'donc', 'avoir', 'éventail', 'propositions', 'tous', 'stades', 'son', 'parcours', 'personnel', 'professionnel', 'Modalités', 'pratiques', 'place', 'distance', 'fait', 'très', 'simplement', 'par', 'intermédiaire', 'liste', 'signets', 'organisés', 'autour', 'ces', 'grands', 'thèmes', 'accessible ', 'chez', 'soi', 'page', 'accueil', 'du', 'portail', 'internet', 'www', 'bm', 'reims', 'fr', 'n', 'a', 'qu', 'identifier', 'numéro', 'sa', 'carte', 'abonné', 'secret', 'pour', 'accéder', 'organisée', 'rubrique', 'navigation', 'bandeau', 'gauche', 'site', 'A', 'simple', 'réservation', 'tranche', 'horaire', 'auprès', 'pourront', 'même', 'connecter', 'intéressent', 'entraîner', 'isolant', 'dédiées', 'équipées', 'casques', 'Un', 'téléphone', '03', '26', '35', '69', '18', 'adresse', 'mail', 'bib', 'mairie', 'permettront', 'garder', 'contact', 'ce', 'service', 'Ils', 'également', 'déposer', 'leurs', 'avis', 'lignes', 'sélectionnées', 'boîte', 'contribuer', 'ainsi', 'enrichissement', 'catalogue', 'Ce', 'nouveau', 'veut', 'interactif', 'évolutif', 'Contact', 'plus', 'informations', 'Sonia', 'Mourlan', '0326356823', 'sonia', 'mourlan', 'frOu', 'Richard', 'Roy', '0326356814', 'richard', 'roy', 'frTags', 'soutien')
ORDER BY length(tterm) DESC
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('9cac803b09d088fc1815b90a3f160393', '82f66692c45be8d133935e51bfd21bfb3adc315b', 1329979724, '<h2><span> </span></h2>\r\n<h2 style=\"text-align: center;\"><span><span><a href=\"http://www.ville-reims.fr/fr/culture/index.html\"></a><a href=\"http://www.ville-reims.fr/index.php?eID=tx_cms_showpic&file=uploads%2Fpics%2FBibliotheques_06.jpg&width=500m&height=500&bodyTag=%3Cbody%20bgColor%3D%22%23ffffff%22%3E&wrap=%3Ca%20href%3D%22javascript%3Aclose%28%29%3B%22%3E%20%7C%20%3C%2Fa%3E&md5=6dbda5bf394a1f51df46d99e3a538a79\" target=\"thePicture\"><img src=\"http://www.ville-reims.fr/typo3temp/pics/f8b708e278.jpg\" border=\"0\" width=\"146\" height=\"180\" /></a></span></span></h2>\r\n<h2><span>Les usagers de la bibliothèque municipale peuvent disposer d’un accès à près de 500 ressources m’apprentissage en ligne, gratuites et de qualité, dans différents domaines. Cet espace d’autoformation en ligne destiné aux jeunes et aux adultes, usagers de la bibliothèque municipale, est accessible sur les postes Internet des bibliothèques et médiathèques ou encore, à domicile.</span><span><a href=\"http://www.ville-reims.fr/fr/culture/index.html\"></a><a href=\"http://www.ville-reims.fr/index.php?eID=tx_cms_showpic&file=uploads%2Fpics%2FBibliotheques_06.jpg&width=500m&height=500&bodyTag=%3Cbody%20bgColor%3D%22%23ffffff%22%3E&wrap=%3Ca%20href%3D%22javascript%3Aclose%28%29%3B%22%3E%20%7C%20%3C%2Fa%3E&md5=6dbda5bf394a1f51df46d99e3a538a79\" target=\"thePicture\"></a> </span>\r\n<p> </p>\r\n</h2>\r\n<h2>Réviser le code de la route, se remettre à niveau en anglais avant un voyage, s’initier au chinois, découvrir l’informatique, rechercher une formation ou un emploi, apprendre le solfège, réviser les mathématiques tout en s’amusant ou encore repérer de bons sites de bricolage ou de cuisine, c’est possible grâce à l’espace Autoformation de la bibliothèque municipale.<br /><br />Le secteur Langues et littératures (2° étage – côté cathédrale) de la médiathèque Jean Falala proposait déjà l’accès gratuit à des cabines d’apprentissage de langues à partir d’une sélection de cédéroms.<br />Aujourd’hui, c’est un véritable espace d’autoformation en ligne dans différents domaines qui est proposé aux adultes comme aux jeunes usagers de la Bibliothèque municipale et toujours gratuitement.</h2>\r\n<h2>Dans un esprit <strong>d’accompagnement scolaire</strong>, de formation initiale et de formation tout au long de la vie, et en complémentarité avec l’offre documentaire classique, les bibliothécaires ont en effet sélectionné près de 500 ressources d’apprentissage en ligne <strong>gratuites</strong> et de qualité dans différents domaines :</h2>\r\n<h2>- Soutien scolaire, informatique-bureautique, code de la route, langues, langue des signes, musique, vie pratique, orientation-emploi-formation et culture générale.</h2>\r\n<h2>L’usager peut donc avoir accès à un éventail de propositions, à tous les stades de son parcours personnel, scolaire ou professionnel.</h2>\r\n<h2>Modalités pratiques, sur place ou à distance :</h2>\r\n<h2>L\'accès se fait très simplement par l\'intermédiaire d’une liste de signets organisés autour de ces grands thèmes, accessible sur les postes Internet des bibliothèques et médiathèques ou de chez soi, à partir de la page d’accueil du portail internet de la Bibliothèque municipale : <a href=\"http://www.bm-reims.fr/\" target=\"_blank\">www.bm-reims.fr</a>.<br />L’usager n’a qu’à s’identifier avec le numéro de sa carte d’abonné et son code secret pour accéder à la liste organisée des signets « autoformation » dans la rubrique « navigation » (bandeau gauche) du site.</h2>\r\n<h2>A la médiathèque Jean Falala, sur simple réservation d’une tranche horaire auprès des bibliothécaires, les usagers pourront même se connecter aux sites qui les intéressent et s’entraîner en s’isolant dans des cabines dédiées et équipées de casques.<br />Un numéro de téléphone : 03 26 35 69 18 et une adresse mail : <br /><a href=\"mailto:bib-autoformation@mairie-reims.fr\">bib-autoformation@mairie-reims.fr</a> permettront aux usagers de garder le contact avec les bibliothécaires autour de ce service.</h2>\r\n<h2>Ils pourront également déposer leurs avis (sur le service comme sur les ressources en lignes sélectionnées) sur la boîte mail et contribuer ainsi à l’enrichissement du catalogue de signets ! Ce nouveau service se veut en effet interactif et évolutif.</h2>\r\n<h2><br />Contact pour plus d’informations : <br />Sonia Mourlan 0326356823 <a href=\"mailto:sonia.mourlan@mairie-reims.fr\">sonia.mourlan@mairie-reims.fr</a><br />Ou Richard Roy 0326356814 <a href=\"mailto:richard.roy@bm-reims.fr\">richard.roy@bm-reims.fr</a></h2><div class=\"clearfix\"></div><div class=\"tag\">Tags:<ul><li><a href=\"/index.php/component/tag/soutien-scolaire-bibliothèque\" rel=\"tag\" title=\"soutien scolaire bibliothèque\" >soutien scolaire bibliothèque</a></li></ul></div>')
SELECT access
FROM jos_content
WHERE id='1640'
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=1639
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = '3a247418f18836ac9b02f622ead1f05a'
AND sha1hash = 'eff9efab1099cd3596d8f7e9f4b700a2763bf5b0'
AND stamp < 1329893324
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 (' ', 'Pour', 'trouver', 'toutes', 'les', 'informations', 'utiles', 'sur', 'bibliothèques', 'de', 'la', 'ville', 'Reims', 'cliquez', 'ici', 'http', 'www', 'bm', 'reims', 'fr', 'medias', 'aspx', 'INSTANCE=EXPLOITATION', 'SYNCMENU=ACCUEIL') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN (' ', 'Pour', 'trouver', 'toutes', 'les', 'informations', 'utiles', 'sur', 'bibliothèques', 'de', 'la', 'ville', 'Reims', 'cliquez', 'ici', 'http', 'www', 'bm', 'reims', 'fr', 'medias', 'aspx', 'INSTANCE=EXPLOITATION', 'SYNCMENU=ACCUEIL')
ORDER BY length(tterm) DESC
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('3a247418f18836ac9b02f622ead1f05a', 'eff9efab1099cd3596d8f7e9f4b700a2763bf5b0', 1329979724, '<p> </p>\r\n<p>Pour trouver toutes les informations utiles sur les bibliothèques de la ville de Reims, cliquez ici :</p>\r\n<p><a href=\"http://www.bm-reims.fr/medias/medias.aspx?INSTANCE=EXPLOITATION&SYNCMENU=ACCUEIL\">http://www.bm-reims.fr/medias/medias.aspx?INSTANCE=EXPLOITATION&SYNCMENU=ACCUEIL</a></p>')
SELECT access
FROM jos_content
WHERE id='1639'
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=1186
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'ae4d227e8a188c3cba6480ed2a52297d'
AND sha1hash = 'e5a269ec1cf3e39a4aeec179437d5cd9daa11ce0'
AND stamp < 1329893324
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', 1329979724, '<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 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
Autour de l'école
