> select max(tx_size), sum(tx_size), block_nTime, cc.block_height from tx join block_tx using (tx_id) join block using (block_id) join chain_candidate cc using (block_id) join chain using (chain_id) where chain_name = 'SolidCoin' and tx_size > 4096 and in_longest = 1 group by block_nTime, cc.block_height order by cc.block_height; max | sum | block_ntime | block_height --------+--------+-------------+-------------- 10103 | 10103 | 1313895020 | 492 7254 | 7254 | 1313895223 | 519 7266 | 7266 | 1313895353 | 537 7504 | 7504 | 1313895472 | 555 7254 | 7254 | 1313895527 | 564 7510 | 7510 | 1313895938 | 622 7256 | 7256 | 1313896279 | 671 7322 | 7322 | 1313897296 | 798 7256 | 7256 | 1313897503 | 823 7315 | 7315 | 1313897741 | 850 7260 | 7260 | 1313898236 | 915 13973 | 13973 | 1313903893 | 1127 7206 | 7206 | 1313912764 | 3402 24599 | 24599 | 1313914010 | 3705 11255 | 11255 | 1313914795 | 3895 6230 | 6230 | 1313915847 | 4136 19094 | 19094 | 1313916000 | 4173 8290 | 8290 | 1313916535 | 4291 5500 | 5500 | 1313916707 | 4332 7824 | 7824 | 1313917204 | 4447 14892 | 14892 | 1313918219 | 4673 10734 | 10734 | 1313918962 | 4831 8621 | 8621 | 1313920611 | 5204 35814 | 35814 | 1313921052 | 5305 35735 | 35735 | 1313921092 | 5312 71353 | 71353 | 1313921111 | 5314 89457 | 89457 | 1313921162 | 5322 4472 | 4472 | 1313922506 | 5630 6802 | 6802 | 1313923361 | 5823 6349 | 6349 | 1313924313 | 6047 5207 | 5207 | 1313924807 | 6157 38593 | 38593 | 1313925551 | 6320 4179 | 4179 | 1313927455 | 6756 4601 | 4601 | 1313928240 | 6986 6269 | 6269 | 1313930298 | 7531 4754 | 4754 | 1313930375 | 7548 6340 | 6340 | 1313931174 | 7745 5158 | 5158 | 1313934834 | 8570 10574 | 10574 | 1313937799 | 9218 42893 | 42893 | 1313937918 | 9243 17976 | 17976 | 1313938373 | 9335 4523 | 4523 | 1313938466 | 9358 8344 | 8344 | 1313940215 | 9730 6411 | 6411 | 1313940533 | 9801 4441 | 4441 | 1313941169 | 9924 7368 | 7368 | 1313942702 | 10239 35576 | 35576 | 1313942897 | 10278 35772 | 35772 | 1313942945 | 10288 35826 | 35826 | 1313942997 | 10297 35763 | 35763 | 1313943375 | 10368 8233 | 8233 | 1313944192 | 10530 8001 | 8001 | 1313945651 | 10786 4597 | 4597 | 1313945898 | 10834 13642 | 13642 | 1313946062 | 10863 5908 | 5908 | 1313947230 | 11075 18042 | 18042 | 1313948411 | 11273 4292 | 4292 | 1313948515 | 11291 7439 | 7439 | 1313948818 | 11333 5222 | 5222 | 1313950153 | 11551 8093 | 8093 | 1313950443 | 11602 4129 | 4129 | 1313952455 | 11955 5728 | 5728 | 1313953923 | 12202 6019 | 6019 | 1313953976 | 12212 18210 | 18210 | 1313954576 | 12304 30788 | 30788 | 1313954664 | 12317 15686 | 15686 | 1313955133 | 12407 7271 | 7271 | 1313956156 | 12580 4297 | 4297 | 1313957328 | 12776 31532 | 31532 | 1313957451 | 12798 9050 | 9050 | 1313959764 | 13147 68225 | 68225 | 1313963627 | 13704 68227 | 68227 | 1313963647 | 13706 68226 | 68226 | 1313963662 | 13708 68225 | 68225 | 1313963674 | 13710 68226 | 68226 | 1313963698 | 13711 68226 | 68226 | 1313963726 | 13713 68226 | 68226 | 1313963751 | 13715 68227 | 68227 | 1313963793 | 13720 68227 | 204678 | 1313963805 | 13721 68226 | 68226 | 1313963850 | 13728 68226 | 68226 | 1313963856 | 13729 68227 | 136453 | 1313963876 | 13731 68226 | 76868 | 1313963890 | 13732 68227 | 136452 | 1313963906 | 13735 68226 | 136452 | 1313963924 | 13737 68227 | 204679 | 1313963946 | 13739 68226 | 68226 | 1313963954 | 13741 68226 | 68226 | 1313963975 | 13744 68227 | 204679 | 1313963995 | 13745 68226 | 136452 | 1313964007 | 13746 68227 | 136453 | 1313964045 | 13754 68225 | 68225 | 1313964077 | 13759 18038 | 18038 | 1313967066 | 14148 13329 | 13329 | 1313967824 | 14244 22276 | 22276 | 1313968015 | 14264 8856 | 8856 | 1313968382 | 14311 4293 | 4293 | 1313969540 | 14453 9979 | 9979 | 1313969583 | 14458 4748 | 4748 | 1313969958 | 14509 6083 | 6083 | 1313972439 | 14780 18044 | 18044 | 1313973371 | 14880 7609 | 7609 | 1313974912 | 15043 5665 | 5665 | 1313975030 | 15056 7617 | 7617 | 1313976607 | 15211 7318 | 7318 | 1313977915 | 15354 11038 | 11038 | 1313979309 | 15495 5388 | 5388 | 1313981131 | 15650 4407 | 4407 | 1313983366 | 15839 7214 | 7214 | 1313985321 | 15996 10801 | 10801 | 1313987158 | 16129 7432 | 7432 | 1313989938 | 16316 9035 | 9035 | 1313996357 | 16675 10077 | 10077 | 1313996671 | 16692 21560 | 21560 | 1313998549 | 16786 24446 | 24446 | 1314021346 | 17599 4297 | 4297 | 1314022644 | 17634 18406 | 18406 | 1314024924 | 17694 4294 | 4294 | 1314036838 | 17982 4746 | 4746 | 1314040112 | 18043 37822 | 37822 | 1314075434 | 18564 8850 | 8850 | 1314080943 | 18623 17855 | 17855 | 1314112399 | 18875 4356 | 4356 | 1314126587 | 19029 11043 | 11043 | 1314135003 | 19149 7174 | 7174 | 1314144069 | 19306 8309 | 8309 | 1314203528 | 20318 5060 | 5060 | 1314205985 | 20370 4216 | 4216 | 1314210639 | 20449 16636 | 16636 | 1314277159 | 21498 14329 | 14329 | 1314281629 | 21561 6739 | 6739 | 1314290613 | 21714 5445 | 5445 | 1314309534 | 21995 7599 | 7599 | 1314311823 | 22030 5295 | 5295 | 1314337272 | 22394 5301 | 5301 | 1314339141 | 22427 4216 | 4216 | 1314351576 | 22640 37505 | 37505 | 1314353351 | 22670 20230 | 20230 | 1314353393 | 22672 56599 | 102831 | 1314353528 | 22673 75331 | 145423 | 1314353556 | 22674 4390 | 4390 | 1314358316 | 22765 13406 | 13406 | 1314364907 | 22877 5660 | 5660 | 1314375448 | 23067 5122 | 5122 | 1314395597 | 23454 4442 | 4442 | 1314429178 | 24003 7666 | 7666 | 1314443683 | 24241 5147 | 5147 | 1314448074 | 24292 18965 | 18965 | 1314450260 | 24322 7256 | 7256 | 1314479114 | 24683 10116 | 10116 | 1314491877 | 24844 5119 | 5119 | 1314502027 | 24979 5431 | 5431 | 1314531517 | 25273 7261 | 7261 | 1314591900 | 25744 19532 | 19532 | 1314592579 | 25749 7993 | 7993 | 1314601509 | 25827 13634 | 13634 | 1314603322 | 25840 4362 | 4362 | 1314624484 | 25951 4896 | 4896 | 1314629968 | 25991 4636 | 4636 | 1314667715 | 26182 7460 | 7460 | 1314669788 | 26192 4755 | 4755 | 1314702967 | 26351 4941 | 4941 | 1314716692 | 26426 4219 | 4219 | 1314719081 | 26440 10800 | 10800 | 1314728257 | 26466 22698 | 22698 | 1314752257 | 26552 4725 | 4725 | 1314753725 | 26553 4403 | 4403 | 1314792802 | 26781 6731 | 6731 | 1314815704 | 27036 10778 | 10778 | 1314823711 | 27094 5081 | 5081 | 1314828449 | 27125 11919 | 11919 | 1314833078 | 27158 4181 | 4181 | 1314837001 | 27189 28153 | 28153 | 1314876120 | 27525 11227 | 11227 | 1314876612 | 27529 22036 | 22036 | 1314896320 | 27693 12501 | 12501 | 1314897794 | 27704 12319 | 12319 | 1314900028 | 27719 4213 | 4213 | 1314902471 | 27734 8007 | 8007 | 1314905375 | 27763 13930 | 27130 | 1314905830 | 27766 6376 | 6376 | 1314906526 | 27769 29964 | 36525 | 1314907743 | 27781 40241 | 40241 | 1314907999 | 27782 4754 | 4754 | 1314911246 | 27810 24715 | 24715 | 1314912275 | 27817 99084 | 99084 | 1314913765 | 27829 65419 | 65419 | 1314916714 | 27847 22576 | 22576 | 1314916833 | 27848 5110 | 5110 | 1314924865 | 27915 6235 | 6235 | 1314933114 | 27985 7250 | 7250 | 1314984521 | 28337 68227 | 136452 | 1314985881 | 28345 34089 | 34089 | 1314986127 | 28347 428376 | 428376 | 1314986803 | 28351 428439 | 428439 | 1314987247 | 28352 427934 | 427934 | 1314987989 | 28354 427993 | 427993 | 1314988394 | 28355 428382 | 428382 | 1314989183 | 28356 428410 | 428410 | 1314989373 | 28357 427992 | 427992 | 1314989581 | 28358 428433 | 428433 | 1314991556 | 28360 427892 | 427892 | 1314991776 | 28361 427957 | 427957 | 1314992123 | 28362 428347 | 428347 | 1314993090 | 28364 428352 | 428352 | 1314993563 | 28365 427986 | 427986 | 1314993913 | 28366 428410 | 428410 | 1314994510 | 28368 427919 | 427919 | 1314994724 | 28369 428447 | 428447 | 1314996382 | 28370 427930 | 427930 | 1314996623 | 28371 427992 | 432217 | 1315002356 | 28385 428433 | 428433 | 1315002415 | 28386 209469 | 277627 | 1315003034 | 28387 427734 | 427734 | 1315003231 | 28388 427740 | 427740 | 1315003665 | 28389 428387 | 428387 | 1315003987 | 28390 427940 | 427940 | 1315004116 | 28391 428379 | 428379 | 1315004363 | 28392 427916 | 427916 | 1315004668 | 28393 427799 | 427799 | 1315005632 | 28394 428431 | 428431 | 1315005860 | 28395 427981 | 427981 | 1315006482 | 28396 428482 | 428482 | 1315006575 | 28397 427991 | 427991 | 1315006811 | 28398 428393 | 428393 | 1315007256 | 28399 428359 | 428359 | 1315007497 | 28400 427963 | 427963 | 1315007954 | 28401 51680 | 51680 | 1315011876 | 28406 427988 | 427988 | 1315013953 | 28411 428395 | 428395 | 1315014226 | 28412 427964 | 427964 | 1315014777 | 28415 428362 | 428362 | 1315015643 | 28416 427926 | 427926 | 1315017110 | 28417 428386 | 428386 | 1315017818 | 28418 427942 | 427942 | 1315018108 | 28419 428354 | 428354 | 1315018912 | 28420 428325 | 428325 | 1315019444 | 28421 427960 | 427960 | 1315019712 | 28422 427984 | 427984 | 1315020039 | 28423 428396 | 428396 | 1315020373 | 28424 427993 | 427993 | 1315020911 | 28425 428360 | 428360 | 1315021885 | 28426 428404 | 428404 | 1315022308 | 28427 427968 | 427968 | 1315022739 | 28428 427940 | 427940 | 1315023132 | 28429 427973 | 427973 | 1315023694 | 28430 428368 | 428368 | 1315023752 | 28431 428347 | 428347 | 1315024689 | 28432 428440 | 428440 | 1315024992 | 28433 428000 | 428000 | 1315025037 | 28434 428018 | 428018 | 1315026842 | 28435 428401 | 428401 | 1315026937 | 28436 427980 | 427980 | 1315027147 | 28437 428395 | 428395 | 1315027971 | 28438 427960 | 427960 | 1315028476 | 28439 428375 | 428375 | 1315031392 | 28443 428408 | 428408 | 1315032735 | 28445 428007 | 428007 | 1315036210 | 28450 427926 | 427926 | 1315041347 | 28462 427998 | 427998 | 1315042447 | 28465 428451 | 428451 | 1315044027 | 28467 167639 | 167639 | 1315044355 | 28469 360063 | 360063 | 1315046122 | 28473 360249 | 360249 | 1315047771 | 28480 359891 | 359891 | 1315047992 | 28481 (265 rows)