A new steel door may not sound like the sexiest addition to your house, but it's one of the financially savviest. According to Remodeling Magazine's 2014 Cost V. Value report, homeowners who install a steel door can expect to recoup nearly 97 percent of the cost when the home sells.
Exterior work on a property, from new siding to replacing windows, dominate the list of projects that offer the biggest bang for your buck. They offer the largest return because a potential home sale can be made or broken on the exterior alone, real estate agents say.
"It's all about first impression, no question about that," said John Kmiecik, regional vice president for the National Association of Realtors and a Chicago-area real estate agent. "When I'm sitting with my buyers in my car and we pull up to a home, if it doesn't look halfway decent, my buyers in many cases say, 'John let's take a pass on this, because I just don't like the outside.' "
Buyers typically assume that if the exterior of the house hasn't been maintained, then the interior hasn't either, Kmiecik said.
So does a steel door really make that big of an impression? Not necessarily, but it improves security and offers energy savings through better insulation. That's the other reason exterior projects also push up the value of a home -- they tend to be practical. Unlike adding luxurious finishes to a kitchen that a new owner may not adore, new siding or new windows generally appeal to any buyer.
Remodeling Magazine's quoted cost includes updating an existing 5-by-7-foot bathroom and replacing all fixtures, including installing a porcelain-on-steel tub with ceramic tile around it, new shower, standard toilet and new tile floor.
Buyers are definitely impressed by finished basements, Kmiecik said. Remodeling Magazine includes in its cost a 20-by-30-foot entertaining area with wet bar and a bathroom. However, finishing your basement may not necessarily add value in an appraiser's eyes, as an appraiser typically counts living space above grade only, Kmiecik said.
New windows look sharper, insulate a home better, save on energy and, for buyers, avoid the cost and hassle of doing upgrades. Wood is the preferred trim finish, but other replacement window projects also pay off. A more upscale version costs $16,798 and has an ROI of 74 percent. Vinyl window replacements cost about $9,978 and have an ROI of 78.7 percent, while a more upscale version costs $13,385 and has a 76.6 percent ROI.
The kitchen is always a good place to invest money, because it's the heart of the home, Kmiecik said.
"Whenever I take buyers to look at a home, we spend most of the time standing in the kitchen, sitting at the table, getting a feel for how this kitchen will fit into your lifestyle," he said. "It definitely adds value. Just be careful not to overdo it."
A major kitchen remodel, meanwhile, would cost $54,909 and has a 74.2 percent ROI.
Replacing your garage door is another way to improve the exterior of your home. But while it's typically inexpensive, an upgrade isn't necessary unless your garage door is old, beat-up or a particularly visible part of your home. A more upscale version would cost $2,791 and offers an 83 percent ROI.
Converting an attic to a bedroom, especially when you can also add a bathroom, adds value in the same way as a two-story addition. While it will not add to the square footage of the overall home, it does add another bedroom. That puts a home in another category, allowing sellers to charge more.
While fiber cement siding is typically tougher and more fire-resistant than vinyl siding, it is significantly more expensive. Other siding replacement projects also came in strong. Vinyl siding replacement costs about $9,978 and has a 78.7 percent ROI; foam-backed vinyl siding replacement costs $14,236 and has a 78.1 percent ROI.
Only two years ago, wooden decks recouped about 70 percent of their value, having dropped during the recession. But with the economy improving and outdoor spaces becoming more popular, buyer interest is again piqued by a quality wood deck out back. The cost assumes a 16-by-20-foot deck with built-in bench and planter, stairs and railings.
A composite deck will also pay off, but not quite as much. A composite deck costs about $15,437 nationally and has an ROI of 74.3 percent.
Because of their low cost and durability, adding steel entry doors typically offers the highest return on investment of all home improvement projects, according to Remodeling Magazine.


