SELECT `events`.*, `kalshi_series`.`tags_json`
FROM `events`
LEFT JOIN `kalshi_series` ON `kalshi_series`.`ticker` = `events`.`series_ticker`
WHERE `events`.`category` = 'Science and Technology'
ORDER BY `close_time` ASC
LIMIT 24
--------------------------------
0
--------------------------------
Array
(
[0] => Array
(
[category] => Companies
[label] => Companies
[slug] => companies
)
[1] => Array
(
[category] => Crypto
[label] => Crypto
[slug] => crypto
)
[2] => Array
(
[category] => Economics
[label] => Economics
[slug] => economics
)
[3] => Array
(
[category] => Elections
[label] => Elections
[slug] => elections
)
[4] => Array
(
[category] => Financials
[label] => Financials
[slug] => financials
)
[5] => Array
(
[category] => Politics
[label] => Politics
[slug] => politics
)
[6] => Array
(
[category] => Science and Technology
[label] => Science and Technology
[slug] => science-and-technology
)
[7] => Array
(
[category] => Sports
[label] => Sports
[slug] => sports
)
)
--------------------------------
Array
(
)
--------------------------------
Science and Technology
Science and Technology