An artwork which collects industrial design and perfect sound quality.
205 backers pledged HK$ 101,178 to help bring this project to life.
Perfect sound quality is our highest pursuit.
The dual drivers produce clear treble, deep bass, and a balanced midrange. Powering the drivers is a Texas Instruments amplifier chip that guarantees distortion-free sound quality even at max volume.
We manufacture the case by following a 10 step aviation oxidation process, followed by precise cutting of the edges and speaker holes. The shell is then surface polished to perfection. Our speaker is a combination of modern design and industrial technology. We don't just pursue sound quality; we also pursue art.
Stronger batteries for a longer playtime.
The powerful 5200mAh internal battery enables you to listen to your music for more than 7 hours on a single charge. When it's time to recharge, it only takes 3.5 hours to get your speaker fully topped up.
The one-piece molding gives our speaker a distinct look and also makes it incredibly strong. The single tone case is elegant and easily matches any indoor or outdoor environment. Both your ears and eyes will love the AS1.
Our audio engineers spent 1,040 hours adjusting the output until they reached perfectly balanced high-fidelity sound. It has tri-band equalization making it suitable for all genres of music.
Aluminum body, simple and elegant. In addition to placed on the desk, family party and outdoor make good use of it as well.
Consumes less power and has better compatibility than previous versions, this gives you extended battery life and assurance it will connect easily to your smartphone. The exceptional range also gives you the freedom to move your smartphone throughout your home without disconnecting from the speaker.
5200mAH high-capacity batteries, to bring you lasting music enjoyment. Each 3.5h charge can guarantee more than 7h of music time.
Advanced audio converters and high -quality digital processing mean the AS1 Wireless sounds pristine, even at high volumes.
We have already put a lot of money into research, development and certification fees, but the cost of raw materials needed for production is high, we still need the help of everyone to complete the entire project. HKD 95,000,Injection molding tools.
HKD 20,000,R & D investment.
Each BlitzWolf product comes with 18 months limited warranty. We also ensure every unit is free from manufacturer defects and handle with care during shipment.
Just like other hardware R & D projects, materials, manufacturing, supply chain management and logistics, are ongoing risks and challenges.
Manufacturing risk: Our stringent requirement for materials and manufacturing quality means we do not allow any flaws in our products. That's why we are working with our manufacturing partners to build an efficient production system. This means that unexpected changes or problems may occur during execution, which may affect delivery times.
Logistics risk: Although we have professional logistics partners, we can not completely guarantee delivery times. Some unpredictable and natural factors may cause product delivery delays. If unfortunate events beyond our control happen, we will inform you and try our best to ensure that the product will be delivered to you in an acceptable timeframe.
-Your name on BlitzWolf website thank you page.
You've missed a low price, don't miss this one!
This is the last chance to enjoy a low price!
It is double, it is cheaper!
A price cheaper than wholesale.


Over the last century, "bringing home the bacon" has been the bailiwick of Southern federal legislators — especially those from Alabama — who promote the idea that the federal funding will help the local economies.
Policies like the New Deal's Tennessee Valley Authority, highway spending and federal defense spending are all part and parcel of this mindset to bring home those federal dollars.
With federal dollars, however, come federal dictates. Consider this month's controversy, which finds the Obama administration sniffing around Maxwell-Gunter Air Force Base near Montgomery, proposing to use it as a facility to house unaccompanied minors apprehended illegally crossing the U.S.-Mexico border.
The noncompliance, according to Bentley's office, is a failure of the federal government to consult with state officials about placement of refugees, in this case unaccompanied minors, if done so within a state's borders.
Given that the proposed action is set to take place on a U.S. military base, critics of Bentley's lawsuit don't expect it will succeed in nullifying the Obama administration's effort to house those illegal immigrant minors.
This raises a number of issues regarding the role of the federal government as a landowner, whether of military bases or national parks and forests.
For starters, Alabama's legislators have put a lot of effort into keeping military installations open in this state. Certainly, military bases offer some economic benefits to the area. But it comes with the cost of ceding ground when protesting executive branch actions — for example, using those bases to house illegal immigrant minors.
Going back over the last few years, Rep. Martha Roby (R-Alabama) has worked to prevent sequestration from impacting military installations in her congressional district and keep in place the 908th Airlift Wing at Maxwell-Gunter and the Army Aviation Center at Fort Rucker.
It would stand to reason that if our state's elected officials have no problem accepting millions in federal taxpayer dollars, then when it's time to for them to do something the federal government requests they probably should be a little more agreeable.
That's not to say it's the right thing to house illegal immigrant minors at a military base in Alabama. But if you're going to live by the federal government, you risk dying by the federal government.
But that raises a larger point: How is it that the federal government owns such an abundance of land that it can just house refugees whenever and wherever it sees fit? It's as if Maxwell-Gunter Air Force Base was just sitting there for the taking with unused resources and available for such a humanitarian effort.
If that's the case, wouldn't it be in the better interest of the taxpayers of this state to let Maxwell-Gunter Air Force Base take its efforts elsewhere so that Alabama isn't on the hook for having to house illegal immigrants within its borders?
But more broadly, it calls into question the amount of land the federal government owns, which — according to a 2012 Congressional Research Service report — is roughly 635 million acres of the 2.27 billion acres in the U.S., nearly a third of all the land.
Granted, the biggest portion of that land is from the Rocky Mountains westward, and mostly uninhabited. And according to that same report, a very small portion of federally owned land is located in Alabama: 844,000 acres, still a sizable amount of land.
Back to the Maxwell-Gunter Air Force Base question: Rather than put up a tooth-and-nail fight for federal funding to preserve military activities at Alabama's military installation, why not make a fight to let those activities go where they may and lobby the federal government to auction off the air force base land and allow the efficient private sector to do something economically beneficial for the region?
If that were the case, the public wouldn't have to worry about housing illegal immigrant minors within its borders and our elected officials could do something better with their time than fight federal government overreaches.
Closer to home, from just off the coast of Pass Christian, Mississippi, all the way to Port St. Joe, Florida, the federal government owns large chunks of the Gulf Coast. Going from west to east, the feds own the Gulf Islands National Seashore, the numerous U.S. Navy installations in and around Pensacola, Eglin Air Force Base near Fort Walton Beach and Tyndall Air Force Base just to the west of Panama City.
Some of that land would fetch a pretty penny if sold to the private sector. That's not to suggest the federal government shouldn't maintain ownership of some of it for conservation or national defense purposes. However, if those national defense exercises could be conducted elsewhere at the same or a lower cost to the taxpayer and those lands sold off to the private sector, it could be a huge benefit to the region.
This has been proven time and time again. The private sector is much more efficient than the public sector when it comes to generating economic activity. This is prized coastal real estate.
There are other numerous examples throughout the country. However, it goes back to the original statement: Is it really worth it to live off the federal government's teat, especially given the alternatives?


text:
<?php

/**
 * Block of links in Order view page
 *
 * @category    Collinsharper
 * @package     Collinsharper_Canpost
 * @author      Maxim Nulman
 */
class Collinsharper_Canpost_Block_Google_Office_Map extends Mage_Core_Block_Template
{

}

redpajama_set_name: RedPajamaGithub


According to ATD's 2014 State of the Industry Report, instructor-led training (ILT) continues to be the most popular training method, accounting for more than half of all training that is available or 68.87% respectively. If your organization's training is still dominated by instructor-led training classes, perhaps it's time you considered managing this process using a learning management system?
Using an LMS to manage your ILT initiatives can effectively reduce your administrative expenses while streamlining many aspects of your current process; such as class scheduling, developing waiting lists and sending out class notifications to tracking class registrations. An LMS will also provide you with a complete electronic history of your learners' class activities including attendance, completions, CEUs, and test or assessment scores, to name a few. Managers can have access to reporting so they can have the information they need about their staff training records right at their fingertips. All of these functions are easily automated within the LMS so there's no need to perform these functions manually – that provides you with incredible savings in time and you know what they say time is money!
Do you want to register your learners for classes or would you like them to self-register for their classes? Would you like your instructor to electronically input attendance rather than handing off an attendance sheet to your training department? After the class is finished, would you like your instructors to officially complete your learners' classroom activities or would you prefer your learners to log-in to your LMS and take a test or assessment to complete their own activity? Maybe you have support materials that you'd like your learners to download before or after their class – the great news is that you have the flexibility to decide. You can decide how much of the process you own, or how much you'd like to empower your instructors and learners with!
Looking to Monetize Your Instructor-led Training Classes?
Are you in an industry where you can sell your instructor-led training classes? If so, you can easily integrate your LMS with an e-commerce engine to sell classroom seats online. Learners can self-register and pay for classes online and their receipt can include classroom specific information such as directions, weather advisory statements or cancellation policies, etc.
Using an LMS to manage you instructor-led training classes definitely has its perks including flexibility, reduced expenses, and perhaps even generating revenue. So what do you think? Maybe it's time to take advantage of what learning management technology has to offer to help you manage your instructor-led training classes? Here's something to think about: step one – manage your ILT with an LMS, step two – transition your ILT to eLearningit's just a thought!


ActiveJet Toner Canon C-EXV14 Supreme (ATC-EXV14N) 8300 str.
ActiveJet Toner BROTHER TN-2000 Supreme (ATB-2000N, [AT-2000N]) 2500 str.
ActiveJet Toner BROTHER TN-135C Supreme (ATB-135CN) 4000 str.
ActiveJet Toner BROTHER TN-241BK Supreme (ATB-241BN) 2500 str.
ActiveJet Toner BROTHER TN-245C Supreme (ATB-245CN) 2200 str.
ActiveJet Toner BROTHER TN-245Y Supreme (ATB-245YN) 2200 str.
ActiveJet Toner BROTHER TN-1030 Supreme (ATB-1030N) 1000 str.
ActiveJet Toner BROTHER TN-230Y Supreme (ATB-230YN) 1400 str.
ActiveJet Toner BROTHER TN-325BK Supreme (ATB-325BN) 4000 str.
ActiveJet Toner BROTHER TN-325C Supreme (ATB-325CN) 3500 str.
ActiveJet Toner BROTHER TN-325M Supreme (ATB-325MN) 3500 str.
ActiveJet Toner BROTHER TN-325Y Supreme (ATB-325YN) 3500 str.
ActiveJet Toner BROTHER TN-328Y Supreme (ATB-328YNX) 6 000 str.
ActiveJet Toner BROTHER TN-326M Supreme (ATB-326MN) 3 500 str.
ActiveJet Toner Epson C13S050435 Supreme (ATE-2000NX) 8000 str.


text:
Korea National League Championship was a football league cup competition operated by the Korea National League.

Champions

List of finals

Titles by club

See also
 Korean National League
 Korean Semi-professional Football Championship

References

External links

redpajama_set_name: RedPajamaWikipedia


