select this_.id as id1_1_8_, this_.blockHash as blockHas2_1_8_, this_.difficulty as difficul3_1_8_, this_.forgerId as forgerI14_1_8_, this_.forgerProof as forgerPr4_1_8_, this_.generationHash as generati5_1_8_, this_.height as height6_1_8_, this_.harvestedInName as harvest15_1_8_, this_.nextBlockId as nextBloc7_1_8_, this_.prevBlockHash as prevBloc8_1_8_, this_.shortId as shortId9_1_8_, this_.timeStamp as timeSta10_1_8_, this_.totalAmount as totalAm11_1_8_, this_.totalFee as totalFe12_1_8_, this_.version as version13_1_8_, blockimpor2_.blockId as blockId14_1_10_, blockimpor2_.id as id1_2_10_, blockimpor2_.orderId as orderId6_10_, blockimpor2_.id as id1_2_0_, blockimpor2_.blkIndex as blkIndex2_2_0_, blockimpor2_.blockId as blockId14_2_0_, blockimpor2_.deadline as deadline3_2_0_, blockimpor2_.direction as directio4_2_0_, blockimpor2_.fee as fee5_2_0_, blockimpor2_.orderId as orderId6_2_0_, blockimpor2_.referencedTransaction as referenc7_2_0_, blockimpor2_.remoteId as remoteI15_2_0_, blockimpor2_.senderId as senderI16_2_0_, blockimpor2_.senderProof as senderPr8_2_0_, blockimpor2_.shortId as shortId9_2_0_, blockimpor2_.timeStamp as timeSta10_2_0_, blockimpor2_.transferHash as transfe11_2_0_, blockimpor2_.type as type12_2_0_, blockimpor2_.version as version13_2_0_, account3_.id as id1_0_1_, account3_.printableKey as printabl2_0_1_, account3_.publicKey as publicKe3_0_1_, account4_.id as id1_0_2_, account4_.printableKey as printabl2_0_2_, account4_.publicKey as publicKe3_0_2_, blocktrans5_.blockId as blockId16_1_11_, blocktrans5_.id as id1_3_11_, blocktrans5_.orderId as orderId8_11_, blocktrans5_.id as id1_3_3_, blocktrans5_.amount as amount2_3_3_, blocktrans5_.blkIndex as blkIndex3_3_3_, blocktrans5_.blockId as blockId16_3_3_, blocktrans5_.deadline as deadline4_3_3_, blocktrans5_.fee as fee5_3_3_, blocktrans5_.messagePayload as messageP6_3_3_, blocktrans5_.messageType as messageT7_3_3_, blocktrans5_.orderId as orderId8_3_3_, blocktrans5_.recipientId as recipie17_3_3_, blocktrans5_.referencedTransaction as referenc9_3_3_, blocktrans5_.senderId as senderI18_3_3_, blocktrans5_.senderProof as senderP10_3_3_, blocktrans5_.shortId as shortId11_3_3_, blocktrans5_.timeStamp as timeSta12_3_3_, blocktrans5_.transferHash as transfe13_3_3_, blocktrans5_.type as type14_3_3_, blocktrans5_.version as version15_3_3_, account6_.id as id1_0_4_, account6_.printableKey as printabl2_0_4_, account6_.publicKey as publicKe3_0_4_, account7_.id as id1_0_5_, account7_.printableKey as printabl2_0_5_, account7_.publicKey as publicKe3_0_5_, account8_.id as id1_0_6_, account8_.printableKey as printabl2_0_6_, account8_.publicKey as publicKe3_0_6_, account9_.id as id1_0_7_, account9_.printableKey as printabl2_0_7_, account9_.publicKey as publicKe3_0_7_ from blocks this_ left outer join importancetransfers blockimpor2_ on this_.id=blockimpor2_.blockId left outer join accounts account3_ on blockimpor2_.remoteId=account3_.id left outer join accounts account4_ on blockimpor2_.senderId=account4_.id left outer join transfers blocktrans5_ on this_.id=blocktrans5_.blockId left outer join accounts account6_ on blocktrans5_.recipientId=account6_.id left outer join accounts account7_ on blocktrans5_.senderId=account7_.id left outer join accounts account8_ on this_.forgerId=account8_.id left outer join accounts account9_ on this_.harvestedInName=account9_.id where this_.height>? and this_.height<=? order by this_.height asc, blockimpor2_.orderId, blocktrans5_.orderId {1: 1516, 2: 1517}