Google Builds First U.S. Offshore Superhighway!
Some very exciting news for US clean energy today. Google announced on their blog last night that they will invest in a project to build 350 miles of transmission off the Atlantic coast from New Jersey to Virginia to tap into gigantic off-shore wind potential that we are only just beginning to tap into — the first-ever US approval of an off-shore wind farm, by the Obama administration, was just this year.
The new transmission cables, a superhighway for clean energy, will enable the connection of up to 6,000 MW of offshore wind turbines. That's equivalent to 60% of the wind energy that was installed in the entire country last year and enough to serve approximately 1.9 million households.
Putting this system in place removes a major barrier to offshore wind energy in the US: lack of infrastructure. And it should — with a friendly administration — jump-start off-shore wind in this country. The US currently lags so far behind Europe that the first off-shore farm approved, this year's Cape Wind, which signed the US' first offshore wind energy lease last week, was reduced to using German turbines (Siemens).
Google's new superhighway of energy will be built by transmission company Trans-Elect and be financed by Google, Good Energies and Marubeni Corporation.
These four mid-Atlantic states are the middle states central to a consortium of what is now 11 Atlantic states whose governors have signed an agreement to develop their tremendous off-shore wind potential, which has been estimated at 330 Gigawatts in total, more than twice what the 11 states use.
Polling of the 5 mid-Atlantic state coastal residents has found that they are very supportive of the development of their off-shore wind (previous story).
These four mid-Atlantic states that Google proposes to get started with have more than 60 GW (60,000 MW) of this gigantic off-shore wind potential in relatively shallow waters that extend miles out to sea, making it easier to install turbines 10-15 miles offshore, where they are barely visible.
This is a historic milestone for the USA. Total off-shore wind power off the Atlantic has been estimated to be enough to take one third of the US population off the fossil grid.
Transmission has always been the elephant in the room when it comes to renewable energy (with apologies to energy storage; let's call that the mildly smaller hippopotamus in the room). Because wind and sun tend to pick and choose their spots to blow strongest, shine brightest and longest, there is usually the need for additional infrastructure capable of bringing all that carbon-free electricity to the load centers.
Offshore wind is no different, and is even more complicated in terms of transmission because it's, you know, off shore. With the offshore wind industry poised to take off — or at least finally get one foot off the ground — there is now a proposed project that would theoretically ease the transmission issues of wind farms up and down the Atlantic coast.
A project to be known as the Atlantic Wind Connection will create a huge "transmission backbone," with undersea cables sited miles off the coast aimed at connecting new wind farms to the power grid without the need for piecemeal infrastructure. The project is run by Trans-Elect, with financial backing for its estimated $5 billion price tag from Google and others.
The Atlantic Wind Connection will run for 350 miles along the coasts of Virginia, Maryland, Delaware and New Jersey. A direct-current series of cables, it will be the first undersea cable in the US to actually pick up generated power along the way. And at 15 to 20 miles off the coast, if wind turbines are built around the backbone they will be barely visible from shore.
It has been a banner couple of weeks for the nascent (still) offshore wind industry. A recent National Renewable Energy Laboratory report indicated the massive potential of the wind flying past US shores — four times that of all the existing electricity generation in the country — and Secretary of the Interior Ken Salazar finally signed a 28-year lease allowing the 130 Cape Wind turbines to be built.
And at the signing of that lease, last week, Salazar hinted at this week's transmission announcement.
The first offshore wind energy turbine in the US will be installed off the Texas coast by the end of the year.
The 2.75-MW turbine is being installed near Galveston Island in the Gulf of Mexico. It is a precursor to the 300-MW Galveston Wind Project and the development of 3500 acres (1,416.4 hectares) already leased for Texas offshore wind operations.
According to the US Department of Energy's National Renewable Energy Laboratory (NREL), the US has the potential to generate over 4,150 GW of energy from offshore wind, which would fulfill four times the current energy demand through wind energy.
"Texas has many favorable conditions, such as its own transmission network and plant sites in a 10 mile zone off of its coast," said Jan Wiedemann, managing director of the German American Chamber of Commerce in Houston (Texas). "This area is governed by Texas state laws, making it unlike any other US state since it does not need the approval of the US Department of the Interior.
"This creates many opportunities for entering the ever growing wind industry The NREL also projects that Texas has the potential to generate 1.06 GW of energy within this 10 mile zone (25.9 square kilometer)," he added.
Not coincidentally, Houston is about to host the first-ever Texas Offshore Wind Energy Roundtable. The conference, and an affiliated forum on offshore wind law will be held 19-22 October. The four-day conference will evaluate the potential of Texas's offshore wind energy market and address the expected wind energy boom in the Gulf of Mexico. E.ON Climate & Renewables Europe, SIEMENS, Hochtief, Vestas, Thales and Siag, have all confirmed their participation.
Featured speakers will include Michael Lewis, managing director of E.ON Climate and Renewables Europe, who will speak about their experiences as a European offshore wind energy supplier, and William Keating, general manager sales North America of Vestas Offshore, who will speak on state-of-the-art technological capabilities and experiences in offshore wind from the perspective of a turbine manufacturer.
While the U.S. wind industry has become a major player in global markets with traditional terrestrial power generation applications, efforts to move offshore – where wind resources are far superior but logistics are more challenging – have been hampered by a lack of regulatory support at both federal and state levels.
The American Wind Energy Association (AWEA) sponsored a conference last week in Atlantic City, New Jersey, attracting roughly 1,500 attendees from around the globe, with heavy representation from European turbine manufacturers such as Vestas, Gamesa, REPower and Siemens, firms that dominate sales in today's major offshore markets such as the United Kingdom and Denmark.
The conference started off with a bang and a bit of ceremony with U.S. Department of the Interior Secretary Ken Salazar signing a 28-year lease for the first offshore wind project in the U.S., to be located off the coast of Cape Cod, Massachusetts.
The Cape Wind project, which will rely upon 130 3.6 MW wind turbines provided by Siemens, will grow from a first phase of 182 MW up to 468 MW at full build out. The project took 8 years to gain final approvals, and drew staunch opposition from wealthy citizens residing on Cape Cod, including the infamous Kennedy family.
Atlantic City was selected as the venue for this premier conference because New Jersey Governor Chris Christie signed the Offshore Wind Economic Development Act into law on July 19, 2010. The Act will provide $100 million in tax credits for offshore wind developments in the Atlantic Ocean that connect to the New Jersey grid.
Special "offshore renewable energy credits" (ORECs) help make projects more economic, with a "Clean Energy Manufacturing Fund" offering additional grants and loans based on local job creation. At present, three of the five "interim leases" offered for offshore wind projects in the U.S. have been secured off the New Jersey Coast, representing 1.4 GW of capacity.
• Rhode Island has a special 15% by 2019 set-aside for offshore wind, with the so-called "Deep Water" offshore project currently under development.
• New York has released two RFPs: one for 120-500 MW of freshwater offshore wind on Lake Erie and Lake Ontario; and a second saltwater RFP for 350-700 MW off the coast of Long Island.
• Virginia offers a unique incentive approach, allowing each MW of offshore wind development to count as the equivalent of 3 MW when complying with the state's Renewable Portfolio Standard.
• Even more generous is Delaware, which offers a 3.5 times multiplier on RECs from offshore wind (which increases to a 4.2 multiplier if 50% of turbine components are manufactured in-state).
• Maine has a special deepwater offshore program focused on 30 MW of pioneering projects that validate new foundation and installation technologies.
• Since Ohio does not have sufficient wind resources to meet its 12.5% by 2025 RPS, the state is looking to develop 20 MW of freshwater offshore wind on Lake Erie, a total that could grow to 1 GW by 2020.
Despite the hype and headlines, there was also some sobering news at the conference. The National Renewable Energy Laboratory projects that including the current PTC and other available federal incentives, the cost for offshore wind is still over 22 cents/kWh. An estimate from Europe was even higher – 26 cents/kWh.
Given the high costs of offshore wind, the rationale for policy support is increasingly focused on economic development. One study by Siemens showed that offshore wind provides 22 jobs per MW in Europe, which compares to approximately 7 jobs per MW for onshore wind there. Jobs in the U.S. are much lower, according to the study, with just 2 jobs per MW for onshore wind, the key difference being Europe's market features 90% local content, while the U.S. is closer to 50%. Rather than manufacturing being the key to maximizing jobs on land-based wind projects, it is ongoing maintenance that provides 70% of employment benefits for offshore wind over the long term.
The U.S. Department of Energy estimates that 54 GW of offshore wind could be included in the 300 GW required to meet 20% of the U.S. electricity needs in 2030.
Despite the hype and hope, Europe is way out in front of the U.S. in this clean energy sector. At present, 17 offshore wind projects are under actual construction in Europe totaling more than 3.5 GW. The projected growth rate for 2010 is 75% when compared to 2009, with 1 GW expected to come on-line by the end of the year. Though the U.K. is now by far and away the market leader, Germany – in spite of its very limited coastline – may soon move into second place.
To get a sense of scale of this opportunity consider that one off-shore wind project proposed in the U.K. would total 9 GW alone, and would represent the fifth largest infrastructure project in the world. All told, 5 GW of offshore wind are currently under development in the U.K. with a goal of 33 GW of offshore wind development by 2020, an investment of $150 billion.
Last week the U.S. Department of Energy released a new report detailing the potential opportunities for offshore wind power development in the U.S. The figures are mighty impressive. Along with generating 4,000 gigawatts, a full blown U.S. wind power development program would create thousands of new green jobs and reduce electricity costs in key coastal areas. Things are already starting to move forward on a grand scale, with eastern seaboard states joining in a new cooperative wind power development effort, called the Atlantic Offshore Wind Power Consortium. The question is, will things keep moving forward after the upcoming election?
What it all boils down to is federal funding and support. Take a look at any major component of the U.S. economy, and you will see massive public support in the form of various federal government subsidies, tax breaks, and regulatory structures. Railroads, seaports, agriculture, our national defense infrastructure, highways, and fossil fuel production — these are all transformational developments that make the modern U.S. what it is today, and they would not have happened without a federal framework. That's exactly the kind of muscle needed to push us forward, and out of the increasingly risky and unstable fossil fuel economy. President Obama got things started with tens of billions in new federal funds for clean energy programs that help businesses create new green jobs, but depending on the results of the upcoming election the future of federal support for sustainable energy doesn't look all that secure.
You would think that strong federal support for new jobs and new business opportunities would get props from the U.S. Chamber of Commerce, but there you'd be exactly wrong. Clean tech companies, companies with strong sustainability profiles and major utilities have been been protesting and outright quitting the Chamber due to its obstructionist policies on climate change. The Chamber has always lobbied representatives in Congress but now it's gone a step beyond and is also investing heavily in campaign ads, including attack ads, in support of candidates who are opposed to climate action. Apparently the Chamber is comfortable with supporting candidates who are likely to challenge, block, suspend or de-fund President Obama's sustainable energy initiatives, even though it means waving good-by to new green jobs and new opportunities for business owners.
One explanation for the motivation behind the Chamber's partisan focus against clean energy can be found in last week's explosive Think Progress report on the Chamber's recent campaign activities. According to the report, the Chamber has been soliciting funds from overseas businesses and foreign governments, including oil-rich nations. The Chamber has apparently commingled these foreign funds with domestic funds in an account from which it draws campaign advertising expenditures. There's a potential for some serious violations of federal election law, and Congress is now investigating. In the mean time, if you haven't gotten all that excited about any of your local candidates for the upcoming election, it would be worthwhile to check out their position on clean energy, climate legislation, or the need for federal support for new green jobs. If you like what you see, by all means go out and vote.
Cape Wind Project Now Has its Ocean Lease From the US Govt.
You might have thought the long battle for the Cape Wind project was over back in April, when the Obama administration BLM filed its approval of the project, but there's more steps than that!
Thursday, Secretary of the Interior Salazar surprised the AWEA at an annual meeting by announcing that at the conclusion of the event he would be publicly signing his approval of a 28-year Federal lease with Cape Wind Associates for 25 square miles of ocean floor 16 miles from Nantucket off the coast of Massachusetts where the project is to be built.
The first ever off-shore wind project in this country would involve 130 wind turbines 16 miles off the coast that could produce up to 468 megawatts of electricity and sell power at $0.18 cents per kilowatt-hour, more than any other non-fossil power other than nuclear energy.
The most controversial renewable energy project in the US would raise National Grid customers in Massachusetts home electric bills per month $1.50. Electricity rates for its commercial and industrial customers would increase between about 2%: well under the 5-7% annual rate rise seen among electricity bills nationwide.
On-shore wind is much cheaper, since off-shore wind is nonexistent, something that Salazar attempted to correct in forming the Atlantic Offshore Wind Energy Consortium earlier this year with 5 Atlantic state governors, to fast track this nation's stalled off-shore energy industry.
The consortium has worked on eliminating the barriers to off-shore wind development, by identifying the best offshore potential for wind projects, bringing the environmental review in line with reality and speeding up the permitting process by removing redundant layers of bureaucracy.
The Atlantic seaboard has a power potential of 330 Gigawatts, about twice the total electricity needs of the states involved. The consortium has doubled to include the governors from 11 Atlantic states.
"I am determined to accomplish a similar objective of orderly, responsible, and straightforward permitting for wind development on the Atlantic Outer Continental Shelf" Secretary of the Interior Salazar told the AWEA during his surprise announcement.
As with the solar projects now planned on BLM lands, the 28-year lease signed by Salazar will cost the company rents and fees payable to the federal government. The "ocean" rent is $88,278 in annual rent prior to production, and then once production begins, a 2% fee for fifteen years and from then: 7%. The first off-shore wind power is expensive at $0.18 cents a kilowatt-hour.
On-shore wind companies who can sell power for half that amount are understandably upset. TransCanada Energy, with on-shore turbines in Maine, offered to sell electricity to National Grid for less than $0.11 cents per kilowatt-hour. And that's just the objections on that side. The US Department of Justice is still battling four pending lawsuits in federal court by the NIMBY contingent.
With the project approval in April, and now the rent agreement signed with the US government, the next step is that the company will need to finalize a power purchase agreement with National Grid, the utility that will make history by purchasing the first off-shore wind power to ever be generated in the USA.
Before a wind farm is built, a long time – often years – goes into figuring out exactly where to place the turbines so that they harness an optimal amount of wind energy. But what if you had the ability to move a wind turbine to a different spot whenever the wind changes?
That's the idea behind the Mobile Wind Turbine concept designed by Pope Design. The turbine is mounted to hybrid truck that runs off energy supplied by the turbine or a diesel generator when the batteries completely drain. When the truck is parked, the turbine can be erected and start producing electricity.
It's unlikely that an entire wind farm would be made up of these, but for places like military bases, schools or businesses where only one or a few would be used, they might be ideal for maximizing the amount of clean energy that's generated. Also, a mobile wind energy generator would be a perfect solution for emergency disaster relief operations.


text:
CBL Properties Looks to Free Up Cash Flow for Redevelopment
1/9/2019 | By Nareit Staff
Stephen Lebovitz, president and CEO of CBL Properties (NYSE: CBL), participated in a video interview at Nareit's REITworld: 2018 Annual Conference in San Francisco.
Lebovitz discussed the short and long-term effect of the previously-announced Sears bankruptcy on CBL.
Lebovitz also commented on CBL's plans to reduce its dividend payment for 2019.
"Redevelopment requires capital and the dividend is the best source of capital that we have," Lebovitz said. By reducing the dividend from 80 cents to 30 cents, CBL has generated $100 million of additional free cash flow which can be reinvested, or used to pay down debt, he said. "It's not the ideal first choice but given our circumstances it was the right thing to do for our company …it positions us for better long-term growth going forward."
Meanwhile, Lebovitz said mixed-use development is becoming increasingly common at malls. "It is going to change the nature of malls and make them more relevant going forward," he said.
CBL Properties
CBL Properties Reinvesting Over $200 Million of Free Cash Flow into Properties

redpajama_set_name: RedPajamaCommonCrawl


While they used to be predominantly the domain of prancing dressage horses, lateral movements like shoulder-in and haunches-in offer unrivaled conditioning effects for almost any equine athlete. Exercise science has shown them to be on par with gymnastic routines like hill repeats and cavalletti routines in terms of muscle recruitment, with a bonus of altering motor sensory patterns. Below I will explain how and why you might consider incorporating them.
Depending how they are performed, these lateral movements offer two main purposes for horses: bodybuilding or physical therapy. When used outside these goals, the exercises fail to have positive physical benefits. In fact, they can act negatively on a horse's way-of-going. This most often happens when riders start practicing shoulder-in or haunches-in for reasons like boredom, to modify a horse's behaviour, or confusion about when and why to use them.
When you begin to use these tools in your training, ask yourself what purpose will they serve – bodybuilding or therapy? If bodybuilding, how do we confirm the horse is prepared for the effort of these exercises without straining? If physical therapy, what kind of changes can you expect, and how much should you challenge your horse?
For most horses, shoulder-in and haunches-in, and later half-pass, are tools to increase strength in the structures that facilitate traveling with more weight on the hindquarters. During lateral strides, the horse alternately engages and stretches his gluteus medius, while the tensor fascia lata muscle stabilizes forces around the hip. Elastic strength here increases both flexion and extension of the hip and stifle joints.
Equally important, the pectorals and inner leg muscles like the groin pull the leg sideways and then stabilize the torso over it. Difficult to access with other exercises, these muscles improve his posture during all other areas of performance by toning the sling muscles that suspend his trunk. When trained consistently, these exercises result in the horse being able to move across the ground looking — and feeling — both super-charged and effortless at the same time.
Admittedly, the horse gains these results only when he performs the maneuvers correctly, which is no small feat. We will cover the specific cues in a future article, but for now the following tips will help you avoid common mistakes and figure out if these tools should be part of your repertoire.
If he has not yet achieved foundational balance, the horse will muddle his way through these exercises using compensating muscle patterns, which will strengthen him in the wrong ways. How do you know if your horse is ready to start challenging with lateral exercises? Use a ten-metre circle test.
When you can ride him at trot around a ten-metre circle with perfect geometry, all the while maintaining an absolutely steady footfall rhythm and an inside bend through his spine, and he stays round over his topline and consistent in his body posture, then you are ready. If there are small hiccups at all in rhythm, bend, or posture you will want to wait before jumping in to lateral work. Be especially patient to start lateral exercises if your horse's body posture gets unsteady or he gets sluggish on the circle.
Little is gymnastically gained from the exercises if the horse travels in an incorrect posture. A horse that is prepared for lateral movements needs to be comfortable and secure moving in a markedly uphill balance, meaning his topline remains rounded and he carries his poll, fluidly arched, slightly higher than his withers. Should the horse abandon these qualities when you perform a shoulder-in, do not carry on just for the sake of doing the exercise.
Riders often find it so much fun to ride, and occasionally elusive, that they drill these movements too repetitively. When this happens, the horse begins to brace up his body and get dull, nullifying any potential gains. Resist the temptation to ride around the arena stuck in shoulder-in or haunches-in. Treat them as an interval format: ride ten strides, then straighten the horse out for several seconds, then repeat ten strides of shoulder-in or haunches-in.
Most of us become so fixated on the contortions of the exercises themselves that we stop guiding the horse forward in a clear rhythm. In this case, his footfalls become erratic or they slow down to a sluggish crawl. Lateral work only serves as bodybuilding when the horse approaches it with the right rhythm. Any time you are practicing and you notice the horse's rhythm falter, immediately leave the exercise you are doing and restore his gaits.
To build strength in the horse's gymnastic muscles, lateral movements are best performed at the trot. Riders can choose to sit or post the trot. Some studies have shown, in fact, that the horse is able to reach further laterally with his strides when the rider sits lighter by posting the trot. Each horse differs, however, and the rider should rise or sit based on how the horse is able to best maintain balance and rhythm throughout the exercise.
For horses not in a program of building gymnastic strength but instead needing physical therapy to repair dysfunctional movement or poor body mechanics, lateral exercises can be curative. Used in this capacity, the exercises are best performed at a walk with the horse in a horizontal body posture (relative to the ground) rather than markedly uphill. Using this posture and slower paces takes the workload away from gymnastic muscles and ensures the horse stimulates his postural muscles.
Lateral exercises performed in a relaxed state like this trigger several responses that reflexively lead to improvements in the horse's way of moving. They can form part of a rehab program, restore mobility, and help resolve asymmetrical or imbalanced muscular development.
Some of the most obvious responses generated are better coordination and proprioception. By recruiting the deep inner structures needed to stabilize the spine and joints during sideways movement, the horse stimulates these richly innervated areas that become dormant when poor posture or movements habituate. In this way, we can think of these tools as "waking up" parts of his nervous system.
Of note, the lumbar multifidi muscles are recruited, allowing the horse to channel movement better through his back. As these muscles tone, the horse's trunk is able to rotate between the shoulder blades as needed during turns and spinal bending. They also help the horse keep his balance and stability rather than get wobbly in his pelvis during forward movement, gait transitions, and riding uneven terrain.
Below are a few primary tips to consider when using lateral work as preventative care or therapeutic exercise.
The helpfulness of these movements owes to their specificity, which means you want to be as precise with each execution as possible. Moreover, you want to target only the postural muscles, which are slow-twitch fibres and respond only to appropriately low intensity contractions. Performing shoulder-in, haunches-in, and half-pass at a walk with occasional surges of easy jog is the best way to deliver physiotherapy benefits. The gait should be rhythmic, but slow and steady.
The nervous system adapts to carrying a load, meaning the type of movement it generates is different with a rider versus without. For this reason, practicing lateral exercises from the ground without weight in the saddle can allow you to influence neural pathways and patterns more directly than from the back. The horse's motor and sensory circuitry is often more available to change.
Blending together two exercises in sequence offers an excellent stimulation to his neuro-sensory system that allows you to re-program movement patterns. It also prevents any bracing or dullness that comes from holding him in a particular movement too long, or the negative effects of anticipating a certain number of strides in it. As an example, execute four strides of shoulder-in and then immediately do four strides of haunches-in or half-pass, and then return again to shoulder-in. The postural adjustments required by this kind of footwork improve involvement of the horse's motor and sensory nerves during movement.
Yes, you will be practicing at slower speeds but do bear in mind that nothing is accomplished if the horse crawls along sluggishly. Much of the purpose is to increase range of motion in the joints and to awaken the small muscles around them. If the horse walks or jogs with listless and stiff steps, then this does not happen. As a general rule, think about accelerating a little after each round of lateral work. In other words, perform four to six strides of shoulder-in and then check your energy, giving a little boost as needed.
Whether your intention is bodybuilding or physiotherapy, a good starting point will reward your efforts. On that note, I offer the following exercise for teaching shoulder-in and haunches-in to horses and riders. I like it most of all because it emphasizes the accuracy of rhythm while learning the mechanics of each maneuver.
Note: These instructions describe a shoulder-in, but the pattern is easily modified for haunches-in as well.
1. Use four ground poles and a cone or cavalletti block to set up a 90-degree angle as shown (you will be riding behind the cone).
2. In a lively walk, ride your horse through this 90-degree "corner" a half dozen times, staying very close to the poles throughout.
Horse is bent with his spine in an arc, or banana shape.
Rhythm of footfalls does not change at all.
Horse's posture remains steady, meaning he does not wiggle or wobble anywhere in his body.
5. Close your inside leg against the horse's ribcage, draw your outer leg rearward about a palm's width to act as a guardrail, and turn your shoulders (not your pelvis) to rotate about 45-degrees off your line of travel.
6. As you come out of the corner, this body position tells your horse's shoulders to follow yours and shift over to a separate line of travel from his haunches. Your pelvis remains facing straight ahead to tell his pelvis to keep going that way rather than following his shoulders.
The Corner Prep exercise works because it teaches riders to practice just a few good quality steps of shoulder-in or haunches-in rather than wrangle themselves all the way around the arena getting contorted. It is imperative that the horse does not learn compensatory muscle patterns early on. Fumbling through the movement with all the wrong muscles engaged does not accomplish our goals. Not only are these patterns difficult to rewire later on, but they also cause the horse a fair amount of confusion and anxiety.
Avoid practicing lateral work, either unmounted or mounted, on hard ground. During sideways movement, the horse's hoof rotates from one side to the other and without soft ground to press down into, that rotation causes torque on the fetlock joint and ligaments of the lower leg and hoof.
During any horse's riding career, lateral exercises can serve different purposes at different times. Sometimes they will serve as therapy to resolve a postural fault that has developed. Other times, they will play an important role enhancing the horse's gymnastic performance. In this article, I have clarified these two roles and hopefully given you a plan for approaching them.
This article was originally published in the Early Summer 2018 issue of Canadian Horse Journal.


This site may not be used as a supplement or alternative for health care, and is not intended and does not warrant or guarantee the quality or quantity of any services of any of the advertisers identified; further, the information provided is merely for educational purposes, and its accuracy is not guaranteed. Do not use this site as a substitute for health care. Please consult with your doctor or other health care provider regarding any health questions you may have. This site is not maintained by doctors or licensed health care providers and may not be used for health diagnosis or treatment. Do not use this site to disregard any health advice, nor to delay seeking health advice, because of something you read or see in this site.
You understand and agree that neither PBHS nor its suppliers or vendors or linked domain names are responsible or liable for any claim, loss, or damage, of any kind, directly or indirectly resulting from your use of this site or the information or the resources contained on or accessible through it.
We understand that your health information is personal to you and we are committed to protecting information about you. However, we have no control over the information contained on a provider's web site and in linking you to a provider's web site, we do not warrant that any health information provided by you will be protected or treated in a manner complying with privacy laws including the Health Insurance Portability and Accountability Act of 1996, regulations enacted thereunder, or applicable state laws. PBHS expressly disclaims all liability for any wrongful disclosure of your health information by the provider.


text:
The Root Causes of Autoimmune Disease with Dr. Kimberly Sanders
http://media.blubrry.com/functional_medicine_radio_show/p/s3-us-west-2.amazonaws.com/drcarri/podcast/055_Kimberly_Sanders.mp3
In this episode of The Functional Medicine Radio Show, Dr. Carri's special guest Dr. Kimberly Sanders explains how you can get to the root cause of autoimmune disease.
Dr. Sanders is a naturopathic doctor in Connecticut and specializes in rheumatology and autoimmunity. Her passion is finding the underlying cause of immune dysfunction and restoring balance to the immune system with functional medicine.
Main Questions Asked:
What causes autoimmune disease?
What are some of the infectious triggers for autoimmune disease?
How is gut health related to autoimmune disease?
What can be done to treat the gut in autoimmune disease?
Can you give an example of a case from your private practice of a patient that had an autoimmune disease and how you treated them?
Key Points made by Dr. Sanders:
Autoimmune disease is a wide spectrum of things. It can attack many different systems.
The way I describe autoimmune disease is like when you get a virus, a cold, your immune system kicks in to attack the virus. Now imagine that your body thinks that you are a virus: your own tissues, body, heart, and joints. What would happen if your immune system got confused and started to attack yourself as though you are a virus?
Some common examples of autoimmune diseases are the arthritis family such as rhumatoid arthritis. Also, Hashimoto's thyroid disease and Crohn's disease or ulcerative colitis. There are even some theories that say how autism could be an autoimmune disease meaning the immune system may be attacking the brain as though it were a foreign object.
The causes of autoimmune disease are multi-factorial meaning that there are so many things that can happen but the current theories of autoimmune disease really point to a genetic predisposition that gets set off, or it could be some environmental trigger.
We really try to find what these environmental triggers are and remove them as much as possible.
For me, triggers are the fun and rewarding part because it's different for everyone. Two people with rhumatoid arthritis may have symptoms that are almost identical but through the course of knowing the patient, their triggers are entirely different. That's what keeps it interesting.
The Big 5 Triggers: 1.) The gut is the most common trigger; 2.) Other infections. Not just in the gut but potential viruses lingering in the bloodstream. We know with psoriasis, strep tends to be a trigger. Children with PANDAS often have a history of strep. A flora imbalance in the mouth. Any type of cell that looks like the gut which we call mucosa but that really extends to the lung, sinuses, mouth and even vaginal. It's really widespread; 3.) Hormone imbalance. The common example here is Hashimoto's. It's very often linked to high estrogen or an estrogen imbalance, it's not in balance with progesterone. Estrogen being out of whack can also affect patients with Lupus or rhumatoid arthritis; 4.) Neurotransmitter imbalance. There's a growing field called Neuro-Endo-Immunology. This is how the nervous system and brain chemicals are connected to the immune system. Stress, anxiety, and mood disregulation definitely go hand-in-hand with these patients who are so inflammed; 5.) Heavy metals and enviornmental toxicity. That has a lot of effects on the immune system. Things like BPA and GMO foods that we're seeing so much more of now than ever before do play quite an integral role in the autoimmune process.
When I talk to somebody and I'm trying to learn what their triggers are, I'm really trying to screen them then decide which of those 5 triggers are the most important at that time. Oftentimes, it's not just one – that's what makes it so complex.
It's very important for the patients to understand how the gut impacts what's going on in the rest of the body. Specifically for autoimmune patients, they need to understnad that the immune system is primed in the digestive system.
We have an immense amount of immune cells lining the gut and the job of those immune cells is to look at the food that you eat and make sure there are no pathogens or bugs like food poisoning. It's there to protect you from something you may get from the environment. That's the purpose of having an immune system so engrained in the digestive tract. It's the first security gate to allow things into the bloodstream.
With that understanding, it then seems to make sense that if something is wrong in your digestive system, that's how the connection occurs with the immune system.
Then we get into the idea of the microbiome and what's happening with the bacteria in the gut. What it really comes down to is a certain type of immune cell called a regulatory T cell. They regulate the immune system. When the immune system is overactive such as in an autoimmune disease, the regulatory T cells' job is to calm them down.
Those immune cells are increased by the presence of good, friendly bacteria. Lactobacillus, the bifido group, and all of our probiotic flora increase the amount of regulatory T cells that we have in our gut.
On the flip side, the more infections we have like yeast, parasites or an overgrowth of bad bacteria, those regulatory T cells come down in number and that allows the immune system to run rampant.
It's a crucial balance between healthy probiotic flora and reducing these pro-inflammatory bad bacteria that allows these regulatory immunue cells to be in good number.
There's also the question of leaky gut. Think of your gut lining like a really tight fence. When you eat something, it should be digested into very tiny molecules that then are allowed into the bloodstream. Now imagine the fence opening up and it's more like a chain link fence with these big holes. Now when you eat something, it's allowed to enter the bloodstream in a larger form. The immune system gets revved up by that. It doesn't like large particles entering the bloodstream and it starts to attack them and when the immune system gets so revved up like that, combined with someone who has a genetic predisposition to have an autoimmune disease anyways, it sets the stage for an autoimmune disease to occur.
The gut really is the focus for most autoimmune patients. If I can't distinguish where to start with someone, I'll start with the gut.
It's your place to go back to. It truly does control so many systems. The gut does control the brain chemicals, the neurotransmitter balance, the hormones, and it controls the toxicity in getting rid of that.
We have stool testing for the lower intestine, breath testing to evaluate the health of the small intestine. I've seen a high number of patients not producing enough stomach acid. What that does is it allows food to enter the intestines undigested. That is then food for the bad bacteria so that can be a predisposing factor to why these infections come about.
Food sensitivities and reactions are a major cause of leaky gut or at least a contributing factor. When looking for triggers, it's important to evaluate food intolerances and some of the biggest culprits are gluten, dairy, and soy.
The cycle has to be broken somewhere. Usually the patient has to go through a certain period where they'll eliminate some things with the goal of healing the gut with the hopes of bringing those foods back at some point.
Case Study: 48 year old female with rhumatoid arthritis. She had been on conventional medication for a while but didn't feel comfortable so in conjunction with her doctor, she decided to stop and came to our clinic with the hope of finding a natural alternative.
Main complaints: Pain in hands, feet and knees; some swelling, red, hot joints; fatigue
During the intake, the triggers were pointing to digestive complaints she's had her whole life: diarrhea, constipation, bloating, heartburn. She also has a significant history of anxiety and depression.
I was most interested in the digestive and nervous systems. To look at the brain chemicals to see if the history of anxiety and depression may be impacting the immune system and possibly even the digestive complaints.
Typically on the first visit while waiting for testing to come back, I get them started on a pretty strong anti-inflammatory protocol using different anti-inflammatory supplements and diet techniques.
For this patient, we started with a stool test and a neurotransmitter test. She was starting to feel pretty well just on the anti-inflammatories but the stool test showed very low-levels of good flora, especially the lactobacillus family and a high level of a certain organism called Prevotella which is a virus that's being linked more and more to rhumatoid arthritis when it's found in the digestive system. Her neurotransmitter panel showed a little bit of an imbalance in her adrenaline markers.
Treatment started with natural antibiotics and probiotics. It's a little controversial but I choose to do both to eradicate that bacteria and also to enhance her good probiotic flora. Also trying to work on her adrenaline markers.
Adrenaline is made in the adrenal gland. Low adrenaline may be linked to adrenal fatigue. It's usually from chronic stress. I did some counseling with her to figure out where her stress is coming from and just working with her on stress management techniques like meditation, exercise, and basic things.
She's doing really well. Her anxiety, joint pain and digestive system are so much better. Just by eradicating this bacteria and boosting her good flora levels.
If a patient is on conventional medication, I think the best thing to do is to use functional medicine and natural medicine very safely making sure that nothing interacts with the medications to get the person to a place where they're feeling stable and well because when it comes to naturopathic medicine, our number one factor when we take our oath is: Do no harm. So if a patient goes off of their medication, pain will relapse for a certain period of time because you've removed the band-aid essentially. While that seem like a good thing to do in the long-run, the momentum starts to shift towards pain and inflammation in such a strong way that using natural medicine to stop that momentum and turn it around can be a little difficult.
What I typically say to a patient in that case is let's combine functional medicine, natural medicine with your prescriptions for now and get you to a place where you're feeling great. Once you're feeling great for a certain period of time, and that timeframe depends on the patient, then let's have a conversation with your rheumatologist about starting to slowly cut down. That way, we're in a bit more control of the situation and I feel like there's a forward momentum towards healing that even though we start to pull out some medication, the body may be in such a forward motion towards getting well that it may have less of a negative impact.
Dr. Sanders' website
Dr. Sanders' facebook page
Thank you for listening! If you enjoyed this podcast, please subscribe and leave a 5-star rating and review on iTunes!
Not Feeling Like Your Self? You…
The Eat-Clean Revolution with…
Fine to FAB: How to Change…
MELTing Away Chronic Pain with…


