text:
Recent Activity
In its newest five-year "roadmap" for justice and home affairs policy, the European Union has made migration a priority area. But while the Stockholm program offers plenty of detail on issues like illegal migration and asylum, it offers few specifics as to the final goal. MPI's Elizabeth Collett analyzes the program's action points and looks at challenges facing its implementation.
Over the past year, long-standing discussions and negotiations have resulted in several new information-sharing initiatives that seek to boost security while facilitating travel for legitimate travelers.
Swiss voters strongly approved a popular initiative to ban the construction of minarets in Switzerland. Julie Schindall reports on reaction to the vote and explains how the Swiss system makes such lawmaking possible.
The global recession has caused countries that once welcomed foreign workers by the tens and hundreds of thousands — particularly Spain — to rethink generous immigration policies as unemployment rates have risen.
Many countries relied on low-skilled immigrant workers during good times. But Japan, Spain, and the Czech Republic have recently introduced "pay-to-go" programs to reduce the number of unemployed immigrants. MPI's Kristen McCabe, Serena Yi-Ying Lin, and Hiroyuki Tanaka, and Piotr Plewa of the European University Institute examine these programs and the larger policy questions they raise.
Recent Activity
Diasporas can play an important role in the economic development of their countries of origin or ancestry. Beyond their well-known role as senders of remittances, diasporas also can promote trade and foreign direct investment, create businesses, spur entrepreneurship, and transfer new knowledge and skills. Policymakers increasingly recognize that an engaged diaspora can be an asset — or even a counterweight to the emigration of skilled and talented migrants.
Circular migration has typically been viewed with skepticism by migrant-rights advocates and wary publics alike. But many experts and policymakers in the migration field — and some in development — have come to recognize that well-managed circulation that is respectful of migrants' human and labor rights can bring benefits to countries of origin and destination, as well as to migrants themselves. For countries of origin, circular migration can relieve labor surpluses; for destination countries, it can provide the flexibility to quickly overcome skills shortages while adapting to long-term labor market shifts. For migrants, circular migration offers the opportunity to earn higher wages and gain international experience.
This report provides an overview of the global trends in the recognition of foreign credentials, and describes new and flexible ways that governments can recognize the qualifications of immigrants.
This report explains the basic structure of the engineering workforce, and the elements that influence the ability of engineers to move across borders. It examines recent efforts to address national differences in education and accreditation, and also considers how serious the barriers to international migration for engineers are in practice.
This edited volume develops a pragmatic approach to the engagement of highly skilled members of the diaspora for the benefit of their countries of origin. The book, edited by a World Bank senior economist, is based on empirical work in middle-income and high-income economies.
Immigrant-receiving countries have introduced a range of policies to improve the recognition of foreign qualifications. This report explores strategies for ensuring that qualified immigrants can contribute their training and talent to the labor force.
This policy brief explores the relationship between environmental change and migration to Europe in light of recent scholarship challenging the notion that environmental change triggers mass migration. It presents an overview of European policy response in this area and summarizes the spectrum of proposed solutions.
This MPI event discussed the Dutch model for fighting human trafficking and the strategic and operational dilemmas that public prosecutors in the Netherlands face.


text:
Product / project engineer (18 month contract)
WEBRECRUIT — Galway
product / project engineer (18 month contract) galway, co galway ?excellent doe working with some of the world's most successful medical device companies, our client provides medical solutions that improve the lives of patients. they are now looking for a product / project engineer to join their team on an 18 month contract basis. if you have experience of leading npi projects and strong autocad and solidworks skills, this is a superb opportunity to undertake a challenging contract with an excel[...]
Job Type: / Full-time

subset: commoncrawl


