Essential MySQL Skills

ABSTRACTThis essay is an introduction to a Special Forum by critical scholar-activists responding to the late Samir Amin’s call for the establishment of a new political vehicle that would be capable of uniting diverse progressive and revolutionary movements consisting of the workers and peoples of the whole world. The purpose of this vehicle would be to confront and radically transform a global capitalist order in deep crisis. The authors of these essays tend to agree that Amin was a profound contributor to the global justice movement, and to the reformulation of Marxism to address the evolution of global capitalism and imperialism that took place in the late twentieth and early twenty-first centuries. However, some are critical of Amin’s stance. The essayists differ about whether they see Samir Amin’s proposal for the establishment of a global party as a good or bad idea. Among those who think it is a good idea there are differences regarding the organizational nature and issue focus of the proposed organization. There are also different attitudes toward the institution of the nation-state and regarding the sources of progressive revolutionary political forces in the contemporary world. We briefly review the main issues under contention.

A learning portfolio was developed to support the development of trainee doctors piloting Foundation Programme prototypes across the Northern Deanery in 2004 and 2005. Trainee doctors and their educational supervisors were surveyed about their experiences of using the portfolio in the clinical workplace. The evaluation consisted of semi-structured interviews with trainee doctors and supervisors, followed by postal questionnaire surveys in 2004 and 2005. Quantitative and qualitative data were triangulated to identify core findings. Questionnaires were returned from 182/305 (60%) trainee doctors and 104 out of 179 (58%) educational supervisors. The portfolio was felt to be a 'good idea' by 55% supervisors and 48% trainees. Trainees' perceptions of the educational value of the portfolio remained consistently low over 2 surveys and they described a sense of 'burden', whereby they identified problems in workload and usability and in gaining feedback on performance. However, positive trainee attitudes towards the portfolio were significantly correlated with greater perceived educational benefits (r = 0.855, P < 0.001). Learning portfolios are now an integral part of Foundation Programme training but this evaluation suggests that many trainee doctors and educational supervisors are yet to be convinced of their educational value. Gaining multi-source feedback, a substantial component of trainee doctors' portfolios, impacts on the wider clinical team and presents a significant challenge to trainees. Educational supervisors continued to rely on feedback from clinical colleagues, rather than portfolio evidence, to monitor trainee doctors' development. Such factors may serve to disengage trainees with the portfolio process by overshadowing any perceived educational gains.

For about 30 years, the European Union (EU) has developed an increasingly comprehensive environmental policy. Although the EU has a primary commitment to building a common market, and may therefore be expected to focus on the removal of trade-inhibiting environmental regulations, EU environmental policy has proved to be quite resistant against such a 'race to the bottom' and actually improved the level of regulatory protection in many instances (Scharpf, 1998; Eichener, 1996). Despite these efforts, and despite the relatively high technological, financial, and administrative capacities in Europe, the actual impact of the EU environmental policy remains disappointing. Notwithstanding some success stories, such as measures for the protection of the ozone layer, the ecosystems in Europe and biodiversity remain threatened. In a recent publication, the European Environment Agency finds the European state of the environment 'far from satisfactory' (European Environment Agency, 1999).

Western Australia (WA) became the fourth Australian jurisdiction to adopt a prohibition with civil penalties scheme for minor cannabis offences when its Cannabis Infringement Notice (CIN) scheme became law on 22 March 2004. Previous criminological research has demonstrated the importance of public attitudes towards the law in determining the effectiveness of legislation. This survey represents the first phase of a pre-post study that attempted to gauge public attitudes towards the legal status of cannabis, the proposed legislative reforms surrounding the drug and their likely effects. A random telephone survey of 809 members of the WA population was conducted prior to the implementation of the new laws with a view to exploring contemporary views of the existing legal status of cannabis, attitudes to the proposed legislative model and respondent perceptions of its likely effects. Despite cannabis being viewed negatively by large numbers of the sample, criminal penalties for minor cannabis offences were viewed as inappropriate and ineffective. Once explained, the proposed civil penalty scheme was viewed as 'a good idea' by 79% of the sample, despite significant differences due to personal experience of cannabis use, political affiliation, religiosity and age of offspring. Most believed that the legislative change would not result in changes to levels of cannabis use (70%) or ease of obtaining cannabis (59%). These data suggest that prior to its implementation the new legislation was highly acceptable to the majority of the community. These baseline data will be compared with data to be collected at the post-change phase of the study to allow empirical observations of attitudinal and behavioural changes occurring in the community.