I am not a big fan of California Senator Dianne Feinstein, the former Mayor of San Francisco. I am not a big fan of former San Francisco Mayor Willie Brown, either. I do think, however, that Brown made a good point in the latest edition of his "Willie's World" column in the San Francisco Chronicle. The headline for the column that appeared yesterday, Sunday, was "Feinstein faces criticism for daring to be honest." That was the title of Brown's column as it appeared in the hard copy version of the paper. When you click the link, you'll get the online version, which comes with this title: "Feinstein's lesson in political correctness: Root for disaster from Trump."
The point Brown made in his column is not unlike the point I was attempting to make yesterday, in my blog posting about Phyllis Schlafly. How we react to statements with which we disagree is important. How we conduct our debates about what we ought to think, and what we ought to do, makes a difference in what kind of democracy we achieve.
Sen. Dianne Feinstein has become the latest victim in our new world of politics — one where instant emotional gratification and ideological reinforcement crowd out intelligent discourse.
Never mind that she also listed all her objections to both the president and his policies. Never mind that she's certainly right about Trump's impeachment chances, at least barring a Democratic landslide in 2018.
She did not feed the emotional needs of the audience. When some in attendance hissed at her candor, the story went viral, with Berniecrats quick to point to her remarks as proof California needs a new, progressive voice in the Senate.
Look, folks. There's no reason to root against Trump learning and changing and being a "good president." That would mean he wouldn't blunder us into a nuclear war with North Korea, and would get religion on immigration, and wouldn't let corporations do whatever they want to the environment. If he became a good president, that would mean he wasn't using the office to enrich himself and his family and that he was respecting the rule of law.
But if all you want to do is to shout down any peep of dissent from the party line, there's no room for that kind of reasoning. Feinstein found that out the hard way and, in less than 24 hours, had to issue a clarification defending herself.
That is the way it is in today's politics, where the key to success is to pander to people's emotions rather than getting them to think or face reality.


