WELCOME BACK! HAPPY NEW YEAR 2016! ONWARD!
(If you assessed your students prior to report cards, you will not be required to retest the students).
Sub Release Sign-Ups for EDL/DRA Assessments - click here!
As we embark in this new assessment cycle, you are required to use the following document to document your students' EDL/DRA scores, please click on this link to take you to the document. More information will be provided on 1/6/16 PD.
Staff, please click on this link to read the new expectations for running records and student progress monitoring.
ILT & SSC will have the opportunity to review this and provide input but most of these expectations are to be implemented effective January 2016.
Students should be below grade level in their first language, or more than 1 year behind in their second language.
A running record on an unknown book that you will use in your reading groups.
If you already did this in preparation for conferences, you can use the scores that you got at that time.
Each teacher will be provided 1 full release day to complete testing.
Some testing will need to be completed during class time.
You will receive the Class profile, and we will do some calibration activities school wide.
Please click on this link to see a memo providing you the rationale of the restructuring of our PD calendar. The ILT and SSC will also have the opportunity to provide input on some of the changes, but I felt it necessary to regain our PD calendar after such unstable directives from OUSD leadership.
Learning Target: I can be honest about my actions and can solve problems honestly.
The class with the BEST attendance in November and December...Nunez!
...and the Golden Spatula for the months of November and December goes to….
We had a total of 196 students with perfect attendance for November & December.
We recognize that it's a large number of students so we will be giving them a Perfect Attendance Ribbon. They will be placed in your box to for you to distribute them; we are happy to go to your classroom to pass them out!
It is extremely important that you take the time to build community and reteach/review classroom expectations. These two weeks without school structures can potentially sabotage your classroom routines.
If you invest some time to review your classroom rules and school expectations, your students will be set for success.
Building a positive classroom community early in the school years allows teachers to focus on the positives of school throughout the year. Learn some tips and techniques on building a good community at Teaching Channel.
Here are some fun and useful resources to make SLA instruction more meaningful and engaging for our students. All these resources are CCSS aligned and mostly benefit 3rd through 5th grade.
Please submit the reading challenge docs to Mr. Todd. We ask that ensure that students write their name on their document.
Here is the link to submit a COST referral: Coordination of Services Referral - click here!
A gentle reminder, personal days are not allowed the day before/after a holiday.
If you are calling in sick, please submit a doctor's note upon return to work.
Please communicate to Nancy by no later than January 28th if you will be using the full amount of the allocations for field trip. If by this date you have not informed her, we will be moving these monies to other school related needs.
Each teacher will receive 500 to order leveled books for your library. We encourage you to order high interest books for the levels where your library is not as complete, or leveled books to coordinate with your expeditions. Please fill a shopping cart at http://www.booksource.com/.
In addition to books from the district, the East Bay Children's Book Project gives up to 50 books a week per teacher.
Other possible ways to get books is Oakland's Temple Sinai's "People of the Book"
Beatrice to conduct informal short observations for all teaching staff.
Click on this link to view the sub release schedule, if you have not signed up-please do so immediately.
Grade level collaboration, please submit grade level notes via Google docs.
Supply requests due to Todd.
I created a new site for our running team to help raise money to Grow the Music Program at Manzanita SEED Elementary School! benefiting LOS AMIGOS DE MANZANITA SEED.
Please let me know if you won't be taking part in the running festival this time around.
Tech Corner - Check it out!
Thanks to Priscilla and Carl, we have a website. Check it out!


text:
Office History
SDNY Weekly Court Calendar
Reentry Program
Assistant U.S. Attorneys
Law Student Intern Program
Undergraduate Internships
Monitors, Receivers, Claims Admin
Report Crime
U.S. Attorneys » Southern District of New York » News » Press Releases
Rashan Michel Pleads Guilty In Manhattan Federal Court To Bribing Former Division I Men's Basketball Coach Chuck Person
Michel, an Atlanta-Based Business Owner, Facilitated Bribes To a Former Auburn University Men's Basketball Coach In Order To Secure College Basketball Players As Clients For Both Michel And a Financial Adviser
Geoffrey S. Berman, the United States Attorney for the Southern District of New York, announced today that RASHAN MICHEL, the owner of a bespoke clothing business in Atlanta, Georgia, pled guilty in Manhattan federal court today to agreeing to facilitate bribes from a financial adviser to Chuck Connors Person ("Person"), a former Auburn University men's basketball coach. The bribes were provided in exchange for Person using his influence over Auburn basketball players to retain MICHEL's services and the services of the financial adviser paying the bribes. MICHEL pled guilty before U.S. District Judge Loretta A. Preska.
Manhattan U.S. Attorney Geoffrey S. Berman said: "As he admitted today, Rashan Michel was paid to facilitate bribe payments from a financial adviser to college basketball coaches. His corruption of the system was significant but, sadly, far from unique. Indeed, in the last year this Office has convicted nine defendants in connection with fraud or bribery in the world of college basketball. We will continue to pursue those who offer or take bribes to influence student-athletes without regard to their interest."
According to the Complaint, the Indictment, statements made in court, and publicly available documents:
In the fall of 2016, MICHEL, the founder and operator of a clothing store that specialized in making bespoke suits for professional athletes, met a financial adviser and business manager who, unbeknownst to MICHEL, was providing information to law enforcement ("CW-1"). MICHEL told CW-1 that MICHEL could introduce CW-1 to several college basketball coaches, including Person, who was then a men's basketball coach at Auburn University, who would be willing to accept bribes from CW-1. MICHEL and CW-1 agreed to offer such bribes in return for the coaches' agreeing to exert their influence over student-athletes to retain the services of Michel and CW-1 once the student-athletes entered the National Basketball Association ("NBA").
In November 2016, MICHEL, who had a preexisting relationship with Person, arranged a meeting in Auburn, Alabama, to introduce CW-1 to Person and to broker the arrangement between CW-1 and Person whereby CW-1 would provide bribes to Person. At that meeting, in exchange for bribes, Person agreed to exert his influence over certain student-athletes Person coached at Auburn University to retain the services of CW-1 and MICHEL once those players entered the NBA. Over the next several months, in exchange for the bribes described above, Person did, in fact, arrange a meeting among CW-1, MICHEL and an Auburn student-athlete in Manhattan. At that meeting, Person falsely touted CW-1's qualifications as a financial adviser and business manager without disclosing that Person was, in fact, being bribed to recommend CW-1 to the student-athlete. In connection with the bribery scheme, Person also steered the parent of a second student-athlete to CW-1.
In addition to brokering the bribery scheme with Person, MICHEL also solicited and received for himself tens of thousands of dollars in payments from CW-1 in exchange for introducing CW-1 to Person, and for promising to introduce CW-1 to other basketball coaches at NCAA Division I universities to engage in a similar bribery arrangement. Ultimately, MICHEL did introduce one member of a university athletics department to CW-1 for the purpose of engaging in a similar scheme. Working with MICHEL, CW-1 made payments to that individual, who in turn attempted to steer the parent of a student-athlete to CW-1.
In all, CW-1 paid more than $91,500 in bribes to Person, and paid MICHEL $24,000 for his role in the scheme.
MICHEL, 44, of Atlanta, Georgia, pled guilty to one count of conspiracy to commit bribery. As a condition of his plea, MICHEL agreed to forfeit $24,000. The charge carries a maximum term of five years in prison. The maximum potential sentence in this case is prescribed by Congress and is provided here for informational purposes only, as any sentencing of the defendant will be determined by a judge. Sentencing is scheduled for September 18, 2019, before Judge Preska.
Mr. Berman praised the work of the Federal Bureau of Investigation and the Special Agents of the United States Attorney's Office for the Southern District of New York.
The case is being handled by the Office's Public Corruption Unit. Assistant United States Attorneys Robert L. Boone, Aline R. Flodr, Noah Solowiejczyk, and Eli J. Mark are in charge of the prosecution.
USAO - New York, Southern
Updated May 7, 2019
Youtube URL:
Follow us on YouTube...
Public Service Announcement on Sexual Assault in Public Housing
Giving back to the community through a variety of venues & initiatives.
Manhattan | Rockland
One St. Andrews Plaza - New York, NY 10007

