{ "__default": { "session": { "counter": 1, "timer": { "start": 1713507202, "last": 1713507202, "now": 1713507202 }, "token": "LrhfdVJB6N6z7kzmPCatqVugY8mYSV0s" }, "registry": { "current_theme": null, "current_direction": "ltr", "current_key_sufix": "__ltr" }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "eb_device_type": "desktop" } }
SELECT `data` FROM `trsst_session` WHERE `session_id` = X'3564316164396236393063386432323532643837353237316433643964346136'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3564316164396236393063386432323532643837353237316433643964346136' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3564316164396236393063386432323532643837353237316433643964346136', 1, 1713507202, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `trsst_viewlevels`
SELECT b.id FROM trsst_usergroups AS a LEFT JOIN trsst_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 14
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
SELECT `value` FROM `trsst_admintools_storage` WHERE `key` = 'cparams'
SELECT * FROM `trsst_admintools_wafexceptions` WHERE NOT(`option` LIKE 'com_%')
SELECT `template` FROM `trsst_template_styles` WHERE `client_id` = 0 AND `home` = 1
SELECT * FROM `trsst_admintools_ipautoban` WHERE `ip` = '3.142.135.86'
SELECT `ip` FROM `trsst_admintools_ipblock`
SELECT * FROM `trsst_admintools_storage` WHERE `key` LIKE 'timestamp_%'
SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects` WHERE ((`dest` = 'events/calendar/visit-with-santa-12-17-2022') OR (`dest` = 'events/calendar/visit-with-santa-12-17-2022') OR ('events/calendar/visit-with-santa-12-17-2022' LIKE `dest`)) AND `published` = '1' ORDER BY `ordering` DESC LIMIT 1
SELECT * FROM trsst_rsform_config
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 trsst_menu AS m LEFT JOIN trsst_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 * FROM ( SELECT * FROM trsst_redj_redirects WHERE ( ( (CAST('/events/calendar/visit-with-santa-12-17-2022' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/events/calendar/visit-with-santa-12-17-2022' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( (CAST('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( (CAST('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/events/calendar/visit-with-santa-12-17-2022' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/events/calendar/visit-with-santa-12-17-2022' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only=0) ) ) AND published=1 ORDER BY ordering ) AS A WHERE A.skip='' OR ( (CAST('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url=0) )
SELECT `query` FROM trsst_eb_urls WHERE md5_key = '69a9a93c61104cd0741b542b457043a9'
SELECT * FROM `trsst_admintools_wafblacklists` WHERE `verb` IN('','GET') AND `option` IN('','com_eventbooking') AND `view` IN('','event') AND `task` IN('','event.') AND `enabled` = '1' GROUP BY `query` ORDER BY `query` ASC
SELECT id, home, template, s.params FROM trsst_template_styles as s LEFT JOIN trsst_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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"1e1abeebe529fe00a14afebd84c67af6\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM trsst_languages WHERE published=1 ORDER BY ordering ASC
SELECT `config_key`,`config_value` FROM trsst_eb_configs
SELECT * FROM trsst_eb_themes WHERE published = 1
SELECT a.*,DATEDIFF(event_date, '2024-04-19 02:13:22') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2024-04-19 02:13:22') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-04-19 02:13:22') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-04-19 02:13:22') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-04-19 02:13:22') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-04-19 02:13:22', early_bird_discount_date) AS date_diff,(IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address, c.lat, c.long,cat.tax_rate AS cat_tax_rate FROM trsst_eb_events AS a LEFT JOIN trsst_eb_registrants AS b ON (a.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.published = 0 AND b.payment_method LIKE "os_offline%"))) LEFT JOIN trsst_eb_locations AS c ON a.location_id = c.id LEFT JOIN trsst_eb_categories AS cat ON a.main_category_id = cat.id WHERE a.id = 5951 GROUP BY a.id
SELECT a.*, (IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,DATEDIFF(event_date, '2024-04-19 02:13:22') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-04-19 02:13:22') AS event_start_minutes,DATEDIFF('2024-04-19 02:13:22', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-04-19 02:13:22') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-04-19 02:13:22') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-04-19 02:13:22', early_bird_discount_date) AS date_diff,l.lat, l.long, l.address AS location_address,`l`.`name` AS `location_name`,c.tax_rate AS cat_tax_rate FROM trsst_eb_events AS a LEFT JOIN trsst_eb_categories AS c ON a.main_category_id = c.id LEFT JOIN trsst_eb_locations AS l ON a.location_id = l.id LEFT JOIN trsst_eb_registrants AS b ON (a.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.published = 0 AND b.payment_method LIKE "os_offline%"))) WHERE a.id = 5951 GROUP BY a.id
SELECT * FROM trsst_eb_taxes WHERE published = 1 LIMIT 2
SELECT * FROM trsst_eb_locations
SELECT a.*, b.event_id FROM trsst_eb_categories AS a INNER JOIN trsst_eb_event_categories AS b ON a.id = b.category_id WHERE b.event_id IN (5951) ORDER BY b.id
SELECT enabled FROM `trsst_extensions` WHERE `element` = 'com_sppagebuilder' AND `type` = 'component'
select `params` from trsst_ijseo_config
select max(`checkdate`) from trsst_ijseo_keys limit 0,1
select * from trsst_ijseo_keys as a where 1<=(SELECT DATEDIFF('2024-04-19 06:13:22',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' order by checkdate asc limit 0,10
SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_cjlib','com_communitysurveys','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_dropfiles','com_droppics','com_easyblog','com_eventbooking','com_fields','com_finder','com_ijoomla_seo','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_monthlyarchive','com_mymaplocations','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_redj','com_rsform','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_templates','com_testimonial_pro','com_users','com_vdata','com_watchfulli','com_weblinks','com_wrapper','com_zoo')
UPDATE trsst_eb_events SET hits = hits + 1 WHERE id = 5951
SELECT * FROM trsst_eb_event_group_prices WHERE event_id = 5951 ORDER BY id
SELECT id, parent, alias FROM trsst_eb_categories
SELECT id FROM trsst_eb_urls WHERE md5_key = '69a9a93c61104cd0741b542b457043a9'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'b9321a69180eb40e33d4f4f7bb8db3bf'
select `menutype` from trsst_menu where 1=1 and link like '%option=com_eventbooking%' and link like '%view=event%' and link like '%id=5951%' and `published`=1
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM trsst_modules AS m LEFT JOIN trsst_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN trsst_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 <= '2024-04-19 06:13:22') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 06:13:22') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 829 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT * FROM trsst_easyblog_configs WHERE `name` = 'config'
SELECT `name`,`element` FROM `trsst_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
SELECT `title` FROM `trsst_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,1,5)
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM trsst_modules AS m WHERE m.id = 207 AND m.published = 1 AND m.access IN (1,1,5)
select c.`canonical` from trsst_ijseo_canonical c where c.`id` = (select `parent_id` from trsst_ijseo_canonical where `link`='https://www.familylifemagazines.com/events/calendar/visit-with-santa-12-17-2022' and `parent_id` <> 0 limit 0,1) and c.`state`=1
SELECT `value` FROM `trsst_admintools_storage` WHERE `key` = 'criticalfiles'
SELECT manifest_cache FROM trsst_extensions WHERE type='component' AND element='com_baforms'
SELECT `key` FROM trsst_baforms_api WHERE service = 'balbooa_activation'
SELECT params FROM `trsst_ijseo_config`
SELECT i.* FROM trsst_ijseo_ilinks AS i LEFT JOIN trsst_ijseo_ilinks_articles AS ia ON i.id = ia.ilink_id WHERE ( i.published =1 AND ia.article_id = '5951' AND i.include_in = 1 ) OR ( i.published =1 AND i.include_in = 0 )
8 × select `params` from trsst_ijseo_confi
4 × select max(`checkdate`) from trsst_ijseo_keys limit 0,
4 × select * from trsst_ijseo_keys as a
2 × SELECT i.* FROM trsst_ijseo_ilinks AS i LEFT JOIN trsst_ijseo_ilinks_articles AS ia ON i.id = ia.ilink_id
2 × select `menutype` from trsst_menu
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions`
2 × SELECT `value` FROM `trsst_admintools_storage`
2 × select c.`canonical` from trsst_ijseo_canonical c
2 × SELECT id FROM trsst_eb_urls
2 × select * from trsst_ijseo_meta_pages
1 × SELECT enabled FROM `trsst_extensions`
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets`
1 × SELECT * FROM trsst_eb_event_group_prices
1 × SELECT id, parent, alias FROM trsst_eb_categorie
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM trsst_modules AS m LEFT JOIN trsst_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN trsst_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT * FROM trsst_eb_location
1 × SELECT * FROM trsst_easyblog_configs
1 × SELECT `name`,`element` FROM `trsst_extensions`
1 × SELECT `title` FROM `trsst_finder_taxonomy`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM trsst_modules AS m
1 × SELECT manifest_cache FROM trsst_extensions
1 × SELECT `key` FROM trsst_baforms_api
1 × SELECT params FROM `trsst_ijseo_config
1 × SELECT a.*, b.event_id FROM trsst_eb_categories AS a INNER JOIN trsst_eb_event_categories AS b ON a.id = b.category_id
1 × SELECT `data` FROM `trsst_session`
1 × SELECT * FROM trsst_eb_taxes
1 × SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects`
1 × SELECT id, rules FROM `trsst_viewlevels
1 × SELECT b.id FROM trsst_usergroups AS a LEFT JOIN trsst_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions
1 × SELECT * FROM `trsst_admintools_wafexceptions`
1 × SELECT `template` FROM `trsst_template_styles`
1 × SELECT * FROM `trsst_admintools_ipautoban`
1 × SELECT `ip` FROM `trsst_admintools_ipblock
1 × SELECT * FROM `trsst_admintools_storage`
1 × SELECT * FROM trsst_rsform_confi
1 × SELECT `session_id` FROM `trsst_session`
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 trsst_menu AS m LEFT JOIN trsst_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM ( SELECT * FROM trsst_redj_redirects
1 × SELECT `query` FROM trsst_eb_urls
1 × SELECT * FROM `trsst_admintools_wafblacklists`
1 × SELECT id, home, template, s.params FROM trsst_template_styles as s LEFT JOIN trsst_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM trsst_languages
1 × SELECT `config_key`,`config_value` FROM trsst_eb_config
1 × SELECT * FROM trsst_eb_themes
1 × SELECT a.*,DATEDIFF(event_date, '2024-04-19 02:13:22') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2024-04-19 02:13:22') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-04-19 02:13:22') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-04-19 02:13:22') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-04-19 02:13:22') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-04-19 02:13:22', early_bird_discount_date) AS date_diff,(IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address, c.lat, c.long,cat.tax_rate AS cat_tax_rate FROM trsst_eb_events AS a LEFT JOIN trsst_eb_registrants AS b ON (a.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.published = 0 AND b.payment_method LIKE "os_offline%"))) LEFT JOIN trsst_eb_locations AS c ON a.location_id = c.id LEFT JOIN trsst_eb_categories AS cat ON a.main_category_id = cat.id
1 × SELECT a.*, (IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,DATEDIFF(event_date, '2024-04-19 02:13:22') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-04-19 02:13:22') AS event_start_minutes,DATEDIFF('2024-04-19 02:13:22', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-04-19 02:13:22') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-04-19 02:13:22') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-04-19 02:13:22', early_bird_discount_date) AS date_diff,l.lat, l.long, l.address AS location_address,`l`.`name` AS `location_name`,c.tax_rate AS cat_tax_rate FROM trsst_eb_events AS a LEFT JOIN trsst_eb_categories AS c ON a.main_category_id = c.id LEFT JOIN trsst_eb_locations AS l ON a.location_id = l.id LEFT JOIN trsst_eb_registrants AS b ON (a.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.published = 0 AND b.payment_method LIKE "os_offline%")))
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3564316164396236393063386432323532643837353237316433643964346136', 1, 1713507202, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"1e1abeebe529fe00a14afebd84c67af6\"}'
1 × UPDATE trsst_eb_events SET hits = hits + 1
to your business!