Published 04/18/2019 03:18:23 pm at 04/18/2019 03:18:23 pm in Air Repair Heating And Cooling.
air repair heating and cooling reibel specializes in ac repair in st paul air repair cooling and heating llc opelousas la white pages.
air conditioner repair heating and cooling,heating and cooling air conditioner repair,air repair heating and cooling,air repair heating and cooling inc,air repair cooling and heating llc opelousas la social security,air repair cooling and heating llc opelousas la,air repair heating and cooling tampa,car repair heating and cooling,air repair cooling and heating llc opelousas la daily world,air repair cooling and heating llc opelousas la white pages, air repair heating cooling llc walkersville maryland facebook air repair heating and cooling.


text:
Stop the Torture and Abuse of inmates at Calhoun Correctional Institution
Sabrina Sykes started this petition to Florida Governor
This petition is not just about my son Keenan. I am asking you to sign this petition because of the constant abuse being meted out to inmates at CALHOUN CORRECTIONAL INSTITUTION. The practice of taking inmates off camera to discipline them needs to be investigated. If an inmate is out of regulation it should be dealt with at that very instance on camera. Every guard that works at CALHOUN CORRECTIONAL INSTITUTION needs to be investigated for abuse, writing fraudulent reports, coverups and using excessive force as well as the warden.
My son Flippins was recently sent to Calhoun Correctional Institution to serve his time. He observed daily how the guards (COs) abused inmates housed at this particular camp. One evening he called and shared that a female guard accused him of rolling his eyes at her. A CPT. then took him in the bathroom off camera and told him he was going to gas, beat and throw him into solitary confinement because he thought he saw him roll his eyes at the female guard. Keenan assured the CPT. that he did not roll his eyes. This happened on a Tuesday. Keenan asked me to report the threat to the Inspector Generals (IG) office that evening (Tuesday). I wrote the threat including names and witnesses exactly as it was told to me and submitted it via the IG website. I received a call from Asst. Warden Kent the next day (1/30/19) thanking me for reporting the threat and assuring me that an investigation would be done to ascertain exactly what happened. I sent my son a message via JPAY letting him know an investigation would ensue because of the threat. I then told him to make sure someone besides himself had my number and our code word. I did this because if something were to happen to him he would not be able to reach out and call me himself. I spoke to Keenan briefly on Friday evening and asked him if all was well. He assured me everything was fine, but reiterated that the guards that threatened him would be coming on duty within the hour. At approximately 6:30pm I received a call from another inmate (unknown to me) that the guards did their walk through and count and immediately zoned in on Keenan. They took him into the bathroom off camera, stripped him, gassed him, beat him and took him to the box (solitary confinement). I received another call from another inmate describing how Keenan was sitting on his bed when the guards approached him, grabbed him and took him in the bathroom off camera where they gassed and beat him. I received a 3rd call from the parent of another inmate letting me know how upset her son was, because he had just witnessed the COs snatch my son from his bunk, take him into the bathroom, gas and beat him. Abuse like this must stop, but it will only stop if this institution and it's guards are investigated. All 3 witnesses that called me have since been put in confinement as retaliation for calling me. Please sign my petition and share it with as many people as you can. Offenders are sent to jail/prison as punishment, they are not sent there to be punished by the guards and those who are in authority over them. THANK YOU FOR YOUR SUPPORT.


