SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
DELETE
FROM jos_session
WHERE ( time < '1329978132' )
SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'ef3b350eb3d887db06a0f802c93dfa31','1329979632','','0','1','0' )
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='21'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 21)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_sections
WHERE id = 39
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='39'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='39'
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 = 39
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:47:12' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:47:12' )
ORDER BY a.created DESC
LIMIT 0, 9
SELECT access
FROM jos_sections
WHERE id='39'
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='39'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='39'
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 = 39
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:47:12' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 06:47: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='39'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='editown'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='39'
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:47' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-23 06:47' )
AND (b.id IN (0) OR b.access <= 0)
WHERE a.section = 39
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='39'
SELECT access
FROM jos_sections
WHERE id='39'
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'
SHOW TABLES
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'd41d8cd98f00b204e9800998ecf8427e'
AND sha1hash = 'da39a3ee5e6b4b0d3255bfef95601890afd80709'
AND stamp < 1329893232
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 = '545459012dede0fdb67e18bb28c4c923'
AND sha1hash = '2191ae0ee5a059c341d30b6f57b3cc88850f0c15'
AND stamp < 1329893232
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 ('Vous', 'trouverez', 'ici', 'toutes', 'les', 'informations', 'sur', 'la', 'restauration', 'scolaire') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('Vous', 'trouverez', 'ici', 'toutes', 'les', 'informations', 'sur', 'la', 'restauration', 'scolaire')
ORDER BY length(tterm) DESC
SELECT id, tterm, tletter, tdefinition
FROM jos_glossary
WHERE id IN (416)
SELECT *
FROM jos_glossary
WHERE id = 416
SELECT termid, termalias
FROM jos_glossary_aliases
WHERE termid IN (416)
SELECT *
FROM jos_glossaries
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('545459012dede0fdb67e18bb28c4c923', '2191ae0ee5a059c341d30b6f57b3cc88850f0c15', 1329979632, '<p>Vous trouverez ici, toutes les informations sur la <a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/R/Restauration-scolaire-416/&tmpl=component\" title=\"Le service de restauration scolaire est un service public administratif Initialement conçue pour répondre à un besoin social d'accueil des élèves pendant le temps de midi à l'intérieur de l'établissement scolaire la restauration scolaire a affirmé au cours des dernières années son caractère éducatif Ce service est organisé dans l'enseignement du premier degré par les communes Dans le second degré ou il est organisé au sein des établissement ce service a fait l'objet d'un récent transfert vers les départements pour les collèges vers les régions pour les lycées Dés lors que le service de restauration est organisé par la commune le Maire est responsable de la sécurité des usagers en particulier au plan de la sécurité des locaux de la surveillance des enfants mais également de la sécurité alimentaire En outre il choisi le mode de gestion du service (directe ou déléguée à un tiers) ainsi que le processus de fabrication et de distribution des repas (liaison chaude liaison froide) Par contre la commune ne peut concéder le service de surveillance des enfants pendant le temps du repas Elle peut intégrer ce temps de restauration dans le projet éducatif local et en contractualiser certains aspects dans le cadre du contrat éducatif local \" target=\"_blank\">restauration scolaire</a></p>')
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=1637
ORDER BY t.weight DESC,t.name
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = '27caa14c02ac908f81899e96c77ee574'
AND sha1hash = '40dea85b5b8591b2584e4ba44e39b8c9ea9db517'
AND stamp < 1329893232
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 ('C', 'est', 'la', 'semaine', 'du', 'gout', 'à', 'Reims') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('C', 'est', 'la', 'semaine', 'du', 'gout', 'à', 'Reims')
ORDER BY length(tterm) DESC
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('27caa14c02ac908f81899e96c77ee574', '40dea85b5b8591b2584e4ba44e39b8c9ea9db517', 1329979632, '<p>C\'est la semaine du gout à Reims !</p>\r\n<p>\r\n')
SELECT access
FROM jos_content
WHERE id='1637'
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 = 21 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
cantine 