redpajama_set_name: RedPajamaCommonCrawl


text:
Q: Checking Dataframe for Offsetting Values I have a list of transactions that lists the matter, the date, and the amount. People entering the data often make mistakes and have to reverse out costs by entering a new cost with a negative amount to offset the error. I'm trying to identify both reversal entries and the entry being reversed by grouping my data according to matter number and work date and then comparing Amounts.
The data looks something like this:

MatterNum
WorkDate
Amount

1
1/02/2022
10

1
1/02/2022
15

1
1/02/2022
-10

2
1/04/2022
15

2
1/05/2022
-5

2
1/05/2022
5

So my output table would look like this:
|MatterNum|WorkDate|Amount|Reversal?|
|---------|--------|------|---------|
|1|1/02/2022|10|yes|
|1|1/02/2022|15|no|
|1|1/02/2022|-10|yes|
|2|1/04/2022|15|no|
|2|1/05/2022|-5|yes|
|2|1/05/2022|5|yes|
Right now, i'm using the following code to check each row:
import pandas as pd

data = [
        [1,'1/2/2022',10],
        [1,'1/2/2022',15],
        [1,'1/2/2022',-10],
        [2,'1/4/2022',12],
        [2,'1/5/2022',-5],
        [2,'1/5/2022',5]
    ]
df = pd.DataFrame(data, columns=['MatterNum','WorkDate','Amount'])

def rev_check(MatterNum, workDate, WorkAmt, df):
    funcDF = df.loc[(df['MatterNum'] == MatterNum) & (df['WorkDate'] == workDate)]

    listCheck = funcDF['Amount'].tolist()
    if WorkAmt*-1 in listCheck:
        return 'yes'

df['reversal?'] = df.apply(lambda row: rev_check(row.MatterNum, row.WorkDate, row.Amount, df), axis=1)

This seems to work, but it is pretty slow. I need to check millions of rows of data. Is there a better way I can approach this that would be more efficient?

A: If I assume that a "reversal" is when this row's amount is less than the previous row's amount, then pandas can do this with diff:
import pandas as pd

data = [
        [1,'1/2/2022',10],
        [1,'1/2/2022',15],
        [1,'1/2/2022',-10],
        [1,'1/2/2022',12]
    ]

df = pd.DataFrame(data, columns=['MatterNum','WorkDate','Amount'])
print(df)
df['Reversal'] = df['Amount'].diff()<0
print(df)

Output:
   MatterNum  WorkDate  Amount
0          1  1/2/2022      10
1          1  1/2/2022      15
2          1  1/2/2022     -10
3          1  1/2/2022      12
   MatterNum  WorkDate  Amount  Reversal
0          1  1/2/2022      10     False
1          1  1/2/2022      15     False
2          1  1/2/2022     -10      True
3          1  1/2/2022      12     False

The first row has to be special-cased, since there's nothing to compare against.

redpajama_set_name: RedPajamaStackExchange


Everything was perfect!!! The owner/manager is a Really nice person!!!
Very comfortable, clean and beautiful houses! Hosts are very nice and helpful.
Great hospitality! High standart! Warm athmodphere!
Perfect place,spacious and clean.Million dollars view and terrace ideal to spend a whole day enjoying the view in peace.The beach which is close by could be reached through the hotel Melathron,but it's very clean and nice,with crystal water.Very nice and welcoming host.We got a drink for welcome and also allowed us to have a later check out without any problem.Strongly recommend.
Overall the property is perfect, nice place for a family time, clean place, fast wifi, polite and friendly staff. We enjoyed in full staying in this property.
Perfect location, very close to the sea, balcony with a beautiful view. Very clean and tidy place fully equipped and spacious. The internet connection was so fast that we could even watch movies on line. The owners are very hospitable always ready to help. They allowed us to stay longer at the day of departure without extra charge. The villa is an ideal place to feel comfortable, calm and relax. We really enjoyed our time there! We will definitely come again!!!!
Fantastic stay! The area is excellent with the sea very close to the villas. The beach is very well organized with umbrellas, deck chairs, bar, sandy beach inside and out with crystal clear water. The villa is very clean and fully equipped with almost everything. You feel like home. Kind and friendly hosts, always available in whatever you need. We highly recommend!
Lock in a great price for Aegean Residence – rated 9.6 by recent guests!
Just 350 feet from Flegra Beach, Aegean Residence offers a garden and a BBQ. Located in Kallithea Village, it features fully equipped units with spa bath and views over the Aegean Sea. Free WiFi is available in all areas.
Fitted with a fireplace and tastefully decorated, all air-conditioned villas of Residence have 3 or 4 separate bedrooms. Opening to a furnished patio, each consists of a living room with flat-screen, satellite TV and a kitchen with stove and dining area. A washing machine, a tumble dryer and an iron are included.
Guests may use the BBQ facilities offered at the property. A restaurant, a bar and a mini market for the basic supplies can be found within 350 feet.
A bus stop providing connection to several parts of the area is at a distance of 350 feet. Macedonia International Airport is located 41 mi away and Thessaloniki City is 53 mi away. Free private parking is possible at a location nearby.
When would you like to stay at Aegean Residence?
Το κατάλυμά μας είναι πολύ κοντά στη θάλασσα και στην αμμώδη παραλία της Κρυοπηγής. Προσφέρει ιδιωτικότητα και ηρεμία.
Μένουμε μέσα στο συγκρότημα και είμαστε πρόθυμοι να σας εξυπηρετήσουμε σε ό,τι πρόβλημα προκύψει και να σας δώσουμε πληροφορίες για την γύρω περιοχή.
Το κατάλυμά μας βρίσκεται δίπλα σε μίνι μάρκετ με φρέσκα φρούτα και λαχανικά.
House Rules Aegean Residence takes special requests – add in the next step!
Please inform Aegean Residence of your expected arrival time in advance. You can use the Special Requests box when booking, or contact the property directly using the contact details in your confirmation.
The noise from the street is loud but you get used to it in a day or two There is no direct path to the beach, however the distance is short.


text:
Join Joseph Cusick, Vice President of Wealth and Asset Management at MoneyBlock, as he discusses approaches for investing strategically long-term and tactically short-term. Joseph was previously the Senior Vice President of Education at optionsXpress, where he created and implemented education and media programs to help investors and advisers incorporate options as an equity portfolio management tool.
Prior to Charles Schwab's acquisition of optionsXpress, Joe lent his market expertise to help launch the firm's brokersXpress subsidiary, where he developed several risk-sensitive equity allocation and tactical derivative programs. Joseph is also a frequent contributor to various media outlets including The Wall Street Journal, Business Week, Barron's, CNBC, BNN and Bloomberg.
Tactical Series: New View on Selling Options into Market Strength
Joseph Cusick, VP of Wealth and Asset Management at MoneyBlock, explores the concept of buying into weakness (when the markets are moving down), and selling into strength (when the markets move up). Joe discusses a contrary approach to the popular opinion in which many investors, traders and advisors will buy assets showing strength, and sell assets showing weakness (a typical trend following approach). Original air date: 2/11/2015. Back to Investor Webcasts...


