{ "__default": { "session": { "counter": 1, "timer": { "start": 1713450920, "last": 1713450920, "now": 1713450920 } }, "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=40", "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'3736663436393263306437656234613331356664353130366330346363626233'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3736663436393263306437656234613331356664353130366330346363626233' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3736663436393263306437656234613331356664353130366330346363626233', 1, 1713450920, 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` = '18.188.175.182'
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=40') OR ('events/cherokee?start=40' 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=40' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/events/cherokee?start=40' 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=40' 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=40' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/events/cherokee?start=40' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/events/cherokee?start=40' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=40' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=40' 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=40' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/events/cherokee?start=40' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=40' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/events/cherokee?start=40' 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\":\"5ba8af599063981be5832566aa01b00e\"}' 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 10:35:20') AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-04-18 10:35:20')
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 10:35:20') AS date_diff,DATEDIFF(tbl.event_date, '2024-04-18 10:35:20') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-04-18 10:35:20') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-04-18 10:35:20') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-04-18 10:35:20') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-04-18 10:35:20') 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 10:35:20') AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-04-18 10:35:20') GROUP BY tbl.id ORDER BY tbl.event_date ASC LIMIT 40, 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 (9949,9863,9873,9484,9309,9767,9805,9950,9914,9864) 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-18 14:35:20',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 = 9949
SELECT id FROM trsst_eb_urls WHERE md5_key = '6d79132778caf42f1d4dcb83bc65e687'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9863
SELECT id FROM trsst_eb_urls WHERE md5_key = '3a2ba157fcff4bae38656a8dc4b1c64f'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9873
SELECT id FROM trsst_eb_urls WHERE md5_key = 'ef19b054810ef8a7a325bf4172004013'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9484
SELECT id FROM trsst_eb_urls WHERE md5_key = '3de83b8b09de22c9b074fc1c2100a09d'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9309
SELECT id FROM trsst_eb_urls WHERE md5_key = '27485b45667bcd5e99d909d013bd2611'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9767
SELECT id FROM trsst_eb_urls WHERE md5_key = '7248aea8cb08c40203593d19eb9c6fc0'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9805
SELECT id FROM trsst_eb_urls WHERE md5_key = '4031b95f5bd6f2f8a5d1e80847fc8f11'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9950
SELECT id FROM trsst_eb_urls WHERE md5_key = 'ef6a5321f3c45c4ac68f93b9038a6539'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9914
SELECT id FROM trsst_eb_urls WHERE md5_key = '51c63ea24682f3e959fd0d2497e9ab04'
SELECT `alias` AS `alias` FROM trsst_eb_events WHERE id = 9864
SELECT id FROM trsst_eb_urls WHERE md5_key = 'f2e4a61fbc64eb190de22b6ceb223790'
SELECT id FROM trsst_eb_urls WHERE md5_key = '855b100045bf71224e316c66f4ce55d6'
SELECT id FROM trsst_eb_urls WHERE md5_key = '6a55f66fd32160ae1688cb9f24fc7980'
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 = '405397dba19e1b638af07481df907771'
SELECT id FROM trsst_eb_urls WHERE md5_key = 'b63e0796acfe17379d15dfc16d4533e7'
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=40'
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-18 14:35:20') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 14:35:20') 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=40' 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-18 10:35:20') AS date_diff,DATEDIFF(tbl.event_date, '2024-04-18 10:35:20') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-04-18 10:35:20') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-04-18 10:35:20') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-04-18 10:35:20') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-04-18 10:35:20') 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'3736663436393263306437656234613331356664353130366330346363626233', 1, 1713450920, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"5ba8af599063981be5832566aa01b00e\"}'
1 × SHOW FULL COLUMNS FROM `trsst_eb_events
to your business!