text:
Costa Mediterranea accidents and incidents
Length (LOA)
292 m / 958 ft
Tracker Ship Wiki
CruiseMapper's Costa Mediterranea cruise ship accidents, incidents and law news reports relate to a 2680-passenger vessel owned by Adora Cruises Carnival China. Our Costa Mediterranea accidents page contains reports made by using official data from renown online news media sources, US Coast Guard and Wikipedia.
Here are also reported latest updates on cruise law news related to ashore and shipboard crimes still investigated by the police. Among those could be arrests, filed lawsuits against the shipowner / cruise line company, charges and fines, grievances, settled / withdrawn legal actions, lost cases, virus outbreaks, etc.
tender boat malfunction - 2015
deaths - overboard (2008)
structural - lifeboat malfunction
boat rescue in Grand Cayman - 2006 (saved 54 pax, 3 crew)
2018 - first Costa ship with company's new livery
10 April 2020 Other Incidents
(crew repatriation) On April 10, 2020, Costa Cruises announced a plan to use Costa Mediterranea to repatriate some of the fleet's Filipino and Indonesian crew. The 30-day voyage (La Spezia Itlay to Shanghai China) included debarkation in La Spezia of the Mediterranea's European crew and embarkation of all Indonesian-Filipino crew from the fleetmate Costa Pacifica. In Brindisi Italy (April 16-18), to Mediterranea were tendered Filipino-Indonesian crew from Costa Fortuna.
None of these Costa ships had Coronavirus- (COVID-19)-positive cases - neither among their former passengers or among the staff-crew.
All the Mediterranea's non-Filipino-Indonesian crew (221) via tender boats were transferred to Pacifica, then flown via charter flights to their home countries. On the same day (April 12) Pacifica's Filipino-Indonesian crew (408) were tendered to Mediterranea. On April 13, Mediterranea departed La Spezia en-route to Brindisi (arrived on April 16) to pick up Fortuna's Filipino-Indonesian crew.
Mediterranea's arrival in Manila (Philippines) and Jakarta (Java Indonesia) was initially planned for mid-May. However, after changing the ship's Master (Captain), the Asian crew repatriation plan was postponed by 14 days - needed for the mandatory self-isolation of the new Captain. The ship departed for Asia on May 15 (out of Brindisi). The voyage (through Suez Canal) had planned arrivals in Muscat (Oman) on May 27 (technical stop for bunkering), in Jakarta on June 15-16 (overnight) and in Manila on June 22 (debarkation process lasted through July 2). After completing the crew debarkation, on July 3 the liner (carrying only 120 skeleton crew) left Manila to Singapore.
01 June 2019 Structural and Technical Issues
On June 1, 2019, while berthed in call port Stavanger Norway, the liner reported a technical issue during the planned lifeboat exercise. The vessel was unable to hoist back 2 of its lifeboats back to their davits. The port authority deployed a floating crane to put back and secure the boats. Ship's departure (scheduled for 7 pm) was delayed until late evening. No injuries or damages were reported.
The incident occurred at the end of 9-day Northern Europe / Norwegian Fjords cruise (itinerary May 26 - June 4) roundtrip from homeport Amsterdam Holland to Norway (Haugesund, Geiranger, Hellesylt, Andalsnes, Flam, Stavanger) and Germany (Bremerhaven).
24 August 2015 Structural and Technical Issues
On August 24, 2015, the vessel was anchored in call port Kotor Montenegro and began offloading passengers via tender boats when it experienced a technical issue with one of the boats. Upon lowering, one of the tenders (on Teseo Deck 4 portside) broke its stern cable. The tender remained hanging on its fore wire rope. Fortunately, the boat was empty and no injuries were reported.
08 March 2008 Crew / Passenger Deaths
(overboard) On March 8, 2008, a 39-year-old female passenger jumped overboard after a quarrel with her boyfriend. The incident occurred at around midnight when the ship was approx 20 ml / 30 km southeast of Key Largo (Florida Keys archipelago). The ship turned around and conducted a search and rescue operation, later joined by USCG vessels. The woman's body was never found. The ship was on a 7-day Western Caribbean cruise from homeport Port Everglades (Fort Lauderdale) Florida, Due to the incident, the itinerary's first call port Key West FL was dropped.
07 April 2006 Boat Rescue
On April 7, 2006, in call port George Town (Grand Cayman), the cruise ship rescued a total of 54 passengers and 3 crew from the tourist boat Sun Runner. The boat first capsized on a sandbar, then began taking water and tilted starboard. When all passengers on board moved to the opposite side, the boat fell portside, plunging all of them into the water. No injuries were reported.
You can add more details on reported here accident or submit new / your own Costa Mediterranea ship incident ("Cruise Minus" report) via CruiseMapper's contact form.
Other Adora Cruises Carnival China accidents

redpajama_set_name: RedPajamaCommonCrawl


Book Your Experience Today or call 0421 648 229 for more info!
From an early age, I've always had an interest in photography. My father, a keen photographer himself, ignited my love for photos and educated me on the importance of capturing special moments today for enjoying tomorrow.
As a parent myself now, my own understanding of the value of creating memories is even greater. Like so many mothers, we know the moments our baby's are small for such a short amount of time and that is why these moments must be recorded.
As a photographer, I endeavour to capture real emotion. My goal is to get the very best out of my clients during a photoshoot, each and every session to ensure your best reflects in the photos.
Sydney Maternity, Newborn & Family Photographer with a love for creating experiences and capturing precious moments that last a lifetime. Based in South Penrith, NSW.


text:
PRESS RELEASE: Providing essential support for people with autism
The Electrical Industries Charity has joined forces with the National Autistic Society (NAS) to provide essential support for individuals and their families who are dealing with autism.
Autism is a lifelong, developmental disability that affects how a person communicates with and relates to other people, and how they experience the world around them. Autistic people see, hear and feel the world differently to others and although all autistic people share certain difficulties, being autistic will affect them in different ways.
The Electrical Industries Charity has therefore launched the Employee and Family Support Programme and partnered with the NAS to assist employees and their families who are affected by autism, offering services which include telephone advice, a parent to parent emotional support network and financial assistance.
Recently the Charity has helped an electrician, John, who approached the Charity for help after seeing the Charity's information on the NAS website.
One of John's children has already been diagnosed with autism, but due to severe behavioural problems, he needs to be managed by both of his parents when visiting doctors. Their other three children are being carefully looked at as they could also be on the autism spectrum.
The company who John worked for had not been very supportive, and therefore he lost his job. He managed to find another one very quickly but due to a lack of steady income, he fell behind in paying for their family car and it was repossessed. The large people carrier was essential for him and his family to take his children to a hospital appointment.
The Charity has assisted the family by providing them with a family car. The Electrical Industries Charity has also referred John to the NAS who are supporting the family through the ongoing diagnosis process, providing information and support as well as putting the family in touch with others in a similar situation.
Through its support services the Charity ensures that those who are dealing with autism are not alone and that they all get the support they need to help them through difficult situations in their lives.
For further information, please contact Vicky Gray: vicky.gray@electricalcharity.org
EFS&P and Autism PR FINAL
(EFSP-and-Autism-PR-FINAL.docx)


text:
Xi Jinping, China's president, waves towards children waving flags in 2019, in China. (Photographer: Justin Chin/Bloomberg)
China Just Showed How Much the World Needs It
BloombergOpinion
Daniel Moss
Dec 15 2020, 10:36 AM Dec 16 2020, 10:34 AM December 15 2020, 10:36 AM December 16 2020, 10:34 AM
(Bloomberg Opinion) -- The world needs China more than ever. Thank goodness it's showing up: Economic data released Tuesday all looked strong and in line with forecasts. The upbeat projections for a strong global rebound in 2021 depend on Beijing maintaining this momentum. Most of the traffic from other consequential economies is going the wrong way, owing to restrictions aimed at suppressing the current wave of Covid-19 infections. ...
(Bloomberg Opinion) -- The world needs China more than ever. Thank goodness it's showing up: Economic data released Tuesday all looked strong and in line with forecasts. The upbeat projections for a strong global rebound in 2021 depend on Beijing maintaining this momentum.
Most of the traffic from other consequential economies is going the wrong way, owing to restrictions aimed at suppressing the current wave of Covid-19 infections. There's a prospect of double-dip recessions in Germany and Japan, and the U.S. rebound has been losing steam. With big question marks over three of the four biggest commercial powers, China is the indispensable player.
China may be the only major economy to notch any growth at all this year. The new data showed industrial output climbed 7% in November from the previous year, and retail sales advanced. Fixed-asset investment increased 2.6% in the first 11 months of 2020, compared with the same period in 2019. These numbers all matched economists' forecasts; that does nothing to detract from their importance. The solid 5% rise in retail sales from a year ago is particularly encouraging, given consumers came late to the recovery that began in the second quarter.
In reviewing the global scene, the world's second-biggest economy stands out all the more. Contrast it with German Chancellor Angela Merkel's decision, with state leaders, to impose a hard lockdown that will shut down most retailers from Wednesday. That's an especially heavy blow, considering the comeback from the first one hadn't taken firm hold. Schools have been encouraged to take long holiday breaks. A fourth-quarter contraction is in the cards after declines in gross domestic product during the first half of 2020.
Things are looking grim in Japan, too, where new daily infections topped 3,000 for the first time on Saturday. Prime Minister Yoshihide Suga has been forced to suspend his signature economic initiative, a subsidized domestic travel program called, "Go To." Few people are heading anywhere. Tokyo asked restaurants and bars to continue with shortened hours until Jan. 11. The blow to the economy, which never really recovered from a consumption-tax hike in 2019, will be significant. It bodes equally poorly for Suga, who has struggled to reverse a slide in the government's standing since taking over from Shinzo Abe a few months ago.
In the U.S., improvements in the labor market look to be stalled. Figures last week showed applications for jobless benefits surged, topping estimates with the highest level since September. If Congress can't agree on an additional federal relief package by the end of the December, millions of Americans could start the new year with lapsed unemployment benefits. As if President-elect Joe Biden won't have enough to contend with.
Critics contend that President Xi Jinping was able to shut down China and reopen at a whim earlier in the year because of the authoritarian political system; there's some truth to that. Or that its statistics are fiction, though few economists quibble with the overall direction of numbers published these days. What matters most is that the economy is at the very least hanging in there, and likely doing much better than that.
This column does not necessarily reflect the opinion of the editorial board or Bloomberg LP and its owners.
Daniel Moss is a Bloomberg Opinion columnist covering Asian economies. Previously he was executive editor of Bloomberg News for global economics, and has led teams in Asia, Europe and North America.
Follow The Latest News On The Global Economy On BloombergQuint


Located opposite Robertson Park, the property has stunning bay views and is surrounded by Sydney's most famous beaches. The position provides a significant tourist destination for visitors from both interstate and overseas as well as catering to the loyal local community.
– Currently seating 70 including outdoor area. Max of 90.


LIMITED TO 250 COPIES. 3 track live EP recorded in 1967 at the height of there career. EP is housed in amazing picture sleeve. Tracks: 01 I Love Her Still, I Always Will 02 Set Me Free 03 Won't You Listen Pseudonym Records is the leading high quality re-issue label for the Benelux market, covering all genres of popular music since the 1950s – rock, folk, singer-songwriter, punk, beat, psychedelica, indie, blues, progressive, symphonic… Each release is carefully compiled (with bonus tracks) and re-mastered (to ensure the highest possible sound quality) with deluxe packaging consisting of colour booklets, with rare photos and memorabilia, and extensive liner notes by leading music writers as standard.


