All cryptocurrencies have taken a battering during the Asian trading session today as a huge selloff has commenced. Fears have escalated over further clampdowns in China and possible restriction in South Korea. The markets have fallen over 36% in the past week and total market capacity at the time of writing was just over $500 billion, down from $830 billion two weeks ago.
Reports have emerged of another crackdown in China, this time on domestic crypto traders and their methods of accessing digital currencies. In its usual authoritarian style the government plans to block access to local and overseas crypto exchanges and prevent peer-to-peer trading. It is not the first time China has clamped down on crypto with a ban on exchanges in September and recent restrictions on power usage for mining operations. Mining factories and crypto exchanges have left China for friendlier countries such as Hong Kong and Japan.
Bitcoin has declined from $14,500 this time last week to just over $11,000 today representing a drop of almost 25% in seven days. Looking at the month it has fallen over 45% and many chart analysts predict it could go as low as $8,000 before showing any sign of recovery.
Ethereum has also fallen from its all-time high of $1,425 last week to just over $1,000 today. A more optimistic view can be seen on the three month chart where ETH is still around 200% up on its trading price of $300 back in early November. Ethereum has performed exceptionally well as many altcoin trades can now be made in ETH instead of BTC which is slower and costlier.
The bloodbath has continued with all other coins and Ripple has taken the biggest beating with a 70% drop from its record peak of $3.80 to $1.20 today. Litecoin has also continued its downward slide from a high of $375 this time last month. The coin has dropped over 50% in a month to $185 where it trades today. Bitcoin Cash which has been holding a $2,500 level for a couple of weeks has dropped down below $2,000 again and even NEO which had a record high of $195 a couple days ago has lost a lot of its gains and fallen back to $135.
Markets have recovered from Chinese clampdowns before and they are all still way up on prices three months ago. Panic selling and FUD seems to be fueling this current slide so those hodling may be inclined to buy the dips and stock up on their favourite cryptos.


A fabulous week's skiing! Thanks to all at Ski Amis for looking after us so well.
Great photo's. Glad you captured me paragliding!!
Thanks for the fab pictures. Look forward to seeing you soon.
My skiing may not always be so pretty, but the surroundings in the Les Trois Vallées are always stunning.


My work is constantly evolving, but it commonly draws inspiration from my interest in heirlooms. I grew up in a home full of antiques and spent a lot of time in roadside antique shops with my parents. These heirlooms were very important to my parents, so they taught me to appreciate and treasure them as they did. Naturally, I became interested in these objects and the simple purpose for which they were used. This has played a considerable role in my subject matter and process as an artist. Much like the objects that inspire my jewelry designs, I aim to create modern heirlooms that evoke a feeling of nostalgia and comfort to its wearer.
Alex received her BA in Studio Art from Humboldt State University where she studied under Professor Kris Patzlaff. She also received a minor in Art History and a Certificate in Museum and Gallery Studies. She currently resides on the Mendocino Coast where she works out of her home studio.


Enclosed with the book is a fabulous CD-ROM that gives viewers a detailed tour of the Enterprise . This remarkable software program was developed in close cooperation with the creators of the Star Trek sets that were used in the films and on the television series. On Board the U.S.S. Enterprise offers Trekkies a once-in-a-lifetime ticket to one of the most popular and beloved sci-fi adventures of all time.
Pre-order: Amazon.com (I), Amazon.com (II), Amazon.co.uk, Amazon.de, Amazon.co.jp.
With the specific reference to only Picard I presume this is just about the Enterprise-D, the new Amazon listing title also suggests this is a TNG book. I am therefore maintaining my hope that this might be the book form of the cancelled Build the USS Enterprise-D part work magazine.
It would be good to see such artwork not go to waste.


Yet another design which will be good for generally house will be flexible and modern espresso table with three legs and circular top on colored wood, it moves perfectly using areas together with friends or family however contemporary style. The help area is ideal to allow for any kind of item, making this accessory of good use from an aesthetic in addition to useful viewpoint. The particular solid wood help framework allows maximum stability in any exterior. Along with realistic, espresso table is also easily accessible in furnishing stores such as for example Ikea or amazon. From a coffee desk in which is minimal, contemporary, affordable, big, and different design can be found. Which we have to consider when choosing a espresso dining table design is regulate a floor color and design of the couch and interior.
Next, when guests are obtained, the espresso desk or could only placing noguchi style coffee table 19mm glass top with walnut , oak or ... regarding noguchi style coffee table support area must certainly be wonderful and make the choice food organized for the event entrancing. On the day, a clay floral vase with fresh flowers gives a pleasant odor while a glass jelly will expose the cupcakes or cookies furnished with fondant. A vibrant coffee support or earthenware teacups to offer warm water. In the evening, for an eleventh hour diy happy time, small white clay spoon can amaze guests with delicious dishes to taste in one single snap. Ok, Let us find out making your home even more lovely.
Structure in wooden beams and crystal prime or in noguchi style coffee table 19mm glass top with walnut , oak or ... regarding noguchi style coffee table to get a cheap family room in pastel colors that loves feminine sign. Sleek materials to accomplish a white couch with small and necessary characteristics. mirrors and colors for a glamorous model living room that really wants to surprise having its refinement. Whatsoever kind of enthusiasm you decide on, the espresso desk will adapt to how big the couch, attaining the top of the seat so as never to creatively clash with the remaining portion of the furnishing.
The actual coffee family table or precisely noguchi style coffee table is actually a decorating adornment this improves the shape associated with couches and also armchairs, deciding in the middle of the bedroom for a focal point with regard to occasions involving conviviality and relaxation. The aid program also to work it's company beverages along with hand food between a number of friends, laughter, and also joke.
White espresso desk could become common furniture for any home design. Exceptionally specific in their concrete is particularly dull and black color. It is a bit of great elegance and unique type, able to create your home distinctive and unparalleled. Enhance your home with this specific contemporary little bit of furnishing. It's stated that the king with the living room may be the sofa, nevertheless we all mustn't forget the necessity of an elegant and purposeful decorating accent such as a espresso desk. Fusions of styles for houses of current motivation in which each factor harmonizes and finishes the actual other. The primary characteristics which separate each trend associated with household furniture will also be mirrored inside the coffee table.
It can be a good time as producing modest talk to friends in conjunction with a cup of joe or even tea on coffee desk inside living room. Cozy seats in the couch, amongst stories, in addition to noguchi style coffee table, it will make a great opinion about your house. A delicate vase associated with contemporary delphiniums or even a growth along with home furnished cupcakes will probably body a part.