text:
I was wondering if you guys could help some trouble with a query in MYSQL. I have a sales table, a cashbox table and a store table, and I need to get the last sale of each store.
Sales ----- #ID Sale //UNIQUE RANDOM IDENTIFIER NOT SEQUENTIAL #FK Cashbox Date Amount Cashbox ------- #ID Cashbox FK Store Number Store ------- #ID Store Name
SO basically in the sales table it is reported the amount the date and the cashbox in which the sale was made, I need to get as I said before the last sale from each store, the problem I'm facing is the query I'm running is too slow (around 6 secs) because (I think) the join with the sales table run through the whole table and it has 2 million+ records.
Here's the query I have:
SELECT st.name,MAX(s.date) as date
FROM store st
JOIN cashbox c ON c.id_store = st.id_store
JOIN sales s ON s.id_cashbox = c.id_cashbox AND c.id_store = st.id_store
GROUP BY st.id_store
ORDER BY date DESC;
//fixed typo //EXPLAIN
ID select_type table type possible_keys key key_len ref rows extra
1 SIMPLE t index PRIMARY,id_store PRIMARY 4 (null) 443 Using where; Using temporary; Using filesort
1 SIMPLE c ref FK_id_cashbox,FK_id_store FK_id_tienda 4 pb.t.id_store 1 Using index
1 SIMPLE v ref id_cashbox id_cashbox 4 pb.c.id_cashbox 2011
I've tried different join orders and this is the one that runs faster, I was wondering if you could help me with the performance issue or if there's a better way to do it.


text:
Biggest fear realised
Mayor's family miss his home cookingMARY-JO TOHILL
Relevant offers
When Bernice Lepper's husband Tony became Central Otago district's new mayor two years ago, her biggest fear was that she would lose her cook.
To a large extent that is exactly what happened, because home life has definitely changed, with a husband more used to heading off to work in his gumboots now just as likely to leave the house in a suit, and not get home until late.
However, he still cooks, regretfully not as often, according to the Lepper's two children Blake, 25, and Brie, 23.
"I used to be good, but I'd got out of the habit and the kids tell me I'm hopeless and they much prefer Tony," Mrs Lepper, known as "Bernie", said.
Re-visiting her cooking skills is just one of several things she has had to come to grips being married to the mayor.
"I'd never saw myself as a mayoress. It just didn't seem 'me.' But actually I'm really enjoying it. It's a privilege."
As a third generation Clyde-Earnscleugh-ite, the eldest daughter of Peter and Wilma Paulin, she has comes from a family with strong community ties.
Mrs Lepper is involved with several high profile groups such as Alexandra Community House Trust, which she chairs, and as a trustee of Central Lakes Trust. She is also Central Otago REAP manager.
"I find myself going to occasions wearing numerous hats."
A marriage celebrant long before she became a mayoress, she has always had to have plenty of "wedding outfits" in the wardrobe, mostly bought from Alexandra stores, which she also puts to good use on mayoral outings.
"It's been really good to have an excuse to have not just one, but three pairs of shoes!"
What Mrs Lepper has loved most about being mayoress so far is the citizenship ceremonies, where she welcomes new New Zealanders and reads out their testimonies.
"I really enjoy meeting them and hearing their stories."
The scariest thing has been the Alexandra Blossom Festival parade, where the mayoral couple is required to drive down the town's main street as part of the procession.
"That's been the hardest thing because it's so public. Walking with a group would be much easier."
The mayoral team are keen on multisport, having entered the Gold Rush as veterans every year.
When Mr Lepper decided to run for mayor, they delivered his flyers by bike.
As mayor, naturally he cops a bit of flak, which he cannot help but bring home.
"He mulls it over, and often we try to think of the issue from a different angle, stepping back from the emotion."
Both from teaching backgrounds, they met at the Craigieburn Ski Field in Canterbury. He was a long-haired, laid-back lad from the Hawke's Bay with a degree in history who wanted to travel. She was short-haired, more studious with a double degree in history and geography, who wanted to focus on a teaching career.
"It took me a while to warm to him," she laughed.
They did not start going out until the last week of their course. Mrs Lepper took a teaching job in Motueka, and he soon followed, becoming a relief-teacher, part-time forestry worker and white-baiter.
They married, and went overseas travelling for three years, coming back to Central to work on the Paulin family orchard in 1984.
Mrs Lepper eventually went to teach at Dunstan, with a two-year stint at Cromwell College. Mr Lepper became manager of the Earnscleugh Irrigation Scheme, and during that time he was a hands-on father to their young children, becoming a councillor at amalgamation time in 1989.
"He was chief cook and bottle-washer while I worked and he enjoyed it, picking the kids up even when he didn't have to."
But when he decided to run for mayor two years ago, she was happy to support him. Still working fulltime herself, they cherish their home life together.
"Sometimes I feel like we're never at home. It's our sanity place."
They work hard at keeping some sort of routine. He gets up early and tends his vege garden, then they have breakfast together before heading off to their various duties.
And will the mayoral team be standing again in the 2013 elections?
"Yep, we'll go another round."
"Sometimes we pinch ourselves and ask each other 'how did we get here?'
"How did I end up married to a mayor and representing a community like this?"
- The Mirror
Sponsored links
Parents hopping on Minecraft bandwagon
Retail project for old hall site
Cold plunge pool for Southland athletes
White Ribbon day all about building bridges
Supermarket rethinks butter price
Fatal crash findings 'bittersweet' for campaigner
Asset sales mooted to fund $11.7m pool
Row at hearing leads to walkout
Mufti cops may blend in at races
Councillors to focus on strategy, policy
Light plane crashes near Riverton
Santa Parade under way after day's delay
Downed power lines live after car crash
Demand for retail space in suburbs
Editorial: A case for dethroning king hits
Teenagers win promotion to Southland team
Fabulous year for Invercargill jeweller
Talented Shaun Stodart studying his options
Bob Robertson recognised for community contribution
Light plane crashes near Riverton
The facts of life - half a century of change
Downed power lines live after car crash
Recap: Inaugural Queenstown Marathon 2014
Santa Parade under way after day's delay
Bad weather sees Santa parade postponed
Digital edition
Subscribe to a digital replica of The Southland Times.
Community newspapers
Click here to read our free community newspapers from around the region online.
Subscriber services
Southland Times subscriber news and information.
Click here for information about advertising with The Southland Times.