More than 100 kids will benefit from Montgomery County�s two-week focus on having deadbeat parents meet their child support obligations.
The first week involved a weeklong amnesty program in which arrest warrants were lifted for those who voluntarily came into the county�s domestic relations office to work out agreements on paying back support that they owed.
A total of 45 parents, owing $704,061 in arrearages, took advantage of the amnesty program, according to Rebecca Colantuno, domestic relations assistant director in charge of enforcement.
Some even brought cash, $1,279 total, although that was not a requirement of the amnesty program, said Colantuno.
Colantuno said that the 45 parents who came forward under the amnesty program are responsible for support of a combined 70 children.
Last week, a beefed-up contingent of sheriff�s deputies went out, rousting another 28 from their beds or on the job, bringing them in to county court for contempt of court hearings before Judge Rhonda L. Daniele for not paying court ordered child support.
These parents, owing a combined $288,454 for 38 kids, were sent to county lockup until they can come up with �purge� payments that Daniele set to have their contempt charges lifted. They could spend up to six months behind bars if they cannot meet the purge payment.
As of mid-afternoon Friday, 15 remained in county prison while the others put up a combined $13,519 in purge payments that will be applied to their arrearages.
�I think this dual approach program has been an absolute success,� said Deputy Joanne Plasterer, who supervised last week�s deadbeat roundup.
�This was truly a joint effort by everyone to do right by these kids,� said Plasterer, citing the collaborative efforts by the domestic relations office, the courts and the sheriff�s department.
Also included in that joint effort, said Plasterer, was the public, calling in with tips and new information on the whereabouts of the deadbeats.
Anyone who knows the whereabouts or has fresher addresses on these deadbeat parents should call the department�s warrants hotline at 610-278-3340 or fill out an email form on the sheriff�s Web page that can be found at www.montcopa.org.
People can find a list of those for whom bench warrants have been issued for back support under �domestic relations warrants.� The list includes the person�s name, the arrearages and the last good address the county had for these individuals.
The identity of the tipsters will remain confidential and can even be made anonymously.
Prior to initiating this two week program, the county had warrants for about 300 parents owing a combined $5.7 million in back support payment.
�Any new information we get is helpful because we are always out serving these warrants,� said Plasterer, whose warrant division also serves criminal bench warrants for defendants who miss their court hearings.


About the Author: Adwina Jackson is a wife and mother of a young boy. She's also the editor of Inspiring Parenting, an online source of valuable parenting information. Please visit Inspiring Parenting for helpful and free parenting info.


Prime Minister Trudeau, President Trump. The Trudeau and Trump Administrations continue to move toward negotiations to modernize the Columbia River Treaty.
As Canada and the United States start negotiations over the Columbia River Treaty, the University of Montana will host a conference to discuss the future of rivers flowing through western Montana.
"One River, Ethics Matter" will take place from 8 a.m. to 5 p.m. Wednesday, April 11, in the University Center Ballroom. The event is hosted by UM's Center for Natural Resources & Environmental Policy and the Department of Geography and is free and open to the public. Lunch is provided, and an evening reception will follow. Participants are required to RSVP at http://bit.ly/2EWa6yi.
Tribal, First Nations and religious leaders from the Upper Columbia River will lead the one-day conference on ethics and the past and future of the Columbia River. The conference series is a multiyear undertaking based on the Columbia River Pastoral Letter issued in 2001 by the 12 Northwest Roman Catholic Bishops of the international watershed, combined with tools used by hospital ethics consultation services.
Brian Lipscomb, Confederated Salish and Kootenai Tribes, CEO of Energy Keepers Inc.
"One River, Ethics Matter" will examine the moral dimensions of the dam-building era, focusing on U.S. Indian tribes and Canadian First Nations people, rivers and the life that depends on them, and the compelling need to add ecosystem-based function to the Columbia River Treaty.
Here was a place where tens of millions of wild salmon returned each year to spawn in forest and desert streams renewing a great cycle of life, a river where people's existence and culture from time immemorial depended on these returning salmon.
At the time of first contact between indigenous people and Lewis & Clark, and then later British explorer David Thompson, the Columbia River was perhaps the richest salmon river on earth.
In a few centuries – the blink of an eye – the forces of Manifest Destiny brought catastrophic change upon the indigenous peoples of the Americas. The dam-building era in the Columbia Basin was a part of colonial settlement and escalated resource extractions.
Dams, while bringing benefits for many, wrought massive environmental destruction and wrenching change for life that depends on the river. Without consulting tribes and First Nations, the federal governments of the U.S. and Canada along with the Provincial B.C. government negotiated the Columbia River Treaty and ratified it in 1964.
Not surprisingly for an international river treaty negotiated during the 1950s (and without including indigenous people in treaty decisions) the Columbia River Treaty has only two purposes: generating hydropower and flood risk management.
Given this history and unfolding climate change, tribes, First Nations, faith leaders, and NGOs are advocating that Ecosystem-based Function – river stewardship – be added to the Treaty as a third treaty purpose equal to hydropower and flood risk management.
Ecosystem-based Function includes passage for fish blocked by dams, reconnecting rivers to their floodplains, and stabilizing reservoir levels. Also central to the future of the Columbia River: who decides river management? To right historic wrongs requires that Canada and the United States expand river governance to include tribes and First Nations in multinational river governance.
– The Columbia River Watershed: Caring for Creation and the Common Good.
Ethics Conference SeriesRevelstoke 2017 – Overview | film Boise 2016 – Overview | Agenda Portland 2015 – Film | Overview | Agenda Spokane 2014 – Film | AgendaThe "One River, Ethics Matter" conference series focuses on the dam-building era's impacts on the Columbia River, modeled on South Africa's "Truth & Reconciliation Process" in response to another great injustice, apartheid.
These water-ethics conferences have two foundations: (1) the Columbia River Pastoral Letter by the Roman Catholic Bishops of the international watershed, and (2) tools used by hospital ethics committees. These conferences are interdisciplinary. They bring together tribal elders, historians, scientists, ethicists, faith leaders, and others to understand rivers through our history and as our responsibility.
The Séliš Ksanka Qlispé Project on the Flathead River, a federal license now held by the Confederate Salish and Kootenai Tribes, the first in the nation to own and operate a major hydropower facility.
The ethics conference will discuss ecosystem-friendly measures known as "Montana Operations" (including "VarQ" flood risk management) as possible models for future management of the dam system throughout the Columbia Basin to advance ethical principles of justice and stewardship.
The One River, Ethics Matter conference is free and open to the public. Lunch is provided to participants.


text:
The Attack at the Lower Sioux Agency was the first organized attack led by Dakota leader Little Crow in Minnesota on August 18, 1862 and is considered the initial engagement of the Dakota War of 1862. It resulted in 13 settler deaths, with seven more killed while fleeing the agency for Fort Ridgely.

Tensions had run high in the weeks leading up to the attack. Many eastern Dakota were angered by the refusal of traders to extend credit during a summer of starvation and hardship, and the failure of the United States Indian agents to deliver annuity payments as required by treaty. The initial attack on the Lower Sioux Agency by a faction of the eastern Dakota focused on the four trading stores, which they proceeded to raid for flour, pork, clothing, whiskey, guns, and ammunition.

The attack at the Lower Agency was followed by the Battle of Redwood Ferry. Violence soon spread to isolated farms and settlements in Brown and Renville Counties, with an estimated 200 settlers killed and another 200 captured. Some settlers' lives were saved after they were warned by the Dakota to flee.

