INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 305 | 257 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 72.84 % | 72.25 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130578 |
reportDate | ratio | endQuaterAffected | dayFrom | dayTo |
Cusip
entryId | groupId | EQUITY | CHANGE | CUSIP | DESCRIPTION | ISSUE STATUS CODE |
ISSUE TYPE CODE |
ADD DATE |
EXPIRATION DATE |
PAYMENT FREQUENCY CODE |
MARGIN FLAG |
OPTION FLAG |
CONVERTED CUSIP |
NASDAQ MARKET CODE |
INDEX ISSUER |
CHANGE DATE |
MERGENT CHANGE DATE |
MATURE DATE |
undefined1 | undefined2 | undefined3 | undefined4 | temp1 | temp2 | fileName | fileDate | processDate | ||
5553704 | 5553704 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .16 | 00 | 2024-06-10 | 2024-06-10 | 2024-06-24 | 2024-05-03 | 0 | 2024-05-03 | ? | 0 | 0006917529 | 20240503.ifs | 2024-05-03 | 2024-05-04 | |||||||
5498282 | 5498282 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .15 | 00 | 2024-03-07 | 2024-03-08 | 2024-03-22 | 2024-02-13 | 0 | 2024-02-13 | ? | 0 | 0006876500 | 20240213.ifs | 2024-02-13 | 2024-02-14 | |||||||
5413285 | 5413285 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .15 | 00 | 2023-12-07 | 2023-12-08 | 2023-12-22 | 2023-11-10 | 0 | 2023-11-10 | ? | 0 | 0006811261 | 20231110.ifs | 2023-11-10 | 2023-11-11 | |||||||
5352754 | 5352754 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .15 | 00 | 2023-09-07 | 2023-09-08 | 2023-09-22 | 2023-08-09 | 0 | 2023-08-09 | ? | 0 | 0006768837 | 20230809.ifs | 2023-08-09 | 2023-08-10 | |||||||
5288084 | 5288084 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .15 | 00 | 2023-06-08 | 2023-06-09 | 2023-06-23 | 2023-05-05 | 0 | 2023-05-05 | ? | 0 | 0006723977 | 20230505.ifs | 2023-05-05 | 2023-05-06 | |||||||
5230925 | 5230925 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-03-09 | 2023-03-10 | 2023-03-24 | 2023-02-15 | 0 | 2023-02-15 | ? | 0 | 0006682855 | 20230215.ifs | 2023-02-15 | 2023-02-16 | |||||||
5138167 | 5138167 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .14 | 00 | 2022-12-08 | 2022-12-09 | 2022-12-23 | 2022-11-09 | 0 | 2022-11-09 | ? | 0 | 0006611896 | 20221109.ifs | 2022-11-09 | 2022-11-10 | |||||||
5077044 | 5077044 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .14 | 00 | 2022-09-08 | 2022-09-09 | 2022-09-23 | 2022-08-10 | 0 | 2022-08-10 | ? | 0 | 0006569266 | 20220810.ifs | 2022-08-10 | 2022-08-11 | |||||||
5009351 | 5009351 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .14 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-24 | 2022-05-06 | 0 | 2022-05-06 | ? | 0 | 0006522612 | 20220506.ifs | 2022-05-06 | 2022-05-07 | |||||||
4954478 | 4954478 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .13 | 00 | 2022-03-09 | 2022-03-10 | 2022-03-24 | 2022-02-16 | 0 | 2022-02-16 | ? | 0 | 0006481743 | 20220216.ifs | 2022-02-16 | 2022-02-17 | |||||||
4847672 | 4847672 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .13 | 00 | 2021-12-09 | 2021-12-10 | 2021-12-24 | 2021-11-12 | 0 | 2021-11-12 | ? | 0 | 0006396373 | 20211112.ifs | 2021-11-12 | 2021-11-13 | |||||||
4780488 | 4780488 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .13 | 00 | 2021-09-09 | 2021-09-10 | 2021-09-24 | 2021-08-11 | 0 | 2021-08-11 | ? | 0 | 0006353338 | 20210811.ifs | 2021-08-11 | 2021-08-12 | |||||||
4702380 | 4702380 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .13 | 00 | 2021-06-09 | 2021-06-10 | 2021-06-24 | 2021-05-07 | 0 | 2021-05-07 | ? | 0 | 0006306551 | 20210507.ifs | 2021-05-07 | 2021-05-08 | |||||||
4631251 | 4631251 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-03-09 | 2021-03-10 | 2021-03-24 | 2021-02-17 | 0 | 2021-02-17 | ? | 0 | 0006264931 | 20210217.ifs | 2021-02-17 | 2021-02-18 | |||||||
4505776 | 4505776 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-12-09 | 2020-12-10 | 2020-12-24 | 2020-11-12 | 0 | 2020-11-12 | ? | 0 | 0006187922 | 20201112.ifs | 2020-11-12 | 2020-11-13 | |||||||
4438864 | 4438864 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-09-09 | 2020-09-10 | 2020-09-24 | 2020-08-11 | 0 | 2020-08-11 | ? | 0 | 0006143612 | 20200811.ifs | 2020-08-11 | 2020-08-12 | |||||||
4331789 | 4331789 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-06-09 | 2020-06-10 | 2020-06-24 | 2020-05-08 | 0 | 2020-05-08 | ? | 0 | 0006097579 | 20200508.ifs | 2020-05-08 | 2020-05-09 | |||||||
4331803 | 4331803 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-06-09 | 2020-06-10 | 2020-06-24 | 2020-05-08 | 0 | 2020-05-08 | ? | 0 | 0006097579 | 20200508.ifs | 2020-05-08 | 2020-05-09 | |||||||
4209778 | 4209778 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2020-03-09 | 2020-03-10 | 2020-03-24 | 2020-02-19 | 0 | 2020-02-19 | ? | 0 | 0006056531 | 20200219.ifs | 2020-02-19 | 2020-02-20 | |||||||
4209834 | 4209834 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2020-03-09 | 2020-03-10 | 2020-03-24 | 2020-02-19 | 0 | 2020-02-19 | ? | 0 | 0006056531 | 20200219.ifs | 2020-02-19 | 2020-02-20 | |||||||
4014812 | 4014812 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2019-12-09 | 2019-12-10 | 2019-12-24 | 2019-11-14 | 0 | 2019-11-14 | ? | 0 | 0005975587 | 20191114.ifs | 2019-11-14 | 2019-11-15 | |||||||
4014821 | 4014821 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2019-12-09 | 2019-12-10 | 2019-12-24 | 2019-11-14 | 0 | 2019-11-14 | ? | 0 | 0005975587 | 20191114.ifs | 2019-11-14 | 2019-11-15 | |||||||
3874294 | 3874294 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2019-09-09 | 2019-09-10 | 2019-09-24 | 2019-08-07 | 0 | 2019-08-07 | ? | 0 | 0005929175 | 20190807.ifs | 2019-08-07 | 2019-08-08 | |||||||
3874295 | 3874295 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2019-09-09 | 2019-09-10 | 2019-09-24 | 2019-08-07 | 0 | 2019-08-07 | ? | 0 | 0005929175 | 20190807.ifs | 2019-08-07 | 2019-08-08 | |||||||
3724673 | 3724673 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2019-06-07 | 2019-06-10 | 2019-06-24 | 2019-05-10 | 0 | 2019-05-10 | ? | 0 | 0005883682 | 20190510.ifs | 2019-05-10 | 2019-05-11 | |||||||
3724904 | 3724904 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .11 | 00 | 2019-06-07 | 2019-06-10 | 2019-06-24 | 2019-05-10 | 0 | 2019-05-10 | ? | 0 | 0005883682 | 20190510.ifs | 2019-05-10 | 2019-05-11 | |||||||
3588086 | 3588086 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-03-08 | 2019-03-11 | 2019-03-25 | 2019-02-20 | 0 | 2019-02-20 | ? | 0 | 0005840109 | 20190220.ifs | 2019-02-20 | 2019-02-21 | |||||||
3588123 | 3588123 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-03-08 | 2019-03-11 | 2019-03-25 | 2019-02-20 | 0 | 2019-02-20 | ? | 0 | 0005840109 | 20190220.ifs | 2019-02-20 | 2019-02-21 | |||||||
3371833 | 3371833 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-12-07 | 2018-12-10 | 2018-12-24 | 2018-11-15 | 0 | 2018-11-15 | ? | 0 | 0005755288 | 20181115.ifs | 2018-11-15 | 2018-11-16 | |||||||
3371859 | 3371859 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-12-07 | 2018-12-10 | 2018-12-24 | 2018-11-15 | 0 | 2018-11-15 | ? | 0 | 0005755288 | 20181115.ifs | 2018-11-15 | 2018-11-16 | |||||||
3233956 | 3233956 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-09-07 | 2018-09-10 | 2018-09-24 | 2018-08-08 | 0 | 2018-08-08 | ? | 0 | 0005707091 | 20180808.ifs | 2018-08-08 | 2018-08-09 | |||||||
3233985 | 3233985 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-09-07 | 2018-09-10 | 2018-09-24 | 2018-08-08 | 0 | 2018-08-08 | ? | 0 | 0005707091 | 20180808.ifs | 2018-08-08 | 2018-08-09 | |||||||
3085413 | 3085413 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-06-08 | 2018-06-11 | 2018-06-25 | 2018-05-09 | 0 | 2018-05-09 | ? | 0 | 0005660124 | 20180509.ifs | 2018-05-09 | 2018-05-10 | |||||||
3085414 | 3085414 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-06-08 | 2018-06-11 | 2018-06-25 | 2018-05-09 | 0 | 2018-05-09 | ? | 0 | 0005660124 | 20180509.ifs | 2018-05-09 | 2018-05-10 | |||||||
2960036 | 2960036 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .09 | 00 | 2018-03-08 | 2018-03-09 | 2018-03-23 | 2018-02-21 | 0 | 2018-02-21 | ? | 0 | 0005617036 | 20180221.ifs | 2018-02-21 | 2018-02-22 | |||||||
2960043 | 2960043 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .09 | 00 | 2018-03-08 | 2018-03-09 | 2018-03-23 | 2018-02-21 | 0 | 2018-02-21 | ? | 0 | 0005617036 | 20180221.ifs | 2018-02-21 | 2018-02-22 | |||||||
2768262 | 2768262 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .09 | 00 | 2017-12-08 | 2017-12-11 | 2017-12-26 | 2017-11-16 | 0 | 2017-11-16 | ? | 0 | 0005530651 | 20171116.ifs | 2017-11-16 | 2017-11-17 | |||||||
2768453 | 2768453 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .09 | 00 | 2017-12-08 | 2017-12-11 | 2017-12-26 | 2017-11-16 | 0 | 2017-11-16 | ? | 0 | 0005530651 | 20171116.ifs | 2017-11-16 | 2017-11-17 | |||||||
2646772 | 2646772 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .09 | 00 | 2017-09-08 | 2017-09-11 | 2017-09-25 | 2017-08-09 | 0 | 2017-08-09 | ? | 0 | 0005482037 | 20170809.ifs | 2017-08-09 | 2017-08-10 | |||||||
2565255 | 2565255 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .09 | 00 | 2017-06-07 | 2017-06-09 | 2017-06-23 | 2017-05-10 | 0 | 2017-05-10 | ? | 0 | 0005434432 | 20170510.ifs | 2017-05-10 | 2017-05-11 | |||||||
2495928 | 2495928 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .08 | 00 | 2017-03-08 | 2017-03-10 | 2017-03-24 | 2017-02-24 | 0 | 2017-02-24 | ? | 0 | 0005391433 | 20170224.ifs | 2017-02-24 | 2017-02-25 | |||||||
2435624 | 2435624 | EQUITY | CHANGE | 12621E103 | COM | 0 | 0 | 2010-02-12 | ? | 0 | no | no | no | 2010-05-10 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2435625 | 2435624 | EQUITY | CHANGE | 12621E103 | COM | 0 | 0 | 2010-02-12 | ? | 4 | no | no | no | 2010-05-10 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2345089 | 2345089 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .08 | 00 | 2016-12-07 | 2016-12-09 | 2016-12-23 | 2016-11-17 | 0 | 2016-11-17 | ? | 0 | 0005312200 | 20161117.ifs | 2016-11-17 | 2016-11-18 | |||||||
2269084 | 2269084 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .08 | 00 | 2016-09-07 | 2016-09-09 | 2016-09-23 | 2016-08-10 | 0 | 2016-08-10 | ? | 0 | 0005264860 | 20160810.ifs | 2016-08-10 | 2016-08-11 | |||||||
2191364 | 2191364 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .08 | 00 | 2016-06-08 | 2016-06-10 | 2016-06-24 | 2016-05-04 | 0 | 2016-05-04 | ? | 0 | 0005216982 | 20160504.ifs | 2016-05-04 | 2016-05-05 | |||||||
2118535 | 2118535 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .07 | 00 | 2016-03-08 | 2016-03-10 | 2016-03-24 | 2016-02-24 | 0 | 2016-02-24 | ? | 0 | 0005175230 | 20160224.ifs | 2016-02-24 | 2016-02-25 | |||||||
2008154 | 2008154 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .07 | 00 | 2015-12-08 | 2015-12-10 | 2015-12-24 | 2015-11-12 | 0 | 2015-11-12 | ? | 0 | 0005093156 | 20151112.ifs | 2015-11-12 | 2015-11-13 | |||||||
1940059 | 1940059 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .07 | 00 | 2015-09-08 | 2015-09-10 | 2015-09-24 | 2015-08-12 | 0 | 2015-08-12 | ? | 0 | 0005046734 | 20150812.ifs | 2015-08-12 | 2015-08-13 | |||||||
1859041 | 1859041 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .07 | 00 | 2015-06-08 | 2015-06-10 | 2015-06-24 | 2015-05-06 | 0 | 2015-05-06 | ? | 0 | 0004998540 | 20150506.ifs | 2015-05-06 | 2015-05-07 | |||||||
1796756 | 1796756 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .06 | 00 | 2015-03-06 | 2015-03-10 | 2015-03-24 | 2015-02-26 | 0 | 2015-02-26 | ? | 0 | 0004958336 | 20150226.ifs | 2015-02-26 | 2015-02-27 | |||||||
1680644 | 1680644 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .06 | 00 | 2014-12-08 | 2014-12-10 | 2014-12-24 | 2014-11-13 | 0 | 2014-11-13 | ? | 0 | 0004872756 | 20141113.ifs | 2014-11-13 | 2014-11-14 | |||||||
1600814 | 1600814 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .06 | 00 | 2014-09-08 | 2014-09-10 | 2014-09-24 | 2014-08-06 | 0 | 2014-08-06 | ? | 0 | 0004827183 | 20140806.ifs | 2014-08-06 | 2014-08-07 | |||||||
1521014 | 1521014 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .06 | 00 | 2014-06-06 | 2014-06-10 | 2014-06-24 | 2014-05-07 | 0 | 2014-05-07 | ? | 0 | 0004781173 | 20140507.ifs | 2014-05-07 | 2014-05-08 | |||||||
1458879 | 1458879 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .06 | 00 | 2014-03-12 | 2014-03-14 | 2014-03-24 | 2014-03-03 | 0 | 2014-03-03 | ? | 0 | 0004744020 | 20140303.ifs | 2014-03-03 | 2014-03-04 | |||||||
1340171 | 1340171 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .03 | 00 | 2013-12-06 | 2013-12-10 | 2013-12-24 | 2013-11-14 | 0 | 2013-11-14 | ? | 0 | 0004658015 | 20131114.ifs | 2013-11-14 | 2013-11-15 | |||||||
1252996 | 1252996 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .03 | 00 | 2013-09-06 | 2013-09-10 | 2013-09-24 | 2013-07-31 | 0 | 2013-07-31 | ? | 0 | 0004606466 | 20130731.ifs | 2013-07-31 | 2013-08-01 | |||||||
1182419 | 1182419 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .03 | 00 | 2013-06-06 | 2013-06-10 | 2013-06-24 | 2013-05-08 | 0 | 2013-05-08 | ? | 0 | 0004570126 | 20130508.ifs | 2013-05-08 | 2013-05-09 | |||||||
1122362 | 1122362 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .02 | 00 | 2013-03-07 | 2013-03-11 | 2013-03-25 | 2013-02-28 | 0 | 2013-02-28 | ? | 0 | 0004532192 | 20130228.ifs | 2013-02-28 | 2013-03-01 | |||||||
1010468 | 1010468 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .02 | 00 | 2012-12-06 | 2012-12-10 | 2012-12-24 | 2012-11-15 | 0 | 2012-11-15 | ? | 0 | 0004458299 | 20121115.ifs | 2012-11-15 | 2012-11-16 | |||||||
858630 | 858630 | DIVIDEND | ADD | 12621E103 | 0 | 0 | 1 | 0 | .02 | 00 | 2012-06-07 | 2012-06-11 | 2012-06-25 | 2012-05-09 | 0 | 2012-05-09 | ? | 0 | 0004373152 | 20120509.ifs | 2012-05-09 | 2012-05-10 | |||||||
190337 | 190337 | EXCHANGE | ADD | 12621E103 | 01 | 2010-05-12 | 2010-05-12 | CNO | 0 | 0 | 2010-05-12 | ? | 20100512.ifs | 2010-05-12 | 2010-05-13 | ||||||||||||||
190744 | 190744 | EQUITY | CHANGE | 12621E103 | COM | N | 0 | 2010-02-12 | ? | 0 | no | no | no | 2010-05-10 | ? | ? | 20100512.ifs | 2010-05-12 | 2010-05-13 | ||||||||||
190745 | 190744 | EQUITY | CHANGE | 12621E103 | COM | 0 | 0 | 2010-02-12 | ? | 0 | no | no | no | 2010-05-10 | ? | ? | 20100512.ifs | 2010-05-12 | 2010-05-13 | ||||||||||
188959 | 188959 | EQUITY | ADD | 12621E103 | COM | N | 0 | 2010-02-12 | ? | 0 | no | no | no | 2010-05-10 | ? | ? | 20100510.ifs | 2010-05-10 | 2010-05-11 |
entryId | groupId | EQUITY | CHANGE | CUSIP | DESCRIPTION | ISSUE STATUS CODE |
ISSUE TYPE CODE |
ADD DATE |
EXPIRATION DATE |
PAYMENT FREQUENCY CODE |
MARGIN FLAG |
OPTION FLAG |
CONVERTED CUSIP |
NASDAQ MARKET CODE |
INDEX ISSUER |
CHANGE DATE |
MERGENT CHANGE DATE |
MATURE DATE |
undefined1 | undefined2 | undefined3 | undefined4 | temp1 | temp2 | fileName | fileDate | processDate |
BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 130578
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC