Update Company
Name Pricing Date  2024-03-31(LQAP)    
CompId   Stop Date volume LQStart
Ticker Price avevol LQEnd
Cusip Last Trade open LQAve
Sector Country high
   
MktCap CompNum low
yearlylow
Shares Out Type1 prevClose
yearlyhigh
Last_ShsOut    Exchange  
     
  09-30 12-25 sic Code      
Description cik  Updated
  Notes PAGE RESET
  Run AOS Charts Yahoo AOS Profile
  Run AOS Institutional Summary Yahoo AOS Key Statisics
  J3 Open AOS Pricing Yahoo AOS Pricing
  J3 AOS Insider   J3 AOS Insitutions Yahoo AOS Holders
     
  Open up Sector/Exchange Map Fidelity AOS Lookup
  Open up sec.gov For Market Ca MSN AOS Lookup
     
  2001-01-01 shsout made up date to make % good  
  0009-09-09 sdate Dead Company  
  2010-12-25 shsout Took From Yahoo  
  9000010176 Next Fake CIK to use
   


INSITITUIONS Dynamic newInstitTable Changed the Cusip/Sector/Shs Out?
Old Cusips
 

Fix Cusip issue where all new and deleted Instittuional Holdings
Current Quarter Date: ie: 2012-06-30
Should We Update The database:
BackUp query is below under BACK UP Institutions before committing.

Total Insititutions : 685 628   Update Insititution By Cusips
% Owned by Insititutions: 82.74 % 86.72 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:135046
New Old Cusip
 

Splits :
 reportDate : 
  ratio : 
  endQuaterAffected : 
  dayFrom  :
  dayTo  :
 

reportDate ratio endQuaterAffected dayFrom dayTo