text:
Irán estuvo representado en los Juegos Olímpicos de Pyeongchang 2018 por cuatro deportistas, dos hombres y dos mujeres, que compitieron en dos deportes.

La portadora de la bandera en la ceremonia de apertura fue la esquiadora de fondo Samaneh Beyrami Baher. El equipo olímpico iraní no obtuvo ninguna medalla en estos Juegos.

Referencias

Enlaces externos
 Base de datos olímpica del Comité Olímpico Internacional .

Iran
I 2018
Olimpicos

redpajama_set_name: RedPajamaWikipedia


text:
Q: Match regex with fixed length and add trailing whitespaces I'm having trouble creating a regex (Java) to match the following pattern:

*

*Starts with 1 or 2 digits

*Followed by letters M or MS

*Must be 7 characters long. Padding at the end must be done with whitespaces.

Valid inputs:

*

*2M, 2MS, 10M, 10MS (and their respective trailing whitespaces)

What I have so far:
[\\d{1,2}MS?\\s]{7}
It enforces the length and allows for whitespaces, but that's about it.
Any help would be greatly appreciated.

A: This one does the job:
^(?=.{7}$)\\d{1,2}MS?\\s*$

Explanation:
^           : begining of line, not mandatory when using matches()
(?=.{7}$)   : lookahead, make sure we have exactly 7 characters
\\d{1,2}    : 1 or 2 digits
M           : M
S?          : optional S
\\s*        : 0 or more spaces
$           : end of line, not mandatory when using matches()

redpajama_set_name: RedPajamaStackExchange


text:
Test for Error
Test for Domingo
Give to United Way Test
Your generous contribution will enable us to keep fighting for the health, education and financial stability of every person in our community and around the world.
A growing community need inspired donors to generously give $48.3 million to the 2020 United Way of San Antonio and Bexar County Community Campaign.
Brad Barron, president and CEO of NuStar Energy and 2020 United Way Campaign Chair, led the effort with local businesses, organizations and nonprofit agencies contributing $48,300,000 toward helping the community's children, individuals and families gain strength and stability – including those hardest hit by the COVID-19 pandemic.
While our community faces this added challenge, donors came forward to help the growing population on the edge -- those who never thought they would need food, or help with rent or a utility bill, or childcare because the schools were closed.
Barron and United Way Board Chair Kim Lubel shared a message of hope, stressing that United Way believes in helping everyone, especially the most vulnerable, as the community navigates the pandemic together.
The COVID-19 healthcare crisis presented challenges for the annual community campaign this year. Thousands across Bexar County lost jobs or experienced inconsistent work. Others lost their homes or were unable to pay the bills or afford groceries. A lack of internet connectivity hampered school learning, and some seniors were cut off from family and community supports.
Despite COVID-19's effects -- including a reduction in the workforce, economic uncertainty, an over-stressed healthcare industry, the pivot to a virtual environment and the rescheduling of events and fundraisers -- there has been overwhelming support.
Barron expressed his pride in San Antonio's donors who paused, took stock, adapted, moved forward, and generously gave back during this year's campaign.
The issues facing the community are complex and connected. Food insecurity, academic preparedness, a family's inability to meet basic needs, and isolated seniors are often inter-related. The money raised by United Way provides much-needed support for thousands of children, families, and individuals across Bexar County.
United Way programs provide workforce opportunities, quality early childcare, disaster care services as well as help with, family violence, reading and math proficiency, prenatal care and much more.
Nonprofit partners provided assistance, care and understanding to those in need – even while struggling themselves this year to respond to the healthcare crisis. They offered help and hope for those who are at crossroads in their lives.
Raised over $6.3 million, for 150 local nonprofits, with the COVID-19 Community Response Fund in partnership with the San Antonio Area Foundation.
Provided wages for 904 people who worked over 55,000 hours through our Get Shift Done for San Antonio collaboration. Displaced food service workers earned a combined total of more than $600,000, helping local agencies provide food to hungry families.
Invested $400,000 in the COVID-19 Emergency Childcare Assistance Program to provide emergency assistance for essential-worker parents struggling to find childcare. United Way's Women United group funded this vital program.
Launched the SAUnited4Good website to gather volunteer opportunities from nonprofits, while helping them connect to volunteers.
Created a community-wide Thank-A-Thon, distributing over 1,000 notes, photos and videos for essential workers.
Directed callers through the 2-1-1 Help Line, fielding nearly 1,000 calls a day, serving civilian and military callers, through MISSION UNITED, while manning the phone 24/7/365.
Donated over 4,500 children's books to vulnerable families.
Saved Volunteer Income Tax Assistance (VITA) participants $4.8 million in tax preparation fees, even though locations were consolidated or closed because of the pandemic. The effort returned $38 million to local taxpayers and the economy. The new VITA season is poised to kickoff later this month.
Conducted the 6th Annual Shoebox Project distributing personal care items to 74 nonprofit partners serving local children, veterans, elderly, homeless and vulnerable populations who inched closer to the edge because of COVID-19.
Introduced the first-ever Community Champions Spirit of SA Awards, recognizing volunteers supporting United Way's four strategic areas of work during the pandemic.
Completed a successful $48.3 million annual fundraising campaign.
United Way is also grateful for a $20 million gift to United Way from MacKenzie Scott, philanthropist and author, which represents the largest ever private donation made in the 81-year history of the nonprofit. Scott's gifts included various organizations in San Antonio and across the country. Her trust in us allows United Way to support even more transformational change across Bexar County. Her gift is in addition to the $48.3 million raised during the 2020 campaign.

