SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
DELETE
FROM jos_session
WHERE ( time < '1329978579' )
SELECT *
FROM jos_session
WHERE session_id = 'ef3b350eb3d887db06a0f802c93dfa31'
UPDATE `jos_session`
SET `time`='1329980079',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:10;s:19:\"session.timer.start\";i:1329979632;s:18:\"session.timer.last\";i:1329980014;s:17:\"session.timer.now\";i:1329980050;s:24:\"session.client.forwarded\";s:14:\"38.107.179.240\";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 template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
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 *
FROM jos_content
WHERE id = '4086'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='section'
AND axo='33'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='category'
AND axo='246'
SELECT id
FROM jos_gmacl
WHERE acosection='com_content'
AND aco='edit'
AND arosection='users'
AND aro IN (0)
AND axosection='item'
AND axo='4086'
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 a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.section
AND s.scope = "content"
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 = 4086
AND (a.id IN (0) OR a.access <= 0)
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 06:54:39' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 06:54:39' ) ) OR ( a.state = -1 ) )
SELECT access
FROM jos_categories
WHERE id='246'
SELECT access
FROM jos_sections
WHERE id='33'
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='4086'
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='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 access
FROM jos_content
WHERE id='4086'
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=4086
ORDER BY t.weight DESC,t.name
SELECT count(cid) AS ct
FROM jos_tag_term_content
WHERE tid=17
SELECT fixup
FROM jos_glossary_cache
WHERE md5hash = 'f1f15c64726e8001183401a9250097fc'
AND sha1hash = 'cce5602078aaad382cfd0351ed23c0924f06a945'
AND stamp < 1329893679
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 ('Nouveauté', '2011', 'Les', 'vacances', 'organisées', 'par', 'la', 'Caisse', 'des', 'Ecoles', 'seront', 'gratuites', 'mais', 'Seulement', 'pour', 'les', '200', 'premiers', 'Alors', 'nous', 'avons', 'prévu', 'un', 'service', 'd', 'ordre', 'et', 'lits', 'de', 'camps', 'devant', 'l', 'entrée', 'Bonne', 'chance', 'Tags') UNION SELECT s.id, s.tterm, s.catid
FROM jos_glossary AS s
WHERE s.published != 0
AND s.tfirst IN ('Nouveauté', '2011', 'Les', 'vacances', 'organisées', 'par', 'la', 'Caisse', 'des', 'Ecoles', 'seront', 'gratuites', 'mais', 'Seulement', 'pour', 'les', '200', 'premiers', 'Alors', 'nous', 'avons', 'prévu', 'un', 'service', 'd', 'ordre', 'et', 'lits', 'de', 'camps', 'devant', 'l', 'entrée', 'Bonne', 'chance', 'Tags')
ORDER BY length(tterm) DESC
SELECT id, tterm, tletter, tdefinition
FROM jos_glossary
WHERE id IN (59)
SELECT *
FROM jos_glossary
WHERE id = 59
SELECT termid, termalias
FROM jos_glossary_aliases
WHERE termid IN (59)
INSERT INTO jos_glossary_cache (md5hash, sha1hash, stamp, fixup)
VALUES ('f1f15c64726e8001183401a9250097fc', 'cce5602078aaad382cfd0351ed23c0924f06a945', 1329980079, '<p>Nouveauté 2011 ! Les vacances organisées par la <a class=\"glossarylinkCapTic modal\" href=\"/index.php/component/glossary/Glossaire-1/C/Caisse-des-Ecoles-59/&tmpl=component\" title=\" \" target=\"_blank\">Caisse des Ecoles</a> seront gratuites... mais...</p>\r\n<p>\r\n\r\r\r\n</p>\r\n<p>Seulement pour les 200 premiers ! Alors nous avons prévu un service d\'ordre et des lits de camps devant l\'entrée.</p>\r\n<p style=\"text-align: center;\"><img src=\"images/stories/arton1196.gif\" border=\"0\" /></p>\r\n<p>Bonne chance.</p><div class=\"clearfix\"></div><div class=\"tag\">Tags:<ul><li><a href=\"/index.php/component/tag/vacances-gratuites\" rel=\"tag\" title=\"vacances gratuites\" >vacances gratuites</a></li></ul></div>')
SELECT metakey
FROM jos_content
WHERE id='4086'
SELECT id, title, introtext
FROM jos_content
WHERE id<>4086
AND state=1
AND access <=0
AND (metakey LIKE '%vacances gratuites%')
ORDER BY created DESC
LIMIT 0,5
SELECT sectionid, catid
FROM jos_content
WHERE id = 4086
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 = 0 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='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
