SELECT *
FROM jos_session
WHERE session_id = 'ie5g6ek9na5aar3poh8bnbml71'
DELETE
FROM jos_session
WHERE ( TIME < '1715927221' )
SELECT *
FROM jos_session
WHERE session_id = 'ie5g6ek9na5aar3poh8bnbml71'
UPDATE `jos_session`
SET `time`='1715928121',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:22;s:19:\"session.timer.start\";i:1715928111;s:18:\"session.timer.last\";i:1715928120;s:17:\"session.timer.now\";i:1715928121;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:21:{s:40:\"088099f1b31b23231dfbac6b88f3e09f39efbde0\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2018&month=11&day=13&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928111;}s:40:\"ae79393acd39b573c5dc63305de9a09b91e5aa63\";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=06&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928112;}s:40:\"a1fb5de04011a828471947bd51b2ead5ce5ae86d\";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=09&Itemid=1\";s:6:\"expiry\";i:1715928112;}s:40:\"4cbfb3d2a703fc845c9cf7e373c18804a53e7650\";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=09&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928113;}s:40:\"2e04708b46b73d87146d093a8983baa092851486\";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=04&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928113;}s:40:\"245241f435c156d0a32d731f18e1daa77aa6dd40\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2018&month=11&day=20&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928114;}s:40:\"4692a67a314de5cd5effd8391947b7fedc82d39d\";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=25&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928114;}s:40:\"a93af650f598631f1f67f3ce266d9f7ac192fb17\";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=20&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928114;}s:40:\"46799791adfe4e9c46e52d7344c201e6d8e07262\";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=04&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928116;}s:40:\"67772fefab731865cf05f2891dfc0b2f22256746\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2015&month=08&day=15&Itemid=1\";s:6:\"expiry\";i:1715928116;}s:40:\"0064330adb1817efa306504531b42a3a7306bcd3\";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=04&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928116;}s:40:\"6960adeeb058f90346e322a1a96e3182220d77ec\";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=19&Itemid=1\";s:6:\"expiry\";i:1715928117;}s:40:\"2be92cc6fc38a57570135871e8847ac8b04f940f\";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=15&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928117;}s:40:\"6c94aeb7e492a8f91a557c8ec8b271ec5da7821e\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2022&month=07&day=05&Itemid=1\";s:6:\"expiry\";i:1715928118;}s:40:\"fbdbbe33fb8404f5c2131d2450d434057ab6e0e9\";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=23&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928118;}s:40:\"c4e0326abdcc1065b0e0c255f68a80c40cf851d4\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2018&month=11&day=09&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928118;}s:40:\"75b1258c99d2ef523564ce75db4427fc2b2f06bf\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=11&day=16&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928119;}s:40:\"563c3ad52a70a282b2e87046bc7a7d298ee53043\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2020&month=09&day=13&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928120;}s:40:\"f60a73771faa6a1d22d9eaf747e48d656427e482\";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=13&Itemid=1\";s:6:\"expiry\";i:1715928120;}s:40:\"2251ddd39aebd7284bfbadb69ebd25fc8cd14675\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2015&month=10&day=16&Itemid=1\";s:6:\"expiry\";i:1715928120;}s:40:\"e3d7d9c6cc01558ed107fcd6485d357a295251ae\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2020&month=04&day=17&Itemid=1&catids=4\";s:6:\"expiry\";i:1715928121;}}}__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='ie5g6ek9na5aar3poh8bnbml71'
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.rp_id
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 >= '2020-01-01 00:00:00'
AND rpt.startrepeat <= '2020-12-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
SELECT ev.*, rpt.*, rr.*, det.*, ev.state AS published
, 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 >= '2020-01-01 00:00:00'
AND rpt.startrepeat <= '2020-12-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
ORDER BY rpt.startrepeat ASC
LIMIT 10
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 >= '2020-12-01 00:00:00'
AND rpt.startrepeat <= '2020-12-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