redpajama_set_name: RedPajamaCommonCrawl


Now here's a nice little jaunt over the pass into the headwaters of the Salmon River. The plan for today was to meet Ben in Stanley.
We would then go farther down river to fish for Steelhead.
so he had a spot in mind he wanted to fish.
It turned out fruitful in the first hour, which is amazing as the typical amount of hours fished for a single Steelhead can be in the dozens.
Traveling back upstream after a couple more hours in that spot, we stopped at Yankee Fork, and the Sunbeam Dam . Or what's left of it.
what they think is the best spot for a catch. That's called combat fishing.
We then cruised back to Stanley where Mr Steelhead got filleted, and we had a fish fry with the Sawtooth Mt Range looking over us.


text:
« Hillary Clinton With Danish Foreign Minister Dr. Per Stig Moeller
Hillary Clinton's Bilaterals This Week »
March 17, 2009 by still4hill
Remarks with Irish Foreign Minister Michael Martin After Their Meeting
Treaty Room
SECRETARY CLINTON: Good afternoon. Well, I am delighted to welcome the foreign minister here today. I know this comes a little early, but, Minister Martin, I wish you and the people of Ireland and all people who are connected to the wonderful Irish history and traditions a very happy St. Patrick's Day.
I had the great honor of representing a very large Irish American citizenry in New York for eight years, and I know well the contributions that Ireland and Irish Americans have made to the United States. They're so numerous, they're impossible to quantify. And indeed, we now have a President and a Vice President who trace some of their family roots back to Ireland.
So I am grateful that the foreign minister could join us here today ahead of the holiday tomorrow to acknowledge both the history and friendship that we share, but also the working relationship that we have enjoyed on a number of important issues that are really significant to both the people of Ireland and to Americans.
I told the foreign minister how much we appreciate that strong partnership. And we discussed and had a very productive meeting about a range of issues. Our countries share a vital economic relationship that has created tens of thousands of jobs in Ireland and the United States. We need to coordinate closely to preserve those benefits in the face of global economic challenges.
Ireland also makes significant contributions to global security. Over 800 troops, 10 percent of the country's armed forces, are currently deployed overseas on peacekeeping missions in Chad, Kosovo, Bosnia, Afghanistan, and other countries.
And on the subject of conflict prevention, I want to address the recent events in Northern Ireland. As many of you know, this is an issue of great personal concern and commitment to both me and to my husband. It was an honor to work on behalf of peace in Northern Ireland and to do so with the leadership of Senator George Mitchell as our negotiator. I had the privilege of visiting Northern Ireland numerous times to meet with activists from both communities. I spent a lot of time in particular with women, Catholic and Protestant, who were working to build bridges in their own communities, to find common ground as mothers and wives, and to create conditions for peace from the ground up.
Thanks to the brave efforts of government leaders and community activists like the women that I was privileged to know, the people of Northern Ireland, with the strong support of the Government of Ireland and the Government of Great Britain, reached a peace agreement, the Good Friday Agreement, that has delivered more than a decade of calm and progress.
Now, in recent days, a handful of rejectionists have tried to drag the people of Northern Ireland back into a full cycle of violence and retaliation. The recent attacks which killed two British soldiers and a police officer are an affront to the values of every community, every ethnicity, every religion, and every nation that seeks peace. I want to commend the entire leadership of Northern Ireland as well as the Irish and British governments for their constructive statements and their strong resolve in the face of this attack.
I hope that the recent arrests will bring an end to these tragic events and allow the people of Northern Ireland to continue to move forward not only with the important work of reconciliation, but with prosperity and progress that will redound to the benefit of all. The success of the peace process has consequences that go far beyond Northern Ireland. It provides proof to people everywhere that negotiations, dialogue, reconciliation, diplomacy can end conflicts that have tormented generations. The United States stand with the people of Northern Ireland. We will not let criminals destroy the gains that have been achieved through great courage and sacrifice.
Now, this issue is, of course, only a small facet of our relationship with Ireland. Whether it is supporting the Middle East peace process; strengthening democratic institutions in Pakistan, Afghanistan, the Western Balkans; promoting human rights; finding solutions to the global financial crisis and climate change; working together on development, we know Ireland is and will remain a strong and steady partner and leader. We share responsibilities, a common agenda, and a proud history.
So Minister Martin, I am grateful for your friendship and for the friendship that you represent on behalf of your country, and I look forward to working with you as we address these and other challenges.
FOREIGN MINISTER MARTIN: Thank you very much indeed, Secretary of State, and may I say that it's a particular pleasure for me and indeed a privilege to be here with you and to have the opportunity to have our first bilateral meeting here in Washington.
I think you will agree that our meeting was substantive, it was productive, and very fruitful. And indeed, I, of course, congratulated Secretary of State Clinton on her recent appointment and, of course, said all of us in Ireland look forward to working with you in the months and indeed in the years ahead.
It is especially appropriate that the meeting should take place on the eve of St. Patrick's Day, when Ireland again has been honored so warmly here in Washington. And indeed there's a special bond of friendship between Ireland and the United States, and again this is reflected, I think, in the very generous way in which St. Patrick's Day has been celebrated here today and tomorrow in Washington and indeed across the United States itself.
Secretary Clinton has been an extraordinary friend of Ireland and continues to be. For many years you've played a key role in our peace process, as you've just articulated, and you've been a frequent visitor to Ireland over the years. Your engagement at a political and civic level, particularly in terms of developing political awareness among women's groups in Northern Ireland, was particularly important and earned you the greatest respect on the island of Ireland and indeed amongst our Irish American community here in the United States. And of course, we look forward very much indeed to welcoming you to Ireland for an official visit at an early opportunity.
In addition to that, we did discuss, of course, the situation in Northern Ireland, including the tragic events of last – of the past week, when three lives were needlessly and senselessly lost as a result of unacceptable and criminal attacks by dissidents. We – what has emerged from the past week, as I spoke and discussed with Secretary Clinton, has been a very strong unity of purpose from both the Irish and the British Government and indeed from all of the political parties on the island of Ireland. It has demonstrated a very significant unity of purpose in ensuring that we will never go back to the bad old days and that we're very anxious to build on the political momentum and develop very strong political structures and community structures to ensure the continuation and the enhancement of the extraordinary achievements of the past ten years. And of course, America has been particularly important in relation to those achievements.
In terms of the ongoing bilateral relationship that we – Secretary Clinton has expressed interest in the new strategic framework that the Taoiseach announced last evening, which will in many ways be the framework for the development of our relationship with the United States in the decades ahead. And we want to work on quite a number of those issues into the future, not least in developing bilateral frameworks whereby young Irish people can come to America and indeed young Americans can come to Ireland to work and to study and to learn more about each other's cultures and experiences. And in that context, we look forward to working bilaterally on issues such as development and other issues where we can add value to the world by working in partnership.
I wish to pay tribute to Secretary Clinton's intensive engagement with the international community over the past few weeks. We look forward to the United States assuming a strong and progressive global leadership role in the years ahead. And already within the European Union community, there is strong anticipation, excited anticipation about the relationship that will develop across the Atlantic between the European Union and indeed the United States.
We've discussed, as the Secretary of State said, issues pertaining to the Middle East, to Afghanistan, to global economic downturn, and developments within the European Union itself. We welcome your very energetic engagement in the pursuit of a comprehensive peace settlement in the Middle East. And of course, we were particularly warm in our welcome of the appointment of Senator George Mitchell as Middle East envoy, a person who did an enormous amount of work for Ireland in developing the peace process back in Ireland. And anywhere we've gone in the Middle East, we have made it very clear a man of integrity, a man of fairness, and a man who listens has been appointed to a very sensitive post. And that speaks volumes in terms of your commitment to the resolution of that issue. And indeed, if we can be of any assistance in that regard, given our own experiences, we're only too willing to provide such assistance.
We look forward to tomorrow, St. Patrick's Day. I was intrigued by the Secretary of State Clinton's memories of the capacity of the Irish to party in a unique way – (laughter) – and she interrogated the Ambassador in terms of where the real parties were going to be tomorrow evening. (Laughter.) And I think, you know, we're looking forward to it, and the Taoiseach – and the meeting between President Obama and the Taoiseach tomorrow as well, which of course is the highlight of the remarkable celebration of our national day in the United States.
SECRETARY CLINTON: Thank you so much, Minister Martin.
MR. WOOD: We'll take a couple of questions. The first one is to Elise Labott of CNN.
QUESTION: Thank you, Madame Secretary. On Pakistan, I'd like to talk to you about your message to Pakistan over the weekend, which certainly seemed to help, at least, calm the situation. What sort of pressure did you apply to Pakistan? Did you warn that Congress may not be forthcoming with aid if the political turmoil continues? And given the political turmoil, can you say that the government is stable and are you concerned that it's distracted from the very important task at hand at fighting the war on terrorism? Thank you.
SECRETARY CLINTON: Well, of course, the Pakistanis themselves resolved the difficulties that were manifest over the last several days. The work that was done by our Ambassador Anne Patterson and the Embassy staff, along with our Special Representative Richard Holbrooke and his staff, was, I think, very helpful in both working with the Pakistani leaders themselves and in keeping our government informed. I did speak with both President Zardari and Nawaz Sharif. And I believe that the resolution that they have agreed upon is the first step of what has to be an ongoing reconciliation and compromising of political views that can stabilize civilian democracy and the rule of law, both of which are essential to the efforts that the Pakistanis themselves see as so critical; namely, preventing extremism and violence from stalking the Pakistani people and the country.
So we are going to continue our very close working relationship with the government and a number of Pakistani leaders in the days and weeks ahead. We have another trilateral meeting scheduled a few months off. So there will be an ongoing effort to make our services available and to help the Pakistanis fight against our common enemy.
QUESTION: Are you worried that (inaudible)?
SECRETARY CLINTON: Well, I think they understand what's at stake.
MODERATOR: Last question is from Denis Coghlan of the Irish Times.
SECRETARY CLINTON: Denis, how are you?
QUESTION: Very well. Thank you, Madame Secretary. The Administration has asked a number of European countries, including Ireland, to help with the resettlement of detainees in Guantanamo Bay. I wanted to ask you, first, how important is our help with that issue? And secondly, what would you say to European citizens who say that Guantanamo was an American creation that most Europeans didn't approve of, and that the United States really has the responsibility to resolve the problems it created?
SECRETARY CLINTON: Well, the President has made it clear that we will close Guantanamo. That is a position that was widely advocated by Europeans, both European governments and the EU, as well as European citizens from, I guess, every country. We believe that that is the right step for the United States to take, and we are going through our process now to evaluate the disposition with respect to each detainee.
But it is clear that we will need help because many of the detainees cannot safely, for themselves or others, be sent back to the countries from which they came. There are some countries that have made it very clear if the detainees are returned that they will face consequences; imprisonment, for example. So we need help to avoid the human rights problems that might arise with the release and resettlement of the detainees. And we are trying to do the best we can with the problem that we inherited, and that certainly is something that Europe, from one end to the other, called upon us to do. So we would hope to have the cooperation of European governments.
FOREIGN MINISTER MARTIN: First of all, we warmly welcomed the decision to close Guantanamo, and indeed Ireland was one of the first countries out calling for its closure. And it has been welcomed warmly across the European Union. And as I have said, and I'm on the record publicly as saying, that given the fact that we called for the closure of Guantanamo, we have – there's a compelling logic to being responsive to the situation and to see what – where we can help in – within the context of the European Union as well, because we do believe that Europe is working on this at the moment, and I understand that the European Union is engaged with the Administration in terms of information and so on. And I know it will be the subject matter of discussions perhaps tomorrow as well between the President and the Taoiseach, so I'm not going to preempt anything the Taoiseach may say.
But we're a friend of America and we will respond to the issues as they emerge. And we've made it clear that we want to be positive in our engagement on this issue with the Administration.
SECRETARY CLINTON: We appreciate that.
MR. WOOD: Thank you all very much.
SECRETARY CLINTON: One – you want one more on each side?
MR. WOOD: Sure.
SECRETARY CLINTON: Yeah, okay.
QUESTION: Madame Secretary, how do you respond to criticism from Senators McCain and Graham and Brownback that Chris Hill is – does not have the experience necessary to become ambassador in Baghdad? He doesn't have the experience in the Arab countries. And they also allege that he doesn't have the negotiating skills necessary, and they point to the recent deadlock in the negotiations with North Korea as an example.
SECRETARY CLINTON: Well, obviously, I think both of those criticisms are unjustified and unfounded. Chris Hill is a distinguished, experienced diplomat who has served in some very difficult positions on behalf of our country. Another very distinguished, experienced diplomat, John Negroponte, was our ambassador to Iraq. He did not have Middle East or Arabic language skills when he was sent to Iraq. I believe the people you've just mentioned, my former colleagues, all voted for former Deputy Secretary Negroponte. So I think on the experience basis, he is not only very well-qualified in terms of running a large embassy, helping to deal with the myriad of issues that will arise as we conduct our withdrawal, but we'll have around him, as any ambassador does, people who have particular skills and expertise.
With respect to the North Korean mission that we believe Ambassador Hill carried out with great persistence and success despite some difficult challenges, this is a hard set of challenges to meet. And it is our perspective that he made a lot of lemonade out of some pretty bad lemons, and he was able to get the North Koreans on record as agreeing to certain obligations. We now have to follow through on those obligations.
So our assessment, which we believe is rooted in the facts, may be different from those who, you know, are rightfully distressed with and extremely critical of North Korean actions on human rights, on their continuing effort to obtain nuclear weapons, on their belligerence and their provocative actions. But that is something that is not in any way reflective of the job that Chris Hill did in the Six-Party Talks, where we think he did a very good job.
MODERATOR: (Inaudible.)
QUESTION: A question for the Secretary of State. You had strong words there for the dissidents in Northern Ireland. Can I just ask —
SECRETARY CLINTON: Not dissidents, not – I'm all in favor of dissidents. I'm not in favor of criminals.
QUESTION: Okay. Well, your strong words, how – I just want to ask how you felt personally last week when you saw the events unfolding. And just secondly on that, you've been asked to make an official visit at the earliest opportunity.
SECRETARY CLINTON: Yes.
QUESTION: When do you think that will be and will President Obama be coming with you?
SECRETARY CLINTON: (Laughter.) Well, I told the minister that unfortunately, my colleagues in the State Department know my great affection for Ireland and they're somewhat skeptical that it's a work job for me to go. So I'm working that through. I will get there at my earliest opportunity.
I think like all people who value peace and who know what it's like to feel secure sending your, you know, son to the store or waiting for your husband to come home from work, those days were thankfully behind us. And so when these criminal elements, these rejectionists, determined to kill and try to set the communities against one another in Northern Ireland again, to relive the troubles and the bad days that everyone worked so hard to resolve, it was distressing.
But I was immediately heartened by the response across Northern Ireland, indeed, the island of Ireland with people speaking out against the murders and the violence and the provocation that these actions represented. I particularly appreciated the very strong statements of Northern Ireland's leaders from both communities. So I believe this did, as the minister said, fortunately foil the efforts of the criminal elements to try to provoke violence again. In fact, it did show a unity of purpose, a commitment to a positive future.
Now that doesn't mean all of the problems are over and all of the difficulties that people live with day-to-day – the minister and I talked about some of the economic issues that we wanted to help address in Northern Ireland. But it did, in a resounding way, demonstrate a commitment to peace that touched my heart and was incredibly moving to me.
FOREIGN MINISTER MARTIN: Thank you.
Ya gotta love her, trying to find out where the good parties are. Come to my house, Hillary!
Remarks With Sinn Fein President Gerry Adams Before Their Meeting
SECRETARY CLINTON: Well, I'm delighted to welcome Gerry Adams to the State Department. I was delighted also to meet with him, I think, every year as a senator from New York. And I'm looking forward to meeting with him and other officials of Northern Ireland and the British Government today as we celebrate St. Patrick's Day and we talk about how we're going to continue to support the devolution of power and authority and the peace and prosperity of the island of Ireland.
Remarks With Northern Ireland Secretary of State Shaun Woodward Before Their Meeting
SECRETARY CLINTON: Good afternoon. I am pleased to welcome the Secretary of State for Northern Ireland here for our meeting on this St. Patrick's Day where we are deeply connected between not only Ireland and – the island of Ireland and the United States, but of course the United Kingdom and its very progressive and positive role in moving Northern Ireland along the path toward lasting peace and prosperity.
SECRETARY WOODWARD: Well, I'd like to thank the Secretary of State for being kind enough to see me and my colleagues from Northern Ireland today on St. Patrick's Day, which of course, is a really important day for us all to celebrate.
It's been a testing time in Northern Ireland in the last week. But the extraordinary thing is how not only the government in Britain and Ireland have come behind the political parties in such an easy way, but how the political parties in Northern Ireland have responded and united (inaudible) this.
And I'd just like to thank the American Government for everything you've done, the investment and the political support, because we really do have the most great opportunities in Northern Ireland, and we couldn't have got there without the help of America. And it's a great chance now for us to see real prosperity for the people there and lasting peace.
So thank you very much.
SECRETARY CLINTON: Thank you very much.
Remarks With Northern Ireland First Minister Peter Robinson and Deputy First Minister Martin McGuinness
Secretary of State, Secretary of State
SECRETARY CLINTON: Good afternoon. Well, I am very pleased to be here this afternoon with two men who have really proven what leadership means and demonstrated clearly courage and commitment: First Minister Peter Robinson and Deputy First Minister Martin McGuinness.
I want to begin by saying how pleased I am personally to welcome them here. I have known Peter and Martin for a number of years and have seen them take responsibility for the future of the people of Northern Ireland in a way that has inspired confidence and created a real opportunity for people not only in the United States, but around the world to look to Northern Ireland and to see the progress there. Of course, it's St. Patrick's Day and they are here on this occasion, but they are no strangers to either Washington or the State Department. And I know how important our relationship is to continue to support those who work for peace.
In addition to the discussion that I just concluded with the first minister and the deputy first minister, I have had excellent conversations with others as well who you have seen starting yesterday and continuing through today.
Northern Ireland has made such remarkable progress since the signing of the Good Friday Accord. We've had more than a decade of peace and progress and prosperity for many. Recent acts of violence cannot be allowed to undermine that progress and the progress that is yet to come as these two leaders and those who work with them continue to move into the future. The violence that has occurred with the killing of the two young soldiers and the police officer are an affront to the values of every community, every person who believes in the power of peace and reconciliation.
The two men standing on either side of me led Northern Ireland through the last days in a commendable manner. Along with the governments of Ireland and the United Kingdom, they have confronted these acts of violence with boldness and statesmanship. And they have responded to actions intended to sow fear and division with unity and courage.
So we are here after ten years of peace, and we're committed to looking forward to a future where we, the United States, working with them, can create a better life so that every child growing up in Northern Ireland has a chance to live up to his or her God-given potential.
The State Department and the Obama Administration will be actively engaged in assisting the leadership of Northern Ireland. And this is not a subject of passing interest, but of surpassing interest. During my time as First Lady, during my time as senator from New York, I have been privileged to see the people of Northern Ireland move in a direction that has given so much hope to so many, including those far beyond their own boundaries.
So I want to thank the first minister and the deputy first minister, and now let me turn to the first minister for any comments he wishes to make.
FIRST MINISTER ROBINSON: Thank you very much. At the very outset, I want to express my appreciation and the appreciation of all of the people of Northern Ireland to Secretary Clinton. Hillary has been a good friend of Northern Ireland, a great friend of the process in which we have been involved. We were delighted to hear in our meeting which has just concluded that that is going to be an ongoing interest. We're looking for excuses to bring her to Northern Ireland, and we're delighted to hear that the Obama Administration is looking to bring an envoy to continue to partner with us, and indeed to have a particular emphasis with someone looking after the issue of the economy.
The deputy first minister and I have had a difficult period of time. I think that anybody who has followed recent events will know that there was a single purpose on the part of those who carried out those dreadful acts. They intended to divide us. They intended to drag Northern Ireland back into conflict. Their hopes were that the work of the politicians in the assembly and in the executive would begin to fray and that the institutions would crumble and fall.
They have not succeeded, and they will not succeed. There is a massive determination, not just on the part of the deputy first minister and myself, but I was delighted to see it from every single political party. There was no party political bickering on the issue. Every politician stepped up to the line and made it clear their denunciation of the incidents and also their determination that they were not going back.
It is that determination not simply not to go back or to stand still, but to drive us forward, to complete the tasks that we have set our hand to, and to bring Northern Ireland to that place where it has a stable political and economic future, where prosperity is a daily diet of our people. It is that hope that drives us forward, and it is that hope that I believe we have the full support of the people of Northern Ireland in realizing.
SECRETARY CLINTON: Thank you so much.
DEPUTY FIRST MINISTER MCGUINNESS: Well, if I could say that it's an incredible good fortune for all of us on the island of Ireland and the north that Hillary Clinton has been appointed the new Secretary of State. She has for many, many years, alongside her husband, been a true friend of all of us, a true friend of the peace process, contributing tremendously to the transformation that has taken place over the course of the last number of years. And what has been really encouraging about this visit and the meeting that we've just come from is that it's quite clear that she is surrounded by people who have a tremendous insight into our situation, going back many, many years. I find that tremendously encouraging, and we're excited about our meeting with President Obama this morning and the things we heard from him and his reiteration of his commitment to help us within the process, continuing, I must say, a long line of important contributions from the United States of America.
And what we've heard just now in the course of our meeting with Secretary Clinton further encourages us that we will see the appointment of an envoy who will make their own particular contribution, also following in a long line of envoys who have been tremendously supportive for all of us.
And we talked about the economy because we believe that economic development is of critical importance, and our program for government identified the development of the economy as a key priority for all of us. And there has been a long tradition of American companies investing on the island of Ireland and in the north of Ireland, and our visit here and the West Coast, and we've been to Los Angeles, Peter's been to Chicago, I've been to New York, and we're now in Washington. Everywhere we went, it was quite clear that people were very tuned in to what had happened in our country and indeed at the time of those incidents were very shocked that it did happen.
But that shock quickly gave way to a bigger story, and the bigger story was the unity which Peter has just spoken about, not just between himself and myself, but between all of the parties recognizing that this represented a real challenge to our process by people who are dedicated to destroy the peace process, dedicated to the demolition of the political institutions, and absolutely dedicated to plunging our community. And we don't speak about two communities. We represent – although we represent different parties, we represent one community in the north of Ireland, and we are not going to allow our community to be plunged into mayhem and destruction by people who have no support, no mandate whatsoever, and no right whatsoever to attack the peace that the people of Ireland as a whole and in the north voted for in the referendum in the aftermath of the Good Friday upheaval.
So I'm actually moving forward on all of this with tremendous confidence about the future, confidence in that we are united, that we are supported by the Irish Government and the British Government, and by a very strong Administration here in the United States of America led by President Obama and Hillary Clinton. So we will leave Washington incredibly buoyed up by the encouragement and support that we've received here, and I want to express my deepest thanks and appreciation to you, Hillary, and to President Obama and all those in all of the political parties on Capitol Hill who have stood by us through thick and thin.
SECRETARY CLINTON: Thank you.
QUESTION: Madame Secretary, there are predictions of really catastrophic conditions in Darfur because of the president of Sudan's expulsion of aid groups and apparent intention to shut them down completely. And I'm wondering what can the international community do about this. Will this in any way speed the appointment of another special envoy, a U.S. envoy to Sudan?
SECRETARY CLINTON: Well, we have been deeply engaged in determining what we can do, because this is a horrendous situation that is going to cause untold misery and suffering for the people of Darfur, particularly those in the refugee camps. There will be a special envoy appointed for Sudan in the coming days. But the real question is what kind of pressure can be brought to bear on President Bashir and the government in Khartoum to understand that they will be held responsible for every single death that occurs in those camps, because by their expulsion of the aid workers, who came from all over the world to assist with the health and the sanitation and the security and the education of the refugees, they are putting those 1.4 million lives at risk.
And for those governments that support President Bashir's decision to expel the aid workers, they have a responsibility to persuade the government in Sudan to change its decision to let the aid workers back in, or they must replace with money and personnel those who have been expelled, so that innocent lives are not lost and further undermined.
So we take this very seriously. We are looking for the most effective ways to convince and demonstrate to the Government of Sudan that they have now assumed an even greater sense of responsibility and infamy in the eyes of the world by turning their backs on these refugees whom they created in the first place. So we hope that either by the internal processes of the Sudanese Government or pressure brought to bear by the supporters of President Bashir and that government, the decision is reversed, or at the very least, the money and the personnel are replaced.
MODERATOR: Jim Dee from the Belfast Telegraph.
QUESTION: Thank you. This is a question for Madame Secretary and also the first and deputy first ministers.
Madame Secretary, as my colleague pointed out, there are many serious problems in the world. Northern Ireland has enjoyed top-level attention from the White House for many years now. When Barack Obama was running against John McCain, he indicated that he may revisit the appointing of an envoy. How long can the White House, in the highest levels of the U.S. Government, stay engaged in Northern Ireland? Will there be a time when they will not?
And to the first and deputy first ministers, you are here on an economic investment journey to try to find companies that will invest in Northern Ireland. The global economy right now is in a very serious state. How contingent on economic progress and stability is political stability in Northern Ireland?
SECRETARY CLINTON: Well, as to your first question, we waited until we had the opportunity to consult with the leaders of Northern Ireland and of the Republic of Ireland about the best way to structure our relationship going forward. And it has been a unanimous agreement that having this high-level attention from the United States Government provides a real value to the ongoing peace process and to the economic aspects of, you know, anchoring peace in the soil where people can actually see the fruits of that effort.
So we will be appointing a special envoy. We'll be appointing someone who will pay attention to the economic investment side of this. You know, there's a great sense of affinity between the United States and the Irish, and it's something that I take very personally as well as professionally as part of my responsibilities. It's not only that we have many millions – about 44 million, which I think is an undercount – of Irish Americans, but it is the fact that we formed this deep relationship. And we are there to help; we're not there to do anything other than support the decisions that these extraordinary leaders make.
But if we are needed, if we provide value, we will continue to support this process. It is gaining strength every day. As both Peter and Martin said, the reaction not just by the leaders, but the people in Northern Ireland to the murders last week demonstrated how firmly anchored peace is. But there are still some bumps along the road.
And before I turn to Peter to answer your second question, you know, the Northern Ireland economy is doing better than a lot of economies right now, so I think it is quite attractive for people who understand that we will work our way through this global economic crisis we're in right now, and there will be opportunities for investments. And I think Peter and Martin are absolutely right to be out talking about the advantages of investing in Northern Ireland right now.
FIRST MINISTER ROBINSON: Secretary Clinton is right. Northern Ireland does have a deep and special relationship with the United States as part of a secret deal. The deal is that as we have supplied you with 15 presidents that we will continue to do that. (Laughter.)
And we continue to get support from the leadership of the United States. It's working well for both of us, I think. The economy of Northern Ireland is critical and is critical to the overall process in which we're engaged. We want to be able to show people that having local control can make a difference. And it only makes a difference to them if they feel it themselves. And therefore, it has to be able to – raise everybody hopes, it has to get into every section of our community. And the economy is the one way that you can do that, you can make people feel better, you can make people feel that this is working.
Of course, we, relatively speaking, are weathering the economic storm better than many. And we have an unemployment rate to which I think most European countries and the United States would be happy with, at just about 5 percent. But we want to go up the food chain in terms of the type of jobs that we have in Northern Ireland. And we're looking at high-end engineering, financial and businesses services, IT, creative industries. Those are the areas that we are wanting to grow in Northern Ireland. And we can provide businesses in the United States, even in these hard times, with a good reason to come to Northern Ireland, where you get the highest skills at the lowest cost.
So yeah, we do want to improve our economy. It's important for the overall process. And we believe that the United States has something that it can give Northern Ireland, but Northern Ireland has something that it can give back.
DEPUTY FIRST MINISTER MCGUINNESS: Well, I think it is very important that people benefit from the fruits of the peace process. And reiterating what Peter said, our relationship with the United States of America is rock solid. We have connections going back here centuries, and the bonds between us are very strong. And I believe that in the future, we will continue to see investment from the United States of America and the island of Ireland and specifically also in the North. And Peter and I have been tremendously encouraged by the messages that we've had over the course of the last short while.
In terms of the whole issue of the connection between the economic situation and the issue of political stability, let me say this. The institutions are, in my opinion, stronger and more stable now in the aftermath of the three killings than they were before. And that should send a very powerful message to those who people who were responsible for those killings. And the message is that we are not going to buckle under this pressure, but we are going to continue to do our jobs, knowing that we have got the overwhelming support of our people, people who too want to benefit for their own sakes, for the sakes of their children, and those yet unborn.
So this is about providing a better future and a better history and this is about recognizing the damage that was done to our Island and to ourselves as individuals by the past that some of us have experienced. So what we have to do is – the key point is to give leadership. That's what it's all about.
I attended two very important conferences in a forest in Helsinki, alongside Jeffery Donaldson of the Democratic Unionist Party, alongside Cyril Ramaphosa from South Africa and Roelf Meyer. And there were many white boards and there were many black boards in attendance. And many words were written on the boards and many words were spoken. I wrote one word on the board when I addressed the Kurds, the Shia and the Sunnis, and that word was "leadership." That's what is required in the north of Ireland, that's what's required in the Middle East, that's what's required in Iraq, that's what's required in Afghanistan and in many other places throughout the world.
The benefit we had was that we had leaders who understood the need to forge an agreement, who didn't want to be part of a process that saw the misery of the past inflected on future generations. And so I think – I would like to think that we have given strong leadership and that we have given a very powerful message – not just to our own people on the island of Ireland or in the North, but to the world – that the only way forward in situations where there is conflict and dispute is to sit down like sensible, reasonable human beings, forge agreements, and we have done that.
I mean, people have said to me, for example, what is different now in relation to what these people are doing and at a time whenever the IRA were involved in a conflict, which I supported, against the British Army? The difference is we have the Good Friday Agreement. The difference is we have all of the parties coming together, forming an inclusive government supported by the Irish Government, supported by the British Government and the U.S. Administration and the full width of international opinion, but more important than all of that, supported by the people, by ordinary housewives, workers, parents, people who have invested a tremendous amount and us as politicians, to give strong leadership and build a better future for them and for their children.
SECRETARY CLINTON: Thank you very much. Thank you all.
Posted in Foreign Policy, Hillary Clinton, Hillary Rodham Clinton, Secretary of State, state department, U.S. Department of State, Uncategorized | Tagged Foreign Policy, Gerry Adams, Hillary Clinton, Hillary Rodham Clinton, Ireland, Martin McGuinness, Micheal Martin, Northern Ireland, Peter Robinson, Secretary of State, Shaun Woodward, St. Patrick's Day, State Department, U.S. Department of State | 5 Comments
on March 16, 2013 at 11:00 pm | Reply Rumana Alvi
It is so cool to see what she was doing four years ago today. Thank you for doing it Still. LOVE IT! I love these pics.
on March 16, 2013 at 11:09 pm | Reply still4hill
OH! I see that I had both the 16th and 17th in the same post! Well, glad you like it! Happy St. Pat's!
Happy St. Patrick's Day to you, too!
[…] Happy St. Patrick's Day! […]


