|
Salve a tutti, ricordiamo che con il terremoto che ha colpito nel 2016 il centro Italia la nostra Chiesa di Santa Maria delle Vergini ha subito gravissimo danni rendendola inagibile, per ora le celebrazioni vengo effettuare nella tensostruttura adiacente alla Chiesa, con igresso dal cancello a destra della Chiesa. Grazie
password_clear ⇒
groups ⇒
limittype ⇒ 0
leadingMax ⇒ 750
introMax ⇒ 500
Ignore_Existing_Read_More ⇒ 0
Strip_Formatting ⇒ 0
wrap_output ⇒ 0
wrap_output_template ⇒ %OUTPUT%
Enabled_Front_Page ⇒ 1
add_trimming_dots ⇒ 0
trimming_dots ⇒ ...
categories_switch ⇒ 0
categories ⇒
articles_switch ⇒ 0
debug ⇒ 0
Thumbnails ⇒ 0
Thumbnails_Class ⇒
Strip_Image_Formatting ⇒ 0
Force_Image_Handle ⇒ 0
csscode ⇒ .margin-h-8 {margin:8px;}
Application 0.013 seconds (+0.013); 0.60 MB (+0.602) - afterLoad
Application 0.448 seconds (+0.436); 5.15 MB (+4.548) - afterInitialise
Application 0.533 seconds (+0.085); 6.96 MB (+1.814) - afterRoute
Application 0.903 seconds (+0.370); 9.43 MB (+2.468) - afterDispatch
Application 1.146 seconds (+0.243); 10.13 MB (+0.703) - beforeRenderModule mod_menu (Menu Parrocchia)
Application 1.190 seconds (+0.043); 10.21 MB (+0.078) - afterRenderModule mod_menu (Menu Parrocchia)
Application 1.194 seconds (+0.004); 10.19 MB (-0.024) - beforeRenderModule mod_dpcalendar_upcoming (Prossimi Eventi)
Application 10.406 seconds (+9.213); 17.49 MB (+7.298) - afterRenderModule mod_dpcalendar_upcoming (Prossimi Eventi)
Application 10.410 seconds (+0.003); 17.46 MB (-0.025) - beforeRenderModule mod_custom (Pulsante Calendario)
Application 10.428 seconds (+0.018); 17.47 MB (+0.008) - afterRenderModule mod_custom (Pulsante Calendario)
Application 10.435 seconds (+0.006); 17.47 MB (-0.003) - beforeRenderModule mod_custom (Pulsante Lettera ai Cristiani)
Application 10.435 seconds (+0.001); 17.47 MB (+0.005) - afterRenderModule mod_custom (Pulsante Lettera ai Cristiani)
Application 10.443 seconds (+0.008); 17.47 MB (-0.003) - beforeRenderModule mod_custom (Pulsante Vergini Fori le mura)
Application 10.444 seconds (+0.000); 17.47 MB (+0.005) - afterRenderModule mod_custom (Pulsante Vergini Fori le mura)
Application 10.450 seconds (+0.006); 17.47 MB (+0.000) - beforeRenderModule mod_jumi (Facebook)
Application 10.470 seconds (+0.020); 17.49 MB (+0.012) - afterRenderModule mod_jumi (Facebook)
Application 10.479 seconds (+0.010); 17.49 MB (+0.003) - beforeRenderModule mod_jw_srfr (News dalla Diocesi)
Application 12.727 seconds (+2.248); 17.62 MB (+0.128) - afterRenderModule mod_jw_srfr (News dalla Diocesi)
Application 12.735 seconds (+0.008); 17.61 MB (-0.010) - beforeRenderModule mod_weblinks (Link Consigliati)
Application 12.774 seconds (+0.039); 17.80 MB (+0.189) - afterRenderModule mod_weblinks (Link Consigliati)
Application 12.786 seconds (+0.012); 17.75 MB (-0.045) - beforeRenderModule mod_custom (Pulsante Gallery)
Application 12.786 seconds (+0.001); 17.76 MB (+0.005) - afterRenderModule mod_custom (Pulsante Gallery)
Application 12.796 seconds (+0.009); 17.75 MB (-0.003) - beforeRenderModule mod_custom (Pulsante Tour)
Application 12.796 seconds (+0.001); 17.76 MB (+0.005) - afterRenderModule mod_custom (Pulsante Tour)
Application 12.805 seconds (+0.009); 17.76 MB (-0.003) - beforeRenderModule mod_custom (Pulsante Eventi)
Application 12.806 seconds (+0.001); 17.76 MB (+0.005) - afterRenderModule mod_custom (Pulsante Eventi)
Application 12.816 seconds (+0.011); 17.76 MB (-0.003) - beforeRenderModule mod_custom (Pulsante Streaming)
Application 12.817 seconds (+0.001); 17.76 MB (+0.005) - afterRenderModule mod_custom (Pulsante Streaming)
Application 12.828 seconds (+0.010); 17.76 MB (-0.002) - beforeRenderModule mod_jumi (Stato Streaming)
Application 12.846 seconds (+0.018); 17.80 MB (+0.038) - afterRenderModule mod_jumi (Stato Streaming)
Application 12.856 seconds (+0.010); 17.76 MB (-0.037) - beforeRenderModule mod_search (Cerca)
Application 12.880 seconds (+0.024); 17.78 MB (+0.017) - afterRenderModule mod_search (Cerca)
Application 12.886 seconds (+0.006); 17.75 MB (-0.029) - beforeRenderModule mod_random_image (Header)
Application 12.914 seconds (+0.028); 17.78 MB (+0.029) - afterRenderModule mod_random_image (Header)
Application 12.914 seconds (+0.000); 17.78 MB (-0.001) - beforeRenderModule mod_cblogin (Login)
Application 12.974 seconds (+0.060); 19.13 MB (+1.354) - afterRenderModule mod_cblogin (Login)
Application 13.091 seconds (+0.117); 19.21 MB (+0.076) - afterRender
19.24 MB (20,172,984 Bytes)
SELECT `data`
FROM `q21e9_session`
WHERE `session_id` = 'er544vks66e6mtgcp3c18k7qq2'
SELECT `session_id`
FROM `q21e9_session`
WHERE `session_id` = 'er544vks66e6mtgcp3c18k7qq2'
LIMIT 0, 1
INSERT INTO `q21e9_session`
(`session_id`, `client_id`, `time`)
VALUES
('er544vks66e6mtgcp3c18k7qq2', 0, '1610795904')
SELECT b.id
FROM q21e9_usergroups AS a
LEFT JOIN q21e9_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `q21e9_viewlevels`
SELECT folder AS type, element AS name, params
FROM q21e9_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM q21e9_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
select id, title, alias
from q21e9_jumi
where published = 1
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 q21e9_menu AS m
LEFT JOIN q21e9_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.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM q21e9_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM q21e9_categories as c
LEFT JOIN q21e9_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 q21e9_categories AS cat JOIN q21e9_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=226
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.lft
SELECT alias, catid
FROM q21e9_content
WHERE id = 226
SELECT *
FROM q21e9_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM q21e9_template_styles as s
LEFT JOIN q21e9_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 = 1
SELECT a.rules
FROM q21e9_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_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.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM q21e9_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
FROM q21e9_content AS a
LEFT JOIN q21e9_categories AS c
on c.id = a.catid
LEFT JOIN q21e9_users AS u
on u.id = a.created_by
LEFT JOIN q21e9_categories as parent
ON parent.id = c.parent_id
LEFT JOIN q21e9_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM q21e9_categories AS cat JOIN q21e9_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 226
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 11:18:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 11:18:25')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM q21e9_categories as c
LEFT JOIN q21e9_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 q21e9_categories AS cat JOIN q21e9_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.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM q21e9_extensions
WHERE `type` = 'component'
AND `element` = 'com_phocagallery'
UPDATE q21e9_content
SET hits = hits + 1
WHERE id = 226
SELECT *
FROM q21e9_template_styles
WHERE template = 'shape5_vertex';
SELECT *
FROM q21e9_menu
WHERE template_style_id IN (7)
AND alias = 'bacheca'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM q21e9_modules AS m
LEFT JOIN q21e9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN q21e9_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 <= '2021-01-16 11:18:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-16 11:18:25')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 313 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT menutype
FROM q21e9_menu
WHERE language = 'it-IT'
AND home = 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM q21e9_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
SELECT menutype
FROM q21e9_menu
WHERE language = 'it-IT'
AND home = 1
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 q21e9_menu AS m
LEFT JOIN q21e9_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.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.1')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.3')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.4')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.5')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.6')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.7')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.8')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.9')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.10')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.11')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.12')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.13')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.14')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.15')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar.extcalendar.16')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM q21e9_extensions
WHERE `type` = 'component'
AND `element` = 'com_dpcalendar'
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `q21e9_dpcalendar_caldav_calendars` c
LEFT
OUTER JOIN q21e9_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from q21e9_dpcalendar_caldav_principals memberp
inner join q21e9_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join q21e9_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `q21e9_dpcalendar_caldav_calendars` c
LEFT
OUTER JOIN q21e9_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from q21e9_dpcalendar_caldav_principals memberp
inner join q21e9_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join q21e9_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 0, 20
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,c.title AS category_title,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `q21e9_dpcalendar_events` AS a
LEFT JOIN q21e9_categories AS c
ON c.id = a.catid
LEFT JOIN q21e9_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN q21e9_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN q21e9_users AS ua
ON ua.id = a.created_by
LEFT JOIN q21e9_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1)
AND a.original_id > -1
AND a.catid IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
AND c.access IN (1,1)
AND a.state = 1
AND a.state != -2
AND (a.start_date >= '2021-01-16 11:15:00')
AND a.language in ('it-IT','*')
GROUP BY a.id
ORDER BY a.start_date asc
SELECT a.*,c.title AS category_title,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `q21e9_dpcalendar_events` AS a
LEFT JOIN q21e9_categories AS c
ON c.id = a.catid
LEFT JOIN q21e9_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN q21e9_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN q21e9_users AS ua
ON ua.id = a.created_by
LEFT JOIN q21e9_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1)
AND a.original_id > -1
AND a.catid IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
AND c.access IN (1,1)
AND a.state = 1
AND a.state != -2
AND (a.start_date >= '2021-01-16 11:15:00')
AND a.language in ('it-IT','*')
GROUP BY a.id
ORDER BY a.start_date asc
LIMIT 0, 5
SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_dpcalendar')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT c.id AS id, a.name AS asset_name
FROM q21e9_categories AS c
INNER JOIN q21e9_assets AS a
ON c.asset_id = a.id
WHERE c.extension = 'com_dpcalendar'
AND c.published = 1
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `q21e9_dpcalendar_caldav_calendars` c
LEFT
OUTER JOIN q21e9_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from q21e9_dpcalendar_caldav_principals memberp
inner join q21e9_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join q21e9_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `q21e9_dpcalendar_caldav_calendars` c
LEFT
OUTER JOIN q21e9_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from q21e9_dpcalendar_caldav_principals memberp
inner join q21e9_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join q21e9_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 0, 20
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
WHERE a.state = 1
AND a.access IN (1,1)
AND a.plugin = 'google'
ORDER BY a.ordering
select custom_script
from q21e9_jumi
where id = 8
SELECT extension_id AS id, element AS "option", params, enabled
FROM q21e9_extensions
WHERE `type` = 'component'
AND `element` = 'com_weblinks'
SELECT a.*, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `q21e9_weblinks` AS a
LEFT JOIN q21e9_categories AS c
ON c.id = a.catid
LEFT JOIN q21e9_users AS ua
ON ua.id = a.created_by
LEFT JOIN q21e9_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1)
AND a.catid = 6
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 11:18:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 11:18:25')
ORDER BY ordering asc
SELECT a.*, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `q21e9_weblinks` AS a
LEFT JOIN q21e9_categories AS c
ON c.id = a.catid
LEFT JOIN q21e9_users AS ua
ON ua.id = a.created_by
LEFT JOIN q21e9_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1)
AND a.catid = 6
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 11:18:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 11:18:25')
ORDER BY ordering asc
LIMIT 0, 5
select custom_script
from q21e9_jumi
where id = 7
SELECT id
FROM q21e9_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published = 1
AND access IN (1,1)
AND `language` IN ( 'it-IT', '*', '' )
UPDATE `q21e9_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610795904;s:18:\"session.timer.last\";i:1610795904;s:17:\"session.timer.now\";i:1610795904;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}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:25:\"autoreadmoreDefaultParams\";a:19:{s:9:\"limittype\";s:1:\"0\";s:10:\"leadingMax\";s:3:\"750\";s:8:\"introMax\";s:3:\"500\";s:25:\"Ignore_Existing_Read_More\";s:1:\"0\";s:16:\"Strip_Formatting\";s:1:\"0\";s:11:\"wrap_output\";s:1:\"0\";s:20:\"wrap_output_template\";s:40:\"<div class=\"autoreadmore\">%OUTPUT%</div>\";s:18:\"Enabled_Front_Page\";s:1:\"1\";s:17:\"add_trimming_dots\";s:1:\"0\";s:13:\"trimming_dots\";s:3:\"...\";s:17:\"categories_switch\";s:1:\"0\";s:10:\"categories\";s:0:\"\";s:15:\"articles_switch\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";s:10:\"Thumbnails\";s:1:\"0\";s:16:\"Thumbnails_Class\";s:0:\"\";s:22:\"Strip_Image_Formatting\";s:1:\"0\";s:18:\"Force_Image_Handle\";s:1:\"0\";s:7:\"csscode\";s:25:\".margin-h-8 {margin:8px;}\";}}'
, `time` = '1610795917'
WHERE `session_id` = 'er544vks66e6mtgcp3c18k7qq2'
98 × SELECT a.*,ag.title AS access_level,l.title AS language_title
FROM `q21e9_dpcalendar_extcalendars` AS a
LEFT JOIN q21e9_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN `q21e9_languages` AS l
ON l.lang_code = a.language
18 × SELECT b.rules
FROM q21e9_assets AS a
LEFT JOIN q21e9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM q21e9_extensions
4 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `q21e9_dpcalendar_caldav_calendars` c
LEFT
OUTER JOIN q21e9_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from q21e9_dpcalendar_caldav_principals memberp
inner join q21e9_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join q21e9_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
2 × SELECT menutype
FROM q21e9_menu
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM q21e9_categories as c
LEFT JOIN q21e9_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 q21e9_categories AS cat JOIN q21e9_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × 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 q21e9_menu AS m
LEFT JOIN q21e9_extensions AS e
ON m.component_id = e.extension_id
2 × SELECT a.*, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `q21e9_weblinks` AS a
LEFT JOIN q21e9_categories AS c
ON c.id = a.catid
LEFT JOIN q21e9_users AS ua
ON ua.id = a.created_by
LEFT JOIN q21e9_users AS uam
ON uam.id = a.modified_by
2 × select custom_script
from q21e9_jumi
2 × SELECT a.*,c.title AS category_title,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `q21e9_dpcalendar_events` AS a
LEFT JOIN q21e9_categories AS c
ON c.id = a.catid
LEFT JOIN q21e9_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN q21e9_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN q21e9_users AS ua
ON ua.id = a.created_by
LEFT JOIN q21e9_users AS uam
ON uam.id = a.modified_by
1 × SELECT *
FROM q21e9_menu
1 × SELECT id
FROM q21e9_menu
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM q21e9_modules AS m
LEFT JOIN q21e9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN q21e9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT c.id AS id, a.name AS asset_name
FROM q21e9_categories AS c
INNER JOIN q21e9_assets AS a
ON c.asset_id = a.id
1 × SELECT *
FROM q21e9_template_styles
1 × SELECT a.rules
FROM q21e9_assets AS a
1 × SELECT folder AS type, element AS name, params
FROM q21e9_extensions
1 × SELECT id, rules
FROM `q21e9_viewlevels
1 × SELECT b.id
FROM q21e9_usergroups AS a
LEFT JOIN q21e9_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `q21e9_session`
1 × select id, title, alias
from q21e9_jumi
1 × SELECT alias, catid
FROM q21e9_content
1 × SELECT `data`
FROM `q21e9_session`
1 × SELECT id, home, template, s.params
FROM q21e9_template_styles as s
LEFT JOIN q21e9_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM q21e9_languages
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM q21e9_contact_details AS contact
1 × UPDATE `q21e9_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610795904;s:18:\"session.timer.last\";i:1610795904;s:17:\"session.timer.now\";i:1610795904;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}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:25:\"autoreadmoreDefaultParams\";a:19:{s:9:\"limittype\";s:1:\"0\";s:10:\"leadingMax\";s:3:\"750\";s:8:\"introMax\";s:3:\"500\";s:25:\"Ignore_Existing_Read_More\";s:1:\"0\";s:16:\"Strip_Formatting\";s:1:\"0\";s:11:\"wrap_output\";s:1:\"0\";s:20:\"wrap_output_template\";s:40:\"<div class=\"autoreadmore\">%OUTPUT%</div>\";s:18:\"Enabled_Front_Page\";s:1:\"1\";s:17:\"add_trimming_dots\";s:1:\"0\";s:13:\"trimming_dots\";s:3:\"...\";s:17:\"categories_switch\";s:1:\"0\";s:10:\"categories\";s:0:\"\";s:15:\"articles_switch\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";s:10:\"Thumbnails\";s:1:\"0\";s:16:\"Thumbnails_Class\";s:0:\"\";s:22:\"Strip_Image_Formatting\";s:1:\"0\";s:18:\"Force_Image_Handle\";s:1:\"0\";s:7:\"csscode\";s:25:\".margin-h-8 {margin:8px;}\";}}' , `time` = '1610795917'
1 × UPDATE q21e9_content
SET hits = hits + 1
1 × INSERT INTO `q21e9_session` (`session_id`, `client_id`, `time`)
VALUES ('er544vks66e6mtgcp3c18k7qq2', 0, '1610795904'