This article addresses the question of how gender inequalities are produced in the film industry. In the absence of industry or organizational interventions, these inequalities seem unmanageable. We present an exploration of the gendered working lives of below-the-line film workers in New Zealand, in the context of the western film industry. Repeatedly, women activists have pointed out that a perception of gender equity contradicts the statistics, which demonstrate traditional as well as ‘new’ forms of sexism. In this post-feminist context inequality is typically invisible and unspoken, and there is a thriving narrative of meritocracy based on talent and determination, where ‘you're only as good as your last job’. Below-the-line ‘crew’ are distinguished from creatives in a hierarchy of creativity. In the New Zealand film industry, they are not unionized, and there are no policies addressing gender. From their perspective, their powerlessness in terms of employment rights is taken as a given, a price they pay for doing their dream job. In spite of beliefs about merit, talent and the ‘good idea’, women's ‘good ideas’ and their work capabilities across a range of roles are less likely to be recognized and rewarded than those of men.

Gaithersburg, Md. – The benefits of a transcatheter heart valve outweigh its risks for older patients with severe, symptomatic aortic stenosis who are at a high risk for surgery, voted the majority of an advisory panel to the Food and Drug Administration recently. All panel members also voted that the valve was effective, and 10 of 12 members said that it was safe. The valve entered the U.S. market last November after receiving FDA approval for patients who have severe aortic stenosis and are deemed too sick to undergo surgical heart valve replacement (N. Engl. J. Med. 2010;363:1597-607). On June 12, Edwards Lifescience, the maker of the SAPIEN transcatheter heart valve, said that based on the results of the PARTNER pivotal trial, the valve is also safe and effective in the high-risk cohort. Although FDA officials agreed that the trial met its primary endpoints, they expressed concern with the higher risk of stroke in patients who underwent transcatheter aortic valve replacement (TAVR), compared with those who underwent surgery. They also raised questions about the long-term durability of the device, for which there are no data yet available yet. In his final remarks, Dr. Craig R. Smith, chair of the department of surgery at Columbia University and coprincipal investigator of the PARTNER trial, said that although the risks associated with the procedures must be taken seriously, they should not be an obstacle to the indication’s approval. The main results of the trial showed that all-cause mortality at 30 days favored TAVR at 3.4%, compared with 6.5% for open surgery, and was similar at 1 year (24% and 27%, respectively). The difference at 1 year reached the trial’s prespecified noninferiority margin, yet again, neurologic complications occurred more frequently after TAVR. Surgical valve replacement has evolved over the past 50 years, and although TAVR is radical, it’s the next logical step in that evolution, Dr. Smith told the panel. The results of cohort A of PARTNER, he said, bring the field one step closer to the day that valves can be replaced with no large incisions, no heart-lung machine, and potentially no general anesthesia. The Centers for Medicare & Medicaid Services decided in May that it will cover the procedure in inoperable patients, under certain conditions, including evaluation of the patient by two cardiac surgeons. Dr. Gregory J. Dehmer, professor of medicine at Texas A&M University, said that the field was only at its infancy. Dr. Dehmer disclosed no conflict of interest. Dr. Smith noted that he is an investigator in the PARTNER trial. CfA

Although the events and the issues at stake are likely to seem trivial and even ludicrous to readers of our time, it is important to remember their influence upon Yeats’s thought and possibly the direction of his life thereafter. He did not leave the Golden Dawn for many years — and in fact maintained an interest till the end of his life, but he was disillusioned. Despite his partial defeat, however, he emerged the statesman of the Second Order, and the privately printed essay on magic expressing his religious convictions and addressed to members of the Order is clearly superior to the essay entitled ‘Magic’, which was written in the same year and published first in The Monthly Review and later in Ideas of Good and Evil.’ Indeed, Yeats’s dissatisfaction with Ideas of Good and Evil, expressed in two letters of May 1903, may be attributable in part to the experiences of these months. ‘The close of the last century’, he wrote to George Russell, ‘was full of a strange desire to get out of form, to get to some kind of disembodied beauty, and now it seems to me the contrary impulse has come.’

Learning about ‘good ideas’ for teaching

