SELECT *
FROM jos_session
WHERE session_id = 'ho02a888e1g3k9r5d2v5fhc0n4'
DELETE
FROM jos_session
WHERE ( TIME < '1715930646' )
SELECT *
FROM jos_session
WHERE session_id = 'ho02a888e1g3k9r5d2v5fhc0n4'
UPDATE `jos_session`
SET `time`='1715931546',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:44;s:19:\"session.timer.start\";i:1715931522;s:18:\"session.timer.last\";i:1715931545;s:17:\"session.timer.now\";i:1715931545;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:44:{s:40:\"b48d684e8dc6535488af1eeb126065bae6d716c9\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2023&month=04&day=03&Itemid=1\";s:6:\"expiry\";i:1715931522;}s:40:\"8614a1c2555b3cd6680f3d17fb1529e4dabf40b8\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2017&month=10&day=10&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931523;}s:40:\"efcd3746232254c32fdb8f0da00aacec84bfde07\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2021&month=12&day=21&Itemid=1\";s:6:\"expiry\";i:1715931524;}s:40:\"27a464d61c8ef63e17ebd514cc9a34939bfdb851\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2019&month=08&day=13&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931524;}s:40:\"02fd3e8159e88b345f8ba3d3094b5f2013e0fba8\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2019&month=10&day=11&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931525;}s:40:\"d6a05040ba72624b984b1b89bf0417009c0c7d09\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2018&month=08&day=23&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931525;}s:40:\"6b648b603a360fe8b0babd62cdf5c1e2c5144aa2\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2023&month=03&day=26&Itemid=1\";s:6:\"expiry\";i:1715931525;}s:40:\"907423b4f64d7c3df5a5d427889b28bd418facaf\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2017&month=10&day=01&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931526;}s:40:\"95b400b0b44cc17d399bf0415984962318ed1773\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2023&month=04&day=10&Itemid=1\";s:6:\"expiry\";i:1715931527;}s:40:\"a3d25f4fbf687d9abc2ee1e57e11701c897e16bb\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2022&month=05&day=16&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931528;}s:40:\"a6d3491eaded186a973d59072f7ee86a71010216\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2022&month=08&day=22&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931528;}s:40:\"4c10f40b4b58c5ec53024abeb5baba1c790b6c38\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2022&month=08&day=15&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931529;}s:40:\"5d66d3c21e3d4fe72c483ba7fe7a57aeeab54bda\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2020&month=05&day=25&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931529;}s:40:\"561b705dc7c83aa8bcec465a3df026f62fc33e70\";O:8:\"stdClass\":2:{s:4:\"link\";s:128:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2023&month=04&day=28&Itemid=1\";s:6:\"expiry\";i:1715931530;}s:40:\"865d3009f6d7a78ac7dca5e12b0efb8e636bb150\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2022&month=08&day=15&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931530;}s:40:\"6a50ee82c04d7cbcd5f2a86d2f3d8b4aa529f51c\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2017&month=10&day=21&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931531;}s:40:\"4d7fca79a7f2e95d87942158df6cefd6de8c958b\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2020&month=10&day=26&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931532;}s:40:\"c044bbbe3de9e982e6727b37a033d0b80349fe9f\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2017&month=10&day=06&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931532;}s:40:\"ef19efe5d980c10fddddfb218dd6978e4e782dee\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2023&month=04&day=29&Itemid=1\";s:6:\"expiry\";i:1715931533;}s:40:\"49e3ffc6169d92486830c18b699cfc61428da08d\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2022&month=05&day=13&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931533;}s:40:\"1374eec7b830a3cbe8221950310a6b3bc36d5e94\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2021&month=12&day=06&Itemid=1\";s:6:\"expiry\";i:1715931534;}s:40:\"55847e2bb4331f60c69695115480078c6add7943\";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=22&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931534;}s:40:\"8a591d232e4ab47fb62ece6715faec59a4159d8e\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2021&month=12&day=02&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931534;}s:40:\"5eedbfa584e4c6dcb00eb11bcafa050771c90caa\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2019&month=10&day=17&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931535;}s:40:\"caedb2283800f17bdb3a275571de0c37f8d6c857\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2023&month=04&day=30&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931535;}s:40:\"a754fa56a7dad0211ea0f2e323562745768ce6a3\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2022&month=05&day=02&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931536;}s:40:\"0cc4237f2fddb58c8d44d7875b523d1b5f7c957b\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2023&month=04&day=15&Itemid=1\";s:6:\"expiry\";i:1715931536;}s:40:\"105cbf3f37faff96c3b32480daaf1d35c54061c3\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2018&month=03&day=03&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931537;}s:40:\"7f53d07c6dc4f3322fb6ef99c46b08cf2e5081d0\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2019&month=11&day=02&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931537;}s:40:\"e0cff9c05f0ee8c0955ecb6852f7da8fdb21ef33\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2022&month=05&day=23&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931538;}s:40:\"72ad86fee9b7734a014ac1623aca552a6382e946\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2019&month=10&day=25&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931538;}s:40:\"54dbdb16660830e0373e2027718cad9098968013\";O:8:\"stdClass\":2:{s:4:\"link\";s:128:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2023&month=04&day=18&Itemid=1\";s:6:\"expiry\";i:1715931539;}s:40:\"5fd13827f45abb50e22f8ed113f78da522235f02\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2017&month=10&day=01&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931539;}s:40:\"2f54c316ee6bf747eba489b2ffdeae3b038c3683\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2021&month=12&day=24&Itemid=1\";s:6:\"expiry\";i:1715931540;}s:40:\"c3fb2a14d6e9dc445f54e7468d808c39078fca06\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2022&month=05&day=03&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931540;}s:40:\"fe8ad7172f6990570f5e6f97cefa02b28f4a4c51\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2021&month=12&day=01&Itemid=1\";s:6:\"expiry\";i:1715931541;}s:40:\"ac5cfb5d2cb000f8c5e2f2867d53cab94efb5a9b\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2023&month=04&day=18&Itemid=1\";s:6:\"expiry\";i:1715931542;}s:40:\"694793e67df4e7849485a99e3c164d9d1ceb7018\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2023&month=04&day=26&Itemid=1\";s:6:\"expiry\";i:1715931542;}s:40:\"c00e7124a7eb822ff859c19a1018c696ade105b6\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2023&month=04&day=13&Itemid=1\";s:6:\"expiry\";i:1715931543;}s:40:\"5a6103a2dce82ca92796e349f714e9a30565677a\";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=18&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931543;}s:40:\"7ad73fc96d26ced2d8a65e754a1d77e557507fc0\";O:8:\"stdClass\":2:{s:4:\"link\";s:132:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2021&month=12&day=10&Itemid=1\";s:6:\"expiry\";i:1715931544;}s:40:\"9aa31f7a315e1e02f60c18a0f305683fa851f429\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2019&month=10&day=24&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931544;}s:40:\"60b3e553d68ce0173f21e5f199132edb088d9c0a\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2020&month=11&day=23&Itemid=1&catids=4\";s:6:\"expiry\";i:1715931545;}s:40:\"624cd9fe6037ee4d94808b35752807ef008dfd03\";O:8:\"stdClass\":2:{s:4:\"link\";s:131:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2021&month=12&day=12&Itemid=1\";s:6:\"expiry\";i:1715931545;}}}'
WHERE session_id='ho02a888e1g3k9r5d2v5fhc0n4'
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'
AND (c.id IN (4) OR p.id IN (4) OR gp.id IN (4) OR ggp.id IN (4))
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 >= '2019-10-01 00:00:00'
AND rpt.startrepeat <= '2019-10-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 >= '2019-10-01 00:00:00'
AND rpt.startrepeat <= '2019-10-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0