text:
Home E/M Sentinel E/M Sentinel News Board of Education member on 2017 racist flier may have been involved...
Board of Education member on 2017 racist flier may have been involved in mailing, according to U.S. Postal Inspector's report
KATHY CHANG, Staff Writer
EDISON – Was the racist flier that was distributed by mail during the 2017 Edison Township Public Schools Board of Education election "a political trick for politics"?
That is what Township Councilman Robert Diehl believes, and he called the information in United States Postal Inspector David Comer's report "a shame" during a Committee of the Whole meeting on Nov. 5.
Comer's report names six members of the community who were allegedly involved in assembling or mailing the flier: Satish Poondi, the legal adviser for the Indian Business Association who previously served on the Mayor's Advisory Committee on Community Relations in Edison; Raj Bhagia; Mohin Patel; Township Councilman Ajay Patil; Board of Education member Jerry Shi; and Shariq Ahmad, the former chairman of the Edison Democratic Organization.
Ahmad was allegedly found to have purchased 80 rolls of the same postage stamp that was used on the flier on Oct. 28, 2017, at the Edison Post Office on Route 27.
Members of the Committee of the Whole read Comer's report verbatim at the meeting on Nov. 5.
Diehl said they had subpoenaed Comer to testify about the report; however, an attorney representing the U.S. Postal Inspector's Office indicated Comer would not comply with the subpoena on Nov. 4.
The attorney said live testimony of a federal agent needed additional affirmations made in regard to the nature of the testimony and then the office would evaluate the request.
Comer previously testified before the Committee of the Whole. He said 137 racist flier postcards which have been marked and submitted as evidence have gone through a visual examination and an alternate light source examination, and have been submitted to a forensic laboratory.
Out of 137 postcards, slightly fewer than 50 postcards came back with fingerprints.
Aloysius Dsouza's fingerprints were found on one mailing that was sent for testing at the forensic laboratory, according to reports. This finding ultimately led to an interview with Chandrakant Patel, founder of Chowpatty Restaurant in Iselin, on Sept. 28, 2020.
Patel named the six people during an interview with Comer. He said he was contacted by Poondi in October 2017, allegedly requesting help in "mailing things." Patel said he was an active member of the community since the 1990s and allows members of the community to use his restaurant for community-related activities.
He said each of the six individuals came into his restaurant carrying boxes that included large postcards, according to reports. He reportedly asked Aloysius and Joseph Dsouza, who were working at the restaurant, to help them with the mailing.
Ten days after, Patel, who said he was not involved in the dissemination or creation of the flier, said he saw a news story about the flier. He contacted Poondi and asked him what was going on. Allegedly, Poondi instructed Patel to stay quiet, to not discuss the flier with anyone and to not say anything to anyone, according to the reports.
Diehl said Patil, who was one of the six people named in the report, reached out to him on Nov. 4 to discuss the situation. He said Patil did not have or see the report prior to their meeting.
Patil met with Diehl, Comer and Councilman Alvaro Gomez on Nov. 5. He explained he was at the Chowpatty Restaurant in late October and did see the flier being prepared; however, he said he had no part in assembling, creating or disseminating the flier.
Patil, who attended the meeting virtually, said he was at the wrong place at the wrong time. He released a sworn written statement on Nov. 6 adding he did not see any of the named people in the report at the Chowpatty Restaurant other than the two employees, the Dsouzas.
Diehl said Patil told them the architects of the racial flier were allegedly Poondi, Bhagia and Mahesh Bhagia, who was not named in the report. Mahesh Bhagia is the current Edison Democratic municipal chairman and works as an aide to Mayor Thomas Lankey.
The mayor released a statement on Nov. 6 stating he was "deeply disturbed by the federal report of a conspiracy surrounding the abhorrent racist flyer."
"Let me be perfectly clear, the township of Edison is united in condemning the actions of the men who brought disgrace upon themselves by trying to divide this town," he said. "While they will have to answer to law enforcement and their own conscience, I want to assure every resident that Edison continues to stand together in moving forward in a spirit of inclusion and unity."
Ahmad took to social media denying his involvement with the racist fliers on Nov. 6.
"This is local politics at its absolute worst," he said. "I was outraged to learn that Chandrakant Patel and Ajay Patil had been caught having involvement with the flyer. At the end of the day, their actions are an embarrassment to all of Edison Township, which, despite its incredible residents, seems to always attract negative headlines because of things like this."
Ahmad further said the claims made by Patel and Patil "are absolutely false and I unequivocally deny all of them, period. I was not there and had no knowledge of it. I will be speaking with an attorney about filing a slander lawsuit against both of them."
A few days after the 2020 election season, questions still linger surrounding the offensive events of the 2017 election in Edison.
One main question remains – who distributed the racist flier by mail on Oct. 31, 2017, which had the faces of the two candidates, Jerry Shi and Falguni Patel, who are of Asian descent. The flier stated "Make Edison Great Again" and underneath each photo was the word "Deport."
"It will not go without us investigating further because we made a pledge we would continue as long as we were able to bring the people who were responsible for this injustice," Diehl said, adding that another Committee of the Whole meeting will be scheduled.
Councilman Richard Brescher said he requested a copy of Comer's report, but did not receive one. He said he suspected politics were in play after learning news media outlets received copies of the report.
Diehl denied it was political.
Township Council President Joyce Ship-Freeman said Diehl made sure no politics were involved and decided to hold the meeting after the election.
Since May 2019, the Township Council, through a Committee of the Whole, has been conducting its own investigation through fact-finding public meetings, questioning candidates from the 2017 Board of Education, Township Council and mayoral elections, people who helped with the campaigns, and people involved in the investigation. All of the people have been subpoenaed to appear before the committee.
Shi appeared before the committee in October 2019 with his attorney Christopher Keating.
Aside from a joint statement with Falguni Patel denouncing the racist flier after it was mailed during the 2017 Board of Education election, Shi, who ran for re-election for a board seat in the recent election, has remained relatively mum about the incident that made national news. Shi has not spoken with law enforcement personnel, according to officials.
During his testimony, Shi called the flier "vile and disgraceful" and said he has been "forever traumatized from the experience."
When reached after the meeting, Shi offered a written statement.
"I, Jerry Shi, have never been to Chowpatty with boxes/racist flyers. Chandrakant Patel's claim of me delivering or putting stamps or labels on racist flyers is flat-out lie."
Township Council members unanimously approved the formation of the Committee of the Whole at a meeting on Feb. 27, 2019. Forming the committee allows council members to meet outside the parameters of a typical council meeting without violating Robert's Rules, which determines how governing bodies operate.
Diehl spearheads the committee with Gomez and Councilman Sam Joshi.
Edison Police Chief Thomas Bryan has said the investigation is in the hands of the New Jersey Attorney General's Office.
Peter Aseltine, a public information officer for the attorney general, has said the office's policy "is that we neither confirm nor deny investigations."
Edison Board of Education
Edison Committee of the Whole
Edison Township Council
racist flier
Howell council members introduce ordinance proposing salary increase
Edison woman, son pulled from vehicle submerged in pond in Piscataway
A Golden Opportunity: South River native recognized by the Queen of England for exemplary law career
Cornavirus - Local Coverage
HVCHS, TMS will return to full day in-person learning starting Jan. 24
ANDREW HARRISON, Staff Writer - January 18, 2022
Health Department expects a tough January for COVID-19 cases in Princeton
Sayreville mask mandate instituted after split vote by council members; GOP...
Lawrence schools go back for half-day sessions
PSRC temporarily halts in-person programming due to rise in COVID-19 cases
Cranbury School on early dismissal for first week of 2022 due...
Princeton High School on remote learning Jan. 3-7 due to staffing...
Lawrence schools on remote instruction Jan. 3-7
Princeton undergraduates' return to campus pushed back
Municipalities see COVID-19 cases rise as residents spend more time indoors
Burlington County Animal Shelter receives more than 600 donations in Betty White's honor
HEALTH MATTERS 1/21: Joint Pain? It Might Be Time to See a Rheumatologist
NBTHS student collects bottle caps that will be used to make prosthetics
Cranbury school board approves contract to construct auxiliary gym
Archives Select Month January 2022 December 2021 November 2021 October 2021 September 2021 August 2021 July 2021 June 2021 May 2021 April 2021 March 2021 February 2021 January 2021 December 2020 November 2020 October 2020 September 2020 August 2020 July 2020 June 2020 May 2020 April 2020 March 2020 February 2020 January 2020 December 2019 November 2019 October 2019 September 2019 August 2019 July 2019 June 2019 May 2019 April 2019 March 2019 February 2019 January 2019 December 2018 November 2018 October 2018 September 2018 August 2018 July 2018 June 2018 May 2018 April 2018 March 2018 February 2018 January 2018 December 2017 November 2017 October 2017 September 2017 August 2017 July 2017 June 2017 May 2017 April 2017 March 2017 February 2017 January 2017 December 2016 November 2016 October 2016 September 2016 August 2016 July 2016 June 2016 May 2016 April 2016 March 2016 February 2016 January 2016 December 2015 April 2014
You can find our Archives from 2000 – 2015 at archive.centraljersey.com