Welcome to the third ACM Symposium on Software Visualization, held this year in Brighton, UK. In addition to our program of peer-reviewed technical papers, this year's event has a number of innovations, and we are looking forward to an interesting and action-packed event.Our technical program consists of 14 papers, 25 interactive posters, and 2 "Challenge" presentations. Each paper was rigorously reviewed by three or more reviewers, resulting in acceptance of 36% of the submissions.Our first innovation was with which conference to co-locate. SoftVis is a small and close-knit conference. This year, instead of co-locating as a satellite to a big conference, as in the first two years, we decided to try a different model: co-locating with other small, close-knit conferences with themes related to ours, namely the IEEE Symposium on Visual Languages and Human-Centric Computing, and the PPIG Workshop (Psychology of Programming Interest Group). We gathered as much data as we could about whether attendees at the other conferences might be attracted to SoftVis and vice versa, and after much deliberation, the SoftVis Steering Committee decided to go ahead with it. The VL/HCC Steering Committee and the PPIG Steering Committee were also in favor, and a vision was developed about how these three events could cooperate and contribute to each other.A slightly overlapping schedule among the three conferences with some joint keynotes, a joint reception and joint tea breaks, a poster display intermingled with the joint reception, and a joint special event emerged. A unified registration process was developed. Discounts for joint registrations were figured out by all the General Chairs. John Howse, the General Chair of VL/HCC, graciously volunteered to manage the joint registration and logistics for all three events. We are very grateful to him and to all three Steering Committees for their efforts, good ideas, and willingness to be flexible.Our second innovation was to include a SoftVis Challenge event. SoftVis has not included such an event before. Carsten Görg agreed to manage the event, and Margaret-Anne Storey s words of experience helped to give it direction. The SoftVis Challenge brings together researchers and practitioners interested in applying, comparing, and challenging their software visualization tools and approaches on software repositories for two common open source projects Mozilla (C,C++) and Eclipse (Java). We are looking forward to hearing what the selected Challenge software visualizations can reveal for these real-world projects.Our third innovation came when the notion was put forward that a joint panel might be a good idea. This is a common device in conferences, but frankly, none of us three actually likes panels. So, we decided to instead try a special event that we thought could provide more direct benefits to attendees: a "How to Succeed at SoftVis/VLHCC Research" event. As a joint session with VL/HCC, this event will include senior researchers from both the SoftVis and VL/HCC communities giving their own tips on how to succeed at SoftVis and VL/HCC research: how to do it, how to write it, and how to transfer it effectively to industry. It will also include the audience itself, from whom additional tips that have worked for them will be shared with the others.These innovations seem to be paying off. As of the time of this writing (two months before the event, and before the early registration deadline), the early SoftVis registrations have already surpassed last year's final total. Further, registrants are showing strong enthusiasm for this collection of conferences together: a full 50% of the SoftVis attendees also registered at VL/HCC, PPIG, or both.Welcome to SoftVis, and to VL/HCC and PPIG as well. We hope you enjoy them and your stay in Brighton, and we look forward to your feedback on this year's innovations.

