query
RESULTSET
query
  CITY PRESENTERID SEASONID SEASONLOCATIONID SHOWLOCATIONID STATE YEAR
CACHED false
EXECUTIONTIME 0
SQL SELECT SL.ID_SEASON_LOCATION AS SEASONLOCATIONID, SL.ID_SEASON AS SEASONID, SL.ID_SHOW_LOCATION AS SHOWLOCATIONID, X.ID_ACCT_PRESENTER AS PRESENTERID, YEAR( S.YEAR ) AS YEAR, CITY.CITY, CITY.STATE FROM ACCT_PRESENTER_X_SEASON_LOCATION X JOIN SEASON_LOCATION SL ON ( SL.ID_SEASON_LOCATION = X.ID_SEASON_LOCATION AND SL.SOFTDELETE = 0 AND SL.ACTIVE = 1 ) JOIN SEASON S ON ( SL.ID_SEASON = S.ID_SEASON AND S.SOFTDELETE = 0AND S.ACTIVE = 1 ) JOIN SHOW_LOCATION CITY ON ( SL.ID_SHOW_LOCATION = CITY.ID_SHOW_LOCATION AND CITY.SOFTDELETE = 0AND CITY.ACTIVE = 1 ) WHERE X.ID_ACCT_PRESENTER = ? ORDER BY S.YEAR DESC, CITY.STATE ASC, CITY.CITY ASC
SQLPARAMETERS
array
1 70