Rosemary is one of the best and well-known herbs of all time — and not for no reason. Its woodsy, mint-like flavor works wonders in the kitchen (here's looking at you, rosemary garlic butter, rosemary potatoes, and rosemary olive oil), but cooking isn't rosemary's only use.
These 4 ways to use rosemary are absolutely divine and totally unexpected. With these uses on hand (+ rosemary's notoriety for improving moods, boosting memory, and detoxifying systems), we fully expect rosemary to quickly become a staple in your life.
Psst! If you're growing a fresh Inbox of Herbs, your Rosemary needs 6 + hours of sunlight to thrive and only needs to be watered when the top of the soil is dry to the touch.
It's the perfect sweetener for ricotta, warm bread, or your favorite tea. With a woodsy scent and slight minty flair, this honey also works as a glaze on your savory dishes like poultry or pork. The natural flavors of the honey and the rosemary come together for a sweet floral and earthy tone you'll crave on everything.
Using a pestle or cocktail muddler, lightly bruise the needles on 5 3-inch rosemary needles. Combine the rosemary and 1 cup honey in a small saucepan with the honey and warm over moderately low heat for 5 minutes. Remove from the heat and let stand for 30 minutes. Remove rosemary stems from the honey and enjoy!
If you think some of the flowers you purchase from a florist or local market have lost some of their special scents, you're not wrong. As consumers demand better-looking blooms, growers have been breeding their flowers for their appearance rather than their smell. To solve this aromatic lack, try using rosemary! Turn your fresh cut flowers to a great smelling centerpiece is easy by simply adding a few sprigs to your newest bouquet. It's a quick way to add a lovely scent to your arrangement without sacrificing the blooms.
If you're like us, one of the most exciting parts of giving a gift is deciding how to wrap it — and we're not alone. According to one gift wrap volunteer at St. Michaels Women's Exchange in Dallas, "A beautifully presented present always leaves a lasting impression, and first impressions last." So, next time you wrap up a cute gift — big or small, place a sprig of Rosemary on top. It's absolutely stunning. Besides, it enlivens the senses before the present is even opened.
A bowl of freshly popped popcorn turns any old flick into the happiest of movie nights. Movie or not, popcorn is essentially the perfect snack — especially when it's dressed in your favorite flavors. One of our garden-inspired favorites that practically explodes with flavor is rosemary popcorn. Whether you enjoy a handful or bowl this treat is a great way to keep everyone happy.
Transfer the air-popped popcorn to a brown shopping bag, toss the remaining ingredients into the bag, shake and serve.
These are our four unique ways to utilize our freshly-harvested rosemary. How do you use yours?


For those of you who do not stray to far from the main blog, here is a quick summary of the posts from January 2010 Pallimed: Arts & Humanities blog by Amy Clarkson, MD and Amber Wollesen, MD.
Amber reviews the multiple themes around death in the popular series of the boy wizard.
Amy discusses a writer/photographer's first hand account of watching her husband succumb to Alzheimer's. The author even commented on the post!
Amber talks about the 2001 film and palliative care themes around the sense of time in a chronic illness.
In this post, the story of an unclaimed body is something we occasionally encounter in hospice and palliative care. Amy explores how different groups have addressed this challenge.


text:
UK piles pressure on Germany with Cleverly pleading for tanks
The Foreign Secretary said he would like "nothing more" than to see Ukrainians armed with Leopard 2 tanks that can hit targets while on the move.
Germany has so far blocked other countries that own its tanks from releasing them to Kyiv under export rules.
James Cleverly refused to directly criticize the German government but said he wants to see a deal to send the equipment.
He said: "The Prime Minister decided quite rightly that the most humane thing to do is to bring this war to a swift conclusion and for the Ukrainians to be successful in the defense of the homeland.
"That is why we made the commitment to significantly increase our military support to Ukraine, to help them defend themselves, including with Challenger 2 tanks.
"I would like nothing more than to see the Ukrainians equipped with those most up-to-date armored vehicles, both tanks and artillery, and others. The Leopard 2 is an incredibly effective piece of military equipment. I would like nothing more than to see the Ukrainians armed with Leopard 2."
Ukrainian President Volodymyr Zelensky pleaded with allies to speed up the delivery of military support in his country's fight against the Russian invasion.
But a conference in Germany on Friday ended without an agreement from Berlin on the supply of its battle tanks.
Poland said Germany's refusal to give it permission to send 14 of the vehicles to Ukraine is "unacceptable".
Around 2,000 Leopard 2s are dotted across European nations.
Britain became the first Western power to agree to send battle tanks with 14 British Army Challenger 2s on the way in the coming weeks.
Mr Cleverly said Germany has been a "huge contributor" of support for Ukraine through hosting of refugees, providing military equipment and economic aid and also through the imposition of sanctions.
He said it was ultimately for every NATO member to decide how they can best support Kyiv.
"The Ukrainians said that they need and want tanks, and they need Western caliber Nato standard tanks," he added. "We provided some Challenger 2s.
"Countries across Nato have provided a range of armored vehicles. Some of that includes light tanks and some of that includes significant artillery.
"We will continue working with our friends and allies across Nato to make sure that the support we give to the Ukrainian armed forces and Ukrainian people are the most effective at helping them defend themselves against this brutal invasion."
Previous: Pope orders probe into lockdown sex party claim at Newcastle Cathedral
Next: Murder investigation launched after man found dead in street

redpajama_set_name: RedPajamaCommonCrawl


text:
Community: Thought Leaders
In 2010, in order to service the needs of its Members and to forge more productive and practical links between the great minds of business academia and the leaders of industry, Criticaleye, the peer-to-peer Board Community, established its own 'Members' Faculty'.
This resulting group of globally acclaimed thinkers now comprises 51 of the biggest names in the world of business thought leadership hailing from 31 schools in 15 countries across 5 continents. 20 are Deans or the Leaders of their organisations and, since 2011, 14 have been included in the Thinkers50 listing of the world's top business thinkers. Nine out of the top 15 Schools in the FT Global MBA Rankings 2015 are represented.
Julian Birkinshaw
Professor of Strategy and Entrepreneurship
TMBC, USA
Bala Chakravarthy
Professor of Strategy and International Management
IMD, Switzerland
Kalok Chan
Wei Lun Professor of Finance & Chairman, Department of Finance
CUHK Business School, Hong Kong
Moira Clark
Professor of Strategic Marketing
Paul Danos
Tuck School of Business at Dartmouth, USA
Stephen Davis
Associate Director, Harvard Law School Programs on Corporate Governance & Institutional Investors
Yuan Ding
Vice President and Dean
China Europe International Business School
Saul Estrin
Professor of Management and Deputy Head of the Department (Strategy and Resources)
Bob Garratt
Professor Extraordinaire; Chairman Centre For Corporate Governance in Africa
University of Stellenbosch Business School, South Africa
Professor of Strategy Management
IESE Business School, Spain
Coxe Distinguished Professor
Lynda Gratton
Professor of Management Practice, Executive Education Faculty Director
Steven Haberman
Professor of Actuarial Science
Anthony Hesketh
Lancaster University Management School
Herminia Ibarra
Professor of Organisational Behaviour
Sheena Iyengar
S.T. Lee Professor of Business Management
Columbia Business School, USA
Dipak Jain
Sasin Graduate Institute of Business Administration, Chulalongkorn University, Thailand
Valery Katkalo
First Vice Rector
Maria Tereza Leme Fleury
Fundação Getulio Vargas (FGV), Brazil
Peggy Liu
JUCCCE, China
Christoph Loch
Cambridge Judge Business School
Peter Lorange
Lorange Institute of Business Zurich, Switzerland
Costas Markides
Founder & President of Roger l. Martin, Inc. and Professor Emeritus, Rotman School of Management
Colin Mayer
Peter Moores Professor of Management Studies
Said Business School, Oxford University
Rita McGrath
Ilian Mihov
David Molian
Senior Lecturer and Director, Business Growth and Development Programme
Cranfield School of Management
Steve Muylle
Professor & Partner
Vlerick Business School
Kjell Nordstrom
Funky Business, Sweden
Ben Page
Kai Peters
Pro-Vice-Chancellor (Faculty of Business and Law)
Coventry University Group
Associate Professor of Organisational Behaviour
Chip Pitts
Lecturer in Law, Stanford Law School and Oxford University
Stanford, USA
Jonas Ridderstrale
Ashridge Business School
The Foundation on Economic Trends, USA
Richard Rumelt
Harry and Elsa Kunin Chair in Business and Society
UCLA Anderson School of Management
Hellmut Schütte
Professor Emeritus of International Management
Han Smit
Professor of Corporate Finance
Erasmus University, Netherlands
Mohan Sodhi
Professor, Operations and Supply Chain Management
Dominic Swords
Visiting Professor of Business Economics
LKCSB Distinguished Term Professor of Strategic Mgmt
Lee Kong Chian School of Business, Singapore Management University, Singapore
Fons Trompenaars
Trompenaars Hampden-Turner, Netherlands
Dominique Turpin
Dean of External Relations
Eric Weber
Professor of Accounting and Control
Adjunct Professor of Management
George Yip
Professor of Marketing and Strategy, and Associate Dean for Executive Programmes
Claudia Zeisberger
Senior Affiliate Professor of Entrepreneurship, Decision Sciences, and Family Enterprise; Academic Director GPEI


There's only a couple of weeks left to get your applications in for the first tranche of Stapledon Innovation and Technology Fellowships. The deadline for the awards, worth up to £3,000 for travel and study related to identifying and developing innovative practices within the grass and forage sector, is 30 November 2016.
Use it or lose it' is the clear message for livestock farmers with unusually abundant grass covers as we move into autumn.
According to Helen Mathieu of forage experts Germinal GB, many parts of the country continue to see grass growth well ahead of an average year, with soil temperatures remaining relatively high. This is an opportunity not to be missed, she insists, and failure to capitalise could even be counter-productive.
The new on-line educational resource at www.sheeplameness.co.ukexplains how to build flock resilience to the infectious causes of lameness and the steps needed to reduce the disease challenge on farm.
As part of the FAIR PLAY campaign on farm-saved seed, the British Society of Plant Breeders (BSPB) is reminding growers that using farm-saved seed of eligible varieties in cover crop mixtures is subject to the same seed regulations and FSS rules as harvested crops.
Interest in the use of cover crops among arable farmers has increased recently in response to CAP greening requirements and as research has demonstrated the rotational benefits of cover crops for soil quality, reduced nutrient losses, and improved weed and disease management.
Eurig Jenkins, a dairy farmer from Pentrefelin Farm near Lampeter, Ceredigion has won the BGS Grassland Farmer of the Year competition. The announcement was made at our awards evening held in Belfast last week, jointly hosted with Ulster Grassland Society and kindly sponsored by Yara and DLF.
The charitable campaign by BGS Corporate Member, Volac, that has seen farms around the country displaying bright pink silage bales in aid of breast cancer research has been hailed a huge success.
According to Jackie Bradley of Volac, the campaign, which raises money from sales of a specially-produced pink version of the film used to wrap the bales, has already raised over £18,500 for the charity, Breast Cancer Now.
After 30 September you must be able to demonstrate compliance with the UK Rodenticide Stewardship requirements before you are allowed to buy and use bait rodenticides.
AHDB has scheduled two webinars, directed at the whole farming sector, which will explain your options.
At the 2016 Livestock Event the Trust and BGS announced the launch of the Stapledon Innovation and Technology Interaction Fellowships.
Somerset Grassland Society have a great tradition of the chairman opening their farm for the group each summer. This year that duty fell to Rachel Horler, who kindly hosted a walk with her husband Joe at their holding, Maundrils Farm, West Huntspill.
Could deeper rooting forage grasses being developed at leading research establishments in the UK offer a sustainable solution to some of the more damaging consequences of climate change?


FOREST CITY, IOWA, November 14, 2017 – Four Waldorf University Creative Writing students were selected to share their poetry at the Streamlines conference held November 11 at Clarke University in Dubuque, Iowa.
Ruth Worrell from Denison, Iowa, Keisha Hendry from Nashua, Iowa, Myriah Hacker from Denison, Iowa and Juno Mulherin from Omaha, Neb., read their poetry as part of a panel. Seven other creative writing students from Waldorf University also attended the conference.
Streamlines is an undergraduate conference celebrating language, literature and writing. This year's conference included eight colleges and universities from four states.
To learn more about Waldorf's creative writing program, please visit waldorf.edu.


text:
Skip to main menu Skip to general content Skip to footer menu
Select country: They are required elements
Select language They are required elements
Return to Avianca.com
Find financial information, general information and updated news about or Company. If you are a shareholder, you can also download your Certificate of Earnings (Available in Spanish).
To browse through the tabs use the arrow keys. Activate tabs using Enter key or Tab key. If you are reading this content through reader press shift + enter in order to access tab content. To return to the tabs, use the Shift and Tab keys
Ordinary bond
Notice of Summons to Avianca's 2018 Ordinary Shareholders Meeting
Power of Attorney for the Ordinary Shareholders Meeting
Power of Attorney for the Extraordinary Shareholders Meeting
Summon of the Extraordinary General Shareholders Meeting
Modification of the Bylaws to be considered by the Shareholders Meeting
2016 – 2018 Board of Directors Election
2016 – 2018 Profiles of the members of the Board of Directors
Appointment of the President
President's Profile
Notice of Summons to the Ordinary Shareholder's Meeting of Avianca 2016
Individual Quarterly Financial Results
2018 December - September - June - March
2013 December - September - June - March
2011 December - September - June - March
Financial Statements 2018
Financial Statements 2011
Avianca S.A.
Management Report 2018
Management Report 2011
Avianca Holdings S.A.
Annual report 2015
Annual report 2011
Corporate Documents
Resumes of Board Members
Ethics Code and Business Behavior Regulations
Good Corporate Governance Code
Policy for Prevention of Sexual Exploitation of Minors
Regulations of the General Shareholder's Meeting
Regulations of the Auditing Committee
Internal Regulations of the Board of Directors
Policy of Money Laundering and Terrorism Financing Risk System (SIPLAFT)
Certificate for the Policy of the Comprehensive System for Risk Control and Prevention of Asset Laundering and Terrorist Financing
Country Code Survey
Country Code Survey 2018
Country Code Survey 2013
Annual Corporate
Governance Report
Annual Corporate Governance Report 2018
Certificate of Financial Yield of Avianca S.A. Ordinary Bonds
Report from Avianca's Legal Representative to the Ordinary Bond Holder's Meeting
Confirmation of the Rating for Avianca 2009 Ordinary Bonds – Fitch Ratings
Opinion of the Legal Representative of Bond Holders
Model for Legal Person Power of Attorney
Model for Natural Person Power of Attorney
Public Offer to Issue Avianca Bonds
Prospect of Bond Placement
Addendum to the Prospect of Bond Placement
Addendum No. 2 to the Prospect of Bond Issuance
Roadshow Presentation
Helm Trust S.A. Contract Legal Representative of Bond Holders
Enter the web site of the Superintendencia Financiera de Colombia
Date
Time
Topic
Summary
Annex
03/05/2019 08:19:25 Reforma de estatutos
Attached is a proposal for the reform of the Statutes that will be presented to the Assembly. See attachment
03/05/2019 08:16:46 Asambleas Extraordinarias Today, El Heraldo newspaper published a notice calling an extraordinary meeting of the General Shareholders' Meeting to be held in the city of Barranquilla on May 9, 2019. See attachment
17:47:06 Cambio de Representantes Legales Retreat of our President. See attachment
15/04/2019 20:55:17 Informes de fin de Ejercicio In compliance with External Circular Letter 004 of 2012, End of Year information is published. See attachment
15/04/2019 20:48:30 Informes de fin de Ejercicio In compliance with External Circular Letter 004 of 2012, consolidated EEFFs are published with a cut-off date of December 31, 2018. See attachment
10/04/2019 17:15:03 Cambio de Junta Directiva Election of Board Members Period 2019-2020. See attachment
10:48:07 Asambleas Extraordinarias Today was published in the newspaper El Heraldo notice calling an extraordinary meeting of the General Meeting of Shareholders to be held in the city of Barranquilla on April 10, 2019. See attachment
Proyecto Utilidad o Pérdida aprobado por Asamblea Approval of the Project for the Non-distribution of Profits. See attachment
21/03/2019 16:18:00 Avisos publicados por la sociedad Election of the Board of Directors. See attachment
21/03/2019 16:09:20 Decisiones de Asamblea Approval of the Management Report and Special Report of the Board of Directors, the President and other Administrators. See attachment
21/03/2019 16:08:21 Decisiones de Asamblea Approval of Financial Statements with cut-off December 31, 2018. See attachment
27/02/2019 09:01:34 Proyecto Utilidad o Perdida a presentar a Asamblea Attached is a Project for the Non-Distribution of Profits that will be presented to the Assembly. See attachment
27/02/2019 08:59:00 Citación a asamblea Ordinaria El Heraldo newspaper published today a notice of call to the ordinary meeting of the General Shareholders' Meeting to be held in the city of Barranquilla on March 21, 2019. See attachment
Codigos de Buen Gobierno In accordance with SFC External Circular Letter 028 of 2014, Avianca transmitted the Best Corporate Practices Report for the period January-December 2018 on January 31st. N/A
18/01/2019 20:02:46 Avisos publicados por la sociedad Decision of the 2009 Ordinary Bondholders Assembly held today.
04/01/2019 11:06:42 Asambleas Tenedores de Bonos
First General Assembly of Ordinary Bond Holders 2009 issued by Avianca (issuer).
15/03/2018 18:15:04 Profit or Loss project approved by the Meeting Relevant decisions approved by the Shareholders Meeting in the ordinary meeting held today. See attachment
15/03/2018 18:13:49 Change of Statutory Auditor Relevant decisions approved by the Shareholders Meeting in the ordinary meeting held today. See attachment
15/03/2018 18:13:20 Change of the Board of Directors Relevant decisions approved by the Shareholders Meeting in the ordinary meeting held today. See attachment
15/03/2018 18:12:40 Notifications published by the company Relevant decisions approved by the Shareholders Meeting in the ordinary meeting held today. See attachment
22:31:10 Profit or Loss Project to be presented before the Meeting The Project of No Profit Sharing and No Payment of Dividends for the 2017 fiscal year is attached. See
16:25:40 Summons to Shareholders Meeting The summons to the ordinary Shareholders Meeting to be held on March 15, 2018 in the city of Barranquilla is attached. See
21:55:49 Notifications published by the Company The Supreme Court ratifies the illegality of this cessation of activities by pilots. See
01/02/2018 12:14:13 Codes of Good Governance Pursuant to External Circular 28 from 2014 of the SFC, Avianca transmitted the Best Corporate Practices Report for the January – December 2017 period on January 30. N/A
26/01/2018 20:41:38 Bylaws Reform Bylaws Reform adopted by the General Shareholders Meeting at the extraordinary meeting held today. See attachment
19/01/2018 11:08:00 Notifications published by the company Summons to the Extraordinary General Shareholders' Meeting, January 26, 2018. See attachment
10/11/2017 16:14:59 Notifications published by the company After 51 days of illegal cessation of activities, pilots affiliated to the ACDAC decided to comply with the law and announced returning to work as of November 13. See attachment
02/11/2017 19:25:28 Notifications published by the company Superior Court of Bogota Reconstructs Hearing. See attachment
31/10/2017 16:14:47 Notifications published by the company Signing of Labor Formalization Agreement between Aerovias del Continente Americano S.A. Avianca, Servicios Aeroportuarios Integrado SAI S.A.S and the Ministry of Labor. See attachment
19/10/2017 21:09:52 Notifications published by the company Decisions adopted at the meeting of the first Meeting of Ordinary Bonds Holders 2009 held today. See attachment
17/10/2017 20:59:20 Notifications published by the company Cundinamarca Administrative Court denied writ of protection action presented by the ACDAC. See attachment
10/10/2017 15:36:15 Bond Holder's Meetings First General Meeting of Ordinary Bond Holders issued by Avianca S.A. (Issuer) 2009. See attachment
06/10/2017 17:08:29 Notifications published by the company Superior Court of the Judicial District of Bogota declares the cessation of activities of ACDAC Pilots illegal. See attachment
22:47:47 Notifications published by the company Ministry of Labor summons an arbitration tribunal to resolve dispute between Avianca – ACDAC See attachment
17:16:47 Notifications published by the company The claim by the Superior District Court of Bogota is admitted See attachment
27/09/2017 19:21:51 Notifications published by the company Avianca remedies claim of illegality for cessation of activities by ACDAC's pilots See attachment
27/09/2017 10:19:36 Notifications published by the company ACDAC did not accept Avianca's final proposal within the established term See attachment
25/09/2017 09:47:26 Notifications published by the company Avianca submits an illegality claim of the ACDAC's pilots cessation of activities. See attachment
22/09/2017 11:58:33 Notifications published by the company Nullity decreed over contempt sentence. See attachment
20/09/2017 15:24:20 Notifications published by the company Negotiations with the Colombian Civil Aviators Association ACDAC. See attachment
15/09/2017 18:18:26 Notifications published by the company Statement regarding the strike called by the Colombian Civil Aviators Association (ACDAC) See attachment
15/09/2017 18:13:41 Notifications published by the company Sanction imposed by the Ministry of Labor. See attachment
12/09/2017 08:39:36 Notifications published by the company ACDAC unilaterally terminates the direct agreement stage. See attachment
04/09/2017 22:33:33 Execution, modification and termination of agreements Execution of aviation fuel procurement agreements with Organizacion Terpel S.A. See attachment
31/08/2017 09:19:13 Notifications published by the company News published in the Media See attachment
16/08/2017 21:17:39 Notifications published by the company Presentation of the List of Demands of the Colombian Civil Aviators Association ACDAC. See attachment
19/07/2017 09:54:09 Securities Rating Fitch publishes AVIANCA S.A.'s technical rating report See attachment
06/07/2017 09:50:11 Securities Rating Fitch confirms Avianca 2009 Bonds Rating at 'A+(col)'; Negative Outlook See attachment
25/04/2017 20:48:50 End of Term Reports In compliance with External Circular 004 from 2012, the end of term information is attached. See attachement
24/04/2017 09:33:21 Notifications published by the company Company notification regarding the statements made by the ACDAC President. See attachement
31/03/2017 15:16:01 Notifications published by the company Avianca signs agreement with the Aviadores de Avianca, ODEAA. See attachement
30/03/2017 11:51:42 Profit or Loss Project approved by the Shareholders Meeting Relevant decisions adopted by the General Shareholders Meeting today. See attachement
30/03/2017 11:48:49 By-laws reform Relevant decisions adopted by the General Shareholders Meeting today. See attachement
10/03/2017 13:02:25 Notifications published by the company Notifications published by the company. See attachement
09/03/2017 08:53:46 Notifications published by the company Clarification of information published on the media. See attachement
07/03/2017 08:46:13 Summons of the Regular Meeting Summons of the Regular General Shareholders Meeting See attachment
02/03/2017 15:26:43 Decisions of the Board of Directors Decisions of the Board of Directors. Summons of the Regular General Shareholders Meeting See attachment
02/03/2017
Profit or Loss Project to be presented before the Meeting
Relevant Decisions of the Board See attachment
02/03/2017 15:10:20 Decisions of the Board of Directors Relevant Decisions of the Board – Reform of the Bylaws. (Note. This file replaces the one published on 02/03/2017 15:03:39) See attachment
17/02/2017 15:45:45 Ads published by the Company Clarification of information published on the media See attachment
01/02/2017 09:57:17 Code of Good Governance In compliance with External Circular No. 028 from 2014, yesterday, the Company transmitted the Country Code survey for 2016. N/A
16/01/2017 16:35:18 Reform of the bylaws Relevant decisions approved at the Shareholders Meeting See attachment
10/01/2017 09:10:04 Modification of the Bylaws Modification of the Bylaws to be considered by the Shareholders, at the extraordinary meeting convened for January 16, 2017 See attachment
10/01/2017 09:07:22 Extraordinary Meetings Summon Notice of the Extraordinary General Shareholders Meeting that will be held on Monday, January 16, 2017 See attachment
02/12/2016 16:11:43 Notifications published by the company Renato Covelo, New Senior Vice President, General Counsel See attachment
22/07/2016 11:05:32 Securities Ratings Fitch publishes Avianca S.A.'s technical ratings report See attachment
08/07/2016 11:15:24 Securities Ratings FItch confirms Avianca's 2009 Bonds Rating at 'A+(col)'; Negative Perspective See attachment
End of Period Reports
In compliance with external circular No. 004 from 2012, Separate Financial Statements for 2015 and Statutory Auditor Opinion are attached
16:45:19
In compliance with external circular No. 004 from 2012, a certification issued by the legal representative according to the terms of Article 37 of Law 222 from 1995 are attached
See attachment
Ads published by the company
Clarification of Relevant Information
Rating of securities
Fitch lowered the Rating of Avianca Bonds 2009 to A+(col); the Perspective is Negative
Change of Board of Directors
Decision adopted by the General Shareholders' Meeting
Change of Statutory Auditor
Profit or Loss Proposal approved by the Meeting
Decisions adopted by the Meeting
Notices published by the company
Appointment of the Chief Executive Officer of Avianca Holdings S.A. and President of Aerovías del Continente Americano S.A. Avianca
Clarification of information
Profit or Loss Proposal to be submitted before the Meeting
Decision of the Board of Directors with regards to the profit distribution proposal
5:11:35
Notice of Ordinary Meeting
Call for Ordinary Shareholders' Meeting.
17:04:14
Call for ordinary meeting of the General Shareholders' Meeting.
See attachment
Good Governance Codes
In compliance with the provisions laid down in External Circular Letter 028 of 2014 of the SFC, the Corporate Best Practices Report corresponding to the period of 2015 was submitted.
N/A
Notices Issued by the Company
Designation of the interim president
Financial Statements by the Issuer
Consolidated Financial Statements – Third Quarter 2015
See attachment
05:34:01
Financial Statements by the Issuer
Condensed Financial Statements – Third Quarter 2015
05:44:52
Consolidated and Condensed Interim Financial Statements – Second Quarter 2015
09:53:32
Notices published by the company
Government of Venezuela lifts suspension.
See attachment
20:35:42
Announcement by the government of Venezuela.
See attachment
Investments in other companies
Purchase agreed for a minority stake in the Mexican freight transport company Aero Transporte de Carga Unión, S.A. de C.V. Aerounión.
See attachment
Fines or penalties imposed by government entities
Penalty imposed by the Superintendence of Ports and Transportation. Not definite.
See attachment
It is clarified that the information published yesterday at 18:10 and 18:12 corresponds to the financial results of its parent Avianca Holdings S.A.
N/A
Avianca Holdings S.A. records an operating income of USD$49.8 million in Q2 2014.
Financial situation of the issuer
Interim Condensed Consolidated Financial Statements for the six-month period ended on June 30, 2014.
See attachment
Securities rating
Fitch publishes technical report for the Ordinary Avianca Bond Issue 2009
Fitch affirms AA+(col) rating for AVIANCA 2009 bonds; Stable outlook
See attachment
Publication of the Issue Prospectus
Through Resolution No 0312 of February 24, 2014, the Financial Superintendence of Colombia approved Addendum No.2 to the Avianca Information Prospect for Ordinary Bonds 2009.
Supplement information posted yesterday about the Arbitration Tribunal Ruling
Press Release No. 726. Arbitral Award February 17, 2014 rules in favor of Avianca S.A.
See attachment
Press Release No.274. Operation of the Fokker 50 fleet
News in Securities Issuers media channels
News published in the Media
Bondholders' Meetings
Decisions taken at the meeting of the second summons of the Extraordinary Meeting of Ordinary Bondholders 2009 held on December 5
Second Summons for the General Assembly of Bondholders. It is clarified that the meeting will take place on December 5, 2013 as the attached notice states and not the 4th as originally published in the relevant information notice on November 19
Second Summons for the General Assembly of Ordinary Bondholders 2009 issued by Avianca S.A.
19/11/2013 16:19:20 Bondholders' Meetings It is reported that the Bondholders' Assembly convened for today was not carried out due to lack of quorum (77.5 % of representatives of the outstanding loan participated). The second summons will be published proceed for 04/12/2013
First Notice of the General Assembly of Ordinary Bondholders 2009 issued by Avianca S.A. (Issuer)
Avianca reaches an agreement with the organization of Avianca pilots, ODEAA
Securities rating
Fitch publishes technical report for the Avianca Ordinary Bond Issue 2009
January-June 2013 Avianca Holdings S.A. reports economic results of its subsidiary in Colombia
Fitch affirms Avianca's 2009 Bonds at AA+(col)
Avianca takes delivery of its first ATR 72-600
Information about the company's shareholders
Clarification of the information published today at 9:23:46, that the bonds rated by Fitch Ratings are ordinary bonds (Senior Notes) and not subordinated bonds
The rating issued by Fitch Ratings for subordinated bonds which can be offered on the international market by Avianca Holdings S.A., is independent of the AA+ rating for the Avianca S.A. bonds issued in pesos in 2009
Financial year end reports
In compliance with External Circular 004 of 2012, the relevant information is attached. Management Report 2012
In accordance with External Circular 004 of 2012, the relevant information is attached. Consolidated Financial Statements 2012, Certification, Statutory Auditor Report
In accordance with External Circular 004 of 2012 , relevant information is attached
Change in the shareholder composition of the issuer
Changes in shareholder composition. Annul the reasons for dissolution due to the concentration of share ownership
Corrections to financial information
Report on Financial Information Republishing at the close of December 2012
Profit or Loss Project approved by the Shareholders' Assembly
Profits distribution project approved by the assembly
Profit or Loss Project to present to the Shareholder's Assembly
Profit Distribution Project
Notice of Ordinary Shareholders Meeting
Press Release Clarification. Avianca receives first Airbus A320 equipped with sharklets
Press Release. Avianca receives first Airbus A320 equipped with sharklets
Decisions of the Board of Directors
Significant Decision of the Board
Change in the shareholder composition of the issuer
Ver anexo
Investors and: ir@avianca.com
Shareholders: gobiernocorporativo@avianca.com
Ethics and transparency: ethicspoint.com
Financial Performance Certificate for Avianca S.A. Ordinary Bonds: bonos@avianca.com
Terms and conditions Web
Privacy Policity
Charges for additional services
If you have any hearing and/or speech disability and require special services, please call (1 866) 998-3357 free of charge, or write to us at e_solutions@centrosolucionavianca.com. Remember that you must request our special services for persons with disabilities during your online purchase process.
Version 9 or greater
Version 32 or greater
Avianca - 2018 Copyright © All rights reserved. NIT 890.100.577-6. RNT 21871
You are leaving Avianca.com. It is possible that the site to which you are being directed does not follow the same accessibility policies as our Company.


We hope you enjoyed Family Science Night last week, courtesy of your PTA and with lots of help from the Maryland Science Center. And congratulations to Kalea J., Hayden M., Summer A., and Angelo M. on each winning a pair of Science Center tickets!
Show us your moves this evening! Hot Skates of Woodlawn will open just for Westowne families and friends. This evening is a social event for our school community, not a fundraiser.
Please note: a parent or guardian MUST attend with all students.
The PTA's 5th Grade Committee will sell concessions at each of The Lion King Jr. performances. We'll have pizza before the Friday evening performances, as well as snacks and drinks at all shows. Please sign up online to help sell food.
Please sign up here to help with tasks such as collecting tickets and assisting the students between acts.
Join us next Tuesday, February 14th at 7:00. Agenda topics include Drama Club support, Book Fair, and Literature Night, and we'll keep it brief so you can spend most of the evening with loved ones. The meeting is held in the library, so please enter the building through the courtyard at the rear of the school.
Registration forms for a winter session of Lego Robotics, which run for 6 weeks starting the end of February, will be sent home in student folders soon. We are offering Lego Robotics taught by parent volunteer, Lara Mellendick and assisted by parent, Joe Riggieri on Monday afternoons from 4:00-5:00.
Reserve one of the slots by sending in your registration and club fees in by the due date on the form. Club sizes are very limited. You will receive a confirmation by email before the start of the club.
The Catonsville Women's Giving Circle (CWGC) has presented Westowne PTA with a $1500 grant to bring Green Author Jennifer Keats Curtis back to Westowne next school year. Thanks to Westowne parent Susan Larsen for preparing the PTA's grant application, to Ms. Johnson for her assistance, and to the Catonsville Women's Giving Circle for their generous support!
Opening night is about a week away! Tickets for Westowne's The Lion King, Jr. are available online.
All performances are general admission and $5 per ticket. Seats are limited, so buy your tickets online today.
Students will be treated to a brief selection of scenes and songs from the full performance during the school day on Tuesday, February 14th.
Both Catonsville Middle School PTSA and Arbutus Middle School PTA would like to invite incoming families to become members and become involved.
CMS PTSA has open delegate positions for a two year term. Elections will be held in May. Please contact the nominations committee with questions or to express interest.
Thank you for supporting your children and our local schools.
Support the community and Catonsville Middle School PTSA during their 14th Annual Mulch Sale. Find details and ordering options on their website. For mulch delivery (minimum of 15 bags), please place your order by March 22nd. Smaller orders must be placed in advance and picked up on Saturday, April 1st, 9:00-2:00.


text:
A key part of being a shooter
Gun cabinets (or as some people call them, gun safes) are a key piece of kit for a gun owner because the law states that you must keep guns and ammunition safely locked away. It's an important part of being a responsible shooter.
On 12th December 2019 the UK law changed and now states that: " When a firearm or shotgun certificate holder is under the age of 18, arrangements must be made for an individual aged 18 or over to assume responsibility for the secure storage of the firearms and ammunition held on the young person's certificate."
According to BASC: The person assuming responsibility must be either the certificate holder's parent or guardian or a person aged 18 or over who is authorised to have possession of such firearms and ammunition. It may not always be necessary for the parent or guardian to also have a firearms certificate if arrangements are made for the firearm to be secured in a cabinet with two separate locks which can only be opened when both key holders are present and one of the key holders is a certificate holder.
Clever and practical – this gun cabinet doubles up as a coat rack
Choosing a gun cabinet
Nowadays there is plenty of choice, ranging from utilitarian metal gun cabinets through to decorative pieces of furniture that belie their real purpose.
As for keys, new technology means that personal security codes can replace traditional key-operated locks and some of the latest gun safes can even be opened by your fingerprint.
Plenty of room inside this Browning gun cabinet
Got a query about a gun safe? You'll find the answers in our informative articles here.
Should the firearms enquiry officer have taken a picture of my gun locker?
Q) I believe a police officer has the power to stop and search, but do police community support offi cers, RSPCA officers and gamekeepers have similar powers where potential firearms offences or wildlife crimes are concerned? N. WILLIAM By email
How can my firearms cabinet be opened lawfully?
What arrangements should I make for the orderly disposal of my firearms after my death, and how can my firearms cabinet be opened lawfully?
7 of the best gun cabinets
Remember all gun cabinets and gun safes must conform to the British standard, have secure locks and be fixed to a secure structure. Contact your local police firearms department if you have a query on where to fit your gun cabinet or safe. The police prefer a gun cabinet to…
What should I do about shotgun storage while I'm away?
I intend to take a long holiday away from home and wonder what obligations I am under in respect of storage of my shotguns while I am away?
Can I store my guns in the attic?
Q: I am applying for a firearms certificate so that I can acquire a .243 calibre rifle for stalking. I understand that I must obtain a gun cabinet, which I am considering installing in my attic. Would this be a suitable location? A: While an attic may appear to be…
Would your gun cabinet pass the test?
A muscular man in the middle of the room swung a large hammer up over his head and brought it crashing down on a metal cabinet. It was not an ordinary Wednesday and Utah was not an ordinary destination for a Shooting Times assignment. Browning's ProSteel gun cabinet factory sits…
7 legal things about gun cabinets you need to know
1. Do you need to heat your gun cabinets in winter? If the temperature is plummeting outside will your guns suffer if the cabinet is in an unheated room that's a bit damp? Is there a danger of the cabinet rusting? Coldness on its own does not cause rust, but…
Where should I keep my gun cabinet keys safely?
On Sunday August 10 1997 a police officer called at the house of Mr Mark Farrer. He wanted to inspect his firearms security. Mr Farrer was not at home. His mother, then in her 80s, who did not hold a certificate, fetched the officer the key and allowed him access to the gun cabinet. The Chief Constable then declined…
Storing guns: advice from the police
"Many people don't realise that the law does not actually require you have a purpose-made firearms cabinet," said Dave Mathias, Explosive Liaison Officer with the Devon and Cornwall Police. "It just says that all reasonable measures must be taken to ensure their safe keeping. We do have to take a…
Moving and gun cabinets. What's the law?
Do I have to notify the firearms department if I move my gun cabinet to another part of the house?
How many guns can you store in a gun cabinet?
Q: When I got my shotgun licence three years ago I bought a four-gun cabinet. I've just bought my fifth shotgun and have been told by my firearms enquiry officer (FEO) that I am only allowed to own four because that is all my cabinet was intended for. Do I…
Can I break my gun down into parts to store it?
Q: I need to buy a gun safe for my house, but I don't have room for a full-size cabinet. I will therefore need to break my gun down into its parts to store it. Will this cause any problems with the gun? A: None whatsoever. Shotguns are designed to be broken…
Do I have to tell police when I move my gun cabinet?
A: Firearm security is the responsibility of the certificate holder not the police. Read condition 4(a) on your certificate. Police involvement is limited to advice only. You don't need to tell police when you move your gun cabinet There is no statutory duty or need to tell the police that you have moved your cabinet. If you do…
Cohabiting? What's the law on shotgun licences and gunsafes?
A: It always makes practical sense for cohabitees to have each other's shotguns listed on both their individual certificates. If that is done, there never can be any question about either party having access to the other's shotguns. The same holds true for Section 1 Firearms but then both parties will have to satisfy the "good reason" test…
Can my wife use my gun cabinet for her shotguns?
A: Every firearm and shotgun certificate carries a statutory condition which states that: "(a) The firearms and ammunition [or shotguns] to which the certificate relates must at all times (except in the circumstances set out in paragraph (b) below) be stored securely so as to prevent so far as is reasonably…
Which gun safe is safest?
Q: I wanted to upgrade my gun safe security and buy a fireproof safe of some sort. Do you have any recommendations? A: Many people go for the minimum-security requirements in terms of gun safes, but if you total the cost of your rifles, scopes and sound moderators compared with the initial…
I have found the start of rust on a gun in my cabinet!
After a wetter and cooler than usual so-called summer, I have found the beginnings of rust on a gun in my cabinet. Why has it happened this year?
Will I need to heat my shotgun cabinets in winter?
I have recently applied for a shotgun certificate, and my preferred place in which to put my shotgun cabinets is in a room that's not heated in winter.
Can I have a gun cabinet in a static caravan?
Is there any way you are allowed to have a gun cabinet in a static caravan?
Can I lose my gun cabinet and wall-mount my guns?
I'm tired of storing my four shotguns in a cabinet where I can't see them and would like to have them in my little office upstairs against the wall.
Why aren't golden retrievers more popular in the field?
One of the mysteries of the gundog world is why golden retrievers are a comparative rarity in the shooting field, especially compared with the ubiquitous Labrador. Fashion probably has a…
Should I choose a spaniel or a Labrador?
I go rabbit and pigeon shooting, and now intend to get a gundog. I am not sure which breed to go for. A friend says…
AIR RIFLES: NO MAKER'S MARKS
Home loading Steel Shot cartridges to save ££££
How can I get the correct gunfit with my Browning Cynergy?
Greedy shot or good sport?
Budget shotguns
Perazzi 16 bore ribless game gun
AYA 16-bore No. 2
Why do none of the top Sporting shots use side-by-sides?
Which trigger do I use first on a side-by-side?
The ferrets are coming
Patrick Laurie


text:
Web News Observer
Ownership and Advertising Policy
TWICE's Jihyo tests positive for COVID-19 ahead of BETWEEN 1&2 release
byNeog
Credit: Instagram
TWICE's member and leader Jihyo has, unfortunately, tested positive for COVID-19. This is according to a recent statement that was issued by the group's associated agency JYP Entertainment. The said notice was shared on the official fan cafe of the group, where it was revealed that the leader had tested positive after having checked on her self-test kit. As a result of the same, Jihyo is expected to remain absent from the upcoming promotions of the group's eleventh EP titled BETWEEN 1&2, which is all set to release on August 26, 2022.
A post shared by 지효 (JIHYO) (@_zyozyo)
Full statement
As revealed earlier, JYP Entertainment has released a full statement confirming Jihyo's diagnosis. Read the complete statement below.
"This is JYP Entertainment.
We are sad to inform you that TWICE member JIHYO has tested positive for COVID-19 antigen testing on August 24th. JIHYO tested positive for self-diagnosis kit at 10:30 AM and is currently quarantined, following the guidelines from health department after testing positive for COVID-19 antigen testing.
We apologize for causing concerns among TWICE's fans and related people.
We will prioritize our artist's health and put our best effort for her quick and healthy recovery.
BETWEEN 1&2
On August 18, 2022, JYP Entertainment released the new concept photos for the group's upcoming album. Well, there is no denying that all the members look gorgeous in the same! The nine members are seen sitting on a green lawn while displaying their dazzling outfits that are somehow interpreting retro vibes in a pretty trendy manner. Now, the concept grabbed the attention of everyone when it appeared in the new album's trailer as well. Meanwhile, the group's mini-album BETWEEN 1&2 and its title song, Talk that Talk, is going to be released officially on August 26, 2022, at 1 pm KST.
A post shared by TWICE (@twicetagram)
The album teaser
The TWICE members have also shared a teaser sound source for the album's songs. The said video includes two songs as the girls exude charisma while posing for the camera with firm gazes. Among them is the track Queen of Hearts which is sung in English. The song harmonizes with an amazing drum beat, guitar sound, and the cool vocals of the TWICE members. Not only that, but LDN Noise, the world-famous producing team, also participated in the track's work.
Neog
A scribbler and wordsmith, she loves to write on all things K-pop. If not that, entertainment surely catches her attention.
For news and updates!
Web News Observer is a media outlet covering the latest news in Entertainment, Technology and Business.
© Copyright Web News Observer 2022.


Team members from our Board of Directors, Volunteer Leaders, and Advisory Board at our kickoff event in 2015.
Photos from the lacrosse workshop that we created for low-income elementary school girls at King Elementary. We partnered with Lincoln High School's girls lacrosse team and the lacrosse players served as coaches for the girls.
We partnered with a youth-led initiative called Positively Post-It to hold our own PPI event at a shelter. Here, our volunteers are writing positive notes with kids to put up around the shelter and give to each other.
Lincoln High School Kids First Project chapter members. To date, it has been running for 5 years and have over 100 active members.
Our first Intersectionality Workshop event! To further promote youth empowerment through service and advocacy and to create collective impact and collaboration among Portland's various youth-led non-profits, I worked with my Kids First Project team to create a city-wide workshop. Participants were able to learn about every non-profit's work and how to get involved, and we ended the workshop with a roundtable discussion on how each issue we address intersects with each other.
Community gardening project for Earth Day. We created a garden at a downtown public high school to grow fresh fruits and vegetables for local shelters. The school then created a gardening class to involve its students in the maintenance of the garden and to learn about issues like food deserts.
Donating school supplies and hand written cards of encouragement to families at Portland Homeless Family Solutions.
Speaking at Human Rights Day about Kids First Project and the importance of early childhood education.
I started volunteering at my local family homeless shelter when I was fourteen. Here, I met Sarah. Both fourteen with brothers, an unabridged love for reading, and a fiery commitment to lacrosse, we instantly became friends. But I began to notice that while I spent thirty minutes at most getting to school, Sarah's daily commutes totaled three hours. While I had lacrosse practice, Sarah had to quit her team. With what free time she had, she would look after her brothers and the younger kids in shelter. All the kids in shelters had aspirations of becoming doctors, scientists, dancers, and even presidents, yet did not have the resources necessary to pursue their dreams. Sarah's resilience in making the most of her situation inspired me, but I was determined to find a way to bring programs directly to her and other young people experiencing homelessness in my community and beyond.
The average age of a homeless person in the US is just nine years old. Because children cannot live in the streets, this issue often goes unnoticed. When I spoke to a transitional housing organization when creating Kids First, I learned that they had lost funding for children's activities and couldn't manage volunteers. Programs and volunteers are needed in family homeless shelter to empower homeless youth to reach their full potential.
Kids First Project brings educational and recreational programs directly to family homeless shelters. All our programs are run and taught by volunteers of all ages from the area. Our unique approach to bring programs directly to shelters is because homeless youth have long commutes between schools and shelters, so they often cannot participate in after-school programs. Furthermore, by having volunteers in shelter, parents have the opportunity to leave their kids for an hour to focus on finding housing or relaxing. However, homeless youth are not the only ones benefitting from our programs. We encourage people in our community to connect their passions with service by leading activities that they're passionate about to get them excited about service-learning. We've helped community members enact programs ranging from weekly lacrosse workshops to STEM programs, making service both meaningful and manageable. Lastly, our model is not only unique, but also relatively easy to replicate. While we're mostly concentrated in a few cities right now, our model means that our chapters and other groups can implement the same programs at the family shelters in their own communities.
Although numbers are important, my team values the immeasurable impact that has been made through our work. We worked with Jasmine last summer through our tutoring program when she was fourteen years old, an eighth grader preparing to enter high school the following year. In middle school, she struggled with school. However, during the summer, our volunteers were able to help her build confidence in her strengths and passions. By August, she felt more comfortable with algebra and essay writing than she ever had before, and our volunteers even helped her discover a passion for painting. Now, she is excelling in her math class and is part of an art club held at her school. She comes back to the shelter to visit and see our volunteers because of the close relationships she has formed with our organization, and is in the process of creating a Kids First Project chapter at her own school.
After I realized that after-school programs wouldn't be effective for youth experiencing homelessness living in shelters, I found that shelters often do not have structured programs for kids, lack funding for children's activities, and, at the time, there were no existing organizations that brought volunteers and programs to shelters. Thus, our traveling model allows us to: 1. Impact more kids by serving multiple shelters in one community. 2. Create convenience for both parents and kids by bringing programs directly to them. 3. Give volunteers the opportunity to engage in service-learning.
With a team of 27 people and over 400 volunteers, we annually serve 500 families at 6 different locations across the country with an additional 7 student chapters. To date, Kids First Project has empowered youth experiencing homelessness across the US through our weekly programs and services. We have also given a platform to students to bring their passions forward and transform them into teachable curriculum. Today, Sarah, the girl who inspires my work, volunteers with Kids First Project and is a strong advocate for the ending of homelessness in our community. Although it cannot be reflected in tangible numbers or statistics, we have helped youth experiencing homelessness, like Sarah and Jasmine overcome barriers and discover, pursue, and excel in their passions.
Now that I am a student at Stanford, it has become more difficult managing a non-profit that focuses so heavily on delivering in-person programs, especially because they're located throughout the country. I need help restructuring Kids First Project so that our programs can continue to scale to new locations while maintaining sustainability. I have been studying human rights in college, and my team and I have realized that Kids First Project could also do a lot for youth experiencing homelessness in the policy and advocacy realm. I'm hoping to add a new component that will allow our volunteers to also engage in meaningful advocacy in regards to youth homelessness, such as government funding for children's activities in shelters.
I need resources to help Kids First Project go through a few transitions. Because we have been running for almost three years now, we need additional resources to adjust to change. With many of our team members cycling out of high school and into college and the importance of teamwork in our work, I need support and advice on replacing old members with new members in our Board of Directors. We do a good job of winning grants, but seed funding would be needed to scale our programs and implement new initiatives within Kids First Project. General mentorship on non-profit transitions and sustainability would be incredibly helpful for my team heading into this summer because we will be working on so many different parts of our organization.
I'm a strong believer in collective impact and partnerships. In the past, I have partnered Kids First Project with other young change makers to help all of our organizations increase our impact. For example, one non-profit distributed feminine hygiene products. Because Kids First serves teens and women who do not have access to free feminine hygiene products, I partnered with her to supply all the shelters Kids First Project serves with feminine hygiene products. Another friend runs a non-profit that creates STEM workshops for low-income students. I partnered with her and she gave Kids First Project curriculum books and materials to hold her STEM workshops for the kids we serve. For change makers located in the same area, I have taken the initiative to create collaborative events, such as our annual Intersectionality Workshop for Global Youth Service Day. (Description of event in attached picture above) Because Kids First Project brings a variety of programs and directly works with youth experiencing homelessness, there are many exciting opportunities for partnerships.
Congratulations to you too! Thanks so much for offering, I'll definitely reach out. I saw that your organization provides STEM programs - Has your team ever considered offering programs in the states? If so, we're always looking to offer more STEM programs at our locations and would be interested in partnering!


Looking for an active, rewarding career? Working in landscaping is a great way to spend time in the outdoors, keeping your hands busy and building something for your community.
Physically fit, with the stamina for hard, physical work?
Kerr & Kerr Landscaping is a local, family-owned business that has been proudly serving Cambridge, Kitchener, Waterloo, Guelph and the surrounding region since 1994.
Beautiful quality is our goal. Our team is tight-knit group of professionals that includes between 13-15 employees in the summers. We are always looking for new talent to add to our little family!
We are committed to being leaders in landscaping and property management within the Tri-Cities area. We offer great opportunities for career advancement within our growing organization, as well as industry training for promising newcomers. Our goal is to grow a world-class team of experts in their field!
We are not actively looking for a team member in this area. If you are interested in this position please contact us using the contact form.
If you are interested in this position please contact us using the contact form.
If you're interested in learning more about career opportunities with Kerr & Kerr Landscaping, fill out the contact form below to get in touch!


text:
The Oldest Universities in Italy: A Sneak Peek
Posted on September 15, 2019 by Stacy di Anna Pollard	Leave a comment
Not only is Italy home to the oldest university in all of Europe and nearly the oldest in the world, il bel paese is also home to multiple universities which have been in continual operation for several centuries. Where might one find these educational treasures? And how many might there be still in operation? Here's a sneak peek…
The university as we regard it today — an educational institution designed for instruction, examination, or both, of students in many branches of advanced learning — had its roots in Italy when, sometime around 1088, the University of Bologna formed. It holds the distinction of being the first institute of higher learning in all of Europe, and nearly the world, not associated with the church.
As we craft a thorough look at the oldest universities in Italy still operating today, here's a look at the five oldest, all which had their beginnings in the 1200s.
1. University of Bologna
Established 1088 (charter granted 1158) | Bologna (Emilia-Romagna) | Original location known as Kingdom of Italy, Holy Roman Empire
The University of Bologna sparked the creation of a number of universities across Italy and all parts of Europe, and is still regarded as the model from which the modern university as we know it today was born. (More on its birth story here)
Given more than 900 years of graduates, the university understandably has a long list of notable alumni. This includes four popes (Alexander VI, Innocent IX, Gregory XIII, Gregory XV); Renaissance scholars and philosophers Petrarch, Leon Battista Alberti and Pico della Mirandola; scientific innovators Nicolaus Copernicus and Guglielmo Marconi. The first woman in the world to be named a university professor of physics was Laura Maria Caterina Bassi, who earned a doctorate of philosophy degree from Bologna in 1732.
2. University of Padua
Established 1222 (likely earlier) | Padua (Veneto) | Original Location known as the Medieval Commune of Padua
Originally founded by a group of students and professors from the University of Bologna seeking greater academic freedom, with the first subjects being law and theology. Today it hosts approximately 60,000 students, is the fifth oldest university in the world and still one of the top-ranked in Italy.
A few of the many notable students throughout history include Nicolaus Copernicus (attended 1501-03 after receiving his law degree in Bologna); Andreas Vesalius (1537) known as the founder of modern human anatomy; and Elena Lucrezia Cornaro Piscopia, who was the first woman ever to receive a PhD (1678) and went on to become a faculty member at the university in the mathematics department. Another noteworthy faculty in the mathematics department: Galileo Galilei, who chaired the deparment from 1592-1610.
3. University of Naples Federico II
Established 1224 | Naples (Campania) | Original location known as the Kingdom of Sicily
In the early 1200s, the University of Bologna was one of the only higher education options, creating a problem for Frederic II, emperor of the Holy Roman Empire. Bologna was an adversary to his kingdom. To keep his scholars close and to train them for ministry in the empire, Frederic II founded the University of Naples as a public institution, and it remains the world's oldest state-supported university. Today, despite being one of the largest in Italy, with nearly 80,000 students, it remains one of the top universities in the world.
Among the many notable graduates are St. Thomas Acquinas (mid 1200s), who also founded the university's theology department; three presidents of the Italian Republic, and Stefania Filo Speziale, the first woman in Naples to receive an architecture degree (1932).
4. University of Siena
Established 1240-1357 | Siena (Tuscany) | Original location known as the Republic of Siena
City of Siena Image Credit
Another public university since its inception, the University of Siena today has a student population of around 20,000 (nearly half the population of the city itself) and attracts an broadly international crowd.
The 13th century university was founded for the studies of humanites and philosophy, and gained traction as a major university in the early 1300s. In 1321, a Bologna student was sentenced to death for the alleged kidnapping of a young woman, prompting a large number of University of Bologna students to protest and ultimately leave. Siena officials seized the opportunity. "Siena, supported by generous funding from the local commune, was able to accommodate the students resigning from the Studium Bolognese." (source)
University of Siena notes two popes as alumni or faculty: Pope John XXI (1276-77) who was a professor of medicine; and Pope Julius III (1550-55) who studied law at the university.
5. University of Macerata
Established 1290 | Macerata (Marche) | Original location known as the Papal States
University of Macerata Aula Magna Image Credit
Macerata is situated just south of Ancona and about 20 miles from the Adriatic Sea. The university began its life as a law school in the late 1200s, and in 1540 became a studium generale (universtiy) by Pope Paul III.
Today, seven centuries later, the university has a student body of just under 10,000 studying one of seven different schools (law remains one of those.) Some courses are offered entirely in English. Those who enjoy wandering the centri storici of Italy will be interested to note that the offices and departments of the university are found in the historical center of Macerata, within its medieval walls.
Post to be continued…Stay Tuned!
Tags: Italy, Travel. Bookmark the permalink.
Previous post ← The Birth of the University: An Italian Story
Next post These 14 Universities in Italy Have Welcomed Students Since the 1400s — or Earlier →


Bell has stopped making the Northwind, but it is a very satisfying boat to paddle and a good compromise between tracking and turning ability. It is light enough to portage in Royalex but able to handle both rocky rivers and the flats equally well.
The Norhtwind is a capable boat that can handle a variety of paddling situations. The Royalex version is 16 1/2 feet with good secondary stablility and decent glide. It handles large lake waves and rapids pretty well, but not as well as the big trippers. It can handle a 5-day paddle with two people and their gear.
The Northwind is similar to a Mad River Explorer, a boat that does everything well. If you only have one canoe, this is a great choice.
The Bell Canoe Northwind is not available from the stores we monitor. It was last seen May 23, 2010	at REI.


1552: Petra Kvitova departs Centre Court as the new Wimbledon champion and heads off for all sorts of glamorous engagements, no doubt. First up, she poses with the trophy alongside her name on the honours board. Presumably, Petra will not be grappling with the rail replacement bus service later on and can sweep into central London for a slap-up meal. We, on the other hand, will continue to prepare for Sunday's men's final between Rafael Nadal and Novak Djokovic. Should be quite good, that. See you at 1200 BST.
1548: Petra Kvitova - "It's hard to find some words. I'm standing here with the trophy and I see some great players in the Royal Box. Of course I was nervous in the final game but I hoped that I can win and I had to focus on each point which was important. It's very nice that Martina Navratilova and Jana Novotna are watching me and have supported me all the time during the tournament and gave me some advice."
1547: Maria Sharapova - "Unfortunately there is only one winner at the end of day. I have had amazing support over so many years and to be back at this stage and holding the runners-up trophy - I wanted that big one and it's something I'm going to be back for and will get again."
Annabel Croft on 5 live: "It was an extraordinary performance. She played breathtakingly and had so many weapons at her disposal and managed to bring them out on display in the final. When she reached the semis last year, it was such a shock but she then went on this losing streak and then bounced back to be here. It will be interesting to see how she responds after this."
Bethanie Mattek Sands on 5 live: "Nerves of steel. Kvitova did it herself and she wasn't waiting for mistakes from Sharapova. And to win it on an ace - what a way to win it. Sharapova's done it so many times [recovered from slow starts] and we were expecting her to get back in it. But Kvitova played aggressively and remained calm and I'm really impressed."
1538: "That was a pretty good time to hit your first ace of the day," says John McEnroe. Jana Novotna, the last Czech to win here in 1998, looks down from the Royal Box alongside the nine-time singles champion Martina Navratilova. And there are currently eight Czech women in the world's top 100. The LTA is looking for a new head of women's tennis, return flight to Prague anyone?
Nerveless stuff from Kvitova as she serves her way to 40-0 and three championship points.... and she hits an ace down the middle! That is the way to win Wimbledon.
Or maybe she will. Sharapova holds to love and Kvitova must serve out for the Wimbledon title. "Something tells me this is going to be a pretty long changeover for her," says John McEnroe. "It's so exciting, your heart starts beating faster and you tell youself, 'Just keep doing what you've been doing'. Think of the first point and the first serve...."
Bethanie Mattek Sands on BBC Radio 5 live on women's final: "Both mixing the game up so well but Kvitova is still smooth and calm and ripping it even more. Petra is making it really tough. Sharapova is back behind the baseline which is where she doesn't want to be and she's got to figure out how to get back inside. It's exciting to know we're getting close to a new Wimbledon champion."
Big hold. Another tight game goes the way of Kvitova when Sharapova blazes a forehand return over the baseline, and it's hard to see the 2004 champion being abe to hold serve enough to get out of this.
Sharapova has won 15% of points on her second serve and 57% on her first serve. That ain't doing it. Under pressure she nets a forehand to fall 15-40 and two break points down... and another wayward forehand when rocked back by Kvitova's power means Sharapova is behind again. "How does anyone get momentum right now - sixteen games, eight breaks of serve," says John McEnroe.
Blimey. Kvitova hits a backhand so hard it produces a scream from Tracy Austin, that in turn nearly knocks me off my seat. Calm it down, Petra, some of us are trying to work. Fortunately, Sharapova is made of sterner stuff and earns herself a break point... but finds the tramlines. Kvitova then misses an absolute sitter to give up another break point.... and Sharapova nails the return. "Poor game from Kvitova," says Tracy Austin.
From BlackburnJA on Twitter: "If #Wimbledon has been anything to go by, the Women's game is fit and strong again. This is a final between 2 great players. #bbctennis"
"That's the best shot she's hit today, right there," says John McEnroe when Sharapova hooks a forehand from almost behind her and fires it cross-court. That gets her back to 30-30, but the momentum is lost when she puts a forehand long on game point. Break point for Kvitova... missed with a return in the net. Another break point.... second serve.... Kvitova smashes a forehand return into the corner. Brilliant.
A screaming Sharapova return is accompanied by a screaming Sharapova, and moments later the Russian has a break point.... Kvitova has the point at her mercy but goes down the middle again with a short ball, and Sharapova scoops a backhand lob over the Czech to grab the break. Cue... fist pump.
Sharapova ends a run of six games against her with a frankly surprising love service game.
Annabel Croft on 5 live: "The swinging lefty serve is causing Sharapova all sorts of problems, as well as her thumping serves, interspersed with her low backhands. By the end of the first set, Sharapova was starting to lose her way. Everything Kvitova is throwing at her is going her way."
She's just tightening up a little bit," says Mark Petchey on BBC One after Kvitova double faults for deuce, but the Czech comes through and lets out the yelp of delight that has become a familiar sound around the All England Club this fornight.
1457: Bad news from Court One if you're British, but we can all congratulate our Australian friends. Hurrah! Luke Saville beats Stockport's Liam Broady 2-6 6-4 6-2 in the boys' final, but it's been a great week for the Briton. Chin up, everyone.
1453: "Sharapova is faced with a bit of a dilemma and it will be interesting to see if she's got an alternative as to what do do," says John McEnroe. "You suspect she has."
Bethanie Mattek Sands on 5 live: "Kvitova's a cool customer and doesn't look like she's outside her comfort zone. She's sticking to her ritual against someone as experienced as Sharapova. This is an important game and she needs to close out this first set but Sharapova will fight back."
Bethanie Mattek Sands on 5 live: "It's a great start. They're both really going for it. As we've seen before, mixing it up against Sharapova really works."
Kvitova comes through a tough service game, seeing off a couple of break points and taking it with a thumping winner before celebrating as though she's broken. And over on Court One - Broady 6-2 4-6 Saville * The Brit was a break up but couldn't hold on.
1400: Maria Sharapova and Petra Kvitova walk onto Centre Court carrying the traditional bouquets of flowers. Over on Court One, Saville looks more like Lleyton Hewitt than ever as he celebrates breaking back, so there's life in that one. I will endeavour to keep you across both matches.
1351: Broady breaks at the start of the second and holds. I'm not calling this one, though. I've seen too much. Meanwhile, the band departs Centre Court and we are about ready to see the ladies' finalists. "Sharapova and Nadal are the best two competitors in the game," says Tracy Austin on BBC One. "From a young age it's unusual for a kid to know 'this is where I'm going', and she has always had that."
1346: Broady wraps up the first set in 36 minutes, clenches his fist and gives a steely look to his supporters. His attitude and poise has stood out in each match so far, he looks like a tough nut to crack.
David Felgate on BBC Radio 5 live watching the boys' final: "It's all been very impressive so far. Liam Broady looks comfortable and he likes the big stage. He's doing all the right things. He looks like he belongs out here and that's very important."
From Liam in Newcastle via text: "can only see the womens final going the way of the big Russian, Kvitova off to a fast start but her standard mid-game slump will see Sharapova gain momentum which will not be relinquished, Shara in 3 sets for me!"
1334: Saville has a break-back point but misses the return on a second serve, Broady saves a second with a swinging lefty serve and a third with a rasping forehand. Tough game, good hold for the Brit.
1326: Broady wallops a forehand pass down the line as Saville charges into the net once again and it's all looking very good on Court One. Suspiciously good.
1319: Broady the steadier so far and the more aggressive Saville is going for a bit too much. The Briton thumps away a volley on his second break point, although looks back nervously as the Aussie's desperate response drifts close to the baseline.
From James via text: "Maria, move her around, think big, hit big and scream big! Good luck masha!"
1313: "Great reception for Liam, including a few screams from female admirers. Broady-mania starts here?" says BBC Sport's Chris Bevan on Twitter from Court One. Steady, Bevo. Saville opens with a hold, Broady responds in kind. I'll be keeping you up to date with this one before we go game-by-game for the ladies' final. Just so you know.
1300: There's a buzz around Centre Court now as we move to within a hour of the ladies' final - Maria Sharapova v Petra Kvitova. The 24-year-old Russian won their only previous meeting on hard courts in Memphis last year and seems to be themarginal favourite, but it's three years since she won a Grand Slam and that serve can go haywire. Kvitova has far less experience at 21 and is playing her first Grand Slam final, but she can hit winners from anywhere.
1251: Let's have a quick look ahead to the boys' final coming up soon, and the chance for Liam Broady to follow in the footsteps of Britain's last junior male champion, Stanley Matthews Jr, in 1962. Broady is on an 11-match winning streak and faces fellow 17-year-old Luke Saville from Berri in Australia. "I played him last in under-14s, so it was a long time ago and things change," says Stockport's Broady. "I've seen him play a few times. Obviously he's a very good player. Hopefully if I bring my game out, I'll be able to do some damage again. I always go on court expecting to win, no matter who against. I think I've got a very good chance if I play well."
From Tim, London, via text: "Murray's solution is easy, he has to move up one (or maybe down one) in the seedings, assuming Nadal gets back to One. Then at least he only meets him in the Final."
1238: The Royal Box list is in, and it's a who's who of women of import - Condoleezza Rice, Anne Hathaway, Bille Jean King, Amelie Mauresmo, Martina Hingis, Martina Navratilova, Jana Novotna, Helena Sukova, Maria Bueno. Plus, er, Nick Clegg.
BBC Sport's Chris Bevan on Twitter: "Nadal briefly forced off court by a swarm of insects. Greenflies, I think. Maybe Murray should bring some with him next year? #bbctennis"
1230: If you're a Nadal fan you're happy, and if you're a Djokvic fan you're probably delirious, but for Andy Murray followers it's another case of 'What if?' or maybe 'Will he ever?' Britain's newspapers have come to the rescue with their thoughts on this subject, for example: "Just like last summer, Nadal welted a great number of forehands past Murray on Centre Court, and then approached the net at the end to say sorry," says Mark Hodgkinson in the Telegraph. And Kevin Mitchell in the Guardian writes: "That Murray fell short for the third year in a row at this stage of the tournament had as much to do with his struggle for consistency when in such a position as the irresistible Spanish force in front of him."
Andy Murray's part-time coach Darren Cahill on Twitter: "Aussie's flying on the back of Tomic's Wimby run, Luke Saville into the boys final & Ash Barty playing the girls semi today. Good luck!"
1222: France's Caroline Garcia is the star name of the girls' singles after Andy Murray proclaimed her a future world number one when she gave Maria Sharapova a mighty scare at Roland Garros. She trails Russia's Irina Khromacheva 2-1 on Court 12, while Dutch girl Indy de Vroome - which, let's face it, is an undeniably brilliant name - leads Aussie Ashleigh Barty 4-2 on Court 18.
1215: Yep, Rafa is out on Court 16. In the first two rallies I see he hits the net both times. Two unforced errors in 30 seconds. He is mocking us. The great man was, well... great yesterday. An official tally of seven unforced errors in his semi-final win over Andy Murray. "The statistics are really unbelievable," Nadal said aterwards, a bit embarrassed. The truth, I don't know. We have to look at the statistics, but not everything is statistics, no?"
BBC Sport's Chris Bevan on Twitter: "Big crowd crammed into Court 16, waiting for Nadal to arrive for practice. His Welsh hitting partner Evan Hoyt here again too. #bbctennis"
1204: He's back, and he's sounding in a jaunty mood. It's the Voice of Wimbledon - "Unbelievably, we've had no rain for the last three days and I'm delighted to tell you that it's highly likely we'll have another fine and dry day, so it's all good news." After a slow start, VoW has really hit his stride in the second week.
1202: The action has already got under way around the All England Club with the wheelchair event on Court 14, while the girls' semi-finals are about to start on Courts 12 and 18. We then have the excitement of a British male in a Grand Slam final as Liam Broady takes on Australia's Luke Saville at 1300 BST, before Sharapova v Kvitova at 1400 BST. And it's all available through the Red Button, online at the top of this page and, with a manual refresh, trusty old 5live.
1200: Hello, and welcome to the penultimate of day of Wimbledon. It might feel like the day after the night before for some, but it's the biggest day of their sporting lives for others. We started off with 256 players hoping to get their hands on the singles trophies and we're now down to just four. This afternoon we'll see whether Maria Sharapova can reclaim the title she won in 2004, or whether Petra Kvitova can become the first Czech champion since Jana Novotna in 1998.


CHICAGO — Chicago artist Tony Fitzpatrick will bring his signature brand of witty visual repartee to the DePaul Art Museum this spring with a display of his collage series "The Secret Birds." The exhibition will run May 12-Aug. 21, 2016, and is the largest presentation of his work to date with more than 50 of his intricately layered collages as well as 40 prints from the DePaul Art Museum collection that span more than two decades of the artist's career.
In his ongoing series "The Secret Birds," Fitzpatrick meticulously draws and layers images, poetry and found materials onto the page. He combines inspiration from his working class roots in Chicago and influences from folk art, comic book characters and tattoo imagery. Each drawn collage depicts a specific species of bird, ranging from the peregrine falcon to the common starling.
Several of the works are commentaries on gun violence, drug abuse and other inequities and injustices found in Chicago and beyond. "The birds play symbolic roles, some delivering otherworldly messages and cautionary tales," said curator Laura Fatemi, associate director of the DePaul Art Museum. Other works eulogize Fitzpatrick's influences, including writer Roberto Bolaño, musician and Chicago blues legend Otis Clay, and his own father.
"Tony celebrates the beauty of the natural world in 'The Secret Birds'" said Fatemi. "The Artist's Studio" section of the exhibition will feature items from Fitzpatrick's studio, including the ornithological reference books he has studied and his carved wooden bird collection.
A Chicago native, Fitzpatrick draws on the history and lore of the city, as well as popular culture and his Irish Catholic roots. He is a self-taught artist, playwright, actor, poet and essayist and a consummate raconteur, said Fatemi. "Tony's astute observations and contemplations of his surroundings reveal and celebrate the magic, beauty and wonder of the world around him," said Fatemi.
Printmaking has played an important part in Fitzpatrick's development as an artist. In 1992, he founded a printmaking workshop, Big Cat Press, in Chicago's Wicker Park neighborhood. The operations have moved and changed over time, but printmaking remains an important part of his work.
Fatemi has grouped some prints with Chicago subject matter from a series titled "Remembered City." These images take the viewer on a journey through the streets of Chicago and reference the city's history and landmarks, including the Chicago Stockyards. "Tony is a chronicler of the city, and the view of Chicago he expresses in prints and poetry is historical, political and intensely personal," said Fatemi.
The exhibition includes selections of Fitzpatrick's work from the DePaul Art Museum's permanent collection, and more than 30 private collectors have contributed their holdings. "These works encompass a range of ideas and showcase a sampling of the visual trajectory of the artist over the past two decades," said Fatemi.
An opening reception will be held for "The Secret Birds" and another exhibition, "Barbara Rossi: Poor Traits," May 12 from 5-8 p.m. A discussion with Fitzpatrick and Chicago Tribune writer Rick Kogan, known for his compelling takes on the city, will be held May 23 from 6-7:30 p.m. These events are free and open to the public.
The DePaul Art Museum is located at 935 W. Fullerton, just east of the CTA's Fullerton 'L' stop. The museum hours are Wednesdays and Thursdays from 11 a.m. to 7 p.m., Fridays from 11 a.m. to 5 p.m., and Saturdays and Sundays from noon to 5 p.m. The museum is closed Mondays and Tuesdays. For more on the DePaul Art Museum's upcoming exhibitions and events, call 773-325-7506 or visit http://museums.depaul.edu/.


text:
Q: Subquery on outer query UPDATE: Please look at the second query, it is more representable for this example
I'd like to create a query that uses different subqueries for each column.
The subqueries would be based on the list obtained by the outer query.
For example:
Consider tableA is a table with 30 columns and 5 million records
SELECT a, b, c,
(SELECT COUNT(a) FROM values WHERE (r = 12 AND u = 'TO') OR (r = 16 AND u IN ('TB', 'TU')) as First,
(SELECT COUNT(a) FROM values WHERE (r = 16 AND u = 'TE') OR (r = 76 AND u IN ('TE', 'TG')) as Second,
(SELECT COUNT(a) FROM values WHERE (r = 564 AND u = 'HG') OR (r = 788 AND u IN ('VD', 'BF')) as Third,
(SELECT COUNT(a) FROM values WHERE (r = 383 AND u = 'RT') OR (r = 35 AND u IN ('GR', 'EZ')) as Fourth
FROM tableA values

I know this query would not execute since I can't call values from the subqueries, but is there a good solution to make this query run fast?

In some subqueries, I'd also need to join to another table, is it then still possible to use values, or do I have to do a subquery on tableA again?

Following query would be more representable for this example:
SELECT col1, col2,

(SELECT COUNT(col3) FROM tableA ta
INNER JOIN tableB b ON tl.TaskId = b.col6
INNER JOIN tableC c ON b.Id = c.TaskId
WHERE c.ResultCode = 1 AND ta.col4 = a.col4 AND ta.col5 = a.col5) as Executed,

(SELECT COUNT(col3) FROM tableA ta
INNER JOIN tableB b ON tl.TaskId = b.col6
INNER JOIN tableC c ON b.Id = c.TaskId
WHERE c.ResultCode = 9 AND ta.col4 = a.col4 AND ta.col5 = a.col5) as NotExecuted

FROM tableA a
GROUP BY col1, col2, col4, col5

A: SELECT a, b, c,
       SUM(CASE WHEN a IS NOT NULL AND b=12 THEN 1 ELSE 0 END) as First,
       SUM(CASE WHEN a IS NOT NULL AND b=16 THEN 1 ELSE 0 END) as Second,
       SUM(CASE WHEN a IS NOT NULL AND b=82 THEN 1 ELSE 0 END) as Third,
       SUM(CASE WHEN a IS NOT NULL AND b=167 THEN 1 ELSE 0 END) as Fourth
    FROM tableA
    GROUP BY a, b, c

redpajama_set_name: RedPajamaStackExchange


text:
SANCTA SANCTORUM (The Shining Darkness) LP/CD
There is no doubt that Steve Sylvester has written history with Death SS. They were one one of the first Italian doom/heavy metal bands who connected the dark imagery of the Alice Cooper Band with the occult content of bands such as Black Sabbath or Black Widow. And so it's not much of a surprise that early Death SS also had an impact on groups like early Cathedral, Northwinds or Internal Void. In addition, one should not forget that Paul Chain also started his career in Death SS. Since then, 34 years have gone by and I must say that I lost interest in Death SS after 'Do What Thou Wilt'. I got the impression that they were desperately trying to achieve some sort of new-fangled metal sound. What is even worse is the fact that they mutated into a trivial technoid gothic/dark metal band who completely ingnored their musical past. For me as an old fan of Death SS it was painful to watch their musical development.
Thus, I was very pleased and surprised when I noticed that Steve Sylvester has joined forces with his old friend Thomas Hand Chaste (Witchfield) who was the drummer in the first lineup of Death SS. Additionally, he recruited another Death SS veteran, namely bass player Danny Hughes. To that we can add guitarist Frederick Dope and keyboarder John Di Lallo and there you have SANCTA SANCTORUM. 'The Shining Darkness' is their debut album, released by Black Widow Records in 2010, and on the basis of the lineup it is therefore entirely logical that SANCTA SANCTORUM bares a striking resemblance to early Death SS. Even though there are some psychedelic leanings, it is unequivocally clear that this album is firmly connected to 1970's hardrock. However, 'The Shining Darkness' is more located on the darker side of rock, or to be more precise, it is pitch black and at times rather depressing. But that is exactly what I want when it comes to occult-tinged hardrock that is over-saturated with doom. It's the real deal and not some pathetic, infantile crap as we know it from bands as, for example, The Devil's Blood or Ghost (Rise Above Records). SANCTA SANCTORUM are serious about their attitude of mind and I respect these views just because of Steve Sylvester's past. After all, Death SS wrote about horror and occultism at a time when it became unfashionable, i.e. 1977.
But back to topic. One of the good things about 'The Shining Darkness' are the vocals of Steve Sylvester, because they have lost none of their morbid and sinister charisma. But also in other areas, SANCTA SANCTORUM do their job pretty good. The organ gives the songs it's necessary 1970's vibe while Frederick Dope has a keen sense for the right riffs. Fortunately the album production is neither slicky nor overproduced, but rather grubby and filthy. This fits in ideally with the joyless atmosphere of this record. One of the most intense tracks is 'When Hopes Are All Gone' which is the perfect soundtrack for your personal downfall. In contrary, there is 'The Soul Of Truth', a hard rocking track that kicks serious ass. As usual, I won't bore you with a detailed analysis, but let me tell you that 'The Shining Darkness' is packed with strong songs. I can only hope that SANCTA SANCTORUM will record more material in the course of time, because this is a very promising start. Just forget about all the soulless imitators, because this is, as previously mentioned, the real deal. You'll also get an appealing and top-quality packaging as one is used from Black Widow Records. All in all, 'The Shining Darkness' is recommended very much.
www.myspace.com/sanctasanctorumband
www.blackwidow.it


The Journal of Stevenson Studies is an internationally peer-reviewed publication with a distinguished body of Stevenson scholars on its advisory board. Founded in 2004, it is published by the Stirling Centre for Scottish Studies by subscription only in the autumn of each year. It is edited by Professor Emeritus Roderick Watson (University of Stirling) and Professor Linda Dryden (Edinburgh Napier).
The Journal is available for on-line purchase through the University of Stirling Online Shop with direct payment by credit or debit card.
The Online Shop (shop.stir.ac.uk) will require you to open a password-protected account to place your order and make a purchase. Go to: 'Product Catalogue / Faculties and Divisions / Faculty of Arts and Humanities'.


text:
NBA Summer League: Day 5By:
Player of the Day:
Noah Vonleh, Portland — He is stepping into some big shoes, though size does not seem to be much of an issue for Vonleh. He has the frame of a legit PF and has been asserting himself quite well in his first two Summer League contests with the Blazers. While the Blazers did come up short on Tuesday, Vonleh kept them in the game, finishing with 20 points (6-10 FG, 1-2 3PT, 7-8 FT) and 8 rebounds. He had a couple of monster throw downs and overall has made life much easier for the Blazers since his arrival after Game 1. His rookie year was definitely a struggle, but he still has considerable upside and seems to be a player that fans in Rip City should have some hope for going into this season.
Biggest Surprise:
Jarrid Famous, Washington — Famous has been a journeyman pro player since finishing up at South Florida but has been a presence for the Wizards Summer League team. After two consecutive double-doubles coming in losses, he helped Washington to their first win in Vegas with 16 points and 9 rebounds in only 20 minutes of play. He has really shown great effort on the offensive glass, managing to assert his will on games without really having much of the offense run through him. This could be someone the Wizards or someone else give a chance to make the roster come training camp.
Justise Winslow, Miami — After being one of the standouts of Orlando's Summer League, Winslow is off to a rocky start in Vegas. While he played only 11 minutes, he looked a tad out of control at times, finishing with 5 points on 5 shots and 3 rebounds in a blowout loss to Boston. He is a great energy player who at times has had a rough time finishing at the hoop, as his lack of an intermediate game gives the defense a cushion to adjust. He still seems like a very promising player, with top-notch athleticism to go along with rare strength for a player his age, it just was a bit of a letdown after he looked so poised in Florida.
Top Performers:
Maurice Ndour, New York/Scottie Wilbekin, Philadelphia: The Jahlil Okafor/Kristaps Porzingis showdown quietly turned into significant games for a couple of guys fighting for roster spots. Wilbekin finished with 26 points, including three crucial FT's to send the game in to OT. The reason they were covering his shot so tightly is that he was 6-8 from 3 on the game, bringing a shooting threat the team could desperately use in Summer League. Ndour is an undrafted PF by way of Senegal who played collegiately at Ohio. More of a role player before this game, he was very active in finishing with 23 points and 6 rebounds to eventually put the Knicks over the top in this close 84-81 contest.
Draft Watch
Jahlil Okafor, Philadelphia: The bigman was a force offensively as usual, finishing with 18 points and 6 rebounds. He may have had the better game than Porzingis, though the Latvian had a crucial block on Okafor down the stretch. Okafor shot 8-18 FG and 2-7 FT, while being blocked 5 times on the game and of course, being forced to sit during crunch time due to his FT woes. Overall he is looking good, though there is still some major room for improvement.
Kristaps Porzingis, New York: He generally will not be going up players as big and strong as Okafor, but Porzingis had a decent showing in his own right. He finished with 9 points to go with 3 rebounds/assists/blocks. While he still needs work on his body, he is not afraid of contact and his shooting stroke has been quite evident. He did finish the game with 7 fouls, including a potentially game costing foul on Scottie Wilbekin that ended up putting the game in OT. It will be a learning experience, but the Knicks seem to have a very high upside prospect to work with at the very least.
Trey Lyles, Utah: Lyles ball skills are great and he had a couple of nice drives to the hoop. Even so, he has a lot of things to work on before getting consistent NBA minutes. He forced up numerous contested shots from long range (0-5 3PT) and was caught out of position for some costly baskets. He always seemed to be more comfortable on the perimeter than with rolling to the basket or going to the post. For a player with his size and skill level, he needs to become more assertive/aggressive closer to the hoop.
Devin Booker, Phoenix: Bouncing back from a very roungh game, Booker did his best work in catch-and-shoot scenarios and has to have one of the nicest strokes of any player entering the league this season. He finished with 18 points and 6 rebounds, he moved quite well without the ball, though was definitely much less effective off of the dribble. He also has great size considering he is still just 18-years old and is a very promising floor stretcher for Phoenix.
By valentine July 16, 2015 Leave a comment
Author: valentine
PreviousPrevious post:NBA Summer League: Day 4NextNext post:NBA Summer League: Day 6