A fall-prevention program piloted by UHS and Broome County is being recognized during a two-day site visit by the Centers for Disease Control and Prevention.
CDC representatives are visiting the Southern Tier March 5 and 6 to meet with internal medicine specialist Frank Floyd, MD, and other members of the UHS team that implemented the fall-prevention program for elderly primary care patients starting in 2012.
Developed by the CDC, "Stopping Elderly Accidents, Deaths and Injuries (STEADI)" was pioneered by UHS Primary Care, the Broome County Health Department and the Broome County Office for Aging.
Since that time, the program has received widespread national attention. It was featured during a 2015 presentation associated with the White House Conference on Aging and in the pages of the national news magazine U.S. News & World Report.
During the current visit, group discussions with CDC representatives are being held at UHS offices on the Vestal Parkway, as well as at the county Health Department and Binghamton University.
UHS representatives participating include John Carrigg, president and chief executive officer, as well as Dr. Floyd, other providers and department leaders. They are joined by representatives of the county Health Department and other local healthcare leaders.
The CDC's recognition of the program will be featured at a physician gathering at Binghamton University and at a dinner at Number 5 Restaurant, both on March 5.
Dr. Floyd and his staff at UHS Primary Care Endwell piloted the national effort to prevent falls among the elderly using an evidence-based approach. Their program encourages primary care providers to conduct regular screenings with patients age 65 and older to determine their risk of falling.
UHS became the alpha test site in part because of its fully established electronic medical record system, which facilitated data collection and reporting to county and state health officials and the CDC.


