text:
News: Kiefel J's last judgment, Kiefel CJ's first
Posted on 30 March 2017 by Jeremy Gans
Yesterday's two judgments mark the final step of the transition from the French Court to the Kiefel Court. Until this week, judgments published by Susan Kiefel have been attributed to 'Kiefel J', even though she has been Kiefel CJ since January 30th. In today's two decisions, the first, Ecosse Property Holdings Pty Ltd v Gee Dee Nominees Pty Ltd [2017] HCA 12, has a joint judgment attributed to 'Kiefel, Bell & Gordon JJ', while the second, Kendirjian v Lepore [2017] HCA 13, has a solo judgment attributed to 'Kiefel CJ'. The obvious explanation of the shift is that 'Kiefel J' is used for judgments where Susan Kiefel was still a mere Justice when she sat at the hearing. Ecosse was heard on 14th December last year, at a time when Robert French was still Chief Justice – he had six weeks left in the role – but by then he had not heard any cases for over two months and the Court had already held a ceremony to mark his retirement. By contrast, Kendirjian is the fifth case heard by the High Court since Susan Kiefel became Chief Justice, but the first to be decided.
So, what were the first ever words in a judgment by Kiefel CJ?:
I agree with Edelman J.
Posted in News, Opinions
Ecosse Property Holdings Pty Ltd v Gee Dee Nominees Pty Ltd
Posted on 29 March 2017 by Martin Clark
The High Court has allowed an appeal against a decision of the Victorian Court of Appeal on contract clause amendments and liability for rates and land taxes. The respondent is the current tenant on an ambiguously amended old-form 99-year lease, concluded between an earlier landlord and tenant in 1981, over farmland now owned by the appellant. Clause 4 of the lease stated, and was amended by striking through, that: 'all rates taxes assessments and outgoings whatsoever excepting land tax which during the said term shall be payable by the Landlord or tenant. A majority of the VSCA held that this clause left the landlord liable for those payments including land taxes levied upon the landlord. Kyrou JA, in dissent, held that this interpretation was not tenable because of the existence of cl 13, which required the tenant to pay the entire 99-year rent in advance, Continue reading →
Posted in Case Pages, Opinions
Kendirjian v Lepore
The High Court has allowed two appeals against a decision of the New South Wales Court of Appeal on advocates' immunity. The appellant was the plaintiff in a car accident matter. The appellant sued his solicitor (Lepore) and barrister (Conomos) for professional negligence after they informed him that a settlement offer had been made just before trial, but allegedly failed to tell him the amount ($600,000). Instead, the appellant claimed the respondent lawyers rejected the offer without seeking instructions on the basis that it was too low, and advised him that his claim was worth twice as much. Upon the claim succeeding, the appellant received only $300,000. The NSWCA held that the advice or omission to advise was out of court conduct that led to the continuation of Court proceedings, and consequently fell within the scope of advocate's immunity. After the NSWCA's judgment, the High Court handed down its judgment in Attwells v Jackson Lalic Lawyers Pty Ltd [2016] HCA 16, holding that advocate's immunity does not extend to negligent advice that leads to a settlement between the parties. On appeal to the High Court, the appellants contended that Continue reading →
Posted in Case Pages, Decided Cases, Opinions
News: Kiefel CJ describes and defends her Court's judicial method [updated]
The new Chief Justice of the High Court, Susan Kiefel, gave the 2017 'Supreme Court Oration' in Brisbane last week to a sell-out crowd. I dare say it is one of the most significant speeches a sitting Chief Justice has given, outlining in detail the High Court's current process for producing judgments and responding to some criticisms of that Court's approaches, including those of former High Court judge Dyson Heydon and current President of the NSW Court of Appeal, Margaret Beazley. The Australian Financial Review covered the speech as favouring 'productivity over prose', and contrasted her approach to one-time law student favourite Lord Denning. The Chief Justice's line:
I have always assumed it to be a universally held view that a judgment should be as succinctly stated as the matter allows.
has the potential to be her version of Dixon CJ's famous, and much debated, pronouncement: 'There is no other safe guide to judicial decisions in great conflicts than a strict and complete legalism.'
The 12-page speech has far too much detail to cover in a short news post. However, one passage, explaining one reason she deprecates unnecessary separate judgments, caught my (and the Australian Financial Review's) eye: Continue reading →
News: Three grants of leave
Last week's special leave hearings broke a four-month drought in appeals granted special leave 'on the papers'. There were three grants of leave announced, one on Wednesday (without a hearing) and one each on Friday's two oral hearings in Brisbane and Sydney.
The three appeals that will now go to the High Court are:
Compton v Ramsay Health Care Australia Pty Ltd [2016] FCAFC 106, which concerns the circumstances when a person who a court previously held owed a debt and is now bankrupt can now argue that he didn't owe the debt. In 2015, the NSW Supreme Court held that the respondent owed just under $10,000,000 [EDITED: see comments] to the applicant after guaranteeing a now bankrupt company's debts, rejecting his argument that details of the debt were not attached to the papers he signed and that he wasn't aware of them. After he went bankrupt and the applicant applied to sequester the debt (preserving it from the demands of other creditors), he submitted new financial evidence challenging whether the bankrupt company ever owed anything to the respondent. The Full Court of the Federal Court unanimously held that the trial judge should have opted to inquire into whether any debt was owed, even though the applicant never challenged the amount of the debt in the NSW Supreme Court.
Kennedy & Thorne [2016] FamCAFC 189, which examines the enforceability of binding financial agreements (colloquially known as 'pre-nups'), where one party insists on the agreement as a pre-condition to marriage. The parties to a 2007 marriage differed in assets (none vs $18M), Australian immigration status (a tourist visa vs Australian citizenship) and English fluency (little vs complete.) A week before they married, they signed an agreement prepared by the richer party's solicitor, despite the poor party receiving independent legal advice that the agreement was 'no good' and (about a further agreement shortly after the marriage) 'terrible'. Ruling after their 2011 separation and the richer spouse's death in 2014, the Full Court of the Family Court overturned a trial judge's finding that the agreement was the result of duress, holding that the trial judge failed to provide adequate reasons for the finding of duress and failed to make a finding of unlawful pressure (as opposed to a mere threat not to marry), instead holding that the agreement was binding on both parties.
Shop, Distributive & Allied Employees Association v ALDI Foods Pty Ltd [2016] FCAFC 161, concerns the process for approving a regional enterprise agreement with employees who are presently in a different region. After the majority of seventeen employees of Aldi who were offered roles in a new 'region' of the company's operations (on the NSW/SA border) voted to approve an enterprise agreement and the agreement was approved by the Fair Work Commission, the union (which was not involved in the earlier agreement) challenged the agreement on three grounds. A majority of the Full Court of the Federal Court held that the agreement could not be approved because it failed a statutory requirement that 'the agreement has been genuinely agreed to by the employees covered by the agreement' – at the time of the vote, the new region had no employees. The same majority also held that the Commission failed to properly apply the requirement that the employees be 'better off overall', relying instead on a clause in the agreement that promised the employees equal (but not better) terms than the award. But the Court unanimously held that it could not invalidate the agreement because of a one-word deviation between the notice given to the employees and the required wording, because, to the extent that the different wording was important – something the three judges differed on – the Commission's failure to act on it was not a jurisdictional error.
Prior v Mole
Posted on 8 March 2017 by Martin Clark
The High Court has dismissed an appeal against a decision of the Northern Territory Court of Appeal on the legality and consequences of a public drunkenness arrest. Two police officers fined the appellant for drinking in public and, following an altercation, took him into protective custody purportedly under s 128 of the Police Administration Act (NT). Section 128(1) allows a police officer to take a person into custody if the officer has reasonable grounds for believing the person is intoxicated in a public place and because of that intoxication is unable to care for him or herself, may intimidate, alarm or cause substantial annoyance to people, or is likely to commit an offence. The appellant was acquitted on a charge of disorderly behaviour, Continue reading →
Kumar v Minister for Immigration and Border Protection
The High Court has allowed an appeal against a decision the Federal Court of Australia on the extension of time limits on visa applications that fall on a weekend. The appellant received the respondent's application for a temporary student visa on a Monday and rejected it on the basis that the applicant must hold a temporary graduate visa, which for the respondent had expired on the Sunday immediately before. North J allowed the applicant's appeal, holding that s 36(2) of the Act Interpretation Act 1901 (Cth), which provides that where an act 'requires or allows a thing to be done' and the 'last day' for doing it is a Saturday, a Sunday Continue reading →
Perara-Cathcart v The Queen
Jeremy Gans, 'News: The High Court Splits Three Ways on Three-Way Splits' (1 March 2017).
The High Court has dismissed an appeal against a decision of the Full Court of the Supreme Court of South Australia on the use of evidence of illegal drug dealing within a rape trial. A jury convicted the appellant of rape and making a threat to kill against K. During the trial the prosecution led evidence from K and her boyfriend J that the appellant had supplied them with methylamphetamine prior to the rape and death threat incident, and marijuana at a later date. The SASCFC held that both K and J's evidence was admissible in the appellant's trial because they cast light on both the prosecution's claim that the rape Continue reading →
Bondelmonte v Bondelmonte
The High Court has dismissed an appeal against the Full Court of the Family Court on whether teenage children removed from Australia in breach of a parenting order must return despite their expressed unwillingness to do so. Following the Bondelmontes' separation in 2010, the Family Court made equal shared parenting orders with living arrangements to be decided by the parties and the children. In 2016, the father removed the two teenage boys to the United States, where they stayed for more than 14 days, in breach of the parenting orders. A majority of the Full Court of the Family Court upheld the trial judge's order Continue reading →
News: The High Court splits three ways on three-way splits
Posted on 1 March 2017 by Jeremy Gans
Today's decision in Perara-Cathcart v The Queen [2017] HCA 9 reviews a split decision in the Full Court of South Australia's Supreme Court, which Gageler J's judgment usefully describes with a table:
This combination raises a long-standing puzzle about the judgments of multi-member courts that have to decide two different issues in a particular case and manage to produce a three-way split. Continue reading →
Should an ongoing criminal investigation bar the return of unlawfully seized property? – AUSPUBLAW on Is the Constitutional Injunction 'Ordinary'? Smethurst v Commissioner of Police
'Berry v CCL Secure Ltd' | Private Law Theory - Obligations, property, legal theory on Berry v CCL Secure Ltd
Border Closures and s 92: Clive Palmer's Quest to Enter WA – AUSPUBLAW on News: The Court's national video connection
John Pyke on Is the Constitutional Injunction 'Ordinary'? Smethurst v Commissioner of Police
'Is the Constitutional Injunction "Ordinary"? Smethurst v Commissioner of Police ' | Private Law Theory - Obligations, property, legal theory on Is the Constitutional Injunction 'Ordinary'? Smethurst v Commissioner of Police
Posts and Cases


text:
Q: Rails omniauth-shopify-oauth2: "[API] Invalid API key or access token (unrecognized login or wrong password)" from console I set up shopify auth (omniauth-shopify-oauth2 gem) for my rails 3.2.6 app.
It works fine when routed from a web page (to the following controller#action)
class ShopifyController < ApplicationController
  ...
  def login
    redirect_to "/auth/shopify?shop=#{current_retailer.primary_host_name}"
  end

It redirects me to shop login and, once I am logged in, redirects back to success callback. All good (see SERVER LOG SUCCESS below).
But when I try to do pretty much the same from the rails console:
irb(main):001:0> RestClient.get 'http://localhost:3000/auth/shopify?shop=vinehillposters.myshopify.com'

I get:
RestClient::Unauthorized: 401 Unauthorized: <?xml version="1.0" encoding="UTF-8"?>
<hash>
  <errors>[API] Invalid API key or access token (unrecognized login or wrong password)</errors>
</hash>

see SERVER LOG FAIL below

SERVER LOG SUCCESS:
Processing by ShopifyController#login as HTML
... AR stuff snipped ...
Redirected to http://localhost:3000/auth/shopify?shop=vinehillposters.myshopify.com
Completed 302 Found in 93ms (ActiveRecord: 1.6ms)
(shopify) Setup endpoint detected, running now.
(shopify) Request phase initiated.
"https://vinehillposters.myshopify.com/admin/oauth/authorize?response_type=code&client_id=44dd9799fbc268c36ef609f0c2386b8c&redirect_uri=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fshopify%2Fcallba
ck&scope=read_orders"

Started GET "/auth/shopify?shop=vinehillposters.myshopify.com" for 127.0.0.1 at 2012-10-30 11:24:21 +0000
(shopify) Setup endpoint detected, running now.
(shopify) Callback phase initiated.

Started GET "/auth/shopify/callback?code=c8c6696ed347e37324d2d62ec203457b&shop=vinehillposters.myshopify.com&timestamp=1351596261&signature=e6324b041d6a6ed1e07719a8909d70f7" for 127.0.0.1 at
2012-10-30 11:24:21 +0000
Processing by ShopifyController#auth_callback as HTML
...

SERVER LOG FAILURE:
(shopify) Setup endpoint detected, running now.
(shopify) Request phase initiated.
"https://vinehillposters.myshopify.com/admin/oauth/authorize?response_type=code&client_id=44dd9799fbc268c36ef609f0c2386b8c&redirect_uri=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fshopify%2Fcallback&scope=read_orders"

Started GET "/auth/shopify?shop=vinehillposters.myshopify.com" for 127.0.0.1 at 2012-10-30 11:24:54 +0000

You may have noticed that I print out the request_phase url right before it gets redirected to shopify (after (shopify) Request phase initiated.). It is the same in both cases. Except in one case it returns success and in another it is 401.
So, what am I doing wrong?

A: I think your question is confusing and you are focusing on the wrong part.  What you need to do is once your user has logged in grab some information about them from the shopify callback.
def shopify
  shopify_domain = params[:shop]
  @your_shop_object = your_finds_or_initializes_shop_or_auth_object_with shopify_domain, token

  if @your_shop_object.persisted?
    redirect_to root_url
  else
    # something went wrong :/
    session['devise.shopify_data'] = request.env['omniauth.auth']
    redirect_to auth_index_url
  end
end

private
def token
  request.env['omniauth.auth']['credentials']['token']
end

Now with this you can use that persisted shop objects data to set up an authorized session
session = ShopifyAPI::Session.new(domain, authentication_token)
if session.valid?
  ShopifyAPI::Base.activate_session(session)
  # Now you can make api calls for that shop (domain)
else
  Rails.logger.error "[Shop] Could not create a valid session for '#{domain}'"
end

redpajama_set_name: RedPajamaStackExchange


In 2014 the big lottery gave us another 5 years funding for health which we have called let's get Healthy 2.
Part of the funding was to carry on doing living a Healthy Life 12 week course. In addition we will be running a four week cooking programme which will be part of the course.
Members have completed the 12 sessions and have been presented with their certificates by the Mayor of Enfield.


text:
At the Races or Racing UK?
by author | Jan 3, 2017 | HOT TOPIC | 6 comments
Battle of the Satellite Channels – Who has your vote?
ITV'S return to the televised racing fray has, it would be fair to say, injected a new sense of excitement and sense of occasion to the game. Ed Chamberlin and co went under the microscope at a soggy Cheltenham on New Year's Day and will continue to face a stern examination from the racing public over the coming months. But perhaps more interesting is what effect their arrival on the scene has on our existing broadcasters and the offering they give to us on a daily basis.
Both At The Races and Racing UK are staples in the homes of ardent racing fans up and down the land. But the satellite channels are just that – for the ardent punter. And as such, their brief is very different from that of the new gang at ITV. You'll find no talk here of "a mare being a female horse" nor Matt Chapman having to explain that staking £4 at 9/4 will return you £13. Away from the mainstream arena, both ATR and RUK have been providing stellar coverage for punters and doing a damn good job of it.
ATR were first on the scene back in 2000 and, being owned by Sky, have the advantage that their output is included with the Sky Sports package (more on that later). The station is a behemoth when it comes to international coverage with Irish racing particularly well served due to its partner racecourse agreements. But perhaps its biggest strength in this regard is the North American offering, when the channel is able to take centre stage at the likes of the Breeder's Cup and truly play its hand as a niche broadcaster. Likewise, if Australian racing takes your fancy, the channel will serve up all manner of action from Down Under during the small hours and it's this kind of syndication that wins a big thumbs up from punters who crave their racing 24/7.
In front of the camera, ATR boasts a stellar line up of respected industry figures and its array of magazine shows make it hard to beat. The likes of The Sunday Forum and On The Line (the Monday phone-in which has helped project the aforementioned Chapman to prominence) are a huge plus point. In contrast to RUK, which at times can produce something of a 'loop' feel when it comes to its output, ATR tends to be on its game in this regard with a daily Racing News bulletin and content that always feels up-to-the-minute.
In recent years, the channel has perhaps become best known for the likes of Chapman and fresh broadcasting talent like Luke Harvey and Jason Weaver, but go back not that long and the likes of Derek Thompson and Robert Cooper (who still feature to this day) played anchor roles in the output. It is without doubt a balanced product which, although no frills, offers the punter everything from rock solid content to sharp inside angles. Its Irish coverage, in particular, is of the highest calibre in terms of content with the excellent Gary O'Brien worth his weight in gold.
Racing UK
Racing UK was slightly later on to the scene in 2004 and offers a subscription service to fans with coverage from RMG's 34 tracks around Britain. In terms of bang for buck, it can be argued whether or not the channel touches ATR in terms of output, but what it is doing is filling a vital void in the market. Last year, its migration to broadcasting in high definition saw the channel kick things up a notch in terms of the production values and this is an acute advantage it has over rivals ATR. To many, it may not matter, but to this viewer the ability to watch the equine action in glorious HD is certainly something that has taken RUK to another level.
With content, RUK is definitely quality over quantity. While they may lack the strong feature work of a Channel 4 in their prime, the analysis pieces on their excellent Verdict shows are second to none. Fast rising broadcast stars like Oli Bell have shot to prominence on the channel and it was no surprise when he got the call to join the newly formed ITV team. The unsung hero in many ways, though, is Lydia Hislop, who has anchored the channel with great professionalism and rates by far and away their top on course presenter. Studio shows like The Betting Lab, featuring regular pundit Tony Calvin, also rate must-view material on a Friday night and help round off the channel's offering.
Gun to head, who gets the vote?
Charging the guts of £25 per month to punters who are already shelling out for Sky means that Racing UK will always have to go the extra mile to land a blow. However, they do offer some tremendous incentives for members such as £300 worth of free raceday tickets and, from my own perspective, it's a channel I could not do without. I hold their product in the highest of regard. Given the choice between the two, I simply love the production values and depth of analysis offered by RUK.
However, ATR and the access it boasts to a far wider audience, means it will always just win the 'value' race by a nose. The one thing we can all be agreed on, though, is how great it is to have two fantastic broadcasters serving up our racing each and every day of the year. Long may it continue.
The Tower.
We did a Twitter vote the other day and it's fair to say views are so split – we'd love to hear your views. Comment below and join the debate, who do you prefer? Why?
John Chambers on January 4, 2017 at 8:24 am
Simple £25 is seriously ridiculous and will always be an obstacle to joining for me
MH on January 4, 2017 at 9:27 am
I actually have a question here regarding Racing UK.
I recently moved into a new place and subscribed to BT TV with Broadband. They have the Racing UK channel on the TV Guide but when you go to watch it the channel says it' isn't available.
Now I am a Racing UK member so I'd have assumed if I paid for it I could watch on TV?
Weird why they would have it on the guide but, despite being a member, I cannot watch on TV. I even tried on the free to air day and nothing.
Does it just not work with BT? Any help appreciated
Dave Gray on January 4, 2017 at 11:38 am
Absolutely no comparison
ATR doesnt cost extra,covers overseas and Irish racing so its a no brainer.
Add to that the entertainmen value of Matt Chapman and the hilarious Friday show Get in!
The biggest downside to RacingUK is poor race analysis.In particular Graham Cunningham who used to make me switch off channel 4!The channel doesn't have any character although I appreciate Lydia Hislop is excellent
george irvine on January 4, 2017 at 12:30 pm
Can't justify the cost of Racing UK, especially when most of the big meetings are on terestrial tv. Very much enjoy At The Races coverage.
Adam on January 4, 2017 at 12:58 pm
I pay for RUK, but I probably get more rewards for watching ATR properly.
Cooper/Harvey/Mapletoft/Chapman seem to instinctively find the right connections to talk to, and I have backed so many winners that I would never have found in the form book, due to their interviews.
RUK is based purely on the subjective opinion of the team, and has none of this pre race interaction, and will always suffer as a result, when winner finding.
David Hall on January 4, 2017 at 1:10 pm
I think any programme with the buffoon Chapman is a serious turn-off. He is unbelievably irritating &I now turn the sound to mute every time he appears. ITV are still learning, but as long as MC is on the programme, they are up against it for me

redpajama_set_name: RedPajamaCommonCrawl


Builder's Special! This lake front 85 X 650 sq. ft. 1.2684 acre lot is a great property to build your house. Zoned as a prime agriculture. Close to shopping, restaurants, State Rd. 415 going to Sanford or going to Daytona Beach and Orlando Attractions.
Copyright © 2019 Mid Florida MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of Mid Florida MLS. Information provided is for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. RE/MAX Core Collection participates in the MFRMLS Internet Data Exchange (IDX) program, allowing display of other MFRMLS broker's listings on this site. However may not include all listings currently available. Information is deemed reliable but not guaranteed. Information last updated at 2019-04-19 21:55:51.


text:
The Music Is Tupac, The Story Is Now: 'Holler If Ya Hear Me' Musical Review
Written By: Sharde Gillam
As a loyal Tupac Shakur fan, I was overly excited when I heard the news that "Holler If Ya Hear Me"–a hip hop musical inspired by the lyrics and lifestyle of the late rapper– was coming to Broadway.
An obvious change from traditional Broadway musicals which typically consist of revamped movies and classic screen plays, "Holler If Ya Hear Me" is the story of the trials and tribulations of a young Black man (Saul Williams) living in the inner city who was recently released from prison and is now in search of peace within himself. Although the story line isn't a direct representation of Tupac's life, it portrays similar racial and social injustices that he rapped about frequently during his career.
Must Read: Does Cancer Like Rich People More?
#TeamBeautiful got a chance to catch a preview performance of the production and I must say, I was utterly impressed and became more of a fan than ever before. The director, Kenny Leon (who is also credited with directing the latest adaptation of Broadway's "A Raisin in the Sun" with Denzel Washington), and writer, Todd Kreidler, both did an amazing job of taking the lyrics from songs like "Hail Mary," "Dear Mama" and the title track, "Holler If Ya Hear Me" and bringing them to life throughout the story.
Hearing Tupac's words used as the script for the unjust, yet all too familiar urban scenarios portrayed in the musical gave me a much deeper understanding of the messages the late rapper delivered and allowed me to appreciate the poetry in his lyricism.
I will admit, I was hoping the musical would focus more on Tupac's life, his career and the moments leading up to his untimely death, but I was impressed how Leon, Kreidler and Tupac's mother, Afeni (who serves as the musical's producer), were able to take the timeless lyrics and accurately relate them to the present day. "It's a story about unconditional love that uplifts all of his [Tupac's] words," Kenny Leon told the New York Times.
If you're looking for a biography of Pac's life, then you'll have to wait until an official biopic is released because this musical just isn't that. It does, however, serve it's purpose of being a story about friendship, revenge, change, family and hope and brings awareness to the reality of violence and gangs in the inner city — topics that Tupac was most passionate about. "Holler If Ya Hear Me" opens on June 19 in New York City at Broadway's Palace Theatre. Will you check it out?
Pass The Popcorn: Meet The Man Who Will Star In Broadway's Tupac Shakur Musical
BASE LEVEL: If Aaliyah & Tupac Had A Love Child, He Would Be Chris Batson
Check Out This Gallery Of Memorable Tupac Lyrics:
The Music Is Tupac, The Story Is Now: 'Holler If Ya Hear Me' Musical Review was originally published on hellobeautiful.com
broadway	, musical	, tupac	, tupac shakur


text:
Q: MYSQL Count - Return 0 if null Here's my query:
select COUNT(*) as total, COUNT(distinct user) as unique
FROM table
WHERE uristem in ('/example/', '/example/', '/example/', '/example/')
      and time > DATE_SUB(NOW(), INTERVAL 24 HOUR)'
group by uristem;

Should look like this
100 50
25  50
0   0
100 35

But if there is no count, it looks like this (missing)
100 50
40  50
100 35

How can I fill in 0's instead?

A: If you don't have a table with the uri stems in then something ugly like
Select
  u.uristem,
  count(t.uristem),
  count(distinct t.user) as unique
From (
    Select '/example1/' As uristem
    Union All Select '/example2/'
    Union All Select '/example3/'
    Union All Select '/example4/'
  ) u
    Left Outer Join
  table t
    On u.uristem = t.uristem And
    t.time > Date_Sub(Now(), Interval 24 Hour)
 Group By
   u.uristem

Should do it

A: Try this (untested):
select COUNT(t.uristem) as total
, COUNT(distinct t.user) as unique
FROM
    (
        select uristem, user
        from table
        where time > DATE_SUB(NOW(), INTERVAL 24 HOUR)
    ) t
right outer join
(
    select '/example/' x
    union select '/example/'
    union select '/example/'
    union select '/example/'
) y
on t.uristem = y.x
group by y.x;


The times, they are a-changin' friends. Welcome to the American Horror Stream recap for episode two of AHS: Apocalypse, "The Morning After", rightly titled after a good ribbing from Michael Langdon and the necessary steps one must take to avoid any surprises after a night of outrageous and un-planned shenanigans.
Mells Bells breaks down the premiere of American Horror Story: Apocalypse!


Graft-versus-host disease (GvHD) is the most common complication after allogeneic HCT. It is caused by immunocompetent donor T-lymphocytes. After conventional myeloablative conditioning GvHD occurs primarily in early (acute) and late (chronic) forms. This definition has been of some practical value since the natural history and treatment of acute and chronic GvHD are different. However the introduction of reduced-intensity conditioning has meant that this traditional distinction between acute and chronic GvHD has become blurred. Patients receiving donor lymphocyte infusions may develop an "acute" form several months after transplantation and GvHD with features of the "chronic" form can occur as early as 50 days post transplant.
These diagnoses are essentially made on clinical and biopsy criteria.
Chronic GvHD (cGvHD) is less easy to define. Its onset is usually within 1-2 years of the transplant procedure. It primarily affects the skin, eyes, mouth, lungs, GI tract, liver and genitalia. It is commonly associated with thrombocytopenia and eosinophilia.
T cell depleted SCT largely prevents GvHD but any benefit is offset by increased disease relapse or graft failure and such grafts are now rarely used. Efforts to separate GvHD from any graft vs malignancy effect continue.
Acute or chronic GvHD is immunosuppressive and this is made worse by steroids. Infection prophylaxis with close monitoring for infection is of critical importance.


text:
Se også 648 (tal)

Begivenheder

Født
 Kejser Kōbun, Kejser af Japan

Dødsfald

Eksterne henvisninger

48
Artikler om enkelte år

redpajama_set_name: RedPajamaWikipedia


text:
Chinese demographic crisis – a result of Beijing's policies
by tippinsights Editorial Board
President Xi Jinping's unprecedented third term seems to be a time of reckoning for the country. China is struggling to cope after its stringent Zero Covid policy was abruptly lifted following widespread public protests. Now, the national census has put forth alarming data that could likely sound the death knell for Beijing's aggressive plans of world domination.
China's National Bureau of Statistics stated yesterday that the country's population stood at 1.411 billion at the end of 2022. The population count declined by 850,000 people in one year. Just 9.56 million births were recorded in the last year. At 6.77 births per 1,000 people, the data signifies a more than 10% drop from 2021.
The last time the country's population growth rate dropped was six decades ago. A devastating famine caused by Mao Zedong's failed "Great Leap Forward" campaign was the culprit then. The latest dismal trend results from another one of the Chinese Communist Party's grand schemes – the One Child policy.
Beijing rarely does anything by half measures – be that enforcing months-long Zero Covid restrictions or imposing the one-child norm. Through relentless propaganda, forced sterilizations, and abortions, the country reined in its numbers after dictating a one-child per couple rule in 1979. The policy irrevocably changed the face of Chinese society. People resorted to sex selection, hoping for a male child, skewing China's gender ratio.
The slowing population growth is terrible news for a struggling economy. Chinese GDP growth was just 3% in 2022. That's the worst numbers posted by the country since the 1970s, barring the first year of the COVID-19 pandemic. The world's largest economy's galloping growth rate may be a thing of the past.
But, the aging Chinese population will have far-reaching consequences. Rising number of seniors means the "world's factory" will face a labor shortage. This, in turn, will push wages higher, resulting in higher production costs. A shortage of the workforce could also result in lower production.
China, much like other economies, is a consumer-driven one. A shrinking consumer base will drastically impact production and manufacturing capabilities. The vicious cycle would drive up prices of goods deemed for the domestic and export market. Countries that rely on cheap Chinese goods may find the rising prices unpalatable.
Many European countries, when faced with a similar situation, embraced an attractive immigration policy. Beijing is highly unlikely to follow suit. The Chinese Communist Party would loathe loosening its ideological control or facilitating a significant degree of cultural exchange among its citizens. Beijing will likely focus on finding technological answers like enhancing industry automation, developing robotics, and exploring artificial intelligence solutions to combat the problem.
Such initiatives may yield better results than appealing to the citizens to have more children. The One Child policy was rescinded a few years ago, in 2016. Today, the Chinese are 'allowed' to have three children. Beijing's incentives to bolster the birth rate have found few takers so far. The Chinese are unwilling to shake off the one-child family setup. Many know no other kind of family, having been an only child raised by parents from one-child families! The proffered tax breaks and childcare benefits hardly offset the prohibitive cost of childcare, healthcare, and education in the country. The COVID-19 uncertainties and the shrinking economy have led many to believe that the days of glorious growth are behind them. And few are willing to expand their families for the sake of the country.
While negating the birth-death gap will take a while if ever, there is a more pressing problem that cannot be ignored. Soon, China's elderly will depend on the shrinking productive workforce for their seniors' pension, healthcare, and other services. Currently, the country is far from equipped to handle the demand for elder care that will kick in soon. A pension deficit is another looming possibility. With fewer workers contributing to the public pension system, there are fears that the urban state pension fund will run out of cash in less than a decade.
The shrinking workforce, a sizeable state-dependent senior population, and a slowing economy may force President Xi Jinping and his cabinet to focus on domestic policies more. What measures the Chinese Communist Party will devise and impose to reverse the unacceptable trend is the critical question. If the shift in focus will result in a less aggressive China on the world stage remains to be seen.
Related Infographic
TIPP Takes
Geopolitics And Geoeconomics
#1. Top Ukraine, U.S. Military Leaders Meet Over 'Urgent Needs – Al Jazeera
The first face-to-face meeting between the two comes as the international community ramps up military assistance to Ukraine, including tanks and air defense systems.
U.S. Army General Mark Milley, chairman of the Joint Chiefs of Staff, met for a couple of hours with Ukraine's chief military officer, General Valerii Zaluzhnyi, at an undisclosed location in Poland near the border with Ukraine.
Zaluzhnyi said he outlined his forces' "urgent needs" with Milley.
#2. Russia Proposes 'Major Changes' To Boost Capabilities Of Armed Forces – WION
In the wake of setbacks faced in the ongoing war, Russia has decided to make "major changes" to its military structure. Defense Minister Sergei Shoigu informed that the proposed changes to its armed forces will take place from 2023 to 2026.
The reforms proposed include boosting the combat capabilities of its naval, aerospace, and strategic missile forces, apart from major changes to the administrative system.
"Only by strengthening the key structural components of the armed forces is it possible to guarantee the military security of the state and protect new entities and critical facilities of the Russian Federation," Shoigu said.
Kremlin spokesman Dmitry Peskov said the proposed reforms were necessitated due to the "proxy war" conducted by the West in Ukraine.
#3. Ukraine War: Zelensky adviser resigns over Dnipro remarks – BBC
Presidential adviser Oleksiy Arestovych offered his resignation after suggesting a Russian missile that hit a building in Dnipro, killing 44 people, was shot down by Kyiv. Mr. Arestovych apologized and said he had made a "fundamental error."
Hours after Saturday's missile strike hit an apartment building in Dnipro, Mr. Arestovych initially said it appeared that the Russian missile had fallen on the building after Ukrainian air defenses shot it down.
The original remark caused widespread anger in the country and was used by Russian officials to blame Ukraine.
Ukraine's President Volodymyr Zelensky has not yet commented on Mr. Arestovych's decision to resign.
#4. Blinken To Visit China Visit On February 5-6 – AFP
The U.S. Secretary of State Antony Blinken would arrive in Beijing on February 5 and hold talks the following day, going ahead with the visit despite mounting concern about Covid-19 cases in China.
In Beijing, Chinese foreign ministry spokesman Wang Wenbin welcomed the visit and said that he hoped Mr. Blinken would follow the path of the Xi-Biden meeting and help "push China-US relations back on the track of healthy and stable development."
Mr. Blinken will be the first US secretary of state to visit China since October 2018, when his Republican predecessor Mike Pompeo, known for his outspoken criticism of Beijing, made a brief stop following talks with North Korean leader Kim Jong Un in Pyongyang.
#5. Taiwan To Let Women Join Reservist Trainings For First Time – AFP
Taiwan's military announced plans to include women in its reservist training for the first time this year as the East Asian island tries to bolster its forces against threats from China.
Taipei's Defense Ministry said it would allow about 200 discharged female soldiers to enroll in voluntary reservist training from the second quarter of this year as part of efforts to boost the overall backup force.
Self-ruled, democratic Taiwan lives under the constant fear of a Chinese invasion, as Beijing claims Taipei as part of its territory to be taken one day by force if necessary.
China's saber-rattling has intensified in recent years under President Xi Jinping, and Russia's invasion of Ukraine has further deepened worries in Taiwan that Beijing might move similarly.
#6. E.U. Calls For Clean-Energy Rival To Biden's Inflation Reduction Act – UPI
E.U. President Ursula von der Leyen said from the WEF in Davos, the bloc needs a comprehensive net-zero subsidy package to counter the green energy spending in President Biden's Inflation Reduction Act.
Von der Leyen's proposed Net-Zero Industry Act calls for increased investments, a skills-based move to accelerate the pivot away from fossil fuels and fast-tracking some of the permitting processes for clean-energy technology.
Her proposal comes amid criticism that the $369 billion green subsidy package from Washington is creating an uneven playing field. The law gives U.S. consumers incentives to purchase new and second-hand electric cars, heat pumps, and electric connections to cooking, among other subsidies. Some of those incentives require a U.S.-made manufacturing base.
EU members said they feared the tax breaks created by the Inflation Reduction Act could draw business away from Europe and potentially lead to a trade war.
#7. Dutch Senate Expands Constitutional Ban On Discrimination – A.P.
The Dutch Senate approved an amendment to the country's constitution, expanding its first article to specifically ban discrimination based on sexual orientation or disability.
The constitution's updated Article 1 mandates that all people in the country must be treated equally and that "discrimination based on religion, belief, political opinion, race, gender, disability, sexual orientation or on any other basis is not allowed."
Astrid Oosenbrug, chair of the country's COC gay rights organization, called the vote "a historic victory for the rainbow community and a crown on years of work" by the group.
#8. Private Jet Emissions To Spike During Davos Meeting – Tippinsights
Environmentalists accuse world leaders and business chiefs of hypocrisy as they fly to the World Economic Forum (WEF) on private jets to discuss, among other things, climate change.
World leaders and business chiefs are again jetting into Davos on private planes for WEF 2023, causing another spike in emissions and leading to calls of hypocrisy as attendees discuss climate and inequality behind closed doors.
Dutch environmental consultancy firm CE Delft has calculated that during WEF 2022, CO2 emissions from private jets were four times greater than an average week – emitting the CO2 equivalent of 350,000 cars over the period.
#9. Iran's 'Death Committee' President Unyielding In Defense Of Clerical Rule – Reuters
As a young prosecutor in Tehran, Ebrahim Raisi sat on a "death committee" overseeing the execution of hundreds of political prisoners in the Iranian capital, rights groups say.
Now president three decades later and seen by many as Iran's potential next Supreme Leader, Raisi is presiding over an uncompromising response to domestic and international challenges which have seen Iranian courts pass dozens of death sentences.
Four people have been hanged after being convicted on charges related to popular unrest that erupted in September.
The executions triggered condemnation from Europe and the US, but Raisi has insisted that "identification, trial and punishment" of all those who authorities believe were involved in violence will continue.
#10. Saudi Arabia Open To Trading In Currencies Besides The U.S. Dollar – Middle East Eye
Saudi Arabia will consider trading in currencies other than the U.S. dollar in one of the clearest signs yet that the oil-rich kingdom is open to diversifying away from the greenback.
"There are no issues with discussing how we settle our trade arrangements, whether it is in the US dollar, whether it is the euro, whether it is the Saudi riyal," the kingdom's finance minister, Mohammed al-Jadaan, said in an interview in Davos, Switzerland.
Jadaan's comments likely spark speculation about Riyadh's willingness to conduct oil sales in the Chinese Yuan.
During a visit to the Gulf in December, Chinese President Xi Jinping told Arab leaders that Beijing would push to buy oil and gas in yuan as it looks to position its currency for use in international trade.
Like other Gulf states, Saudi Arabia has pegged its currency to the dollar for decades.
#11. Pakistan PM Sharif Makes Conditional Talks Offer To Arch-Rival India – Reuters
Pakistan PM Shehbaz Sharif has made a conditional offer to his Indian counterpart to open talks on all outstanding issues between them, including disputed Kashmir.
He believes could be facilitated by the United Arab Emirates (UAE).
However, a statement issued by Sharif's office after the interview aired added that such talks would only be possible if India restored the autonomous status in the part of Kashmir it rules that was revoked in 2019.
"Without India's revocation of this step, negotiations are impossible," it said.
New Delhi has ignored such calls from Pakistan on Kashmir's status.
We welcome readers' letters via email. If your letter is published, you get to ask a question in the TIPP Poll for free.
Please email [email protected]
Republished with permission from TIPP Insights
Trump takes to Truth Social to launch attack on 'RINO globalist' DeSantis
Megyn Kelly sounds off on firing of arrogant ABC lovebirds: 'Stop projecting 'I don't give a s**t''
Tarlov finally fed up with migrants complaining about relocation: 'You're here by the grace of our generosity'
FBI searches Biden's vacation home with consent of president's attorneys in another scandal twist
Police in California under fire for deadly shooting of a double amputee armed with 12-in butcher knife


If you are looking for Krakow tips before you visit, then look no further. I've got you covered!
This post will include some advice for you.
what to do before entering a building?
how to make a Polish waiter (or waitress) smile?
what kind of food you have to try when in Poland?
…and a few more practical pieces of information.
I've teamed up with both tourists who came to Krakow this year and locals to create a comprehensive list for you – our future guest.
1. Polish people are lovely, just talk to them!
"Poles are actually much nicer than they seem. It's not a cultural norm over there to smile at strangers in buses or supermarkets. It made me feel really uneasy at first and I thought that the locals are cold and unapproachable, when in reality it's the opposite.
Just start a conversation with someone and you'll see how nice they are. Don't be afraid of them!"
This is so true! A lot of tourists are used to smiling at everyone around them and, as a result, sometimes they find us quite rude.
We have a reputation of being very hospitable, so don't feel bad when someone on the street does not reciprocate your smile. It's normal to keep a straight, neutral face here – we don't mean anything by it, don't take this the wrong way.
"Working as a waitress for 3,5 years has taught me a lot. One of the things you may find useful is that Polish people really do appreciate when you learn a word or two in our twisted language. Simple dziękuję instead of thank you will brighten up our shift and put a huge smile on our face, so it's worth giving it a shot"
Polish is known for being an extremely difficult language and I can vouch that we really have a soft spot for foreigners trying to speak it.
It doesn't have to be perfect, it doesn't even have to be good – it's the thought that counts!
I am convinced that you will be treated well either way, but if you want to score a few extra points with a receptionist or a waiter, dzień dobry (good morning) or do widzenia (goodbye) is the way to go!
You can also try pronouncing Kraków the way Poles do.
"During my recent trip to Krakow I found out that in Poland it is rude to keep your hat on whenever you enter a building – be that a church, a restaurant or even a friend's apartment. I thought it was quite bizarre at first, but I quickly got used to the fact that it is expected of me"
In Poland it's a cultural norm to take your hat off when indoors.
If you don't want to get funny looks or comments – especially from the elderly – it's a useful thing to remember.
"If you're planning on using public transport, Jakdojade app is going to become your best friend. Practically everyone uses it in any big city in Poland, it's an absolute must and a great time saver."
Yup, Jakdojade is indeed very popular in Poland. It can come in handy while exploring the city, so we recommend downloading it from App Store or Google Play (it's free).
And while we're on the subject of public transport – I have noticed that a lot of tourists struggle to remember that they have to validate their tickets as soon as they enter the vehicle. Keep that in mind when using trams or buses in Krakow if you want to get around the city without any hassle.
"Our trip to Krakow was terrific! Thanks for reaching out to us, we are happy to help other travelers!
If we were to recommend one tip, it would probably booking your tours in advance. The most popular attractions can get very busy in high season, so pre-booking key activities ahead of time will surely save you quite the headache, as it did for us (yay!)."
Auschwitz-Birkenau and Wieliczka Salt Mine are both extremely popular among tourists and almost everyone who comes to Lesser Poland has them on their agenda – hence the constant crowds there.
It really is a smart move to book your tours before you come to Poland, as looking for a seat last-minute (without the certainty that you will be able to find something) can ruin even the best of holidays, and I'm sure you don't want to miss out.
"I highly recommend checking out the less crowded areas that not many tourists visit, such as Podgorze or Nowa Huta. I always feel like they are underrated compared to Stare Miasto or Kazimierz. If you have a spare few hours, they are worth visiting as well!"
Krakow is full of charming streets, interesting stories, impressive architecture and beautiful greenery, so if you want to step off the beaten track and explore something that most tourists don't get to experience – check out Podgorze and Nowa Huta.
"I was visiting Krakow with my extended family (8 people), so when we wanted to change the currency, it was quite a big sum. We asked the receptionist in our hotel for the nearest exchange office, but she gave us two addresses: of the nearest one and of the cheapest one (which was not that far away, either).
When we checked online, it turned out that we could have lost a significant amount of money by going to the first place. Wherever you go, it's always good to compare rates between several exchange offices."
Another awesome and universal tip!
Those little differences add up and you can basically throw money down the drain by not preparing.
And you wouldn't want that, right?
It's always worth checking! You can easily find websites that compare rates in exchange offices by simply googling them.
Two minutes of research versus saving some money for souvenirs (or, let's be honest… food).
"Most of the museums offer free admission on one chosen day of the week. I am a student (constantly on a budget) and thanks to that free day policy I was able to visit a lot of Krakow's museums without breaking the bank! All it takes is a little planning."
It's a great tip! If you will be in Krakow for more than just a weekend, you can read a little about Krakow's museums, find the ones that interest you the most, and then check their websites for more information.
Bear in mind that even on days that are admission free, some of the museums will still require of you to register for a free ticket so it's very important to double-check policies of the particular museums you want to visit.
"Polish bread is just next level. And I didn't even know that before! Why isn't that knowledge readily available to everyone? When my couchsurfing host got me some food for breakfast, I didn't know what was coming!
You HAVE to try Polish bread. I am not kidding. It's one of the things I miss the most about Poland. And one of the reasons I will come back, for sure."
Interestingly enough, I've heard that a lot from foreigners and whenever I mention it to Poles, they are quite surprised.
We don't know how good we have it, eh?
I recommend you to take a morning stroll to one of Krakow's numerous bakeries and see for yourself if it lives up to Lauren's hype.
And if you will love the bread and will want to indulge more in the amazing food Krakow offers, check out our guide to Krakow's restaurants.
"When I was visiting my friend abroad, I had a very unpleasant experience the very first day I arrived.
When I got in the cab, the taxi driver – who clearly saw that I was a tourist – had taken me to my destination via route that was four times longer than the actual distance.
Of course I am sure that the majority of taxi drivers are very friendly and honest, but since that fiasco my number one tip to any tourist in any city is to check the map for a rough estimate of how many kilometres there are from point A to point B and reconfirm that with the driver at the beginning of your journey – he will know that you've done your research and you're not an easy target to manipulate!"
I am sorry to hear about Marta's experience.
The one good thing that came out of this situation is that clever tip that we can all use in the future wherever we go!
While checking the map you will also be able to see what is in the proximity of your accommodation, which is an added bonus.
"Krakow has a great system of city bikes, so if you enjoy cycling and can't bring your bike with you (for obvious reasons), you still have the opportunity to explore the city on two wheels for a very reasonable price.
I was pleasantly surprised by that and I recommend it to all of my friends who are planning their trips to Krakow."
City bikes in Krakow are really popular and you can find plenty of Wavelo stations all around the city.
It's an efficient and user-friendly system that will give you the freedom to explore the city at your own pace. Definitely make sure to check it out if you're a fan of cycling.
"Don't drink in public! It's illegal in Poland to drink outside and you can get fined for that. Trust me… Been there, done that."
Well, that's pretty self-explanatory, nonetheless very important to remember.
You can drink if a pub has an enclosed beer garden-esqe area outside, but sipping on a beer in a public park is not allowed and you can get in trouble for it if you're caught by a policeman.
I hope that you found the information we have prepared for you useful.
Once again – a huge thank you to all who contributed!
And hey – if you have some travel tips that will help fellow travelers with planning their trip to Krakow, share them below in the comments!
Great tips, thank you. You may be able to help me. I am planning a motorcycle tour from the UK across to Krakow and I'm interested to know a few things before hand. For example how are motorcyclists received in general? (over here some places will not serve us for example). What is parking like in the city and are there secure parking places etc? I plan on parking the bike up and using public transport whilst there so would like to know my bike is safe. Thanks again.
Thank you Ania, I'll have a look on Reddit.
Thank you so much for all of this information ... I'll be coming to Krakow in a little over six weeks, and trying to do as much research as possible, and this was an enormous help. So looking forward to my visit!
Krakow Nightlife What is it like? Is it Good? FIND OUT HERE!


text:
Audi's electric R4 at the Detroit motor show 2010
Mon, 11 Jan 2010 00:00:00 -0800
This is Audi's latest electric E-tron sports car, unveiled at today's Detroit motor show. Or to give the concept its official name, this is the Audi E-tron Detroit Showcar. Catchy.
More importantly, think of the concept as a glimpse of what the future holds for Audi's sports car range...
Think of it as Audi's vision of what a sports car below the R8 might be like. We know Ingolstadt hopes to have its own version of VW's Bluesport roadster – and insiders confirm this is indeed our first glimpse of the much-mooted R4.
The two-seat E-tron is just 3.93m long (the Bluesport measures 3999mm) so it's shorter – as well as lower and narrower – than a TT. Unlike the four-motor, four-wheel drive E-tron unveiled at the 2009 Frankfurt show, this E-tron has just two motors and rear-wheel drive. Still, the two electric units (mounted on the rear axle) combine to produce 1955lb ft – down from big brother's 3319lb ft – and 201bhp so the E-tron is propelled to 62mph in just 5.9 seconds. Together with the smaller shape, aluminium spaceframe and carbonfibre-reinforced plastic body, the E-tron weighs just 1350kg, versus 1600kg for the original E-tron.
The lithium-ion batteries that power the E-tron are mid-mounted and tip the scales at 399kg, giving the show car a 40:60 front-to-rear weight distribution. With the car's top speed limited to 124mph, their 45kWh capacity gives a 155-mile range.
Production versions – which 'will look 90% like this', say well placed insiders – will of course sport a range of petrol and diesel engines as well. But Audi is serious about producing electric versions too.
Yes. This baby E-tron also has the original's torque vectoring system that sends twist to the required wheel, LED headlights that react to weather and traffic conditions, plus a minimalist interior that takes advantage of the lack of a transmission tunnel to liberate extra space.
The E-tron also has a Smartphone that integrates with the car and allows you to programme the sat-nav from the comfort of your own home, and side intakes that open or close depending on the car's cooling needs. They're seriously cool, and headed for production.
By Ben Pulman and Tim Pollard


The teachers of our Middle School (Years 5 & 6) integrate Middle Schooling philosophy and perspectives into their planning for student learning. Students, in the middle years of schooling, share an array of rapidly changing, diverse and often challenging qualities. Other than infancy, research identifies the ages of approximately 10 to 14 years as a time when children develop and grow more rapidly than during any other developmental stage.
They have access to extensive and sophisticated informational sources outside of the school and family.
They are the target of mass media and advertising.
They are participants in a society which has a pervasive consumer culture.
They will participate in a world where the certainty of learning one set of job-related skills for a lifetime of employment is not sufficient.
Middle Schooling refers to practices that make education responsive and appropriate to the needs of young adolescents engaging them proactively in their learning through appropriate curriculum, pedagogy and school organisation.
The following aspects of learning are addressed in the Middle School program at St Joseph's.
Curriculum: The teachers at St Joseph's plan cooperatively to develop units of work to provide learning experiences that connect with and are relevant to young adolescent learners and learning processes that explicitly develop reading, writing, critical thinking, decision-making and creativity.
Pedagogy: Teachers work as a team to know and understand their students well and use powerful teaching strategies to challenge and extend students in a supportive environment.
School Organisation: Middle School (MS) is a flexible grouping of students from Years 5 & 6.


Unlike other companies, Advance Consulting does not simply follow the "traditional wisdom" in how we do things. We want more for you than that. Instead, we follow our "experiential wisdom". That means that we have learned what works and what doesn't work based on our direct experience helping people and companies across industries improve business performance. We apply that direct experience in our client engagements. Do it once, do it right, and enjoy the benefits.
The truth about how things work, and how things don't work, is sometimes unexpected, even ironic. Such is the case with customer focus and the ability to serve others. The "traditional wisdom" tells us that if you want to establish or improve customer focus, start with those in your business who directly communicate with external clients. That seems to make perfect sense. However, based on our experience, it doesn't work well and the change is not sustainable.
To create sustainable change, you must develop customer focus from the inside out. Start with your organization, operations and skill sets. Otherwise, your people will be too distracted and encumbered by internal activities and conflict to adequately focus on external customers. In other words, we must get our houses in order before we can increase customer focus and achieve business excellence. So, you can do things the traditional way five times and never get it right, or you can do it right the first time. We show you how, and partner with you and your team to get it done.
The rest is about our toolkit and people. Advance Consulting employs a variety of leading-edge consulting, training, and coaching elements to create experienced-based, customer focused business solutions for you and your business. And our highly talented and experienced consultants, coaches, and facilitators bring it all together to deliver the custom business solutions with optimum results.


text:
Hull & East Yorkshire News
Christmas coronavirus warning for Hull before families meet
Rules for five-day festive period will not be changed
One of Hull's senior public health officials has spoken of his concerns over some Covid restrictions being lifted over Christmas.
Debate over the wisdom of changing some of the rules during a five-day period starting on December 23 has intensified with infection rates still high and rising sharply in some areas.
Under the relaxed rules, up to three households will be allowed to meet indoors.
Hull's deputy public health director Tim Fielding said: "There is no way you can increase the amount of contact that you have between people without it increasing risk.
To get the Hull Live headlines every day, simply pop your email address into the sign-up box just beneath the picture at the top of this article.
(Image: Shared Content Unit)
"So any loosening of the restrictions, any increase in bringing people together and increased mixing between families and people, all will bring increased risk with it.
"It will be about people managing that risk appropriately and taking measures to keep that risk as low as possible but it will increase and we are all anticipating that will have a knock-on impact on infection rates.
"The extent of that knock-on effect is the huge unknown, We are waiting to see what that will be but we will not see that until we get towards the New Year."
Axed P&O Ferries Hull to Zeebrugge route sparks outcry for more support
Tattoo torment for painter after 'wolf looks like Alsatian puppy'
Under the current Tier 3 rules covering Hull and East Riding, households are not allowed to mix indoors or outdoors.
Leaders from the four nations met yesterday to discuss issuing stronger warnings to the public about mixing over the festive period.
Today cabinet minister Robert Jenrick urged the public to "use their own judgement" on who to see over the five days but said the rules covering Christmas would remain unchanged.
He added: "You can come together as three families and bubble for up to five days but I suspect many, many people across the country will choose to do less than that, to protect themselves, their loved ones, and broader society."
Change in tiers may not be known until Thursday
Minister says Christmas rules will be down to 'personal judgement'
In a joint editorial, the British Medical Journal and Health Service Journal stressed that demand on the NHS was increasing, adding that a new strain of coronavirus - identified in both England and Wales - "has introduced further potential jeopardy".
Graham Medley, a member of the Scientific Advisory Group for Emergencies, said the "major driver" for how much the disease spreads over the five-day Christmas period was the infection prevalence - and that the current prevalence had started to rise "really quite rapidly in some places".
"When the rules were made about Christmas, we didn't know what that prevalence was going to be," he added.
A public information campaign is expected to be launched in the days running up to Christmas.
Hull City Council


text:
Q: Pip says old version is installed after installing new version I uninstalled pip and reinstalled it from get-pip.py, yet it reports the wrong version.
C:\>python get-pip.py
Collecting pip
  Cache entry deserialization failed, entry ignored
  Using cached pip-8.1.1-py2.py3-none-any.whl
Installing collected packages: pip
Successfully installed pip-8.1.1

C:\>pause
Press any key to continue . . .
PS C:\> pip --version
pip 6.0.3 from c:\python33\lib (python 3.3)

Has the correct version been installed? Every time I use pip it still tells me to upgrade.

A: Deleting c:\python33\lib\pip solved the issue.


Using our 27 years of experience in solving individual experiences of Furniture Poverty, in June 2015 we launched End Furniture Poverty™ to campaign nationally and across all types of housing tenure to shine a light on the reality of living in Furniture Poverty and to promote the take up of practical solutions.
Furniture Poverty is a hidden issue that affects millions of low-income households in the UK. Furniture Poverty has many faces. It can mean families are living without adequate furniture and appliances or they have gone into unmanageable levels of debt to buy the basic items they need. For some, the inability to buy basic furniture keeps them trapped in temporary accommodation. Many households live with the stress of worrying about Furniture Poverty, fearing what would happen when an essential item like their fridge or cooker breaks and there is no money to replace it.
End Furniture Poverty will work across sectors to raise awareness of these issues and to become a source of practical help for individuals in need and for professionals.
Our first campaign is Furnishing Homes, Furnishing Lives which raises awareness of the role that furnished tenancies in the social housing sector can play in alleviating Furniture Poverty.


text:
Lasting legacy not trophy-hunting drives Djokovic
Reem ABULLEIL
December 21, 2019, 5:30 PM UTC
Serbia's Novak Djokovic has called for the Davis Cup and ATP Cup to merge (AFP Photo/-)
Abu Dhabi (AFP) - Novak Djokovic says the main source of his motivation at this stage of his career is securing a lasting legacy rather than simply trying to win tennis matches and trophies.
For nearly two years, from mid-2016 until mid-2018, the 32-year-old Serb had admittedly struggled with motivation after pulling off the historic feat of winning four Grand Slams in a row –- a first in men's tennis since 1969.
Djokovic recaptured his spark and has since added a quartet of majors to his overall tally, which now stands at 16.
While the world number two remains in a tight battle with Rafael Nadal and Roger Federer in the race for most Grand Slam titles won, Djokovic believes what currently drives him in the sport is something deeper than that.
"You need to constantly give yourself fuel from the source, whatever the source is," Djokovic said at the Mubadala World Tennis Championship exhibition event in Abu Dhabi, where he secured third place with victory over Karen Khachanov on Saturday.
"I think it's always about finding that purpose, and the reason, the meaning of actually playing. For me, especially in the last couple of years, it's not only about winning a tennis match or a trophy.
"It had to be something greater than my own achievements. Something that would be related to legacy, something that would really be inspiring the lives of others, particularly kids."
Federer holds the men's all-time record of most majors won, with 20, and Nadal is breathing down his neck with a total of 19.
Djokovic is younger than both of them though, and has a shot at closing the gap on his two rivals.
"That's a goal," said Djokovic, when asked if he is fuelled by breaking records.
"I'm motivated by breaking my own records and moving my own boundaries and that"s something that motivates me to compete.
"I do love to play tennis so I do like to be on the practice court. But competitive tennis is different. In order to compete to be a professional tennis player and to compete at the highest level, you really need goals, daily goals, monthly goals, yearly goals.
"So I do have them, as everyone else. Of course I'm aware of the privilege that I have to fight for history and to be able to possibly achieve even greater things and that's something that drives me of course, alongside other things."
Djokovic will begin his 2020 season by representing Serbia in the ATP Cup in Australia.
He remains midway through his pre-season preparations, and leaves Abu Dhabi with one loss, to Stefanos Tsitsipas, and one win over Khachanov.
"I got what I came here for, two good matches," he said on Saturday.
Meanwhile, Khachanov is hoping to find consistency in the new season following a see-saw 2019.
The Russian former top-10 player has added Swedish coach Fredrik Rosengren to his team, to work alongside Vedran Martic.
The 23-year-old is also a new dad, having welcomed his son David with his wife, Veronika, three months ago.
"Fatherhood is treating me very well. I think you become more mature because you have responsibility not only for yourself, but for the whole family, so that's one of the biggest steps," said the 17th-ranked player.


Let's face it: modern life needs smoothies.
They're a great way to make sure you're getting everything you need for your body all in one delicious sip. While smoothies can be the saving grace you need for the quick pre-work breakfast or post-workout refuel, you may not be helping yourself out as much as you think if you're not putting the right stuff in there.
Our smoothie boosters are here to help! Using our organic Red Beet Crystals (US/CA), our Green Blend (US) / Beyond Greens (CA), and our Elderberry Crystals (US/CA), you'll be adding a nutritional boost to your smoothies. With minerals, fermented grasses, antioxidants, and immune support, our arsenal of smoothie boosters covers all your bases.
You can easily add these all-organic, non-GMO, dehydrated and crystal blends to just about any smoothie. Add our Red Beet Crystals or our Green Blend to this delicious Green SOS and this Strawberry Beet Smoothie to give your body that extra something it's been craving.
The one we've been sipping on lately? In preparation for upcoming holiday indulgence, we've been going green with this Green Lean Protein Machine. This smoothie helps you get your greens and gives you energy from a kick of matcha and lean protein. It's perfect for your morning meal or as something to replenish yourself after hitting the gym.
For some added protein try 1 tbsp of your favorite whey or vegan protein powder.


text:
Q: ACF5: Use field names rather than field keys for HTML element IDs I've taken over a plugin which relies heavily on Advanced Custom Fields. For further development I updated ACF from version 4 to the latest version (5.8.x).
The plugin includes styles and scripts relying on HTML element (e.g. input) IDs such as acf-field-header_caption, where header_caption is the field name. This works well with ACF 4, but in version 5, the much less coder-friendly field key (e.g. 5ac098bae96e4) is used for the IDs and classes, eg: acf-field-5ac098bae96e4. (The custom fields are added to a post_type and edited on that post_type in the backend.)
Example:
Input field in ACF v4 (what I need):
<input type="text" id="acf-field-header_caption" class="text" name="fields[field_5ac098bae96e4]" value="" placeholder="">

Same field in ACF v5 (what I don't want):
<input type="text" id="acf-field-5ac098bae96e4" class="text" name="fields[field_5ac098bae96e4]" value="" placeholder="">

Is there a way to revert back to HTML IDs in which the field names rather than the field keys are used?

A: John Huebner answered this question on the ACF support forum (thanks!).
There is no way to revert to the old class and ID format. This means, you have to update custom scripts and CSS when updating to ACF 5.
If one prefers to use the field name rather than the field key for the likes of jQuery or CSS selectors, one could use the data-name attribute in the wrapper div. Example for a selector referencing header_caption input field from above:
[data-name="header_caption"] input

(This works well for text fields, radio fields and their likes have multiple inputs within the wrapper.)
I quote the original answer:

No, there isn't a way to revert the field ID values. The only place you will find the field name is in the wrapper div data-name="field_name_here".
In addition to the change in IDs and classes, even changing them would likely not help with the JS. If the JS is dependent on ACFs JS then it probably will not work anyway. The JS in ACF5 is completely different than ACF4 and any custom JS that interacts with it would need to be completely rebuilt.


text:
Indy Transponder 08-MAR-2012 0200z
World-flight Pipistrel suffers structural damage from AOPA Pilot Blog: Reporting Points by Al Marsh | Matevž Lenarcic of Slovenia has landed safely in Australia at Ayers Rock Connellan Airport in central Australia after suffering in-flight structural damage on his quest to fly around the world in a Pipistrel, but detour for ecological surveys along the way. He has already covered a distance equal to that around the globe, with half his trip still to fly. Serious vibrations alerted him to problems ...
RIP Milblogger Carroll LeFon (aka Lex) of Neptunus Lex from Milblogging.com | I received some sad news earlier today that retired TOPGUN pilot US Navy Capt. Carroll LeFon, better known as Lex of the military blog Neptunus Lex, was killed Tuesday when a jet he was flying crashed at Naval Air Station Fallon in Nevada...
Blue Angels Bring Winter Thrill To California City - NPR | For 45 years, the city has been the winter training home of the Navy's flight demonstration squadron. The "Blues," as the locals call them, have been an enduring source of pride for the desert community. The "hay bales" is a dusty crop field a stone's...
2012 GA Award Winners to Be Honored at AirVenture from EAA Airventure | The General Aviation Awards program announced this week its 2012 national winners who will receive their awards this summer at EAA AirVenture Oshkosh 2012. They include Marvin Hornbostel, of Junction City, Kansas,...
EAA 2012 Hops & Props from eaavideo.org | Highlights from the 2012 Hops and Props celebration.
Change in air for area show - Parkersburg News and Sentinel | WILLIAMSTOWN - The 2012 Air Show is likely to be different from previous events as the new committee is looking to make positive changes. Among changes is a new organizer. "Donna (Rusche) stepped up to the table to lead the air show this year," said Terry Moore, manager of the Mid-Ohio Valley Regional Airport. "She has some new and fresh ideas."...
Letter gets girl US spyplane treat - ic CheshireOnline | Luckily the Monkleigh Primary School pupil keeps a close eye on the Royal International Air Tattoo (RIAT) website and spotted the plea from organisers trying to track her down. After her mother, Lorna Carter, got in touch it was arranged by the crew of...
AIRSHOW NEWS: Wings & Wheels to Showcase Aerodromes Iconic History at 2012 Show from Flightline UK | The historic setting for one of the UK's most popular family days out, 'Wings & Wheels', is celebrating its 70th anniversary in 2012. As the airshow returns to Dunsfold Aerodrome (home to BBC's Top Gear) on Sunday 26th & Monday 27th August 2012, the event will showcase some of the airfield's iconic aviation and motoring history....
Cactus Fly-In 2012 from PHXspotters by Felipe Garcia | Last Friday and Saturday the Cactus Fly-In was held in Casa Grande (CGZ). One of two fly-ins in the area that that, the other being the monthlt Coolidge Fly-In, it was packed with fun and lots of airplanes. I was able to squeeze those two events and a visit to Sky Harbor all the same day (as well as the drive to and from Prescott), mainly to see how much I could handle and also for the variety....
Women are Key to Aviation's Future - Scott Spangler | Did you know that March is Women's History Month, and that Women of Aviation Worldwide Week started March 5? I didn't, until a friend shared an e-mail from Penny Hamilton, a pilot with a Ph.D. who's invested a lot of time studying just...
A Week To Celebrate Aviation's Women from AVwebFlash Current Issue | Over the years, various events to recognize women's contributions to aviation have been held in March to coincide with Women's History Month, and this year, many events are scheduled for this week, in honor of International Women's Day on Thursday. A group based in Canada has...
Happy Women Of Aviation Worldwide Week! from You Fly, Girl by Cathy Gale | From Women in Aviation Week: Happy Women Of Aviation Worldwide Week! | "I was annoyed from the start by the attitude of doubt by the spectators that I would never really make the flight. This attitude made me more determined than ever to succeed," said Harriet Quimby before taking off for France....
Warhawk Air Museum A Trip In time from Pacific Flyer | Visiting the 40,000 sq. ft. Warhawk Air Museum at the Nampa, Ida. Municipal Airport is akin to taking a trip back into time. The 20,000 sq. ft. WW II wing allows visitors to experience the 1940's through thousands of personal collections and memorabilia, airplanes, trucks, engines and equipment that was used during the war years. It was a war that had a beginning, a known enemy, and an ending....
Mayor, military officers detail next month's War of 1812 bicentennial events ... - NOLA.com | Tall ships and modern warships from an array of nations will dock along the Mississippi River in downtown New Orleans, and the Navy's Blue Angels flight demonstration team will perform over Lake Pontchartrain. US NavyThe USS Wasp,...
New Smithsonian Exhibit on Hindenburg and Titanic from Airships: A Hindenburg and Zeppelin History Site | A new exhibit, Fire & Ice: Hindenburg and Titanic, opens March 22, 2012 at the Smithsonian National Postal Museum in Washington D.C. 2012 is the 100th anniversary of the Titanic tragedy, and the 75th anniversary of the Hindenburg disaster. Fire & Ice: Hindenburg and Titanic at the Smithsonian National Postal Museum | The Hindenburg and Titanic were the world's largest mobile post offices in their day, and zeppelin mail played a...
Renovated airport terminal dedicated and named after aviation pioneers in Augusta - The Republic | A newly renovated airport terminal in Augusta is being dedicated and named after a pioneering aviation family in the east Georgia city. The Augusta Chronicle reports (http://bit.ly/zH4h4U) the terminal at Daniel Field is being renamed Boshears Terminal...
"Slip Slidin' Away" UCAP #275 from Uncontrolled Airspace: General Aviation Podcast
C-130 Hercules: World's Most Versatile Warbird? | Warbird Wednesday from Leaving Terra Firma | Much like my obsession with the U2, which has outlived another 'replacement,' I am always amazed by the C-130. Obviously, considering its long life of service, so is the military. I'm hard pressed to find any area where the C-130 doesn't do something amazing. I guess maybe if you compared it to a Cessna 150 in a fuel economy test it might not come out on top. That said, I challenge you to put 92 people or 2 armored personnel carriers in a Cessna 150 and make it off the ground...
43-37716 – B-17G "5 Grand" - warbird-central.com | B-17G 43-37716 "5 Grand" flew its combat tour with the 338th Bomb Sq, 96th BG. Much publicity surrounded the aircraft when it departed the Boeing factory, the crew being handpicked from among members of the 486th BG who were native to the Seattle area. 2LT Edward C. Unger was her first pilot, but the aircraft was taken from them upon arrival in England and assigned to the 96th....
Stahr's Flying Works of Art (Part 2):A Tedious Process Only an Artist Could Love from Av8rdan's World of Flying | In part one of this article series, I introduced you to John Stahr, one of this country's most prolific aviation airbrush artists. He's also a member of my EAA Chapter in Eugene, Oregon, and a hangar row mate at KEUG....
Unmanned aircraft conference April 17-18 at Sinclair College - Dayton Daily News | DAYTON — Registration is open to businesses, military personnel and others interested in attending an April 17-18 conference on unmanned aerial systems, which include the aircraft and their sensor systems. Sinclair Community College will host the Ohio...
RC club a draw for aviation lovers - Daily News - Galveston County | "Aviation is in the blood," Ammons, 52, said. "Since I was 10 years old, I've been thrilled to get wind under the wings. It's a passion more than a hobby." Ammons, an avionics technician manager for what was until Saturday known as Continental Airlines...
NASA Tweetups Are Evolving. It's Time To Be More Social from NASA Breaking News | NASA is expanding its successful program of Tweetups to include more social media platforms, broadening the agency's use of social media to engage audiences about the agency's mission of exploration and discovery.
Labels: #AirShow, #OSH12, #UAV, #Warbirds, aviation bloggers, Aviation Heritage, Aviation Museums, C-130, Hindenburg, NASA, Pipistrel, UCAP, USN Blue Angels, Women of Aviation
Smithsonian's National Postal Museum Opens New "F...
LiveAirShowTV Profiles Jason Newburg
Urbana, Ohio, Airport the Target for Largest Gathe...
Airspeed Update: Shooting Movies in the Sky - Webi...
Annual Louisiana Wing Conference and Awards Banque...
Multi-City Film Tour Set For Doolittle Raiders' 70...
RAF AIRPOWER ON SHOW AT AIR TATTOO
Unique Mosquito NF.36 Night-Fighter restoration co...
Sea Harrier to debut at Vectren Dayton Air Show
PLANES, TRAINS & AUTOMOBILES IN PLANT CITY IN MARC...
Vintage airplane competition kicks-off with call f...
Heli-Expo 2012 and Huey Follow up
ENJOY STEVE MILLER BAND'S LEGENDARY ROCK JULY 23 A...
RARE OSPREY TO SWOOP AT AIR TATTOO
BTTC Honors Women During Women's History Month
Records and Racing
Advanced Warbird Training
Wings of Dreams 2012 Airfest -- Reminder


We have a team of talented professionals that can help you start or upgrade your website. We have the ability to create virtually anything you want in a unique and high-quality custom website for you or your business. Call us today for a free consult, or email us here.
Our hosting platform is state of the art and completely ours, we do not resell another companies services. We offer MySQL database access, FTP access, plenty of disk space (and full nightly backups), email accounts and 24/7 network monitoring. Click here for more details.
We'd like to hear what you have to say, good or bad - Please take a minute or two to tell us how we're doing!


text:
AddCSLuaFile()
DEFINE_BASECLASS( "base_wire_entity" )
ENT.PrintName       = "Wire Locator Beacon"
ENT.WireDebugName = "Locator"

if CLIENT then return end -- No more client

function ENT:Initialize()
	self:PhysicsInit( SOLID_VPHYSICS )
	self:SetMoveType( MOVETYPE_VPHYSICS )
	self:SetSolid( SOLID_VPHYSICS )
end

function ENT:GetBeaconPos(sensor)
	return self:GetPos()
end
function ENT:GetBeaconVelocity(sensor)
	return self:GetVelocity()
end

duplicator.RegisterEntityClass("gmod_wire_locator", WireLib.MakeWireEnt, "Data")

redpajama_set_name: RedPajamaGithub


text:
Coastal Scene with Sailing Vessels
Jan van de Cappelle was a self-taught artist who combined his artistic activities with that of a prosperous cloth dying business inherited from his father. In addition, he was an important collector of Dutch painting, as is evident from the inventory of his collection drawn up one year after his death in 1680 and which records around 200 paintings and a large number of drawings. Among the paintings and drawings listed are works by landscape artists such as Hendrick Avercamp, Esaias van de Velde the Elder, Rembrandt (represented by a large number of sketches), and the marine painter Simon de Vlieger who was particularly well represented in Cappelle's collection. Among the paintings were three by Rubens, seven by Rembrandt and others by Hercules Segers, Frans Hals and Jan Porcellis. Cappelle thus had the opportunity to make a first-hand study of the works of these artists, assimilate their lessons and apply his conclusions to his own production.
Cappelle executed tranquil, harmonious marine views and invented a type of work known as a "parade" scene in which ships are moored in ports or estuaries while salutes are fired, or groups of dignitaries in small boats approach or depart from these vessels during the celebration of a particular event. Van de Cappelle's compositions are considered to be classic examples of Dutch marine painting due to their perfection and the mastery of the elements within them.
Coastal View with Sailing Vessels, dated to the second half of the 1650s, is signed by the artist using a double "p" and double "l", a spelling that he started to use in the 1650s, according to Russell. The artist organised the ships into two lines, creating an empty space in the centre that allows for a view to the brightly lit horizon that creates another visual focus point. The artist's interest focuses on capturing the atmosphere rather than on a depiction of the vessels, and this is conveyed through the light and its reflection, with the sails brightly lit or back-lit and their shadows and reflections falling on the calm water. Some of these effects are evident in the foreground in which the sea is illuminated in certain areas by these reflections, which in places even include the colours of the clothes of the figures on board. This carefully organised composition opens out on each side with small boats full of passengers that lead the eye into the middle-ground where Cappelle has located larger vessels.
In the mid-19th century the canvas was in the collection of Henry Danby Seymour where it was seen by Waagen who catalogued the painting as a work by Willem van de Velde the Younger. As Gaskell noted, this erroneous attribution may have been due to the condition of the painting at that date and the difficulty of reading the signature. In addition, during the 18th and 19th centuries the work of Van de Velde was more highly esteemed than that of Cappelle.
Winter Landscape
Portrait of a Man with Documents
Panoramic Landscape with a City in the Background
The Naughty Drummer


CHATTY is a Prague based fashion label founded in 2004 by designers Radka Sirková and Anna Tušková. Their unique design approach offers a modern interpretation of both masculinity and femininity, achieved by creating thoughts, and provoking silhouettes through a cross-pollination of elements usually attributed to either men's or women's fashion. The collections are defined by CHATTY's signature design and special attention to detail, with a strong emphasis on premium tailoring and an eclectic use of materials. In their work, their passion for denim is highly expressive and when describing their style they often use words like hyperbole, subtlety and volume.


text:
Q: Pass a List into Python Function As a new python programmer, I have two questions about list and really appreciate your advice:
Question 1:
For the following code:
nums1 = [1,2,3,8,0,0,0]
m = 3
nums2 = [2,5,6]
n = 3
def merge(nums1, m, nums2, n):
    nums1[:] = sorted(nums1[:m]+nums2)
merge(nums1, m, nums2, n)
nums1

What it does is: pass list nums1 and list nums2 into merge function, and merge them into list nums1 with the first m items in nums1 and n items in nums2, and sort list nums1. So the results are: [1, 2, 2, 3, 5, 6]
So my question is: since list nums1 was defined outside the scope of function merge, how come it has the ability to update nums1? And in the following example:
x = 10
def reassign(x):
    x = 2
reassign(x)
x

Variable x was defined outside of function reassign, and the reassign function was not able to update x defined outside of reassign, which is why x returns 10.
Question 2:
In the above code I provided, if I write it like the following:
Note: I just modified nums1[:] into nums1 when assigning sorted(nums1[:m]+nums2)
nums1 = [1,2,3,8,0,0,0]
m = 3
nums2 = [2,5,6]
n = 3
def merge(nums1, m, nums2, n):
    nums1 = sorted(nums1[:m]+nums2)
merge(nums1, m, nums2, n)
nums1

nums1 returns [1,2,3,8,0,0,0], so my question is: after adding [:] after nums1, how come the function has the ability to nums1? What does [:] in that example?

A: To replicate what you are saying, take the following:
var = 10
lst = [1, 2, 3]

def func():
    var = 11
    lst[:] = [1, 2, 3, 4]

func()
print(var, lst)

The above will output 10 [1, 2, 3, 4]. Now notice the following:
var = 10
lst = [1, 2, 3]

def func():
    print(var)
    print(lst)

func()

Outputs 10 [1, 2, 3] -- so we know that functions can access global variables, but in most cases cannot modify them. Now let us look at both cases (int and list): The two cases are followed:

*

*The var variable is not being modified due to the difference of reference between local and global scope (while we can access the global scope, we can't modify it). I recommend playing around with printing globals() and locals() for fun. This case can be fixed if we do:

def func():
    global var
    var = 11

*The lst variable is being modified with the [:] notation because as referenced here, the slice assignment [:] utilizes the operator function setitem(). Therefore, technically, lst[:] = is the equivalent of doing:

from operator import setitem

lst = [1, 2, 3]

# Both of these are equivalent.
lst[:] = [1, 2, 3, 4]
setitem(a, slice(0, len(a)), [1, 2, 3, 4])

setitem does not discriminate between local or global scopes.

A: (Don't use the [:] thing. That's horrible.)
My informal answer
When you say nums1[:] Python is finding the GLOBAL list called nums1.
However, inside of a function, Python pays attention to new variables first. Why?
- it would suck if any variable name you ised outisde of a function, was now restricted from being used as DIFFERENT variable inside the function
H = True # some variable.pretend it means "High"

def euro_height(inches):
    H = inches # since H is a nice abbrev for height in inches
    return H*2.54 # Centimeters

I don't want my H inside the function to overwrite something I already stored. Therefore, within euro_height, H is considered a different local variable, which only that function can see and use. If I want to use the H from outside of the function, I'd have to first tell Python to access it. Then I can use it.
H = True # some variable.pretend it means "High"

def euro_height(inches):
    global H
    print(H) # will say true

    renamed_var = inches # since H is a nice abbrev for height in inches
    return renamed_var*2.54 # Centimeters

If I were to assign H = inches inside the function now, it would overwrite the True value for the global H. So instead, I rename it, because there is already an H I want to use.
The name for all this is called namespaces. Hopefully, you are doing a Python tutorial. You will understand this when they teach functions. I highyl suggest doing a tutorial if you aren't.
For more about this answer related to what happened to you, look at the interactive examples here https://www.programiz.com/python-programming/global-local-nonlocal-variables
Also, never use mylist[:] again. =) It's poor syntax.
It just returns the entire list. so just use the name of the list mylist. By adding the brackets, you forced finding og the global var, and created your problem

A: If you are confused, take the following.
Firstly placement and change are not the same things
nums1 = [1,2,3,8,0,0,0]
lst = None
m = 3
nums2 = [2,5,6]
n = 3
def merge(nums1, m, nums2, n):
    global lst
    lst = sorted(nums1[:m]+nums2)
merge(nums1, m, nums2, n)
print(lst)

nums1[:] means your whole list.
If you use nums1[:] instead of nums1 You can change your former nums1[:] list using sorted(nums1[:m]+nums2). When you do this change what both your former and latest list, so you in the nums1 array list changing new with new attached variables place each other. But if you use only nums1 instead of nums1[:] the latest nums1 now refers to a different list from the former.


As a beneficiary of a Rowe Fund loan, Borrowers must inform the Rowe Fund Committee, in a timely manner, whenever there is a change in the Borrowers and/or Guarantors address, telephone number, facsimile number (if any), and/or e-mail by filling out the Update Information Form. Upon clicking submit, you will receive a confirmation email.
"The Rowe Fund was fundamental for allowing me to complete my studies at Harvard. It was small relative to the overall cost of my tuition but critical to meet the last mile of financial requirements to enroll in my second year. I will always be grateful to the OAS and encourage the Fund to keep helping people improving the world."


text:
package demo.binea.com.androidbillion;

import android.content.Context;

import javax.annotation.Nonnull;
import javax.annotation.concurrent.GuardedBy;
import java.util.concurrent.Executor;
import java.util.concurrent.Executors;

public final class RobotmediaInventory extends BaseInventory {

	@Nonnull
	private final Executor background = Executors.newSingleThreadExecutor();

	@Nonnull
	private final Executor onLoadExecutor;

	@GuardedBy("lock")
	@Nonnull
	private State state = State.INITIAL;

	public RobotmediaInventory(@Nonnull Checkout checkout, @Nonnull Executor onLoadExecutor) {
		super(checkout);
		this.onLoadExecutor = onLoadExecutor;
	}

	@Nonnull
	@Override
	public Inventory load() {
		synchronized (lock) {
			if (state != State.INITIAL) {
				return this;
			}
			state = State.LOADING;
			if (RobotmediaDatabase.exists(checkout.getContext())) {
				background.execute(new Loader());
			} else {
				onLoaded(RobotmediaDatabase.toInventoryProducts(checkout.getProducts()));
			}
		}

		return this;
	}

	private void onLoaded(@Nonnull final Inventory.Products products) {
		synchronized (lock) {
			if(this.state == State.LOADED) {
				return;
			}
			this.state = State.LOADED;
			this.products = products;
		}
		onLoadExecutor.execute(new Runnable() {
			@Override
			public void run() {
				synchronized (lock) {
					if(state != State.LOADED) {
						return;
					}
					listeners.onLoaded(products);
				}
			}
		});
	}

	boolean isLoaded() {
		synchronized (lock) {
			return state == State.LOADED;
		}
	}

	private enum State {
		INITIAL,
		LOADING,
		LOADED
	}

	private class Loader implements Runnable {
		@Override
		public void run() {
			final Context context = checkout.getContext();
			final RobotmediaDatabase database = new RobotmediaDatabase(context);
			final Products products = database.load(checkout.getProducts());
			onLoaded(products);
		}
	}
}