...
Code Block | ||
---|---|---|
| ||
SELECT (Various Aggregations) FROM JTELStats.AcdStatisticsLogin2 AcdStatisticsLogin2 JOIN JTELWeb.AcdAgentStatus AcdAgentStatus ON AcdStatisticsLogin2.AcdAgentStatusID = AcdAgentStatus.ID WHERE ( INTERSECTS ( LINESTRING ( POINT( UNIX_TIMESTAMP( _Timeslice_Begin ), AcdStatisticsLogin2.UsersID ), POINT( UNIX_TIMESTAMP( Timeslice_End_Selects_ ), AcdStatisticsLogin2.UsersID ) ), geom2 ) ) |
...