text:
Ranbir Kapoor 09/28/1982 , (39 years old) in Mumbai, Maharashtra, India
Ranbir Kapoor is an Indian actor who appears in Bollywood movies. He first appeared in the 2007 film Saawariya for which he won a Filmfare Best Male Debut Award. Born to actors Rishi Kapoor and Neetu Singh, Kapoor is the great grandson of Prithviraj Kapoor and the grandson of actor and filmmaker Raj Kapoor. He is the brother of Riddhima Kapoor and his uncles are Randhir Kapoor and Rajiv Kapoor. Other notable family members include his cousins Karisma Kapoor, Kareena Kapoor and Nikhil Nanda. As a child, Kapoor studied at Bombay Scottish School in Mahim, Mumbai, and went on to pursue method acting at The Lee Strasberg Theatre and Film Institute in New York. Kapoor currently lives with his parents in Pali Hill in Mumbai, Maharashtra. He announced that he was dating Bollywood actress Deepika Padukone in an interview in February 2008. The couple later broke up in October 2009.
The Kapil Sharma Show (2016)
Comedy Nights with Kapil (2013)
PK (2014)
Alien Scientist (Cameo Appearance)
Rockstar (2011)
Janardan Jakhar / Jordan
Barfi! (2012)
Murphy Johnson "Barfi"
Sanju (2018)
Ajab Prem Ki Ghazab Kahani (2009)
Prem Shankar Sharma
Yeh Jawaani Hai Deewani (2013)
Kabir 'Bunny' Thapar
Wake Up Sid (2009)
Sidharth Mehra (Sid)
Ae Dil Hai Mushkil (2016)
Ayan Sanger
Bachna Ae Haseeno (2008)
Love per Square Foot (2018)
Gattu (Special Appearance)
Saawariya (2007)
Ranbir Raj
Tamasha (2015)
Ved Sahni
Jagga Jasoos (2017)
Jagga
Raajneeti (2010)
Samar Pratap
Rocket Singh: Salesman of the Year (2009)
Harpreet Singh Bedi
Bombay Talkies (2013)
Himself (uncredited)
Chillar Party (2011)
Item Number (Tai Tai Phish)
Anjaana Anjaani (2010)
Luck by Chance (2009)
Brahmāstra Part One: Shiva (2022)
Shiva Tripathi
Shamshera (2022)
Bhoothnath Returns (2014)
Himself (Cameo Appearance)
Roy (2015)
Besharam (2013)
Besharam
Bombay Velvet (2015)
Johnny Balraj
Untitled Luv Ranjan's Project (2023)
Animal (2023)
Karma (2004)