In the times of information flooding via internet, social media, streaming services and telemedicine, the question arises: Do we still need a scientific journal for dermatovenereology? The answer is ‘yes’ and for several reasons: Continuing professional development requires contact with new developments in research and clinical practice. If this is only given by secondary sources, e.g. review articles, there will be a loss of quality and ability in understanding genuine research; therefore, original articles reporting new findings in our specialty are crucial also for the quality of our patient care. Furthermore, in the competition with other medical and neighbouring disciplines, it is important to highlight the opportunities and progress in our field. This is daily life in medical faculties all over the world and Dermatology – in many places and countries – can show proudly its achievements. As largest scientific society in our field in Europe, it is a duty to our members to offer them an excellent, attractive and informative journal. This also means that we should have a high impact factor, which has been established as a measure of quality of a scientific journal worldwide, whether justified or not. With 3.08 IF at the moment, JEADV ranks No 10 among 70 dermatological journals globally, and belongs to the top five clinical dermatology journals. How can we further improve and keep our major target group in mind – the practising dermatovenerologist in university, hospital or office? We have to find a balance between mechanistic basic research and patient care with practical clinical information. We might in the future also accept basic research articles when they are clearly translational in nature, meaning that they show ways to possible new diagnostic or therapeutic strategies. It will be more and more difficult to accept Case Reports; therefore, EADV should think of an extra journal like, e.g. ‘JEADV-Clinical Cases’. At the moment, many of them are accepted as ‘letters’ and will be published from now on in electronic-only form. We will provide more selected review articles also to new technologies. JEADV is the classical journal for clinical trials in dermatovenereology. Authors have to agree to the CONSORT rules guaranteeing quality of these trials. We will not only report about therapeutic but also about diagnostic news and results of epidemiological studies. A special focus has been put on teledermatological issues. Quality of life issues and psychosocial aspects of skin disease including the development of appropriate instruments are equally important. Health outcome research also considering health political issues is welcome. The place for European guidelines of care to be published is the JEADV. We have to resist to the temptation to publish a guideline on a skin disease in another discipline's journal only because of a higher impact factor, this will make our specialty invisible at the end! What are practical consequences to move forward so many good ideas? We will probably have to follow an even more rigorous review and acceptance policy for the ca 2500 new submissions reaching JEADV every year. We will restructure the editorial team and board by implementing section editors, in addition to associate editors. We will try to promote open access policy more intensively than now. Manuscripts will appear on-line as soon as they are accepted – with a note that they may undergo slight editorial corrections and changes before final printing. Plagiarism is an increasing problem; so, we seriously think about routine checking for this in all accepted manuscripts. Although we are a European journal, more than half of our submissions and our readership come from overseas. We can learn from the exchange of experience with colleagues in America, Africa and Asia-Pacific. We need you, the readers, your help in advertising EADV in general, sending us good ideas, manuscripts and include quotations of JEADV work in your articles! It is hard work and a great responsibility but also great fun to contribute in making this journal!

