SELECT *
FROM jos_session
WHERE session_id = 'reuc9vf6593jpenlpfr1pn0t14'
DELETE
FROM jos_session
WHERE ( TIME < '1715923813' )
SELECT *
FROM jos_session
WHERE session_id = 'reuc9vf6593jpenlpfr1pn0t14'
UPDATE `jos_session`
SET `time`='1715924713',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:46;s:19:\"session.timer.start\";i:1715924691;s:18:\"session.timer.last\";i:1715924712;s:17:\"session.timer.now\";i:1715924712;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\":2:{s:16:\"published_fv_ses\";s:1:\"0\";s:15:\"justmine_fv_ses\";s:1:\"0\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{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: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:77:\"/web/htdocs/www.cifppiambello.it/home/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:16:\"com_mailto.links\";a:45:{s:40:\"a9cf1b49e59a1083d76791ac3d662bbd5ce16ad7\";O:8:\"stdClass\":2:{s:4:\"link\";s:128:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2020&month=12&day=31&Itemid=1\";s:6:\"expiry\";i:1715924691;}s:40:\"e84ef385fdc6e12c8125b038070fd0d62d6d995e\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=04&day=17&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924692;}s:40:\"558475ae4314f41f17ab827f2fbabbc6937bf7d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2020&month=05&day=01&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924692;}s:40:\"6d765741d43082f06115a14f935801f2bb993c21\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2018&month=02&day=18&Itemid=1\";s:6:\"expiry\";i:1715924693;}s:40:\"a099327c7eb8f6739b17217a8a01f704e6b08719\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=05&day=12&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924693;}s:40:\"4ebda15268b9375ff66f879b8e3ab55aa4476ad2\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2021&month=05&day=16&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924694;}s:40:\"a2d231995790c5a24e583e9d7da7fb7b62e3b9a9\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2016&month=12&day=24&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924694;}s:40:\"f4d2acb2bb00c2a3f52dd0427e701a936b68c3c6\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2020&month=12&day=08&Itemid=1\";s:6:\"expiry\";i:1715924695;}s:40:\"957fdb4a201275619580668e53ec1e1b25c6397a\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=09&day=28&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924695;}s:40:\"469507a9d93e7aa525aaa84a752e8e03b35254be\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2020&month=05&day=05&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924695;}s:40:\"887f02ea508386f8c9f1d78a5a2de9a6b7b22efb\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2020&month=12&day=19&Itemid=1\";s:6:\"expiry\";i:1715924696;}s:40:\"6f8300867bf74eabe5b88ea92e044abc7df0087a\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=04&day=27&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924696;}s:40:\"893ed053a5ba4b6a151e91679d43a62f62b296d4\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2020&month=05&day=28&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924697;}s:40:\"006d53c9f4b28c2a1119f068e6d8d2bc23d8ba8c\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2020&month=12&day=23&Itemid=1\";s:6:\"expiry\";i:1715924697;}s:40:\"90f7d3bc61c349a8458e116763bba4917082b987\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2022&month=07&day=27&Itemid=1\";s:6:\"expiry\";i:1715924697;}s:40:\"8117d8878e7a4b5027966dbeff194bbdade9f639\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2018&month=11&day=20&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924698;}s:40:\"cb120150b122f1a300473a2f6155386df6398510\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2018&month=10&day=28&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924699;}s:40:\"7a35f127c77c4e1ee1a72916ba80661c3eeac111\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2018&month=11&day=14&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924699;}s:40:\"4e9938fa2e54c7114e116e7c75e969e0b02db229\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2019&month=06&day=23&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924700;}s:40:\"50e24f980417269f4b895e929ec4c82e67fc9440\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2015&month=06&day=15&Itemid=1\";s:6:\"expiry\";i:1715924701;}s:40:\"928c2438b4e08992e84dae95ef61a5ea6b04ba95\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2020&month=12&day=16&Itemid=1\";s:6:\"expiry\";i:1715924701;}s:40:\"f7987e651e2451cdf5f4cf545b45df02ee59f1b2\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2020&month=12&day=08&Itemid=1\";s:6:\"expiry\";i:1715924702;}s:40:\"feb023b2c9069076797702e3357ea4e563bc89d1\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=09&day=14&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924702;}s:40:\"89cc50d7bdd5ef37444a0a67921fe143712141f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2021&month=09&day=01&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924702;}s:40:\"c63fd34ca438ebf982fc169c257eb002e93ad0d8\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=09&day=01&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924703;}s:40:\"8797b49b82b407c2646a1add7e38f1e8dda56139\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2022&month=06&day=02&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924703;}s:40:\"0d9b3bb2c122227f4b7b7a62a5991bea04777f49\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2018&month=11&day=11&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924704;}s:40:\"0032a8b423c57a98808981f1218c24194759e00f\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=04&day=21&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924704;}s:40:\"e6754d43ea853b9013c6143cda687c1f3f450dd9\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2022&month=08&day=05&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924705;}s:40:\"2f947c204b62d05332775bdbd235cc4998b47ac3\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2018&month=02&day=27&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924705;}s:40:\"12e4b0cf36d7be9337343f95c846014312726942\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2020&month=12&day=14&Itemid=1\";s:6:\"expiry\";i:1715924706;}s:40:\"4b0f6a1cb73cf985a1b9947ae950e12ad4721712\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2022&month=07&day=12&Itemid=1\";s:6:\"expiry\";i:1715924706;}s:40:\"dfa9053b2db18aad9ed9077d2931a745a43d8786\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2022&month=07&day=26&Itemid=1\";s:6:\"expiry\";i:1715924707;}s:40:\"13c077ddfec0b93c36a52f877efeae9d7eede365\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2022&month=08&day=19&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924707;}s:40:\"399468866bdc66d1f7dba819bbc04d39e0a024b2\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2022&month=07&day=14&Itemid=1\";s:6:\"expiry\";i:1715924708;}s:40:\"9d937eae0fa0132892b403e58a444d73c31a1702\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2020&month=06&day=16&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924708;}s:40:\"3cb6ff475f31e76924baefae55c904c5570ddf70\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2016&month=06&day=08&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924709;}s:40:\"b6a7e14ffff795e6fc1d531453df3ec0578787ba\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2020&month=12&day=28&Itemid=1\";s:6:\"expiry\";i:1715924709;}s:40:\"4c6b0a1298cbd6ad81841bc3bcdf83c6ce7b3c99\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2019&month=06&day=16&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924710;}s:40:\"56c59694f7ace18f2251e861f6d4c6a0bbd13719\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2017&month=10&day=04&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924710;}s:40:\"51167b78b577b7b488005946114e44f383706046\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2020&month=05&day=24&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924710;}s:40:\"9ea049b635e1c279e77322ae08de559b7e402a2a\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=04&day=25&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924711;}s:40:\"ec361b6a5a52ed70a48d3437ce9e50c834c3cb1b\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=09&day=18&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924711;}s:40:\"21c97465d7ea24a0580dbed4aa4ae1dab2ffb946\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2022&month=08&day=29&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924712;}s:40:\"cacdb82f87aac78140c11b2c4d2836f807a80a30\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2022&month=08&day=21&Itemid=1&catids=4\";s:6:\"expiry\";i:1715924712;}}}__ricerca|a:4:{s:4:\"menu\";s:2:\"11\";s:3:\"ord\";s:4:\"DESC\";s:9:\"indietro1\";s:126:\"http://www.cifppiambello.it/index.php?option=com_chronoconnectivity2&connectionname=ricerca_archivio_accessibili&Itemid=11\";s:6:\"totale\";s:3:\"661\";}'
WHERE session_id='reuc9vf6593jpenlpfr1pn0t14'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY 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 = 1)
ORDER BY menuid DESC
LIMIT 0, 1
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.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 1 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT c.id
FROM jos_categories AS c
LEFT JOIN jos_categories AS p
ON p.id=c.parent_id
LEFT JOIN jos_categories AS gp
ON gp.id=p.parent_id
LEFT JOIN jos_categories AS ggp
ON ggp.id=gp.parent_id
WHERE c.access <= 0
AND c.published = 1
AND c.SECTION = 'com_jevents'
SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published, ev.created AS created
, YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
, YEAR(rpt.endrepeat ) AS ydn, MONTH(rpt.endrepeat ) AS mdn, DAYOFMONTH(rpt.endrepeat ) AS ddn
, HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
, HOUR(rpt.endrepeat ) AS hdn, MINUTE(rpt.endrepeat ) AS mindn, SECOND(rpt.endrepeat ) AS sdn
FROM jos_jevents_repetition AS rpt
LEFT JOIN jos_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,4)
AND rpt.endrepeat >= '2022-07-01 00:00:00'
AND rpt.startrepeat <= '2022-07-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
SELECT c.id AS cid, j.id AS jid, c.*, j.*
FROM jos_categories AS c
LEFT JOIN jos_jevents_categories AS j
ON j.id=c.id
WHERE c.access <= 0
AND c.published = 1
AND c.SECTION = 'com_jevents'
ORDER BY c.title
SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published, ev.created AS created
, YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
, YEAR(rpt.endrepeat ) AS ydn, MONTH(rpt.endrepeat ) AS mdn, DAYOFMONTH(rpt.endrepeat ) AS ddn
, HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
, HOUR(rpt.endrepeat ) AS hdn, MINUTE(rpt.endrepeat ) AS mindn, SECOND(rpt.endrepeat ) AS sdn
FROM jos_jevents_repetition AS rpt
LEFT JOIN jos_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,4)
AND rpt.endrepeat >= '2022-07-01 00:00:00'
AND rpt.startrepeat <= '2022-07-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0