Prelude
After the initial conflict at Acton Township, Minnesota on August 17, in which five white settlers were killed by four young Wahpeton Dakota hunters from Rice Creek village, tensions were running high. Similar incidents in the past had resulted in only the perpetrators being punished. However, "traditionalist" leaders such as Cut Nose, the "head soldier" of the soldiers' lodge, and Red Middle Voice, the head of the Rice Creek band, grasped that the situation presented an opportunity to lead an uprising against the Americans, who had withheld annuity payments and provisions during a summer of starvation and hardship for many eastern Dakota. They were also aware that the Americans were in the midst of their own Civil War, and were "getting short of men".

In the middle of the night, Red Middle Voice and his nephew, Chief Shakopee III (also known as Little Six), convened a council at Little Crow's house. Taoyateduta Little Crow was viewed as "the last of the major Mdewakanton chiefs to hold out against acculturation", whose support was essential to convincing others to go to war. Although Little Crow initially hesitated, warning that it was futile to go to war against the Americans, he eventually agreed to lead an uprising, and ordered an attack on the nearby Lower Sioux Agency the following morning.

On the morning of August 18, several traders happened to be away from the Lower Sioux Agency, including Nathan Myrick, Major William H. Forbes, and Captain Louis Robert, leaving others in charge of their stores.

Participants
In the early morning, a group of Dakota soldiers marched toward the Lower Sioux Agency, also known as the Redwood Agency. Dominant within the group were men from the villages of Red Middle Voice and Shakopee. They were joined by others from the villages of Mankato, Big Eagle, and Little Crow. Chief Wabasha III opposed the war and refused to lead a group. Several Dakota men and women went to warn their relatives and friends living in the vicinity.

Many leaders lacked control over their bands, as young braves acted without heeding their warnings. Historian Gary Clayton Anderson argues that the soldiers' lodge or  from Shakopee's village asserted authority in leading the attack, given Shakopee's inexperience as a leader, and the age of his elderly uncle, Red Middle Voice. Anderson also suggests that the pattern of killing seemed "selective", with those perceived as having insulted Dakota religion or medicine men, or who had refused to assist the Dakota with food or credit, targeted first. One young soldier, Tawasuota (Much Hail), was one of the first to attack.

Attack

On the morning of August 18, a large party of soldiers surrounded the Lower Sioux Agency, a settlement including the quarters of the Indian agent, other government personnel, traders' stores, barns, and other buildings. Separating into small groups, they surrounded the four trade houses at the Lower Agency, firing at once on signal.

The following were killed in the initial attack:

 James W. Lynd, a former state senator who was working as a clerk at Myrick's trading store. Lynd, who had a Dakota wife with whom he had two children, was the first to be killed. Tawasuota ran toward him, screaming, "Now I will kill the dog who would not give me credit."
 Andrew Myrick, the "most hated of the traders" for having refused the Dakota credit earlier that summer when they were starving. He was hit by two balls, one in the arm and one in the side. Myrick escaped from the post storehouse through an attic window, but was killed before he could reach cover. His corpse was later found with his mouth stuff full of grass. Many have interpreted this as retaliation for saying, "Let them eat grass."
 George W. Divoll, another clerk at Myrick's store, and "old Fritz", the cook. Both men were behind the counter when they were gunned down.
 Francois LaBathe, a trader of French and Dakota heritage, who was related to Chief Wabasha. LaBathe was killed in his own store.
 Joseph E. Belland and Antoine Young, clerks at William Forbes's store.
 Patrick McClellan, a clerk at Louis Robert's store.
 Alexis Dubuque, a clerk for either Forbes or Myrick.
Three unarmed government workers were killed on the order of Little Crow, when they confronted the Dakota soldiers in an effort to prevent them from stealing horses. These included A. H. Wagner, the superintendent of farms; John Lamb, the hostler; and Lathrop Dickinson. Philander Prescott, an elderly fur trader who had lived among the Dakota for forty years and had a Dakota family, was killed while running toward his house.

A total of thirteen victims were killed at the Lower Agency.

Escape and pursuit

Many of the Dakota soldiers proceeded to raid the trading stores for flour, pork, clothing, whiskey, guns, and ammunition. The attack was suspended long enough for as many as fifty to escape to the thickets below the bluff from the Dakota soldiers. From there, the civilians made their way toward Fort Ridgely, which was fourteen miles away. Some were helped across the river by the ferryman, whose name is disputed, before he himself was murdered; others fled by foot. One of the last to cross the river by ferry was Reverend Samuel D. Hinman, who fled by buggy after encountering Little Crow. Seeing Taoyateduta's sullen expression, Hinman had asked, "Crow, what does this mean?" and realized he was in danger when he received only a fierce glare in reply.

Nonetheless, seven more settlers were overtaken and killed while in flight. These included Dr. Philander P. Humphrey, the agency physician, his sick wife, and two of his children. Dr. Humphrey and his family were killed after they had crossed the river and gone four miles, stopping to allow his wife to rest when she was unable to continue. Only his twelve-year-old son, who had been sent to get water for his mother, survived and eventually reached the fort.

The life of George Spencer, a clerk at William Forbes's trading store, was spared after his friend Wakinyantawa, a veteran soldier, intervened and declared that Spencer was under his protection and should not be killed. Spencer, who had been wounded during the initial attack, was instead taken captive for the duration of the war, while William Bouratt, who was part-Dakota, was allowed to escape.

Aftermath
According to historian Marion P. Satterlee, approximately 85 people resided at the Lower Sioux Agency at the time of the attacks. In Massacre at the Redwood Indian Agency, he states that a total of 13 people were killed at the agency; another seven were killed while in flight. About ten were captured and 47 people escaped. Once the buildings of the Lower Agency had been emptied of their contents, they were torched and burned to the ground.

The hired ferryman who stayed at his post and ferried those who were fleeing was among the victims. Although a granite marker on the north side of the river gives his name as "Charlie Martel", various accounts have suggested that the name of the ferryman was Jacob Mauley or Hubert Millier. As the Dakota attackers started crossing the river in pursuit, Olivier Martell, the proprietor of the ferry, had mounted his horse headed for Fort Ridgely.

Further attacks

As refugees from the massacre started to arrive at Fort Ridgely, Captain John S. Marsh left the fort with a relief force of 47 men and headed toward the Lower Sioux Agency. Marsh and his men were ambushed in what has been called the Battle of Redwood Ferry.

The violence escalated as Dakota soldiers attacked isolated homesteads in Brown and Renville counties, killing an estimated 200 settlers and taking another 200 women, children, and part-Dakota civilians hostage. According to Anderson, "The erratic behavior of the  soldiers is indicative of the confusion that abounded, as no one seemed to be in charge."

Notes

References

External links
 Minnesota Historic Sites: Lower Sioux Agency

Lower Sioux Agency
Lower Sioux Agency
Redwood County, Minnesota
Lower Sioux Agency
August 1862 events

redpajama_set_name: RedPajamaWikipedia


The 24% lead crystal photo frame is traditional in design and features diamond cutting on either side of the frame. There is an engraving area above and below where the photo is displayed that can be personalised with any crest, logo or wording to create a gift that is sure to be treasured by the recipient. The frame holds a 4 x 6 inch photo and can stand vertically or horizontally.


