{ "__default": { "session": { "counter": 1, "timer": { "start": 1713496692, "last": 1713496692, "now": 1713496692 } }, "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", "com_contactenhanced": { "isekeywords": { "referer": "http:\/\/www.familylifepublications.com\/events\/cherokee", "searchEngine": { "engine": "", "searchPhrase": false }, "all_keywords": [ "" ], "filter_keywords": [ "" ], "params": { "load-instructions": "0", "enable-highlight": "0", "integrate-ce": "1", "exclude": "a,e,i,o,u,an,the,for,is,in,are,was,and,from,of,on,with,this,that,or,these,those" }, "queryString": "", "excludes": [ "a", "e", "i", "o", "u", "an", "the", "for", "is", "in", "are", "was", "and", "from", "of", "on", "with", "this", "that", "or", "these", "those", "us", "be", "have", "not", "he", "as", "do", "you", "he", "she", "we", "me", "will", "my", "a", "e", "i", "o", "u", "an", "the", "for", "is", "in", "are", "was", "and", "from", "of", "on", "with", "this", "that", "or", "these", "those", " ", ".", ",", ";", "!", "?", "|", "\\", "\"", "\/", "<", ">", "^", "~", "`", "[", "]", "{", "}", "=", "+", "-", "_", "(", ")", "@", "#", "$", "%", "&", "*" ] } } } }
SELECT `data` FROM `trsst_session` WHERE `session_id` = X'6666333964396462343430383634383063373733663837316261353465643162'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'6666333964396462343430383634383063373733663837316261353465643162' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6666333964396462343430383634383063373733663837316261353465643162', 1, 1713496692, 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.136.154.103'
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/cherokee') OR (`dest` = 'events/cherokee') OR ('events/cherokee' 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/cherokee' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/events/cherokee' 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/cherokee' 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/cherokee' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/events/cherokee' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/events/cherokee' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee' 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/cherokee' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/events/cherokee' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url=0) )
SELECT * FROM `trsst_admintools_wafblacklists` WHERE `verb` IN('','GET') AND `option` IN('','com_eventbooking') AND `view` IN('','category') AND `task` IN('','category.') 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\":\"cf609b5c364d10f145af0d98797b5cd3\"}' 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
SHOW FULL COLUMNS FROM `trsst_eb_events`
SELECT COUNT(*) FROM trsst_eb_events AS tbl WHERE (DATE(tbl.event_date) >= '2024-04-18' OR DATE(tbl.cut_off_date) >= '2024-04-18') AND tbl.published > 0 AND tbl.hidden = 0 AND tbl.access IN (1,1,5) AND tbl.id IN (SELECT event_id FROM trsst_eb_event_categories WHERE category_id IN (1)) AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2024-04-18 23:18:12') AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-04-18 23:18:12')
SELECT tbl.id,tbl.parent_id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.tax_rate,tbl.event_capacity,tbl.private_booking_count,tbl.waiting_list_capacity,tbl.created_by,tbl.created_date,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.event_detail_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.image_alt,tbl.language,tbl.alias,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2024-04-18 23:18:12') AS date_diff,DATEDIFF(tbl.event_date, '2024-04-18 23:18:12') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-04-18 23:18:12') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-04-18 23:18:12') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-04-18 23:18:12') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-04-18 23:18:12') AS cut_off_minutes,`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,(IFNULL(SUM(b.number_registrants), 0) + tbl.private_booking_count) AS total_registrants FROM trsst_eb_events AS tbl LEFT JOIN trsst_eb_registrants AS b ON (tbl.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 tbl.location_id = c.id LEFT JOIN trsst_eb_categories AS cat ON tbl.main_category_id = cat.id WHERE (DATE(tbl.event_date) >= '2024-04-18' OR DATE(tbl.cut_off_date) >= '2024-04-18') AND tbl.published > 0 AND tbl.hidden = 0 AND tbl.access IN (1,1,5) AND tbl.id IN (SELECT event_id FROM trsst_eb_event_categories WHERE category_id IN (1)) AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2024-04-18 23:18:12') AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-04-18 23:18:12') GROUP BY tbl.id ORDER BY tbl.event_date ASC LIMIT 10
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 (9305,9761,9799,8707,9868,9454,8348,8758,9482,9306) 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 03:18:12',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')
SELECT `message_key`,`message` FROM trsst_eb_messages
SELECT id, parent, alias FROM trsst_eb_categories
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9305
SELECT id FROM trsst_eb_urls WHERE md5_key = '2d5051c00986d3662c89b30ca6aeb9da'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9761
SELECT id FROM trsst_eb_urls WHERE md5_key = 'fd49b3ba6187e4ae139231a7c4f3008e'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9799
SELECT id FROM trsst_eb_urls WHERE md5_key = '3968e67d6b0d4d1c854115364fb01f34'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 8707
SELECT id FROM trsst_eb_urls WHERE md5_key = 'bea99bff9ddd9848c27aa23cdac5e2bd'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9868
SELECT id FROM trsst_eb_urls WHERE md5_key = '2635e329f62c0e0658c07ac58d628315'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9454
SELECT id FROM trsst_eb_urls WHERE md5_key = '63da258599d7937444a3fa650fb08acd'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 8348
SELECT id FROM trsst_eb_urls WHERE md5_key = '7d7f226cc9f1322816e658bee3df8b79'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 8758
SELECT id FROM trsst_eb_urls WHERE md5_key = '0c66f80786ff399157032426605c2cf8'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9482
SELECT id FROM trsst_eb_urls WHERE md5_key = '3f7e143ac2b30d0535141b9578ea3e19'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9306
SELECT id FROM trsst_eb_urls WHERE md5_key = 'c1821acbf48e68d607ac72733a645c8e'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'd17896fc5db40d864a25f31f7e4d8535'
SELECT id FROM trsst_eb_urls WHERE md5_key = '4886c2cf1284e5d32fa6b97e47194343'
SELECT id FROM trsst_eb_urls WHERE md5_key = '855b100045bf71224e316c66f4ce55d6'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'eb16591edef95ecba44f4f098b71da38'
SELECT id FROM trsst_eb_urls WHERE md5_key = '6a55f66fd32160ae1688cb9f24fc7980'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'a5a9434788b2242d25fbc13825985685'
SELECT id FROM trsst_eb_urls WHERE md5_key = '1a74fa9c548b117904e8b134437edc52'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'a899660844a4f1ded53e41106e1529d7'
select `menutype` from trsst_menu where 1=1 and link like '%option=com_eventbooking%' and link like '%view=category%' and link like '%layout=timeline%' and `published`=1
select `params` from trsst_menu where id=830
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/events/cherokee'
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 03:18:12') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 03:18:12') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 830 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/cherokee' 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 = '0' AND i.include_in = 1 ) OR ( i.published =1 AND i.include_in = 0 )
28 × select `params` from trsst_ijseo_confi
22 × select max(`checkdate`) from trsst_ijseo_keys limit 0,
22 × select * from trsst_ijseo_keys as a
18 × SELECT id FROM trsst_eb_urls
10 × SELECT `alias` AS `alias` FROM trsst_eb_events
2 × select * from trsst_ijseo_meta_pages
2 × select `menutype` from trsst_menu
2 × select `params` from trsst_menu
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 `value` FROM `trsst_admintools_storage`
2 × select c.`canonical` from trsst_ijseo_canonical c
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions`
1 × SELECT `title` FROM `trsst_finder_taxonomy`
1 × SELECT `name`,`element` FROM `trsst_extensions`
1 × SELECT * FROM trsst_easyblog_configs
1 × SELECT enabled FROM `trsst_extensions`
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 id, parent, alias FROM trsst_eb_categorie
1 × SELECT `message_key`,`message` FROM trsst_eb_message
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets`
1 × SELECT params FROM `trsst_ijseo_config
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 `data` FROM `trsst_session`
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 * FROM trsst_rsform_confi
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 `source`,`keepurlparams` FROM `trsst_admintools_redirects`
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 `session_id` FROM `trsst_session`
1 × SELECT * FROM ( SELECT * FROM trsst_redj_redirects
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 COUNT(*) FROM trsst_eb_events AS tbl
1 × SELECT tbl.id,tbl.parent_id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.tax_rate,tbl.event_capacity,tbl.private_booking_count,tbl.waiting_list_capacity,tbl.created_by,tbl.created_date,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.event_detail_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.image_alt,tbl.language,tbl.alias,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2024-04-18 23:18:12') AS date_diff,DATEDIFF(tbl.event_date, '2024-04-18 23:18:12') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-04-18 23:18:12') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-04-18 23:18:12') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-04-18 23:18:12') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-04-18 23:18:12') AS cut_off_minutes,`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,(IFNULL(SUM(b.number_registrants), 0) + tbl.private_booking_count) AS total_registrants FROM trsst_eb_events AS tbl LEFT JOIN trsst_eb_registrants AS b ON (tbl.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 tbl.location_id = c.id LEFT JOIN trsst_eb_categories AS cat ON tbl.main_category_id = cat.id
1 × SELECT * FROM trsst_eb_taxes
1 × SELECT * FROM trsst_eb_location
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6666333964396462343430383634383063373733663837316261353465643162', 1, 1713496692, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"cf609b5c364d10f145af0d98797b5cd3\"}'
1 × SHOW FULL COLUMNS FROM `trsst_eb_events