text:
10 Talented men sing majestic 'Hallelujah'
Music remains an enchanting experience in all the different ways it can be expressed or produced. There are so many diverse ways of creating sound and the way it is performed as well. Whether we are watching a band, a solo performer, an orchestra, or even a choir we can always appreciate the deep emotions and appreciation shared between whether we are the performers or the viewers.
Photo by Yuting Gao from Pexels Source: Photo by Yuting Gao from Pexels
One Australian music ensemble called 'The Ten Tenors' composed of 10 singers has toured nationally and internationally sharing those special moments with all those who get the opportunity to sit in the audience. On to their website TheTenTenors.com, they provide a brief background of their history on their about page stating that the group first formed in 1995 and since then their signature brand of music is featuring 10-part harmonies. One of their performances that has since been appreciated worldwide was an amazing cover they did of the song "Hallelujah (Leonard Cohen Cover)" that has over 6,770,000 views and 58k likes.
Video by The Ten Tenors on Youtube Source: Video by The Ten Tenors on Youtube
The stage starts out with an all-black background with blue and purple lights highlighting just the orchestra and the choir. Once they sit down the orchestra and the Tenors begin their show. As the first tenor begins with the opening lyrics it echoes beautifully throughout the room. Then the other tenors join in softly while perfectly synchronized in harmony together to bring in the chorus.
Then it is the next tenors turn and as each tenor debuts their voice we understand why they work so well together. Each with their own unique voice that adds to the greater whole of the ensemble.
Once again they zoom the camera out to show us the tenors as they stand on stage and the full view of the orchestra behind them. The four main singers sitting in the chairs and the other six tenors standing in the back behind them.
Then the third main tenor takes his turn building up to the climax of the song.
Next is the big moment that hits and the orchestra increases their intensity as the Tenors belt out altogether. As that is all happening the black background slowly lights up. Creating an even more magical show.
Then we take a brief moment to come down for just a moment as the fourth and final main tenor takes his turn.
Then the energy of the orchestra and the tenors begin to increase again for the ending of the song. Even the drummer gets to jam out as the intensity of the song builds on stage.
The orchestra then closes out the song and one of the tenors lets out the last lyric ever so gently and the crowd can barely wait to start applauding the performance they just witnessed. A true treat to be able to watch a recording that we can only imagine the intensity and emotions shared witnessing this performance in real life!
To stay updated on what The Ten Tenors are up to and more click the links below!
Listen to 'The Ten Tenors' latest album titled "Wish You Were Here": http://smarturl.it/TTT_WYWH
Website: http://thetentenors.com/
Facebook: www.facebook.com/thetentenors
Instagram: www.instagram.com/thetentenors
Twitter: www.twitter.com/thetentenors
Sources: Youtube, Pexels, TheTenTenors.Com
Dani Halteman
Dani Halteman is a contributor at Shareably.
51 real-life cartoon character lookalikes that shatter reality