Bury St Edmunds travelled to Mildenhall for the first EAPL game in a few years, the home side batted first and in the 3rd over Mark Nunn trapped Kyle Morrison lbw, Jo Reed played a typical robust innings but was caught by wicket keeper James Sturgeon off Nunn for 28 with the score on 51. Matt Allen battled hard scoring 24 off 70 balls before being 3rd out on 106. Ben Shepperson came in to push the score on making 28 at a run a ball, Peter Worthington had held the innings together before being out for 65 off 130 deliveries when he was well caught by Tom Robotham off Sean Park. After this wickets fell at regular intervals Nunn taking ex Surrey player Murtaz Hussein, Robotham had bowled well without reward his 10 overs for 26 but it was Nunn with figures of 4 for 37 and Park 3 for 31 who had taken the wickets in a total of 186/9 off the 50 overs.
The Bury reply was soon in trouble against the pace of Tino Best and Morrison; Ben Curran and Luke DePloy were both out to Morrison cheaply before in the cold wet conditions the teams came off in the 9th over.
Bury's 2nd team played co-leaders Long Melford at the Victory Ground the visitors scored 178/8 but rain probably saved Bury when they were well below the target as the match was abandoned.
Bury's 3rd team travelled to Easton to play the home side 2nd team. Bury batted first and scored 142 Tony Riddick scored 42 and Simon Aldous 41 it was a competitive match but the score proved too little as the home side reached the target with 5 wickets down.
On Sunday the 1st team were at home to Stowupland batted first and scored 224/3 with 88 from Hugh Stanton and 96 from Phil Godden in reply Stowupland were all out of 124 with the fast improving Ollie Riddick taking 5 for 37.
Greene King players of the week Mark Nunn, SeanPark, SeanCooper, HughStanton, PhilGodden and OllieRiddick.
Next week we are at home to Sudbury in a 120 over EAPL game, the 2nd team travel to Tuddenham, 3rds are away to Worlington 2nds, 4th team at home to Bardwell.
On Sunday the 1st team are away to Battisford.


text:
Home » Don't expand the CPTPP - AFTINET Submission
Don't expand the CPTPP - AFTINET Submission
May 10, 2021 ; The Comprehensive and Progressive Agreement for Trans-Pacific Partnership (CPTPP) was signed in 2018 by 11 countries: Australia, New Zealand, Japan, Chile, Peru, Mexico, Canada, Malaysia, Singapore, Brunei and Vietnam, after the US withdrew in 2017. The remaining 11 re-badged the agreement as the CPTPP and suspended some of its most controversial clauses. But these concerns have also influenced four of the 11 signatories to still not ratify the agreement. In this context, expansion of the agreement seems premature.
Twenty-two of the original TPP-12 provisions were suspended, but not removed, in the CPTPP, in case the USA wanted to rejoin. Many of these provisions are intellectual property provisions that increase monopolies on the most expensive biologic medicines, which would delay the availability of cheaper forms of these medicines for an additional three years.
See the AFTINET Bulletin April 2021 for more detail.
AFTINET's submission to the Joint Standing Committee on Foreign Affairs, Defence and Trade is here.


text:
From near death to the life of the party
"I'm just beyond grateful and feel very blessed that she had such good people around her," the mom of a 5-year-old said after her daughter suffered extensive injuries in an accident.
Madalynn Hoffman Grzelak is a walking miracle.
The 5-year-old, injured in a horrific lawnmower accident last July, wasn't expected to live, much less run and play like other kids her age.
But that's exactly what the spirited little girl is doing today, thanks to the collaboration of a team of physicians and clinicians in multiple specialties at Riley Hospital for Children at IU Health.
"This was a devastating injury she had, and now you would never know," said Dr. Joshua Adkinson, a pediatric plastic surgeon at Riley. "She lost a tremendous amount of soft tissue in the flank and upper bowel area, entering the abdominal cavity."
Dr. Adkinson was seeing a completely different Madalynn than the fragile girl he first treated at Riley last summer. Madalynn and her mom, Cassondra Grzelak, were back at Riley for a follow-up visit with Dr. Adkinson last month.
The kindergartner was twirling around in the small exam room, jumping up and down off her mom's lap and literally bouncing off the walls as she pretended to be a zombie.
"It's fun for me to see her like this, given how bad things were," Dr. Adkinson said with good humor.
DARK DAYS IN ICU
Those were some dark days, he and Grzelak agreed. Madalynn was in the intensive care unit for several weeks. In all, she was hospitalized for about six weeks, but it felt more like a year, Grzelak said, wondering then if discharge day would ever come.
When Madalynn left Riley, she was in a wheelchair, but today she requires no assistive devices to walk, thanks to excellent care, regular therapy and perhaps a dose of divine intervention, her mom said.
"If I never believed in a God or anything before, I definitely know now that there is because there is no way she would be here if not."
Grzelak doesn't like to talk about the accident, but she remembers the panic she felt as she tried to get help for her daughter.
She lives with her two girls (Madalynn has a 9-year-old sister) and her mom on a large piece of land in Freedom, Indiana, an unincorporated community west of Bloomington.
"We had no cell service at our house," she said. "When it happened, I was freaking out because I didn't know where to take her. Everywhere is so far."
Grzelak drove her daughter to her neighbor's house and had them call for an ambulance. The injured girl, who was rapidly losing blood, was taken to Terre Haute Regional Hospital, then immediately transferred to Riley.
"They told me she likely wouldn't make it on the ride there," Grzelak recalled.
"HORRIFIC INJURIES"
But Maddie had other ideas, proving once again that children are often more resilient than adults, Dr. Adkinson said.
"Their reserves are greater than ours."
Still, he admitted, it is hard to see a child injured so severely.
Dr. Christine Caltoum, division chief for pediatric orthopedic surgery, agrees, describing it as "one of the most horrific lawnmower injuries that we have seen."
"She had an extensive right flank and buttock wound with gross contamination, exposed bone and bowel loops in the wound."
When she first arrived at Riley on July 15, Maddie was in extremely critical condition. Even if she survived, Dr. Caltoum said, it was unclear what her level of function would be. Her sciatic nerve was exposed in the wound. The sciatic nerve is the largest nerve in the body and is formed by the union of five nerve roots from the lower spine.
The little girl underwent many surgeries, with extensive reconstruction by orthopedics, plastics and general surgery, the latter with Dr. Deborah Billmire.
Dr. Caltoum said Madalynn's case is a powerful example of the teamwork at Riley.
"Not only did she have multiple surgical services involved in her care, other services such as infectious diseases, ICU, psychiatry, social work, child life and others were also involved," she said.
The result is an active, healthy girl who keeps her mom and grandma on their toes. The only evidence of her accident is a slight limp that should resolve itself in time once she gains the confidence to put more weight on her right leg.
And there are the scars she carries on her tiny body.
GIGGLING AND WIGGLING
Dr. Adkinson talked to Madalynn's mom about those scars during their recent appointment at the Riley Outpatient Center. When he asked Madalynn if he could take a look at how the wounds on her torso and leg were healing, she said, "Nope, nope, nope" and folded herself into her mom's lap.
After some coaxing by mom, Madalynn let down her guard, but she ended up giggling and wiggling as Dr. Adkinson examined her scar tissue.
"She looks great," he said, noting how far she has come.
"She was a rock star in a very difficult situation," he said of those days in the hospital. "We were doing daily wound checks and turning her. I don't remember her being difficult at all."
She is a lot more squirrely now, so much so that the exam room can barely contain her. But it's an amazing thing to see, he said.
Her recovery "is as close to a miracle as we see in what we do," the plastic surgeon said. And her active play is a good thing – it helps with joint tightness, he added.
Reviewing Madalynn's surgical procedures, Dr. Adkinson said general surgeons had to close the abdominal wall to keep the bowel contents contained. After they did their part, orthopedics cleaned up the wound and Dr. Caltoum reconstructed the child's pelvis to stabilize her hip and allow her to walk. The accident had shaved off part of her hip bone.
Then it was plastic's job to reconstruct the injury site, to fill the "giant hole" left in the flank and upper buttock area.
In the end, surgeons rotated an area of skin from her abdominal wall to fill the hole in her flank.
"That left a donor site where we stole the flap from," he explained. "We robbed Peter to pay Paul, so we had to pay Peter back. We had to skin graft that area."
As she grows, her scars will grow with her, Dr. Adkinson said, though they might fade in time. There are cosmetic procedures that can be done later in life if desired, but for now, the little girl with the big personality is a walking success story. She has full function of her body.
Grzelak hopes that maybe next summer, her daughter can go back to gymnastics camp, something she loved before the accident. Her other passions include Barbie dolls, Slime, playing with her big sister and watching videos on YouTube.
As she tries to put the accident in the rearview mirror, Grzelak is thrilled with how well her daughter is doing today.
"I'm just beyond grateful and feel very blessed that she had such good people around her," she said. "They were really kind to her and to our family. They took such good care of Maddie. I don't even have the words to express it."
Photos by Mike Dickbernd, IU Health visual journalist, mdickbernd@iuhealth.org
Deborah F. Billmire, MD
Christine B. Caltoum, MD
Pediatric Orthopedic Surgery
Joshua M. Adkinson, MD
Pediatric orthopedic experts at Riley Children's Health provide premier care for children with injuries, skeletal or neuromuscular diseases and other orthopedic conditions.
Pediatric plastic and reconstructive surgeons at Riley at IU Health treat children of all ages with facial, hand, skin and body conditions.
Our pediatric general surgeons provide specialty care from simple to complicated conditions that need surgical treatment.


text:
-- @product_version gpdb: [4.3.2-4.3.98]
--
-- STRINGS
-- Test various data entry syntaxes.
--

-- create required tables
CREATE TABLE CHAR_STRINGS_TBL(f1 char(4));
INSERT INTO CHAR_STRINGS_TBL (f1) VALUES ('a'),
('ab'),
('abcd'),
('abcd    ');

CREATE TABLE VARCHAR_STRINGS_TBL(f1 varchar(4));
INSERT INTO VARCHAR_STRINGS_TBL (f1) VALUES ('a'),
('ab'),
('abcd'),
('abcd    ');

CREATE TABLE TEXT_STRINGS_TBL (f1 text);
INSERT INTO TEXT_STRINGS_TBL VALUES ('doh!'),
('hi de ho neighbor');

-- SQL92 string continuation syntax
-- E021-03 character string literals
SELECT 'first line'
' - next line'
	' - third line'
	AS "Three lines to one";

-- illegal string continuation syntax
SELECT 'first line'
' - next line' /* this comment is not allowed here */
' - third line'
	AS "Illegal comment within continuation";

--
-- test conversions between various string types
-- E021-10 implicit casting among the character data types
--

SELECT CAST(f1 AS text) AS "text(char)" FROM CHAR_STRINGS_TBL ORDER BY 1;

SELECT CAST(f1 AS text) AS "text(varchar)" FROM VARCHAR_STRINGS_TBL ORDER BY 1;

SELECT CAST(name 'namefield' AS text) AS "text(name)";

-- since this is an explicit cast, it should truncate w/o error:
SELECT CAST(f1 AS char(10)) AS "char(text)" FROM TEXT_STRINGS_TBL ORDER BY 1;
-- note: implicit-cast case is tested in char.sql

SELECT CAST(f1 AS char(20)) AS "char(text)" FROM TEXT_STRINGS_TBL ORDER BY 1;

SELECT CAST(f1 AS char(10)) AS "char(varchar)" FROM VARCHAR_STRINGS_TBL ORDER BY 1;

SELECT CAST(name 'namefield' AS char(10)) AS "char(name)";

SELECT CAST(f1 AS varchar) AS "varchar(text)" FROM TEXT_STRINGS_TBL ORDER BY 1;

SELECT CAST(f1 AS varchar) AS "varchar(char)" FROM CHAR_STRINGS_TBL ORDER BY 1;

SELECT CAST(name 'namefield' AS varchar) AS "varchar(name)";

--
-- test SQL92 string functions
-- E### and T### are feature reference numbers from SQL99
--

-- E021-09 trim function
SELECT TRIM(BOTH FROM '  bunch o blanks  ') = 'bunch o blanks' AS "bunch o blanks";

SELECT TRIM(LEADING FROM '  bunch o blanks  ') = 'bunch o blanks  ' AS "bunch o blanks  ";

