SELECT "a".*, "nro_viajes", "idpais", "pais_es", "nomnave", "nave_imo", "servicio", "codigo_manifiesto", "iddestino", (select count(e.idmercaderiaviaje) from lf_mercaderiaviaje e where e.idviaje=a.idviaje and e.idmanifiesto=a.idmanifiesto and e.idbls=a.Idblsviaje and e.estado=0 ) as cntmerca, (select f.nombre_exportador from lf_exportador f where a.id_exportador=f.idexportador ) as exportador, (select g.nombre_consignatario from lf_consignatario g where a.id_consignatario=g.idconsignatario ) as consignatario, (select h.prefijo from lf_destinosviajes h where h.iddestino=e.iddestino ) as prefijo, (select count(i.idfoliospallet) from lf_foliospallet i where a.Idblsviaje=i.idblsviaje ) as cantfolios, (select h.nombre_puerto from lf_puerto h where e.idpuerto_embarque=h.idpuerto) as pto_embarque FROM ( SELECT ROW_NUMBER() OVER(ORDER BY "a"."Idblsviaje" ASC) AS "CI_rownum", "a".*, "b"."nro_viajes", "c"."idpais", "c"."pais_es", "b"."nombre_nave" as "nomnave", "d"."nave_imo", "b"."servicio", "e"."codigo_manifiesto", "e"."iddestino", (select count(e.idmercaderiaviaje) from lf_mercaderiaviaje e where e.idviaje=a.idviaje and e.idmanifiesto=a.idmanifiesto and e.idbls=a.Idblsviaje and e.estado=0 ) as cntmerca, (select f.nombre_exportador from lf_exportador f where a.id_exportador=f.idexportador ) as exportador, (select g.nombre_consignatario from lf_consignatario g where a.id_consignatario=g.idconsignatario ) as consignatario, (select h.prefijo from lf_destinosviajes h where h.iddestino=e.iddestino ) as prefijo, (select count(i.idfoliospallet) from lf_foliospallet i where a.Idblsviaje=i.idblsviaje ) as cantfolios, (select h.nombre_puerto from lf_puerto h where e.idpuerto_embarque=h.idpuerto) as pto_embarque FROM "lf_blsviajes" "a" JOIN "lf_naveviaje" "b" ON "a"."idviaje"="b"."idviajes" JOIN "lf_manifiestoviajes" "e" ON "a"."idmanifiesto"="e"."idmanifiesto" JOIN "lf_pais" "c" ON "b"."idpais"="c"."idpais" JOIN "lf_naves" "d" ON "b"."idnave"="d"."idnave" ) "CI_subquery" WHERE "CI_rownum" BETWEEN 2 AND 201