text:
Egypt's official statistics agency CAPMAS has said the number of tourists visiting the country in March 2014 fell 32.4% to 755,000, compared with the same month last year, Ahram has reported. Vacations in Egypt during the month were also shorter as compared to the same period a year earlier, with the number of nights spent by tourists down by 43.6%. Egypt's tourism sector, which represents 11% of the country's GDP, has been suffering from ongoing shocks ever since the 2011 uprising that unseated Hosni Mubarak.
All News May 14 2014
May 14 2014 All News
Wednesday, May 14- 2014 @ 10:47 UAE local time (GMT+4) Replication or redistribution in whole or in part is expressly prohibited without the prior written consent of Mediaquest FZ LLC.


text: Scotty McCreery By Lynn Quale August 23, 2011 12:55 PM Share on Facebook Share on Twitter Category: Share on Facebook Share on Twitter More Leave a comment Send to a friend! Print this page Pin it! Reddit This! Share on Tumblr! More from 98 Country #ThrowbackThursday…On This Day In The Year… Clay Walker Responds to Kenny Chesney's Bro-Country Comments Today's Zentral Minnesota Moment [Video] Pet Patrol: Meet Benny And Jub Best of the Web


text:
Blog: CEO Bob Anderson to Retire June 2015
It is with a sense of deep appreciation and tremendous satisfaction for the almost 16 years of service as CEO of Horizon House that I announce my plan to retire in June 2015…I realized recently that I have served this remarkable institution for 30 percent of its life and more than one-third of my career. I can simply say these have been the very best years of my professional life. Read more.
Happy Thanksgiving
We wish our readers and friends a happy Thanksgiving. We're thankful for you and all the bounty this season brings.