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
4425792	4425792	CORPACTION	ADD	07986W102	66	D	2020-07-29			?															20200729.ifs	2020-07-29	2020-07-30
4425793	4425793	EQUITY	CHANGE	07986W102	SPONSORED ADR	0	0	2001-12-21	?	2	no	no		no		2002-04-26	?	?							20200729.ifs	2020-07-29	2020-07-30
4425794	4425793	EQUITY	CHANGE	07986W102	SPONSORED ADR	D	0	2001-12-21	2020-07-29	2	no	no		no		2002-04-26	2020-07-29	?							20200729.ifs	2020-07-29	2020-07-30
4402878	4402878	DIVIDEND	DELETE	07986W102		0		1	0	.074647		00	?	2020-03-31	2020-07-07	?		0	2020-06-26	?	0	0006069633			20200629.ifs	2020-06-29	2020-06-30
4402879	4402879	DIVIDEND	ADD	07986W102		0	0	1	0	.074647	0	00	?	2020-03-31	2020-07-07	2020-03-17		0	?	2020-06-29	0	0006069633			20200629.ifs	2020-06-29	2020-06-30
4402880	4402880	DIVIDEND	CHANGE	07986W102		0	0	1	0	.074647	0	00	?	2020-03-31	2020-07-07	2020-03-17		0	?	2020-06-29	0	0006069633			20200629.ifs	2020-06-29	2020-06-30
4402881	4402880	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.074647	0	00	?	2020-03-31	2020-07-07	2020-03-17		0	?	2020-06-29	0	0006069633			20200629.ifs	2020-06-29	2020-06-30
4402729	4402729	DIVIDEND	ADD	07986W102		0		1	0	.074647		00	?	2020-03-31	2020-07-07	?		0	2020-06-26	?	0	0006069633			20200626.ifs	2020-06-26	2020-06-27
4243047	4243047	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2020-03-31	?	2020-03-17		0	2020-03-17	?	0	0006069633			20200318.ifs	2020-03-18	2020-03-19
4243048	4243048	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2020-03-31	?	2020-03-17		0	2020-03-17	?	0	0006069633			20200318.ifs	2020-03-18	2020-03-19
4041049	4041049	DIVIDEND	ADD	07986W102		0	0	1	0	.073571		00	?	2019-09-30	2019-12-16	2019-09-12		0	?	2019-12-05	0	0005944257			20191205.ifs	2019-12-05	2019-12-06
4041051	4041051	DIVIDEND	CHANGE	07986W102		0	0	1	0	.073571		00	?	2019-09-30	2019-12-16	2019-09-12		0	?	2019-12-05	0	0005944257			20191205.ifs	2019-12-05	2019-12-06
4041052	4041052	DIVIDEND	ADD	07986W102		0	0	1	0	.073571		00	?	2019-09-30	2019-12-16	2019-09-12		0	?	2019-12-05	0	0005944257			20191205.ifs	2019-12-05	2019-12-06
4041053	4041052	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.073571		00	?	2019-09-30	2019-12-16	2019-09-12		0	?	2019-12-05	0	0005944257			20191205.ifs	2019-12-05	2019-12-06
4041054	4041054	DIVIDEND	CHANGE	07986W102		0	0	1	0	.073571		00	?	2019-09-30	2019-12-16	2019-09-12		0	?	2019-12-05	0	0005944257			20191205.ifs	2019-12-05	2019-12-06
4041056	4041055	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.073571		00	?	2019-09-30	2019-12-16	2019-09-12		0	?	2019-12-05	0	0005944257			20191205.ifs	2019-12-05	2019-12-06
3823589	3823589	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.069395		00	?	2019-03-29	2019-07-08	2019-03-15		0	?	2019-07-02	0	0005852896			20190702.ifs	2019-07-02	2019-07-03
3823662	3823662	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.069395		00	?	2019-03-29	2019-07-08	2019-03-15		0	?	2019-07-02	0	0005852896			20190702.ifs	2019-07-02	2019-07-03
3405929	3405929	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.066226		00	?	2018-09-28	2018-12-14	2018-09-18		0	?	2018-12-06	0	0005724788			20181206.ifs	2018-12-06	2018-12-07
3405932	3405932	DIVIDEND	DELETE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.05664		08	?	2018-03-29	2018-07-09	2018-03-08		0	?	2018-06-29	0	0005627819			20181206.ifs	2018-12-06	2018-12-07
3405934	3405934	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.05664	0	00	?	2018-03-29	2018-07-09	2018-03-08		0	?	2018-12-06	0	0005627819			20181206.ifs	2018-12-06	2018-12-07
3405941	3405941	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.066226		00	?	2018-09-28	2018-12-14	2018-09-18		0	?	2018-12-06	0	0005724788			20181206.ifs	2018-12-06	2018-12-07
3405943	3405943	DIVIDEND	DELETE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.05664		08	?	2018-03-29	2018-07-09	2018-03-08		0	?	2018-06-29	0	0005627819			20181206.ifs	2018-12-06	2018-12-07
3405945	3405945	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.05664	0	00	?	2018-03-29	2018-07-09	2018-03-08		0	?	2018-12-06	0	0005627819			20181206.ifs	2018-12-06	2018-12-07
3164449	3164449	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.05664		08	?	2018-03-29	2018-07-09	2018-03-08		0	?	2018-06-29	0	0005627819			20180629.ifs	2018-06-29	2018-06-30
3164505	3164505	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.05664		08	?	2018-03-29	2018-07-09	2018-03-08		0	?	2018-06-29	0	0005627819			20180629.ifs	2018-06-29	2018-06-30
2806953	2806953	DIVIDEND	DELETE	07986W102		0		1	0	.055319		00	?	2017-10-02	2017-12-14	?		0	2017-12-05	?	0	0005500801			20171206.ifs	2017-12-06	2017-12-07
2806954	2806954	DIVIDEND	DELETE	07986W102		0		1	0	.055319		00	?	2017-10-02	2017-12-14	?		0	2017-12-05	?	0	0005500801			20171206.ifs	2017-12-06	2017-12-07
2806955	2806955	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.055319	0	00	?	2017-10-02	2017-12-14	2017-09-21		0	?	2017-12-06	0	0005500801			20171206.ifs	2017-12-06	2017-12-07
2806956	2806956	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.055319	0	00	?	2017-10-02	2017-12-14	2017-09-21		0	?	2017-12-06	0	0005500801			20171206.ifs	2017-12-06	2017-12-07
2804270	2804270	DIVIDEND	ADD	07986W102		0		1	0	.055319		00	?	2017-10-02	2017-12-14	?		0	2017-12-05	?	0	0005500801			20171205.ifs	2017-12-05	2017-12-06
2806880	2806880	DIVIDEND	ADD	07986W102		0		1	0	.055319		00	?	2017-10-02	2017-12-14	?		0	2017-12-05	?	0	0005500801			20171205.ifs	2017-12-05	2017-12-06
2684982	2684982	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2017-10-02	?	2017-09-21		0	2017-09-21	?	0	0005500801			20170922.ifs	2017-09-22	2017-09-23
2685121	2685121	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2017-10-02	?	2017-09-21		0	2017-09-21	?	0	0005500801			20170922.ifs	2017-09-22	2017-09-23
2682753	2682753	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2017-10-02	?	2017-09-21		0	2017-09-21	?	0	0005500801			20170921.ifs	2017-09-21	2017-09-22
2682852	2682852	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2017-10-02	?	2017-09-21		0	2017-09-21	?	0	0005500801			20170921.ifs	2017-09-21	2017-09-22
2610884	2610884	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.055405		00	?	2017-03-31	2017-07-10	2017-03-15		0	?	2017-07-03	0	0005402304			20170703.ifs	2017-07-03	2017-07-04
2449372	2449372	EQUITY	CHANGE	07986W102	SPONSORED ADR	0	0	2001-12-21	?	8	no	no		no		2002-04-26	?	?							20170124.ifs	2017-01-24	2017-01-25
2449373	2449372	EQUITY	CHANGE	07986W102	SPONSORED ADR	0	0	2001-12-21	?	2	no	no		no		2002-04-26	?	?							20170124.ifs	2017-01-24	2017-01-25
2360686	2360686	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.054775		00	?	2016-09-30	2016-12-12	2016-09-08		0	?	2016-12-05	0	0005278543			20161205.ifs	2016-12-05	2016-12-06
2360687	2360687	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.050722		00	?	2015-09-30	2015-12-14	2015-12-07		0	?	2015-12-08	0	0005063900			20161205.ifs	2016-12-05	2016-12-06
2360688	2360687	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.050722	0	00	?	2015-09-30	2015-12-14	2015-12-07		0	?	2016-12-05	0	0005063090			20161205.ifs	2016-12-05	2016-12-06
2235783	2235783	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.060832		00	?	2016-03-31	2016-07-11	2016-03-09		0	?	2016-06-30	0	0005185593			20160630.ifs	2016-06-30	2016-07-01
2027254	2027254	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.050722		00	?	2015-09-30	2015-12-14	2015-12-07		0	?	2015-12-08	0	0005063900			20151208.ifs	2015-12-08	2015-12-09
1904603	1904603	DIVIDEND	DELETE	07986W102		0		1	0	.050734		00	?	2015-03-31	2015-07-09	?		0	2015-06-30	?	0	0004968252			20150701.ifs	2015-07-01	2015-07-02
1904604	1904604	DIVIDEND	ADD	07986W102		0	0	1	0	.050734	0	00	?	2015-03-31	2015-07-09	2015-06-30		0	?	2015-07-01	0	0004968252			20150701.ifs	2015-07-01	2015-07-02
1904605	1904605	DIVIDEND	CHANGE	07986W102		0	0	1	0	.050734	0	00	?	2015-03-31	2015-07-09	2015-06-30		0	?	2015-07-01	0	0004968252			20150701.ifs	2015-07-01	2015-07-02
1904606	1904605	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.050734	0	00	?	2015-03-31	2015-07-09	2015-06-30		0	?	2015-07-01	0	0004968252			20150701.ifs	2015-07-01	2015-07-02
1903850	1903850	DIVIDEND	ADD	07986W102		0		1	0	.050734		00	?	2015-03-31	2015-07-09	?		0	2015-06-30	?	0	0004968252			20150630.ifs	2015-06-30	2015-07-01
1813490	1813490	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2015-03-31	?	2015-03-13		0	2015-03-13	?	0	0004968252			20150316.ifs	2015-03-16	2015-03-17
1812119	1812119	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2015-03-31	?	2015-03-13		0	2015-03-13	?	0	0004968252			20150313.ifs	2015-03-13	2015-03-14
1705097	1705097	DIVIDEND	DELETE	07986W102		0		1	0	.05141		00	?	2014-09-29	2014-12-15	?		0	2014-12-09	?	0	0004842111			20141210.ifs	2014-12-10	2014-12-11
1705098	1705098	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.05141	0	00	?	2014-09-29	2014-12-15	2014-09-11		0	?	2014-12-10	0	0004842111			20141210.ifs	2014-12-10	2014-12-11
1704864	1704864	DIVIDEND	ADD	07986W102		0		1	0	.05141		00	?	2014-09-29	2014-12-15	?		0	2014-12-09	?	0	0004842111			20141209.ifs	2014-12-09	2014-12-10
1629514	1629514	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2014-09-29	?	2014-09-11		0	2014-09-11	?	0	0004842111			20140912.ifs	2014-09-12	2014-09-13
1628476	1628476	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2014-09-29	?	2014-09-11		0	2014-09-11	?	0	0004842111			20140911.ifs	2014-09-11	2014-09-12
1575194	1575194	DIVIDEND	CHANGE	07986W102		0	0	1	0	.061618		00	?	2014-03-28	2014-07-10	2014-03-06		0	?	2014-07-03	0	0004748464			20140707.ifs	2014-07-07	2014-07-08
1575195	1575194	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.061618	0	00	?	2014-03-28	2014-07-10	2014-03-06		0	?	2014-07-07	0	0004748464			20140707.ifs	2014-07-07	2014-07-08
1575070	1575070	DIVIDEND	DELETE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.061618		00	?	2014-03-28	2014-07-01	2014-03-06		0	?	2014-07-02	0	0004748464			20140703.ifs	2014-07-03	2014-07-04
1575071	1575071	DIVIDEND	ADD	07986W102		0	0	1	0	.061618		00	?	2014-03-28	2014-07-10	2014-03-06		0	?	2014-07-03	0	0004748464			20140703.ifs	2014-07-03	2014-07-04
1368077	1368077	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.060856		00	?	2013-09-27	2013-12-18	2013-09-13		0	?	2013-12-13	0	0004628660			20131213.ifs	2013-12-13	2013-12-14
1231998	1231998	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.037848		00	?	2013-03-28	2013-07-08	2013-03-13		0	?	2013-07-02	0	0004540752			20130702.ifs	2013-07-02	2013-07-03
1036106	1036106	DIVIDEND	DELETE	07986W102		0		1	0	.045333		00	?	2012-09-27	2012-12-17	?		0	2012-12-11	?	0	0004428497			20121212.ifs	2012-12-12	2012-12-13
1036107	1036107	DIVIDEND	ADD	07986W102		0	0	1	0	.045333	0	00	?	2012-09-27	2012-12-17	2012-09-12		0	?	2012-12-12	0	0004428497			20121212.ifs	2012-12-12	2012-12-13
1036108	1036108	DIVIDEND	CHANGE	07986W102		0	0	1	0	.045333	0	00	?	2012-09-27	2012-12-17	2012-09-12		0	?	2012-12-12	0	0004428497			20121212.ifs	2012-12-12	2012-12-13
1036109	1036108	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.045333	0	00	?	2012-09-27	2012-12-17	2012-09-12		0	?	2012-12-12	0	0004428497			20121212.ifs	2012-12-12	2012-12-13
1035905	1035905	DIVIDEND	ADD	07986W102		0		1	0	.045333		00	?	2012-09-27	2012-12-17	?		0	2012-12-11	?	0	0004428497			20121211.ifs	2012-12-11	2012-12-12
956173	956173	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2012-09-27	?	2012-09-12		0	2012-09-12	?	0	0004428497			20120913.ifs	2012-09-13	2012-09-14
955298	955298	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2012-09-27	?	2012-09-12		0	2012-09-12	?	0	0004428497			20120912.ifs	2012-09-12	2012-09-13
901614	901614	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.047063		00	?	2012-03-29	2012-07-09	2012-03-12		0	?	2012-07-02	0	0004344792			20120702.ifs	2012-07-02	2012-07-03
901615	901615	DIVIDEND	CHANGE	07986W102		0	0	1	0	.048225	0	00	?	2011-09-29	2011-12-19	2011-09-13		0	?	2011-12-12	0	0004241915			20120702.ifs	2012-07-02	2012-07-03
901616	901615	DIVIDEND	CHANGE	07986W102	No Ex-Date set by NBB.	0	0	1	0	.048225	0	00	?	2011-09-29	2011-12-19	2011-09-13		0	?	2012-07-02	0	0004241915			20120702.ifs	2012-07-02	2012-07-03
718517	718517	DIVIDEND	DELETE	07986W102		0		1	0	.048225		00	?	2011-09-29	2011-12-19	?		0	2011-12-09	?	0	0004241915			20111212.ifs	2011-12-12	2011-12-13
718518	718518	DIVIDEND	ADD	07986W102		0	0	1	0	.048225	0	00	?	2011-09-29	2011-12-19	2011-09-13		0	?	2011-12-12	0	0004241915			20111212.ifs	2011-12-12	2011-12-13
717942	717942	DIVIDEND	ADD	07986W102		0		1	0	.048225		00	?	2011-09-29	2011-12-19	?		0	2011-12-09	?	0	0004241915			20111209.ifs	2011-12-09	2011-12-10
642956	642956	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2011-09-29	?	2011-09-13		0	2011-09-13	?	0	0004241915			20110914.ifs	2011-09-14	2011-09-15
642028	642028	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2011-09-29	?	2011-09-13		0	2011-09-13	?	0	0004241915			20110913.ifs	2011-09-13	2011-09-14
582119	582119	DIVIDEND	DELETE	07986W102		0		1	0	.046405		00	?	2011-03-30	2011-07-11	?		0	2011-07-01	?	0	0004159741			20110705.ifs	2011-07-05	2011-07-06
582120	582120	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.046405	0	00	?	2011-03-30	2011-07-11	2011-03-16		0	?	2011-07-05	0	0004159741			20110705.ifs	2011-07-05	2011-07-06
581678	581678	DIVIDEND	ADD	07986W102		0		1	0	.046405		00	?	2011-03-30	2011-07-11	?		0	2011-07-01	?	0	0004159741			20110701.ifs	2011-07-01	2011-07-02
473060	473060	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2011-03-30	?	2011-03-16		0	2011-03-16	?	0	0004159741			20110317.ifs	2011-03-17	2011-03-18
375690	375690	DIVIDEND	DELETE	07986W102		0		1	0	.04461		00	?	2010-09-29	2010-12-20	?		0	2010-12-09	?	0	0004059639			20101210.ifs	2010-12-10	2010-12-11
375691	375691	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.04461	0	00	?	2010-09-29	2010-12-20	2010-09-14		0	?	2010-12-10	0	0004059639			20101210.ifs	2010-12-10	2010-12-11
375579	375579	DIVIDEND	ADD	07986W102		0		1	0	.04461		00	?	2010-09-29	2010-12-20	?		0	2010-12-09	?	0	0004059639			20101209.ifs	2010-12-09	2010-12-10
307659	307659	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2010-09-29	?	2010-09-14		0	2010-09-14	?	0	0004059639			20100915.ifs	2010-09-15	2010-09-16
306559	306559	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2010-09-29	?	2010-09-14		0	2010-09-14	?	0	0004059639			20100914.ifs	2010-09-14	2010-09-15
249090	249090	DIVIDEND	DELETE	07986W102		0		1	0	.04221		00	?	2010-03-30	2010-07-16	?		0	2010-07-13	?	0	0003977893			20100714.ifs	2010-07-14	2010-07-15
249091	249091	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	0	1	0	.04221	0	00	?	2010-03-30	2010-07-16	2010-03-15		0	?	2010-07-14	0	0003977893			20100714.ifs	2010-07-14	2010-07-15
248988	248988	DIVIDEND	ADD	07986W102		0		1	0	.04221		00	?	2010-03-30	2010-07-16	?		0	2010-07-13	?	0	0003977893			20100713.ifs	2010-07-13	2010-07-14
132936	132936	DIVIDEND	DELETE	07986W102		0	0	1	6	0		08	?	2010-03-30	?	2010-03-15		0	2010-03-15	?	0	0003977893			20100316.ifs	2010-03-16	2010-04-07
132823	132823	DIVIDEND	ADD	07986W102		0	0	1	6	0		08	?	2010-03-30	?	2010-03-15		0	2010-03-15	?	0	0003977893			20100315.ifs	2010-03-15	2010-04-07
47663	47663	DIVIDEND	DELETE	07986W102		0		1	0	.04238		00	?	2009-09-29	2009-12-21	?		0	2009-12-10	?	0	0003881722			20091211.ifs	2009-12-11	2010-04-07
47664	47664	DIVIDEND	ADD	07986W102	No Ex-Date set by NBB.	0	1	1	0	.04238	0	14	?	2009-09-29	2009-12-21	2009-12-10		0	?	2009-12-11	0	0003881722			20091211.ifs	2009-12-11	2010-04-07
47573	47573	DIVIDEND	ADD	07986W102		0		1	0	.04238		00	?	2009-09-29	2009-12-21	?		0	2009-12-10	?	0	0003881722			20091210.ifs	2009-12-10	2010-04-07

Old 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

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 = 145600
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