text:
Summary and book reviews of A Map of Glass by Jane Urquhart
Summary | Excerpt | Reading Guide | Reviews | Beyond the book | Readalikes | Genres & Themes | Author Bio
A Map of Glass
by Jane Urquhart
Mar 2006, 375 pages
Generational & Family Sagas
Physical & Mental Differences
Jerome, a young artist on a remote island retreat, discovers the body of an old man, Andrew Woodman, frozen in the ice. One year after the body is discovered, Sylvia Bradley – a withdrawn, sheltered woman whose secret affair with Andrew changed her world forever – decides to learn more about her lover's mysterious disappearance. She flees to the overwhelming, unfamiliar city of Toronto on a quest to find Jerome. Once she does, they work together to uncover both the secrets of their own pasts and the story of Andrew's ancestors.
The eagerly anticipated new novel from the best-selling Canadian author of The Stone Carvers and The Underpainter.
Andrew Woodman stumbles through a snowstorm, slowly losing his strength, his language, and his memories of the once-familiar island landscape around him. When Jerome, a young artist on a remote island retreat, discovers the old man's body frozen in the ice later that winter, the rich narrative tapestry of A Map of Glass begins.
One year after Andrew's body is discovered, Sylvia Bradley – a withdrawn, sheltered woman whose secret affair with Andrew changed her world forever – decides to learn more about her lover's mysterious disappearance. She flees to the overwhelming, unfamiliar city of Toronto on a quest to find Jerome. Once she does, they work together to uncover both the secrets of their own pasts and the breathtaking story of Andrew's ancestors.
With her celebrated lyrical prose and haunting imagery, Urquhart's A Map of Glass is a skillful exploration of love, loss, and the transitory nature of place.
He is an older man walking in winter. And he knows this. There is white everywhere and a peculiar, almost acidic smell that those who have passed through childhood in a northern country associate with new, freshly fallen snow. He recognizes the smell but cannot bring to mind the word acidic. Snow, walking, and winter are the best he can come up with – these few words – and then the word older, which is associated with effort. Effort is what he is making; the effort to place one foot in front of the other, the effort required to keep moving, to keep moving toward the island.
It might have been more than an hour ago that he remembered, and then forgot, the word island. But even now, even though the word for island has gone, he believes he is walking toward a known place. He has a map of the shoreline in his brain; its docks and rundown wooden buildings, a few trees grown in the last century. Does he have the word for trees? Sometimes yes, but mostly no. He is ...
Please be aware that this discussion guide may contain spoilers!
Jane Urquhart doesn't title individual chapters, instead she divides her novel into three large sections: "The Revelations"; "The Bog Commissioners"; "A Map of Glass". Look at each of these sections and discuss why it is given that particular title. The name of the second section, "The Bog Commissioners," is at first mysterious because Joseph Woodman only stayed in Ireland as a bog commissioner for less than half a year. But something ...
BookBrowse Review
Urquhart continues her interest in unconventional art forms, a theme that has run through two of her previous novels, The Stone Carvers and The Underpainter, with a story that rewards the patient reader...continued
Full Review (337 words).
This review is available to non-members for a limited time. For full access, become a member today.
(Reviewed by BookBrowse Review Team).
Her story flies in too many directions, and is hamstrung by appallingly portentous, theme-driven dialogue. At her best, this writer commands an impressive range of varied literary skills. But here, simpler would have been better.
The book starts slowly and quietly but rewards patient reading; at play here are big themes about the impermanence of everything: relationships, memory, possessions, civilizations, and even the landscape.
Quill & Quire
A serious, mature novel abundantly displaying the skill Urquhart has built up over decades in her poetry and prose.
Starred Review. Urquhart's passion for the past is at full poetic play in this intricate story of love, loss and memory.
Winnepeg Free Press
She displays a masterful command of language and a grasp of the complexities that form the tapestry of each person.
Jane Urquhart was born in the small northern Ontario mining community of Little Long Lac and spent her later childhood and adolescence in Toronto.
She has published three books of poetry (I'm Walking in the Garden of His Imaginary Palace, False Shuffles, and The Little Flowers of Madame de Montespan), six novels (The Whirlpool, Changing Heaven, Away, The Underpainter, The Stonecarvers and A May of Glass), and a collection of short fiction (Storm Glass) as well as numerous articles and reviews.
Her books have been published in many countries, including Holland, France, Germany, Britain, Scandinavia, Australia, and The United States, and have been translated into several languages.
This "beyond the book" feature is available to non-members for a limited time. Join today for full access.
More books by Jane Urquhart
If you liked A Map of Glass, try these:
Told from Frank's perspective forty years after that fateful summer, Ordinary Grace is a brilliantly moving account of a boy standing at the door of his young manhood, trying to understand a world that seems to be falling apart around him.
This is a tender, brutal book about loving a person we cannot save. It is about loyalty, and about being lifted up by the sheer effervescence of someone who knew how to live life to the fullest.
by Robert Jones Jr.
A stunning debut novel about the forbidden union between two enslaved young men on a Deep South plantation.
Be careful about reading health books. You may die of a misprint.


Slab and Beam Form Work installation activities in our construction site in August 2016.
Reinforcement Work site activities of Building A & B on 5th Floor which completed.
Mixed-Concrete was tested at site before casting building A & B Structure, Slab and Beam.
Pipe for electricity in 5th Floor Slab was laid and our engineer checking strictly on MEP works to be ready for concreting.
Concrete Work for 5th Floor Level of Building A & B was completed in August 2016. This is level checking after casting concrete.
Plastering work in our site for our mock up unit in building A already start in this August.
MEP work in our site for our mock up unit in building A also started in this August.


text:
Servest's managing director of Security achieves OBE status
By Suzanne Hyde6th January 2017Awards & Achievements, News, Security, Show on Homepage
Servest Group's Security MD, Jason Etherington, has been awarded an OBE for his career achievements to date.
Prior to joining Servest in 2016, Etherington had commanded at every level up to Colonel in the Ministry of Defence (MoD), serving the country in all corners of the globe. In the last decade, he successfully grappled with the unique challenges of Apache helicopter operations, as well as operational and structural changes never faced before by the Force, the OBE recognises his vital contribution to date.
Etherington's inclusion on this year's Honours list is testament to the fact that he is recognised by international partners as setting the benchmark.
As managing director of Servest Security, a £28M man guarding and security systems business, Etherington continues to share his comprehensive management and leadership experience and MoD understanding with the wider team. His priority is to improve the service offering and working relationships across the entire security division and Servest Group.
"We are delighted to hear of Jason's outstanding achievement," commented Rob Legge, Group CEO. "Jason's OBE further demonstrates his expertise, experience and dedication. The insight that Jason brings to the team is invaluable and I know that this will be a contributing factor in our continued success."
Etherington said: "This award is a source of great pride: I'm truly humbled to receive the Queen's honour and recognise that I have been fortunate to have been supported by exceptional teams throughout my previous career."


Making a room or dormitory bed booking at Marco Polo Top Ho(s)tel Budapest on a low rate is fast and easy: choose our on-line booking option to get an instant confirmation after entering your credit card details into the system, or us an e-mail : our sales colleagues will be at your help and answer your request within 24-hours.
Marco Polo Top Ho(s)tel is an ideal place for both individuals and groups with the private rooms and the dormitories, offering high quality hostel services but low hostel rates.
Make an individual booking for less then 15 people for a private room or for a dormitory bed.
Group bookings for students and adults alike apply for at least 15 people together.
Watch out for our special seasonal promotions to save more money on your Budapest stay!


Patients diagnosed with certain types of bladder cancers may be suitable for bladder washouts using chemotherapeutic agents to try to reduce the risk of recurrence of further tumours. Recurrence of bladder tumours is common. Frequent cystoscopies to identify and destroy recurrent tumours are therefore required to reduce the risk of the cancers progressing to more aggressive tumours. If recurrent tumours become a problem, bladder washouts (intravesical therapy) usually involve 6 treatments over a 6 week period (1/week, each lasting 1-2 hours). A catheter is placed in the bladder and the agent introduced and left in the bladder for 1 to 2 hours. There are different agents available and the particular agent will depend on the type of tumour that you have. These treatments are usually tolerated very well. Patients sometimes experience bladder discomfort with frequency and urgency and occasionally bleeding. If patients are particularly uncomfortable the treatment program can be deferred for a week to allow the bladder to settle down. A cystoscopy will be required about 8 weeks after the treatment. Maintenance treatments are often arranged periodically to keep the cancers under control. If tumours continue to recur, more aggressive treatment may be indicated.
If your bladder tumour has been found to invade into the muscle wall of the bladder the standard treatment is to remove the bladder completely and to divert the urine. The usual form of diversion is called an ileal conduit. A 15cm to 20cm segment of small bowel is isolated and separated from the rest of the small intestine. The ureters that drain urine from the kidney are plugged into one end of the isolated segment with the other end being sutured to the skin of the abdominal wall allowing the urine to drain into a bag that is attached around the opening on the skin. This is major surgery and will require the patient to be in Hospital for 7 to 10 days. If the tumour was completely confined to the bladder the cure rates are very high. Usually, additional therapy is not required.
Cystectomy is now being performed by Robotic minimally invasive techniques. This greatly limits the morbidity of open surgey and reduces the hospital stay.
An alternative to an ileal conduit is to have a Neobladder (new bladder) created out of small bowel. This negates the need for a bag attached to the skin of the abdomen and in many cases the neobladder functions virtually as a normal bladder. In this procedure the bladder is removed as for a normal cystectomy. A longer segment of small bowel is isolated and can be used to create a functional bladder. The ureters are sutured into the top of the neobladder that will then store urine as a normal bladder does. The patient then learns to void and in most cases will function quite normally. Patients undergoing formation of a neobladder need to be motivated and dextrous. Patients will need to learn to catheterise themselves which may be required in certain circumstances if mucous formed by the bowel restricts the flow of urine. Intermittent self catheterisation may also be required to help empty the bladder if it does not empty adequately. Most patients are suitable for neobladders but this requires detailed discussion with your Urologist to be able to give you all the relevant information required to manage your new bladder.


text:
ENTERTAINMENT News ›
The Prosecutor's office will investigate the leaking of documents 'quitalazos' in a police station of Mossos
Haberkip	The public Prosecutor Superior of Catalonia has completed its investigation of the Mossos d'esquadra that identified several activists who were stripped of sym
The public Prosecutor Superior of Catalonia has completed its investigation of the Mossos d'esquadra that identified several activists who were stripped of sym
The public Prosecutor Superior of Catalonia has completed its investigation of the Mossos d'esquadra that identified several activists who were stripped of symbols and material independence, as ties yellow, on the night of 17 August 2018, in the towns of Mora la Nova, Tivissa and Vandellos. Despite filing the majority of the actions reported by Boost Citizen and some citizens, the Public Ministry has forwarded the proceedings to the Prosecutor's office Provincial of Tarragona to initiate an investigation of the filtration of data in social networks on planes commandeered to the 'quitalazos' identified.
In this regard, the deputy prosecutor of Catalonia, Pedro Ariche, believes that he could commit a crime of revelation of secrets committed by a public official, in particular by someone in the police station of Mora d'ebre of the Mossos, although without specifying the person who could perpetrate. That's why requests to the office of the Prosecutor of Tarragona, the completion of the research, since that has conferred those powers.
In his decree, the prosecutor believes that it is "an objectively serious, and that transcends the limits of the merely disciplinary" that is filtered this documentation that carried the 'quitalazos'. He felt, however, that you can not prove that the personal data of the activists identified as well as that one of them was a member of the Civil Guard were filtered by public officials.
from the reports of the Mossos, the prosecutor concludes that the condition of agent of the Guardia was known by several people "from the first moment the facts by a multitude of people, even some from outside the Body of the Mossos d Esqueadra". The same thing happens with the personal data of other activists who denounced hostigamento or threats by the networks when they spread their names. The prosecutor notes that the Autonomous inquired this possible filtration by analyzing the network without results by indicating that "his patent lack of collaboration has just frustando the good end of the investigation."
with Respect to the plans, with indications on various populations that carried the activists, which is included in the packed court, the prosecutor concludes that the filtering on social networks, "was carried out or facilitated by officers of the Cos de Mossos d'esquadra, attached to the police Station of Mora d'ebre. A out he said that with the mobile phone that is rotated among the shifts made pictures of the flat, but denied its dissemination.
On the police report and del17 of August after the intervention in Mora La Nova and the identification of suspects, the prosecutor believes that "police management of the incident is at least unfortunate, not to say that cosntituye an authentic nonsense" because the police officers were assured that the withdrawal of symbology-partisan, as independence is "illegal action". A court of Falset already closed the case opened against the 'quitalazos' from the report of the Mossos.
Finally, the Prosecutor's office an eyesore to the Department of Interior that difundiese by the social networks that the 14 identified could be sanctioned with the application of "serious" citizen security law, and that not desmintiese "the false perception that certain paramilitary groups ideology campaban" for the county to say nothing of the alarm you created. In this sense, the Public Ministry, notes that when it issued the message, the police report was not finished and that the infringement could be "mild" and not "serious".
For the fiscal "the Department of the Interior are allowed, with the occasion of a trivial incident of identification of a people that 'made noise', withdrew the determined symbology of the public highway, carrying, in the end, the same tools or tooling used by those who have previously located, and, in your case, 'striped' metal sign of a private nature and installed in public place", in reference to the "Municipi Adherit to the Associació de Municipis per la Independència, to "send a message conminatorio for the citizens, especially those committed dates." In concrete details that the Government had a "lack of objectivity" because it suggested to him that the people involved in remove symbology party would be "severely punished". However, the Prosecution believes that this attitude is not a criminal offence but of a "reproach to the plane of the action partisan politics".
Publish Date : 21 Aralık 2018 Cuma 20:00
Try your luck in the DC Universe playing the...
The Mobster Who Infiltrated Hollywood For The...
The witness, who had welcomed Morate in Romania:...
Beltrán de Heredia claims that assume the errors...
A commission "non-permanent" to investigate the...
Vegans against antiveganos: so shall the war...
She says that the Osakidetza wants to "legitimize"...
The Prosecutor's office of the U.S. investigates...
The Internet: a New Year's resolution
The Prosecutor's office will investigate the...
Jorge Illegal: "We deserve the 'Gag law' by not...
Pablo Alborán: "Peté in full concert and I...


It has been MANY many months in the planning and discussion stages, and has been a couple of months in the development stages. But finally, it is here. Metroid in Motion is a unique and SCU Exclusive 2 Disc DVD set produced to play on proper DVD players on your TV. The 2 Disc DVD set consists of not only of a world record speed run from each of the Metroid games, but it's also crammed to the hilt with LOADS of extra clips (such as various TV ads, glitch movies and Secret World Movies).
The set is produced in both PAL and NTSC variants to ensure that as many people can watch the DVD's with the minimum of hassle. With "interactive menus" (chapter search etc) it functions just like a professionally produced DVD. Disc 1 contains runs from: Metroid (29mins 10secs), Metroid 2 (1hr 2mins) and Metroid Prime (1hr 4mins). As well as this on Disc 1, there are around 25 extra movie clips, including TV ads, Prime art galleries (with music), Prime 2 trailers and Beta footage of Prime 1.


Geoengineering Creating Freeze Fry Extremes.
Global climate engineering operations are creating ever more extreme weather and temperature whiplash scenarios. The immense scale of climate forcing being carried out by the geoengineers is wreaking havoc on the biosphere. Over 70 years of covert climate intervention and weather warfare (along with countless other forms of anthropogenic activity) has done unimaginable damage to the planet's life support systems. The blowback is already unfolding and will get rapidly worse. The extreme and unprecedented temperature imbalances already occurring in the US, and forecasted (scheduled) to occur, are beyond alarming. The 15 minute video below exposes some of the most primary agendas of the ongoing climate engineering operations.
Author adminPosted on 2017-09-29 2017-09-29 Categories Health & HealingTags global climate, weather changesLeave a comment on Geoengineering Creating Freeze Fry Extremes.


text:
Lunac is een gemeente in het Franse departement Aveyron (regio Occitanie) en telt 462 inwoners (1999). De plaats maakt deel uit van het arrondissement Villefranche-de-Rouergue.

Geografie
De oppervlakte van Lunac bedraagt 19,0 km², de bevolkingsdichtheid is 24,3 inwoners per km².

Demografie
Onderstaande figuur toont het verloop van het inwonertal (bron: INSEE-tellingen).

Externe links

Gemeente in Aveyron


The Region 5 Regional Early Childhood Committee (RECC) will hold its regular meeting on Monday, Sept. 10, in Twin Falls. Agenda highlights for the meeting include nominations for a new committee co-chair, an overview of the Regional Early Childhood Summer Leadership meeting in Boise, and a discussion of outreach activities for 2018-2019. Read the full agenda here.
Where: 803 Harrison St., Twin Falls, Idaho.


text:
DTH company artist Amanda Smith and former company artist Da' Von Doane in Darrell Grand Moultrie's "Harlem On My Mind." Dave Andrews, Courtesy Lincoln Center
Lincoln Center's BAAND Together Dance Festival Showcases Five Major NYC Dance Companies
Kyra Laubacher
What happens when five of New York City's largest dance companies join forces? BAAND Together Dance Festival: five-nights of outdoor performances by Ballet Hispánico, Alvin Ailey American Dance Theater, American Ballet Theatre, New York City Ballet and Dance Theatre of Harlem. Held at Lincoln Center's outdoor Restart Stage in Damrosch Park, the program runs August 17–21. It features five different mixed bills of celebrated repertoire, including Alvin Ailey's Revelations, Annabelle Lopez Ochoa's Línea Recta, Justin Peck's In Creases, Kyle Abraham's Ces noms que nous portons and more. The festival also includes five dance workshops, one led by each performing company.
Since the pandemic's onset, leaders from these organizations have conducted weekly or biweekly meetings focused on supporting each other and the city's arts community. Plans for BAAND developed early on as an opportunity for artistic partnership. In an interview, Ballet Hispánico artistic director and CEO Eduardo Vilaro reflected on the groups' commitment to collaboration and solidarity with one another: "It's remarkable because as artistic directors, it can often be lonely and siloed. Coming together during this time of loss and insecurity was essential."
NYCB principal Taylor Stanley in Justin Peck's "In Creases." Paul Kolnik, Courtesy Lincoln Center
Dance Theatre of Harlem company member Amanda Smith is excited to perform in the company's first live show in New York City since the beginning of the pandemic. "It will be magical to be outside and see the audience members' faces," she says. "We'll really be able to feel everyone's energy—I think the city deserves a gift like this." Smith will be dancing in Dianne McIntyre's Change. She will also partner with Anthony Santos in the opening night performance of Darrell Grand Moultrie's Harlem on My Mind pas de deux.
With three BIPOC-led companies and a diverse array of choreographers represented, Vilaro hopes that BAAND will also inspire dancers, leaders and dance enthusiasts to catalyze further action toward equity and allyship. "Our message is unity in diversity," he explains. "We have a responsibility as citizens and artists, but we can't do it alone. It makes you think, How else can we share?"
Ballet Hispánico's Melissa Verdecia in Anabelle Lopez Ochoa's "Línea Recta." Paula Lobo, Courtesy Lincoln Center
BAAND will be Smith's first large-scale festival. She is looking forward to sharing the stage with fellow dancers and hopes it will continue as an annual event. "At the end of the day, we have to come together as a dance community," she says. "I'm hoping that in the future, we'll be closer and do more collaborations as companies together!"
For more details, including ticket and venue information, visit the Lincoln Center website.
Tamara Rojo Presents Her New Adaptation of "Raymonda" at English National Ballet
April Deocariza
Festival Ballet Providence Presents a Sparkly New "Nutcracker"
What to Watch: Jeremy McQueen's "WILD" Examines the Juvenile Justice System
Ilena Peng
Beyond "The Nutcracker": 6 Other Ballet Events to Catch This December
More Onstage


text:
Q: SQL Multiple values from same column with inner join I am looking to join data from one table to another. The problem I have is in table two, the data I need is in the same column.
This is using wordpress/woocommerce DB so as you may be aware a lot of the user data is stored in the user meta table and you extract it by selecting the meta value where meta key = something
Rough data structure for user meta table
id | user_id | meta_key | meta_value

Now I select from table 1, inner join to table 2 and use the IN operator to select the meta values I want based on meta_key
 select wp_xxxxxx_users.ID, wp_xxxxxx_users.user_email, wp_xxxxxxxxx.meta_value
    from wp_xxxxxx_users
    INNER JOIN wp_xxxxxx_usermeta on wp_xxxxxx_users.ID=wp_xxxxxx_usermeta.user_id
    WHERE wp_xxxxxx_usermeta.meta_key IN ('last_name', 'first_name')

Now this returns all the data fine but in this format
id | user_email | meta_value

So what's wrong? Well I would like the meta_value columns to appear on the same row rather than multiple rows
I want the output to do the following
id | user_email | metavalue-first_name | metavalue-last_name

As it's currently outputting like so
1 | test@test.com | first name
1 | test@test.com | lastname name
2 | test1@test.com | first name
2 | test1@test.com | lastname name

I have a looked around relevant threads and seen people accomplishing this by Group By but I couldn't get it to work
Version is MySQL 5.7.27

A: You can do it if you group by ID, user_email and use conditional aggregation:
select
  u.ID, u.user_email,
  max(case m.meta_key when 'first_name' then m.meta_value end) first_name,
  max(case m.meta_key when 'last_name' then m.meta_value end) last_name
from wp_xxxxxx_users u inner join wp_xxxxxx_usermeta m
on u.ID = m.user_id
where m.meta_key IN ('last_name', 'first_name')
group by u.ID, u.user_email

A: You didn't give any data.
So this tables
 CREATE TABLE wp_xxxxxx_users  (
   ID  int ,  user_email varchar(20));
 INSERT INTO wp_xxxxxx_users  (id,user_email) VALUES
   (1,'test@mail.de'),
   (2,'test1@mai.de'),
   (3,'test2@mail.de');

CREATE TABLE wp_xxxxxx_usermeta
  (`ID` int, `user_id` int, `meta_key` varchar(14), `meta_value` varchar(12))
;

INSERT INTO wp_xxxxxx_usermeta
  (`ID`, `user_id`, `meta_key`, `meta_value`)
VALUES
  (1, 1, 'last_name' , 'Dallas' ),
  (2, 1, 'first_name' , 'Kermit' ),
  (3, 2, 'last_name' , 'Huston' ),
  (4, 2, 'first_name' , 'Piggy' ),
  (5, 3, 'last_name' , 'Oklahoma' ),
  (6, 3, 'first_name' , 'Beep' )
;

This Select statement
SELECT
  wpu.ID
  ,wpu.user_email
  , wpm.last_name
  ,wpm2.first_name
FROM wp_xxxxxx_users wpu
INNER JOIN
(SELECT meta_value as last_name, user_id FROM
  wp_xxxxxx_usermeta Where meta_key = 'last_name') wpm
  ON  wpu.ID=wpm.user_id
INNER JOIN (SELECT meta_value as first_name, user_id from
 wp_xxxxxx_usermeta WHERE meta_key = 'first_name') wpm2
 ON  wpu.ID=wpm2.user_id
;

or you can use
Select       wpu.ID
  ,MAX(wpu.user_email),
  MAX(CASE WHEN wpm.meta_key = 'last_name' THEN wpm.meta_value END) last_name,
  MAX(CASE WHEN wpm.meta_key = 'first_name' THEN wpm.meta_value END) first_name
  From wp_xxxxxx_users wpu inner join wp_xxxxxx_usermeta wpm
  ON  wpu.ID=wpm.user_id
  WHERE  wpm.meta_key in ('last_name','first_name')
  GROUP by wpu.ID;

gives you following result
ID  user_email      last_name   first_name
1   test@mail.de    Dallas      Kermit
2   test1@mai.de    Huston      Piggy
3   test2@mail.de   Oklahoma    Beep

You find here an example


On average this build a deck project costs $7500 in Bremen, AL. Depending on your contractor, prices can range from $3490 to $12000. When pricing out your build a deck project make sure to get at least 3 quotes to compare prices and get the best value.
See attached pics of our most recent new decks and modified/repaired stained decks.


text:
.cr-dialog-container {
  -webkit-box-align: center;
  -webkit-box-pack: center;
  -webkit-transition: opacity 250ms linear;
  -webkit-user-select: none;
  display: -webkit-box;
  height: 100%;
  left: 0;
  overflow: hidden;
  position: absolute;
  top: 0;
  width: 100%;
  z-index: 9999;
}

.cr-dialog-frame {
  -webkit-box-orient: vertical;
  -webkit-box-shadow: 5px 5px 5px rgba(100, 100, 100, 0.5);
  background-color: white;
  border: 1px solid rgba(0, 0, 0, 0.3);
  border-radius: 3px;
  box-shadow: 0 4px 23px 5px rgba(0, 0, 0, 0.2),
              0 2px 6px rgba(0, 0, 0, 0.15);
  cursor: default;
  display: -webkit-box;
  padding: 14px 17px;
  position: relative;
  width: 460px;
}

.cr-dialog-frame:focus {
  outline: none;
}

@-webkit-keyframes pulse {
 0% {
   transform: scale(1);
 }
 40% {
   transform: scale(1.02);
  }
 60% {
   transform: scale(1.02);
  }
 100% {
   transform: scale(1);
 }
}

.cr-dialog-frame.pulse {
  -webkit-animation-duration: 180ms;
  -webkit-animation-iteration-count: 1;
  -webkit-animation-name: pulse;
  -webkit-animation-timing-function: ease-in-out;
}

.shown > .cr-dialog-frame {
  transform: perspective(500px) scale(1)
                     translateY(0) rotateX(0);
  opacity: 1;
}

.cr-dialog-frame {
  transform: perspective(500px) scale(0.99)
                     translateY(-20px) rotateX(5deg);
  -webkit-transition: all 180ms;
  -webkit-transition-duration: 250ms;
  opacity: 0;
}

.cr-dialog-shield {
  -webkit-transition: opacity 500ms;
  background-color: white;
  bottom: 0;
  display: block;
  left: 0;
  opacity: 0;
  pointer-events: none;
  position: absolute;
  right: 0;
  top: 0;
}

.shown > .cr-dialog-shield {
  -webkit-transition: opacity 500ms;
  opacity: 0.75;
}

[hidden] {
  display: none;
}

.cr-dialog-title {
  -webkit-margin-end: 20px;
  display: block;
  font-size: 120%;
  font-weight: bold;
  margin-bottom: 10px;
  white-space: nowrap;
  word-wrap: normal;
}

.cr-dialog-text {
  margin: 13px 0;
}

.cr-dialog-text,
.cr-dialog-title {
  overflow: hidden;
  text-overflow: ellipsis;
}

.cr-dialog-frame input {
  -webkit-box-sizing: border-box;
  width: 100%;
}

.cr-dialog-buttons {
  -webkit-box-orient: horizontal;
  -webkit-box-pack: end;
  display: -webkit-box;
  padding-top: 10px;
}

.cr-dialog-close {
  background: url(chrome://theme/IDR_CLOSE_DIALOG) center no-repeat;
  display: inline-block;
  height: 44px;
  opacity: 0.7;
  position: absolute;
  right: 0;
  top: 0;
  width: 44px;
}

.cr-dialog-close:hover {
  background-image: url(chrome://theme/IDR_CLOSE_DIALOG_H);
}

.cr-dialog-close:active {
  background-image: url(chrome://theme/IDR_CLOSE_DIALOG_P);
}

redpajama_set_name: RedPajamaGithub


The most beautiful places on the planet, a thousand cultures to discover, the pleasure of being outdoors, the emotion of taste and a sense of sharing: that's the backdrop we use to create the most beautiful vacations possible in several places like Thailand, Japan or more.
One thing we pride ourselves on, here at Club Med, is the authentic cuisine available at our all-inclusive resorts. From delicious fresh seafood to tantalising desserts, you can rest assured there is something matching everybody's taste.
Whether you're a a first-timer or an experienced rider, we offer other fabulous activities in the best destinations on the planet in our all-inclusive resorts, with specialist GO's. Group lessons or accessible to all, with or without a coach, your package opens the doors to a whole new world at the most incredible spots… and it is all-included.
Go after those pesky little tensions, gently rediscover muscles you forgot you had, learn how to breathe again…Between the care offered in our Spas and the relaxation activities included in your package, you have everything you need to let yourself be carried away.


text:
Ram Malla, also known as Kshetra was the thirty-third king of Mallabhum. He ruled from 1185 to 1209 CE.

History
Ram Malla strengthened the military power of his state.

References

Sources

Malla rulers
Kings of Mallabhum
12th-century Indian monarchs
13th-century Indian monarchs
Mallabhum


text:
The Torres Gonzalo Jiménez de Quesada ("Gonzalo Jiménez de Quesada Towers") is a residential complex composed of five towers of equal height in the centre of the Colombian capital Bogotá. The buildings are situated in the neighbourhood (barrio) Las Aguas, in the northeast of La Candelaria.

Etymology
The towers are named after the Spanish conquistador Gonzalo Jiménez de Quesada, who after the expedition into the Andes and conquest of the Muisca was the first governor of the New Kingdom of Granada and the founder of Bogotá on August 6, 1538.

Description
The Torres Gonzalo Jiménez de Quesada were constructed as part of the urbanization project in the late 1960s and 1970s. They are locates in the centre of Bogotá; the locality La Candelaria. The complex of the five residential towers, each  in height, consists of 390 apartments, next to the Universidad de los Andes. The towers are the highest buildings in the historical centre of the Colombian capital.

At the base of the towers, a mural has been drawn.

See also

 Gonzalo Jiménez de Quesada
 BD Bacatá

References

Bibliography

External links

Buildings and structures in Bogotá