text:
Q: MySQL Query For Total Online Time Based On Login/Logout Entries Ok, so I have to perform a bit of a nasty MySQL query, and I can't for the life of me think of how to do it.
I have the following content:
id    date                       name    join_or_leave
1     yyyy-mm-dd hh-mm-ss        user1   join
2     yyyy-mm-dd hh-mm-ss        user2   join
3     yyyy-mm-dd hh-mm-ss        user1   leave
4     yyyy-mm-dd hh-mm-ss        user3   join
5     yyyy-mm-dd hh-mm-ss        user2   leave
6     yyyy-mm-dd hh-mm-ss        user1   join
7     yyyy-mm-dd hh-mm-ss        user4   join
8     yyyy-mm-dd hh-mm-ss        user1   leave

So it logs all login/logout times for users.
What I have to calculate is the total time spent online (the total for all users, but I can work out this total after getting the total for each user if getting the total of all users is going to be very slow).
Hopefully it's obvious what I need to do here, obviously all of the dates  are going downwards (so whatever time the  join/leave entry was added); but how I'd go about doing it I just don't know. :p

A: should do the trick:
SELECT
    player_name,
    TIME_FORMAT(SEC_TO_TIME(
        IF(SUM(TIME) < 0,
            SUM(TIME) + TO_SECONDS(NOW()),
            IF(SUM(TIME) > 63000000000, SUM(TIME) - TO_SECONDS(NOW()), SUM(TIME))
        )
    ),'%Hh %im') AS TOTAL_TIME
FROM
(
    SELECT
        TO_SECONDS(c.date) * - 1 AS TIME, c.player_name
    FROM player_playtime c
    WHERE join_or_leave = 'join'
    UNION
    SELECT
        TO_SECONDS(date) AS TIME, player_name
    FROM player_playtime
    WHERE join_or_leave = 'leave'
) t
GROUP BY player_name WITH ROLLUP
;

fiddle: http://sqlfiddle.com/#!2/ebe7a1/4

A: Add a column for the session time for each user, which you update when the user logs out. Then it is only a question of summing app that column. Of course, it will only show you the time for users that have logged out, desregarding the fact that they might have logged in again.