Abbreviations and acronyms are common in any culture, and that's the case in Permaculture, as well. Some of them are "Permanaut" and EPT – European Permaculture Teachers partnership. If the attached photo is blurry, find us at http://permateachers.eu/mugshot-gallery/.


Australian surfer Stephanie Gilmore has claimed her seventh world surfing title, equalling the record set by former champion Layne Beachley.
Gilmore claimed the win after title rival Lakey Peterson failed to move past the second round of the Maui Pro in Hawaii this morning.
Peterson came up against Hawaiian Alana Blanchard, who made things difficult for Peterson by notching up two waves of 7.60 and a 5.50.
Peterson needed a 7.83 in the dying minutes but could only manage a 5.27, handing Gilmore the world title.
"I was not expecting this right now," Gilmore said after the win.
The work isn't over for Gilmore just yet, she still has to compete in round three of the Maui Pro.
Gilmore has now equalled Layne Beachley's record of seven world surfing titles, which she set in 2006 before retiring from the ASP World Tour in 2008.
Gilmore had a message for Beachley after matching her feat.
"It's an honour to sit alongside you Layne," Beachely said.
"You've been a huge inspiration for my entire career and for so many female surfers around the world and to equal you is amazing.
"Thanks for setting the standard."When asked how many more titles she wanted to win, Gilmore remained coy.
"I'm just going to lap up seven," she said.


Please select a delivery option below.
Would you like to order cookies?
If no, please leave blank. If yes, please enter the quantity and any special request.
Would you like to order cupcakes?
Would you like to order a cake?
If no, please leave blank. If yes, please enter any special request and complete the sections below.
Would you like to include any cake decorations?
What cake flavors would you like?
What cake filling would you like?
What type of cake icing would you like?