SELECT TRIM(TRAILING FROM '  bunch o blanks  ') = '  bunch o blanks' AS "  bunch o blanks";

SELECT TRIM(BOTH 'x' FROM 'xxxxxsome Xsxxxxx') = 'some Xs' AS "some Xs";

-- E021-06 substring expression
SELECT SUBSTRING('1234567890' FROM 3) = '34567890' AS "34567890";

SELECT SUBSTRING('1234567890' FROM 4 FOR 3) = '456' AS "456";

-- T581 regular expression substring (with SQL99's bizarre regexp syntax)
SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d)#"%' FOR '#') AS "bcd";

-- No match should return NULL
SELECT SUBSTRING('abcdefg' FROM '#"(b_d)#"%' FOR '#') IS NULL AS "True";

-- Null inputs should return NULL
SELECT SUBSTRING('abcdefg' FROM '(b|c)' FOR NULL) IS NULL AS "True";
SELECT SUBSTRING(NULL FROM '(b|c)' FOR '#') IS NULL AS "True";
SELECT SUBSTRING('abcdefg' FROM NULL FOR '#') IS NULL AS "True";

-- PostgreSQL extension to allow omitting the escape character;
-- here the regexp is taken as Posix syntax
SELECT SUBSTRING('abcdefg' FROM 'c.e') AS "cde";

-- With a parenthesized subexpression, return only what matches the subexpr
SELECT SUBSTRING('abcdefg' FROM 'b(.*)f') AS "cde";

-- PostgreSQL extension to allow using back reference in replace string;
SELECT regexp_replace('1112223333', E'(\\d{3})(\\d{3})(\\d{4})', E'(\\1) \\2-\\3');
SELECT regexp_replace('AAA   BBB   CCC   ', E'\\s+', ' ', 'g');
SELECT regexp_replace('AAA', '^|$', 'Z', 'g');
SELECT regexp_replace('AAA aaa', 'A+', 'Z', 'gi');
-- invalid regexp option
SELECT regexp_replace('AAA aaa', 'A+', 'Z', 'z');

-- set so we can tell NULL from empty string
\pset null '\\N'

-- return all matches from regexp
SELECT regexp_matches('foobarbequebaz', $re$(bar)(beque)$re$);

-- test case insensitive
SELECT regexp_matches('foObARbEqUEbAz', $re$(bar)(beque)$re$, 'i');

-- global option - more than one match
SELECT regexp_matches('foobarbequebazilbarfbonk', $re$(b[^b]+)(b[^b]+)$re$, 'g');

-- empty capture group (matched empty string)
SELECT regexp_matches('foobarbequebaz', $re$(bar)(.*)(beque)$re$);
-- no match
SELECT regexp_matches('foobarbequebaz', $re$(bar)(.+)(beque)$re$);
-- optional capture group did not match, null entry in array
SELECT regexp_matches('foobarbequebaz', $re$(bar)(.+)?(beque)$re$);

-- no capture groups
SELECT regexp_matches('foobarbequebaz', $re$barbeque$re$);