text:
Arturo Gallea (18 September 1895 – 21 September 1959) was an Italian cinematographer and producer.

Born in Turin, Gallea entered the industry of cinema in 1911 as a film producer. He began his career as a cinematographer in the mid-1910s and,  in 1952, won the Nastro d'Argento for best cinematography for his work in Renato Castellani's Two Cents Worth of Hope. Gallea died in a car accident in 1959.

Selected filmography

La crociata degli innocenti   (1916)
 The Cry of the Eagle (1923)
Nini Falpala (1933)
 The Matchmaker (1934)
 Creatures of the Night (1934)
 The Blind Woman of Sorrento (1934)
Don Bosco   (1935)
The Man Who Smiles   (1936)
 God's Will Be Done (1936)
 Adam's Tree (1936)
Music in the Square (1936)
 The Two Sergeants (1936)
Triumph of Love   (1938)
The Lady in White   (1938)
Marionette   (1938)
Under the Southern Cross   (1938)
 Defendant, Stand Up! (1939)
 The Document (1939)
At Your Orders, Madame   (1939)
We Were Seven Sisters   (1939)
 Wealth Without a Future (1939)
 It Always Ends That Way (1939)
 A Romantic Adventure (1940)
Piccolo mondo antico   (1941)
 The Last Dance (1941)
 The Man on the Street  (1941)
 Light in the Darkness (1941)
 The Queen of Navarre (1942)
 Disturbance (1942)
 Jealousy (1942)
Love Story   (1942)
 The Materassi Sisters (1944)
 The Priest's Hat (1944)
Lo sbaglio di essere vivo   (1945)
Il mondo vuole così   (1946)
 The Unknown Man of San Marino (1946)
 Fire Over the Sea (1947)
 The Lady of the Camellias (1947)
 William Tell (1949)
 The Legend of Faust (1949)
 Mistress of the Mountains (1950)
Volcano  (1950)
 Captain Demonio (1950)
Two Cents Worth of Hope  (1952)
The White Sheik  (1952)
 Son of the Hunchback (1952)
Bread, Love and Dreams   (1953)
 The Merchant of Venice (1953)
Bread, Love and Jealousy   (1954)
 The King's Prisoner (1954)
 Orphan of the Ghetto (1954)
The Widow   (1955)
I pappagalli   (1955)
The Belle of Rome   (1955)
 The Angel of the Alps (1957)
Valeria ragazza poco seria   (1958)

References

External links

1895 births
1959 deaths
Italian cinematographers
Film people from Turin
Nastro d'Argento winners
Road incident deaths in Italy

redpajama_set_name: RedPajamaWikipedia


You go to the cereal box and it is has been left open!
You come down in the morning and the last person to go to bed hadn't turned off the light!
The last person to use the butter just left the empty tub in the fridge!
But nothing beats the empty loo roll! Oh why don't they just put a new one on when it is finished! I WAS tempted to do it back to them.... but I just couldn't!


Speak to people you know who have had dental treatment. Ask them about how comfortable their dentists made them feel, and how they felt about the treatment they received.
Consult as many people as you feel necessarily, and select your dentist from the recommendation you either trust most or were most impressed by. If possible, ask the person who referred you to your new dentist to attend your appointment with you.
Prior to making a firm booking with a dental practice, ask the practice you are thinking about visiting about coming to see them so that they can show you around their premises and introduce you to their team. Explain to them that the reason for this is that you are not feeling very confident about visiting the dentist, and this should prompt them to do everything in their power to make you feel at ease.
Something to remember when you come to book your appointment is to try to book it as early in the day as possible. It sounds simple, but by booking an early morning appointment you will spend less of your day worrying and will be far less anxious by the time you see your dentist.
Essentially, there is genuinely nothing to worry about in terms of your first appointment. Your first trip to the dentist will merely be a consultation, and if any further treatment is required, it will almost be certainly scheduled for a different day. It is highly unlikely that any of the dental treatments you dread will be performed during your initial consultation.
If it is cosmetic dental surgery that you are ultimately interested in, then it would be a good idea to try a less intensive treatment first (such as polishing or teeth whitening) in order to allow you to become accustomed with receiving dental treatment. From here, you may feel more willing to approach the prospect of the treatments you are more interested in which require more work.
If you do require a procedure or treatment that you feel worried or anxious about, then discuss this with your dentist before it commences. If possible, ask him if there will be opportunities for the dentist to allow you to stop him when you feel it is necessary. This is usually done by some form of physical signal (for example, raising of a hand).