Five weeks from today the 2019 NFL league year will begin and the first week of it includes the Pittsburgh Steelers being scheduled to pay out $15.4 million in total in roster bonuses to five different players. While many of these roster bonus amounts and due dates have long been known, there might have been a few questions on a few others. Thanks to a great Thursday morning post by former NFL agent Joel Corry of CBS Sports that recaps the league-wide important contract dates of several players, we have a great snapshot of which Steelers players are due what and when. Below is recap of the Steelers players who are due roster bonuses during the first week of the 2019 NFL league year and the specific amounts and dates for each.
QB Ben Roethlisberger – ($5 million roster bonus due March 15 (third day of 2019 league year) – While Roethlisberger is officially due his 2019 roster bonus on March 15, his expected forthcoming contract extension that should be completed around his March 2 birthday should take care of that. The $5 million roster bonus that Roethlisberger is due, along with a good portion of the $12 million base salary he's currently scheduled to earn in 2019, will more than likely be rolled into one large signing bonus as part of his new and expected contract extension.
ILB Vince Williams – ($2.9 million roster bonus due March 15 (third day of 2019 league year) – Williams, who signed a three year, $18.6 million contract extension with the Steelers last August, his due a $2.9 million roster on the same day Roethlisberger is due is. While the Steelers former sixth-round draft pick out of Florida State did miss two games in 2018 due to injuries, he still managed rto come close to setting a new career-high in tackles in addition to registering 4.5 sacks, one interception and two passes defensed. Along with the $2.9 million roster bonus he's due in March, Williams is also scheduled to earn a base salary in 2019 of $2.2 million and his salary cap charge is set to be $6.7 million.
K Chris Boswell – ($2 million roster bonus due March 15 (third day of 2019 league year) – Just like Roethlisberger and Williams, Boswell is also due his $2 million roster bonus on the third day of the new league year after signing a four year, $16.8 million contract extension with the Steelers last August. Despite his disastrous 2018 kicking season that ended with him being placed on the team's Reserve/Injured during the final week reportedly with a grade-2 groin tear, there's no reason to think that Boswell be cut before being paid the roster bonus he's due. Even Steelers team president Art Rooney II hinted that Boswell will remain with the team through at least training camp when he held his annual end-of-the-season media sessions several weeks ago. The Steelers will pay Boswell his bonus and hope that he can rebound during the offseason while being pushed by another kicker.
DE Stephon Tuitt – ($3 million roster bonus due March 17 (fifth day of 2019 league year) – A few days after the roster bonus due dates of Roethlisberger, Williams and Boswell, Tuitt will be due his $3 million roster bonus. With Tuitt also currently scheduled to earn a base salary in 2019 of $6 million, he'd be a perfect candidate in the next five weeks to have his contract restructured should the Steelers decide they'll need an even larger extra surplus of salary cap space this season. Restructuring Tuitt's contract to the maximum allowed prior to March 17 would clear $6,146,250 in 2019 salary cap space. Such a restructure isn't guaranteed to happen, but don't be shocked if it does. We'll likely know for sure if it has been restructured within the next five weeks. One year ago this week is when the Steelers last restructured Tuitt's contract.
WR Antonio Brown – ($2.5 million roster bonus due March 17 (fifth day of 2019 league year) – If you weren't already aware by now that Brown is due a $2.5 million roster bonus on the fifth day of the new league year, welcome back from your coma. With Brown's current status with the Steelers being very tenuous, the team might decide they want to rid themselves of him this offseason via a trade. If that winds up being the Steelers plan with Brown, and they can find a team willing to trade for the wide receiver, the ideal time to deal him would be within the first five days of the new league year so that the acquiring team would be on the hook for the $2.5 million roster bonus he's due on March 17. If the Steelers hold on to Brown through March 17 and trade him at a later offense date, however, they would need to eat that roster bonus as dead money.


text:
Izel-lès-Hameau (; before June 2009: Izel-les-Hameaux) is a commune in the Pas-de-Calais department in the Hauts-de-France region of France.

Geography
Izel-lès-Hameau is a farming village situated  west of Arras, at the junction of the D54, D75 and the D78 roads.

History
During the First World War, a farm about  east, known as Filescamp Farm, was converted for use by the Royal Flying Corps. The location was known as Le Hameau. It was commemorated with a ceremony and plaque in 2015.

Population

Places of interest
 The church of St. Pierre, rebuilt in 1962.

See also
Communes of the Pas-de-Calais department

References

Izelleshameau

redpajama_set_name: RedPajamaWikipedia


text:
require "rails_helper"

RSpec.describe Interactors::PullGeoAttributes do
  describe ".perform" do
    let(:result) { Interactors::PullGeoAttributes.perform(source, destination) }
    let(:source) { build_stubbed(:person, source_attributes) }
    let(:destination) { build_stubbed(:person, destination_attributes) }
    let(:modified_destination) { result.resources[:destination] }

    context "when all destination attributes are nil" do
      let(:source_attributes) { {country_code: "US", state_code: "CO", city: "Grand Junction"} }
      let(:destination_attributes) { {country_code: nil, state_code: nil, city: nil} }

      it "assigns source country_code, state_code, and city to destination" do
        expect(modified_destination.country_code).to eq("US")
        expect(modified_destination.state_code).to eq("CO")
        expect(modified_destination.city).to eq("Grand Junction")
      end
    end

    context "when states match and destination country is nil" do
      let(:source_attributes) { {country_code: "US", state_code: "CA"} }
      let(:destination_attributes) { {country_code: nil, state_code: "CA"} }

      it "assigns country data from source" do
        expect(modified_destination.country_code).to eq("US")
      end
    end

    context "when destination state does not exist in country of source" do
      let(:source_attributes) { {country_code: "MX", state_code: nil} }
      let(:destination_attributes) { {country_code: nil, state_code: "CA"} }

      it "does not assign country data from source" do
        expect(modified_destination.country_code).to be_nil
      end
    end

    context "when source state does not exist in country of destination" do
      let(:source_attributes) { {country_code: "CA", state_code: "BC"} }
      let(:destination_attributes) { {country_code: "US", state_code: nil} }

      it "does not assign source state data to destination" do
        expect(modified_destination.state_code).to be_nil
      end
    end

    context "when a country conflict exists" do
      let(:source_attributes) { {country_code: "US", state_code: "CO", city: "Denver"} }
      let(:destination_attributes) { {country_code: "MX", state_code: nil, city: nil} }

      it "does not assign source country, state, or city data to destination" do
        expect(modified_destination.country_code).to eq("MX")
        expect(modified_destination.state_code).to be_nil
        expect(modified_destination.city).to be_nil
      end
    end

    context "when a state conflict exists" do
      let(:source_attributes) { {country_code: "US", state_code: "CO", city: "Denver"} }
      let(:destination_attributes) { {country_code: "US", state_code: "CA", city: nil} }

      it "does not assign source state or city data to destination" do
        expect(modified_destination.country_code).to eq("US")
        expect(modified_destination.state_code).to eq("CA")
        expect(modified_destination.city).to be_nil
      end
    end

    context "when a city conflict exists" do
      let(:source_attributes) { {country_code: "US", state_code: "CO", city: "Denver"} }
      let(:destination_attributes) { {country_code: "US", state_code: "CO", city: "Grand Junction"} }

      it "does not assign source city data to destination" do
        expect(modified_destination.country_code).to eq("US")
        expect(modified_destination.state_code).to eq("CO")
        expect(modified_destination.city).to eq("Grand Junction")
      end
    end

    context "when country is the same and source state is nil" do
      let(:source_attributes) { {country_code: "US", state_code: nil, city: "Denver"} }
      let(:destination_attributes) { {country_code: "US", state_code: "CO", city: nil} }

      it "assigns source city to destination" do
        expect(modified_destination.country_code).to eq("US")
        expect(modified_destination.state_code).to eq("CO")
        expect(modified_destination.city).to eq("Denver")
      end
    end

    context "when state is the same and source country is nil" do
      let(:source_attributes) { {country_code: nil, state_code: "CA", city: "Los Angeles"} }
      let(:destination_attributes) { {country_code: "US", state_code: "CA", city: nil} }

      it "assigns source city to destination" do
        expect(modified_destination.country_code).to eq("US")
        expect(modified_destination.state_code).to eq("CA")
        expect(modified_destination.city).to eq("Los Angeles")
      end
    end

    context "when state and country are the same and city is nil" do
      let(:source_attributes) { {country_code: "US", state_code: "CO", city: "Grand Junction"} }
      let(:destination_attributes) { {country_code: "US", state_code: "CO", city: nil} }

      it "assigns source city to destination" do
        expect(modified_destination.country_code).to eq("US")
        expect(modified_destination.state_code).to eq("CO")
        expect(modified_destination.city).to eq("Grand Junction")
      end
    end
  end
end

redpajama_set_name: RedPajamaGithub


text:
Home/World News/Asia-Pacific/Princes fuel corruption in Saudi absolute monarchy
Asia-PacificWorld News
Princes fuel corruption in Saudi absolute monarchy
A group of veteran Saudi activists stresses that the endemic political corruption in the oil-rich kingdom emanates from officials who are all appointed by and/or come from the royal family.
"Corrupt behaviors have become the general norm of royal family members; they occupy top government positions, compete to rob public funds and accumulate illegitimate wealth," the recently formed Saudi Civil and Political Rights Association said in a statement.
The statement added, "The common denominator between most corrupt practices is the existence of princes, who provide bandits with logistical support and necessary protections."
The official positions held by members of the royal family should be limited and provincial governors and parliamentary representatives elected, the group also argued.
Saudi Arabia sits on 25 percent of the world's known oil reserves and plays a moderating role in OPEC by manipulating supply to keep prices down. So the West's addiction to oil makes it subject to only mild tut-tutting on questions of corruption.
Saudi Arabia's most internationally prominent prince, Prince Bandar Bin Sultan, who negotiated a £40bn arms deal between Britain and Saudi Arabia reportedly received secret payments for over a decade, The Guardian reported in February 2008.
Up to £120m a year was sent by BAE Systems from the UK into two Saudi embassy accounts in Washington. The purpose of one of the accounts was to pay the expenses of Prince Bandar's private Airbus.
The payments were discovered during a Serious Fraud Office (SFO) investigation. The SFO inquiry into the Al-Yamamah deal was stopped in December 2006 by attorney general Lord Goldsmith.
Saudi Arabia's rulers threatened to make it easier for terrorists to attack London unless corruption investigations into their arms deals were halted, according to the Guardian report.
Bombs hits MP's house in central Pakistan, kills seven
Imam Khomeini (ra) has also constantly stated the Center of Islamic Revolution as the country of The Owner of the Time Mahdi (as)
WATCH| NEW VIDEO CLIP- MERELY ONE ALLAH(SWT), MERELY ONE ALLAH(SWT)
Supreme Leader pays tribute to Founder of Islamic Republic

redpajama_set_name: RedPajamaCommonCrawl


Discussion in 'Clean Debate Zone' started by MacTheKnife, Jan 9, 2019.
We hear that accusation and chant constantly...particuarly from the antifa group when they are out in the streets hollering 'Islamaphobe' and of course we see it on the board constantly.
First of all let me post a definition of Islamaphobia to make sure we are on the same page..................'unreasonable dislike or fear of, and prejudice against, Muslims or Islam:' from --the Cambridge English Dictionary.
The key word being of course.....'unreasonable' ---so can it be said at least truthfully that 'Islamaphobia' is a problem in America or can it be truthfully said that Republicans are guilty of Islamaphobia?
Any phobia is fear that is out of proportion to the danger. Thus, fear of crossing any bridge is excessive and unhealthy. Fear of crossing an old rope bridge high over a ravine is not unfounded or excessive.
When the matter is dislike or opposition to something, phobia has nothing to do with it. In such a case, "phobia" is merely an epithet cast to disparage the mental state of the person opposed.
To be opposed to something or someone opposed to you is understandable, even natural.
There are 1.6 Billion Muslims in the world. Most of them are just trying to get by in life. There are 6 million Muslims in the US. Most of them are law abiding folks as well.
You are more likely to be killed by a white extremist than a Muslim extremist in this country.
Nobody talks about Caucasia-phobia... we just kind of accept it.
Okay, let's look at that one.
Are Muslims opposed to us, or our policies? Since this is the CDZ, I would liken our policy to sticking our hands in a hornet's nest and then complaining about getting stung. We go into THEIR part of the world, bomb their cities, occupy their lands, arm the craziest person we can find on the theory we can work with him and then wonder why he turns on us.
Fun Fact: What do Osama Bin Laden and Saddam Hussein have in common? They were both guys the CIA thought we would work with until they turned on us.
No more than anyone else's.
Muslims just kind of hung back and said, 'Yeah, go ahead and kill each other if it gets you off our backs."
How many muslims does it take to set off a nuclear device in New York? Lest we forget Obama said that was one of his biggest fears.
Anyhow....we see posts like yours all the time claiming that(you do not post any stats) but even if the stats support that it is essentially irrelevant...as in the count could change at any time.
Say Obama's fear about N.Y. came true....can you imagine how the count would change?
White extremists is a broad term...by which you could include the school shooters, hate crimes etc.etc. and so on and so forth and since Whites are the majority pop. then of course they are going to committ more crimes...but are these white criminals really a threat to our National Security? I do not know of any white extremist group who wants to destroy America.
At that moment in time when Japan attacked pearl harbor..more whites had been killed in America by other whites over the years....but who posed the biggest threat to America?....thus it is obvious you pose a fallacious argument.
Obviously you know nothing of the History of Islam. They have been fighting wars ever since Mohammed founded Islam.
But Perhaps you are just being sarcastic...and I kinda think you are but anyhow Jihad is founded on Islamic teachings.
the topic is about Islamaphobia in America not the history of Islam.


Last year was rather a rough one for me and left me feeling fairly disheartened. I think I lost the last of my naïveté, and the last of my innocence.
I am really saddened by this wasteful world we live in, where everyone is after a better deal and is willing to climb over their fellow human to get their hands on it (preferably giving them a kick as they climb). It isn't the world I want to live in, it is not the workplace I want to work in, and it is certainly not the future society I want to bring my children into.
But it is so, it exists, and I cannot change it.
All any of us can do is be the best people we can be - look after ourselves well so that we can be kind and good people to others - especially to those we love the most.
I made some big choices last year that will deeply affect the rest of my life, and so far I feel very strongly that they were the right choices. Sometimes, you just have to trust in yourself and do what you instinctively know is right.
2014 is looking very positive, full of hope, new life and creative promise.
So here we are in mid-December with Christmas fast approaching. It has been a very eventful year and although creative endeavours have always remained at the forefront of my mind, mostly they have not progressed from the design stage to production mode.
I did have the absolute pleasure of attending screen printing and fabric stamping classes in the latter part of the year and have purchased my beloved nieces a custom fabric stamping kit for Christmas. I cannot wait to see what they make!
I too have bought myself some printing goodies and I am looking forward to enjoying a relaxing holiday with my family and a fair bit of creative time.
A big thank you to all the lovely Twice Giggle Thrice customers over the past two years. 2014 should see some changes in direction for the brand. You can expect more quilts and some very special limited edition crafts.
It has been busy here. October was a bit of a whirlwind month for us. The twice giggle thrice Etsy store sold out, and with lots of babies arriving, we have had several quilt and bib orders.
Look out for new stock in the Etsy store over the coming months. Just don't look today, because like mother Hubbard's, our shelves are bare. Not to worry though, the sewing studio is still well stocked with beautiful organic fabric waiting for a purpose.
Well, not so much sewing has occurred here lately. We had one sick little person about 4 weeks ago who had a fever and cough for 7 days, but otherwise was bright eyed, alert and eating. We didn't know what it was until a friend popped over to admit she had had influenza and might have passed it on.
It explains why the grown ups didn't get sick, as we would have contracted a virus, but having had half a decade of flu shots under our belts, we were ok. Incidentally, we don't get flu shots anymore. I had a very extreme reaction to one in 2012 at work and my GP warned against them. However, I do like to think that the reason my son was able to weather the flu so very well is down to the fact that he had the benefit of all of those years of vaccination his mother (me!) was able to pass on to him in utero and through breast milk.
Long story short, our very important small person was sick for a week and we big people have taken weeks to recover from the exhaustion you get after a few consecutive nights without sleep and constant worrying. A bit like having a new baby all over again, no?
So, I have been thinking about sewing, but not actually doing any sewing.
But, I have been cooking lots of healthy stuff to help my family regain optimum health after our ordeal. A lot of it I just make up as I go, and most of the time things turn out amazingly.
We have had one fail, which was pancakes made with coconut flour. They were terrible!
A big recent success has been brown rice piklets, made with whole cooked brown rice, organic spelt flour, eggs, a liquid such as milk (you can use soy or almond or whatever you want), vanilla bean paste and a splash of maple syrup (the real organic stuff from Canada please...) or coconut sugar or both. So yummy, recipe free, and great cold snacks to eat at the park, or on the way there.
It has got me thinking, do people mostly use recipes to cook? Or are there other happy go lucky experimental cooks like me out there?
It is growing. It is all still alive. So far, so good.
But... The poor violets have been sprayed AGAIN by the council. Very annoying and disappointing. They've also sprayed the mint in my neighbours front garden and an entire fenceline of seaside daisy a few houses up from us has been obliterated. Oh so unnecessary.


Part of the Noah's Ark series of animal prints, all six of these necklaces are designed to highlight the artistry of glass while adding just a touch of the classic go-to print.
Each glass component is painstakingly created one be one (not two by two!) by swirling molten glass and carefully placing spots or stripes of more molten glass on each of the focals before shaping them into little hearts and matching rounds.
These Leopards are white with deep yellow and jet black stripes crouching elegantly between the strands of silver.
Approximatley 30" to the tip of the dangles.


text:
Traditions Explained: A History of Christmas Stockings
by Ceara Rossetti December 19, 2019
written by Ceara Rossetti December 19, 2019
Home » Style & Creativity » Traditions Explained: A History of Christmas Stockings
There are so many traditions surrounding holidays. Christmas has many, one of them being hanging stockings that get filled with small gifts on Christmas Eve. Like many traditions, the history of Christmas stockings is uncertain and also mind-boggling. Who would have thought to hang socks up on a fireplace and put gifts inside? Similar to the confusion when considering why someone thought it would be a good idea to cut down a tree and put it in their house to decorate? But that is a whole other tradition. In terms of Christmas stockings, there are two main theories as to how it began.
The Story of a Man and His Three Daughters
Firstly, the story of A Man and his Three Daughters: There was an old, widowed man who had three daughters. They were poor and the man worried about the future of his daughter; even though they were quite beautiful, he had nothing to give for their dowries and their impoverished status was an obstacle. St. Nicholas, a 4th-century bishop from modern-day Turkey, heard about this and wanted to help the man. His parents had left him with a small fortune and St. Nicholas wanted to do good with it so he often made anonymous gifts. One night while the family was asleep, St. Nicholas snuck inside their home via the chimney and placed a bag of gold in each of the three freshly washed stockings that hung above the fireplace to dry. Naturally, when the family woke up the next morning they were awestruck to find the gold and the girls were happily able to get married.
The origins of the Christmas stockings are many and sparse, but regardless of its history, it is a popular Christmas practice worldwide to hang stockings above the fireplace.
The history of Christmas stockings is said to have inspired children to hang their own stockings up on the fireplace in hopes that St. Nicholas would visit them and give them gifts, too. Oranges became a common gift as a way to represent the gold that St. Nicholas gave to the three daughters.
The Norse Legend of Odin and Yule
Secondly, the Norse legend of Odin and Yule: the god Odin rode an eight-legged flying horse, Sleipnir, with whom he lead the Wild Hunt that took place during Yule. As a holy time, Yule lasted from December 21st, the winter solstice, until the end of the month. On the eve of this night, children put carrots, straw, and/or sugar into their boots as food for Sleipnir as he rode across the sky. To repay their gratitude, Odin would replace the food in their boots with treats for the children. Because of the older origins of putting gifts in shoes, it is plausible that the stockings evolved from the shoes as it was typically wooden shoes that were used, but those became less common. Socks have never ceased being used, except to become decorated and festive!
The Story of "A Visit From St. Nicholas
In the famous poem, "A Visit from St. Nicholas," which might be more commonly known as "'Twas the night before Christmas," Christmas stockings are mentioned. Written in 1823, it makes sense to conclude that stockings had already been well-established as a Christmas tradition. The author (which is a controversial topic) ended the poem with "fill'd all the stockings; then turn'd with a jerk,/And laying his finger aside of his nose/And giving a nod, up the chimney he rose." Whether it was Clement Clarke Moore or Henry Livingston Jr., stockings were present enough in most households to include in this poem for all to read.
Whether St. Nicholas, Odin, or someone entirely different, the history of Christmas stockings became more than just socks hung above the mantle. In countries all over the world, families hang up specially designed stockings that represent the holiday in their home with hopes that they will be filled with gifts and treats.
More on Gildshire Style and Creativity Magazine
#christmasdecorations#christmastraditions#HolidaySeason#tradition
Ceara Rossetti
Ceara is a freelance writer who loves being able to write about her favorite topic - art! Of course, there are many other topics she also enjoys such as literature, traveling, and food. When she is not writing, she is usually cooking, reading, making art, or going for walks around NYC where she lives with her husband.
Toyota Surprises Industry: "Trump is Right"
How Millennials Are Changing the World
Making New Year's Resolutions to Better Yourself Artistically
Fashion and Beauty Trends Changing in the Post-Pandemic...
Sustainable and Environmentally Friendly Clothing
Purple Color is Trending for Spring 2023 –...
How To Stay Warm, But Be Cool: Essential...
When Is The Right Time to Buy New...
Best Converse Shoes of All Time
Top 3 Cities to Choose as Your Bachelorette...
5 Tips For Choosing The Right Wristwatch For...
4 Ways to Express Yourself With Jewelry
I Want Candy: The Tootsie Roll History
California Splits in Two on Gov. Newsom's Mask Directive
Westminster Kennel Club Best in Show on TV
The Academy Awards and the COVID
Elon Musk's Ten Rules for Success
Oregon Coast Road Trip with Gildshire
Must-Have 2019 Washington Nationals World Series Champions Products


text:
Lhôtel de ville de Vanves est un bâtiment administratif se trouvant dans la ville de Vanves dans les Hauts-de-Seine. Il est situé rue Mary-Besseyre.

Historique

À la Révolution, le siège ne la nouvelle municipalité fut établi dans un local attenant à l'église Saint-Rémy. Une mairie fut ensuite construite en 1857 par l'architecte Claude Naissant, route départementale 74, aujourd'hui la rue Antoine-Fratacci. Une annexe se trouvait rue Normande, aujourd'hui rue Louis-Dardenne, fruit de l'acquisition en 1884 de la propriété Ribout. C'est en 1893, avec la création du chef-lieu de canton, que la commune fit édifier un nouveau bâtiment, inauguré le 23 juillet 1898.

Description

C'est un bâtiment à deux étages. Au centre de la façade extérieure, se trouve un fronton central portant une horloge. L'entrée se fait par un escalier central à double rampe. La couverture est faite d'ardoises.

Il a été décoré par le peintre Jean Enders. Henri Gaston Darien a de plus réalisé sur les murs de la salle des fêtes des scènes de la vie de Vanves.

Paul Schmitt a réalisé des esquisses, mais qui n'ont pas donné lieu à une réalisation.

Dans l'entrée se trouve un buste de Marina Tsvetaïeva, œuvre du sculpteur Andrei Tyrtyshnikov.

Références

Vanves
Vanves


In this article, we are going to see about implementing Stripe payment gateway and how to integrate using PHP. In a previous tutorial, we have seen an example of integrating PayPal payment gateway with PHP. By referring to this linked article, you can easily get the idea about the payment flow.
Create a Stripe account and login to the dashboard. Navigate through the Developers -> API keys menu to get the API keys. There is two type of standard API keys named secret key and publishable key. The secret key will be masked by default which has to be revealed by clicking reveal key token control explicitly.
In this article, I have added a demo by showing this payment form with test card numbers. You can find more test data in the Stripe API testing documentation. You can use the test card numbers to demonstrate Stripe payment integration.
This screenshot shows the fields required to be in the Stripe payment form to get data from the user for processing payment.


ImageJ calls a 4D image a hyperstack (it actually be 5D or even higher). You can save these and open them and it'll show a nice GUI for them.
Unfortunately, it's not very well documented (if at all) how it recognises some images as hyperstacks. This is what I found: A hyperstack is a multi-page TIFF with the image description tag containing information on the hyperstack.
I can generate one by outputting the individual slices to files (in the right order) and then calling tiffcp on the command line to concatenate them together. If the metadata is there, ImageJ will recognise it as a hyperstack.
Here is how to do it in Python and mahotas-imread .
# Do not forget to output the metadata!
And, voilà! This function will output a file with the right format for ImageJ to think it is a hyperstack.
 Naturally, you can use other packages, but you need one which lets you write the image description TIFF tag.
Actually, Hyperstacks in ImageJ 1.x can be only up to five dimensional, with the axes being hardcoded to X, Y, Z, channel, time.
A better way to write multi-dimensional data in a robust, interoperable manner would be to write OME TIFF files.
I actually looked at what ImageJ was doing when it save hyperstacks to reverse engineer the format 🙂 I couldn't find any documentation.
Do you have any suggestion on how to solve this issue?


Ben Salzmann is a corporate freak of nature.
SHEBOYGAN – In an industry driven by financial benchmarks such as premiums, deductibles and policies in force, property and casualty insurance is not exactly known for its merriment, creativity, spontaneity or levity.
But those are the contradictions that make Ben Salzmann, president and CEO of Sheboygan-based Acuity Insurance, such an interesting corporate freak of nature.
The Acuity campus has long been the curiosity for motorists from Milwaukee driving on I-43 on their way to a Green Bay Packers game or Door County: It's that huge glass palace with the world's largest free-flying American flag.
Some employees are taking long power walks between the expansive wings of the glass-encased grounds.
Other employees are climbing up the rock walls that adorn the central elevator shafts or playing rousing games of ping pong in the lower recreation center.
Still other employees are getting fit in the company's 27,000-square-foot workout facility.
At the center of the headquarters is an honest-to-goodness, working Ferris wheel, which the CEO describes as the Charity Wheel.
Near the Ferris wheel is a ceramic carousel horse that makes for some great photo opportunities for the children of Acuity's employees — and Salzmann.
Independent insurance agents gather in the company's theater in the round for company meetings and concerts.
Salzmann records a weekly company "gossip" message that is emailed to all of the firm's employees.
"What does that stand for?" asks the naive first-time visitor.
Moments later, we arrive on the lower level, replete with replica medieval torture racks and other implements of agony that are tongue-in-cheek props in a room where employees have their blood tested, get their flu shots and partake in other harmless human resources activities.
The eccentric CEO loves to have fun, and he's not sorry if you don't understand.
With Salzmann at the helm, Acuity was ranked No. 2 in Fortune magazine's 100 Best Companies to Work For in 2016.
It wasn't always that way. When Salzmann was promoted from chief information officer to CEO in 1999, the property and casualty insurer was in a downward spiral.
At the time, the company was stalled with an annual employee turnover rate of 28%. The firm had lost a third of its annual sales, and its A.M. Best financial rating had been downgraded.
Salzmann would not be having so much fun today if he was not producing industry-leading results on the bottom line: Acuity's written premiums (sales) grew to $1.45 billion in 2017 from $289.7 million in 2000. In that same time frame, the company's net worth grew to $1.94 billion from $237 million.
The company completed a $250 million headquarters expansion project in 2017 to accommodate anticipated staffing and business growth. The firm plans to add another 100 employees in 2018.
Acuity writes property and casualty insurance across 26 states, with more than $4.4 billion in assets. The company has ambitious plans to expand its service territories into Texas, New Hampshire, Virginia, Oregon, New York, Washington and California.
Along the way, Salzmann continues to defy corporate norms.
Acuity provides unlimited sick time for its employees.
The company has no long-term disability benefit plans. Instead, if an employee becomes sick or disabled, the employee is paid regular wages — with twice-annual raises — until he or she returns to work, retires or perishes.
The company sets no sales goals for its salespeople. "Sales goals encourage bad decisions just to keep your job," Salzmann says.
The firm has no dress code. At least one employee even works barefoot.
The headquarters are adorned with exotic artwork, including gothic gargoyles on the exterior.
Acuity donates $1.5 million annually to charities.
No wonder Acuity has become the preferred employer in the Sheboygan region.
Education: Phi Beta Kappa graduate in liberal arts and a master's degree in business administration from the University of Wisconsin-Madison and a computer information systems degree from Aquinas College in Grand Rapids, Mich.


text:
COMMENTARY: Spoonful of Sugar: Why India's push for alt-med in the public health system is ill-advised
Published on October 31, 2018 November 20, 2019 by Sumaiya Shaikh
Since November 2014, the alternative treatment industry in India has been bolstered by the establishment of a dedicated ministry called the ministry of ayurveda, yoga & naturopathy, unani, siddha and homeopathy, or AYUSH. Upgraded from its status as a department, the AYUSH ministry now operates parallel to the ministry of health and family welfare, which focusses primarily on evidence-based modern medicine. In the past four years, the AYUSH ministry's budget has more than doubled to Rs 1,428.7 crore in 2017-2018. With such serious money under its belt, plans for the industry's scale and growth have been ramped up.
In 2017, the union minister of state for AYUSH, Shripad Yesso Naik, a Bachelor of Arts graduate with no scientific training, announced that the centre had approved proposals to set up 100 AYUSH hospitals across the country. This would include a major Ayurveda centre, called the All India Institute of Ayurveda—dreamed up as an equivalent of AIIMS in Delhi, India's premier government teaching hospital. In addition, Naik spoke of plans to set up an Institute of Naturopathy in Pune, at a cost of Rs 1,000 crore. The government also approved postings for 4,000 AYUSH practitioners in primary health centres across the country. This year, there was an even more aggressive push to commemorate days promoting alt-med—as alternative treatment systems are popularly referred to—in the Indian public health system. The Homoeopathy Day in April, Yoga Day in June and National Ayurveda Day in November are all fallouts of this policy push.
Urban citizens, who rely on private medical care and often choose to combine a range of modern and traditional therapies, remain largely unaffected by this push on the health front. However, a majority of the rural population, a larger segment compared to the urban demographic, either cannot afford private care or do not have access to different therapy options. Even if they do have access, many do not possess the capacity to evaluate the efficacy of different treatments. Recent schemes, such as the Ayushman Bharat—a health insurance that promises to "cover over 10 crore poor and vulnerable families"—ensure that alt-med becomes the primary source of treatment for certain segments of the population……
READ THE FULL ARTICLE at The Caravan, India's website at https://caravanmagazine.in/Science/why-India's-push-for-alt-med-in-the-public-health-system-is-ill-advised
Books & articlesOpinion
Previous Previous post: Scientific Commentary: The Cognitive Neuroscience of a Lynching
Next Next post: OPINION: Taslima Nasreen's views echo eugenicists who favour genetic cleansing for racial supremacy


Looking for a Difference in Your Floral Designs? Come to FLORAL-ELEGANCE!
Christmas flowers from FLORAL-ELEGANCE in Mount Pearl, NL are the best way to send Christmas cheer! Flowers and poinsettia plants are a great way to spread joy throughout the season, but also make quick and easy party decor. FLORAL-ELEGANCE can help you with any Christmas styles or colors with our Christmas decor accessories. Need a centerpiece or a Christmas wreath for your party? FLORAL-ELEGANCE has it, and more!


text:
Our Foresight
Focused Foresights
Title: Water Management
Author: Future Agenda | https://www.futureagenda.org
https://www.futureagenda.org/foresights/water-management/
Almost Zero Waste Previous Virtual Authenticity Next
Advanced water purification, irrigation and desalination technologies are used to help communities to manage the growing supply/demand imbalance.
As highlighted in the key resource constraints chapter, water is the resource over which many governments, corporations and communities have greatest concern for the future. As populations increase and move to urban areas, and as consumption rises in line with economic growth, water stress will be the main challenge for many parts of the world.
At a basic level, many parts of Africa and Asia will suffer increased physical water stress as the available water per person falls below the UN minimum target of fifty litres per day. In many areas, sanitation, itself a UN Millennium Development goal, is increasingly seen as difficult to achieve. Today, around 2.5 billion people lack access to adequate sanitation and the aim of halving this figure by 2015 is likely to be missed by a considerable margin. In some parts of sub-Saharan Africa, achieving this goal even by 2050 is now considered to be an ambitious target.
From the US to Chile, southern England to Kenya and the greater parts of the Middle East to Southeast Asia, water scarcity is forecast to have a severe impact over the next decade. Indeed, economic water stress is expected to affect up to half of the global population by 2020. In many areas it is not that there is insufficient water over an annual cycle but that it comes in peaks and troughs: 'the wrong water at the wrong time in the wrong place'. This is increasingly occurring as, in one season, flooding encourages us to get rid of excess water as quickly as possible and, in another, drought leads us to try to catch every drop.
According to a recent World Bank/McKinsey report, 'by 2030, projected population and economic growth will lead to global water demand 40% in excess of current supply if no adequate action is taken in the coming years. This would leave one-third of the world's population with access to only half the water it needs.'
As governments develop national water strategies and both cooperate and compete to secure water supplies, companies will come under increasing pressure to make more effective use of water in their production processes. Some will follow the lead taken by the likes of SAB Miller, P&G and Dow in significantly reducing water consumption and the principle of water footprints will gain fast traction as media and governments seek to raise public awareness of the water challenge.
With momentum building up around the issue of water use, the impetus for improved water management will increase internationally. While major technological breakthroughs such as low-cost desalination will be sought and become major areas of investment over the next decade, the utopian vision of transforming sea water into fresh water available for all will not be realised. 'Desalination will remain a luxury for rich countries such as Israel, the UAE, Singapore and Saudi Arabia.' In addition, 'desal water' is too pure and so, in many countries, minerals need to be added to satisfy public health requirements.
Some argue that 'the water problem is not one of water scarcity but more of system management'. Therefore, in the next ten years, more pragmatic short-term solutions to help communities better manage the rising supply–demand imbalance will be implemented in such areas as water purification and irrigation. While the concept of a water grid, able to shift resources around regions and between buildings to balance supply and demand, is increasingly discussed, in many areas the next ten years will be more about driving consumption behaviour change. At the same time, the politics of water will continue to be a crucial issue. 'There are vested interests in the supply and management of water and the associated impact and influence of large scale infrastructure. Most water infrastructures are managed both locally and regionally but are usually seen from a centralized perspective.'
Some say that the problem is one of consumer understanding and behaviour. In many regions where supply is not yet constrained, water is seen as having little value. People pay little attention to water because it is too cheap for them to care about. The view is that governments around the world should regulate such that everyone has a water meter and we can then build a wider public understanding of usage. In general, the privatisation of utilities such as water does not seem to have been effective and some companies are now proactively handing back the responsibility of running the infrastructure to non-profit public bodies and local authorities. Governance on catchment areas is key here. The UK system is the only one where the actual water supply has been privatised but it operates under government controls – and hence suffers from an inability to create value for the management companies.
The need to have an infrastructure that provides us all with water is the driving issue and we need to question whether large companies and organisations should be in control of this or whether it requires a local community focus. There was general agreement in the varied Future Agenda events that it really comes down to how you set up the institutions to achieve the aims and overcome the challenges at a local level. In urban environments, water scarcity in addition to forcing us to us to reconsider certain lifestyles could, at the same time, open up opportunities for innovation in areas such as water capture, treatment, conservation and efficiency. Changes in behaviour will require measuring our water consumption before we can manage it and solutions such as smart metering will find their way into our homes.
Community-driven mechanisms are particularly important in developing countries to ensure equity and effectiveness. One suggestion was to work more closely with women as, in the main, in many regions, it is they who fetch and carry water and therefore control access. There is also much to be gained from making the most of existing resources by reducing wastage, increasing water reuse, desalination and groundwater recharge. Simple but highly effective things like rain harvesting make a huge difference and, in the future, buildings will be better designed to align with this need.
The Economist is optimistic about the future and argues that change will happen where it is needed most: 'It will be in areas of high political, economic and social need that the key technological change in water will occur'. This is why Singapore is such a focus for water and its investment in low-cost desalination may be pivotal in the next decade. 'Both from government and companies such as Hyflux, many see that Singapore is a hub of water technology development.' Others are not quite so hopeful.
What everyone can agree on is that the issue is critical and that the right for all to have access to clean water is a priority. Therefore, a primary focus over the next decade will be to manage our supplies so as to enable this to happen.
Foresights
Sort A-Z Sort A-Z
${ item.value }
Download PDF Of Foresight
Future Agenda Limited
84 Brook Street
London, W1K SEH
Douglas.Jones@futureagenda.org
Join LinkedIn Group
© Copyright Future Agenda 2023
If you would like stay informed please visit our LinkedIn group: https://www.linkedin.com/groups/8227884/


text:
Projects & Design
Critical friends
Strategic planning for schools
STRATEGIC PLANNING, 2018 – 19
Our approach to long term planning enables schools and organisations to remain fully focused on their objectives and keeping on course, while responding confidently to changing circumstances that are beyond their control.
We know how challenging strategic planning can be. Over the past 20 years we have made decisions in some difficult circumstances as school leaders and advisers – for example during the South East Asian currency crisis of 1997 and after the banking crisis of 2008. Drawing on our experience of "interesting times", we can facilitate your planning to enable you to establish long term direction, while preparing for the unexpected.
School priorities must be seen in context and so we will always conduct a short analytical overview of your position in 7 Areas for Action when we are engaged to carry out training or facilitation. We are also able to assist with preparation for an accreditation or inspection.
Mission, Vision and Strategy
Our approach to strategic planning suggests that direction is maintained by having a clear Vision for the future, while the Mission is the compass which charts the course towards the identified goals, whichever way the wind is blowing. The three year strategy document is the chart used to plot the course, but the element most likely to be adjusted in the short term as the school reacts to fair winds or foul. Mission and vision, however, are both unchanging.
STRATEGIC PLANNING IN ACTION
Uncertain times
No posts available
© Copyright Consilium Education
© 2018 Consilium Education. All rights reserved.


text:
Q: How to check if value exists in each group (after group by) Assume I have a subscriptions table :
uid  | subscription_type
------------------------
Alex | type1
Alex | type2
Alex | type3
Alex | type4
Ben  | type2
Ben  | type3
Ben  | type4

And want to select only the users that have more than 2 subscriptions but never subscribed with type 1
The expected result is selecting "Ben" only.
I easy can found the users that have more than 2 subscribes using:
SELECT uid
FROM subscribes
GROUP BY uid
HAVING COUNT(*) > 2

But how to check if in a group some value never exists?
Thanks for the help!

A: To check if something doesn't exist, use NOT EXISTS(...):
SELECT uid
FROM subscribes su
WHERE NOT EXISTS (SELECT *
        FROM subscribes nx
        WHERE nx.uid = su.uid AND nx.subscription_type = 'type1'
        )
GROUP BY uid HAVING COUNT(*) > 2
        ;

A: Create Sample Table:
CREATE TABLE subscribes
(
uid NVARCHAR(MAX),
subscription_type NVARCHAR(MAX)
)

Insert Values:
INSERT INTO subscribes
VALUES ('Alex', 'type1'), ('Alex', 'type2'), ('Alex', 'type3'), ('Alex', 'type4'),  ('Ben', 'type2'), ('Ben', 'type3'), ('Ben', 'type4')

SQL Query:
SELECT uid
FROM subscribes
GROUP BY uid
HAVING COUNT(*) > 2
AND MAX(CASE subscription_type WHEN 'type1' THEN 1 ELSE 0 END) = 0

Output:
======
|uid |
------
|Ben |
======

A: Try this query:
SELECT uid
FROM subscribes
GROUP BY uid
HAVING COUNT(*) > 2
   AND max( CASE "subscription_type"  WHEN 'type1' THEN 1 ELSE 0 END ) = 0

redpajama_set_name: RedPajamaStackExchange


Theme park management sims have been a bit of a rare beast over the last decade or so. But, much like Space Sims before them, they seem to be making a comeback! And leading the charge is Planet Coaster!
Tyranny is a new PC RPG from Obsidian Entertainment, the same devs who brought us games like Pillars of Eternity and Neverwinter Nights 2- it's hard to find another studio as experienced in role-playing games, Hex!
Watch Dogs 2 continues the hacker franchise that projects a not-too-distant future where none of our data is safe - and our personal information is exploited at the whim of sinister corporations.
In times of betrayal, magic and conspiracy, sometimes the only way to survive is to crouch a lot and get stabby in Dishonored 2!
In Owlboy, you play as Otus, who is part of a race of owl-human hybrids that act as guardians of a small village in the sky.
It's been 6 years since the last main game in the Civilization series, which is a very long time in between conquering.
We've got two music-based games that take advantage of the VR fad to make the experience all the more intense: Thumper and Rez Infinite!
World War 1's depiction in games has been extremely varied and now, Battlefield One accepts the challenge of taking us back to that dark and dangerous time.
Virginia is a short, narrative experience from indie developer Variable State.
It's been five years since Gears of War 3 wrapped up the original trilogy, but the gears are turning once more in Gears of War 4.
The Forza Horizon festival is back for its third outing, and this time it's brought the thunder down under!
ReCore throws you into the future - after a brief message tells you some plague has ravaged Earth and you're on a planet called Far Eden.
Taking the simple mechanic of swiping left or right to make all of the decisions, REIGNS treats your kingdom like a Friday night Tinder session.
Obduction is a narrative first person puzzle game that starts with confusion. You don't know who you are, you don't know where you are, and you don't know how you got there. There's a voiceover telling you that many other people have been here before you though, from all places, and all times.
House of the Dying Sun is a tactical space shooter that puts you in the cockpit of the universe's most terrifying starfighter.
Trials on Tatooine is a short tech-demo slash interactive experience that puts you onto Tatooine as you await a delivery from Han Solo.
The Brookhaven Experiment is basically an old-school time crisis style arcade shooter, but in VR. You stand in the one spot while a variety of horrific and terrifying monsters come at you from all angles.
Everest VR is not much of a game either, it's about thirty minutes long and split up into five little areas that take you to various major points on the climb up Everest.
Did you name the game for this week? Plus, we say goodbye to Bajo who is away for a few weeks!
NichBoy was in San Francisco to take us on a tour with Double Fine Productions, the team behind last week's Headlander as well as Psychonauts!
The Elder Scrolls: Legends is a collectible card video game developed by Dire Wolf Digital and published by Bethesda Softworks.
Goose gives us his opinion on the international phenomenon, Pokemon GO!
Riders of Icarus is a free-to-play MMORPG by WeMade Entertainment, who have been making MMOs in South Korea for about 16 years, and are most known for the Legend of Mir series.
Monster Hunter Generations is an action role-playing video game developed and published by Capcom for the Nintendo 3DS.
Song of the Deep is a story about Merryin, about a 12 year old girl who lives with her father near the sea. At night, he would tell her fantastic stories of ancient underwater cities and terrifying creatures.
Dead By Daylight is an asymmetrical multiplayer survival horror game for PC. It's 1 killer vs. 5 survivors. The survivors need to escape and the murderer needs to sacrifice their souls to its pointing tentacle demonic god.
Trials of the Blood Dragon is a spinoff for the brilliant racing-platformer series, and actually based on another spin-off, the Far Cry Blood Dragon DLC. If you haven't played Trials before, it's basically about guiding a motorbike through obstacles, and then trying to do it faster than all your friends.
The Solus Project begins with you waking up on a beach, surrounded by the rubble of your former spaceship. You'll soon discover another astronaut who landed on the planet, but unfortunately he hasn't fared so well.
Fire Emblem: Fates came out last year in Japan, and has just received a western release. The series has some of the best turn based action around, and Fates is no expectation- follow this epic story!
Stephen's Sausage Roll is a game all about cooking sausages. Sounds easy right? Well it isn't, and it's been labelled by many as the "Dark Souls" of puzzle games. Prepare to Roll!
Star Fox Zero is a 3D scrolling shooter video game and the sixth installment in the series developed by Nintendo and PlatinumGames for the Wii U.
Stories: The Path of Destinies is a fairytale RPG, all about making choices and finding the truth. The game is told through a story book that can tell the future, and it's all narrated by one man, voicing all the characters, for a bit of a Bastion-style running commentary as you play.
Banner Saga 2 is an indie turn-based strategy game, with a strong narrative focus. The first game was crowd funded and created by a trio of former Bioware developers. And, you can certainly see their influence and experience in the choice/consequence narrative style.
The Walking Dead: Michonne is the latest installation in Telltale's very successful Walking Dead series, so we were excited to dive into the first episode to experience hair-pulling stress with every dialogue choice once more.
Born from an FPS game jam, and inspired by a flash game about a cat, Superhot is part shooter, part puzzle game. When you move, time moves. Stop moving, and time virtually slows to a stop. The game throws you in a bunch of quite varied combat scenarios, and you use this mechanic to survive.


Considered to be the worlds happiest country (from 2016), Costa Rica is a volcano jam-packed country, sea turtle loving habitat, crystal clear waterfall home and where you can sleep in a converted Airplane (for real). I'm sold from just knowing it's the worlds happiest country. Life seems so peaceful and satisfying for those who live here.
It's the definition of paradise. Need I say more?
Amazing bucket list locations! I have been to costa rica! LOVED it so much! Such a different atmosphere and culture. Right now the top locations I need to visit are Paris, the U.K. as a whole, and the bahamas!
All this places are there in all the travels bucket list, the pictures are amazing any one can fall in love with this places. I would like to go MALDIVES.
Literally all of these are on my travel bucket list. Seriously, I can send you a picture lol. I'd have to add France, Scotland, and Russia to that list.
What a list! One place my husband and I have always dreamed of going is Iceland. Especially after the New York Times wrote an article about all of their swimming pools (or baths). One day we'll go .. one day!
Oh I have never been to any of these places. All of your travel bucket list places are awesome. I have them too in my bucket list. I like to see Peru because of the Macchu Pichu; I'd love to see Iceland because of its beautiful winter landscape; New Zealand because it is so beautiful, and it is the location shoot of the Lord of the Rings movies. Oh, and yes, Norway! I would love to see the Trolltunga, but I guess I don't have that much courage to hike there. I will only admire it from a distance.
These would be great places to visit, I want to do Costa Rica and Iceland and Tanzania!
I love this list, mine has Japan, Australia and Brazil very close to the top! I've been to Iceland and have written some posts about it (Northern Lights, blue lagoon, golden circle, snowmobiling etc) on my blog if you'd like some inspiration! I'm also going to Norway in December, can't wait!


What are the type of products Dihuni can help me with?
I searched Dihuni.com and cannot find the product I need. Can Dihuni help with ordering products not listed on the website?
Yes, our vendor partners carry thousands of products and we don't have all of them listed here. We will be happy to help fulfill such products for you. For example, if you buy a server or embedded IoT product but don't see compatible memory or solid state disk or IO module listed on Dihuni.com, please contact us and we will send pricing info and help you process the order manually.
Will Dihuni fulfill all orders automatically when placed online? I had an order refunded without any reason. Is that normal?
When you place an order with Dihuni, it does not constitute an automatic commitment or confirmation of our offer to sell. Dihuni reserves the right at any time after receipt of your order to accept or decline your order for any reason. All orders will be fulfilled only after confirmation and agreement on acceptable method of payment by our credit and finance department. Dihuni can cancel any order at any time due to product short supply, recognition of fraudulent transactions or for other reasons deemed suitable by the company. In situations where Dihuni cancels the order prior to fulfillment, Dihuni will promptly refund the order amount through the payment method that was used during ordering. This is not a common scenario but you will agree it is important for us to protect from fraud which is very common specially with computer hardware.
Dihuni is a Virginia, USA company and we ship throughout USA. We offer flexible payment options. Besides using Credit Card, PayPal, PayPal Credit or Amazon Pay, you have the option to place an order online without instant payment using Bank/Wire Transfer method at checkout and then transfer funds after receiving order confirmation. This is only for corporate, educational and overseas customers. Note – order will only ship after receipt of payment, except for approved Net Terms orders. You can attach your Purchase Order and Net Terms documents at checkout.
Credit Card – You can use valid USA bank issued credit card. The billing address and shipping address must match. If you are a corporate customer with separate billing and shipping addresses we must get a Purchase Order for such transactions or proof of address, employee information at each location etc. Note – we will cancel any orders where we suspect fraudulent transactions. Also unless authorized by Dihuni and for corporate customers with validated addresses, if the billing and shipping addresses do not match, we will decline the order.
Net Terms – in most cases, the first order is pre-paid except for Fortune 500 companies and select Universities. In general, to be approved for Net Terms, you must establish recurring pre-payment order history before submitting credit application. Please contact us for more information.
All orders must be prepaid by wire transfer; We do NOT accept overseas credit cards. We will verify your address and credentials before shipping any product.
We ship globally using international carriers, primarily FEDEX International. It is recommended that you contact us to get accurate international shipping charges as sometimes web rates are not updated. We will try to negotiate and get you the best possible rates.
Dihuni will not ship to any country on the USA embargo list.
I want to order a high-end product that is listed for more than $50,000 on your website. How do I order such products?
We understand very high-end systems such as Deep Learning servers can range in price up to $200,000 or more and are not suitable for payment by credit card. However, you can order the product through our online system using bank transfer as payment method. There will be no actual financial transaction in such scenario. Once we receive the order notification, we will contact you about your payment method i.e. provide you with our bank/wire information after verifying your company and billing/shipping address. If you would like to set up Net Terms, you can attach and send your Purchase Order along with your credit application to digital@dihuni.com before or after online ordering.
If online ordering for such systems is not suitable, please contact us by email or phone and we will process your order manually.
Does Dihuni accept phone orders?
Yes, for customers who prefer ordering by phone, our sales team will help process your order manually.
I need a formal quote for my company or university's Purchasing department. Can Dihuni provide that?
Yes, please select the 'Request Quote' button and send us your product and quoting requirements and we will send you a formal quote. Please provide your billing and shipping address and contact information so we can prepare a formal quote which is usually sent as a PDF document.
What are 'Dihuni OptiReady' products?
'Dihuni OptiReady' products are 'optimized and ready' for applications. These are server, storage and embedded systems that are fully built and tested with components such as CPU, memory, hard disk, GPU, software etc that can be purchased as a fully functional system instead of a barebones system. In some cases, OptiReady may also imply a custom board + enclosure combination that are not standard manufactured by the customer; the product description will refer to such systems as barebones.
I like the barebones products on your website but need them to be built out to my specific requirements. The Dihuni OptiReady products are close but don't meet my exact requirements. How can I request customization?
A significant portion of our business is in customized and complete systems vs barebones. Dihuni OptiReady systems were designed to meet most common system requirements however we understand your requirements can be unique. To get a quote on a completely customized system, please use the 'Request Quote' button and send us your desired specifications. We will get back to you with a custom system quote. This process usually takes about 2-3 days as all our customized quotes come directly from the manufacturer and is subject to their processing time.
Does Dihuni build all servers and IoT products in-house? If not, why?
No, unless a product has been designed from scratch by Dihuni, we don't build servers/systems at our facilities. We specifically adopted a business model to work directly with manufacturers (OEMs) directly and have them build our systems – both standard and customized – to ensure highest quality. Our manufacturer's only build systems with components that are tested and qualified by their engineering team and provide direct warranty on such systems. For systems deployed in data centers or used for Deep Learning, IoT etc, we believe that the products must be hugely reliable and there is nobody better positioned to build such products than the manufacturers. Additionally to keep our costs down and pass those savings to you, we mostly drop ship hardware products from the manufacturer directly to your shipping address.
Does Dihuni offer warranty and technical support?
All hardware products come with manufacturer's standard warranty. Depending on the product/manufacturer, you can also purchase extended support options such as 5 year warranty, Next Business Day Onsite support etc. Licensed software products usually come with some basic support with options to select extended support. Software as a Service (SaaS) or other subscription based offerings also usually come with support bundled for the duration of the subscription.
What is your order processing and shipping lead times?
We usually process orders within 2 hours of receipt and send them to the specific manufacturer or software vendor for fulfillment. Orders received during weekends are processed on Mondays (except for holidays). Hardware inventory levels change every day so we check with our suppliers every time we receive an online order. Our sales teams will inform you of expected shipping time-frame after an order is received. As a general guideline, for hardware components and barebones systems that are in stock, the products are usually shipped within 3-5 days from order. Some components/barebones systems may ship same day depending on the item and vendor and if an order is placed before noon eastern US time. You can also request an order to be rushed; we don't charge any rush fee and route all rush requests to our partners but we cannot guarantee that orders will be expedited.
Custom built systems typically take about 2-3 weeks from assembly to test. And after release from production, delivery time depends on the shipping method you have selected.
After I place my order, how will I be notified of the progress of my order?
Dihuni sales team will keep you informed of your order by e-mail or through your account page on the website. Once an item is shipped, we will email you the tracking number of your shipment.
Does Dihuni sell any refurbished or used products?
No, we only sell and ship 100% new, factory packaged products.
How can I cancel my order? Can I get refund?
All product sales are non-cancellable, final and non-refundable after they have been processed unless otherwise stated on product description pages. Only Dead on Arrival (DOA) Products may be returned for exchange or credit within 15 days from Dihuni's invoice date. Credit will only be issued if returned products are in brand new condition and if manufacturer approves such return for credit and/or is unable to exchange with a comparable product. Dihuni will charge a restocking fee of an amount no less than 25% of the original purchase price for any returned product that is non-defective or arrives with an incomplete package. Customer must obtain a Return Merchandise Authorization (RMA) number from Dihuni. Please see our Returns, Repair and Refund policy for more details.
A credit card could be declined for various reasons including but not limited to: invalid credit card number, wrong billing address, expired card, in excess of daily limit, or insufficient credit. It is also possible that the card number (or expiration date) was entered incorrectly. Sometimes credit card companies will soft decline a transaction and will require you to call them to pre-approve a charge after which you can re-enter the information.
Can Dihuni advise me on compatibility for the items that I wish to purchase?
For all Do it Yourself/barebones/component products, we can help answer your compatibility questions only in accordance with manufacturer's supplied information but cannot guarantee product compatibility. We suggest that you check with the manufacturer to resolve any compatibility issues before making your purchase. The manufacturer should be able to accurately answer your technical questions.
For all customized complete systems and Dihuni OptiReady pre-configured systems, Dihuni will ensure all selected components are fully compatible.
Where is Dihuni based and which countries do you ship products?
Dihuni is a USA company headquartered and registered in the state of Virginia (VA). Our products are sold across USA and worldwide geographies with international customers in Europe, Asia etc. Most products ship overseas from the USA unless manufacturer has a facility located overseas and prefers to ship from that location. We do not ship to countries embargoed by the US government. Dihuni is not responsible for any customs duties, VAT, or any other import related taxes specific to the country where products are shipped. Such charges have to be paid by the recipient/importer directly to the shipping company/carrier/freight forwarder or customs officials. Dihuni will just charge customers international shipping charges.
I work for the US government. Does Dihuni conduct business with the US government?
Yes, we will work with our suppliers to offer high volume discounts wherever possible. Please contact us with your high volume requirements.
If an item says, "Due to the complexity of integration, this product is sold as a completely assembled system only", what does it mean from online ordering perspective?
Some barebones products are listed with price but have a note that says the product is only sold as a complete system. The product price for such systems is provided only for informational purposes. You must not purchase these barebones products online. Instead you can select a pre-configured OptiReady system if listed or contact us with your specifications so we can price a completely assembled system for you.
Do you charge sales tax? I am eligible for tax exemption.
Besides Virginia, depending on the product/manufacturer, we charge sales in states where we have nexus. For e.g. for all Supermicro products, we charge sales tax in Virginia, California, Florida and Illinois. If you are eligible for tax exemption in those states, please attach your Government Tax Exempt Permit/Reseller's Certificate etc during checkout or email us after placing the order online. We will refund you the tax portion for your order after we validate your tax exempt status. You can also email us your tax exemption document before placing an oder if you would like pre-approval for tax exemption.
What is Dihuni's unique value proposition and why we should buy from you?
We are a technology company – not another online company that sells diapers and computers on the same site. Our focus is on bringing the broadest, most advanced and reliable technology products to you for your digital transformation applications. And as diapers are getting connected to the internet with the promise of IoT, we will certainly sell them as they turn into technology products!
Close Partnerships – As authorized partners of top global companies, we work directly with their product teams to bring the best products to you and often have early access to new products. In several cases, we help vendor Product groups design new products and therefore have a strong 2-way relationship.
Best pricing – our business model ensures cutting of logistics and overhead costs and thereby passing you the savings. We strive to keep our pricing among the lowest in the industry.
Consultative, Simplification and Responsiveness – we provide detailed product information and help you with narrowing down and finalizing your product requirements, simplify your buying experience and are responsive right from initial communication to quoting to delivery and post-sales engagement.
Customer & Quality Always First – we don't just believe in it but also push our partners to maintain the same standards. We are customers for our suppliers and we understand the importance of on-time delivery and high product quality and are committed to delivering the same and top-notch customer service to you.


In this post I will walk your through in creating a photo viewer with Bing Maps integration. The viewer is hosted on a Raspberry Pi 2 running Windows 10 IoT Preview and is created as a C#/XAML Universal Windows Platform (UWP) application.
UWP is a great way of writing code that reached broad - before UWP we could still create a single solution in Visual Studio, but we would need separate DLLs for each platform target - now we can just create one DLL that can be installed on all Windows platforms. That's great!
You need to register your Microsoft account as a Bing Developer which can be done using the Bing Portal right here: Bing Maps Dev Center. Once registered you need to acquire a key/token go to My Account > Create or view keys. Follow the link to create a new key, follow the guide and remember to select Basic / Universal Windows App as the key type.
Copy the key, you will need to enter it later when creating the application.
Then we need some magic to read the photos from disk, read properties from each photo file like latitude and longitude, translate the coordinates using the Bing Maps service, update the text blocks with the data and finally show the image and set the location of the Map control. All this is implemented in C# in the code behind file.
This will look in the current users Pictures library for a folder named PiPic. Note that in the UWP there are no File library or other of that stuff we are used to from .NET - this is because that UWP will work on a phone also where we not necessarily have a C: drive.
The ImageDto and LocationDto are classes I have created for easability, download the complete solution to get the big picture.
I found this code somewhere on MSDN (can't remember the link) so I can't take credit for that, but it works :) Basically we are just querying the Bing Maps service and returning the result.
Now this is easy! All we have to do is change the debug option in Visual Studio to ARM and select Remote Machine and enter the IP adddress of the Pi. Remember to change authentication mode to None (default is Windows). Also, change the build type to Release - then you get rid of the diagnostics numbers in the top corners, but this heavily increases the build time.
For more info on deploying an UWP to Windows 10 have a look here! Look for the paragraph "Deploy the app to your Windows IoT Core device" This guide also contains instructions on how to set the application as the startup application. By doing so you can plug the photo Pi to your TV and once powered on you will have your very own photo viewer on the big screen!
And that's it - remember you can find the complete solution right here!