In no genre that I've spent any time listening to have I found more of an issue with The Formula than modern country music. Let me be clear, it is not my intention to bash country music here, in fact, some of it I do very much enjoy (particularly Zac Brown), and I am someone who will never try to put someone down for having particular likes or dislikes. It is not my goal to explain why you should dislike something, but merely express why I myself do.
It's not the style. It's not the timbre. It's not the instruments or the predictable verse-chorus-bridge structure.
It's the dishonesty of the music.
So much of modern country feels forced to me. Rather than writing a song and finding a style that suits the content, it's the other way around. Artists choose a genre and find the lyrics to match and it doesn't feel very real. Above all, this comes from lyrical content, all the welcome clichés of trucks and dirt roads, pretty girls in cowboy boots on a Friday night drinking from red solos cups all summer long. We've heard it before, and that's exactly why we're hearing it again.
That's not to say something has to be entirely original or unique to be honest or worthy of merit, but the specificity of the items pulled from the barrel of possible country lyrics is what tires them out. There are love songs and heartbreak songs across the genres that don't say anything particularly new, but the concepts of them still feel vague enough and universal enough to not feel like they're pandering or commercially targeted.
The point at which I decided this was a topic worth writing about was while listening to the latest album of one of my favorite bands, Green River Ordinance. It pains me to say anything negative about the band, and they are doing well with this album. Good for them, I'm proud of them, but in terms of my own enjoyment in listening to them, they've lost me with Fifteen.
GRO had been trending in the country direction for a while. Their previous release, Chasing Down the Wind, had stripped away the electric guitars and gotten a lot more of the folksy Americana violin-tinged style. The songs themselves though still sounded like the same band, in fact I thought the change in instrumentation suited them far better than the sometimes overly-produced alt/rock direction of their previous albums.
When Fifteen came out, it took me a while to get around to listening to it. I had read an article about their battle with Billboard or one of the other big chart bodies about how they hadn't been accepted on the country charts, and saw a lot of comments about how they were trying too hard to be country. Having heard their previous release, I assumed that the music was probably similar and was on the band's side, but once I started listening through the album, I found myself very disappointed.
I actually didn't even finish the album. I got a ways into the fourth track, "Simple Life," and gave up on it. The song talks about loving the simple life, complete with front porches in front of green grass and open skies, Willie and Waylon tunes, grill smoke, working with hands, etc. For those of a similar age demographic to myself, it reminded me of Mr. Hyunh's country hit from that one episode of Hey Arnold (which to be totally honest is actually pretty damn good). It's pandering, it's tired, it's been done before. The funny thing is, in a way GRO's old lyrics weren't exactly unique. They were sentiments you've heard before in other songs, but they were vague enough to still feel real. They weren't so targeted as these.
I just saw a Bo Burnham clip over the past week from one of his specials that talked about The Formula in country, and I thought it was pretty accurate and funny (although I actually do enjoy a fair bit of Keith Urban and think he is far from the biggest culprit), and I think it's the perfect way to wrap up my thoughts on this. Watch it here (be aware there's strong, crude language).
As a performing musician, especially one that frequently plays hours of covers in pubs, it's inevitable that you're going to receive requests from your audience, and you sit on somewhere along a spectrum between loving it and hating it.
On the one hand, it means someone is engaged with what you're doing. Or you could take it to mean that they're not satisfied with the songs that you've been playing. I'd say in the vast majority of cases, it's the former, but as one of many introverted singers, the alternative does creep into your head from time to time.
Myself, I sit somewhere in the middle of this spectrum, and slide left and right on any given night. It's fun to play something for someone generally, especially if they want to hear something a little different than the average person. But what gets frustrating is the monotony of the songs requested, or having to feel like you're at fault and have to apologize for not knowing a particular song. I am not a jukebox - I am a living, breathing person with likes and dislikes. I can't just have a file programmed into my system and have it there forever. Learning a song takes time, especially for someone like me who feels the need to not use a music stand and keep everything memorized. It takes listening to the song enough times to have the outline and lyrics and melodies and dynamics to engrain themselves in my mind before I can move on actually getting it performance ready. Therefore, I tend only to learn songs I enjoy.
Her: Do you know any Justin Bieber?
Me: No I don't, sorry!
I generally dread when I see someone approach me at a gig while I'm playing, not because I hate taking requests, but I always assume the worst is coming - some scenario like this where I try to remain polite and respectful of someone's musical tastes, while I'm internally just getting really flustered. I don't do well with conflict, and I'm not one to sass back to someone unless they manage to really set me over the edge. I generally encourage folks to let me know if they think of anything else they might like, and I'll do my best to play it for them if I can. Unless they're relentless with requests that I don't know, I usually avoid handing them my repertoire list except as a last resort, because that usually ends badly for me. One year on St. Patrick's Day that happened, and rather than lessening my struggle, it turned into a drunk person coming up to me about 9 times while I was mid-song, often mid-line, to put in a steadily overflowing queue of songs he and his friends wanted to hear. One song in particular he did this to me three times before it was finished.
One of the strangest phenomena to me is the stalwart requests that everyone has. The Wagon Wheels and Wonderwalls of the world. The inevitable "do you know any Johnny Cash?" from people ranging age 9-99. Again, I'm not one to bash anyone's musical tastes, but it's just hard to grasp why, in the whole wide world of music, everyone always sees an acoustic guitarist and immediately wants to hear these songs. I have nothing against Johnny Cash, I've grown to like some of his stuff, I appreciate his importance in the world of music, but I don't really listen to him, and therefore don't have any of his music in my repertoire. I do know Wagon Wheel, I do know Wonderwall, and if you ask me (please don't...) I will play them for you, albeit somewhat begrudgingly. But at this point I've had to play them so many times that I will only do them by request anymore. At times in my life, I enjoyed both of those songs, but they've just been irreversibly run into the ground for me.
Are these really the songs you listen to all the time? I'm positive that more often than not that is not the case. You just want to be involved and make a request, and default to the go-to's that everyone knows, or that you assume everyone does. But the issue here is I don't want to be everybody. Not in a hipster kind of way, I am certainly far from that, I just want to be seen as an individual. I want people to go to the bar to hear Ryan Sweezey, not to hear some singer guy with a guitar. I've prided myself on building a huge catalog of songs I can play to please all ages while still being a bit out of the ordinary and true to my own likes and dislikes. I don't play songs nobody knows, I try to play the songs they do know but don't hear all the time, and save for the Johnny Cash fans of the world, I get as many compliments on my set lists as I do any other aspect of my performance. I've had regular spectators who reassure other folks that if I don't know their request, they shouldn't worry because they will hear plenty that they enjoy. But there are still those times when someone just gets so fixated on one particular thing that if I can't do it, I become the enemy.
In the end, at these types of gigs in particular, I'm being paid to give the people what they want, so it's really just about finding the balance between accepting the inevitable and being able to still enjoy what you're doing. Sometimes you just have to grit your teeth and push on through stuff you don't like playing. If you're a performer, you know this struggle, and you either embrace it or soldier through it. If you're a spectator, please don't think me bitter, just envision yourself in my shoes and try and be as respectful of your entertainer as they are trying to be to you. My goal here is not to complain, it's simply a statement of my observations. At the end of the day, I get to do something I love doing for a living. It's hard to call it work, but sometimes instances like these drain a bit of the enjoyment out of it. I'm going to accommodate you if I can, but I shouldn't feel like I'm inept or in the wrong for not knowing how to play something in particular.


Explore the role of trade from a historical perspective on human survival and life; the relationship and impact of trade on society and social development structure; revise the shortcomings of professional history; return to the care of Chinese culture and thought.
Education, firstly, is to educate students. University education should teach students to be a human being first, then deliver knowledge and make instructions. We should cultivate students' abilities of critical thinking, judgment and creativity instead of merely passing on knowledge; It's our duty to broaden students' horizon, promote personality formation, arouse their awareness of autonomy and interestingness.
History of World Trade has made profound academic and social impact on getting rid of the limitations of western theories and western historical theories and formulating subjective cognition of Chinese culture.
The two comments on the Beijing News have provided realistic reflection on the current debate over the concept and the road of the economic development of China and have a relatively great impact on our society.
History of World Trade, China Renmin University Press, 2009.
Micro-ecological Reconstruction of County Economy: Innovative Thought on Supply-side Reform, Chinese Development Economics Committee.
Subject Report on Chinese Food Circulation; White Paper on College Students' Entrepreneurship, etc.
2016.11.21 Though the Debate over Lin (Planned Economy and Market Intervention) and Zhang(Market Economy and Market Freedom) was Over, We Should not Leave the Issue an Academic Debate.


I love brightly coloured postcards. Here are a few of my favourites.
I like collecting black and white cards. The photos from times past show a different way of life. they provoke such memories and thoughts.


Microsoft has been avoiding giving away the battery capacity of the new Surface Go and now we can see why. The small 26 Wh battery of the Surface Go has us wary about battery life as this is almost half the capacity of last year's Surface Pro.
The Surface family of Windows tablets is notorious for being difficult to service with questionable quality control in some cases. The latest 10-inch Surface Go does nothing to buck the trend and it even cuts some corners in order to reach the lucrative $399 starting price point.
According to a teardown by iFixit, the Surface Go carries a very small 26.12 Wh internal battery compared to the 45 Wh and 33 Wh batteries of the Surface Pro 5 and 2018 Apple iPad, respectively. Thus, it's unlikely that the Surface Go can actually last for the full 9 hours of runtime that Microsoft is claiming on its product page. Unless, of course, you plan to idle on desktop at the lowest brightness setting possible.
Aside from the battery, the source has noted that the Surface Go continues the brazen use of adhesives instead of screws not unlike its older siblings. The result is yet another Surface tablet that is user-unfriendly for servicing or repairs, which is something HP has been capitalizing on for its Elite x2 series of competing Windows tablets. A final "Repairability Score" of just 1 out of 10 was awarded to the Surface Go. In other words, be prepared to replace the entire tablet if even a single module or part becomes faulty.


text:
Last updated in April 2018
Background Constitutional History
The Constitution of the Republic of Korea is the supreme law of the Republic of Korea (South Korea). Between 17 July 1948, the date of adoption of the first Constitution, and 1987, the Constitution was amended nine times and six republics were established. South Korea adopted its current democratic constitution on 29 October 1987.
The 1948 constitution established a system where the president was elected by the national assembly. The first amendment in 1952 was enacted during Rhee Syngman and introduced a directly elected president and a bicameral parliament, despite initial proposals to establish a parliamentary system. Rhee Syngman was reelected the following year. Syngman subsequently amended the constitution in November 1954 to remove term limits to allow him to run again, following mathematical maneuvers where the 2/3 majority required was approximated to the integer closest to the exact figure. In exact figures, a 2/3 majority meant support from 135.33 members of parliament out of the total 203 members. The amendment only received 135 votes. The government argued that the 2/3 majority was achieved as 135 was the closest integer to 135.33. The unlimited term for the presidency in this controversial amendment was to apply only to the first president of the Republic.
Following the popular protests and student revolution in response to rigged elections in 1960, which eventually led to the resignation of Syngman, the constitution was amended in June 1960 to introduce a parliamentary system of government, constituting the Second Korean Republic. This was followed by another amendment in November 1960 which, in response to popular demands for punitive measures, allowed the retroactive punishment of those guilty of election irregularities, corruption and appropriation of public property-under the inclusive designation of 'anti-democratic' acts.
The fifth amendment to the constitution in December 1962 gave birth to the Third Republic. The then newly installed government proved incapable of asserting its authority following the departure of strong man Syngman. This precipitated a military coup in December 1962, led by Park Chung-Lee. The military junta dissolved parliament. While the constitution theoretically continued in force, the emergency law had precedence. The ruling junta established a committee to draft a new constitution. Public hearings and panel discussions were held on a nationwide basis and findings were referred to the Supreme Military Council for final review before the draft Constitution was put to a referendum. The presidential system was retained in the new Constitution. The token public engagement in the drafting process was aimed at countering the prevailing complaint that the regime was dictatorial and enjoyed little popular support.
The ruling party undertook another (sixth) constitutional amendment in October 1969 to authorize a third term for the general turned President Park Chung-Lee. Despite strong resistance from the opposition, the amendment was passed in the Assembly and approved in a referendum.
President Park, then in his third term, suddenly invoked martial law, ostensibly in anticipation of a projected North-South Korean dialogue in December 1972. The constitution was suspended and the National Assembly was dissolved by an extra-constitutional power. Soon the State Council, temporarily substituting the Assembly, took up a constitutional amendment bill, which was approved with 91.5% in a referendum, launching the Fourth Republic. This constitution brought about the so-called 'Yusin Ch'eje' (Restoration Order). Under this constitution, ostensibly designed to expedite reunification and to give legal backing to what was claimed to be the 'Korean style democracy', the president was vested with nearly unlimited powers overriding the other separate branches of government: he was free to serve as many terms as the National Congress for Reunification may decide; he could name one-third of the members of the National Assembly and dissolve the legislature; he could appoint judges, including the chief justice, and; he was authorized to issue extraordinary measures which could suspend constitutional provisions.
Process of Adoption of the 1987 (current) Constitution
The 'Restoration Order' came to a sudden end with the assassination of the president. Another coup was staged in the ensuing interregnum. On the initiative of the interim president, a new amendment was drafted by the Constitution Deliberation Committee operating under the prime minister, and approved in a referendum in October 1980, establishing the current and Fifth Korean Republic. Under this Constitution, the president would serve only one seven-year term. Although the extension of the presidential term was possible by constitutional amendment, such a change would not apply to the president in office. This explicit prohibition of constitutional amendment for extended rule was a distinctive component of the new constitution. True, the new constitution removed many undesirable provisions in the Restoration Order Constitution; but it still conferred a vast authority on the president. In form, the Constitution of the Fifth Republic was drafted according to established legal processes. Under martial law, however, political activity was banned and freedom of speech suppressed.
The constitution was amended in 1987 as a result of the people's aspiration for enhanced democracy. The proposed amendment was submitted to the National Assembly on 18 September 1987, passed at the legislature on 12 October, confirmed through a public referendum on October 27 with 93%, and finally promulgated on 25 February 1988. This amendment was achieved through government-opposition collaboration, for the first time in Korean constitutional history. In this sense, the constitution has more legitimacy than does any earlier amendment. Pivotal in this amendment is the election of a president by direct popular vote, restored after a 15-year aberration of indirect vote. The president is to serve only one five-year term. The power of the legislature is strengthened, and individual rights are further protected under the constitution. While the powers of the legislature were boosted to allow it to check the executive branch, the extensive presidential powers remain, tilting the balance in favor of the latter. The constitution has not been amended since 1987.
Recent Constitution Reform Efforts
There is growing public demand for revising 'the 1987 Constitution', which is in reality an amendment to the former constitution. Most of all, South Korea has yet to find the best balance for the executive power under a hierarchical political tradition. In 2016 and 2017, the political scandal that led to the removal of President Park's from office revived a long-simmering argument that constitutional reform is necessary to reduce the president's powers. Due to the extensive powers of the presidency, Korean politicians are obsessed with winning in the presidential election and becoming the 'ruling party'. Rather than engaging in dialogue and compromise with the opposing party, elected presidents rely on informal toolboxes, i.e., patronage politics, clientelist favoritism and regional loyalties, to ultimately win legislative support. Furthermore, the president can neutralize political opponents through his 'political weapons' namely, the Prosecutor General, the Chief of the Police Agency, the Chairman of the Board of Audit and Inspection (BAI), and the Commissioner of National Tax Service. Thus, South Korean presidents exercise concentrated and personalized presidential power, undermining democratic political institutions. While also proposing the reduction of the powers of the president and the enhancement of the powers of parliament and the prime minister, there is also strong support for the removal of the prohibition on reelection. The permission of reelection is said to allow incumbents to deliver with a view of renewing their mandate and also address the challenge where single term presidents lose political steam in the last years of their term.
Moreover, the current court structure is too overbearing and authoritative. Recently, there have been allegations that the National Court Administration (NCA) kept a secret list of judges and their political orientations and used it as a gauge for decisions on promotion. Under the current system, the president nominates the Chief Justice of the Supreme Court who then de facto appoints court justices and all other judges. Simultaneously, the independence and expertise of institutions such as the Board of Audit and Inspection (BAI), the Prosecutor General, and Commissioner of National Tax Service must be stepped up to better protect the rights of the public.
In addition, the reform proposal is likely to open possibilities for other reforms. There are some rights that exist in theory but have yet to be incorporated into case law that should be added to the constitution, such as right to live (safely), the related rights to information, rights of consumers, right to conscientious objection, right of asylum, etc. There is also proposals for the decentralization of powers and the inclusion of mechanisms for direct democracy to allow citizens to propose laws.
The System of Government in the Current Constitution
Consisting of a preamble, 130 articles, and supplementary provisions, the constitution provides for an executive branch headed by a president and an appointed prime minister, a unicameral legislature called the National Assembly, and a judiciary consisting of the Constitutional Court, Supreme Court and lower courts.
The constitution vests legislative power in the unicameral National Assembly, which consists of at least 200 members. Currently, it has 300 seats. Three-quarters are elected from single-member districts for a term of four years. The remaining members are appointed through a proportional allocation of seats to political parties. The latest election was held in 2016, and the next election will be in 2020. The National Assembly elects a speaker and two deputy speakers, which in reality means that the majority party determines who the speaker will be. The Assembly can override presidential vetoes with a two-thirds majority.
The president, who is the head of state and government, is elected by direct popular election once every five years through the first-past-the-post plurality system and cannot serve more than one term. The president cannot dissolve the National Assembly and is also prohibited from issuing emergency decrees covering the whole range of state affairs. However, the president can still proclaim martial law and grant amnesty. Upon the proclamation of martial law, the president must notify the National Assembly without delay. If the Assembly requests the lifting of martial law with an absolute majority of its total membership, the president must comply. The president appoints a cabinet consisting of no more than thirty posts for the State Council, among them a prime minister and a deputy prime minister. The appointment of the prime minister requires the consent of the National Assembly. The president and the central bureaucracy continue to be the dominant forces in South Korean policymaking through the presidential authority to table bills before the legislature, which outnumber the number of bills proposed by the legislature itself, and through decrees. The National Assembly can propose to the president the dismissal of the prime minister and state ministers. The recommendation is not binding.
The judicial branch consists of the Constitutional Court, the Supreme Court, and lower courts, such as the Family Court and the District Courts. The president appoints the Chief Justice and other justices of the Supreme Court upon the recommendation of the Chief Justice and with the consent of the National Assembly. Judges other than the Supreme Court justices are appointed by the Chief Justice with the consent of the Conference of Supreme Court Justices. There is no jury system.
In particular, the Constitutional Court was formally established in September 1988. Based on the European model, it is a specialized court that exclusively determines (1) the constitutionality of laws upon the referral of regular courts; (2) impeachment; (3) the dissolution of a political party up on the request of the government; (4) competence disputes between central government agencies, between central government agencies and local governments, and between local governments; and (5) constitutional complaints as prescribed by law. Notably, decisions of the Court on the unconstitutionality of a law, impeachment, dissolution of a political party, and constitutional complaints require the concurrence of at least six of the nine judges.
The nine members of the Constitutional Court are appointed for a renewable six-year term by the president (three members), the National Assembly (three members), and the Chief Justice (three members). The head of the Court is appointed by the president with the consent of the National Assembly.
System of Government under the 1987 Constitution
Direct popular election through the first-past-the-post system. President serves a single five-year term.
Head of State;
Head of Government;
Commander-in-Chief of the Armed Forces (to declare war);
Top diplomat and foreign policy maker;
Chief policy maker and key lawmaker;
Can veto bills subject to a two-thirds majority veto override by the National Assembly.
End of term;
Resignation;
Demise;
Impeachment.
(PM)
Appointed by the president with the consent of the National Assembly (NA)
The vice chairman to the cabinet, directing the executive ministries under order of the president;
Consultation of ministers for appointments of the president;
Replacing the president on an acting capacity if the president is not in a position to carry out her or his duties.
Dismissal by the president;
Resignation (or when NA passes recommendation for removal).
State Council
(Cabinet)
Composed of the president, the Prime Minister, and other ministers whose number shall be no more than thirty and no less than fifteen.
Ministers are appointed by the president after recommendation with the PM.
Deliberating on important national policies that fall within the power of the Executive
Dissolution or dismissal by the president;
Popular vote of at least 200 members (currently 300 National Assembly members): 3/4th appointed by single-member district, and 1/4th appointed by proportional representation;
Electoral gender quota system requires political parties to include at least 30 per cent of female candidates in their district nominations and 50 per cent of appointed proportional representatives.
In addition to its legislative power, the NA decides upon budget bills submitted by the Executive;
Consent for the ratification of treaties and declarations of war;
Overseeing the government;
Impeaching the president, other officials and justices for violating the constitution.
End of four-year term.
Consists of a Chief Justice and 13 Associate Justices who are appointed by the president for 6-year terms;
Only the Chief Justice cannot be re-appointed.
Hears appeals from decision by second level of district courts or appeals from decision of High Courts.
Chief Justice: a single six-year term
Associate Justices: six-year term;
Attainment of retirement age of 70;
Impeachment;
Incapacity.
Appointed by the Chief Justice with the consent of the Conference of Supreme Court Justices.
Functioning as court of first appellate court as well as those cases designated by law.
Ten-year term;
District Court (Family court, etc.)
Primarily courts of general original jurisdiction, hearing both criminal and civil cases.
Consisting of nine members: appointed by the president (3 members), the National Assembly (3 members), and the Chief Justice (3 members).
The constitutionality of a law upon the request of the court;
Dissolution of a political party;
Competence disputes between state agencies, between state agencies and local governments, and between local governments;
Constitutional complaints as prescribed by law.
Six-year term;
1945 After World War II, Japanese occupation ends with Soviet troops occupying area north of the 38th parallel, and US troops in the south.
1948 Republic of Korea proclaimed.
1950 South declares independence, sparking North Korean invasion.
1953 Armistice ends Korean War, which cost two million lives.
1950s South sustained by crucial US military, economic and political support.
1960 President Syngman Ree steps down after student protests against electoral fraud. New constitution forms Second Republic, but political freedom remain limited.
1961 Military coup puts General Park Chung-hee in power.
1963 General Park restores some political freedom and proclaims Third Republic. Major programme of industrial development begins.
1972 Martial law. Park increases his powers with constitutional changes.
1979 Park assassinated. General Chun Doo-hwan seizes power the following year.
1980 Martial law declared after student demonstrations. In the city of Gwangju, army kills at least 200 people. Fifth Republic and new constitution.
1981 Chun indirectly elected to a seven year term. Martial law ends, but government continues to have strong powers to prevent dissent.
1986 Constitution is changed to allow direct election of the president.
1987 President Chun pushed out of office by student unrest and international pressure in the build-up to the Sixth Constitution. General Roh Tae-woo succeeds President Chun, grants greater degree of political liberalisation and launches anti-corruption drive.
1988 First free parliamentary elections. Olympic games in Seoul.
1993 President Roh succeeded by Kim Young Sam, a former opponent of the regime and the first freely-elected civilian president.
2002 December - Roh Moo-hyun, from governing Millennium Democratic Party, wins closely-fought presidential elections.
2007 December - Conservative Lee Myung-bak wins landslide victory in presidential election.
2012 July - South Korea begins move of most ministries to 'mini capital' at Sejong City, 120km south of Seoul. Key ministries will remain in Seoul.
2012 December - South Korea elects its first female president, Park Geun-hye, of the conservative Saenuri party. She takes office in February.
2014 April - Sewol ferry sinks off west coast, killing at least 281 people, mainly high-school students.
2014 December - Constitutional Court bans left-wing Unified Progressive Party, accused of being pro-North Korean.
2015 November-December - Mass protests in Seoul against government's economic policy and insistence on schools' using state-approved history books.
2016 October - President Park Geun-Hye is embroiled in a political crisis over revelations that she allowed a personal friend, with no government position, to meddle in affairs of state.
Dec 9 - Parliament votes to impeach Park. She is stripped of powers while awaiting a court decision on the vote. Prime Minister Hwang Kyo-ahn becomes acting president.
2017 March 10 - Constitutional Court upholds parliament's vote to impeach Park, removing her from office.
May 10 - The center-left candidate Moon Jae-in is elected president.
The Constitution of the Republic of Korea
The Reviews of the 1987 Constitution, The Special Committee on Constitutional Amendment of the National Assembly
Cho, Jung Kwan 'The Politics of Constitution-Making During the 1987 Democratic Transition in South Korea' (2004) 35(2) Korea Observer 171-206.
Guichard, Justine 'In the Name of the People: Disagreeing over Peoplehood in the North and South Korean Constitutions' (2017) 4(2) Asian Journal of Law and Society 405-445.
Jonsson, Gabriel Consolidation of democracy in South Korea? (Acta Universitatis Stockholmiensis, 2014).
Kil, Sŭng-hŭm and Chung-in Moon Understanding Korean Politics: An Introduction (Albany: State University of New York Press, 2001).
Park, Myung-Lim 'Original Peculiarities of Constitution and Democracy in South Korea' (2010) 41(2) Korea Observer 221.
16 Oct 2020 Indictment of South Korean legislators for election violations may impact constitutional reform efforts
8 May 2020 In South Korea, motion to allow voters to propose constitutional amendments fails
4 May 2020 In South Korea, ruling party kindles debate on revising constitution
16 May 2018 Presidential Proposal for Constitutional Revision in South Korea: Unlikely to be Passed but Significant Step Forward

redpajama_set_name: RedPajamaCommonCrawl


The Egyptian food retail sector is dominated by small, traditional, grocery retailers, with an estimated 98% of trade passing through these stores, street vendors and unregulated markets. Although there are only a few local supermarket chains, they are currently responsible for 15% of total food sales, a percentage that is expected to rise given the country's growing middle class and increasing rate of urbanisation.
Despite the risks associated with political instability, Egypt is considered to have great potential as it is has the largest market in the Arab world with a population of more than 90 million people. Egyptians spend on average 50% of their income on food and groceries and with a large percentage of the population relying on food subsidies, the value of food retail sales is expected to reach US$67.37bn by 2017. Although Egypt's online retail offering is still a novelty and not widely used, the general growth patterns in Egyptian retail and its youthful population indicate potential for strong online retail growth. However, currently only 10% of the population is banked, only 17 million people have credit or debit cards and mobile money is still a relatively new concept.
The Egyptian Food Retail report examines current conditions, investment in the sector and other developments such as the entrance of foreign retailers like France's Carrefour, the world's fourth largest retailer. The company entered Egypt in 2002 and now runs a network of hypermarkets, supermarkets and express shops in partnership with UAE-based Majid Al Futtaim (MAF). In total 19 companies are profiled, including the Mansour Group, which owns both the Metro supermarket chain, the largest in the country, and the Kheir Zaman discount store chain. Also profiled is ExxonMobil Egypt (SAE) which operates 25 "On-the-Run" convenience stores and plans to open another 25 in the near future.


The MOOCK portable Bluetooth speaker is seeing a nice discount on Amazon right now, shaving off 50% off its original price if a discount coupon code is applied.
Though the market is flooded with Bluetooth speakers, but there are a very few good ones. When we came across the MOOCK Bluetooth speaker, what caught our eye the most is that it has a 5-star rating on Amazon. That's pretty good news if you are asking us. And things are topped off with a discount on a price tag that's already too low. Can we say no to that? Obviously not.
So what does the MOOCK speaker offer? First of all, it touts amazing sound quality with a significant amount of bass given its price tag. It even features a built-in microphone if you wish to attend phone calls using this. Furthermore, you have multiple options when it comes to interfacing with this speaker. You can either use Bluetooth or even an aux cable if you like.
You can grab this deal straight from Amazon, but make sure you apply the coupon code before checkout in order to avail the discount. Furthermore, this deal is live till the 10th of March, which gives you plenty of time to make a decision regarding this.


text:
Q: trainHog opencv sample assert positive count i am trying to train inria dataset using trainHog opencv example, and i'm getting the assert there, what i'm doing wrong?
clog << "Histogram of Gradients are being calculated for negative images...";
    computeHOGs(pos_image_size, neg_lst, gradient_lst, flip_samples);
    size_t negative_count = gradient_lst.size() - positive_count;
    labels.insert(labels.end(), negative_count, -1);
    CV_Assert(positive_count < labels.size());

redpajama_set_name: RedPajamaStackExchange


Retail and trade are in the DNA of Dutch people. Whether it is cycling, fashion, decoration or some other trade, Dutch brands and companies are known worldwide. Discover the Overijssel retail companies and their export ambitions.


MOQ 1 Certification ETL, DLC, CE, RoHS Model: YR-WL112-W150 Brief Description: Full-cut off wall pack: 1. Cree/Samsung LEDs. 2. Meanwell driver. 3. Lamp luminous >110lm/w. 4. 5 years warranty. 5. CE ETL DLC certificate. 6. OEM.


text:
Prefabricated Concrete Outhouses
A Prefabricated Concrete Outhouse Ready for Loading
Photo from R. Walker
Used by permission Prefabricated Outhouses are popular purchases by the government and states.
Once a prefabricated outhouse is built, it must be loaded on a large truck for transport to its new home. Large cranes lift it onto the truck. The same cranes are sometimes used to lift yachts out of the water in the Fall.
Ever wondered how they might load
and transport a concrete outhouse?
Used by permission
These prefabricated outhouses come in single, double and larger sizes. Here is a finished men's and women's Outhouse.
A Beautiful Finished Concrete Outhouse
These photo's were contributed by R. Walker and he works for CXT Incorporated located in Spokane, Washington in the precast engineering department. He recently visited my web site and felt that photos from CXT Incorporated may contribute to the variety of outhouses that we have on display. Their main customer is the U.S. Forest Service, although they do sell many concrete outhouses to private parties and contractors. They fabricate six different models of vault building and several different models of flush buildings. They currently produce 800 to 1000 buildings a year and have over 4000 buildings located in the field. Their buildings are made of precast reinforced concrete in a variety of textures, and come delivered to the job site 100% finished. They even come with the toilet paper. They currently have buildings located all over the U.S. including Florida, California, Alaska, and even Hawaii. Their web site can be found at www.cxtinc.com.
This Home Page was created on September 11, 2000
Most recent revision September 11, 2000


text:
SsangYong unveils the international Rexton
Favorites Print page
The SsangYong Rexton is a body-on-frame SUV that went into a new generation in 2017, but never became particularly popular on the market. The South Korean company now unveils its "brand new" international version, which is technically a mid-gen refresh.
Compared side-by-side with its predecessor, the 2021 Rexton model sports an octagonal radiator grille, a new front bumper with smaller anti-fog lights, and LED-based headlights. The taillights get different lamps inside, and the rear bumper is slightly redesigned as well. At 4,850 mm (15.91 feet) long and 1,920 mm (6.3 ft.) wide, the car is identical to the pre-facelift version in two dimensions while gaining 25 mm (1") of extra height (now 1,825 mm / 6 ft.). The wheelbase spans 2,865 mm (9.4 ft.), and the clearance amounts to 224 mm (8.75"). Unlike the Korean spec with its 18-inch wheels, the worldwide model offers a choice of wheel sizes from 17 to 20 inches.
Inside, there are new door cards, a four-spoke steering wheel, a 12.3-inch digital dash cluster, a fixed-position gear joystick coming to replace the regular lever, and better overall trim materials. The infotainment system gets an update to support satellite navigation, Android Auto and Apple CarPlay, and a nine-inch touchscreen display that displays the video from the 360-degree cameras. The base trim includes a non-digital dash with a B&W screen and an eight-inch central display. Customers can opt for up to nine airbags. The Korea-spec Rexton always comes with five seats, while the global spec has an optional third row. Trunk size amounts to 784 liters (27.7 cubic feet), but increases to 1,977 liters (69.82 cu. ft.) with the second row folded down.
The 2.2-liter e-XDi turbo diesel remains in the range, but raises the output to 202 PS (200 hp / 150 kW) and 440 Nm (325 lb-ft) of torque. The old Mercedes 7G-tronic automatic makes way for a new eight-speed auto transmission. Select countries will receive the new Rexton with the old 2.0-liter gasoline turbo four-pot rated at 225 PS (222 hp / 165 kW) and 350 Nm (258 lb-ft) of torque, which can be paired with a six-speed manual or six-speed Aisin auto gearbox. Rear-wheel drive is standard for all specs, but AWD with its hard coupling on the front axle and reduction gear remains available. The power steering mechanism is now electric, rather than hydraulic.
Options include AEB, ACC, blind zone monitor, lane control and trailer assist. The diesel version can tow trailers weighing up to 3 metric tons (6,600 lbs).
The SsangYong Rexton hits the market in Europe next March.
Editor Andrew Raspopov
Forma car News
News permanent address:
https://www.formacar.com/en/news/view/31328.html
Actual themes
Alpine announces three EVs at once
20174 videos More videos
Forma Car Recommends
Car Tuning 15-01-2021
The Volkswagen Golf has stayed in the bestseller league since forever, which unfortunately also means it has become too commonplace of a sight. RaceChip and Barracuda have joined efforts to change that.
Check out a 30-year-old Caprice Hulkmobile
Streetside Classic is offering a very special lot on its website: a Chevrolet Caprice themed after The Hulk. The asking price of $40,000 may seem like much, but Spade Kreations – which was responsible for the build – claims that the paintjob alone cost that much back in 1989.
Alfa Romeo to launch Tonale SUV in November
Novelties 11-01-2021
The final production version of the Alfa Romeo Tonale will hit the spotlight in September 2021, and sales in Europe will start just two months after that, the automaker reports.
Video: New 911 Turbo S vs. 1000-HP M5 vs. 800-HP RS3
CarWOW has invited an owner of the newest Porsche 911 (992) Turbo S to a drag race against two seriously modded sedans: an Audi RS3 and a BMW M5.
Tokyo Auto Salon goes online for 2021
Auto Show 24-12-2020
With most automotive industry events canceled in North America, Asia and Europe, manufacturers move their premieres into the Internet and try to line things up so as not to get their viewers and participants stolen by another big event.
Six 1980s-era Mustangs go up on sale
Bring A Trailer has posted sale ads for as many as six third-gen Ford Mustangs, some of them among the rarest of their kind.
Check out this unique, lightly armored Ferrari 458 Speciale
AddArmor – an armored car maker based in Jackson, Wyoming – has quite an extensive portfolio already (watch the video for an example). However, its latest project is hands down one of the most unusual.
Hyundai, Kia showcase new dedicated EV platform
Technology 03-12-2020
Co-designed by the two leading Korea automakers, the e-GMP architecture lends itself exclusively to all-electric vehicles and will provide the basis for the Ioniq 5 SUV coming up next year.
Video: Ford MUDstang climbing hill after hill
If you were invited to a hill climb race, what kind of car would you pick for the job? Definitely not a muscle car like the Ford Mustang, right? Well, color us surprised: someone actually did just that.
Alpina explains why its 468-PS BMW i8 never saw the daylight
A year and a half ago, Alpina devised a complex performance upgrade plan for the BMW i8 hybrid coupe, but ditched it before production. Read on to find out why.
Mercedes-Maybach S-Class dials up luxury with new options
While Mercedes surely isn't in a hurry to reveal the engine lineup of the new Maybach S-Class, it still wants us to know what we can pay for to make the opulent executive saloon even more spectacular.
Ford unveils its SEMA lineup
Ford will be revealing a buggy-shaped Bronco Badlands Sasquatch Concept, a beefed-up Mustang Mach-E 1400 and a few other new vehicles at the upcoming online SEMA show.
Lamborghini Huracan STO debuts on official terms
The long-awaited Lamborghini Huracan STO (stands for 'Super Trofeo Omologata') is finally here. Let us see what this road-legal track weapon is all about.
Ferrari SF90 Stradale debuts as a 1,000-HP Spider convertible
Prancing Horse's flagship hypercar has dropped its top in the newest SF90 Spider edition, the world's fastest-accelerating car of its type that leaves even the Bugatti Veyron Grand Sport Vitesse and the Porsche 918 Spyder behind.


via Panay News, 05 Sep 2018: Unauthorised renovations made on a century-old church in the Philippines.
The Sangguniang Panlungsod's (SP) committee on tourism and cultural affairs has recommended the filing of charges against Monsignor Maurillo Silva, administrator of St. Anne Parish in Molo district for the unauthorized renovation of the Molo Church's convent.
The charges could be for violation of Republic Act 10066 (National Cultural Heritage Act of 2009) and the National Building Code, among others, according to the committee chaired by Councilor Candice Tupas.
An ancient chapel built during the 16th century Portuguese colonial period in historic Malacca will finally be restored by the local authorities.
Lent 2015 brought cheer to thousands of Catholics here with news that the ancient Rosary Chapel (Ermida de Rosario) will be restored, ending its days of neglect.
Malacca Museum Corporation (Perzim) has received the go-ahead from the management of St Peter's Church of Malacca to start work on the 466-year-old building and the land it stands on in Jalan Bunga Raya Pantai along Malacca River.
"With the permission granted, work will begin very soon," Perzim general manager Datuk Khamis Abas said yesterday.
Joseph Sta Maria, a representative of minority ethnic communities under the state Barisan Nasional's social service unit (Pembela), said the announcement brought joy not only to Catholics in Malacca but also nationwide.
A new book released earlier this week showcases the churches of Bohol, in their former and current state after the devastating 2013 earthquake that damaged a number of churches.
Two Cebu churches damaged by earthquakes last year are undergoing repair works. The older of the churches dates to 1599.


The purpose of this repository is to make prototypes as case study in the context of proof of concept(PoC) that I have written in my website: Accel Brain (Japanese). Especially, natural language processing, statistical machine learning, and deep reinforcement learning are main topics.
The basic theme in my PoC is a Lifehack, which is any technique that reduces the burden of our life and make it easier to control, or more convenient. Considering that many lifehack solutions are technological and obviously product design and development technology are kind of life which can be hacked, lifehack itself also can be purpose of lifehack. Because of this Autologie, a seemingly endless round of my PoC and technological prototypes is rotary driven by Selbstreferenz to repeat lifehack of lifehack cyclically.
In this problem setting and recursive solutions, this repository is functionally differentiated by compositions such as information collection, searching optimal solution, and focus booster. Each function can be considered an integral component of lifehack solutions. These tools make it possible to efficiency the process of contemplation and accelerate our brain, enabling provisions for the developments of other tools in this repository.
All code, implemented as in an algorithm of machine learning or data science, reflects the concept of proof of concept(PoC). Especially, natural language processing, statistical machine learning, and deep reinforcement learning are main topics.
pysummarization is Python3 library for the automatic summarization, document abstraction, and text filtering.
The function of this library is automatic summarization using a kind of natural language processing. This library enable you to create a summary with the major points of the original document or web-scraped text that filtered by text clustering.
Full documentation is available on https://code.accel-brain.com/Automatic-Summarization/ . This document contains information on functionally reusability, functional scalability and functional extensibility.
The function of pydbm is building and modeling Restricted Boltzmann Machine(RBM) and Deep Boltzmann Machine(DBM). The models are functionally equivalent to stacked auto-encoder. The basic function is the same as dimensions reduction(or pre-training). And this library enables you to build many functional extensions from RBM and DBM such as Recurrent Temporal Restricted Boltzmann Machine(RTRBM), Recurrent Neural Network Restricted Boltzmann Machine(RNN-RBM), Long Short-Term Memory Recurrent Temporal Restricted Boltzmann Machine(LSTM-RTRBM), and Shape Boltzmann Machine(Shape-BM).
As more usecases, RTRBM, RNN-RBM, and LSTM-RTRBM can learn dependency structures in temporal patterns such as music, natural sentences, and n-gram. RTRBM is a probabilistic time-series model which can be viewed as a temporal stack of RBMs, where each RBM has a contextual hidden state that is received from the previous RBM and is used to modulate its hidden units bias. The RTRBM can be understood as a sequence of conditional RBMs whose parameters are the output of a deterministic RNN, with the constraint that the hidden units must describe the conditional distributions. This constraint can be lifted by combining a full RNN with distinct hidden units. In terms of this possibility, RNN-RBM and LSTM-RTRBM are structurally expanded model from RTRBM that allows more freedom to describe the temporal dependencies involved.
The usecases of Shape-BM are image segmentation, object detection, inpainting and graphics. Shape-BM is the model for the task of modeling binary shape images, in that samples from the model look realistic and it can generalize to generate samples that differ from training examples.
The methodology of equivalent-functionalism enables us to introduce more functional equivalents and compare problem solutions structured with different algorithms and models in common problem setting. For example, in dimension reduction problem, the function of Encoder/Decoder schema is equivalent to DBM as a Stacked Auto-Encoder.
Cho, K., Van Merriënboer, B., Gulcehre, C., Bahdanau, D., Bougares, F., Schwenk, H., & Bengio, Y. (2014). Learning phrase representations using RNN encoder-decoder for statistical machine translation. arXiv preprint arXiv:1406.1078., p2.
According to the neural networks theory, and in relation to manifold hypothesis, it is well known that multilayer neural networks can learn features of observed data points and have the feature points in hidden layer. High-dimensional data can be converted to low-dimensional codes by training the model such as Stacked Auto-Encoder and Encoder/Decoder with a small central layer to reconstruct high-dimensional input vectors. This function of dimensionality reduction facilitates feature expressions to calculate similarity of each data point.
This library provides Encoder/Decoder based on LSTM, which is a reconstruction model and makes it possible to extract series features embedded in deeper layers. The LSTM encoder learns a fixed length vector of time-series observed data points and the LSTM decoder uses this representation to reconstruct the time-series using the current hidden state and the value inferenced at the previous time-step.
Shape-BM is a kind of problem solution in relation to problem settings such as image segmentation, object detection, inpainting and graphics. In this problem settings, Convolutional Auto-Encoder(Masci, J., et al., 2011) is a functionally equivalent of Shape-BM. A stack of Convolutional Auto-Encoder forms a convolutional neural network(CNN), which are among the most successful models for supervised image classification. Each Convolutional Auto-Encoder is trained using conventional on-line gradient descent without additional regularization terms.
My jupyter notebook: demo/demo_convolutional_auto_encoder.ipynb also demonstrates various reconstructed images.
Encoder/Decoder based on LSTM and Convolutional Auto-Encoder have a functional reusability to extend the structures to Spatio-Temporal Auto-Encoder, which can learn the regular patterns in the training videos(Baccouche, M., et al., 2012, Patraucean, V., et al. 2015). This model consists of spatial Auto-Encoder and temporal Encoder/Decoder. The spatial Auto-Encoder is a Convolutional Auto-Encoder for learning spatial structures of each video frame. The temporal Encoder/Decoder is an Encoder/Decoder based on LSTM scheme for learning temporal patterns of the encoded spatial structures. The spatial encoder and decoder have two convolutional and deconvolutional layers respectively, while the temporal encoder and decoder are to act as a twin LSTM models.
Chong, Y. S., & Tay, Y. H. (2017, June). Abnormal event detection in videos using spatiotemporal autoencoder. In International Symposium on Neural Networks (pp. 189-196). Springer, Cham., p.195.
demo/demo_spatio_temporal_auto_encoder.ipynb is a jupyter notebook which demonstrates the video recognition and reconstruction of video images by the Spatio-Temporal Auto-Encoder.
Full documentation is available on https://code.accel-brain.com/Deep-Learning-by-means-of-Design-Pattern/ . This document contains information on functionally reusability, functional scalability and functional extensibility.
pyqlearning is Python library to implement Reinforcement Learning and Deep Reinforcement Learning, especially for Q-Learning, Deep Q-Network, and Multi-agent Deep Q-Network which can be optimized by Annealing models such as Simulated Annealing, Adaptive Simulated Annealing, and Quantum Monte Carlo Method.
According to the Reinforcement Learning problem settings, Q-Learning is a kind of Temporal Difference learning(TD Learning) that can be considered as hybrid of Monte Carlo method and Dynamic Programming method. As Monte Carlo method, TD Learning algorithm can learn by experience without model of environment. And this learning algorithm is functional extension of bootstrap method as Dynamic Programming Method.
In this library, Q-Learning can be distinguished into Epsilon Greedy Q-Leanring and Boltzmann Q-Learning. These algorithm is functionally equivalent but their structures should be conceptually distinguished.
Considering many variable parts and functional extensions in the Q-learning paradigm from perspective of commonality/variability analysis in order to practice object-oriented design, this library provides abstract class that defines the skeleton of a Q-Learning algorithm in an operation, deferring some steps in concrete variant algorithms such as Epsilon Greedy Q-Leanring and Boltzmann Q-Learning to client subclasses. The abstract class in this library lets subclasses redefine certain steps of a Q-Learning algorithm without changing the algorithm's structure.
demo/search_maze_by_deep_q_network.ipynb is a Jupyter notebook which demonstrates a maze solving algorithm based on Deep Q-Network, rigidly coupled with Deep Convolutional Neural Networks(Deep CNNs). The function of the Deep Learning is generalisation and CNNs is-a function approximator. In this notebook, several functional equivalents such as CNN, Long Short-Term Memory(LSTM) networks, and the model which loosely coupled CNN and LSTM can be compared from a functional point of view.
Deep Reinforcement Learning to solve the Maze.
Black squares represent a wall.
Light gray squares represent passages.
A dark gray square represents a start point.
A white squeare represents a goal point.
Expanding the search problem of the maze makes it possible to describe the pursuit-evasion game that is a family of problems in mathematics and computer science in which one group attempts to track down members of another group in an environment.
This problem can be re-described as the multi-agent control problem, which involves decomposing the global system state into an image like representation with information encoded in separate channels. This reformulation allows us to use convolutional neural networks to efficiently extract important features from the image-like state.
demo/search_maze_by_deep_q_network.ipynb also prototypes Multi Agent Deep Q-Network to solve the pursuit-evasion game based on the image-like state representation of the multi-agent.
Multi-agent Deep Reinforcement Learning to solve the pursuit-evasion game. The player is caught by enemies.
Multi-agent Deep Reinforcement Learning to solve the pursuit-evasion game. The player reaches the goal.
Moving dark gray squares represent enemies.
There are many hyperparameters that we have to set before the actual searching and learning process begins. Each parameter should be decided in relation to Reinforcement Learning theory and it cause side effects in training model. This issue can be considered as Combinatorial optimization problem which is an optimization problem, where an optimal solution has to be identified from a finite set of solutions. In this problem setting, this library provides an Annealing Model such as Simulated Annealing to search optimal combination of hyperparameters.
As exemplified in annealing_hand_written_digits.ipynb, there are many functional extensions and functional equivalents of Simulated Annealing. For instance, Adaptive Simulated Annealing, also known as the very fast simulated reannealing, is a very efficient version of simulated annealing. And Quantum Monte Carlo, which is generally known a stochastic method to solve the Schrödinger equation, is one of the earliest types of solution in order to simulate the Quantum Annealing in classical computer.
Full documentation is available on https://code.accel-brain.com/Reinforcement-Learning/ . This document contains information on functionally reusability, functional scalability and functional extensibility.
This library makes it possible to design the Generative models based on the Statistical machine learning problems in relation to Generative Adversarial Networks(GANs) and Adversarial Auto-Encoders(AAEs) to practice algorithm design for semi-supervised learning.
This library provides the Adversarial Auto-Encoders(AAEs), which is a probabilistic Auto-Encoder that uses GANs to perform variational inference by matching the aggregated posterior of the feature points in hidden layer of the Auto-Encoder with an arbitrary prior distribution(Makhzani, A., et al., 2015). Matching the aggregated posterior to the prior ensures that generating from any part of prior space results in meaningful samples. As a result, the decoder of the Adversarial Auto-Encoder learns a deep generative model that maps the imposed prior to the data distribution.
pycomposer is Python library for Algorithmic Composition or Automatic Composition by Reinforcement Learning such as Q-Learning and Recurrent Temporal Restricted Boltzmann Machine(RTRBM). Q-Learning and RTRBM in this library allows you to extract the melody information about a MIDI tracks and these models can learn and inference patterns of the melody. And This library has wrapper class for converting melody data inferenced by Q-Learning and RTRBM into MIDI file.
Full documentation is available on https://code.accel-brain.com/Algorithmic-Composition/. This document contains information on functionally reusability, functional scalability and functional extensibility.
This is the simple card box system that make you able to find and save your ideas.
These modules are functionally equivalent to Python Scripts in AccelBrainBeat.
This is a demo code for my case study in the context of my website.
Accel Brain Code: From Proof of Concept to Prototype.
RTRBM, RNN-RBM, and LSTM-RTRBM for probabilistic time-series model.
Shape-BM for image segmentation, object detection, inpainting and graphics.


Abilities Community Services has been providing support since 1998, serving the lives of People with Autism, Down Syndrome, Mental Heath and other various diagnoses. Our members are employed providing services in community inclusion, education and training, residential support and supported Employment.
The City of Colwood employs members in City Hall, Fire Hall, Parks, Public Works and RCMP Detachment.
Bargaining in progress for current collective agreement.
The Township of Esquimalt employs members in City Hall, Fire Hall, Parks, Public Works and Recreation Centres.
The District of Metchosin employs members in City Hall, Fire Hall, and Public Works.
The District of North Saanich employs members in City Hall, Fire Hall, Parks, and Public Works.
The District of Oak Bay employs members in City Hall, Fire Hall, Parks, Public Works, and Recreation Centres.
The Town of Sidney employs members in City Hall, Fire Hall, ICBC, Parks, Public Works, and RCMP Detachment.
The District of Sooke employs members in City Hall, Fire Hall, Parks, and the Waste Water Treatment Plant.


text:
Q: How to fix "ERROR 1064 you have an error in your SQL syntax" in SQL coding The problem has asked me to write the SQL command to list the total sales by customer and by product, with subtotals by customer and a grand total for all product sales. However, the input I keep entering gives me back the results "ERROR 1064 (42000) at line 1: You have an error in your SQL syntax."
This is the code I have tried:
SELECT    CUS_CODE, P_CODE, SUM(SALE_UNTS*SALE_PRICE) AS TOTSALES
FROM      DWDAYSALESFACT NATURAL JOIN DWPRODUCT NATURAL JOIN DWVENDOR
GROUP BY  ROLLUP (CUS_CODE, P_CODE)
ORDER BY  CUS_CODE, P_CODE;

The results should show a CUS_CODE, P_CODE, and TOTSALES column.

A: As mentioned in one the comments from @Dai your query should look like this.
SELECT    CUS_CODE, P_CODE, SUM(SALE_UNTS*SALE_PRICE) AS TOTSALES
FROM      DWDAYSALESFACT NATURAL JOIN DWPRODUCT NATURAL JOIN DWVENDOR
GROUP BY  CUS_CODE, P_CODE WITH ROLLUP
ORDER BY  CUS_CODE, P_CODE;


This year's Father's Day celebration was all Liam. As in Liam led the celebrations with 100% on his own. Coming from a 2 yr old, I'm impressed.
I had no part in it because after Liam's nasty fever spike for most of last night, robbing me of any decent sleep as his warm little body climbed up and down my pregnant belly to cuddle up every 15 mins and me trying to cool him & monitor his temperature at the same time…I was pretty much a very exhausted grouch when morning came.
Thankfully our little dude felt 100% better when he woke up this morning, greeted his papa "Happy Papa's Day" after I told him it was papa's special day and proceeded to ask his daddy on his own if he could change "diapers", "nice shirt" and "sit papa car go out" if he was a "good boy" and "eat medicine".
Papa obliged of course (I mean, have you heard Liam when he requests for something? It's so hard to say NO), and gave me the entire morning to catch up on some rest and a round of prenatal massage/body wrap which was what I needed badly.
So yep, father & son went out on their own and seems like they had some great fun, judging by the photos above that the Bo sent me post lunch. Brownie points for managing to capture photos of them both by asking a stranger to help!
I'm so proud of my boys.


text:
Home Food & Drink Faultline Bar Owner Confirms Our Report that the Bar is in Fact...
Faultline Bar Owner Confirms Our Report that the Bar is in Fact Closed for Good on Melrose Ave
Photo by Paulo Murillo for WEHO TIMES
Co-owner of the Faultline Bar, Ruby De Fresno, has finally conceded and confirmed our report that the beloved Faultline Bar located at 4216 Melrose Avenue has indeed closed for good at its home location, and she admits that the bar is currently looking for a new home somewhere else.
De Fresno, who is actually listed as Ruby J. Nuno in the bar's liquor license, told Q Voice News that the Faultline will no longer be at the location where it was founded for the past 26 years (they cleared out in late 2020) and De Fresno is negotiating a new lease, possibly in Silver Lake.
"It was a difficult decision," she told Q Voice. "It was a decision to keep the business alive. Rent had something to do with it. We were hoping to stay, but it didn't work out."
Ruby De Fresno stated the contrary after WEHO TIMES broke the story that the bar was gone for good at the Melrose Avenue location. In two false statements under the fake name Ruby De Faultline, De Fresno vehemently denied the bar's closure, stating, "The Faultline Bar is still in business," and "Statements describing the Faultline and its exit from Melrose Avenue in the Weho Times' story are factually incorrect."
The bar's owner is now backtracking and admitting what WEHO TIMES originally reported on January 17, 2021. The old queer space everyone is familiar with is very much in fact gone and she is hoping to bring a new Faultline to a different venue.
De Fresno has also finally confirmed our report that the Faultline space had been cleared out of all the erotic art, signage and neon lights as a result of the closure.
She told Q News that before leaving, she had the iconic interior decor, including the illuminated phallus, removed for safekeeping at its future home.
"All the interior decor and artwork is in storage," De Fresno said. "The neon penis, neon clock, and other historic items are being preserved, including the larger-than-life, iconic Faultline leather men art pieces."
Unfortunately, the iconic outdoor signage sat inside the bar for weeks before it was thrown in the trash by the new co-owner of the space.
WEHO TIMES' readers and loyal patrons of the bar were saddened to read our report that the bar on Melrose was gone. Then they were incensed when the bar's owner stated that our report on the bar's closure was false. The backlash following the bar's statement was immediate and naturally, with the flick of a lie, we became "fake news" over night. Although Ruby De Fresno has yet to officially retract her statements and to strike another falsehood she told her followers about WEHO TIMES reporting the closure of the Gym Bar incorrectly to discredit and cancel this publication, finally getting honest with Q News is a move in the right direction. It removes all false hope that Faultline is still in business at 4216 Melrose Avenue.
Founded in 1994, the iconic Faultline Bar was known for its indoor and outdoor bars with a large outdoor patio area. It featured a mix of themed nights, go-go boys, DJs, live performances, outdoor parking lot events, and a long-standing Sunday beer bust destination known to attract upwards of 600 participants. The bar's liquor license is set to expire on March 31, 2021.
According to the Los Feliz Ledger, the Faultline space was a venue called the Red Rouge in the early 1960s, owned by Judy Garland's, then husband, Sid Luft. Legend has it that as the concrete floor was being laid down, the star put her handprint and signed her name on the cement slab behind the bar back in 1963.
Judy's handprint and autograph has been at this historical location for the past 58 years. The new owner has not been able to locate Judy's handprint, but he says he recognizes its historical value and plans to preserve it and have it continue to be part of the bar's history.
The Red Rouge morphed into the The Stud, a Levi/leather cruise bar from 1974 to 1988, and then morphed into Griff's, before it became the legendary Faultline Bar in 1994.
The former queer space faces some major changes in 2021. The new owner has some wild ideas for the new space. He told WEHO TIMES it will no longer be gay.
Editor's note: Ruby De Fresno has not returned several emails requesting a call for comment.
Previous articleCity of West Hollywood Congratulates President Biden and Vice President Harris on Inauguration Day
Next articlePeople 65 and Over Are Now Eligible to Receive the COVID-19 Vaccine
She was not a good business person at all & got rid of long term employees that customers liked when she took over. She changed the legendary atmosphere making it uncomfortable with a security guard walking around inside with a flashlight.
F. Thomas
It will no longer be gay? What if only gays show up? You won't be taking their money?
Ty Huber
You use the word iconic four times. Enough, already. There are other adjectives.
Paulo Murillo(@paulo-murillo)
Reply to Ty Huber
HAH!!! True. But to be fair, two of those are iconic's were take from quotes, so technically I only used two.
Paula Marana
y'all gonna get sued lmao
MadLove
Reply to Paula Marana
Y'all are dumb. A judge will ask lying Ruby whatever her last name is if the bar is open or closed. She'll say 'we're moving to a new home' and the judge will ask her again 'is the bar open or closed, yes or no, and she'll say, 'we're still in business, working on a new deal' and the judge will ask her again is the bar open or closed? The bar is closed. Why argue with the truth? Y'all are so dumb sticking up for a pathological liar lmao!
Mr Murillo is a failed community blogger that leverages rumors and opinions as fact to drive clicks for his failed column.
We encourage the WehoTimes to move Mr Murillo to an administration role in sales vs posting inaccurate articles or biased content.
VoteThemOut
Reply to jake
And yet the truth remains. The bar is closed.
I like him & his initial report was correct
Matt F
Thank you Mr. Murillo for the follow up. It's somewhat insane that their original statement called Weho Times liars when there was nothing contradictory in their "explanation". WT reported they closed, which they did, and will no longer be at their Melrose location, which is true. Maybe Faultline was mad that there was no indication in the article of them looking for a new space? But that still doesn't mean anything in the original breaking article was untruthful.
Had Weho Times reporting been more professional and articulated something to the effect that "THOSE LOCATIONS are no longer around, but we don't know about the future of the businesses–we're waiting to hear back from the respective owners" this wouldn't have happened. One time, fine a mistake. Twice? Sloppy. So while not fake news, it's misleading and you brought this on yourselves.


Shima is the eldest of four sisters born to parents from Eastern DR Congo. She lived in Burundi, Rwanda and Uganda before coming to Concord, NH then, finally Portland, ME, when she was 16.
Now through her work, Shima uses everything that she learned about adapting to new cultures, to help establish the New Mainers Integration Center. The center is currently in it's formative stage but the organizers hope to welcome foot traffic early next year. Immigrants will be able to come in to the center, eventually, to receive guidance on where and how to get started in their unique process of becoming financially independent citizens. The plan is that all this will be delivered with a cultural sensitivity, and an appropriate language, in a judgment-free zone. Help will include face-to-face resource sharing regarding everything a new arrival might face: job training, resume writing, education, health care, policies, customs, literacy, laws of the land, housing, and much more. It will be an information clearinghouse with people on hand to help new arrivals access the multitude of community supports available to them.
For more information you can contact Shima, the future Program Director of the New Mainers Integration Center.
Nagham and her family left Iraq in 2000 and lived in Jordan for years before being resettled in Alabama. Her family moved to Maine in 2009 and in 2012 she and 4 of her siblings opened a Middle Eastern restaurant called Babylon at Morrill's Corner, Portland.
Nagham talks about the process of starting a business with mentoring from SCORE and CEI and also shares their experience being scammed by an equipment rental company.
Music: Hussam "The Eye of God Be Upon You"- Composed by Zia Mayali.


text:
About LATN
Testimonial from students in partner institution
The Latin America Training Network is a 501(c)(3) foundation with the mission, "to facilitate Christian leadership development throughout Latin America and beyond."
LATN was created in response to a tremendous need in the Spanish speaking church. One of the challenges faced by the church in Latin America is how to bridge the gap between funders and strategic needs in Latin America. Many good ministries in Latin America would greatly benefit through a financial partnership in order to empower committed servant leaders who minister in areas where foreign missionaries are scarce. There are many good organizations which with financial help and human resources, would be able to maximize the potential they have in significantly strengthening and expanding the Church. Already, there is a growing number of Latin American leaders who are assuming international roles on the global stage of missions, theological education, and various other strategic ministries. The growing role of the "Global South" is having an impact on missions and the become However, by coming alongside many others, we are able to partner with men and women whom God has called to serve the church full-time.
As a foundation, the Latin America Training Network (LATN) has a very short history. In 2013 a committed team, working virtually, began putting together the documents for the creation of a foundation which would respond to the needs mentioned above. On October 7, 2014 the documents were submitted to the State of Florida requesting the creation of the Latin America Training Network. The request was approved and the foundation was given the following Employee Identification Number (EIN): 47-2161757. On September 19, 2016, the IRS approved LATN as a tax exempt organization with public charity status. Though the foundation is taking its first steps as a significant partner with sister organizations in Latin America, it will be partnering with ministries that have a track record of effective ministry. (A protocol has been developed to formalize a relationship with those ministries in a way that meets IRS legal standards and requirements.)
Although we anticipate that various qualifying organizations will use LATN as a partner in ministry in terms of financial support, the foundation will begin with assisting ProMETA, a Costa Rican nonprofit which has been training Spanish-speaking leaders at the Masters level since 2001. ProMETA makes ministry training and leadership development accessible by using the Internet to deliver its transformational learning process. Discussions are being held with other organizations who desire to develop a similar relationship with LATN.
When I think about my life, I think about life before ProMETA and after ProMETA because of...
ProMETA Testimonial
I'm very thankful for ProMETA. I've benefited greatly in my personal and ministry life and...
Student Testimonial
LATN is a ministry supported by those whom God has called to share kingdom resources for His glory
Amazon Prime Day – Support LATN when you shop
LATN partners with ProMETA
Give Biblical Training to Latin American Christians
Give via tithely
Give via Paypal
Copyright © 2021 Latin American Training Network (LATN)


text:
Jump to: Advantage West Midlands (AWM) | Advantage West Midlands (AWM) | Advantage West Midlands (AWM) Advanced Materials Project | AstraZeneca (Firm) | Birmingham Science City | Brazil. Coordenação do Aperfeiçoamento de Pessoal de Nível Superior (CAPES) | Brazil. Coordenação do Aperfeiçoamento de Pessoal de Nível Superior (CAPES) | British Council | Bruker Analytische Meßtechnik GmbH | Coordenacao de Aperfeicoamento de Pessoal de Ensinol Superior (CAPES, Brazil) | Daphne Jackson Trust | Dr. Reddy's Laboratories | Engineering and Physical Sciences Research Council (EPSRC) | Engineering and Physical Sciences Research Council (EPSRC) | European Regional Development Fund (ERDF) | European Research Council (ERC) | European Union (EU) | Fundación "Pedro Barrié de la Maza, Conde de Fenosa" | Guo jia zi ran ke xue ji jin wei yuan hui (China) [National Natural Science Foundation of China] (NSFC) | Johnson Matthey Plc. | Leverhulme Trust (LT) | Libya | Libya. | Oxford Asymmetry International plc | Rhodia Consumer Specialities Ltd. | Rhodia Consumer Specialties Ltd. | Royal Society (Great Britain) | Science City Research Alliance | SmithKline Beecham | Spain. Ministerio de Ciencia e Innovación (MICINN) | Technology Strategy Board (Great Britain) | University of Warwick | University of Warwick	| University of Warwick Postgraduate Research Scholarship | University of Warwick Undergraduate Research Support Scheme | Warwick Collaborative Postgraduate Research Scholarship (WCPRS)
Advantage West Midlands (AWM)
Brown, Thomas Joseph, Cumbes, Madeleine, Diorazio, Louis J., Clarkson, Guy J. and Wills, Martin (2017) Use of (Cyclopentadienone)iron tricarbonyl complexes for C–N bond formation reactions between amines and alcohols. The Journal of Organic Chemistry, 82 (19). pp. 10489-10503. doi:10.1021/acs.joc.7b01990
Del Grosso, Alessandro, Galanopoulos, Lavrentis-Dimitrios, Chiu, Cookson K. C., Clarkson, Guy J., O'Connor, Peter B. and Wills, Martin (2017) Strained alkynes derived from 2,2′-dihydroxy-1,1′-biaryls ; synthesis and copper-free cycloaddition with azides. Organic & Biomolecular Chemistry, 15 (21). 4517-4521 . doi:10.1039/C7OB00991G
Fu, Ying, Sanchez-Cano, Carlos, Soni, Rina, Romero-Canelón, Isolda, Hearn, Jessica M., Liu, Zhe, Wills, Martin and Sadler, P. J. (2016) The contrasting catalytic efficiency and cancer cell antiproliferative activity of stereoselective organoruthenium transfer hydrogenation catalysts. Dalton Transactions, 45 (20). pp. 8367-8378. doi:10.1039/c6dt01242f
Jolley, Katherine E., Clarkson, Guy J. and Wills, Martin (2015) Tethered Ru(II) catalysts containing a Ru–I bond. Journal of Organometallic Chemistry, 776 . pp. 157-162. doi:10.1016/j.jorganchem.2014.10.033
Fu, Ying, Soni, Rina, Romero, Maria, Pizarro, Ana M., Salassa, Luca, Clarkson, Guy J., Hearn, Jessica M., Habtemariam, Abraha, Wills, Martin and Sadler, P. J. (2013) Mirror-image organometallic osmium arene iminopyridine halido complexes exhibit similar potent anticancer activity. Chemistry - A European Journal, Volume 19 (Number 45). pp. 15199-15209. doi:10.1002/chem.201302183
Soni, Rina, Jolley, Katherine E., Clarkson, Guy J. and Wills, Martin (2013) Direct formation of tethered Ru(II) catalysts using arene exchange. Organic Letters, 15 (19). pp. 5110-5113. doi:10.1021/ol4024979
Darwish, Moftah O., Wallace, Alistair, Clarkson, Guy J. and Wills, Martin (2013) Use of tridentate TsDPEN/pyridine ligands in ruthenium-catalysed asymmetric reduction of ketones. Tetrahedron Letters, 54 (32). pp. 4250-4253. doi:10.1016/j.tetlet.2013.05.141
Moreton, Ben, Fang, Zhijia (Researcher in chemistry), Wills, Martin and Costantini, Giovanni (2013) Dissociation and hierarchical assembly of chiral esters on metallic surfaces. Chemical Communications, 49 (58). pp. 6477-6479. doi:10.1039/c3cc40805a
Bisset, Alexander A., Shiibashi, Akira, Desmond, Jasmine L., Dishington, Allan, Jones, Teyrnon, Clarkson, Guy J., Ikariya, Takao and Wills, Martin (2012) Synthesis and asymmetric hydrogenation of (3E)-1-benzyl-3-[(2-oxopyridin-1(2H)-yl)methylidene]piperidine-2,6-dione. Chemical Communications, 48 (98). pp. 11978-11980. doi:10.1039/c2cc36807b
Gosiewska, Silvia, Soni, Rina, Clarkson, Guy J. and Wills, Martin (2010) Synthesis and use of a stable aminal derived from TsDPEN in asymmetric organocatalysis. Tetrahedron Letters, Vol.51 (No.32). pp. 4214-4217. doi:10.1016/j.tetlet.2010.06.017
Johnson, Tarn C., Clarkson, Guy J. and Wills, Martin (2011) (Cyclopentadienone)iron shvo complexes : synthesis and applications to hydrogen transfer reactions. Organometallics, 30 (7). pp. 1859-1868. doi:10.1021/om101101r
Advantage West Midlands (AWM) Advanced Materials Project
Morris, David J., Clarkson, Guy J. and Wills, Martin (2009) Insights into hydrogen generation from formic acid using ruthenium complexes. Organometallics, Vol.28 (No.14). pp. 4133-4140. doi:10.1021/om900099u
AstraZeneca (Firm)
Bisset, Alexander A., Dishington, Allan, Jones, Teyrnon C., Clarkson, Guy J. and Wills, Martin (2019) Data for Synthesis and reduction reactions of pyridones and 5-acyl-2-methoxypyridines. [Dataset]
Forshaw, Sam, Matthews, Alexander J., Brown, Thomas Joseph, Diorazio, Louis J., Williams, Luke and Wills, Martin (2017) Asymmetric transfer hydrogenation of 1,3-alkoxy/aryloxy propanones using tethered Arene/Ru(II)/TsDPEN complexes. Organic Letters, 19 (11). pp. 2789-2792. doi:10.1021/acs.orglett.7b00756
Bisset, Alexander A., Dishington, Allan, Jones, Teyrnon C., Clarkson, Guy J. and Wills, Martin (2014) Synthesis and reduction reactions of pyridones and 5-acyl-2-methoxypyridines. Tetrahedron, 70 (40). pp. 7207-7220. doi:10.1016/j.tet.2014.06.046
Soni, Rina, Cheung, Fung Kei, Clarkson, Guy J., Martins, Jose E. D., Graham, Mark A. and Wills, Martin (2011) The importance of the N–H bond in Ru/TsDPEN complexes for asymmetric transfer hydrogenation of ketones and imines. Organic & Biomolecular Chemistry, 9 (9). pp. 3290-3294. doi:10.1039/c1ob05208j
Cheung, Fung Kei, Clarke, Adam J., Clarkson, Guy J., Fox, David J., Graham, Mark A., Lin, Changxue, Crivillé, Adriana Lorente and Wills, Martin (2010) Kinetic and structural studies on 'tethered' Ru(II) arene ketone reduction catalysts. Dalton Transactions, Vol.39 (No.5). pp. 1395-1402. doi:10.1039/b915932k
Birmingham Science City
Brazil. Coordenação do Aperfeiçoamento de Pessoal de Nível Superior (CAPES)
Martins, José Eduardo Damas and Wills, Martin (2009) Ir(III) complexes of diamine ligands for asymmetric ketone hydrogenation. Tetrahedron, Vol.65 (No.29-). pp. 5782-5786. doi:10.1016/j.tet.2009.05.012
Martins, Jose E. D., Morris, David J. and Wills, Martin (2009) Asymmetric hydrogenation of ketones using Ir(III) complexes of N-alkyl-N '-tosyl-1,2-ethanediamine ligands. Tetrahedron Letters, Vol.50 (No.6). pp. 688-692. doi:10.1016/j.tetlet.2008.11.101
Martins, Jose E. D. and Wills, Martin (2008) Synthesis of a series of novel N,N-dialkyl-TsDPEN ligands and their application to enantioselective addition of dialkylzinc to benzaldehyde. Tetrahedron: Asymmetry, Vol.19 (No.10). pp. 1250-1255. doi:10.1016/j.tetasy.2008.04.020
Bruker Analytische Meßtechnik GmbH
Coordenacao de Aperfeicoamento de Pessoal de Ensinol Superior (CAPES, Brazil)
Matharu, Daljit S., Martins, Jose E. D. and Wills, Martin (2008) Asymmetric transfer hydrogenation of C=O and C=N bonds by tethered Rh-III catalysts. Chemistry - An Asian Journal, Vol.3 (No.8-9). pp. 1374-1383. doi:10.1002/asia.200800189
Daphne Jackson Trust
Martins, Jose E. D., Morris, David J., Tripathi, Bhavana and Wills, Martin (2008) Further 'tethered' Ru(II) catalysts for asymmetric transfer hydrogenation (ATH) of ketones; the use of a benzylic linker and a cyclohexyldiamine ligand. Journal of Organometallic Chemistry, Vol.693 (No.23). pp. 3527-3532. doi:10.1016/j.jorganchem.2008.08.026
Parekh, Vimal, Ramsden, James A. and Wills, Martin (2012) Ether-tethered Ru(ii)/TsDPEN complexes : synthesis and applications to asymmetric transfer hydrogenation. Catalysis Science & Technology, Vol.2 (No.2). pp. 406-414. doi:10.1039/c1cy00364j
Parekh, Vimal, Ramsden, James A. and Wills, Martin (2010) Asymmetric transfer hydrogenation of quinolines using tethered Ru(II) catalysts. Tetrahedron: Asymmetry, Vol.21 (No.11-12). pp. 1549-1556. doi:10.1016/j.tetasy.2010.03.053
Engineering and Physical Sciences Research Council (EPSRC)
Hodgkinson, Roy, Del Grosso, Alessandro, Clarkson, Guy J. and Wills, Martin (2016) Iron cyclopentadienone complexes derived from C2-symmetric bis-propargylic alcohols; preparation and applications to catalysis. Dalton Transactions, 45 . pp. 3992-4005. doi:10.1039/c5dt04610f
Liu, Ruixia, Zhou, Gang, Hall, Thomas Howard, Clarkson, Guy J., Wills, Martin and Chen, Weiping (2015) Practical access to planar chiral 1,2-(α-Ketotetramethylene)- ferrocene by non-enzymatic kinetic resolution and conclusive confirmation of its absolute configuration. Advanced Synthesis & Catalysis, 357 (16-17). pp. 3453-3457. doi:10.1002/adsc.201500728
Soni, Rina, Hall, Thomas Howard, Morris, David J., Clarkson, Guy J., Owen, Matthew R. and Wills, Martin (2015) N-Functionalised TsDPEN catalysts for asymmetric transfer hydrogenation; synthesis and applications. Tetrahedron Letters, 56 (46). pp. 6397-6401. doi:10.1016/j.tetlet.2015.09.135
Soni, Rina, Hall, Thomas Howard, Mitchell, Benjamin P., Owen, Matthew R. and Wills, Martin (2015) Asymmetric reduction of electron-rich ketones with tethered ru(II)/TsDPEN catalysts using formic acid/triethylamine or aqueous sodium formate. The Journal of Organic Chemistry, 80 (13). pp. 6784-6793. doi:10.1021/acs.joc.5b00990
Coverdale, James P. C., Sanchez-Cano, Carlos, Clarkson, Guy J., Soni, Rina, Wills, Martin and Sadler, P. J. (2015) Easy to synthesize, robust organo-osmium asymmetric transfer hydrogenation catalysts. Chemistry - A European Journal, 21 (22). pp. 8043-8046. doi:10.1002/chem.201500534
Rawlings, Andrew J., Diorazio, Louis J. and Wills, Martin (2015) C–N bond formation between alcohols and amines using an iron cyclopentadienone catalyst. Organic Letters, 17 (5). pp. 1086-1089. doi:10.1021/ol503587n
Marlow, Victoria A., Rea, Dean, Najmudin, Shabir, Wills, Martin and Fülöp, Vilmos (2013) Structure and mechanism of acetolactate decarboxylase. ACS Chemical Biology, 8 (10). pp. 2339-2344. doi:10.1021/cb400429h
Johnson, Tarn C., Totty, William and Wills, Martin (2012) Application of ruthenium complexes of triazole-containing tridentate ligands to asymmetric transfer hydrogenation of ketones. Organic Letters, 14 (20). pp. 5230-5233. doi:10.1021/ol302354z
Jolley, Katherine E., Zanotti-Gerosa, Antonio, Hancock, Fred, Dyke, Alan, Grainger, Damian M., Medlock, Jonathan A., Nedden, Hans Günter, Le Paih, Jacques J. M., Roseblade, Stephen J., Seger, Andreas, Sivakumar, Vilvanathan, Prokes, Ivan, Morris, David J. and Wills, Martin (2012) Application of tethered ruthenium catalysts to asymmetric hydrogenation of ketones, and the selective Hydrogenation of aldehydes. Advanced Synthesis & Catalysis, 354 (13). pp. 2545-2555. doi:10.1002/adsc.201200362
Hopewell, Jonathan P., Martins, José E. D., Johnson, Tarn C., Godfrey, Jamie and Wills, Martin (2012) Developing asymmetric iron and ruthenium-based cyclone complexes : complex factors influence the asymmetric induction in the transfer hydrogenation of ketones. Organic & Biomolecular Chemistry, Vol.10 (No.1). pp. 134-145. doi:10.1039/c1ob06010d
Manville, Charles, Docherty, Gordon, Padda, Ranbir and Wills, Martin (2011) Application of proline-functionalised 1,2-diphenylethane-1,2-diamine (DPEN) in asymmetric transfer hydrogenation of ketones. European Journal of Organic Chemistry, 2011 (34). pp. 6893-6901. doi:10.1002/ejoc.201101164
Martins, Jose E. D., Redondo, Miguel A. Contreras and Wills, Martin (2010) Applications of N '-alkylated derivatives of TsDPEN in the asymmetric transfer hydrogenation of C=O and C=N bonds. Tetrahedron: Asymmetry, Vol.21 (No.18). pp. 2258-2264. doi:10.1016/j.tetasy.2010.07.013
Racys, Daurgidas Tomas, Rea, Dean, Fülöp, Vilmos and Wills, Martin (2010) Inhibition of prolyl oligopeptidase with a synthetic unnatural dipeptide. Bioorganic & Medicinal Chemistry, Vol.18 (No.13). pp. 4775-4782. doi:10.1016/j.bmc.2010.05.012
Morris, David J., Partridge, A. Simon, Manville, Charles, Racys, Daurgidas Tomas, Woodward, G., Docherty, Gordon and Wills, Martin (2010) Asymmetric organocatalysis of the addition of acetone to 2-nitrostyrene using N-diphenylphosphinyl-1,2-diphenylethane-1,2-diamine (PODPEN). Tetrahedron Letters, Vol.51 (No.1). pp. 209-212. doi:10.1016/j.tetlet.2009.10.131
Jiang, Xiaoli, London, Emma K., Morris, David J., Clarkson, Guy J. and Wills, Martin (2010) Gold-catalysed cyclic ether formation from diols. Tetrahedron, Vol.66 (No.52). pp. 9828-9834. doi:10.1016/j.tet.2010.10.068
Majewski, Artur, Morris, David J., Kendall, Kevin and Wills, Martin (2010) A continuous-flow method for the generation of hydrogen from formic acid. Chemsuschem, Vol.3 (No.4). pp. 431-434. doi:10.1002/cssc.201000017
Martins, Jose E. D., Clarkson, Guy J. and Wills, Martin (2009) Ru(II) complexes of N-Alkylated TsDPEN ligands in asymmetric transfer hydrogenation of ketones and imines. Organic Letters, Vol.11 (No.4). pp. 847-850. doi:10.1021/ol802801p
Wills, Martin, Palmer, Matthew, Smith, Athene, Kenny, Jennifer and Walsgrove, Tim (2000) Recent developments in the area of asymmetric transfer hydrogenation. Molecules, Volume 5 (Number 1). pp. 4-18. doi:10.3390/50100004
European Regional Development Fund (ERDF)
European Research Council (ERC)
Zammit, Charlotte M. and Wills, Martin (2013) Use of triazole-ring formation to attach a Ru/TsDPEN complex for asymmetric transfer hydrogenation to a soluble polymer. Tetrahedron : Asymmetry, 24 (13-14). pp. 844-852. doi:10.1016/j.tetasy.2013.05.022
Fundación "Pedro Barrié de la Maza, Conde de Fenosa"
Guo jia zi ran ke xue ji jin wei yuan hui (China) [National Natural Science Foundation of China] (NSFC)
Johnson Matthey Plc.
Hodgkinson, Roy, Jurčík, Václav, Zanotti-Gerosa, Antonio, Nedden, Hans Günter, Blackaby, Andrew, Clarkson, Guy J. and Wills, Martin (2014) Synthesis and catalytic applications of an extended range of tethered ruthenium(II)/η6-Arene/diamine complexes. Organometallics, Volume 33 (Number 19). pp. 5517-5524. doi:10.1021/om500788t
Leverhulme Trust (LT)
Darwish, Moftah and Wills, Martin (2012) Asymmetric catalysis using iron complexes : 'ruthenium lite'? Catalysis Science & Technology, Vol.2 (No.2). pp. 243-255. doi:10.1039/c1cy00390a
Libya.
Oxford Asymmetry International plc
Rhodia Consumer Specialities Ltd.
Rhodia Consumer Specialties Ltd.
Science City Research Alliance
SmithKline Beecham
Spain. Ministerio de Ciencia e Innovación (MICINN)
Technology Strategy Board (Great Britain)
Fang, Zhijia (Researcher in chemistry), Clarkson, Guy J. and Wills, Martin (2013) Asymmetric reduction of 2,2-dimethyl-6-(2-oxoalkyl/oxoaryl)-1,3-dioxin-4-ones and application to the synthesis of (+)-yashabushitriol. Tetrahedron Letters, Volume 54 (Number 50). pp. 6834-6837. doi:10.1016/j.tetlet.2013.10.010
University of Warwick Postgraduate Research Scholarship
University of Warwick Undergraduate Research Support Scheme
Warwick Collaborative Postgraduate Research Scholarship (WCPRS)


Having grown up witnessing constant episodes of domestic abuse it is with pleasure and without reservation that I work on a voluntary basis as a Mindfulness Meditation Teacher for the Iris Trust, delivering six week Mindfulness Meditation courses.
The Iris Trust is a relatively new charity and provides meditation and relaxation courses for women who have suffered domestic violence.
The Iris Trust's knowledge and understanding of the dynamics of abusive relationships and the effects this has on one's emotional and mental state are reflected in the course content, as are the difficulties encountered whilst living in a refuge and starting a new life. High levels of stress related to domestic violence create vulnerability and a lack of self-esteem which can manifest as physical illness.
Ruminating over past experiences, constant fear and worrying about the future can easily lead onto depression and anxiety.
The programme not only promotes awareness of unhealthy thought patterns whilst providing the tools to overcome them, but empowers the self, boosts self confidence and self esteem and enabling far greater relationships with oneself and others.
It is estimated that ten women commit suicide every week as a result of domestic violence.
This is why it is my privilage to be able to volunteer with the Iris Trust. Find more information about the Iris Trust's work here here.


Globe Telecom actively pushes Cebuano lifestyle into the digital scene as it introduces the Globe myLifestyle Plan. Likewise, the Telco is also giving a hand to Cebu-based small to medium businesses with its myBusiness plan. Both services offer flexibility in creating and customizing the way customers wanted to use their plans.
In a recent round table discussion with Cebu media, Globe dished out several important points about their new plans.
With the new myLifestyle Plan, Cebuanos will get access to an easier and simplified plan offer starting at P499 a month which comes with built-in unlimited calls and texts to Globe & TM plus freebies such as the Navigation Bundle which gives customers all day, all month access to apps such as Waze, Grab Taxi, Google Maps, MMDA, and Accuweather, 1 GB Globe Cloud for easy and hassle-free storage of files and photos, and Gadget Care to allow customers to protect their devices against theft and accidental damage.
On top of the base P499/month plan, Globe postpaid customers can avail of add-on services like Surf Packs for their mobile internet needs which are bundled with exclusive access to Spotify and/ or NBA League Pass. Customers can choose from GoSURF99 for 100MB of mobile internet monthly to as much as 15GB monthly with GoSURF2499.
For a richer data experience, myLifestyle plan customers can also choose from any of the Lifestyle Packs, which includes Music (Spotify), Productivity (Work Bundle for access to Evernote, Gmail, Yahoo Mail, and Globe Cloud), Life (Navigation Bundle, Explore Bundle for access to Agoda, Cebu Pacific, PAL, and Trip Advisor; and Shopping Bundle for access to Amazon, AyosDito, eBay, OLX, and Zalora), and Social (Chat Bundle for access to Viber, Facebook Messenger, KakaoTalk, Line, WeChat, and WhatsApp; Photo Bundle for access to Instagram, InstaSize, Photo Grid, and Photo Repost; ChatApp for access to Viber or Facebook Messenger; and standalone access to Facebook or Twitter).
Moreover, they can also get extra calls and texts to other networks, as well as landline and international services with the Classic Packs. All promo packs chosen will then be added to the P499 base plan, which will be equivalent to the customer's monthly service fee (MSF). Customers then get to choose from a wide range of free devices and gadgets, depending on their MSF. The more services they add on top of the base plan, the better the handset they can get.
The new plans also come with a free 30-day webpage trial that can be customized for one's business.With internet penetration growing at a rapid pace, this feature lets the business stay competitive and easier to search. Taking into account this trend, Globe myBusiness will help create and maintain the webpage, giving entrepreneurs a hassle-free experience in running their operations using the online media.
Entrepreneurs can choose a plan for as low as Plan 299 a month to Plan 3799, depending on their needs and scale of communication requirements. Each plan comes with consumables at least 50% more than for the monthly service fee. The consumables can be used to customize their plan with calls, SMS, mobile internet and gadgets. Finally, they can boost their plans with solutions that help increase productivity and sales of their business.
You can visit any Globe Store anytime for more information about these plans. Alternately, you can also visit the respective websites for Globe myLifestyle Plan and myBusiness Plan.