-- give me errors
SELECT regexp_matches('foobarbequebaz', $re$(bar)(beque)$re$, 'zipper');
SELECT regexp_matches('foobarbequebaz', $re$(barbeque$re$);
SELECT regexp_matches('foobarbequebaz', $re$(bar)(beque){2,1}$re$);

-- split string on regexp
SELECT foo, length(foo) FROM regexp_split_to_table('the quick brown fox jumped over the lazy dog', $re$\s+$re$) AS foo;
SELECT regexp_split_to_array('the quick brown fox jumped over the lazy dog', $re$\s+$re$);

SELECT foo, length(foo) FROM regexp_split_to_table('the quick brown fox jumped over the lazy dog', $re$\s*$re$) AS foo;
SELECT regexp_split_to_array('the quick brown fox jumped over the lazy dog', $re$\s*$re$);
SELECT foo, length(foo) FROM regexp_split_to_table('the quick brown fox jumped over the lazy dog', '') AS foo;
SELECT regexp_split_to_array('the quick brown fox jumped over the lazy dog', '');
-- case insensitive
SELECT foo, length(foo) FROM regexp_split_to_table('thE QUick bROWn FOx jUMPed ovEr THE lazy dOG', 'e', 'i') AS foo;
SELECT regexp_split_to_array('thE QUick bROWn FOx jUMPed ovEr THE lazy dOG', 'e', 'i');
-- no match of pattern
SELECT foo, length(foo) FROM regexp_split_to_table('the quick brown fox jumped over the lazy dog', 'nomatch') AS foo;
SELECT regexp_split_to_array('the quick brown fox jumped over the lazy dog', 'nomatch');
-- errors
SELECT foo, length(foo) FROM regexp_split_to_table('thE QUick bROWn FOx jUMPed ovEr THE lazy dOG', 'e', 'zippy') AS foo;
SELECT regexp_split_to_array('thE QUick bROWn FOx jUMPed ovEr THE lazy dOG', 'e', 'zippy');
-- global option meaningless for regexp_split
SELECT foo, length(foo) FROM regexp_split_to_table('thE QUick bROWn FOx jUMPed ovEr THE lazy dOG', 'e', 'g') AS foo;
SELECT regexp_split_to_array('thE QUick bROWn FOx jUMPed ovEr THE lazy dOG', 'e', 'g');

-- change NULL-display back
\pset null ''

-- E021-11 position expression
SELECT POSITION('4' IN '1234567890') = '4' AS "4";

SELECT POSITION(5 IN '1234567890') = '5' AS "5";

-- T312 character overlay function
SELECT OVERLAY('abcdef' PLACING '45' FROM 4) AS "abc45f";

SELECT OVERLAY('yabadoo' PLACING 'daba' FROM 5) AS "yabadaba";

SELECT OVERLAY('yabadoo' PLACING 'daba' FROM 5 FOR 0) AS "yabadabadoo";

SELECT OVERLAY('babosa' PLACING 'ubb' FROM 2 FOR 4) AS "bubba";

--
-- test LIKE
-- Be sure to form every test as a LIKE/NOT LIKE pair.
--

-- simplest examples
-- E061-04 like predicate
SELECT 'hawkeye' LIKE 'h%' AS "true";
SELECT 'hawkeye' NOT LIKE 'h%' AS "false";

SELECT 'hawkeye' LIKE 'H%' AS "false";
SELECT 'hawkeye' NOT LIKE 'H%' AS "true";

SELECT 'hawkeye' LIKE 'indio%' AS "false";
SELECT 'hawkeye' NOT LIKE 'indio%' AS "true";

SELECT 'hawkeye' LIKE 'h%eye' AS "true";
SELECT 'hawkeye' NOT LIKE 'h%eye' AS "false";

SELECT 'indio' LIKE '_ndio' AS "true";
SELECT 'indio' NOT LIKE '_ndio' AS "false";

SELECT 'indio' LIKE 'in__o' AS "true";
SELECT 'indio' NOT LIKE 'in__o' AS "false";

SELECT 'indio' LIKE 'in_o' AS "false";
SELECT 'indio' NOT LIKE 'in_o' AS "true";

-- unused escape character
SELECT 'hawkeye' LIKE 'h%' ESCAPE '#' AS "true";
SELECT 'hawkeye' NOT LIKE 'h%' ESCAPE '#' AS "false";

SELECT 'indio' LIKE 'ind_o' ESCAPE '$' AS "true";
SELECT 'indio' NOT LIKE 'ind_o' ESCAPE '$' AS "false";

-- escape character
-- E061-05 like predicate with escape clause
SELECT 'h%' LIKE 'h#%' ESCAPE '#' AS "true";
SELECT 'h%' NOT LIKE 'h#%' ESCAPE '#' AS "false";

SELECT 'h%wkeye' LIKE 'h#%' ESCAPE '#' AS "false";
SELECT 'h%wkeye' NOT LIKE 'h#%' ESCAPE '#' AS "true";

SELECT 'h%wkeye' LIKE 'h#%%' ESCAPE '#' AS "true";
SELECT 'h%wkeye' NOT LIKE 'h#%%' ESCAPE '#' AS "false";

SELECT 'h%awkeye' LIKE 'h#%a%k%e' ESCAPE '#' AS "true";
SELECT 'h%awkeye' NOT LIKE 'h#%a%k%e' ESCAPE '#' AS "false";

SELECT 'indio' LIKE '_ndio' ESCAPE '$' AS "true";
SELECT 'indio' NOT LIKE '_ndio' ESCAPE '$' AS "false";

SELECT 'i_dio' LIKE 'i$_d_o' ESCAPE '$' AS "true";
SELECT 'i_dio' NOT LIKE 'i$_d_o' ESCAPE '$' AS "false";

SELECT 'i_dio' LIKE 'i$_nd_o' ESCAPE '$' AS "false";
SELECT 'i_dio' NOT LIKE 'i$_nd_o' ESCAPE '$' AS "true";

SELECT 'i_dio' LIKE 'i$_d%o' ESCAPE '$' AS "true";
SELECT 'i_dio' NOT LIKE 'i$_d%o' ESCAPE '$' AS "false";

-- escape character same as pattern character
SELECT 'maca' LIKE 'm%aca' ESCAPE '%' AS "true";
SELECT 'maca' NOT LIKE 'm%aca' ESCAPE '%' AS "false";

SELECT 'ma%a' LIKE 'm%a%%a' ESCAPE '%' AS "true";
SELECT 'ma%a' NOT LIKE 'm%a%%a' ESCAPE '%' AS "false";

SELECT 'bear' LIKE 'b_ear' ESCAPE '_' AS "true";
SELECT 'bear' NOT LIKE 'b_ear' ESCAPE '_' AS "false";

SELECT 'be_r' LIKE 'b_e__r' ESCAPE '_' AS "true";
SELECT 'be_r' NOT LIKE 'b_e__r' ESCAPE '_' AS "false";

SELECT 'be_r' LIKE '__e__r' ESCAPE '_' AS "false";
SELECT 'be_r' NOT LIKE '__e__r' ESCAPE '_' AS "true";

--
-- test ILIKE (case-insensitive LIKE)
-- Be sure to form every test as an ILIKE/NOT ILIKE pair.
--

SELECT 'hawkeye' ILIKE 'h%' AS "true";
SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";

SELECT 'hawkeye' ILIKE 'H%' AS "true";
SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";

SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";

SELECT 'Hawkeye' ILIKE 'h%' AS "true";
SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";

--
-- test implicit type conversion
--

-- E021-07 character concatenation
SELECT 'unknown' || ' and unknown' AS "Concat unknown types";

SELECT text 'text' || ' and unknown' AS "Concat text to unknown type";

SELECT char(20) 'characters' || ' and text' AS "Concat char to unknown type";

SELECT text 'text' || char(20) ' and characters' AS "Concat text to char";

SELECT text 'text' || varchar ' and varchar' AS "Concat text to varchar";

-- Test "unknown" from sub queries - MPP-2510
select foo || 'bar'::text from (select 'bar' as foo) a;
select foo || 'bar'::text from (select 'bar'::text as foo) a;
select * from ( select 'a' as a) x join (select 'b' as b) y on a=b;

-- Test "unknown" with typmod MPP-2658
create table unknown_test (v varchar(20), n numeric(20, 2), t timestamp(2));
insert into unknown_test select '100', '123.23', '2008-01-01 11:11:11';
select 'foo'::varchar(10) || bar from (select 'bar' as bar) moo;
select '123'::numeric(4,1) + bar from (select '123' as bar) baz;
drop table unknown_test;

-- Test nested "unknown"s from MPP-2689
select 'foo'::text || foo from ( select foo from (select 4.5, foo from ( select
1, 'foo' as foo) a ) b ) c;
select 'foo'::text || foo from ( select foo from
 (select foo || bar as foo from ( select 'bar' as bar, 'foo' as foo) a ) b ) c;
create domain u_d as text;
prepare p1 as select $1::u_d || foo from (select 'foo' as foo) a;
prepare p2 as select 'foo' || foo
from (select $1::u_d || bar as foo from (select 'bar' as bar) a ) b;

select 'a' as a, 'b' as b, 'c' as c, 1 as d union select * from (select 'a' as a, 'b' as b, 'c' as c, 1 as d)d;
select * from (select 'a' as a, 'b' as b, 'c' as c, 1 as d)d union select 'a' as a, 'b' as b, 'c' as c, 1 as d;

-- Make sure we can convert unknown to other useful types (MPP-4298)
create table t as select j as a, 'abc' as i from
generate_series(1, 10) j;
select * from t order by a;
alter table t alter i type int; -- should fail
alter table t alter i type text; -- should work
select * from t order by a;
drop table t;

--
-- test substr with toasted text values
--
CREATE TABLE toasttest(f1 text);

insert into toasttest values(repeat('1234567890',10000));
insert into toasttest values(repeat('1234567890',10000));

--
-- Ensure that some values are uncompressed, to test the faster substring
-- operation used in that case
--
alter table toasttest alter column f1 set storage external;
insert into toasttest values(repeat('1234567890',10000));
insert into toasttest values(repeat('1234567890',10000));

-- If the starting position is zero or less, then return from the start of the string
-- adjusting the length to be consistent with the "negative start" per SQL92.
SELECT substr(f1, -1, 5) from toasttest;

-- If the length is less than zero, an ERROR is thrown.
SELECT substr(f1, 5, -1) from toasttest;

-- If no third argument (length) is provided, the length to the end of the
-- string is assumed.
SELECT substr(f1, 99995) from toasttest;

-- If start plus length is > string length, the result is truncated to
-- string length
SELECT substr(f1, 99995, 10) from toasttest;

DROP TABLE toasttest;

--
-- test substr with toasted bytea values
--
CREATE TABLE toasttest(f1 bytea);

insert into toasttest values("decode"(repeat('1234567890',10000),'escape'));
insert into toasttest values(pg_catalog.decode(repeat('1234567890',10000),'escape'));

--
-- Ensure that some values are uncompressed, to test the faster substring
-- operation used in that case
--
alter table toasttest alter column f1 set storage external;
insert into toasttest values("decode"(repeat('1234567890',10000),'escape'));
insert into toasttest values(pg_catalog.decode(repeat('1234567890',10000),'escape'));

-- If the starting position is zero or less, then return from the start of the string
-- adjusting the length to be consistent with the "negative start" per SQL92.
SELECT substr(f1, -1, 5) from toasttest;

-- If the length is less than zero, an ERROR is thrown.
SELECT substr(f1, 5, -1) from toasttest;

-- If no third argument (length) is provided, the length to the end of the
-- string is assumed.
SELECT substr(f1, 99995) from toasttest;

-- If start plus length is > string length, the result is truncated to
-- string length
SELECT substr(f1, 99995, 10) from toasttest;

DROP TABLE toasttest;

-- test internally compressing datums

-- note this tests compressing a datum to a very small size which tests a
-- particular case in the packed varlena where very small compressed datums
-- must be given a 4-byte header because there are no bits to indicate
-- compression in a 1-byte header

CREATE TABLE toasttest (c char(2048));
INSERT INTO toasttest VALUES('x');
SELECT length(c), c::text FROM toasttest;
SELECT c FROM toasttest;
DROP TABLE toasttest;

--
-- test length
--

SELECT length('abcdef') AS "length_6";

--
-- test strpos
--

SELECT strpos('abcdef', 'cd') AS "pos_3";

SELECT strpos('abcdef', 'xy') AS "pos_0";

--
-- test replace
--
SELECT replace('abcdef', 'de', '45') AS "abc45f";

SELECT replace('yabadabadoo', 'ba', '123') AS "ya123da123doo";

SELECT replace('yabadoo', 'bad', '') AS "yaoo";

--
-- test split_part
--
select split_part('joeuser@mydatabase','@',0) AS "an error";

select split_part('joeuser@mydatabase','@',1) AS "joeuser";

select split_part('joeuser@mydatabase','@',2) AS "mydatabase";

select split_part('joeuser@mydatabase','@',3) AS "empty string";

select split_part('@joeuser@mydatabase@','@',2) AS "joeuser";

--
-- test to_hex
--
select to_hex(256*256*256 - 1) AS "ffffff";

select to_hex(256::bigint*256::bigint*256::bigint*256::bigint - 1) AS "ffffffff";

--
-- MD5 test suite - from IETF RFC 1321
-- (see: ftp://ftp.rfc-editor.org/in-notes/rfc1321.txt)
--
select md5('') = 'd41d8cd98f00b204e9800998ecf8427e' AS "TRUE";

select md5('a') = '0cc175b9c0f1b6a831c399e269772661' AS "TRUE";

select md5('abc') = '900150983cd24fb0d6963f7d28e17f72' AS "TRUE";

select md5('message digest') = 'f96b697d7cb7938d525a2f31aaf161d0' AS "TRUE";

select md5('abcdefghijklmnopqrstuvwxyz') = 'c3fcd3d76192e4007dfb496cca67e13b' AS "TRUE";

select md5('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789') = 'd174ab98d277d9f5a5611c2c9f419d9f' AS "TRUE";

select md5('12345678901234567890123456789012345678901234567890123456789012345678901234567890') = '57edf4a22be3c955ac49da2e2107b67a' AS "TRUE";

select md5(''::bytea) = 'd41d8cd98f00b204e9800998ecf8427e' AS "TRUE";

select md5('a'::bytea) = '0cc175b9c0f1b6a831c399e269772661' AS "TRUE";

select md5('abc'::bytea) = '900150983cd24fb0d6963f7d28e17f72' AS "TRUE";

select md5('message digest'::bytea) = 'f96b697d7cb7938d525a2f31aaf161d0' AS "TRUE";

select md5('abcdefghijklmnopqrstuvwxyz'::bytea) = 'c3fcd3d76192e4007dfb496cca67e13b' AS "TRUE";

select md5('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'::bytea) = 'd174ab98d277d9f5a5611c2c9f419d9f' AS "TRUE";

select md5('12345678901234567890123456789012345678901234567890123456789012345678901234567890'::bytea) = '57edf4a22be3c955ac49da2e2107b67a' AS "TRUE";

--
-- test behavior of escape_string_warning and standard_conforming_strings options
--
set escape_string_warning = off;
set standard_conforming_strings = off;

show escape_string_warning;
show standard_conforming_strings;

set escape_string_warning = on;
set standard_conforming_strings = on;

show escape_string_warning;
show standard_conforming_strings;

select 'a\bcd' as f1, 'a\b''cd' as f2, 'a\b''''cd' as f3, 'abcd\'   as f4, 'ab\''cd' as f5, '\\' as f6;

set standard_conforming_strings = off;

select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\'   as f4, 'ab\\\'cd' as f5, '\\\\' as f6;

set escape_string_warning = off;
set standard_conforming_strings = on;

select 'a\bcd' as f1, 'a\b''cd' as f2, 'a\b''''cd' as f3, 'abcd\'   as f4, 'ab\''cd' as f5, '\\' as f6;

set standard_conforming_strings = off;

select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\'   as f4, 'ab\\\'cd' as f5, '\\\\' as f6;

--
-- test unicode escape
--
select E'A\u0041' as f1, E'\u0127' as f2;
select E'\u0000';
select E'\udsfs';
select E'\uD843\uE001';
select E'\uDC01';
select E'\uD834';

drop table CHAR_STRINGS_TBL;
drop table VARCHAR_STRINGS_TBL;
drop table TEXT_STRINGS_TBL;
drop domain u_d;


RICHMOND, Va. – NCAA semifinalist and intra-state rival Virginia, as well as Colonial Athletic Association champion Old Dominion highlight the 2011 VCU Field Hockey Schedule, released Thursday.
The Rams, coming off a CAA Tournament Semifinal berth, open their 2011 slate on Saturday, Aug. 20 against Radford at Cary Street Field. The regular season kicks off on Friday, Aug. 26 when VCU meets Virginia in Charlottesville, Va. at 4 p.m. It will be the first meeting between the two schools since 2008.
VCU will open its home schedule on Saturday, Aug. 27 when it hosts Appalachian State on the Cary Street Turf at 2 p.m. The Rams will host cross-town rival Richmond on Sept. 9. VCU's 2-1 overtime victory over the Spiders last season sparked a 13-win campaign.
Non-conference dates with Big Ten stalwarts Northwestern (Sept. 2) and Penn State (Sept. 18), Albany (Sept. 3), Davidson (Sept. 11), Longwood (Sept. 15), Pacific (Oct. 9) and Columbia (Oct. 16) also highlight the schedule.
The Rams open CAA action on Sept. 23 against Towson at Cary Street Field at 7 p.m. Home contests with Drexel (Sept. 25) and Delaware (Oct. 30) are also of note. The Black and Gold will take on defending league champion Old Dominion on Oct. 23 at 1 p.m. in Norfolk, Va.
Led by fifth-year Head Coach Kelly McQuade, the Rams are coming off a 13-7 campaign, the school's best since the 1992 season. The 13 victories represent the second-most in program history. VCU returns All-CAA forward Kelsey Scherrer (Chesapeake, Va.) as well as the bulk of its starting lineup.
Aug. 26: at Virginia, 4 p.m.
Aug. 27: APPALACHIAN STATE, 2 p.m.
Sept. 2: at Northwestern, 2 p.m.
Sept. 3: vs. Albany (at Northwestern), 1 p.m.
Sept. 9: RICHMOND, 5 p.m.
Sept 11: DAVIDSON, 2:30 p.m.
Sept. 15: LONGWOOD, 6 p.m.
Sept. 18: vs. Penn State (at James Madison), 1 p.m.
Sept. 23: *TOWSON, 7 p.m.
Sept 25: *DREXEL, 12 p.m.
Sept 30: at *Hofstra, 3 p.m.
Oct. 2: at *Northeastern, 2 p.m.
Oct. 7: at *James Madison, 7 p.m.
Oct. 9: PACIFIC, 12 p.m.
Oct. 16: at Columbia, 1 p.m.
Oct. 21: at *William & Mary, 7:30 p.m.
Oct. 23: at *Old Dominion, 1 p.m.
Oct. 30: *DELAWARE, 12 p.m.


With its celebrated round bead setting, the Vintage Alhambra collection remains true to the design which launched the iconic motif in the 1960s. The exotic charm of tiger's eye is complemented by the warmth of 18 karat yellow gold in this bracelet.
The bracelet is offered with its original packaging and certificate of authenticity.
ASK A QUESTIONYou can order the Van Cleef & Arpels Vintage Alhambra Bracelet by calling us at 202-363-6305, 10:00am-5:30pm EST, Mon-Sat or by e-mailing sales@pampillonia.com. Returns and exchanges are accepted within 10 days of delivery for a full refund less cost of return shipping for this item. Special orders and alteration are non refundable.


text:
Marino, Mariño or Maryino may refer to:

Places
 Marino, Lazio, a town in the province of Rome, Italy
 Marino, South Australia, a suburb of Adelaide
 Marino Conservation Park
 Marino Rocks Greenway, a cycling route
 Marino Rocks railway station
 Marino, County Down in Northern Ireland
 Marino railway station (Northern Ireland) in County Down, Northern Ireland
 Marino railway station, Adelaide in Adelaide, South Australia
 Marino, Dublin, a suburb of Dublin, Ireland
 Marino, Ilinden, North Macedonia
 Maryino District of Moscow, Russia
 Maryino (Moscow Metro), a station of the Moscow Metro

Name
 Marino (name), including people with the surname and given name
 Marino, a thief in the video game Mega Man X: Command Mission
 Marino (comic book), a comic book hero published by Editions Lug
 Marino, a surname of Saint Marina the Monk

Sports
 A.S.D. Città di Marino Calcio or simply Marino, an Italian association football team
 CD Marino, a football team in the Canary Islands, Spain
 Marino de Luanco, a football team in Asturias, Spain
 Yokohama Marinos, a Japanese football team which merged with the Yokohama Flügels to form the Yokohama F. Marinos

Other uses
 Marino language, a language of Vanuatu also known as Sungwadia
 Marino DOC, an Italian wine
 El Marino, a Chilean newspaper
 Palazzo Marino, a 16th-century palace in Milan, Italy

See also
 Toyota Sprinter Marino, a version of the Toyota Corolla car
San Marino (disambiguation)
Mariño
Marinho
Merino (disambiguation)
Marino railway station (disambiguation)


Bmw 318i Se Service Manual - 3 Series E46 318i (M43TU) SAL > BMW Workshop Manuals > 2 Repair Instructions > 11 Engine (M43TU) > 21 Crankshaft With Bearing > 1 RA Replacing Crankshaft (M43 _ M43TU). BMW 3 Series (E36) Service Manual (1992-1998): M3, 318i, 323i, 325i, 328i. The Motor Bookstore is always on the lookout for books like BMW 3 Series (E36) Service Manual (1992-1998): M3, 318i, 323i, 325i, 328i.A resource like this 1992-1998 BMW E36 service manual will be a time and cost saver for every owner of these luxury models.. A penny saved is a penny earned, especially when it comes to BMW 318I Repair Manual parts. You cannot go wrong when you purchase BMW 318I Repair Manual parts from our online web store. Our BMW 318I Repair Manual parts customer service personnel are all located within the US..
Auto Facts has the best selection of service repair manuals for your 1998 BMW 318i - download your manual now! Money Back Guarantee! 1998 BMW 318i service repair manuals. BMW 318i 1998 Factory Repair Manual; BMW 318i-s 328is, 323i, 328i, M3 1998 INCL CONVERTIBLE ELECT. hd ultra limited bmw 318i se owners manual - manualspath.com manual mecanico aveo bentleys bmw e36 workshop service manual m3 318i softail 1995 bmw 318i auto repair manual - chiltondiy renault cd bmw repair manual from haynes - haynes is the information nexus student bmw e46 318i repair manual 1999-2006 - cummins 6cta engine manual manual bmw. Order BMW 318i Repair Manual - Vehicle Maintenance online today. Free Same Day Store Pickup. Check out free battery charging and engine diagnostic testing while you are in store..
Auto Facts has the best selection of service repair manuals for your 1997 BMW 318i - download your manual now! Money Back Guarantee! 1997 BMW 318i service repair manuals. DOWNLOAD BMW E46 318I SERVICE MANUAL N42 MOTOR MBAASORE bmw e46 318i service pdf BMW AG (German: [ˈbe˒ˈʔɛmˈve˒]; originally an initialism for Bayerische Motoren Werke in German, or Bavarian Motor Works in English) is a German. Finally I get this ebook, thanks for all these Bmw 318i 2001 repair manual I can get now! Reply 1 Like Follow 1 hour ago Lisa Doran.
Find used BMW 3 Series Edition SE Cars for sale at Motors.co.uk. Choose from a massive selection of deals on second hand BMW 3 Series Edition SE Cars from trusted BMW dealers! BMW 3 Series2008 2.0 318i SE Edition 4dr Auto BMW 3 Series Edition SE Automatic BMW 3 Series Edition SE Manual.. Manual Idle Control Valve Bmw E46 318i DIY 92 e36 BMW idle control valve removal. WTF. BMW E30 M20 Idle Control Valve. BMW 318i SE 2.0 6 Speed (1 owner, 9 service stamps). BMW AG. Electrical troubleshooting still have For sale or swaps is my 1995 E36 318i bmw manual, is a rare morea.. Bmw 318i Se Manual MANUAL. This bmw 318i se service manual will contain a broad description in the item, the name and functions of their various parts, step-by-step instructions..
Dec 16, 2015 · Buy and Download Complete repair manual / service manual for BMW 3 Series E36 M3, 318i, 323i, 325i, 328i, Sedan, Coupe and Convertible 1992 - 1998. This manual very useful in the treatment and repair.. 8 days ago · equivalent to the printed versions available from a local (U.S) BMW service center. 4. Additional BMW 3 series M-vehicles are archived on the separate M-Vehicle page. BMW 318I ELECTRICAL TROUBLESHOOTING MANUAL Pdf Download. View and Download BMW 318I electrical troubleshooting manual online. 318I Automobile pdf manual download..


text:
Kejlsø er en lille ubeboet ø i det sydlige Guldborg Sund mellem Lolland og Falster.

Højeste punkt: 2 m over havets overflade.

Øer i Danmark
Fredede arealer i Danmark
Guldborgsund Kommunes geografi


text:
Escape Room Artist
Escape Room Review - Escape Hunt:Samurai Espionage
Escape Hunt Tokyo is located in the Asakusa district of Tokyo, but it's hidden away from the tourist-packed market stalls and shrines that the area is known for. While there's hardly a shortage of escape rooms to be found in Tokyo, Escape Hunt is one of the few that caters to both Japanese and English speaking audiences.
There are three rooms on offer – a mystery involving a runaway bride, a samurai-themed room and a room with a Zen theme. As we were in Japan, it seemed only fitting to go for the samurai-themed room. The plot of the room is set in Edo-period Japan, the era of feudalism, geisha, shogun and samurai. You play as a samurai, and the local shogun that you serve has received a death threat. Your task in the game is to secure the area and protect his life. The room is decorated with tatami mats, and to keep authenticity you're expected to remove your shoes before entering. Besides that nod to detail, the room is actually quite small and sparsely decorated. There are wall hangings and sliding doors, but not much in the way of extra decoration – if it's included in the room then it's there for a good reason.
The website highlights the focus of each room, with the Zen room described as being centred around 'searching and discovering things around the room'. The bridal room's focus was said to be on mind puzzles and observation, while the Samurai Espionage room was more based around physical activity. When choosing which room to book, you should think about what aspects of escape rooms you enjoy, where your team's strengths lie and even the age and attention span of your team. For example, a team that includes children may prefer a room that involves searching around over a more cerebral challenge. While I can't speak for the other rooms, the company's description is a fair assessment of the Samurai room. There were a lot of physical puzzles and activities in the Samurai room, including getting to play with one large, very cool and apparently authentic prop.
Does…does it still count as a spoiler if they've literally got it
featured on the front page of their website?
No understanding of Japanese, either spoken or written, is needed to successfully play through the game. There is a fair amount of Japanese text, but any writing also has an English translation provided. There are Japanese numerals throughout the game though, and this creates an extra level of difficulty for English-speakers who will have to spend time translating these. This goes some way to explaining why every team on the leaderboard was Japanese. The quickest completion time for the room was 25 minutes, which is almost too quick – if it hadn't been for the extra time spent identifying and interpreting the Japanese numerals, there would be a lack of content to the room.
The hint system for the room was unlike any that I've encountered before. Rather than hints being provided through writing on a screen, via walkie-talkie or even by text message, there was a buzzer situated near the door. If you gave in and pressed the buzzer, the Escape Hunt worker monitoring the game lets themselves in and offers assistance. They then hover uncomfortably for a while before leaving. It is a quicker and more efficient way to get immediate feedback, rather than being fed hints based on the limited viewpoint that the employee has through the cameras. Still, it's incredibly immersion breaking to have them able to wander in, and also gives a real sense of defeat in having to ring the buzzer of shame.
Pictured: the buzzer of shame.
After we completed the room, we were offered tea and refreshments, and then had the photo session standard to every escape room. The company's hospitality was outstanding, but it was actually another symptom of my issue with this room. The photo session in the aftermath of the game featured costumes to wear and props to pose with, including signs with slogans such as Ask me how we escaped! and I'm with stupid! It all felt very generic and no different to any escape room in the UK. Although the room featured samurai, something inherently Japanese, there wasn't really any unique twist to it, which was most of the reason that we'd taken the time to experience how another culture would interpret escape rooms. There are certain points that are central to the concept, such as the puzzles and a set time limit, but other than that different countries can take the idea in very different directions. There's a chance that I'm being unfairly harsh on this room because my expectations didn't match up to what they provided. We had been excited to see what Japan, the country that first came up with the concept of escape rooms, would have to offer. It turned out to be very similar to what we could experience in, say, Birmingham or Slough.
There was a large world map on one wall which was bristling with pins, and underneath there was an extensive list of all the locations where Escape Hunt is located. It was an extensive list which correlated – if only roughly – with the locations pinpointed on the map. Escape Hunt is a franchise across the globe, which may be part of the reason why everything felt so homogenised. The company was professional, all of its employees unfailingly polite and the room was perfectly satisfactory, but there was a lingering feeling that it catered to tourists. If you're looking for an escape room to pass the time then there's nothing wrong with this one. But if you're looking for an escape room that offers a uniquely Japanese experience then it may be best to keep searching.
Website: www.tokyo.escapehunt.com
Price: ¥7560 per person for a team of 2, decreasing from there*
Players: 2 – 5
Strengths: Hospitality, prop
Weaknesses: Generic
*Around £25 per person at the exchange rate at the time of writing.


I wrote this answer to a patient on ACOR or Association of Cancer Online Resources to her questions about other's experience with transplants and CLL with the bad prognostic marker of 17p del.
A HSCT is narrow road, but sometimes it's the best road and sometimes it's the only road, but it is always a narrow and difficult road.
Have you contacted BMT-TALK@LISTSERV.ACOR.ORG? That's a start.
Mine is bkoffman.blogspot.com ( not 17p but 11q CLL). I am here and doing OK 3 years post a rejected HSCT.
Chonette Taylor and Dennis Bayer have done pretty well, but they don't have a blog that I know.
And Susan's with CML http://www.caringbridge.org/visit/susanleigh is many years out, not without challenges, but living a big full life.
IF YOU DON'T WANT ANY REAL BAD NEWS, STOP HERE.
Prepare for a wild CLL/ transplant ride with Greg: http://www.caringbridge.org/visit/maddog23 He's a great writer too.
My memory is distorted. As a doctor, I am often guided by the worst cases, as they are the ones you must learn from to best avoid repeating the dangerous moves.
I am sure that I have forgotten other voices that have guided and comforted me by sharing their trials and trails. Please forgive me.
Still despite all this bad news, actually odds are in your favor, but it is never easy. It is alway complicated and tough to decide and tougher to do.
We are all in this together. Let me know if I can help- if I haven't too scared or depressed you too much.
Many years ago, I read an article about Frank Sinatra having a cold. It was a big deal, with recording and performing dates upcoming. And for a man not known for his calm demeanor at the best of times, his sniffles didn't make the job of his entourage any easier.
I knew I was at risk when I was stuck in the waiting room for a routine dental hygiene appointment (trying to be healthy and proactive with my teeth and gums) with a young child joyfully coughing and sneezing away, and with her mother dutifully reading to her. Every tenth or twentieth discharge of millions of viruses into the closed atmosphere from her snotty kid, mother would suggest that she cover her mouth, which was never actualized. I guess the thought counts. I guess I need to carry a N95 mask with me at all times, especially in flu season. I guess I now will worry how my battered immune system will handle this latest assault with nearly all my antibodies missing in action. Maybe my borrowed IVIG next week with be my rescuing cavalry charge.
My chief complaint is mostly a miserable runny stuffy sneezy nose, just like the little girl I shared the air with a few days ago. Throw in some mild malaise and a not so bad sore throat and you get the picture: a head cold.
My usual diet of cold raw veggies is of no interest when I feel this way. I want hot soup and tons of tea, and even more time to nap.
Hopefully I have only a few more days or less of this gentle misery ahead of me. Hopefully my chest is not the next battlefield.
I haven't time for this. I have work to do, but I also have bigger zucchinis to chop.
I might also add descending more than a mile into the pit and reemerging impressed with what is possible and what is unknown and unknowable.
The disconnect between how well I might look and feel and the growing burden of cancer in my gut challenges my intuitions of how the world and leukemia works. Fighting the hidden enemies is my new imperative, one I can not ignore or wish away.
My doctors Forman and Kipps disagree on most everything, EXCEPT that I need therapy. Soon.
I will be spending the next 2 to 3 months deciding what to do next.
Doing nothing is not an option. Or at least not a very wise option, though it is certainly the most appealing in the short term.
I will not let this decision consume me, but will try as best I can to detach myself from the process and argue as I would for a friend or patient.
I will try to be calm in the face of imperfect choices and incomplete data.
I will try to look beyond the immediate horizons to the best possible future.
I will decide and move on.
The second was shot when I was lecturing this week in Motown, after more than six years of fighting my CLL and ITP and after the very recent challenge of nodes pushing 10 centimeters in my gut.
Have I changed much? You be the judge.
I still have my grey hair and mustache. I still wear dark sweat shirts and grey scarves, though the new scarf is from my visit to Egypt and not from a mall.
I still visit art museums wherever I travel, even when it is too cold and too difficult and makes no sense. What did art ever have to do with sense?
I still gravitate to the modern art, and still love what Leger can teach us about being human souls in an increasingly mechanized and alienating world.
Tomorrow I consult Dr. Forman about how a second transplant, still the only cure for my CLL. I will ask him when and how that fits into my treatment mix.
All that is missing is a third photo of me beside another painting by Leger, perhaps next time in Biot, France where his national museum is to be found.
But that photo is at least five years off.
That picture will be of me post CLL. Cured. Or at a minimum in a very long term deep remission.
That picture will not be hiding any internal nodes or diseased marrow. You could zoom in using a billion pixels and never find a trace of my evil clone ready to explode again. because there will be no rogue sleeper cells.
In that picture my hair may be thinner, I may be thinner, but my smile with be broader and my eyes brighter.
In that photo I will be in my 70s, but I guarantee I will still be hungry for more art by Leger to delight in and more life to share.
Stay with me until I share that photo. I guarantee a wild, informative and entertaining ride before and for many years after that next snapshot is posted.
Karl asked I post a slightly more polished version with his signature.
I am in Dearborn, having just finished two days of lectures and little thought about CLL- Ask me about sleep apnea or migraine or circadian problems and I am all over it, but CLL has been happily off my radar screen for a day or two.
I am loving Hockeytown. There is a big hockey tournament in town so kids as young as 6 are found all through the hotel carrying their gear with help from lots of proud moms and dads.
There is also a Star Trek convention here.
Is this great or what?
Saw the powerful Diego Rivera Courtyard at the Detroit Institute of Arts and went to a wonderful activist Sabbath service in an old downtown synagogue, then enjoyed a decent raw organic vegan meal. I was the only one there over 30, and the patrons were diverse to say the least. Next store, crowds in T-shirts and shorts or clown outfits were braving the bitter cold for what seemed to be a rave- I asked one of the freezing guys waiting in the que to get in: DJs, circus, lots of dancing and laughs. Sounds like a rave to me.
Tonight it's Arab food. Dearborn has the largest Lebanese community on the USA.
And I leave for the airport at 4:30 AM. Almost not worth going to bed.
... Which seems to apply pretty well to the indolent lymphomas and CLL.
lymphoma can sometimes require a timely response.
the odds of achieving the best results.
to using milder therapies more often.
lymphoma, or responsiveness to prior therapies.
Karl is an excellent researcher and a very clear thinker.
Take a look at what he has to say about the choices in an indolent cancer.
This is the generic question I face.
Do I hit the CLL hard and then dash to a transplant, and be cured or die trying or perhaps worse get a new difficult and sometimes incurable disease, graft versus host?
Do I gently rap the cancer's knuckles with a slightly bigger stick than the rituximab which is no longer doing the job, but hold off on the big clubs to avoid peripheral damage to my already compromised marrow and immunity? Probably that means a clinical trial.
Here is how Karl lays out the options. I will write soon on the specific details of what I need to deal with, what I can't ignore.
"If treatment for cure is necessary; is it possible? If possible, is it necessary?"~ Dr Willet Whitmore (on prostate cancer).
advanced lymphoma can sometimes require a timely response.
therapeutic options and lower the odds of achieving the best results.
My MR showed that my gut nodes that have grown too big, and need attention. Counts are good except for a mild persistent anemia.
Kipps says I shouldn't ignore them or the ones he can palpate, but there is no urgency.
The next step is a bone marrow biopsy and then probably a clinical trial at UCSD. All in the next 60 -90 days or so.
Actually the next step is a nap. I always think clearer after a nap.
And I write better too.
It would be so great to get a long respite from decision overload. My longest rest from having to do something about my CLL was about first 12 months after I was diagnosed, and that hardly counts as I was running around getting contradictory opinions on what to do and not to do.
I could use a break from this chess game.
But that's not to be, and so I will nap and research and meditate and move on.
It is a much better time to be pushed to treatment than say 4 years ago when I went for my transplant. Many more effective low toxicity choices now.
But first, my nap. I love to nap, don't you?
You give me reason to live, you give me a reason to live, you give me reason to live!
Patty and I went on one of our best trip ever. It wasn't exotic China, not romantic Italy, not Zen Japan, not super natural New Zealand, not historic Prague or musical Vienna or friendly OZ, not ancient Israel and Egypt, not the castled United Kingdom, not magical Peru, not the grand Grand Canyon, but gritty occupied Oakland because that's where my daughter, son-in-law, and granddaughter live.
That young lady with the pink bib in the picture is another reason to soldier on.
I have no bucket list. As I have said before, I have way too much joy in each day and way too many things left undone to imagine that a list of the top 10 or top 100 or 1000 checked off would signal it's OK to check out.
But seeing that four month old under the marriage chuppah might be a moment when I can say that I have seen enough.
Nah, make that holding my first great grandchild. I should be in my 90s or close. If I live long enough to see that baby's bat mitzvah, I would be around the century mark.
In any case, CLL would be a remote memory. What a blessing that would be.
But now CLL is front and center. Tomorrow I have my MRI to see if my CLL is trying to launch a sneak attack from inside enemy lines, my mesenteric or gut nodes. If they have grown too big despite another course of rituximab, I need to knock them back to size while I still can. If they become "massive" ( >10 cm) they become harder to kill. In these large niches, they have more supportive infrastructure such as nurse cells and they are just tricker to reach with what ever toxic cocktail I have planned for their last meal.
That means choosing a new treatment strategy that keeps one eye on my ITP, and another on my sleepy bone marrow and my third eye on a future transplant redux- probably my only chance to live long enough to see a fourth generation.
I wish there was another way, but I am not convinced. Kinase inhibitors such as CAL 101 or immunomodulators such as Revlimid might buy some time, but not a cure. They don't promise me another 30 years. Only a second transplant gives me a 50/50 shot at getting really old. But a transplant demands a big price for that shot of redemption and a second transplant demands even more.
I have been catching up on hours and hours of reading about my disease and transplant. CLL remains thankfully a hot research arena. Much is changing fast, but is it fast enough? I doubt it, at least for me and those of us who might need treatment soon.
Those who have followed me on some or part of my six year journey know this is a repetitive loop- my anxiety before a scan or bone marrow biopsy, my cogitation over my next move, my lament about the slow progress and the constricted choices, and my hunger for life.
I've got too many reasons to live and one very young, and beautiful new one.


Time is just racing by at this point in the story. No surprise of course that they are moving time along so they can get to that match revealed in the first episode. At this point the race is on and we know the destination point. So it wasn't much of a surprise when the episode opened up with Akari just going through the timeline. They've just straight up moved into the next year of schooling for the respective students. It's not quite a full year time skip since the last incarnation of this Valkyrie Cup happened before Haruka moved out there, but it's still a significant jump in time. Although that was somewhat required since the skills and growth Haruka needed as an athlete required time to master.
The only real downside I have with this time skip is the lack of interest in finding Akari a partner. She's been in the beach volleyball club for months and they haven't been able to find anyone for her to play with. It's good that she has friends and a larger social circle. But how much fun is there really for her to have sitting around and watching or practicing on skills without a partner? I know the focus is on Haruka and Kanata, but it feels awkward to introduce this character without a plan to pair her up with someone.
At least this episode did focus a decent amount on Haruka. They haven't really returned to tackle any issues with her height or anything, but it did focus on her development. The whole showdown with the Kanna/Youna pair centered on attacking Haruka's blocks. While Kanata played an important role near the end Haruka won almost all the points. Normally I'd say that would hint towards the kind of negative thing that lead to Kanata retreating from the game in the first place. But in this case it was more about showing that Haruka has improved all facets of her game (spike, serve, block, etc.) and was now capable of holding her own. It wasn't an overnight improvement but the time skip did allow her to grow rather quickly in that respect. This does show that her blocks aren't anything to look down on and are now a key consideration.
The match itself was pretty simple. Kanna and Youna were just trying to break through the block and tried every trick they had to make that happen. The scary thing was that they didn't have much of a plan. They were bleeding points throughout the game just trying to crush that block. Their plan clearly ignored that Kanata had the option of tracking down anything that broke past and they didn't have a solid defense to handle Haruka's spikes. It wasn't a great strategy and their loss was somewhat a given.
The other big point made in this episode is that the next match is going to be an intense one. Instead of what Claire/Emily said before there isn't two spots available for both teams to claim. Whether that's different from the manga or they did it here to cut back on the amount of matches I'm not sure. But regardless the end result is a given. We already saw Haruka/Kanata facing Narumi/Ayase in the opening episode. We know that Haruka and Kanata are going to win this match. The only question now is how they win and what growth is needed to overcome such a strong pair in Claire and Emily. I suppose the show could catch us offguard and have the officials decide to award Claire and Emily a spot since losing last year's runner-ups in a qualifying tournament would be a shame, but I kind of doubt it.
Now we just have to wait and see how this match will go. It will be interesting to see how Haruka rises to the occasion and what Kanata can do. Claire and Emily are pretty balanced and both very good. If the story has decided to give our main characters a win then it will require some careful consideration as to how that will happen. This should be fun to watch though. There is good stuff in there since all four characters have spent a good amount of time together.
This was a pretty good episode. They did what was needed in pushing the clock ahead so they can get to the planned showdown in the final episodes. There isn't much time left, but that just means these matches should be short but sweet.


text:
Q: How do I Reset Chrome's Java Applet Security Prompt? I'm having a heck of a time debugging a certified Java applet in Chrome.  I want the browser to serve me the "Security Warning" prompt (shown below) every time I refresh to simulate a fresh visitor.  The browser seems to permanently remember my selection for all apps on the domain.

Clearing the cache and cookies does not reset this.

A: Java has its own Applet-related cache that is independent from the browser cache. Go to your Java control panel and you will see a "temporary internet files" section under the General tab. There you can clear the cache related to your applet, or even disable it. Possibly this will resolve your issue.

redpajama_set_name: RedPajamaStackExchange


Look for the Historical Society in the annual Memorial Day Parade and then join us for an Open House at the History Center – 721 N. Prospect @ Prospect Park. Refreshments will be served.
Ride your bike on our guided tour through the city's north side and view historic sites.


text:
Boardwalk Power Link
Visit Main Company Site
The innovation to lead New Jersey to our carbon- free future.
Anbaric is a renewable energy industry leader with decades of experience in energy transmission and proven experience in the Northeast.
We're working on expanding New Jersey's offshore wind infrastructure to help position our state at the forefront of clean energy development in the nation.
Carbon-Free Future
Anbaric is committed to building New Jersey's carbon-free future by solving today's critical renewable energy challenges.
Scaling Renewables
The waters off New Jersey's coast are perfect for offshore wind. Currently, our state has the mandate to reach 11,000 MW of offshore wind by 2040.
Innovative Industry Leader
Anbaric is an innovative energy industry leader dedicated to building the clean energy infrastructure of tomorrow.
See How Offshore Wind Can Power 3.2 Million New Jersey Homes.
Janice Fuller
At Anbaric, leading the way towards a cleaner, renewable energy future is more than just our business – it's our passion.
As a lifelong New Jersey resident and mother of three young children living near the Jersey Shore, I know firsthand the importance of creating a carbon-free future. At Anbaric, we understand that building sustainable energy systems cannot wait; the work must start now. I'm proud to lead a New Jersey company at the helm of environmental sustainability, as we build the green energy systems of tomorrow.
The waters off New Jersey's coast are perfect for offshore wind.
Currently, our state has the mandate to reach 11,000 MW of offshore wind by 2040. Anbaric is the company to economically scale renewable energy in New Jersey.
Planned transmission infrastructure is the critical first step. Planned transmission is a concrete commitment to build the offshore wind industry to scale by speeding the development process. Future wind farms can connect to a transmission system much more quickly than if they had to build their own link to the grid.
Why Offshore Wind Transmission?
Anbaric is a proud member of:
Learn More about Anbaric in New Jersey
Value-Driven
Anbaric is a value-driven company that is US-based. We are funded by the Ontario Teachers' Pension Plan (OTPP), a responsible investor guided by strong environmental, social, and governance principles. OTPP is Canada's largest single-profession pension plan. The partnership between Anbaric and OTPP creates the opportunity for innovative new projects to be developed and for OTPP to invest and participate early in the asset lifecycle.
Anbaric is an innovative energy industry leader dedicated to building the clean energy infrastructure of tomorrow. Planned transmission systems, such as the ones being developed by Anbaric, help lower costs, create competition and reduce monopoly risk, while protecting the environment and accelerating the deployment of offshore wind.
Anbaric is an American company whose executives collectively have decades of experience in the energy industry and hands-on expertise with projects in the Northeast. Anbaric was a founding member of the only companies to have developed two buried, underwater electricity transmission lines originating here in New Jersey: the 660 MW Neptune and 660 MW Hudson transmission projects, both completed on time and on budget. Additionally, Anbaric is committed to partnering with organized labor for the construction of future projects, as we have in the past.
Anbaric is committed to building New Jersey's carbon-free future by solving today's critical renewable energy challenges. By scaling offshore wind development, New Jersey can accelerate the development of clean, sustainable energy systems and become a national leader in renewable energy.
Anbaric Applauds Governor Murphy's Offshore Wind Goal Announcement
Anbaric commends Governor Murphy for his commitment to accelerating the growth of the offshore wind industry in New Jersey following the announcement that the state will increase their offshore wind goal from 7,500 MW by 2035 to 11,000 MW by 2040.
Anbaric Statement on the First New Jersey Offshore Wind Transmission Stakeholder Meeting
Anbaric Development Partners released the following statement from Janice Fuller, President, Mid-Atlantic, regarding the first New Jersey Board or Public Utilities (BPU) stakeholder meeting on the Offshore Wind State Agreement Approach Transmission Initiative.
Anbaric Statement on the Announcement of New Jersey's Adjusted Offshore Wind Solicitation Schedule
Anbaric Development Partners released a statement from Janice Fuller, President, Mid-Atlantic, regarding the New Jersey Board of Public Utilities' adjusted offshore wind solicitation schedule.
Anbaric Applauds the Biden Administration for Historic Offshore Wind Lease Auction in the New York Bight
Anbaric commends the Biden Administration for its commitment to accelerating the growth of the offshore wind industry along the Atlantic Coast.
Copyright © 2020 Anbaric Development Partners, All Rights Reserved. Website by Mosaic.


Recharge on your Mobile/ELECTRONIC VOUCHER/Data Card are realtime transactions and there will be no refund or exchange permitted. Please be advised that You are responsible for the mobile number, ELECTRONIC VOUCHER account number and/or Data Card mobile number recharges and all charges that result from those recharges/purchases. Topup.co.zw is not responsible for any purchase of Recharge for an incorrect mobile number, ELECTRONIC VOUCHER account number and Data Card mobile number.
However, in a case where a transaction has been completed by you on the Site, and money has been charged to your card or bank account but a Recharge has not been delivered within 24 hours of your completion of the transaction for reasons like "invalid recharge denomination", "service provider unavailable" and/or other technical issues, then you may inform us by sending us an email on support@topup.co.zw or contacting us via our various support channels. Please note that as soon as the transaction fails, money is typically returned automatically to your original payment instrument.
We request you to include in the email the following details - the mobile number/ELECTRONIC VOUCHER account number/Data Card Number, Operator name, Recharge value, Transaction date and Order Number.


· Prevent car or truck driver distraction: Prevent your dog from distracting the driver! Driver distraction results in thousands of unnecessary accidents.
· Protect passengers from injury in an accident: In the event of a sudden stop, an unrestrained animal can become a projectile – hurting themselves and others in the vehicle.
· Reduce injury during travel to your pet: Animals are frequently injured by being thrown into wheel wells and underneath seats – or into/through windows.
· Help rescue workers by keeping a dog restrained: In the event of an accident, a frightened animal may try to protect an unconscious passenger, making rescue more difficult for rescue workers.


text:
Students counter-display School of Evangelism
Jennifer Corbett
In response to the School of Evangelism preaching no sex, impure thoughts or masturbation before marriage on campus, a group of student groups voiced their opposition Nov. 19 on the university plaza.
Common ground and Pagan Student Association were just two of the groups that protested outside of the University Center. The group held signs that said "It's natural to love yourself and yes I mean masturbation," and "Atheists are people too. We think, we have values, we care and we love."
"We all just kind of came together with all positive messages," said Chris Walker, sophomore anthropology major.
The group planned to hold their signs until 2 p.m. and have no plans on coming back.
Walker added the group "may pop back up if another group comes back and tells us we're going to hell."
Junior Michelle Franklin agreed with the message the students were sending.
"I think it's a good idea. (The school of Evangelism) was out of line, we always have a choice and we choose what we want to do," she said.
The members of the School of Evangelism visited Northern Kentucky University twice in Novemeber preaching their message to students on the plaza.


Application Acceleration Manager (AAM) uses symmetric data deduplication to reduce the amount of bandwidth consumed across a WAN link for repeated data transfers. This feature is available only with an Application Acceleration Manager (AAM) license.
With data deduplication, the system performs pattern matching on the transmitted WAN data, rather than caching. If any part of the transmitted data has already been sent, BIG-IP system replaces the previously transmitted data with references. As data flows through the pair, each device records the byte patterns and builds a synchronized dictionary. If an identical pattern of bytes traverses the WAN more than once, the BIG-IP closest to the sender replaces the byte pattern with a reference to it, compressing the data. When the reference reaches the other side of the WAN, the remote BIG-IP device replaces the reference with the data, restoring the data to its original format.
Symmetric data deduplication (SDD) offers two versions, called codecs. SDD v3 is appropriate for most AAM installations, particularly in large networks, such as hub and spoke, or mesh deployments. SSD v2 is an alternative for installations with fewer than eight high-speed links, such as for data replication between data centers.


text:
National Day parade draws to a close at Dataran Merdeka with Negaraku finale
The National Day parade came to a close with the singing of the Negaraku at Dataran Merdeka, today. (pix by MOHD YUSNI ARIFFIN)
By HANA NAZ HARUN and SOO WERN JUN - August 31, 2017 @ 1:17pm
KUALA LUMPUR: The National Day parade came to a close with the singing of the Negaraku at Dataran Merdeka, today.
The crowd chanted "Daulat Tuanku" three times as the Yang di-Pertuan Agong, Sultan Muhammad V, made his way down from the grandstand about 10.45am to leave the event.
Soon after, the 400-strong marching band played the late Sudirman's hit song, Tanggal 31.
Children and adults alike sang along to the tune, proudly waving their Jalur Gemilang in the air.
Over 50,000 people thronged Merdeka Square this morning, some coming as early as 6am to secure the best possible seats to watch the annual parade.
Prime Minister Datuk Seri Najib Razak and his wife, Datin Seri Rosmah Mansor arrived at 7.45am in matching yellow khaki uniforms. It was also attended by Deputy Prime Minister Datuk Seri Dr Ahmad Zahid Hamidi, Cmunications and Multimedia Minister Datuk Seri Dr Salleh Said Keruak, among others.
The crowd then witnessed the hoisting of the national flag by officers from the Royal Malaysian Navy (RMN) followed by the singing of Negaraku and a 14-gun salute representing the states in the country by the Royal Artillery Regiment.
This was followed by the oath-taking (ikrar) ceremony, and ended with the crowd being led to the shouts of "Merdeka", led by Najib.
Spectators were then taken back in time when the nation's 60-year history was presented at the celebration, right from pre-independence days.
The showcase was aided by a 200-metre wide and 9-metre long giant LED screen, with the help of 2,000 student volunteers on the graphic terrace.
With the this year's theme "Negaraku Sehati Sejiwa" (My country, One Heart, One Soul) performers re-enacted the Malaysia's journey and development under all six prime ministers, showing how the country had progressed throughout 60 years.
This year's celebration also saw the appearance of several individuals, including two RMN retirees tasked with raising the Malaysian flag for the first time. They were Lt Commander (Rtd) Mohd Sharif Kalam and Warrant Officer 1 Commander (Rtd) Oliver Culvelt Samuel.
Another special guest was Rusnah Aksah, 66, who released 101 pigeons on Sept 16, 1963 in conjunction with the formation of Malaysia. Rusnah was 12 at the time she released the birds at Merdeka Stadium.
This time, Rusnah released 60 pigeons, symbolising 60 years of independence.
Also making an appearance was the national contingent for the 2017 Kuala Lumpur Sea Games, led by the official mascot, Rimau, and cycling superstar 'Pocket Rocketman' Azizulhasni Awang.
A giant 20x40m Jalur Gemilang, was brought to the parade march by the National Service Training Department and the National Service Volunteer Brigade, led by Mohd Yunus Abd Rahmat.
The crowd was also treated to an airshow performed by the Royal Malaysian Airforce fly formation which this time featured Hawk aircraft, F/A 18Ds and Sukhoi SU 30 MKM fighter jets.
Alor Star roads to close for Merdeka Day parade tomorrow
Weatherman forecasts sunny skies for National Day parade
10,000-strong crowd celebrate National Day parade in Kuantan