SALOTTO LETTERARIO
Venerdì 11 aprile 2008 ore 21.15 – Biblioteca Comunale
via Stazione Vecchia nr.3 – Pontedera
Con il Patrocinio del Comune e dell’Università degli Studi di Cassino
Venerdì 24 ottobre 2008 ore 10.30
presso la Biblioteca Comunale – Sala Malatesta – via del Carmine nr. 8 Cassino (FR)
Presentazione del libro
IL SILENZIO di GIANNI PALAGONIA
Moderatore: Dr. Erasmo Di Vito (Giornalista)
Introduzione: Dr. Michele Durante
Relatore: Dr. Paolo Andrea Taviano – Magistrato
Venerdì 18 gennaio 2008, alle ore 17.30
presso la libreria Cavallotto di Corso Sicilia nr.91 -Catania
Presentazione del libro IL SILENZIO
del poliziotto catanese GIANNI PALAGONIA
Interverranno:
Piergiorgio Di Cara – Scrittore, Funzionario di Polizia
Angelo Busacca – Magistrato A.N.M. – Catania
Dario Montana – Associazione “Libera” (Nomi e numeri contro le mafie)
Giovanna Quasimodo – Giornalista “La Sicilia”
Martedì 16 ottobre 2007 ore 20.30 in Roma
presso la Sala Pincianaquattro
L’aperitivo Letterario
incontro con GIANNI PALAGONIA
autore del libro
IL SILENZIO Racconto di uno sbirro antimafia.
Introduce: Dr. Roberto Artusi – Funzionario di Polizia
Modera: Dr. Giuseppe BALSAMO - Dirigente Superiore in quiescenza di Polizia
Pagina 8 di 8
password_clear ⇒
groups ⇒
link ⇒ https://www.giannipalagonia.it/eventi/126-presentazione-del-l-aquila-e-la-piovra-15-luglio-2015-san-marino.html
link ⇒ https://www.giannipalagonia.it/eventi/123-27-maggio-2015-pubblicazione-l-aquila-e-la-piovra.html
link ⇒ https://www.giannipalagonia.it/eventi/118-parlando-di-legalita-ringraziamenti.html
link ⇒ https://www.giannipalagonia.it/eventi/100-fra-stato-e-mafia-chioggia-17-ottobre-2014.html
link ⇒ https://www.giannipalagonia.it/eventi/98-prossima-presentazione-parlando-di-legalita-aprilia-roma-5-maggio-2014.html
link ⇒ https://www.giannipalagonia.it/eventi/59-parlando-di-legalita-aprilia-roma-19-aprile-2012-103.html
link ⇒ https://www.giannipalagonia.it/eventi/74-presentazione-piacenza-25-maggio-2010-69.html
link ⇒ https://www.giannipalagonia.it/eventi/71-presentazione-qnelle-mani-di-nessunoq-macerata-21maggio-2010-72.html
link ⇒ https://www.giannipalagonia.it/eventi/75-presentazione-qnelle-mani-di-nessunoq-lions-arezzo-20-maggio-2010-68.html
link ⇒ https://www.giannipalagonia.it/eventi/76-presentazione-qnelle-mani-di-nessunoq-bruxelles-28-aprile-2010-67.html
link ⇒ https://www.giannipalagonia.it/eventi/77-presentazione-nelle-mani-di-nessuno-catanzaro-27-febbraio-2010-64.html
link ⇒ https://www.giannipalagonia.it/eventi/78-presentazione-nelle-mani-di-nessuno-tuoro-sul-trasimeno-15-gennaio-2010-61.html
link ⇒ https://www.giannipalagonia.it/eventi/90-presentazione-il-silenzio-pontederapi-11-aprile-2008-22.html
link ⇒ https://www.giannipalagonia.it/eventi/91-presentazione-il-silenzio-cassinofr-24-ottobre-2008-21.html
link ⇒ https://www.giannipalagonia.it/eventi/92-presentazione-il-silenzio-catania-18-gennaio-2008-20.html
link ⇒ https://www.giannipalagonia.it/eventi/93-presentazione-il-silenzio-roma-16-ottobre-2007-19.html
session.token ⇒ eda0432ece5662240567587c21d5f8d1
Application 0.000 seconds (+0.000); 0.37 MB (+0.372) - afterLoadApplication 0.081 seconds (+0.081); 1.65 MB (+1.275) - afterInitialiseApplication 0.108 seconds (+0.027); 2.11 MB (+0.462) - afterRouteApplication 0.328 seconds (+0.220); 3.72 MB (+1.612) - afterDispatchApplication 0.389 seconds (+0.062); 3.99 MB (+0.269) - beforeRenderModule mod_custom (Acquista online footer)Application 0.395 seconds (+0.005); 4.00 MB (+0.010) - afterRenderModule mod_custom (Acquista online footer)Application 0.395 seconds (+0.000); 4.00 MB (-0.003) - beforeRenderModule mod_custom (Social)Application 0.398 seconds (+0.003); 4.01 MB (+0.009) - afterRenderModule mod_custom (Social)Application 0.398 seconds (+0.000); 4.01 MB (+0.000) - beforeRenderModule mod_lca (Storico Articoli)Application 0.407 seconds (+0.009); 4.06 MB (+0.057) - afterRenderModule mod_lca (Storico Articoli)Application 0.407 seconds (+0.000); 4.08 MB (+0.017) - beforeRenderModule mod_articles_popular (Articoli più letti)Application 0.421 seconds (+0.014); 4.27 MB (+0.191) - afterRenderModule mod_articles_popular (Articoli più letti)Application 0.421 seconds (+0.000); 4.12 MB (-0.150) - beforeRenderModule mod_articles_latest (Ultimi articoli)Application 0.455 seconds (+0.034); 4.30 MB (+0.179) - afterRenderModule mod_articles_latest (Ultimi articoli)Application 0.455 seconds (+0.000); 4.15 MB (-0.149) - beforeRenderModule mod_login (Login Form)Application 0.466 seconds (+0.011); 4.18 MB (+0.023) - afterRenderModule mod_login (Login Form)Application 0.467 seconds (+0.000); 4.18 MB (+0.001) - beforeRenderModule mod_jcomments_latest (Ultimi Commenti)Application 0.486 seconds (+0.019); 4.30 MB (+0.123) - afterRenderModule mod_jcomments_latest (Ultimi Commenti)Application 0.486 seconds (+0.000); 4.29 MB (-0.013) - beforeRenderModule mod_articles_category (Eventi in programmazione)Application 0.493 seconds (+0.007); 4.35 MB (+0.061) - afterRenderModule mod_articles_category (Eventi in programmazione)Application 0.493 seconds (+0.000); 4.33 MB (-0.019) - beforeRenderModule mod_custom (LIBRI DI GIANNI PALAGONIA)Application 0.494 seconds (+0.001); 4.33 MB (+0.005) - afterRenderModule mod_custom (LIBRI DI GIANNI PALAGONIA)Application 0.494 seconds (+0.000); 4.33 MB (-0.001) - beforeRenderModule mod_custom_advanced (Custom HTML advanced)Application 0.498 seconds (+0.004); 4.34 MB (+0.011) - afterRenderModule mod_custom_advanced (Custom HTML advanced)Application 0.498 seconds (+0.000); 4.34 MB (-0.004) - beforeRenderModule mod_finder (Cerca)Application 0.533 seconds (+0.036); 4.42 MB (+0.083) - afterRenderModule mod_finder (Cerca)Application 0.534 seconds (+0.000); 4.42 MB (-0.002) - beforeRenderModule mod_pwebfblikebox (Facebook Fan Page)Application 0.540 seconds (+0.006); 4.46 MB (+0.041) - afterRenderModule mod_pwebfblikebox (Facebook Fan Page)Application 0.540 seconds (+0.000); 4.46 MB (-0.004) - beforeRenderModule mod_twitter_widget_slider (Twitter Widget Slider)Application 0.544 seconds (+0.004); 4.47 MB (+0.014) - afterRenderModule mod_twitter_widget_slider (Twitter Widget Slider)Application 0.544 seconds (+0.000); 4.47 MB (-0.003) - beforeRenderModule mod_youtubeslider (Youtube Widget Slider)Application 0.548 seconds (+0.004); 4.48 MB (+0.012) - afterRenderModule mod_youtubeslider (Youtube Widget Slider)Application 0.549 seconds (+0.000); 4.48 MB (-0.002) - beforeRenderModule mod_custom (logo)Application 0.551 seconds (+0.002); 4.48 MB (+0.005) - afterRenderModule mod_custom (logo)Application 0.594 seconds (+0.043); 4.59 MB (+0.104) - afterRender4.7 MB (4,925,488 Bytes)SELECT `data`
FROM `lm4ez_session`
WHERE `session_id` = 'a6bbe4b1f3c4c861940f46c8e0535429'SELECT folder AS type, element AS name, params
FROM lm4ez_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM lm4ez_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM lm4ez_menu AS m
LEFT JOIN lm4ez_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT *
FROM `lm4ez_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''SELECT id, home, template, s.params
FROM lm4ez_template_styles as s
LEFT JOIN lm4ez_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1SELECT extension_id AS id, element AS "option", params, enabled
FROM lm4ez_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT *
FROM lm4ez_languages
WHERE published=1
ORDER BY ordering ASCSELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT extension_id AS id, element AS "option", params, enabled
FROM lm4ez_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM lm4ez_usergroups AS a
LEFT JOIN lm4ez_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM lm4ez_categories as c
LEFT JOIN lm4ez_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN `lm4ez_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=19
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.19')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM lm4ez_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM lm4ez_content AS a
LEFT JOIN lm4ez_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN lm4ez_categories AS c
ON c.id = a.catid
LEFT JOIN lm4ez_users AS ua
ON ua.id = a.created_by
LEFT JOIN lm4ez_users AS uam
ON uam.id = a.modified_by
LEFT JOIN lm4ez_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lm4ez_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 19
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 22:48:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 22:48:10')
ORDER BY c.lft,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 42, 11SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM lm4ez_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM lm4ez_content AS a
LEFT JOIN lm4ez_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN lm4ez_categories AS c
ON c.id = a.catid
LEFT JOIN lm4ez_users AS ua
ON ua.id = a.created_by
LEFT JOIN lm4ez_users AS uam
ON uam.id = a.modified_by
LEFT JOIN lm4ez_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lm4ez_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 19
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 22:48:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 22:48:10')
ORDER BY c.lft,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.createdSELECT id, rules
FROM `lm4ez_viewlevels`SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lm4ez_categories as c
LEFT JOIN lm4ez_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=19
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT extension_id AS id, element AS "option", params, enabled
FROM lm4ez_extensions
WHERE `type` = 'component'
AND `element` = 'com_attachments'SELECT created_by, catid
FROM lm4ez_content
WHERE id = 90SELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.90')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_attachments')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSHOW FULL COLUMNS
FROM `lm4ez_assets`SELECT id
FROM lm4ez_assets
WHERE parent_id = 0SELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.*, u.name as creator_name
FROM lm4ez_attachments AS a
LEFT JOIN lm4ez_users AS u
ON u.id = a.created_by
WHERE a.parent_id=90
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY filenameSELECT created_by, catid
FROM lm4ez_content
WHERE id = 91SELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.91')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT id
FROM lm4ez_assets
WHERE parent_id = 0SELECT a.*, u.name as creator_name
FROM lm4ez_attachments AS a
LEFT JOIN lm4ez_users AS u
ON u.id = a.created_by
WHERE a.parent_id=91
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY filenameSELECT created_by, catid
FROM lm4ez_content
WHERE id = 92SELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.92')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT id
FROM lm4ez_assets
WHERE parent_id = 0SELECT a.*, u.name as creator_name
FROM lm4ez_attachments AS a
LEFT JOIN lm4ez_users AS u
ON u.id = a.created_by
WHERE a.parent_id=92
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY filenameSELECT created_by, catid
FROM lm4ez_content
WHERE id = 93SELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.93')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT id
FROM lm4ez_assets
WHERE parent_id = 0SELECT a.*, u.name as creator_name
FROM lm4ez_attachments AS a
LEFT JOIN lm4ez_users AS u
ON u.id = a.created_by
WHERE a.parent_id=93
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY filenameSELECT *
FROM lm4ez_template_styles
WHERE template = 'shape5_vertex';SELECT *
FROM lm4ez_menu
WHERE template_style_id IN (11)
AND alias = 'eventi'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lm4ez_modules AS m
LEFT JOIN lm4ez_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lm4ez_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-28 22:48:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-28 22:48:10')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 107 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM lm4ez_extensions
WHERE `type` = 'component'
AND `element` = 'com_weblinks'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM lm4ez_menu AS m
LEFT JOIN lm4ez_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT id
FROM lm4ez_menu
WHERE link="index.php?option=com_content&view=featured"
AND home=1SELECT id
FROM lm4ez_menu
WHERE link="index.php?option=com_content&view=featured"
AND access<=1
AND published=1
ORDER BY id DESC
LIMIT 1SELECT id
FROM lm4ez_menu
WHERE link LIKE "index.php?option=com_content%"
AND access<=1
AND published=1
ORDER BY id DESC
LIMIT 1SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM lm4ez_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM lm4ez_content AS a
LEFT JOIN lm4ez_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN lm4ez_categories AS c
ON c.id = a.catid
LEFT JOIN lm4ez_users AS ua
ON ua.id = a.created_by
LEFT JOIN lm4ez_users AS uam
ON uam.id = a.modified_by
LEFT JOIN lm4ez_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lm4ez_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 22:48:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 22:48:10')
ORDER BY a.hits DESC
LIMIT 0, 5SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lm4ez_categories as c
LEFT JOIN lm4ez_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=2
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lm4ez_categories as c
LEFT JOIN lm4ez_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=16
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM lm4ez_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM lm4ez_content AS a
LEFT JOIN lm4ez_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN lm4ez_categories AS c
ON c.id = a.catid
LEFT JOIN lm4ez_users AS ua
ON ua.id = a.created_by
LEFT JOIN lm4ez_users AS uam
ON uam.id = a.modified_by
LEFT JOIN lm4ez_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lm4ez_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 22:48:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 22:48:10')
ORDER BY a.created DESC
LIMIT 0, 5SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lm4ez_categories as c
LEFT JOIN lm4ez_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=12
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner
FROM lm4ez_jcomments AS c JOIN lm4ez_jcomments_objects AS o
ON c.object_id = o.object_id
AND c.object_group = o.object_group
AND c.lang = o.lang
WHERE c.published = 1
AND c.deleted = 0
AND o.link <> ''
AND o.access IN (1,0)
AND c.object_group in ('com_content','com_jcomments')
ORDER BY c.date DESC
LIMIT 0, 2SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM lm4ez_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM lm4ez_content AS a
LEFT JOIN lm4ez_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN lm4ez_categories AS c
ON c.id = a.catid
LEFT JOIN lm4ez_users AS ua
ON ua.id = a.created_by
LEFT JOIN lm4ez_users AS uam
ON uam.id = a.modified_by
LEFT JOIN lm4ez_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lm4ez_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (19)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 22:48:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 22:48:10')
AND a.publish_up >= DATE_SUB('2026-10-28 22:48:10', INTERVAL 30 DAY)
ORDER BY a.title ASCSELECT extension_id AS id, element AS "option", params, enabled
FROM lm4ez_extensions
WHERE `type` = 'component'
AND `element` = 'com_finder'SELECT name
FROM `lm4ez_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'finder'
AND `enabled` = 1SELECT `title`
FROM `lm4ez_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1)UPDATE `lm4ez_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1793227688;s:18:\"session.timer.last\";i:1793227689;s:17:\"session.timer.now\";i:1793227690;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:76:\"&return=aHR0cHM6Ly93d3cuZ2lhbm5pcGFsYWdvbmlhLml0L2V2ZW50aS5odG1sP3N0YXJ0PTQy\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;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:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:16:{s:40:\"d2fff895d54c88e12da509d7e0a248483a2605d8\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://www.giannipalagonia.it/eventi/126-presentazione-del-l-aquila-e-la-piovra-15-luglio-2015-san-marino.html\";s:6:\"expiry\";i:1793227688;}s:40:\"399555a03954fb26ded67aa4a91edc59016d8bcc\";O:8:\"stdClass\":2:{s:4:\"link\";s:96:\"https://www.giannipalagonia.it/eventi/123-27-maggio-2015-pubblicazione-l-aquila-e-la-piovra.html\";s:6:\"expiry\";i:1793227688;}s:40:\"76217a266901074c8532875cd9ca3ea0337bac99\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"https://www.giannipalagonia.it/eventi/118-parlando-di-legalita-ringraziamenti.html\";s:6:\"expiry\";i:1793227688;}s:40:\"9e4b46bd57d574b4af65dad42d20b85ab5d966ec\";O:8:\"stdClass\":2:{s:4:\"link\";s:89:\"https://www.giannipalagonia.it/eventi/100-fra-stato-e-mafia-chioggia-17-ottobre-2014.html\";s:6:\"expiry\";i:1793227688;}s:40:\"e19336e3f97f6e8b71462c0e4810c521535bc576\";O:8:\"stdClass\":2:{s:4:\"link\";s:116:\"https://www.giannipalagonia.it/eventi/98-prossima-presentazione-parlando-di-legalita-aprilia-roma-5-maggio-2014.html\";s:6:\"expiry\";i:1793227688;}s:40:\"3af9a15e9d0458098a6aa9f1ffdadce8b7ba50e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"https://www.giannipalagonia.it/eventi/59-parlando-di-legalita-aprilia-roma-19-aprile-2012-103.html\";s:6:\"expiry\";i:1793227688;}s:40:\"45f76a64f609777e856da1104aee888c4056d285\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"https://www.giannipalagonia.it/eventi/74-presentazione-piacenza-25-maggio-2010-69.html\";s:6:\"expiry\";i:1793227690;}s:40:\"2c6db24c7939a2dbf89a03801a1a665285d3ffeb\";O:8:\"stdClass\":2:{s:4:\"link\";s:109:\"https://www.giannipalagonia.it/eventi/71-presentazione-qnelle-mani-di-nessunoq-macerata-21maggio-2010-72.html\";s:6:\"expiry\";i:1793227690;}s:40:\"d4cf72629216ac20110a5c6cfaf740efd5755670\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"https://www.giannipalagonia.it/eventi/75-presentazione-qnelle-mani-di-nessunoq-lions-arezzo-20-maggio-2010-68.html\";s:6:\"expiry\";i:1793227690;}s:40:\"0c229f0895090dfb142aaf0d0325afd99e29848c\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://www.giannipalagonia.it/eventi/76-presentazione-qnelle-mani-di-nessunoq-bruxelles-28-aprile-2010-67.html\";s:6:\"expiry\";i:1793227690;}s:40:\"a3ff774dc2b62d0f980e7b0c81b00e1df833db66\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://www.giannipalagonia.it/eventi/77-presentazione-nelle-mani-di-nessuno-catanzaro-27-febbraio-2010-64.html\";s:6:\"expiry\";i:1793227690;}s:40:\"ac126473c20c9241283c34ad7fc7092ed0b927c7\";O:8:\"stdClass\":2:{s:4:\"link\";s:120:\"https://www.giannipalagonia.it/eventi/78-presentazione-nelle-mani-di-nessuno-tuoro-sul-trasimeno-15-gennaio-2010-61.html\";s:6:\"expiry\";i:1793227690;}s:40:\"10c625520e1e097edfd126576b81677bb3a55ad8\";O:8:\"stdClass\":2:{s:4:\"link\";s:101:\"https://www.giannipalagonia.it/eventi/90-presentazione-il-silenzio-pontederapi-11-aprile-2008-22.html\";s:6:\"expiry\";i:1793227690;}s:40:\"008c0f964fd9a669198fe9e4031b31a4b5174ecf\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"https://www.giannipalagonia.it/eventi/91-presentazione-il-silenzio-cassinofr-24-ottobre-2008-21.html\";s:6:\"expiry\";i:1793227690;}s:40:\"2b115e2e76684e4803b11d511a43db482afc5bca\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"https://www.giannipalagonia.it/eventi/92-presentazione-il-silenzio-catania-18-gennaio-2008-20.html\";s:6:\"expiry\";i:1793227690;}s:40:\"d030c389d611e71160610b2195f096d7c57f3634\";O:8:\"stdClass\":2:{s:4:\"link\";s:95:\"https://www.giannipalagonia.it/eventi/93-presentazione-il-silenzio-roma-16-ottobre-2007-19.html\";s:6:\"expiry\";i:1793227690;}}s:13:\"session.token\";s:32:\"eda0432ece5662240567587c21d5f8d1\";}'
, `time` = '1793227691'
WHERE `session_id` = 'a6bbe4b1f3c4c861940f46c8e0535429'8 × SELECT b.rules
FROM lm4ez_assets AS a
LEFT JOIN lm4ez_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM lm4ez_extensions5 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM lm4ez_contact_details AS contact4 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lm4ez_categories as c
LEFT JOIN lm4ez_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt4 × SELECT id
FROM lm4ez_assets4 × SELECT created_by, catid
FROM lm4ez_content4 × SELECT a.*, u.name as creator_name
FROM lm4ez_attachments AS a
LEFT JOIN lm4ez_users AS u
ON u.id = a.created_by3 × SELECT id
FROM lm4ez_menu2 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM lm4ez_menu AS m
LEFT JOIN lm4ez_extensions AS e
ON m.component_id = e.extension_id1 × SELECT name
FROM `lm4ez_extensions`1 × SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner
FROM lm4ez_jcomments AS c JOIN lm4ez_jcomments_objects AS o
ON c.object_id = o.object_id
AND c.object_group = o.object_group
AND c.lang = o.lang1 × SELECT *
FROM lm4ez_template_styles1 × SELECT *
FROM lm4ez_menu1 × SELECT `title`
FROM `lm4ez_finder_taxonomy`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lm4ez_modules AS m
LEFT JOIN lm4ez_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lm4ez_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id, rules
FROM `lm4ez_viewlevels1 × SELECT *
FROM `lm4ez_jcomments_settings`1 × SELECT folder AS type, element AS name, params
FROM lm4ez_extensions1 × SELECT id, home, template, s.params
FROM lm4ez_template_styles as s
LEFT JOIN lm4ez_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM lm4ez_languages1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM lm4ez_categories as c
LEFT JOIN lm4ez_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lm4ez_categories AS cat JOIN lm4ez_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT b.id
FROM lm4ez_usergroups AS a
LEFT JOIN lm4ez_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `data`
FROM `lm4ez_session`1 × UPDATE `lm4ez_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1793227688;s:18:\"session.timer.last\";i:1793227689;s:17:\"session.timer.now\";i:1793227690;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:76:\"&return=aHR0cHM6Ly93d3cuZ2lhbm5pcGFsYWdvbmlhLml0L2V2ZW50aS5odG1sP3N0YXJ0PTQy\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;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:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:16:{s:40:\"d2fff895d54c88e12da509d7e0a248483a2605d8\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://www.giannipalagonia.it/eventi/126-presentazione-del-l-aquila-e-la-piovra-15-luglio-2015-san-marino.html\";s:6:\"expiry\";i:1793227688;}s:40:\"399555a03954fb26ded67aa4a91edc59016d8bcc\";O:8:\"stdClass\":2:{s:4:\"link\";s:96:\"https://www.giannipalagonia.it/eventi/123-27-maggio-2015-pubblicazione-l-aquila-e-la-piovra.html\";s:6:\"expiry\";i:1793227688;}s:40:\"76217a266901074c8532875cd9ca3ea0337bac99\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"https://www.giannipalagonia.it/eventi/118-parlando-di-legalita-ringraziamenti.html\";s:6:\"expiry\";i:1793227688;}s:40:\"9e4b46bd57d574b4af65dad42d20b85ab5d966ec\";O:8:\"stdClass\":2:{s:4:\"link\";s:89:\"https://www.giannipalagonia.it/eventi/100-fra-stato-e-mafia-chioggia-17-ottobre-2014.html\";s:6:\"expiry\";i:1793227688;}s:40:\"e19336e3f97f6e8b71462c0e4810c521535bc576\";O:8:\"stdClass\":2:{s:4:\"link\";s:116:\"https://www.giannipalagonia.it/eventi/98-prossima-presentazione-parlando-di-legalita-aprilia-roma-5-maggio-2014.html\";s:6:\"expiry\";i:1793227688;}s:40:\"3af9a15e9d0458098a6aa9f1ffdadce8b7ba50e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"https://www.giannipalagonia.it/eventi/59-parlando-di-legalita-aprilia-roma-19-aprile-2012-103.html\";s:6:\"expiry\";i:1793227688;}s:40:\"45f76a64f609777e856da1104aee888c4056d285\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"https://www.giannipalagonia.it/eventi/74-presentazione-piacenza-25-maggio-2010-69.html\";s:6:\"expiry\";i:1793227690;}s:40:\"2c6db24c7939a2dbf89a03801a1a665285d3ffeb\";O:8:\"stdClass\":2:{s:4:\"link\";s:109:\"https://www.giannipalagonia.it/eventi/71-presentazione-qnelle-mani-di-nessunoq-macerata-21maggio-2010-72.html\";s:6:\"expiry\";i:1793227690;}s:40:\"d4cf72629216ac20110a5c6cfaf740efd5755670\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"https://www.giannipalagonia.it/eventi/75-presentazione-qnelle-mani-di-nessunoq-lions-arezzo-20-maggio-2010-68.html\";s:6:\"expiry\";i:1793227690;}s:40:\"0c229f0895090dfb142aaf0d0325afd99e29848c\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://www.giannipalagonia.it/eventi/76-presentazione-qnelle-mani-di-nessunoq-bruxelles-28-aprile-2010-67.html\";s:6:\"expiry\";i:1793227690;}s:40:\"a3ff774dc2b62d0f980e7b0c81b00e1df833db66\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://www.giannipalagonia.it/eventi/77-presentazione-nelle-mani-di-nessuno-catanzaro-27-febbraio-2010-64.html\";s:6:\"expiry\";i:1793227690;}s:40:\"ac126473c20c9241283c34ad7fc7092ed0b927c7\";O:8:\"stdClass\":2:{s:4:\"link\";s:120:\"https://www.giannipalagonia.it/eventi/78-presentazione-nelle-mani-di-nessuno-tuoro-sul-trasimeno-15-gennaio-2010-61.html\";s:6:\"expiry\";i:1793227690;}s:40:\"10c625520e1e097edfd126576b81677bb3a55ad8\";O:8:\"stdClass\":2:{s:4:\"link\";s:101:\"https://www.giannipalagonia.it/eventi/90-presentazione-il-silenzio-pontederapi-11-aprile-2008-22.html\";s:6:\"expiry\";i:1793227690;}s:40:\"008c0f964fd9a669198fe9e4031b31a4b5174ecf\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"https://www.giannipalagonia.it/eventi/91-presentazione-il-silenzio-cassinofr-24-ottobre-2008-21.html\";s:6:\"expiry\";i:1793227690;}s:40:\"2b115e2e76684e4803b11d511a43db482afc5bca\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"https://www.giannipalagonia.it/eventi/92-presentazione-il-silenzio-catania-18-gennaio-2008-20.html\";s:6:\"expiry\";i:1793227690;}s:40:\"d030c389d611e71160610b2195f096d7c57f3634\";O:8:\"stdClass\":2:{s:4:\"link\";s:95:\"https://www.giannipalagonia.it/eventi/93-presentazione-il-silenzio-roma-16-ottobre-2007-19.html\";s:6:\"expiry\";i:1793227690;}}s:13:\"session.token\";s:32:\"eda0432ece5662240567587c21d5f8d1\";}' , `time` = '1793227691'1 × SHOW FULL COLUMNS
FROM `lm4ez_assets


Leggi tutto...