text:
Q: EXECUTE FORMAT() USING in postgres is showing error for $ i will directly get to the code rather than explaining too much
execute format('
                "$1" = select "Source1" from temp_tables._%s;
                '::text, (translate("Song_Id_"::text, '-', '_')))
using "Source1__";

the table is dynamically created and the table name is all fine as i have used that table to insert some data into it. if i run this code, the error i am getting is
ERROR:  syntax error at or near "$1"
LINE 1: $1 = select "Source1" from temp_tables._24af1593_3539_49fd_9...
        ^
QUERY:  $1 = select "Source1" from temp_tables._24af1593_3539_49fd_9ef4_29307f301d38;

i have tried other method too like
execute
        '$1 = select "Source1" from temp_tables._' || (translate("Song_Id_"::text, '-', '_')) ||';'
        using "Source1__";

even this gives the same error.
note : "Source1__" is a variable of type text declared in the stored procedure where everything else is being executed too.

A: This is wrong. The EXECUTE command accepts only SQL statements. There is nothing statement like var = SELECT .... More - the you can pass just value by using clause USING. You cannot to pass any reference to variable. Solution is easy. Just use clause INTO
EXECUTE 'SELECT ... ' INTO target_plpgsql_variable

Please, read related documentation. Unfortunately, some parts the stored procedures are not extra intuitive because there is mix of two very different languages. It is good by reading documentation, because is hard to find correct solution without knowledge of possibilities and syntax.

redpajama_set_name: RedPajamaStackExchange


text:
The Adamawa State Government has directed the closure of all schools with immediate effect.
December 18, 2020 precious presloaded NEWS 0
The order, issued by the state Ministry of Education, came to light Friday when the Permanent Secretary of the Ministry of Education and Human Capital Development, Aisha Abubakar said the closure is to take immediate effect.
"The Ministry of Education and Human Capital Development wishes to direct and announce the immediate closure of private and public schools in the state," she stated.
The ministry gave no reason for the closure of schools, causing many to link it to exigencies of COVID-19 but when contacted, Governor Ahmadu Fintiri's Press Secretary, Mr Humwashi Wonosikou, attributed it to the Christmas's and New Year festivities.
"This is to allow school children to go home early for the Yuletide and New Year celebrations.
"The schools are to resume for the second term on Monday 11th January 2021," Wonosikou said.
READ ALSO: BADLUCK! Side Chick Dies In Married Man's House In Imo
Kaduna State Government Condemns Attack On Gora Gan Community
Cross River State Commissioner Of Police Allegedly Dies Of COVID-19


text:
episource Follow
episource
episource episource
Uhldingen, Germany
www.episource.de
Block or report episource
git-merge-subtree2 Public
Tracking of subdirectories from other branches: a subtree-like merge strategy and a custom subproject git command.
Keepass-SmartcardEncryptedKeyFile Public
This plugin adds support for using (multiple) smartcards as second factor to unlock KeePass databases. This is implemented in a manner, that is fully compatibly with built-in key files: Keeping a p…
C# 3 1
jekyll-uncss Public
A Jekyll plugin that uses uncss to remove unused css rules.
Ruby 20 6
jekyll-js-minify-plugin Public
Forked from lyoshenka/jekyll-js-minify-plugin
A Jekyll plugin that automatically minifies all Javascript files using the Google Closure Compiler
unbound-modules Public
Custom (python) modules for the unbound dns resolver.
Python 11 1
unblocker Public
A .net framework library to execute most code - including blocking system calls - asynchronously, with the ability to cancel the invocation at any time.
No contributions on January 23, 2022 No contributions on January 24, 2022 No contributions on January 25, 2022 No contributions on January 26, 2022 No contributions on January 27, 2022 No contributions on January 28, 2022 No contributions on January 29, 2022 No contributions on January 30, 2022 No contributions on January 31, 2022 No contributions on February 1, 2022 No contributions on February 2, 2022 No contributions on February 3, 2022 No contributions on February 4, 2022 No contributions on February 5, 2022 No contributions on February 6, 2022 No contributions on February 7, 2022 No contributions on February 8, 2022 No contributions on February 9, 2022 No contributions on February 10, 2022 No contributions on February 11, 2022 No contributions on February 12, 2022 No contributions on February 13, 2022 No contributions on February 14, 2022 No contributions on February 15, 2022 No contributions on February 16, 2022 No contributions on February 17, 2022 No contributions on February 18, 2022 No contributions on February 19, 2022 No contributions on February 20, 2022 No contributions on February 21, 2022 No contributions on February 22, 2022 No contributions on February 23, 2022 No contributions on February 24, 2022 1 contribution on February 25, 2022 2 contributions on February 26, 2022 No contributions on February 27, 2022 2 contributions on February 28, 2022 No contributions on March 1, 2022 No contributions on March 2, 2022 No contributions on March 3, 2022 No contributions on March 4, 2022 6 contributions on March 5, 2022 No contributions on March 6, 2022 No contributions on March 7, 2022 No contributions on March 8, 2022 No contributions on March 9, 2022 No contributions on March 10, 2022 2 contributions on March 11, 2022 1 contribution on March 12, 2022 1 contribution on March 13, 2022 No contributions on March 14, 2022 1 contribution on March 15, 2022 No contributions on March 16, 2022 No contributions on March 17, 2022 No contributions on March 18, 2022 3 contributions on March 19, 2022 1 contribution on March 20, 2022 No contributions on March 21, 2022 1 contribution on March 22, 2022 No contributions on March 23, 2022 No contributions on March 24, 2022 No contributions on March 25, 2022 No contributions on March 26, 2022 No contributions on March 27, 2022 No contributions on March 28, 2022 No contributions on March 29, 2022 No contributions on March 30, 2022 No contributions on March 31, 2022 No contributions on April 1, 2022 No contributions on April 2, 2022 No contributions on April 3, 2022 No contributions on April 4, 2022 No contributions on April 5, 2022 No contributions on April 6, 2022 No contributions on April 7, 2022 No contributions on April 8, 2022 No contributions on April 9, 2022 No contributions on April 10, 2022 No contributions on April 11, 2022 No contributions on April 12, 2022 No contributions on April 13, 2022 No contributions on April 14, 2022 No contributions on April 15, 2022 No contributions on April 16, 2022 No contributions on April 17, 2022 No contributions on April 18, 2022 No contributions on April 19, 2022 No contributions on April 20, 2022 No contributions on April 21, 2022 No contributions on April 22, 2022 No contributions on April 23, 2022 No contributions on April 24, 2022 No contributions on April 25, 2022 No contributions on April 26, 2022 No contributions on April 27, 2022 No contributions on April 28, 2022 No contributions on April 29, 2022 No contributions on April 30, 2022 No contributions on May 1, 2022 No contributions on May 2, 2022 No contributions on May 3, 2022 No contributions on May 4, 2022 No contributions on May 5, 2022 No contributions on May 6, 2022 No contributions on May 7, 2022 No contributions on May 8, 2022 No contributions on May 9, 2022 No contributions on May 10, 2022 No contributions on May 11, 2022 No contributions on May 12, 2022 No contributions on May 13, 2022 No contributions on May 14, 2022 No contributions on May 15, 2022 No contributions on May 16, 2022 No contributions on May 17, 2022 No contributions on May 18, 2022 No contributions on May 19, 2022 No contributions on May 20, 2022 No contributions on May 21, 2022 2 contributions on May 22, 2022 No contributions on May 23, 2022 No contributions on May 24, 2022 No contributions on May 25, 2022 7 contributions on May 26, 2022 No contributions on May 27, 2022 No contributions on May 28, 2022 No contributions on May 29, 2022 5 contributions on May 30, 2022 No contributions on May 31, 2022 No contributions on June 1, 2022 No contributions on June 2, 2022 No contributions on June 3, 2022 No contributions on June 4, 2022 No contributions on June 5, 2022 No contributions on June 6, 2022 No contributions on June 7, 2022 1 contribution on June 8, 2022 No contributions on June 9, 2022 No contributions on June 10, 2022 No contributions on June 11, 2022 No contributions on June 12, 2022 No contributions on June 13, 2022 No contributions on June 14, 2022 No contributions on June 15, 2022 No contributions on June 16, 2022 No contributions on June 17, 2022 No contributions on June 18, 2022 No contributions on June 19, 2022 No contributions on June 20, 2022 No contributions on June 21, 2022 No contributions on June 22, 2022 No contributions on June 23, 2022 No contributions on June 24, 2022 No contributions on June 25, 2022 No contributions on June 26, 2022 No contributions on June 27, 2022 No contributions on June 28, 2022 No contributions on June 29, 2022 No contributions on June 30, 2022 No contributions on July 1, 2022 No contributions on July 2, 2022 No contributions on July 3, 2022 No contributions on July 4, 2022 No contributions on July 5, 2022 No contributions on July 6, 2022 No contributions on July 7, 2022 No contributions on July 8, 2022 No contributions on July 9, 2022 No contributions on July 10, 2022 No contributions on July 11, 2022 No contributions on July 12, 2022 No contributions on July 13, 2022 No contributions on July 14, 2022 No contributions on July 15, 2022 No contributions on July 16, 2022 No contributions on July 17, 2022 No contributions on July 18, 2022 No contributions on July 19, 2022 No contributions on July 20, 2022 No contributions on July 21, 2022 No contributions on July 22, 2022 No contributions on July 23, 2022 No contributions on July 24, 2022 No contributions on July 25, 2022 No contributions on July 26, 2022 No contributions on July 27, 2022 No contributions on July 28, 2022 No contributions on July 29, 2022 No contributions on July 30, 2022 No contributions on July 31, 2022 No contributions on August 1, 2022 No contributions on August 2, 2022 No contributions on August 3, 2022 No contributions on August 4, 2022 No contributions on August 5, 2022 No contributions on August 6, 2022 No contributions on August 7, 2022 No contributions on August 8, 2022 No contributions on August 9, 2022 No contributions on August 10, 2022 No contributions on August 11, 2022 No contributions on August 12, 2022 No contributions on August 13, 2022 No contributions on August 14, 2022 No contributions on August 15, 2022 No contributions on August 16, 2022 No contributions on August 17, 2022 No contributions on August 18, 2022 No contributions on August 19, 2022 No contributions on August 20, 2022 No contributions on August 21, 2022 No contributions on August 22, 2022 No contributions on August 23, 2022 No contributions on August 24, 2022 No contributions on August 25, 2022 No contributions on August 26, 2022 No contributions on August 27, 2022 No contributions on August 28, 2022 No contributions on August 29, 2022 No contributions on August 30, 2022 No contributions on August 31, 2022 No contributions on September 1, 2022 No contributions on September 2, 2022 No contributions on September 3, 2022 No contributions on September 4, 2022 No contributions on September 5, 2022 No contributions on September 6, 2022 No contributions on September 7, 2022 No contributions on September 8, 2022 No contributions on September 9, 2022 No contributions on September 10, 2022 No contributions on September 11, 2022 No contributions on September 12, 2022 No contributions on September 13, 2022 3 contributions on September 14, 2022 No contributions on September 15, 2022 No contributions on September 16, 2022 No contributions on September 17, 2022 No contributions on September 18, 2022 No contributions on September 19, 2022 No contributions on September 20, 2022 No contributions on September 21, 2022 No contributions on September 22, 2022 No contributions on September 23, 2022 No contributions on September 24, 2022 No contributions on September 25, 2022 No contributions on September 26, 2022 No contributions on September 27, 2022 No contributions on September 28, 2022 No contributions on September 29, 2022 No contributions on September 30, 2022 No contributions on October 1, 2022 No contributions on October 2, 2022 No contributions on October 3, 2022 No contributions on October 4, 2022 No contributions on October 5, 2022 No contributions on October 6, 2022 No contributions on October 7, 2022 2 contributions on October 8, 2022 No contributions on October 9, 2022 No contributions on October 10, 2022 No contributions on October 11, 2022 No contributions on October 12, 2022 No contributions on October 13, 2022 No contributions on October 14, 2022 No contributions on October 15, 2022 No contributions on October 16, 2022 No contributions on October 17, 2022 No contributions on October 18, 2022 No contributions on October 19, 2022 No contributions on October 20, 2022 No contributions on October 21, 2022 No contributions on October 22, 2022 No contributions on October 23, 2022 No contributions on October 24, 2022 No contributions on October 25, 2022 No contributions on October 26, 2022 No contributions on October 27, 2022 No contributions on October 28, 2022 No contributions on October 29, 2022 No contributions on October 30, 2022 No contributions on October 31, 2022 No contributions on November 1, 2022 No contributions on November 2, 2022 No contributions on November 3, 2022 No contributions on November 4, 2022 No contributions on November 5, 2022 No contributions on November 6, 2022 No contributions on November 7, 2022 No contributions on November 8, 2022 No contributions on November 9, 2022 No contributions on November 10, 2022 No contributions on November 11, 2022 No contributions on November 12, 2022 No contributions on November 13, 2022 No contributions on November 14, 2022 No contributions on November 15, 2022 No contributions on November 16, 2022 No contributions on November 17, 2022 No contributions on November 18, 2022 No contributions on November 19, 2022 No contributions on November 20, 2022 No contributions on November 21, 2022 No contributions on November 22, 2022 No contributions on November 23, 2022 No contributions on November 24, 2022 No contributions on November 25, 2022 No contributions on November 26, 2022 No contributions on November 27, 2022 No contributions on November 28, 2022 No contributions on November 29, 2022 No contributions on November 30, 2022 No contributions on December 1, 2022 No contributions on December 2, 2022 No contributions on December 3, 2022 No contributions on December 4, 2022 No contributions on December 5, 2022 No contributions on December 6, 2022 No contributions on December 7, 2022 No contributions on December 8, 2022 No contributions on December 9, 2022 No contributions on December 10, 2022 No contributions on December 11, 2022 No contributions on December 12, 2022 No contributions on December 13, 2022 No contributions on December 14, 2022 No contributions on December 15, 2022 No contributions on December 16, 2022 No contributions on December 17, 2022 No contributions on December 18, 2022 No contributions on December 19, 2022 No contributions on December 20, 2022 No contributions on December 21, 2022 No contributions on December 22, 2022 No contributions on December 23, 2022 No contributions on December 24, 2022 No contributions on December 25, 2022 No contributions on December 26, 2022 3 contributions on December 27, 2022 No contributions on December 28, 2022 No contributions on December 29, 2022 No contributions on December 30, 2022 No contributions on December 31, 2022 No contributions on January 1, 2023 No contributions on January 2, 2023 No contributions on January 3, 2023 No contributions on January 4, 2023 No contributions on January 5, 2023 No contributions on January 6, 2023 No contributions on January 7, 2023 No contributions on January 8, 2023 No contributions on January 9, 2023 No contributions on January 10, 2023 No contributions on January 11, 2023 No contributions on January 12, 2023 No contributions on January 13, 2023 1 contribution on January 14, 2023 No contributions on January 15, 2023 No contributions on January 16, 2023 No contributions on January 17, 2023 No contributions on January 18, 2023 No contributions on January 19, 2023 No contributions on January 20, 2023 No contributions on January 21, 2023 No contributions on January 22, 2023 No contributions on January 23, 2023 No contributions on January 24, 2023 No contributions on January 25, 2023 No contributions on January 26, 2023 No contributions on January 27, 2023 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Sun Mon Tue Wed Thu Fri Sat
Created 1 commit in 1 repository
episource/picopdio 1 commit


text:
Q: How can I find the InternetRegistry User Key or Parent Registry Key I have a BHO which on the first run is gathering activation information and storing this in the registry.
(I think) due to IE's permission's I am only able to store this in the registry branch

HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\InternetRegistry\REGISTRY\USER\S-0-0-00-000000000-000000000-000000000-0000\Software\MyBHO\MyKey

Where S-0-0-00-000000000-000000000-000000000-0000 is a unique key for each user.
Which is fine using RegCreateKey() with "Software\MyBHO\MyKey". It's all created and running lovely. It determines where in space to store the Key with no problems.
The Problem:
When I carry out an uninstall I want to remove this key and as this is run outside of IE I have no way to determine where that key is / what the user string is.
Options I have in mind:
Option 1 (Ideal)
Find out this user string first to then build a new path for the key I wish to remove and remove it. How?
Option 2
At the point of activation store the path to the key in another registry value that can be accessed. Then read, and delete both (Which seems a bit backwards and probably wont work due to the access restrictions of the BHO on the registry (Thus it being written there in the first place))
Do you know if there is any way to find this User key or even how to find the parent dir.
Edit Upon continued research I've found that the thing I'm referring to as "user key" is the current Users "SID". Maybe this will yield me better results.

A: Call GetUserName to get the user name, and LookupAccountName to get his SID.
ConvertSidToStringSid is a useful utility function to format a SID as a S-1-5-32-00000000-00000000-00000000-00000000-0000 string

A: If you really want to write per-user data to the registry, use IEGetWriteableHKCU().
In general there is no good way to remove per-user data at uninstall.  For example, what if you install as user A and the uninstall as user B?  Are you going to go find all of them and delete them?  Just leave the turds behind.
Alternatively you could consider using a different data store.  Do you really need the registry?  Can you store this data in a file?  What about Web Storage?


text:
News Flash: Giving Banks Billions Won't Create Jobs
Last year, President Obama signed into law the $30 billion Small Business Lending Fund as a way to stimulate job creation.
"It's going to speed relief to small businesses across the country right away," Obama said at the time.
It was supposed to help create 500,000 jobs.
Well, not so much.
Not only has the program been a dismal failure, with few banks applying to participate, but it turned into another giant taxpayer handout to bankers.
Only $4 billion was handed over to banks under the lending scheme. The bankers didn't use it to boost small businesses, and it turned out they weren't even required to. Instead the bankers used more than $2 billion to pay off their bailout debt to the Troubled Asset Relief Program, according to a story in the October 12 Wall Street Journal (no link).
"It was basically a bailout for a 100-plus banks," Giovanni Coratolo, vice-president of small-business policy at the U.S. Chamber of Commerce, told the Journal.
None of this should come as a surprise. Bankers said at the time that the problem was not that they didn't have enough money to lend, but that demand for loans was weak because of the continuing bad economy.
"Until you start to see the economy improve and job growth you won't see lots of loan demand," Thomas Dorr, chief financial officer of Bank of Birmingham in Michigan, which received $4.6 million from the program, told Bloomberg. "You can't force banks to lend."
The lending program was either just another veiled handout to the banks or another lame attempt at trickle-down stimulus. Either way it contributes to the strong impression that our political leaders aren't actually working on solutions, they're getting in our way.
Congress / D.C. Disconnect / Martin Column / President Barack Obama / TARP - 10/13/2011
Listening to Our History
Driving through the west, headed towards home from a cross-country road trip with my wife Stacie and dog Billie, there's endless hours on the highway, no Internet and not much radio except for hard-right talk.
Hearing the voices passing through the desert states is a grim reminder of the forces we're up against, who now characterize themselves as the real "community organizers," who represent the real people.
It's not just the right wing. Lots of people have adopted the timid trickle-down theories embodied by our political leadership: "Don't get too tough on BP or they'll take away our jobs. Don't cross Wall Street, we need to keep the market stable."
We're in Winslow, Arizona, wondering whether a boycott will worsen the dire poverty we see in front of us. It's easier and more politically expedient to make immigrants the scapegoats for lack of jobs and economic uncertainty than it is to question a system that is seriously out of whack, that offers the biggest rewards to those who gamble on our collective losses without risking their own wealth.
That's what a big chunk of the financial system like hedge funds and derivatives has become. Cynical and bloodthirsty, producing nothing except profits for the few. And the gesture toward financial reform winding its way through congressional conference committee does little to change that.
I understand the fears of friends and family that the money they have saved and invested over the years will be lost if we challenge Wall Street and the robber barons of our time. The financial industry has shown that if it doesn't get what it wants it is capable of wrecking our economy and causing great suffering for others. But this kind of blackmail undermines democracy. We deserve a financial system that provides both transparency and financial security.
Traveling through the country, along roads adjacent to rail lines and mile-long freight trains, I kept thinking about our nation's history and those rare moments of courageous leadership like Teddy Roosevelt tackling the railroad trusts, and FDR and his team creating the New Deal to save the financial system from its own excesses. And the creation of the GI Bill, which was designed to bolster possibilities for people who risked their lives for our country, and had played a huge part in the creation of a vital middle class. These were moments when audacious politics met pragmatic problem-solving.
I attended the Personal Democracy Forum in New York City earlier this month. The topic of the wide-ranging conference was "Can the Internet Save Politics?"
One of the most inspiring speakers was Daniel Ellsberg. Amid all the excitement over the possibilities for political activism and engagement with new social media, Ellsberg reminded us that one of the most important ingredients is the same as it always was: moral courage.
Ellsberg was the Pentagon military analyst who leaked a secret Defense Department account of the disgraceful political decisions that led the country into the Vietnam War and its outcome. Plenty of people on the inside knew what was happening in Vietnam, Ellsberg said, but they had kids to put through college and mortgages to pay. They were not about to step outside the system and jeopardize their careers.
Not everybody has the nerve or inside information to be a whistleblower like Ellsberg. But we can demand a financial and economic system where we don't have to sacrifice our financial security to those who gamble against our futures.
We can demand that our president delivers on his campaign promise of real change. There can be no real change without confronting corporate power over our government and political system. We are as controlled today by the financial and oil industries as we were by the railroad barons when Teddy Roosevelt took them on. TR said one should speak softly and carry a big stick. President Obama has been doing the opposite. We need to demand that Barack Obama follow TR's suggestion.
Action / Martin Column / President Barack Obama - 06/20/2010