SELECT *
FROM jos_session
WHERE session_id = 'fhe1mk71es57bsoi422larvfa2'
DELETE
FROM jos_session
WHERE ( TIME < '1716064134' )
SELECT *
FROM jos_session
WHERE session_id = 'fhe1mk71es57bsoi422larvfa2'
UPDATE `jos_session`
SET `time`='1716065034',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:31;s:19:\"session.timer.start\";i:1716065020;s:18:\"session.timer.last\";i:1716065033;s:17:\"session.timer.now\";i:1716065034;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:31:{s:40:\"ab298cb03b9a9ced6f96b518a98e6f8a85a8a0ca\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=06&day=19&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065020;}s:40:\"80853c0c4df9a7bf22c941029f8661909c9d14e6\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2018&month=03&day=06&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065021;}s:40:\"fc7dc50c52e28c3408532322c52c293907c40bc6\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=04&day=27&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065021;}s:40:\"811d5144551d29a7edf7d4bdfbcb171043f57f7e\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=05&day=01&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065022;}s:40:\"d7537c87c31f753e8e0c6c7a485f88f8adedc776\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2020&month=06&day=03&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065022;}s:40:\"56e4a157cca8eda1dce1072ab56a368da27f744e\";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=14&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065023;}s:40:\"0ccc5461cede018622dfc196cc21ed4dacf5b434\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2019&month=03&day=25&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065023;}s:40:\"de1f50faeb89f36017d6eb703268c302cd1f204c\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=06&day=25&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065024;}s:40:\"9a2ff91e2bb4d28eb7974488d1d77db7fe90261a\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2019&month=03&day=04&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065024;}s:40:\"787bfb3b165823d5e1b348e4dd4824af320f7554\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=06&day=18&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065025;}s:40:\"4e646a3f541a662b5ffc22343805c3053b5f157e\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=06&day=08&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065025;}s:40:\"d3abda03bae3726ee7dc0c7ce3408bad30b96569\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2019&month=05&day=01&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065025;}s:40:\"e999249b6ea5cf19a6b7d0ee76bf4fc2c04cbdde\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2020&month=06&day=28&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065026;}s:40:\"0822d0bce11c4660f61bfb64cbe4c6d142d3fa6f\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2021&month=05&day=15&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065026;}s:40:\"49acb4fd608d36b7f9035a915c98fa1fa403b392\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=05&day=07&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065027;}s:40:\"74c186e46f04ec1add4ebb402491701865b2902d\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2021&month=05&day=30&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065027;}s:40:\"17a916555d47d07eddb5f5a5f3d19142f3e7a78b\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=04&day=30&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065028;}s:40:\"07466ea95c9cc45223db67f32647327cf3938cde\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=04&day=03&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065028;}s:40:\"3cf8f6ff2bd06d2fb7294a48aa7b8f0d72f08aec\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2022&month=10&day=20&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065028;}s:40:\"e89cd37991a63d9e6c846b3423303e8dd7fcca1f\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2019&month=03&day=09&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065029;}s:40:\"5f35d108499fd7b20f37136f0f66f145d6b1dcf1\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2018&month=10&day=26&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065029;}s:40:\"da050d28c76a453c4254fd1330a8777f29068247\";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=04&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065030;}s:40:\"cebd254b822d832b68fa482bafaa1e978397e7a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=04&day=29&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065030;}s:40:\"66e5d8ef9514cc335d8f8cc365660d57089a57dc\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2018&month=04&day=04&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065030;}s:40:\"ed1d9d82aa9d4652574a0cbd0fa0558174643edb\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=year.listevents&year=2018&month=04&day=11&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065031;}s:40:\"7909558727b0699ca728aa20cd5b78ce3b20bd16\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=month.calendar&year=2017&month=06&day=10&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065032;}s:40:\"a7170b968d1a1b339f3494ed904c78feb167a45b\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=04&day=26&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065032;}s:40:\"5ea67e14699eda439a19dc646d977f92d6b4ed37\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=04&day=25&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065033;}s:40:\"7d8450f5b897842f7c7bef39ebddbbf1ea7c740d\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=week.listevents&year=2018&month=04&day=03&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065033;}s:40:\"2360b7a38926997d99ec387b82efa3d92322f1ef\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=search.form&year=2019&month=03&day=09&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065033;}s:40:\"91b26192ef1e093090cf82fca200b585a57e363c\";O:8:\"stdClass\":2:{s:4:\"link\";s:144:\"http://www.cifppiambello.it/index.php?option=com_jevents&task=day.listevents&year=2021&month=05&day=17&Itemid=1&catids=4\";s:6:\"expiry\";i:1716065034;}}}'
WHERE session_id='fhe1mk71es57bsoi422larvfa2'
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 >= '2021-05-16 00:00:00'
AND rpt.startrepeat <= '2021-05-22 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
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 >= '2021-05-01 00:00:00'
AND rpt.startrepeat <= '2021-05-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
