select * from
(
select row_number()over(order by [DATE_VALIDITY],[PASSAGE_STOPPOINT_PREV]) as row
,A.[GUID_CERT] ,A.[full_data],A.[GUID_COMPANY],A.[GUID_RACE] ,A.[LINE_CODE] ,A.[DIRECT_CODE] ,A.[RACE_CODE]
,A.[DIRECTION] ,A.[DATE_VALIDITY],A.[STOPPOINT_INDEX],A.[STOPPOINT_INDEX_MAX] ,A.[STOPPOINT_CODE],A.[PASSAGE_STOPPOINT_REAL]
,A.[PASSAGE_STOPPOINT_REAL_OUT],A.[PASSAGE_STOPPOINT_PREV],A.[LON_IN],A.[LAT_IN],A.[LON_OUT],A.[LAT_OUT]
,A.[DIST_PREVSTOPPOINT_REAL],A.[DIST_PREVSTOPPOINT_PREV],A.[FLG_DOOR],A.[GUID_DEVICE],A.[ID_USER]
,A.[ID_KNDCERT],A.[ID_RACE_CERTIFICATION_STATUS],A.[ID_STOP_CERTIFICATION_STATUS],A.[PASSENGERS_UP]
,A.[PASSENGERS_DOWN] ,A.[PASSENGERS_TOTAL],A.[TURN_U_CODE],A.[TURN_M_CODE],A.[FLG_MUST_STOP]
,A.[ID_JUSTIFICATION],A.[ID_CONTEXT],A.[TYPE_SERVICE],A.[HISTORY_SERVER],A.[HISTORY_DB]
,A.[HISTORY_TABLE],A.[HISTORY_GUID],A.[LAST_USER],A.[LAST_UPDATE],A.[HASH_STOPPOINT],A.[HASH_RACE]
,A.[HASH_LINE],A.[AVG_SPEED_SECTION],A.[AVG_DELAY_RACE],A.[VAR_DELAY_RACE]
,F.[HASH_STOPPOINT] AS [F_HASH_STOPPOINT] ,F.[CODFER]AS [F_CODFER] ,F.[PROGRE]AS [F_PROGRE]
,F.[DESFE]AS [F_DESFE] ,F.[DESFE2]AS [F_DESFE2] ,F.[DESFE3]AS [F_DESFE3]
,F.[LON]AS [F_LON] ,F.[LAT] AS [F_LAT] ,F.[CTFER]AS [F_CTFER],F.[DESDSP]AS [F_DESDSP]
,F.[TIPO]AS [F_TIPO] ,F.[R1]AS [F_R1] ,F.[R2]AS [F_R2],F.[DATA_END_VAL]AS [F_DATA_END_VAL]
,C.[HASH_RACE] AS [C_HASH_RACE],C.[CODLIN]AS [C_CODLIN],C.[CODINS]AS [C_CODINS]
,C.[CODCOR]AS [C_CODCOR],C.[ANDRIT] AS [C_ANDRIT],C.[FERPAR] AS [C_FERPAR]
,C.[FERARR]AS [C_FERARR],C.[ORAPAR]AS [C_ORAPAR],C.[ORAARR]AS [C_ORAARR]
,C.[CODPER]AS [C_CODPER],C.[KMTCOR]AS [C_KMTCOR],C.[DESCO]AS [C_DESCO]
,C.[DESCO2]AS [C_DESCO2],C.[DESCO3]AS [C_DESCO3],C.[CADENZ]AS [C_CADENZ]
,C.[CODDSP]AS [C_CODDSP],C.[URBEXT]AS [C_URBEXT],C.[DATA_END_VAL]AS [C_DATA_END_VAL]
FROM
(
SELECT *
FROM CERT_11_10
UNION ALL
SELECT *
FROM CERT_11_9
) AS A INNER JOIN ANG_FERMATE F ON
A.HASH_STOPPOINT = F.HASH_STOPPOINT
INNER JOIN ANG_CORSE C ON
A.HASH_RACE = C.HASH_RACE
WHERE
F.[DATA_END_VAL] > @DATA_VAL AND
C.[DATA_END_VAL] > @DATA_VAL

) as K
where
K.row>@pagenumber * @pagesize and
K.row<=@pagenumber * @pagesize + @pagesize;