To Upper  



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
5537180 5537180 DIVIDEND ADD 831865209 0 0 1 0 .32 00 2024-04-29 2024-04-30 2024-05-15 2024-04-09 0 2024-04-09 ? 0 0006905709 20240409.ifs 2024-04-09 2024-04-10
5480724 5480724 DIVIDEND ADD 831865209 0 0 1 0 .32 00 2024-01-30 2024-01-31 2024-02-15 2024-01-16 0 2024-01-16 ? 0 0006864743 20240116.ifs 2024-01-16 2024-01-17
5394053 5394053 DIVIDEND ADD 831865209 0 0 1 0 .32 00 2023-10-30 2023-10-31 2023-11-15 2023-10-09 0 2023-10-09 ? 0 0006798227 20231009.ifs 2023-10-09 2023-10-10
5333333 5333333 DIVIDEND ADD 831865209 0 0 1 0 .3 00 2023-07-28 2023-07-31 2023-08-15 2023-07-10 0 2023-07-10 ? 0 0006755470 20230710.ifs 2023-07-10 2023-07-11
5269693 5269693 DIVIDEND ADD 831865209 0 0 1 0 .3 00 2023-04-27 2023-04-28 2023-05-15 2023-04-10 0 2023-04-10 ? 0 0006711869 20230410.ifs 2023-04-10 2023-04-11
5212533 5212533 DIVIDEND ADD 831865209 0 0 1 0 .3 00 2023-01-30 2023-01-31 2023-02-15 2023-01-17 0 2023-01-17 ? 0 0006670486 20230117.ifs 2023-01-17 2023-01-18
5120256 5120256 DIVIDEND ADD 831865209 0 0 1 0 .3 00 2022-10-28 2022-10-31 2022-11-15 2022-10-12 0 2022-10-13 ? 0 0006599432 20221013.ifs 2022-10-13 2022-10-14
5056738 5056738 DIVIDEND ADD 831865209 0 0 1 0 .28 00 2022-07-28 2022-07-29 2022-08-15 2022-07-11 0 2022-07-11 ? 0 0006555009 20220711.ifs 2022-07-11 2022-07-12
4992405 4992405 DIVIDEND ADD 831865209 0 0 1 0 .28 00 2022-04-28 2022-04-29 2022-05-16 2022-04-11 0 2022-04-11 ? 0 0006510610 20220411.ifs 2022-04-11 2022-04-12
4935580 4935580 DIVIDEND ADD 831865209 0 0 1 0 .28 00 2022-01-28 2022-01-31 2022-02-15 2022-01-18 0 2022-01-18 ? 0 0006468995 20220118.ifs 2022-01-18 2022-01-19
4825382 4825382 DIVIDEND ADD 831865209 0 0 1 0 .28 00 2021-10-28 2021-10-29 2021-11-15 2021-10-11 0 2021-10-11 ? 0 0006383428 20211011.ifs 2021-10-11 2021-10-12
4756156 4756156 DIVIDEND ADD 831865209 0 0 1 0 .26 00 2021-07-29 2021-07-30 2021-08-16 2021-07-12 0 2021-07-12 ? 0 0006339217 20210712.ifs 2021-07-12 2021-07-13
4680189 4680189 DIVIDEND ADD 831865209 0 0 1 0 .26 00 2021-04-29 2021-04-30 2021-05-17 2021-04-12 0 2021-04-12 ? 0 0006294143 20210412.ifs 2021-04-12 2021-04-13
4606997 4606997 DIVIDEND ADD 831865209 0 0 1 0 .26 00 2021-01-28 2021-01-29 2021-02-16 2021-01-15 0 2021-01-15 ? 0 0006252413 20210115.ifs 2021-01-15 2021-01-16
4485107 4485107 DIVIDEND ADD 831865209 0 0 1 0 .26 00 2020-10-29 2020-10-30 2020-11-16 2020-10-12 0 2020-10-12 ? 0 0006174918 20201012.ifs 2020-10-12 2020-10-13
4418501 4418501 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2020-07-30 2020-07-31 2020-08-17 2020-07-13 0 2020-07-13 ? 0 0006130397 20200713.ifs 2020-07-13 2020-07-14
4287719 4287719 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2020-04-29 2020-04-30 2020-05-15 2020-04-14 0 2020-04-14 ? 0 0006085311 20200414.ifs 2020-04-14 2020-04-15
4287835 4287835 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2020-04-29 2020-04-30 2020-05-15 2020-04-14 0 2020-04-14 ? 0 0006085311 20200414.ifs 2020-04-14 2020-04-15
4171990 4171990 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2020-01-30 2020-01-31 2020-02-18 2020-01-16 0 2020-01-17 ? 0 0006043331 20200117.ifs 2020-01-17 2020-01-18
4172045 4172045 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2020-01-30 2020-01-31 2020-02-18 2020-01-16 0 2020-01-17 ? 0 0006043331 20200117.ifs 2020-01-17 2020-01-18
3971773 3971773 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2019-10-30 2019-10-31 2019-11-15 2019-10-10 0 2019-10-11 ? 0 0005962032 20191011.ifs 2019-10-11 2019-10-12
3971776 3971776 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2019-10-30 2019-10-31 2019-11-15 2019-10-10 0 2019-10-11 ? 0 0005962032 20191011.ifs 2019-10-11 2019-10-12
3831277 3831277 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2019-07-30 2019-07-31 2019-08-15 2019-07-08 0 2019-07-09 ? 0 0005915377 20190709.ifs 2019-07-09 2019-07-10
3831280 3831280 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2019-07-30 2019-07-31 2019-08-15 2019-07-08 0 2019-07-09 ? 0 0005915377 20190709.ifs 2019-07-09 2019-07-10
3679855 3679855 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2019-04-29 2019-04-30 2019-05-15 2019-04-08 0 2019-04-09 ? 0 0005869405 20190409.ifs 2019-04-09 2019-04-10
3679858 3679858 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2019-04-29 2019-04-30 2019-05-15 2019-04-08 0 2019-04-09 ? 0 0005869405 20190409.ifs 2019-04-09 2019-04-10
3552032 3552032 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2019-01-30 2019-01-31 2019-02-15 2019-01-16 0 2019-01-16 ? 0 0005826531 20190116.ifs 2019-01-16 2019-01-17
3552055 3552055 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2019-01-30 2019-01-31 2019-02-15 2019-01-16 0 2019-01-16 ? 0 0005826531 20190116.ifs 2019-01-16 2019-01-17
3326648 3326648 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2018-10-30 2018-10-31 2018-11-15 2018-10-09 0 2018-10-09 ? 0 0005740204 20181009.ifs 2018-10-09 2018-10-10
3326708 3326708 DIVIDEND ADD 831865209 0 0 1 0 .22 00 2018-10-30 2018-10-31 2018-11-15 2018-10-09 0 2018-10-09 ? 0 0005740204 20181009.ifs 2018-10-09 2018-10-10
3188686 3188686 DIVIDEND ADD 831865209 0 0 1 0 .18 00 2018-07-30 2018-07-31 2018-08-15 2018-07-09 0 2018-07-10 ? 0 0005692738 20180710.ifs 2018-07-10 2018-07-11
3188687 3188687 DIVIDEND ADD 831865209 0 0 1 0 .18 00 2018-07-30 2018-07-31 2018-08-15 2018-07-09 0 2018-07-10 ? 0 0005692738 20180710.ifs 2018-07-10 2018-07-11
3033350 3033350 DIVIDEND ADD 831865209 0 0 1 0 .18 00 2018-04-27 2018-04-30 2018-05-15 2018-04-09 0 2018-04-09 ? 0 0005646170 20180409.ifs 2018-04-09 2018-04-10
3033351 3033351 DIVIDEND ADD 831865209 0 0 1 0 .18 00 2018-04-27 2018-04-30 2018-05-15 2018-04-09 0 2018-04-09 ? 0 0005646170 20180409.ifs 2018-04-09 2018-04-10
2922549 2922549 DIVIDEND ADD 831865209 0 0 1 0 .18 00 2018-01-30 2018-01-31 2018-02-15 2018-01-19 0 2018-01-19 ? 0 0005602599 20180119.ifs 2018-01-19 2018-01-20
2922574 2922574 DIVIDEND ADD 831865209 0 0 1 0 .18 00 2018-01-30 2018-01-31 2018-02-15 2018-01-19 0 2018-01-19 ? 0 0005602599 20180119.ifs 2018-01-19 2018-01-20
2719974 2719974 DIVIDEND ADD 831865209 0 0 1 0 .14 00 2017-10-30 2017-10-31 2017-11-15 2017-10-09 0 2017-10-10 ? 0 0005513863 20171010.ifs 2017-10-10 2017-10-11
2619260 2619260 DIVIDEND ADD 831865209 0 0 1 0 .14 00 2017-07-27 2017-07-31 2017-08-15 2017-07-10 0 2017-07-11 ? 0 0005467525 20170711.ifs 2017-07-11 2017-07-12
2541319 2541319 DIVIDEND ADD 831865209 0 0 1 0 .14 00 2017-04-26 2017-04-28 2017-05-15 2017-04-12 0 2017-04-12 ? 0 0005421003 20170412.ifs 2017-04-12 2017-04-13
2318549 2318549 DIVIDEND ADD 831865209 0 0 1 1 .12 06 2016-10-27 2016-10-31 2016-11-15 2016-10-06 0 2016-10-07 ? 0 0005297179 20161007.ifs 2016-10-07 2016-10-08
2290046 2290046 DIVIDEND DELETE 831865209 0 0 5 0 1 10 ? 2016-09-21 2016-10-05 2016-09-07 0 2016-09-07 ? 0 0005278433 20160908.ifs 2016-09-08 2016-09-09
2290047 2290047 DIVIDEND ADD 831865209 0 0 5 0 1 10 2016-10-06 2016-09-21 2016-10-05 2016-09-07 1 2016-09-07 2016-09-08 0 0005278433 20160908.ifs 2016-09-08 2016-09-09
2290048 2290048 SPLIT ADD 831865209 .5 2016-10-06 10 2016-09-08 ? 20160908.ifs 2016-09-08 2016-09-09
2289410 2289410 DIVIDEND ADD 831865209 0 0 5 0 1 10 ? 2016-09-21 2016-10-05 2016-09-07 0 2016-09-07 ? 0 0005278433 20160907.ifs 2016-09-07 2016-09-08
2249715 2249715 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2016-07-27 2016-07-29 2016-08-15 2016-07-11 0 2016-07-12 ? 0 0005250894 20160712.ifs 2016-07-12 2016-07-13
2162582 2162582 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2016-04-27 2016-04-29 2016-05-16 2016-04-11 0 2016-04-11 ? 0 0005204948 20160411.ifs 2016-04-11 2016-04-12
2097556 2097556 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2016-02-03 2016-02-05 2016-02-16 2016-01-25 0 2016-01-25 ? 0 0005162164 20160125.ifs 2016-01-25 2016-01-26
1989958 1989958 DIVIDEND ADD 831865209 0 0 1 0 .19 00 2015-10-28 2015-10-30 2015-11-16 2015-10-13 0 2015-10-13 ? 0 0005079361 20151013.ifs 2015-10-13 2015-10-14
1916229 1916229 DIVIDEND ADD 831865209 0 0 1 0 .19 00 2015-07-29 2015-07-31 2015-08-17 2015-07-13 0 2015-07-14 ? 0 0005032431 20150714.ifs 2015-07-14 2015-07-15
1839276 1839276 DIVIDEND ADD 831865209 0 0 1 0 .19 00 2015-04-28 2015-04-30 2015-05-15 2015-04-13 0 2015-04-13 ? 0 0004985749 20150413.ifs 2015-04-13 2015-04-14
1774766 1774766 DIVIDEND ADD 831865209 0 0 1 0 .19 00 2015-02-04 2015-02-06 2015-02-17 2015-01-26 0 2015-01-26 ? 0 0004944106 20150126.ifs 2015-01-26 2015-01-27
1657056 1657056 DIVIDEND ADD 831865209 0 0 1 0 .15 00 2014-10-29 2014-10-31 2014-11-17 2014-10-13 0 2014-10-14 ? 0 0004859430 20141014.ifs 2014-10-14 2014-10-15
1576554 1576554 DIVIDEND ADD 831865209 0 0 1 0 .15 00 2014-07-29 2014-07-31 2014-08-15 2014-07-08 0 2014-07-08 ? 0 0004813931 20140708.ifs 2014-07-08 2014-07-09
1492596 1492596 DIVIDEND ADD 831865209 0 0 1 0 .15 00 2014-04-28 2014-04-30 2014-05-15 2014-04-07 0 2014-04-07 ? 0 0004767115 20140407.ifs 2014-04-07 2014-04-08
1468007 1468007 DIVIDEND CHANGE 831865209 0 0 1 0 .15 00 2014-02-05 2014-02-07 2014-02-18 2014-01-28 0 2014-01-28 ? 0 0004726365 20140317.ifs 2014-03-17 2014-03-18
1468008 1468007 DIVIDEND CHANGE 831865209 0 0 1 0 .15 00 2014-02-05 2014-02-07 2014-02-18 2014-01-28 1 2014-01-28 2014-03-17 0 0004726365 20140317.ifs 2014-03-17 2014-03-18
1428582 1428582 DIVIDEND ADD 831865209 0 0 1 0 .15 00 2014-02-05 2014-02-07 2014-02-18 2014-01-28 0 2014-01-28 ? 0 0004726365 20140128.ifs 2014-01-28 2014-01-29
1314677 1314677 DIVIDEND ADD 831865209 0 0 1 0 .12 00 2013-10-29 2013-10-31 2013-11-15 2013-10-09 0 2013-10-10 ? 0 0004644914 20131010.ifs 2013-10-10 2013-10-11
1237418 1237418 DIVIDEND ADD 831865209 0 0 1 1 .12 06 2013-07-29 2013-07-31 2013-08-15 2013-07-08 0 2013-07-09 ? 0 0004600570 20130709.ifs 2013-07-09 2013-07-10
1185197 1185197 DIVIDEND CHANGE 831865209 0 0 5 0 1 0 10 2013-05-16 2013-04-30 2013-05-15 2013-04-15 0 ? 2013-04-16 1 0004558089 20130514.ifs 2013-05-14 2013-05-15
1185198 1185197 DIVIDEND CHANGE 831865209 0 0 5 0 1 0 10 2013-05-16 2013-04-30 2013-05-15 2013-04-15 0 ? 2013-05-14 1 0004558089 20130514.ifs 2013-05-14 2013-05-15
1160240 1160240 DIVIDEND DELETE 831865209 0 0 5 0 1 10 ? 2013-04-30 2013-05-15 2013-04-15 0 2013-04-15 ? 1 0004558089 20130416.ifs 2013-04-16 2013-04-17
1160241 1160241 DIVIDEND ADD 831865209 0 0 5 0 1 0 10 2013-05-16 2013-04-30 2013-05-15 2013-04-15 0 ? 2013-04-16 1 0004558089 20130416.ifs 2013-04-16 2013-04-17
1160796 1160796 DIVIDEND CHANGE 831865209 0 0 5 0 1 0 10 2013-05-16 2013-04-30 2013-05-15 2013-04-15 0 ? 2013-04-16 1 0004558089 20130416.ifs 2013-04-16 2013-04-17
1160797 1160796 DIVIDEND CHANGE 831865209 0 0 5 0 1 0 10 2013-05-16 2013-04-30 2013-05-15 2013-04-15 0 ? 2013-04-16 1 0004558089 20130416.ifs 2013-04-16 2013-04-17
1160798 1160798 SPLIT ADD 831865209 .5 2013-05-16 10 2013-04-16 ? 20130416.ifs 2013-04-16 2013-04-17
1159956 1159956 DIVIDEND ADD 831865209 0 0 5 0 1 10 ? 2013-04-30 2013-05-15 2013-04-15 0 2013-04-15 ? 1 0004558089 20130415.ifs 2013-04-15 2013-04-16
1159957 1159957 DIVIDEND ADD 831865209 0 0 1 0 .24 00 2013-04-25 2013-04-29 2013-05-14 2013-04-15 0 2013-04-15 ? 0 0004558087 20130415.ifs 2013-04-15 2013-04-16
1090511 1090511 DIVIDEND ADD 831865209 0 0 1 0 .2 00 2013-01-29 2013-01-31 2013-02-15 2013-01-15 0 2013-01-15 ? 0 0004515321 20130115.ifs 2013-01-15 2013-01-16
982981 982981 DIVIDEND ADD 831865209 0 0 1 0 .2 00 2012-10-29 2012-10-31 2012-11-15 2012-10-08 0 2012-10-09 ? 0 0004444386 20121009.ifs 2012-10-09 2012-10-10
910207 910207 DIVIDEND ADD 831865209 0 0 1 0 .2 00 2012-07-27 2012-07-31 2012-08-15 2012-07-09 0 2012-07-09 ? 0 0004401922 20120709.ifs 2012-07-09 2012-07-10
835928 835928 DIVIDEND ADD 831865209 0 0 1 0 .16 00 2012-04-26 2012-04-30 2012-05-15 2012-04-16 0 2012-04-16 ? 0 0004361877 20120416.ifs 2012-04-16 2012-04-17
756637 756637 DIVIDEND ADD 831865209 0 0 1 0 .16 00 2012-01-27 2012-01-31 2012-02-15 2012-01-13 0 2012-01-13 ? 0 0004320919 20120113.ifs 2012-01-13 2012-01-14
670826 670826 DIVIDEND ADD 831865209 0 0 1 0 .16 00 2011-10-27 2011-10-31 2011-11-15 2011-10-10 0 2011-10-11 ? 0 0004256727 20111011.ifs 2011-10-11 2011-10-12
586246 586246 DIVIDEND ADD 831865209 0 0 1 0 .16 00 2011-07-27 2011-07-29 2011-08-15 2011-07-11 0 2011-07-12 ? 0 0004216070 20110712.ifs 2011-07-12 2011-07-13
500922 500922 DIVIDEND ADD 831865209 0 0 1 0 .14 00 2011-04-27 2011-04-29 2011-05-16 2011-04-12 0 2011-04-12 ? 0 0004174851 20110412.ifs 2011-04-12 2011-04-13
418952 418952 DIVIDEND ADD 831865209 0 0 1 1 .14 06 2011-01-27 2011-01-31 2011-02-15 2011-01-14 0 2011-01-14 ? 0 0004134960 20110114.ifs 2011-01-14 2011-01-15
336228 336228 DIVIDEND DELETE 831865209 0 0 5 0 .5 10 ? 2010-10-29 2010-11-15 2010-10-14 1 2010-10-14 2010-10-15 1 0004074822 20101018.ifs 2010-10-18 2010-10-19
336229 336229 DIVIDEND ADD 831865209 0 0 5 0 .5 0 10 2010-11-16 2010-10-29 2010-11-15 2010-10-14 0 ? 2010-10-18 1 0004074822 20101018.ifs 2010-10-18 2010-10-19
336230 336230 SPLIT ADD 831865209 .6666666667 2010-11-16 10 ? 2010-10-18 20101018.ifs 2010-10-18 2010-10-19
335757 335757 DIVIDEND DELETE 831865209 0 0 5 0 .5 10 ? 2010-10-25 2010-11-05 2010-10-14 0 2010-10-14 ? 1 0004074822 20101015.ifs 2010-10-15 2010-10-16
335758 335758 DIVIDEND ADD 831865209 0 0 5 0 .5 10 ? 2010-10-29 2010-11-15 2010-10-14 1 2010-10-14 2010-10-15 1 0004074822 20101015.ifs 2010-10-15 2010-10-16
335139 335139 DIVIDEND ADD 831865209 0 0 5 0 .5 10 ? 2010-10-25 2010-11-05 2010-10-14 0 2010-10-14 ? 1 0004074822 20101014.ifs 2010-10-14 2010-10-15
332929 332929 DIVIDEND ADD 831865209 0 0 1 0 .21 00 2010-10-27 2010-10-29 2010-11-15 2010-10-11 0 2010-10-11 ? 0 0004074398 20101011.ifs 2010-10-11 2010-10-12
258707 258707 DIVIDEND ADD 831865209 0 0 1 0 .21 00 2010-07-28 2010-07-30 2010-08-16 2010-07-23 0 2010-07-23 ? 0 0004036165 20100723.ifs 2010-07-23 2010-07-24
157687 157687 DIVIDEND ADD 831865209 0 0 1 0 .195 00 2010-04-28 2010-04-30 2010-05-17 2010-04-12 0 2010-04-12 ? 0 0003992865 20100412.ifs 2010-04-12 2010-04-13
88973 88973 DIVIDEND ADD 831865209 0 0 1 0 .195 00 2010-01-27 2010-01-29 2010-02-16 2010-01-15 0 2010-01-15 ? 0 0003953828 20100115.ifs 2010-01-15 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


Your Name Click here to open the child window


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