I have a list of events in table A.
In table A I have a location ID.
Table B is a list of locations which the location ID in table A joins too. Each row has a 'timezone' saved in it. Table A as also has a datetime column which is local to this this timzone.
https://www.php.net/manual/en/timezones.php
I want to order records from table A in time order based on the timezone
order by eventDateTime
Doesn't work as no timezone is consdered