{ "__default": { "session": { "counter": 1, "timer": { "start": 1713500152, "last": 1713500152, "now": 1713500152 } }, "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": "https:\/\/www.familylifepublications.com\/events\/cherokee?start=250", "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'3238393161343536353766633065386166613431626634643034396134396130'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3238393161343536353766633065386166613431626634643034396134396130' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3238393161343536353766633065386166613431626634643034396134396130', 1, 1713500152, 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.144.42.196'
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?start=250') OR ('events/cherokee?start=250' 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?start=250' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/events/cherokee?start=250' 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?start=250' 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?start=250' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/events/cherokee?start=250' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/events/cherokee?start=250' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=250' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=250' 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?start=250' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/events/cherokee?start=250' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=250' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=250' 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\":\"048290d1be66c3b05d0a97a84fa5927e\"}' 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-19' OR DATE(tbl.cut_off_date) >= '2024-04-19') 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-19 00:15:52') AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-04-19 00:15:52')
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-19 00:15:52') AS date_diff,DATEDIFF(tbl.event_date, '2024-04-19 00:15:52') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-04-19 00:15:52') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-04-19 00:15:52') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-04-19 00:15:52') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-04-19 00:15:52') 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-19' OR DATE(tbl.cut_off_date) >= '2024-04-19') 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-19 00:15:52') AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-04-19 00:15:52') GROUP BY tbl.id ORDER BY tbl.event_date ASC LIMIT 250, 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 (9502,9339,8296,9115,9920,9340,8714,8795,8355,7431) 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 04:15:52',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 = 9502
SELECT id FROM trsst_eb_urls WHERE md5_key = '138376644942ea5bd8ee4354b2c99664'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9339
SELECT id FROM trsst_eb_urls WHERE md5_key = 'ab5139e848f7b7e3a2743429e0ae7650'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 8296
SELECT id FROM trsst_eb_urls WHERE md5_key = 'a7c22716d446aa61b2e4a501a7962ee8'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9115
SELECT id FROM trsst_eb_urls WHERE md5_key = 'c63a9fe8bbf47fbc7a2a1759708e3d33'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9920
SELECT id FROM trsst_eb_urls WHERE md5_key = '352e22a3d2a46e7c0d8731050b4c30de'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9340
SELECT id FROM trsst_eb_urls WHERE md5_key = '879a03be26e3b9911cde75580cfed743'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 8714
SELECT id FROM trsst_eb_urls WHERE md5_key = 'c3d1046bccf8b1a79092cf576bc8159b'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 8795
SELECT id FROM trsst_eb_urls WHERE md5_key = '38ed9061d5467799fc0e7650fab70921'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 8355
SELECT id FROM trsst_eb_urls WHERE md5_key = 'a3f95cc27f7d9c55f1509bcb3fe5b5ec'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 7431
SELECT id FROM trsst_eb_urls WHERE md5_key = '2b0de0686c9ce598b5febe878a1886fa'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'd17896fc5db40d864a25f31f7e4d8535'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'eb16591edef95ecba44f4f098b71da38'
SELECT id FROM trsst_eb_urls WHERE md5_key = '405397dba19e1b638af07481df907771'
SELECT id FROM trsst_eb_urls WHERE md5_key = '959567b06e84981fd10659aad685694b'
SELECT id FROM trsst_eb_urls WHERE md5_key = '1a74fa9c548b117904e8b134437edc52'
SELECT id FROM trsst_eb_urls WHERE md5_key = '855b100045bf71224e316c66f4ce55d6'
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?start=250'
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 04:15:52') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 04:15:52') 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?start=250' 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
16 × 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-19 00:15:52') AS date_diff,DATEDIFF(tbl.event_date, '2024-04-19 00:15:52') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-04-19 00:15:52') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-04-19 00:15:52') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-04-19 00:15:52') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-04-19 00:15:52') 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'3238393161343536353766633065386166613431626634643034396134396130', 1, 1713500152, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"048290d1be66c3b05d0a97a84fa5927e\"}'
1 × SHOW FULL COLUMNS FROM `trsst_eb_events
to your business!