rendered paste bodySQL> select identifier, round(filesize/1024/1024,0) as mb from tgeg_mailbox order by identifier;
IDENTIFIER MB
------------------ ----------
000000000003540749 4
000000000003540789 3
000000000003540913 3
000000000003543713 0
000000000003543717 0
000000000003543732 0
000000000003543748 0
000000000003543763 0
000000000003543813 0
9 rows selected.
SQL> select identifier, count(*) from tgeg_data group by identifier order by identifier;
IDENTIFIER COUNT(*)
------------------ ----------
000000000001058824 1
000000000002028159 1
000000000002077816 1
000000000002077825 1
000000000002077837 1
000000000002077852 1
000000000002077867 1
000000000002123759 1
000000000002123802 1
000000000002123816 1
000000000002123834 1
000000000002123849 1
000000000002126949 1
000000000002126956 1
000000000002126968 1
000000000002126980 1
000000000002126992 1
000000000002127626 1
000000000002127638 1
000000000002127650 1
000000000002127662 1
000000000002127674 1
000000000002183694 1
000000000002183722 1
000000000002184055 1
000000000002184280 1
000000000002184532 1
000000000002184538 1
000000000002184543 1
000000000002184550 1
000000000002184558 1
000000000002184801 1
000000000002184807 1
000000000002184816 1
000000000002184822 1
000000000002184831 1
000000000002184860 1
000000000002184866 1
000000000002184871 1
000000000002184881 1
000000000002184887 1
000000000002184916 1
000000000002184922 1
000000000002184931 1
000000000002184939 1
000000000002184947 1
000000000002185124 1
000000000002185129 1
000000000002185137 1
000000000002185142 1
000000000002185147 1
000000000002188932 1
000000000002189148 1
000000000002190152 1
000000000002377419 1
000000000002552695 1
000000000002757805 1
000000000003524624 1
000000000003525217 1
000000000003525448 1
000000000003525451 1
000000000003525453 1
000000000003525454 1
000000000003525456 1
000000000003525459 1
000000000003525467 1
000000000003525474 1
000000000003525477 1
000000000003525480 1
000000000003525513 1
000000000003525541 1
000000000003525543 1
000000000003525545 1
000000000003525546 1
000000000003525548 1
000000000003525552 1
000000000003525558 1
000000000003526966 1
000000000003527463 149
000000000003527468 1
000000000003527474 1
000000000003527482 1
000000000003527489 1
000000000003527496 1
000000000003527509 1
000000000003527516 1
000000000003527523 1
000000000003527530 1
000000000003527537 1
000000000003527587 1
000000000003527594 1
000000000003527601 1
000000000003527608 1
000000000003527615 1
000000000003527665 1
000000000003527672 1
000000000003527679 1
000000000003527743 1
000000000003527810 1
000000000003527817 1
000000000003527824 1
000000000003528681 1
000000000003532647 1
000000000003540695 4
000000000003540699 4
000000000003540705 4
000000000003540708 4
000000000003540711 4
000000000003540739 1
000000000003540757 1
000000000003540797 1
000000000003540921 1
000000000003541244 1
000000000003543713 1
000000000003543904 1
000000000003543907 1
000000000003543940 1
000000000003543943 1
118 rows selected.