select at.*,vs.*,ecd.event_dates,ecd.event_object from CollectionVersions as vs , CollectionSearchIndexAttributes as at, EasyCalendarDates as ecd where at.cID=vs.cID && vs.cID="307" && ecd.event_dates != "" && ecd.cID=vs.cID && ecd.cID="307" order by vs.cvID desc limit 1Array ( [0] => stdClass Object ( [id] => 307 [start] => 1717518600 [end] => 1717521300 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jun 4 2024 10:30 am to 11:15 am ) [1] => stdClass Object ( [id] => 307 [start] => 1718123400 [end] => 1718126100 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jun 11 2024 10:30 am to 11:15 am ) [2] => stdClass Object ( [id] => 307 [start] => 1718728200 [end] => 1718730900 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jun 18 2024 10:30 am to 11:15 am ) [3] => stdClass Object ( [id] => 307 [start] => 1719333000 [end] => 1719335700 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jun 25 2024 10:30 am to 11:15 am ) [4] => stdClass Object ( [id] => 307 [start] => 1719937800 [end] => 1719940500 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jul 2 2024 10:30 am to 11:15 am ) [5] => stdClass Object ( [id] => 307 [start] => 1720542600 [end] => 1720545300 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jul 9 2024 10:30 am to 11:15 am ) [6] => stdClass Object ( [id] => 307 [start] => 1721147400 [end] => 1721150100 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jul 16 2024 10:30 am to 11:15 am ) [7] => stdClass Object ( [id] => 307 [start] => 1721752200 [end] => 1721754900 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jul 23 2024 10:30 am to 11:15 am ) [8] => stdClass Object ( [id] => 307 [start] => 1722357000 [end] => 1722359700 [timezone] => [hasstarttime] => 1 [hasendtime] => 1 [repeats] => [repeat_number] => 0 [isrepeat] => [original] => jul 30 2024 10:30 am to 11:15 am ) ) select at.*,vs.*,ecd.event_dates,ecd.event_object from CollectionVersions as vs , CollectionSearchIndexAttributes as at, EasyCalendarDates as ecd where at.cID=vs.cID && vs.cID="356" && ecd.event_dates != "" && ecd.cID=vs.cID && ecd.cID="356" order by vs.cvID desc limit 1Array ( [0] => stdClass Object ( [id] => 356 [start] => 1710372600 [end] => [timezone] => [hasstarttime] => 1 [hasendtime] => [repeats] => [repeat_number] => 0 [isrepeat] => [original] => mar 13 2024 5:30 pm ) ) select at.*,vs.*,ecd.event_dates,ecd.event_object from CollectionVersions as vs , CollectionSearchIndexAttributes as at, EasyCalendarDates as ecd where at.cID=vs.cID && vs.cID="422" && ecd.event_dates != "" && ecd.cID=vs.cID && ecd.cID="422" order by vs.cvID desc limit 1Array ( [0] => stdClass Object ( [id] => 422 [start] => 1712556000 [end] => 1713074340 [timezone] => [hasstarttime] => [hasendtime] => [repeats] => [repeat_number] => 0 [isrepeat] => [original] => apr 8 2024 to apr 13 2024 ) )