Historians have been complicating their understandings of networks, and especially mercantile networks.Moving on from a rather positivistic approach based on family, religion and ethnicity, research has now started to stress the inherent problems inherent in networks. 2Furthermore, researchers have started to stress the problems in constructing and maintaining networks of whatever type. 3However, far less work has been conducted on the problems encountered in developing and under-developed networks, where key actors may be unduly influential because they have access to new and/or highly-prized information.Such key actors (often but not always, Mark Granovetter's 'weak ties') can help to bridge what Ronald Burt has called structural holes in networks; that is, 'the separation between non-redundant contacts'. 4Actors that stand near structural holes are 'at a higher risk of having good ideas' through the ability to better synthesise the various, different, and new information to which they have access. 5Moreover, that information is likely to be seen as high value and credited because that information is considered rare.Therefore, actors bridging structural holes are often perceived as positive players within a network. 6However, the very fact that these bridging actors have information arbitrage to their advantage means that they are also in a great position to act against the interests of the principal(s), especially where there is a lack of good governance. 7These opportunities could be seen as 'bad ideas', the opposite of Burt's good ones.This situation could lead to bad decision making simply due to a lack of competency, through positive adverse selection, or even fraud. 8ther of these behaviours could be seen as a type of network failure, which Andrew Schrank and Josh Whitford define as 'the failure of a more or less idealized set of relational-network institutions to sustain 'desirable' activities or impede 'undesirable activities'. 9They posit two types of network failure: absolute and relative -the latter of which is more relevant to the discussion here. 10They argue that relative failure occurs when networks fail due to a lack of competencies (involuted), or due to opportunism (contested).The first is due to ignorance and a failure to absorb enough information, and the latter occurs where there is sufficient competence, but safeguards against mistrust and opportunism are absent.The colloquial, if clear way they sum

Pharmacy-based alcohol screening and brief intervention (SBI) services in England vary in follow-up requirements and achieving follow-up can be challenging. Little is known about service-user views and this study aimed to explore these as well as the feasibility of follow-up. The study was funded by Liverpool Primary Care Trust using an unrestricted educational grant from Lundbeck Limited. Five pharmacies providing alcohol SBI services were purposively selected across three areas. Forty individuals receiving SBI interventions were invited by pharmacy staff to participate and contact details recorded with consent. A researcher conducted semi-structured telephone interviews at 1-2 weeks and 3 months after service use. Interview 1 covered views on the service and interview 2 covered behaviour changes, including subsequent discussions with third parties. Institutional ethics approval was obtained. Sixteen service users took part in the first follow-up (40%); all viewed it positively and ‘a good idea’, although one felt services should be targeted to under-50s. Not all regarded it as personally relevant and one admitted dishonesty in his responses. However, all felt at ease having a discussion in the consultation room about drinking. Fourteen of the 16 (86%) agreed to three-month follow-up. Of these, six reported talking to others about their own drinking habits and three had discussed the service with family and friends, of whom two had recommended they should make use of it. Two had made significant changes to lifestyle that they attributed to the pharmacy intervention. Pharmacy alcohol services were well received by service users interviewed, a significant proportion of whom had subsequently discussed the pharmacy interaction and/or alcohol use with other people, potentially leading to a cascade effect. Two of 16 interviewees reported significant lifestyle changes at 3 months, which tallies with findings from services based elsewhere. Good follow-up rates were achieved at 2 weeks and three months.

This article: Considers competitive business strategy from a managerial rather than purely theoretical perspective; Focuses on the practical task of generating ‘good ideas’ for business development; Concentrates on products and markets as the building blocks of strategy; and Proposes a framework which managers can employ to stimulate idea generation and the identification of the key resource implications. Copyright © 2000 John Wiley & Sons, Ltd.

Journal of Parenteral and Enteral NutritionVolume 30, Issue 6 p. 539-540 Editorial Perioperative Immunonutrition: Good Idea or More Hype? Charles W. Van Way III MD, Corresponding Author Charles W. Van Way III MD charles.vanway@tmc.med.org From the UMKC Department of Surgery, Kansas City, MissouriCorrespondence: Charles W. Van Way III, MD, UMKC Department of Surgery, 2301 Holmes Street, Kansas City, MO 64108. Electronic mail may be sent to charles.vanway@tmc.med.org.Search for more papers by this author Charles W. Van Way III MD, Corresponding Author Charles W. Van Way III MD charles.vanway@tmc.med.org From the UMKC Department of Surgery, Kansas City, MissouriCorrespondence: Charles W. Van Way III, MD, UMKC Department of Surgery, 2301 Holmes Street, Kansas City, MO 64108. Electronic mail may be sent to charles.vanway@tmc.med.org.Search for more papers by this author First published: 01 November 2006 https://doi.org/10.1177/0148607106030006539Citations: 2Read the full textAboutPDF ToolsRequest permissionExport citationAdd to favoritesTrack citation ShareShare Give accessShare full text accessShare full-text accessPlease review our Terms and Conditions of Use and check box below to share full-text version of article.I have read and accept the Wiley Online Library Terms and Conditions of UseShareable LinkUse the link below to share a full-text version of this article with your friends and colleagues. Learn more.Copy URL Share a linkShare onFacebookTwitterLinked InRedditWechat No abstract is available for this article.Citing Literature Volume30, Issue6November-December 2006Pages 539-540 RelatedInformation

The history of congenital interventional cardiology has seen numerous groundbreaking innovations typically related to the introduction of a new device or a novel treatment technique. Similarly, imaging of cardiac defects has changed dramatically over the past decades, although some of the advancements have seemed to omit the catheterisation laboratories. Rotational angiography, one of the imaging techniques for guidance of cardiac catheterisation currently referred to as "advanced", in fact was described already in 1960s.1 More recently its improved version, including three-dimensional reconstruction (3DRA), became a valuable intra-procedural imaging tool in interventional cardiology and neuroradiology.2 Dr Evan Zahn was one of the pioneers of 3DRA in the field of congenital cardiology, setting an example for many to follow. With his innovative publication and subsequent lecture at 2011 Pediatric and Adult Interventional Cardiac Symposium (PICS-AICS) on "The Emerging Use of 3-Dimensional Rotational Angiography in Congenital Heart Disease" he motivated many to explore benefits of this modality to strive for improved procedural outcomes and reduced patients' burden of cardiac catheterisation3. I was one of those to take Dr Zahn's thoughts and implement them into routine workflow.4-6 However, almost a decade after Dr Zahn shared his important work, despite tremendous efforts by teams from Utrecht, (Netherlands) and Columbus (Ohio, United States of America) to popularise 3D imaging in catheterisation laboratory during dedicated meetings, two-dimensional (2D) angiography does not seem to be threatened in many, otherwise-progressive, laboratories. During the recent 30th Japanese Pediatric Interventional Cardiology (JPIC) meeting I had the opportunity to ask Dr Zahn why giving up knowledge is almost never a good idea, what is technology's natural order of things, and why the technology has to be more than just exciting, pretty, and new.