text:
Reduced fee for 2014/15
Graduate applications
Internationally qualified nurses and midwives – update
Strengthening international criminal history checks
Criminal history – your requirement to tell us
Certificate of registration status now available online
Notification information for employers
From the Victorian Coroner
Consultations update
NMBA review brand identity
NMBA focus groups on services for nurses and midwives with a health impairment
National Scheme news
2013/14 National Scheme annual report
Three-year review of the National Scheme
Regulatory principles for National Scheme
Keep in touch with the Board
The Nursing and Midwifery Board of Australia (NMBA/National Board) continues its mission to work in partnership with the nursing and midwifery professions and associations, the education sector and the wider community.
Recently we released our 2013/14 annual report and this gave me the opportunity to reflect on the NMBA's achievements, challenges and priorities during the last year. This year, for the first time, we have also published a profession-specific profile – Nursing and midwifery regulation at work in Australia, 2013/14.
One of our great achievements this year has been a continuing increase in online registration renewals. During the last renewal period (by 31 May 2014), 97% of nurses and midwives renewed online. The change over the last four years is remarkable; when we started the renewal process in 2010, the online renewal rate for nursing and midwifery was closer to 54%. Each annual renewal is a process we look to learn from and our work continues in finding opportunities for refinement.
With your support and contributions, we also conducted a number of midwifery related consultations this year. Thank you for your feedback on all of our consultations to date. On behalf of the NMBA, I encourage all nurses, midwives and students to stay abreast of the upcoming changes in the new year and to continue engaging in our future consultations on new and revised registration standards, codes or guidelines.
Finally, I take this moment to reinforce my commitment to strengthening the relationships between the NMBA and our stakeholders. We look forward to working with you on nursing and midwifery regulation, education and workforce matters. We will involve you in our improvement initiatives for 2014/15 that focus on fostering stakeholder relationships, improving and strengthening the National Registration and Accreditation Scheme (the National Scheme), and driving operational excellence.
On behalf of the National Board, I wish you and your families the best of this festive season. Hope you all have a safe and happy New Year.
Dr Lynette Cusack RN
Chair, Nursing and Midwifery Board of Australia
We have reduced our national registration fee for nurses and midwives for 2014/15.
The lower fee at $150 came into effect on 9 September 2014 and will apply to the next registration renewal for nurses and midwives due by 31 May 2015.
This fee reduction is consistent with our commitment to maintaining fees at a reasonable level. Registrants who hold both nursing and midwifery registration will only pay one registration fee.
To find out more, read the media release on the NMBA website.
The Australian Health Practitioner Regulation Agency (AHPRA) is calling for online applications from students who are in their final year of an approved program of study. Students who completed their study in 2014 are urged to apply for registration, if they haven't already done so.
AHPRA sends out emails, on behalf of the National Board, to final-year students on the Student Register as a reminder to apply early and online. Applications can also be made by completing a paper application form.
Nursing and midwifery students are encouraged to read the information on AHPRA's website under Graduate applications. Graduates must meet the National Board's registration standards and need to be a registered nurse or midwife before they start practising.
You may have noticed that we have recently updated our website with the new model for assessing applications for registration from internationally qualified nurses and midwives (IQNMs).
This includes information about:
how we assess applications under the new model – the equivalence of international qualifications to Australian qualifications.
making an appeal – making an appeal if an application for registration with the NMBA is not successful.
how we use the Australian Qualifications Framework (AQF) – our assessment of qualification levels. The new model does not distinguish between different countries but rather requires applicants to give proof that both their education institution and their program of study were accredited according to the standards set out on the website.
Our new set of frequently asked questions (FAQ) will assist with some of your common queries on accreditation, the AQF, bridging programs and migration.
The NMBA is working closely with the Australian Nursing and Midwifery Accreditation Council (ANMAC) to streamline approaches to migration and registration assessments.
In September this year, we announced that nurses and midwives who were approved by ANMAC before 10 February 2014 (when we implemented the new model) may be eligible for registration if they meet specified registration requirements. See the media release on our website.
From early 2015, National Boards and AHPRA will implement a new procedure for checking the criminal history of international applicants for registration. The new approach aims to balance protecting the public without unnecessarily delaying the registration process for applicants.
For more information, please read the media release on the AHPRA website.
We would like to remind all nurses and midwives that you have an obligation under the National Law1 to not only disclose criminal history when applying for registration or to renew registration, but also, within 7 days at any time, you are required to provide notice:
if you are charged with an offence punishable by 12 months' imprisonment or more, or
if you are convicted of, or the subject of, a finding of guilt for an offence punishable by imprisonment.
Section 79 of the National Law requires a National Board to check for criminal history before deciding an application for registration.
The National Law defines criminal history as:
every conviction of the person for an offence, in a participating jurisdiction or elsewhere, and whether before or after the commencement of this Law;
every plea of guilty or finding of guilt by a court of the person for an offence, in a participating jurisdiction or elsewhere, and whether before or after the commencement of this Law and whether or not a conviction is recorded for the offence;
every charge made against the person for an offence, in a participating jurisdiction or elsewhere, and whether before or after the commencement of this Law
While every case is decided on an individual basis, the National Board considers a number of factors when determining how the criminal history may affect your eligibility for registration.
The Criminal history registration standard is available under Registration standards on our website.
1Health Practitioner Regulation National Law, as in force in each state and territory.
New process makes it easy
Registered nurses and midwives can now request a certificate of registration status (CoRS) using the online AHPRA portal. In the past this was a manual process involving a form that was either posted or hand-delivered to an AHPRA office. Nurses and midwives can now:
apply online by logging onto online services, or find out more information on our Practitioner services page of the AHPRA website, or
apply using the PDF form (245 KB), which is available for download from our Common application forms page or the Practitioner services page of the AHPRA website.
There is a fee of $50 for each CoRS.
For more information on CoRS please visit the AHPRA website.
We recently published Guidelines for mandatory notifications. A notification is a complaint to AHPRA or the NMBA about a registered nurse or midwife.
The NMBA would like to emphasise to employers of nurses and midwives that there are some workplace or disciplinary matters that can be resolved in a work context, without being notifiable conduct.
The general definition of notifiable conduct for a registered health professional is as below.
Has practised while intoxicated by alcohol or drugs
Sexual misconduct in the practice of the profession
Has placed the public at risk of substantial harm because of an impairment (health issue).
Has placed the public at risk of harm because of a significant departure from accepted professional standards.
Making a mandatory notification is a serious step to protect the public from risk, and must meet a high threshold. If in doubt about whether to make a mandatory notification, you may wish to check with your insurer or professional association.
See also notification publications for the community and health professionals on the AHPRA website.
Performing duties under the influence of alcohol and/or drugs
The National Board received notification about a midwife who performed the duties of a visiting midwife under the influence of alcohol and/or prescription medication that impaired the midwife's ability to practise.
The midwife failed to properly address the patient's clinical concerns, made unprofessional remarks about work colleagues to the patient, and did not complete relevant entries in the midwifery service log book.
The National Board took immediate action to restrict the midwife's practice, and referred the midwife to a panel hearing. The panel gave the midwife a caution and resolved to seek a health assessment of the midwife if they chose to renew registration.
The midwife did not renew registration and became unregistered.
Impersonating a medical practitioner
The National Board received a notification of an enrolled nurse's behaviour that constituted professional misconduct. The enrolled nurse had impersonated a medical practitioner to procure medication and medical devices under false pretences.
The enrolled nurse also failed to undertake a scheduled health assessment.
The National Board determined that the enrolled nurse's conduct was substantially below the standard reasonably expected of a person of an equivalent level of training or experience, and referred the matter for a tribunal hearing.
The tribunal determined that the enrolled nurse had behaved in a way that constituted professional misconduct under the National Law and ordered that their registration is cancelled and disqualified the enrolled nurse from applying for registration as a registered health professional for four years.
The Victorian Coroner has written to AHPRA and the NMBA asking that we highlight the dangers associated with the blurring of professional boundaries and the potential loss of objectivity inherent in treating friends and colleagues. The Coroner stated that 'health professionals treated in settings where they are well known should be treated the same as any other patient. They should be advised to submit to standard treatment guidelines for that institution and assumptions should not be made about their state of knowledge'.
The NMBA has issued guidance in the following documents for nurses and midwives to manage professional boundaries between themselves and the person to whom care is being provided:
the Code of professional conduct for midwives and the Code of professional conduct for nurses (see Conduct Statement 8 in both documents), and
A midwife's guide to professional boundaries and A nurse's guide to professional boundaries.
The codes of conduct and the professional boundaries documents are available on the NMBA website under Codes, guidelines and statements.
The NMBA has had a busy year developing registration standards, codes and guidelines for nurses and midwives. The common registration standards for criminal history, continuing professional development, professional indemnity insurance, English language and recency of practice have now been finalised and are being submitted to health ministers for consideration.
We have two open public consultations which close on 19 December 2014:
Endorsement as a nurse practitioner registration standard and associated guidelines
Registration standard on endorsement for scheduled medicines for eligible midwives
We are also in the final stages of drafting the public consultation report for the enrolled nurse standards for practice, and this will be reviewed by the NMBA in the coming months. The registered nurse standards for practice are in development, with the observation phase nearly complete and the first drafts of these are expected in early 2015 for consultation.
We are currently undertaking a comprehensive review of the understanding and recognition of the NMBA brand and identity. As part of this review, we will be conducting an online survey in January 2015 to get a better understanding of the NMBA's role as seen by its major stakeholders including nurses, midwives and consumers in general.
PricewaterhouseCoopers, in collaboration with independent market research company Colmar Brunton, will be conducting this survey on our behalf.
Please register your interest in the survey; you will receive an email with a link to the survey in the new year.
For more information please contact Mark Baker at mark.baker@colmarbrunton.com or (07) 3026 3014.
The NMBA, together with AHPRA, is currently exploring the role of the regulator in the referral, treatment and rehabilitation of nurses and midwives with a health impairment.
In February 2015, ACIL Allen Consulting (on behalf of the NMBA and AHPRA) will hold focus groups in Sydney and Adelaide to get your feedback on this important issue.
Please register your interest to participate in these focus groups by sending an email, (indicating your preferred location), to focusgroup@acilallen.com.au. There may be an opportunity to participate via teleconference. Please also indicate if this is a preference.
AHPRA and the National Boards have released their 2013/14 annual report on the National Scheme, providing a comprehensive record of the operations of the National Scheme for the 12 months ending 30 June 2014.
The annual report provides a national snapshot of the work and finances of the National Scheme and is tabled in the parliaments of each state and territory and the Commonwealth. The 2014 annual report is an important reporting milestone and covers the lead-up to the scheduled independent three-year review of the National Scheme, now underway.
This year, for the first time, AHPRA and the National Boards have also published summaries of our work regulating health practitioners in every state and territory.
The National Board has also published, for the first time, a report titled Nursing and midwifery regulation at work in Australia 2013/14, which outlines its work in regulating nurses and midwives in the National Scheme. The report provides a profession-specific view of the NMBA's work to manage risk to the public and regulate nurses and midwives in the public interest. It is a profile of regulation at work in Australia for the 12 months ending 30 June 2014.
Snapshot of the profession
The data below are drawn from data published in the report Nursing and midwifery regulation at work in Australia 2013/14, as at 30 June 2014.
362,450 registered nurses and midwives in Australia
7% increase in the number of registered nurses and 1% increase in the number of enrolled nurses
32.7% increase in the number of registered midwives
42% increase in the number of nurse practitioners
We told you about the three-year review of the National Scheme in our July 2014 newsletter. The team undertaking the review released a consultation paper in September 2014, to seek feedback on a number of areas.
The terms of reference for the review are published at the Australian Health Ministers' Advisory Council website under 'media releases' on the right-hand tab. The review – led by independent reviewer, Mr Kim Snowball – was built into the intergovernmental agreement that set up the framework and governance arrangements for the National Scheme. The agreement stated that the Australian Health Workforce Ministerial Council (Ministerial Council) would initiate an independent review after three years of the National Scheme's operation.
It identified three main areas of the review:
accountability – looking at options for how the National Scheme can improve its accountability, both at a national level and to each state and territory health minister
future of regulation – looking at options for balancing questions of risk, the level of regulation and costs across the needs of a range of health professions, including any new professions entering the National Scheme, and
complaints and notifications – looking at options for improving the management of notifications and complaints. This includes the option of continuing to improve the current arrangements under the National Law.
The paper also identified a number of related issues for comment including workforce reform, advertising provisions, assessment of overseas trained practitioners and legislative amendments.
The consultation period, which included stakeholder forums, has now been finalised and the report to governments is being progressed.
The review team expects to make its recommendations early in 2015, which will then be subject to final decisions by all health ministers.
The National Boards and AHPRA are actively participating in the review process.
The National Boards and AHPRA have launched refreshed regulatory principles that will underpin the work of the National Boards and AHPRA in regulating Australia's health professionals in the public interest.
The principles are endorsed by all National Boards and the AHPRA Agency Management Committee and will guide Boards and AHPRA when they are making decisions. The principles encourage a responsive, risk-based approach to regulation across all professions within the National Scheme.
Regulatory decision-making is complex and contextual, requiring judgement, experience and common sense. The principles will further support consistent, balanced decision-making.
AHPRA and the National Boards will be seeking feedback on the principles in a formal consultation and will review them based on this feedback and 12 months' experience.
You can read the regulatory principles in a media release on the AHPRA website.
Visit the Board website for registration standards, codes, guidelines and FAQ.
Lodge an online enquiry form.
For registration enquiries, call 1300 419 495 (from within Australia) or +61 3 8708 9001 (for overseas callers).
Address mail correspondence to: Dr Lynette Cusack RN, Chair, Nursing and Midwifery Board of Australia, GPO Box 9958, Melbourne, VIC 3001.


Visited the #bachritterburg in 88422 Kanzach / Germany, a reconstruction of a medieaval #motte-and-bailey castle from the early 14th. century. It's a wooden fortification with an enclosed courtyard that has a lot of #livinghistory from various groups going on.
Visited Campus Galli and it was awesome. Here you can witness the construction of a medieaval monastic with tools and techniques from the 9th century based on an original plan drawn over 1000 years ago.
I notice a certain lack of #HEMA ⚔ in my mastodon stream.
Im #UK läuft ja aktuell nicht viel zusammen.
Aber es gibt auch Ausnahmen. London hat eine Citymaut eingeführt - und das halte ich für sinnvoll.
Automotive Security Research Group at Shackspace (Stuttgart) and really liked it (despite me looking asleep all the time to due critical caffeine levels).
TIL: Don't attack the crypto. Attack the implementation.
"Na, da hat denen wohl noch ne Frau in der Runde gefehlt."
Wenn doch jetzt nur die ÖR anderer Länder nachzögen.
This is how being below 40 feels in the #EU at the moment.


Been turned down by your bank? We can help.
Rethink specialises in finding home loan solutions for you when the Bank says "No". A non-bank solution may just be the answer you're looking for.
Are you finding it hard to secure a mortgage because you haven't got the relevant or 'right' documentation for the banks? Home loan applications can be tricky to navigate at the best of times – when you don't have the right documents about your financial history, or your documents are simply not available to you, it can be even tougher.
Self-employed New Zealanders may also have trouble providing documentation to banks, if they haven't been trading long enough or aren't able to provide the required financial information to the bank.
Low doc means not having to prove your income using Financials. This can include commission sales, overseas income or simply financials not being available. Low doc mortgages are not generally available from the banks anymore, so we have special arrangements in place to help out. They can also be useful for short-term development funding, which banks are generally not keen on.
Use this calculator as a guide to find out what your home loan repayments could be.
How can we help if you've been turned down by your bank?
Has the Bank said "NO"?
Have you been declined by your Bank as your income is seasonal or hard to prove as you do not have current financial data from your Accountant? Perhaps you have only been in business 6 months? The product that may help you is known as "Low Doc", "Lo Doc", or a "Non Conforming" Loan. This is an exciting product that has allowed many self-employed and small business owners the opportunity to buy homes, investments, or access equity in their property.
A lot of people only find out they have a credit history issue after applying for a mortgage and being rejected because of what the lender found on their credit report.
But having a poor credit history does not mean you have to wait to get into (or back into) the property market.
The good news is that there are lenders who will potentially allow you to borrow even if you have multiple credit issues.
The good news with banks is that they're starting to lend up to 90% again and there are other lenders – non-banks who will still go up to 90%. In either of these circumstances the lenders are very choosy about who they will lend to at this level. Often you will get one chance to get it right when applying for lending over 80%. We make sure we present the deal in the best possible way to give it the best chance of getting approved.
This a loan provided on the basis that the you declare what you earn instead of proving what you earn by way of standard income documentation.
This is a loan provided on the basis that the lender relies on the equity you have in a property instead of you having to provide income proof or declare an amount.
Is non-bank lending for you?
Non-bank lending is when a loan is obtained from an institution other than a Bank, such as a Credit Union or Building Society. In some cases the non-bank lender gets its funding line from a Bank!
For all New Zealanders with low deposit, self-employment, little proof of income or less than ideal credit history, it can be very difficult to find a Bank willing to give them a mortgage.
If you're in this situation, then non-bank lending provides you with a solution.


text:
package com.feilong.core.util.collectionsutiltest;

import static org.junit.Assert.assertEquals;

import java.util.ArrayList;
import java.util.List;

import org.junit.Test;

import com.feilong.core.util.CollectionsUtil;
import com.feilong.store.member.User;

import static com.feilong.core.bean.ConvertUtil.toList;

/**
 * The Class CollectionsUtilIndexOfTest.
 *
 * @author feilong
 */
public class IndexOfTest{

    /**
     * Test index of.
     */
    //************CollectionsUtil.indexOf(List<User>, String, String)******************************
    @Test
    public void testIndexOf(){
        List<User> list = toList(//
                        new User("张飞", 23),
                        new User("关羽", 24),
                        new User("刘备", 25));

        assertEquals(0, CollectionsUtil.indexOf(list, "name", "张飞"));
        assertEquals(1, CollectionsUtil.indexOf(list, "age", 24));
    }

    /**
     * Test index of not find value.
     */
    @Test
    public void testIndexOfNotFindValue(){
        List<User> list = toList(//
                        new User("张飞", 23),
                        new User("关羽", 24),
                        new User("刘备", 25));
        assertEquals(-1, CollectionsUtil.indexOf(list, "age", 240));
        assertEquals(-1, CollectionsUtil.indexOf(list, "age", null));
    }

    /**
     * Test index of null list.
     */
    @Test
    public void testIndexOfNullList(){
        assertEquals(-1, CollectionsUtil.indexOf(null, "age", 24));
    }

    /**
     * Test index of empty list.
     */
    @Test
    public void testIndexOfEmptyList(){
        assertEquals(-1, CollectionsUtil.indexOf(new ArrayList<User>(), "age", 24));
    }

    /**
     * Test index of null property name.
     */
    @Test(expected = NullPointerException.class)
    public void testIndexOfNullPropertyName(){
        List<User> list = toList(//
                        new User("张飞", 23),
                        new User("关羽", 24),
                        new User("刘备", 25));
        CollectionsUtil.indexOf(list, null, 240);
    }

    /**
     * Test index of empty property name 1.
     */
    @Test(expected = IllegalArgumentException.class)
    public void testIndexOfEmptyPropertyName1(){
        List<User> list = toList(//
                        new User("张飞", 23),
                        new User("关羽", 24),
                        new User("刘备", 25));
        CollectionsUtil.indexOf(list, "", 240);
    }

    /**
     * Test index of empty property name 2.
     */
    @Test(expected = IllegalArgumentException.class)
    public void testIndexOfEmptyPropertyName2(){
        List<User> list = toList(//
                        new User("张飞", 23),
                        new User("关羽", 24),
                        new User("刘备", 25));
        CollectionsUtil.indexOf(list, " ", 240);
    }
}

redpajama_set_name: RedPajamaGithub


The Directors League combines MovieMuse review scores of films to provide an overall rating (averaged from the individual films).
Only directors who have at least three film reviews on MovieMuse will be included. Where a score is tied, the Director with most films reviewed will be placed higher.
The scores for any given director may change over time as new reviews for their films are added and therefore their position on the league table could go up or down.
You can view information and review scores for each director by clicking on their name.


If you or someone you know is ever in crisis and needs help immediately – call 911 or visit your local emergency department.
At the first sign of suicidal thoughts, seek professional help. If a friend or family member is in crisis, be as supportive as possible, but remember you are not a trained counsellor or therapist.
Please note that the resources listed are not a complete listing and are not necessarily endorsed by jack.org. Use of these resources should not replace a professional diagnosis by a health care practitioner.


text:
Home More Information Match Regulations
Information Filter
All Star Trials
Bye Laws
Mouthguard / Helmets
Inter County Referees
GAA Injury Scheme
Match Regulations
Safeguarding/Child Protection
REGULATIONS GOVERNING THE ORGANISATION AND PRESENTATION OF GAMES (Approved by Ard Comhairle)
Affiliated schools are advised to familiarise themselves with the details of these Regulations which are posted both on our website (ulsterschoolsgaa.com) and on the Croke Park website (www.gaa.ie) Attention is drawn in particular to the following:
"A Sideline Official will be appointed by the committee-in-charge, and it shall be his duty to report any breaches of these Regulations. The Committee-in-charge may also appoint a Match Monitor who shall be responsible for any duties assigned. The Sideline Official shall include in his report any relevant observations or breaches reported to him by the Match Monitor. These will then form part of the Referee's Report in accordance with Rule 1.6, Rules of Control, T.O. 2017 (Cuid II) but any errors or omissions in respect of this shall not invalidate the Report as a whole.
The Committee-in-charge may also impose penalties for breaches of the Regulations brought to its attention by members of the Committee-in-charge or the Management Committee."
Failure to respect the regulations and follow laid down procedures therein may lead to penalties as defined in General Rule & Section 3 of this document being imposed on individuals, teams, County Committees, or Clubs by the Committees-in-Charge.
Game Regulations
The Referee has the authority during the game to send any person in repeated breach of these Regulations to the stand / outside the pitch enclosure, and such person may not be replaced.
Team Officials must be named on the official team list submitted to the referee. The number of Team Officials permitted to remain in the Pitch Enclosure during the game is up to a maximum of FIVE, who are the Bainisteoir, the Maor Foirne, the 2 Water Carriers / Hurley Carriers, and one Medic.
BAINISTEOIR:
The Bainisteoir shall wear a designated distinctive top, and is not permitted to enter the field of play. He may move along the sideline from the 65m line to the 45m line as per the 'Pitch Layout' in these Regulations. The Bainisteoir may not act in any other capacity (e.g. as Maor Foirne etc).
MAOR FOIRNE/RUNNER
The Maor Foirne (who must be Selector) shall wear a designated distinctive top, and may enter the field of play only through the area in front of the team's designated area, and only when the ball has gone out of play following a score, wide or during a stoppage in play called by the Referee. He shall exit the field of play at the nearest point and return to his designated area without interfering with play or opposition personnel. The Maor Foirne may not be a listed member of the Team panel and may not act as a designated Water/Hurley carrier.
A Break in Play:
A Break in Play is when the ball has gone out of play following a score or a wide, or a stoppage in play called by the Referee for medical attention to an injured player. The taking of a free, a 45, and/or a sideline kick/puck does not constitute a break in play.
Selectors must sit in their designated area and may not act as Water Carriers / Hurley Carriers.
MEDICAL PERSONNEL (I & II)
Two (2) Medical Personnel (2) shall be identified on the Official Team list and shall sit in the areas designated in Ground Regulations; they shall wear clear identification, may only enter the field of play to attend to an injured player.
Maor uisce
Two (2) Maor Uisce are permitted per team; they may not enter the field of play. Each must wear a designated distinctive top and will be situated as per the 'Pitch Layout' in these Regulations, and at least 2 metres from the sideline. In hurling, the Maoir Uisce will also act as Hurley Carriers, and may enter the field of play with a replacement hurley when necessary. Substitutes, injured players, or members of the extended panel may not act as Maoir Uisce.
*Penalties:
Penalties for breaches of Match Regulations shall be at the discretion of the Committee-in-charge. These may include warnings, fines, the withdrawal of sideline privileges as outlined in (a) – (e) above, or suspension of individuals as considered appropriate.
EXTRA TIME AND FINISHING GAMES ON THE DAY PROCEDURES
PHASE 1: Proceed to Extra time as provided for in T.O Cuid II (Two periods of ten minutes each way)
PHASE 2: If teams are still level, an additional two periods of five minutes each way will be played. (This shall be considered an extension to the first period of extra time, therefore a team reduced to 14 players because of a sending off during the playing of the first phase of Extra Time must start Phase II with only 14 players.)
PHASE 3: If still level, a "Free taking competition" to decide the outcome.
Each team will nominate 5 free takers for the competition and indicate to the referee in which order (1 to 5) the free takers will take the frees.
The 5 players above must be chosen from players who have participated in the game, either in normal time or in one of the periods of Extra Time.
Players who receive a red card in Hurling or Football, and players who receive a black card in Football, in normal time or any of the four periods of Extra Time are not permitted to participate in the free-taking competition.
The Referee will toss a coin for choice of ends in the presence of the Team Captains. The Captain who wins the toss will choose which end the free taking competition should be played into and will have the option of his team going 1st or 2nd.
The Referee will ensure 2 goal umpires are in place at the end in which the competition is being played into.
Frees will be taken by each of the five players from a position of their choosing on the 65 (Hurling) or 45 (Football) metre line. Frees in football may be taken from the hands or off the ground.
As per Ard Comhairle protocol, with the following additional provisions for younger age groups:
Hurling:
U16.5 years – frees will be taken from the 45m line.
Football:
(1) U16.5 years: frees will be taken from 33 metres (the apex of the D)
(2) U14.5 years: frees will be taken from the 20 metre line ateither corner of the D
In Hurling, frees shall be taken in accordance with the provisions of T.O 2016 Cuid II – Rules of Set Play Riail 2.5 (a) and (b) and Rules of Foul Play 4.24, 4.25 and 4.27. Breaches of these provisions will render frees null and void and they cannot be retaken.
In football, frees shall be taken in accordance with the provisions of T.O 2016 Cuid II Rules of Set Play – Rule 2.5 and Rules of Foul Play 4.23, 4.24 and 4.26. Breaches of these provisions will render frees null and void and they cannot be retaken.
Frees will be taken for points only, with no goalkeeper / defenders facing the free-takers.
With the exception of the player taking the free, all other players, managers, officials, backroom personnel etc should be at their designated sideline area, and off the field of play when the free taking competition is taking place.
The game is awarded to whichever team scores more of their 5 frees.
If still level then sudden death frees to be taken using the same 5 players in order (i.e. first sudden death free is taken by the player who took the first free for each side, 2nd sudden death free if required to be taken by the player who took the 2nd free and so on).
If a player scores in sudden death and his direct opponent misses, the game is awarded to the team of the player who has scored.
The sudden death element will continue until such time as there is a definite outcome (i.e. returning to the first player(s) and repeating the sequence again if required).

redpajama_set_name: RedPajamaCommonCrawl


text:
Feb. 11, 1950 WKY-TV Lets City Viewers Tune In to Television Era
Sandi Davis
Published: Sun, April 18, 1999 12:00 AM
Baby boomers raised in Oklahoma City remember.
They remember sitting on benches at the Circle 4 Ranch on the "Foreman Scotty Show." They remember live professional wrestling from the Stockyards Coliseum on Friday nights and watching weatherman Jim Williams draw thunderstorm hot spots on a map.
They remember Mary Hart and Danny Williams on their noontime talk show, "Danny's Day."
Some may even remember the state's first television station as WKY, long before it was KFOR, Channel 4.
WKY made its broadcast debut June 6, 1949, becoming the 65th TV station in the United States.
The station, owned by Gaylord Broadcasting Co. in 1949, was sold to The Evening News Association in Detroit and then was bought by The New York Times Co. in July 1996.
KFOR is celebrating its 50th year on the air in 1999. Some of the station's milestones:
It began daily broadcasting Feb. 11, 1950.
In 1953, the station donated $150,000 in television equipment to the Oklahoma Educational Television Authority, making it possible to start educational television in Oklahoma.
It was the first independent station in the nation to broadcast in color.
It was the first station to install radar for weather reports and to broadcast tornado warnings.
It was the first station to have a mobile unit and televise OU football games.
It was the first station to telecast programs in stereo.
Danny Williams' show, "3-D Danny," was the first local show to get better ratings than "The Mickey Mouse Club."
The station received an Emmy in 1974 for "Through the Looking Glass Darkly," which examined the history of blacks in Oklahoma.
Steve Powell, the much-loved Foreman Scotty, died in 1994.
Meteorologist Jim Williams has retired.
Danny Williams, a staple of WKY radio and TV, is now the morning disc jockey on KOMA, giving adult baby boomers a bit of continuity in today's changing TV and radio markets.
Archive ID: 759492


text:
InspecVision scoops prestigious CIM Ireland Marketing Award
Mallusk-based company, InspecVision Ltd, was among the winners at the Chartered Institute of Marketing (CIM)'s prestigious Ireland Marketing Awards on November 9th.
Faculties - Faculties at Ulster
Ulster University Business School - Ulster University Business School
Ulster University Business School students make 500k profit in seven weeks
Ulster University Business School Student Aces Interview Test
Ulster University Business School Students Ace Interview Test
Award Winning Megan in Seventh Heaven
Hat trick of awards for Business School graduate
Award Success for Hospitality Management Student Niall Beatty
Mallusk-based company, InspecVision Ltd, was among the winners at the Chartered Institute of Marketing (CIM)'s prestigious Ireland Marketing Awards on November 9th. It was awarded winner of the category Most Marketing Impact on a Small Budget, sponsored by Ulster University Business School and judged by an esteemed panel of experts, including Nicky Jackson, deputy head of local campaigns for the Cabinet Office, and Ann McGregor FCIM, CEO of the Northern Ireland Chamber of Commerce and Industry.
The awards were held at the magnificent Titanic Belfast and hosted by CIM, the world's leading professional marketing body, with partners The Marketing Trust.
The ceremony highlighted the new face of marketing, with digital innovation and multichannel customer experience at the forefront of this year's winning campaigns.
InspecVision's success was recognised by CIM for its unrivalled performance in achieving the most marketing impact on a small budget. The purpose of the campaign was to increase sales and brand awareness in the USA.
InspecVision Ltd was established in 2003 and specialises in the design and manufacture of computer vision based 2D and 3D measurement systems for industrial applications. The founder of the company, Dr. Jan Antonis, carried out advanced research in computer vision systems at Queens University Belfast and saw there was a gap in the market for a system which could measure parts quickly and easily. Sales of the Planar inspection system, for quality control and reverse engineering applications, began in 2005. InspecVision products are now sold in over 30 countries worldwide
Dr. Jan Antonis, Managing Director and founder of InspecVision commented:
"We are delighted that the hard work we have put into developing the US market over the past two years has been recognised. Whilst we have had a presence in the USA for many years, this campaign resulted in a 220% increase in US sales, new partnerships with Productivity Quality Inc and Mitsubishi and a 50% increase to our workforce here in Mallusk."
On the night, Chris Daly, chief executive of CIM, addressed the finalists by saying:
"We are here tonight to recognise and celebrate the insight, creativity and impact Irish marketers are having on the world. With the hunt for Ireland's best marketer almost complete, tonight we will celebrate and crown the very best our sector has to offer." "I am delighted that the Marketing Trust, which has provided invaluable support to the industry, has joined forces with us in Ireland for the first time, to highlight the advantage marketing can provide in today's increasingly competitive – and often uncertain – business environment."
Discussing the night, Eileen Curry, Chair of CIM Ireland, said:
"It was a hugely successful night. It's clear that the role of the marketer is becoming more demanding, competitive and varied as it expands to encompass data analysis, commercial awareness, business development and customer experience. Our winners have demonstrated the enormous value that marketing brings to a business or an organisation, particularly during these times of immense change. I would like to offer my congratulations to all who made it to the finals; they reflect the very best in marketing talent and I'd also like to thank our founding partner, The Marketing Trust, who help make these awards possible."
The CIM Ireland Marketing Awards are a celebration of the very best marketing innovations,interventions and campaigns crafted by organisations, businesses and agencies from across Ireland.


The biggest and most trusted mold inspection company offers its services to the entire state of Near North Valley, New Mexico without a conflict of interest. Only inspectors that are skilled and have years of experience are employed by us. You can be sure that whichever technician is appointed to your residence has seen properties similar to yours in the past. Other than generating thorough protocols for people that do indeed have a issue, MI&T has no role in the mold removal practice so you can trust the Near North Valley mold testing results your get from us to be truthful.
You might have found yourself at our website because you are experiencing something unusual that has you thinking mold may be a problem in your residence or business. Each situation is different in its own way, but most mold problems occur for similar reasons. Just know that our specialized and certified mold inspectors have seen it all. If there is a issue present, they will be able to discover it and supply the best plan for Near North Valley mold tests possible. Prior to any sample collection, you will have the final say in what is to be tested.
Unlike "free mold inspections" in Near North Valley, New Mexico offered by many companies that do handle mold remediation; our service is complete with mold testing. This is the only way to get factual evidence and be sure of exactly what is going on with your indoor environment. Since some types of mold are not toxic, some things that may look bad to you might not be as serious as you think. This means you might not need professional services at all and we will be pleased to pass on that information to you. If going through insurance or if you are in any sort of disagreement, having our report can be a backing of your argument.
On the other hand our Near North Valley mold inspection in New Mexico still offers you valuable information for situations in which a issue does exist. Our thorough report will include the origin of the problem, what type of mold is present, and how far the issue has spread. Mold remediation is a very expensive process and has to be carried out by a company that knows what they are doing. Having our report will benefit you by making sure no unnecessary work is done to keep the bill as small as possible. Following the step-by-step protocol we lay out will also make sure the job is done properly the first time.
We hope that you grasp the benefit of a Near North Valley mold inspection prior to appointing a company to handle a remediation project. Spending a little more money up front will most likely save you some of money and frustration in one way or another in the big scheme of things. If you do make up your mind to go straight into the removal process, we highly recommend getting a clearance test before the buildback in order to ensure the problem was handled properly and the job is complete. Please call us with any questions or to schedule an inspection at 505-312-4403. Mold Inspection and Testing also serves all of the following cities around Near North Valley, New Mexico.
Last updated: October 15, 2013 at 18:05 pm by Eric R.


text:
Is s4 relatable?
Thread starter Octavia
#buffy #btvs #vampires #noangel #s4 #student dorms
My arse is not pansy!
S4 was one of the least relatable seasons for me. Perhaps why s5 appealed so much. What aspects of s4 were true to your growing up experience?
You rocks think you're so smart.
I never went to college, so I find that I agree with you about the least relatable, but I think if I had to pick a big one, it would be the way the main gang (Buffy, Willow, Xander and Giles) all grow apart over this year. That they get back together rather easily is irritating and super fake, but before that, it was handled very believable. I can't count the number of friends I've had over the years who I thought would be in my life forever; at last count, only one of them still is...for now.
Reactions: Btvs fan and Kratos
AlphaFoxtrot
I remember seeing "The Freshman" in college, and laughing for a good twenty minutes at how true to life the first act is, of how overwhelming the whole experience is. But other than that, I didn't attend a party school or a large state college, so, a lot of it was someone else's life. Also, I did chuckle when Giles got lost on campus, because that always happens to me.
Reactions: Twinkie and spikenbuffy
HowiMetdaSlayer
Occasionally, I am callous and strange 🐶
Well, for me, Willow's S4 story line was pretty relatable.
Reactions: Willow Tara
WillowFromBuffy
I've been in college and the military since forever. I lived in my dad's basement for a while. I've had all kinds of jobs, even construction. Sex hasn't always been the start of a long and meaningful relationship. Break ups. Gay encounters. Annoying flatmates. Constant invitations to parties.
S4 is the season that's the closest to my heart. It's criminally underrated.
Reactions: SunnydaleGlitz, Joan the Vampire Slayer, Btvs fan and 3 others
Ethan Reigns
Season 4 would have been more relatable if the Initiative hadn't been presented the way it was.
Every campus has some equivalent to the Regular Officer Training Plan so instead of being an elite soldier (who seems to fail at everything he does), Riley could have been a student in this program. Riley did not have the look of experience or the thousand-yard stare that veterans get when they remember things they had done and he was too young to be one of the elite.
There would possibly be a building for them on campus so the concept of a secret lab ten stories below ground wouldn't be necessary. There could be no such secret - there would have been a record of an excavation that went down a hundred feet below a building. Even if it wasn't a military building, we in the Ontario Aerospace Council (where I was a representative for our company) often met at the Institute for Space and Terrestrial Science on the northeast corner of the York University campus. No need for cloak-and-dagger secrecy when it is easy to just use a building that has other uses.
I thought the concept of Adam's war to pit humans against demons to create a hybrid race with cyborg enhancement was ingenious but suffered from lack of development - it only showed up in a couple of episodes.
two by two, hands of blue
HoppyHippy said:
Not so much with the specifics is it relatable, but it's the most relatable in how I felt at that age. I very much experienced Xander's listless malaise about his place in the world, though that translated in reality to clinical depression lol. Good times.
Reactions: WillowFromBuffy and Btvs fan
thrasherpix
First, I have to say that I found much in the earlier seasons relatable...though Sunnydale High wasn't like any public school I'd gone to, from its dress codes to its gothic library. (Principal Flutie was a popular school stereotype at the time but I never encountered anyone like him, unless I want to count a passive aggressive school counselor who was deliberately malicious.) I should also add that I only did 2 years in high school (and didn't do the full year of either one before I left), one year in a special program for delinquents (and thus separated from the general school population), and have never gone to any school dance in my life, let alone prom. I am NOT nostalgic for those days, and the very thought of my waking up a kid again makes me shudder. And yet seasons 1 to 3 still work for me.
Likewise, I never went to college, nor did I join the military. Offhand, that's about all I remember of the mundane aspects of season 4. I still like the season, though. As for what was most relatable...all I can think of is that I've had to help care for people withdrawing from drugs and/or alcohol as Buffy did Riley, and that's it.
I guess it's just that I love scifi, fantasy, and even (dark) faerie tales, always have, and that's what draws me to the stories of the show.
Also of interest (to me anyway), season 6 is arguably the one I could relate to the most, as I was living very poor at the time I saw it and had to deal with stalkers, drug addicts (hell, I helped prepare and sell drugs when I was a kid on the street), been locked in a mental hospital as a kid where an evil doctor tried to distort my sense of reality, and back then I also dealt with death (such as the horrid death of my best friend), loss, and violence of all sorts. And yet it's the season I dislike the most.
Perhaps because it's written in a way I find a penny dreadful of what people who never experienced such things imagine it to be like, or maybe it's because it deliberately stepped away from metaphor that I loved so much and tried to make it a bit more realistic (failing in the process, IMO, though I'm aware others disagree). And even for angst and realism, I'd say season 5 did that better, and season 2 actually ended on angst, unlike season 6.
Good gods, all the funerals I went to and graves I visited recently....I wonder if I dare watch season 5 again soon....
BuffyBot22
s4 is very relatable to me.
Adjusting to a new roommate in college is always hard. And I actually had 2 experiences in undergrad where my roommate turned out to be quite vindicative and evil just like Kathy was to Buffy. Not to mention before we found out Kathy was a demon she was crossing all sorts of boundaries that I had roommates cross like eating my food or thinking borrowing my clothes was okay.
Growing apart from your high school friends in undergrad is a very real thing. I grew a part from a lot of my friends my first year away and then we got back closer toward the end of that year, just like it happened for the scoobies. This was due to us just living very different lives and attending different schools. But I am actually still friends with them now so I would say it all worked out, but we definitely drifted apart in undergrad and then came back together around the end of my freshman year.
The season that was the most unrelatable to me was s7 bc it just didn't have a clear path or good metaphors. Otherwise even if you didn't have direct life events that coincided with Buffy gang's life events I still found the seasons relatable. Like for instance s6 is very relatable even though my mom is alive, I haven't been in an abusive relationship, and I haven't been as depressed as Buffy was. Still thought that season was super relatable though bc so much of what the scoobies were going through happens IRL.
Joan the Vampire Slayer
Carpe Spuffy!
I can't honestly say S4 was relatable to me personally - at least not the depiction of the college experience. I went to college, but I was a "commuter" student, lived off campus and worked part-time.
Reactions: Btvs fan
Btvs fan
Joan the Vampire Slayer said:
Same here. Also my college never looked as fantastic as the Buffy college looked either 😩
Seriously production wise I think S4 had the best sets and fight scenes on the show.
Agreed! The Fight between B and S in Harsh Light of Day is great!
Reactions: Joan the Vampire Slayer
sosa lola
I related to Buffy's experience the most, how out of place she felt in her first days at college and growing apart from my high school friends.
Reactions: BuffyBot22, Athene and Btvs fan
vampmogs
Btvs fan said:
I'm not sure about sets but I totally agree about the fight scenes. The fight scenes were so great in Season 4 and it's such a shame that we changed stunt teams for Season 5. They were getting so, so good and it's incredibly noticeable how different the stunts are after this season. Buffy was depicted as being so quick and powerful in Season 4 and then all of a sudden she's much slower and doing all these unnecessary gymnastics and flips. It's such a shame we didn't get to have the Buffy VS Glory scenes choreographed by Pruitt *sigh*
As for the topic of the thread, I did find Buffy's story in "The Freshman" really relatable. I was totally overwhelmed my first few days of college. I had attended the same school my entire life (it was a school that went from elementary right up to senior year) so suddenly attending a huge college in the city was a pretty big shock for me. I also distinctly remember running into a girl from my high school on my first day and she seemed to be totally engrossed in college already and had met a bunch of new people so I felt even more out of place (similar to how Willow/Oz seemed to adapt far more quickly than Buffy did which isolated her).
I should also note, this only applies to the first 2-3/5th of the season. I felt it did a good job of showing the Greatest Hits of the first year of college, then it became about having unfinished business with you Shadow Self, or Military nonsense. That part is where the season loses me. The final part where the Scoobies come together to use the Magic of a Friendship Speech to break Adam is on target, but so much of the season isn't. But then again, it was Buffy. If I wanted to watch a show about College, I would have watched "Felicity." You know, Buffy never did time travel, but Felicity did. What's up with that?
Neptune, California
I definitely feel it was relatable. Freshman year was a wild experience. I definitely started feeling the growing apart from my HS friends—this continued throughout college for me. I had my first relationship and came out to my closest friends—a monumental scary experience. Of course my boyfriend that year was no Tara—wholly the opposite. And my HS framily never had that come back together moment the scoobies had. Of course, the Buffy and Friends Experience isn't EVERYONES Experience, but it was definitely relatable. The least relatable would be, as others said, season 7 because it lost the metaphorical aspect of the show for a serialized year of suckiness (after CWDP)
Reactions: WillowFromBuffy
telperion66
York, England
For me, there's definitely a disconnect in the overall tone of season four compared with earlier seasons.
I heavily related to the Angel/Buffy storyline. After Angel left and Buffy seemed to move on pretty quickly, I couldn't get to grips with how she did that at all.
I related a lot to the gang being in high school. Being at college put a distance between their interests and mine, as I really liked the high school metaphors and storylines compared to the seemingly lofty academic world of university. The storylines didn't feel as immediate or gritty being based on the college campus.
Overall, its a Buffy season, so I relate to the characters quite well regardless. I feel I know and appreciate their strengths a lot, but I just felt that disconnect compared to the earlier seasons. I still like to occasionally dive into and watch this season, though.
Reactions: Ceadsearc03
SunnydaleGlitz
Very relatable, especially to the campus feel and the idea that you could get lost navigating where to go for your next class and whether you'd catch on quick to assignments. I related both to Buffy's nerves but also to Willow's excitement. My first college I commuted to, my second uni I basically stayed on campus housing in a big city. I didn't know a soul, and the first week was kind of intimidating. Also, relationships/ break ups/ trying to move on/ making new friends/ feeling like a misfit/ exploring your identity is all very relatable.
Its very subjective as to whether the individual actually went to college/university. But, I definitely see why It would be relatable for you in that sense! :)
Reactions: WillowFromBuffy, telperion66 and TriBel
I thought S4 was the last of the relatable seasons in Buffy. The subsequent seasons each felt less and less relatable.
Aside from relating to Buffy's first experiences at college, I also related to Xander's storyline, albeit, later in life. I mean, I guess you could say I relate a lot to Buffy's arc in Season 6 too (dropping out of college and being in a dead end job/her depression) but Xander's storyline in Season 4 really speaks to me even if I did initially attend college. Whilst Buffy's story in Season 6 very briefly touched on her feelings of aimlessness both professionally/educationally, I felt that Xander's lack of purpose and direction and his inferiority complex resonated with me. I went through the exact same thing in my mid-twenties when I didn't feel I was getting anywhere and I was bouncing from one dead-end job to the next. His insecurities about his friends and being left behind was also something I really identified with.
Furthermore, I really identified with Willow/Tara this season and especially Tara in "New Moon Rising." I'm a gay guy but I've rarely connected with Willow/Tara on that level as their gay experience doesn't really reflect mine at all. However, I did strongly relate to their relationship when it was a secret and kept hidden from the other characters. The moment that really stands out to me is also in "New Moon Rising" when Oz shows up at Giles' apartment and Tara is really uncomfortable and hurt but nobody pays any attention to her because as far as they're all concerned Tara is just Willow's "friend" and she is not remotely on their radar. I've totally been there. I know what it's like to have a secret relationship with someone and for that person to really matter to you, and for you to feel like you matter to them, but because your relationship is kept hidden from everyone else by that very person, nobody around you acknowledges you as being remotely significant to that person's life. It's such an odd and disconcerting feeling to have such an intense and important relationship with someone but for that relationship to be totally unacknowledged by everyone else. On a larger scale, it's also really reflective of those horrible situations many gay couples go through when one person is in a terrible accident or even dies, and their family completely cuts their partner out of decisions about their health/wellbeing or funeral etc and refuses to acknowledge them as their life-partner. It's totally soul-crushing and horrible and why gay people have fought so hard to be legally recognised the same way a straight partner would be. So Tara's scenes in that episode really resonate with me strongly.
I love Season 4.
S4 is the best!
Yes so much to this! Being in a closeted relationship is so detrimental to both parties! Especially if you are out and the other person is not. I know everyone comes out in their own time but that kind of relationship is so difficult.
Reactions: Btvs fan and WillowFromBuffy
"Mist... cemetery... Halloween. Should end well."
Partially relatable. My college experience was also different since I'm a foreigner, but I can relate to several of the topics explored throughout the season (except the initiative arc, we definitely didn't have something like that on campus 😝).
good the Initiative on your campus was better at hiding itself.


text:
Home Legal
New Zealand bans semi-automatic, assault rifles
Updated : March 21, 2019 08:45 AM IST
Prime Minister Jacinda Ardern announced the gun law reforms at a press conference, New Zealand Herald reported.
The government has banned the weapons less than a week after a shooter opened fire at two mosques in Christchurch, killing 50 people, and injuring 50 others.
Military-style semi-automatics and assault rifles will be banned under stronger new gun laws announced by the New Zealand government on Thursday.
IndiGo Q1 net profit at Rs 1,203 crore
The country's rules around guns have been in the spotlight since last Friday's mosque shootings in Christchurch.
Attorney-General David Parker said over the weekend that semi-automatic guns would be banned and 70,000 people have signed a petition against these types of weapons.
Tags Gun Laws New Zealand new zealand mosque attack New Zealand PM Jacinda Ardern
Have you signed up for Primo, our daily newsletter?
It has all the stories and data on the market, business, economy and tech that you need to know.
THANK YOU! You made our day. See you every morning
YOUR EMAIL IS ON ITS WAY. Check your inbox for future updates.
To keep watching CNBC-TV18, India's No. 1 English Business News Channel, call your Cable or DTH Operator and subscribe now for just Rs. 4 per month. You can also subscribe to CNBC-TV18 Prime HD for Re 1/- per month.Find out more
Markets at close: How the major indices and stocks fared on...


text:
Q: mysql select from a view with where condition gives different result than executing the view definition with where condition I have a view with the following definition:
    select
        `cb_trans_detail`.`numero_partida` AS `numero_partida`,
        `cb_trans_head`.`fecha_partida` AS `fecha_partida`,
        `cb_trans_detail`.`concepto_partida` AS `concepto_partida`,
        `cb_cuenta`.`nombre_cuenta` AS `nombre_cuenta`,
        `cb_cuenta`.`codigo_mayor` AS `codigo_mayor`,
        `cb_mayor`.`nombre_mayor` AS `nombre_mayor`,
        `cb_mayor`.`categoria` AS `categoria`,
        `cb_categoria`.`nombre` AS `nombre`,
        `cb_categoria`.`presentacion` AS `presentacion`,
        `cb_trans_detail`.`codigo_cuenta` AS `codigo_cuenta`,
        sum(`cb_trans_detail`.`debito_partida`) AS `Debitos`,
        sum(`cb_trans_detail`.`credito_partida`) AS `Creditos`,
        `cb_cuenta`.`saldo_inicial` AS `saldo_inicial`,
        ((`cb_cuenta`.`saldo_inicial` +
       sum(`cb_trans_detail`.`debito_partida`)) -
       sum(`cb_trans_detail`.`credito_partida`)) AS `Saldo`,
        concat(`cb_mayor`.`categoria`,`cb_cuenta`.`codigo_mayor`,`cb_trans_detail`.`codigo_cuenta`)
 AS `Codigo`
      from
        ((((`cb_trans_detail` join `cb_cuenta`
      on(((`cb_trans_detail`.`codigo_cuenta` = `cb_cuenta`.`codigo_cuenta`)
      and (`cb_trans_detail`.`categoria` = `cb_cuenta`.`categoria`)
     and (`cb_trans_detail`.`codigo_mayor` = `cb_cuenta`.`codigo_mayor`))))
     join `cb_mayor` on(((`cb_cuenta`.`codigo_mayor` = `cb_mayor`.`codigo_mayor`)
     and (`cb_cuenta`.`categoria` = `cb_mayor`.`categoria`))))
     join `cb_categoria` on(((`cb_mayor`.`categoria` = `cb_categoria`.`categoria`)
     and (`cb_trans_detail`.`categoria` = `cb_categoria`.`categoria`))))
     left join `cb_trans_head` on((`cb_trans_detail`.`numero_partida` =
     `cb_trans_head`.`numero_partida`)))
      where
        (`cb_categoria`.`presentacion` = '1')
        group by  concat(`cb_mayor`.`categoria`,`cb_cuenta`.`codigo_mayor`,
        `cb_trans_detail`.`codigo_cuenta`)

If I select from this view as follows:
SELECT
  `balance_general_view`.`numero_partida`,
  `balance_general_view`.`fecha_partida`,
  `balance_general_view`.`concepto_partida`,
  `balance_general_view`.`nombre_cuenta`,
  `balance_general_view`.`codigo_mayor`,
  `balance_general_view`.`nombre_mayor`,
  `balance_general_view`.`categoria`,
  `balance_general_view`.`nombre`,
  `balance_general_view`.`presentacion`,
  `balance_general_view`.`codigo_cuenta`,
  `balance_general_view`.`Debitos`,
  `balance_general_view`.`Creditos`,
  `balance_general_view`.`saldo_inicial`,
  `balance_general_view`.`Saldo`,
  `balance_general_view`.`Codigo`
FROM
  `balance_general_view`
WHERE
  `balance_general_view`.`fecha_partida` BETWEEN '2014-01-01' AND '2014-01-31'

this yields a different result than if I execute the query as follows:
select
    `cb_trans_detail`.`numero_partida` AS `numero_partida`,
    `cb_trans_head`.`fecha_partida` AS `fecha_partida`,
    `cb_trans_detail`.`concepto_partida` AS `concepto_partida`,
    `cb_cuenta`.`nombre_cuenta` AS `nombre_cuenta`,
    `cb_cuenta`.`codigo_mayor` AS `codigo_mayor`,
    `cb_mayor`.`nombre_mayor` AS `nombre_mayor`,
    `cb_mayor`.`categoria` AS `categoria`,
    `cb_categoria`.`nombre` AS `nombre`,
    `cb_categoria`.`presentacion` AS `presentacion`,
    `cb_trans_detail`.`codigo_cuenta` AS `codigo_cuenta`,
    sum(`cb_trans_detail`.`debito_partida`) AS `Debitos`,
    sum(`cb_trans_detail`.`credito_partida`) AS `Creditos`,
    `cb_cuenta`.`saldo_inicial` AS `saldo_inicial`,
    ((`cb_cuenta`.`saldo_inicial` + sum(`cb_trans_detail`.`debito_partida`)) - sum(`cb_trans_detail`.`credito_partida`)) AS `Saldo`,
    concat(`cb_mayor`.`categoria`,`cb_cuenta`.`codigo_mayor`,`cb_trans_detail`.`codigo_cuenta`) AS `Codigo`
  from
    ((((`cb_trans_detail` join `cb_cuenta` on(((`cb_trans_detail`.`codigo_cuenta` = `cb_cuenta`.`codigo_cuenta`) and (`cb_trans_detail`.`categoria` = `cb_cuenta`.`categoria`) and (`cb_trans_detail`.`codigo_mayor` = `cb_cuenta`.`codigo_mayor`)))) join `cb_mayor` on(((`cb_cuenta`.`codigo_mayor` = `cb_mayor`.`codigo_mayor`) and (`cb_cuenta`.`categoria` = `cb_mayor`.`categoria`)))) join `cb_categoria` on(((`cb_mayor`.`categoria` = `cb_categoria`.`categoria`) and (`cb_trans_detail`.`categoria` = `cb_categoria`.`categoria`)))) left join `cb_trans_head` on((`cb_trans_detail`.`numero_partida` = `cb_trans_head`.`numero_partida`)))
  where
    (`cb_categoria`.`presentacion` = '1') and `cb_trans_head`.`fecha_partida` BETWEEN '2014-01-01' and '2014-01-31'
  group by
    concat(`cb_mayor`.`categoria`,`cb_cuenta`.`codigo_mayor`,`cb_trans_detail`.`codigo_cuenta`)

My question is: How to get the result I need using the view and filtering programatically instead of hard-coding the where condition? Thank you. If you need the individual table definitions let me know. Much appreciated.

A: If you use a left join to a table X and a condition in the WHERE-clause to this table X, you change your left join to an inner one. If you want to restrict the results by the values of this left joined table, you must use this condition in the ON clause of the left join instead:
...
LEFT JOIN
    cb_trans_head
ON
    cb_trans_detail.numero_partida = cb_trans_head.numero_partida
AND
    cb_trans_head.fecha_partida BETWEEN '2014-01-01' and '2014-01-31'
...

If there's another one that I overlook, tread it the same way.

redpajama_set_name: RedPajamaStackExchange


Signing: Our non-dominant hand is placed flat with palm up and our dominant hand hits the flat side of the non-dominant hand with hand extended, fingers together and palm visible. Imagine an ax or knife cutting something.
Usage: We use stop as a safety sign to teach babies to stop dangerous behaviors or activities .
Flash Card: Click the link to view the Stop Baby Sign Language Flash Card. The flash cards are printable and available in both U.S. Letter and A4 sizes.


Our first meeting with citizens in Hørve shows that committed and organized community work is an important component in revitalizing urban functions and meeting places around residental subdivisions in minor towns.
A recently established civic centre has formed one of the backbones to foster social network activities for the community. Experiments with repair cafes have shown to be a valuable platform to meet across generations and different cultural backgrounds. Also the town has recently started organizing events that activate empty retail buildings to showcase the potentials of the community life.
We see plenty of capacity building potential to be further developed here.


text:
Rivian CEO Shows Off R1S SUV Interior | 10 Mar 2021
Wanna split £100? You get £50 free AND save money on 100% green electricity by moving to Octopus Energy. Plus I get £50 to support this podcast but ONLY if you do it by using my unique referral code. I moved to Octopus recently and had been putting it off for ages, but I kicked myself for not doing it sooner, as it's literally a 5 minute job to give them your details.
Click here: https://share.octopus.energy/free-puma-452
On today's podcast:
Kia unveils the EV6, its first dedicated EV
Dacia Spring EV now available to order, priced from €12,403
Tesla Will Ask Regulators to Allow FSD Beta Release in Europe, Says Elon Musk
Tesla's cost per kWh for cells from suppliers revealed
bp pulse invests £2 million to upgrade legacy charge points
Rivian CEO shares how roomy the back of the R1S will be
Hyundai announces New KONA Electric prices
Show #1017
Good morning, good afternoon and good evening wherever you are in the world, welcome to EV News Daily for Wednesday 10th March. It's Martyn Lee here and I go through every EV story so you don't have to.
"Kia has revealed the first official images of the EV6 – its first dedicated Battery Electric Vehicle (BEV) built on the company's new EV platform: the Electric-Global Modular Platform, or E-GMP. The EV6 is also the first of Kia's next-generation BEVs to be developed under a new design philosophy that embodies Kia's shifting focus towards electrification." says Next Green Car: "Kia has not yet provided any technical data on the EV6 with the revealing of the name and the sketch of the design. However, the Ioniq 5 should provide some good clues here, since it is based on the same platform. This basis will give Kia the scope for batteries with 58 or 73 kWh, powertrains between 125 and 225 kW. The technical details of the electric Kia might differ slightly, but the Kia EV6 should also have the fast-charging capability of up to 220 kW and the impressive charging curve of the Ioniq 5."
https://www.nextgreencar.com/news/9106/kia-unveils-the-ev6-its-first-dedicated-ev/
Dacia is opening a new chapter in its history with the launch of all-new Spring, the brand's first 100% electric car.
Dacia benefits from the unique know-how and experience acquired by the Renault Group and the Renault-Nissan-Mitsubishi Alliance, pioneers of electric mobility for over 10 years.
Priced at €12,403 after government incentives in France, Dacia Spring is the most affordable electric car in Europe, making electric mobility accessible to the greatest number of people.
Beneath its SUV look lies a city car with record-breaking roominess with 4 real seats, a simple and reliable electric engine and a range of 230 km (WLTP) and 305 km in the city (WLTP city).
The 33 kW (44 hp equivalent) all-electric power engine is coupled with a 27.4 kWh battery.
https://en.media.groupe.renault.com/news/the-all-new-dacia-spring-taking-the-electrical-revolution-for-a-spin-ace9-989c5.html
"After Tesla CEO Elon Musk announced the wider release of the newest FSD Beta a few days ago, this topic has attracted even more attention from those who want to become a participant in the early testing program. In addition to requests from North America, Europeans also expressed a strong desire to become beta testers. Musk wrote that Tesla will ask regulators in order to make possible the proliferation of FSD Beta in Europe." reports Tesmanian: "Also, in response to a request from a Tesla owner from Europe, Musk replied that the company would ask the regional regulators to authorize the use of FSD Beta there. If this approval is granted, it will become an additional stage in the development of FSD. The fact is that the layouts of cities in the United States and Europe are significantly different. Europe is characterized by compact cities with many narrow streets saturated with dense traffic."
https://www.tesmanian.com/blogs/tesmanian-blog/tesla-will-request-regulators-to-release-fsd-beta-in-europe-says-elon-musk
"Tesla sources many of its battery cells from third-party suppliers, like Panasonic, LG Chem, and CATL. Because of the massive rate at which Tesla buys these cells, it is paying significantly less per kilowatt-hour compared to its competitors, according to a new report from Cairn Energy Research Advisors" says Teslarati: "According to Cairn's research, Tesla pays an average of $142 per kWh for cells purchased from its three previously mentioned suppliers. Meanwhile, companies like GM are paying $169 per kWh, while the industry average runs around $186, according to the firm's report. Furthermore, Tesla's packs cost $187 per kWh on average, with GM's costing $207 per kWh and the industry average being $246 per kWh."
Tesla's cost per kWh for cells from suppliers revealed, and it's much lower than competitors
"In the UK, bp pulse is pledging to improve the reliability of the UK's older public charging infrastructure by working with local authorities to upgrade and replace charge points across the country." reports Electrive: "The BP subsidiary – that was given the new name bp pulse incorporating bp Chargemaster and Polar in 2020 – has already agreed to invest over £400,000 in infrastructure for replacing more than 50 charge points. These are mostly owned by local authorities and originally installed over a decade ago with government grant funding under the Plugged in Places scheme. Beyond the upgrading of initial 50 charge points, discussions are already underway to make an additional £750,000 available for legacy charge point owners, which could see over 300 units upgraded. In total, bp pulse has made £2 million available for the endeavour."
"Rivian's CEO RJ Scaringe Tweeted a video of himself surrounded by R1S electric SUVs. In the video, he explains how the second and third-row seats fold down and shares perspective of how much room future drivers will actually have." says Electrek: "In a recent Tweet, Rivian CEO RJ Scaringe offers fans of the automaker a glimpse at a posse of R1S SUVs. The video features eight different R1S' lined up in various colors. Scaringe speaks about how he has been driving the R1S the past couple weeks and has been loving it. He talks about loading up his kids and gear, and even posted along with the video, "Ready for camping!" This certainly fits the theme of outdoor, all-terrain situations the high-performance EV is geared specifically toward. Scaringe admits many people have been curious about how the second and third rows fold flat in the R1S, so he decided to share a demonstration. With the tailgate down, the seats lay seamlessly flat from the second-row headrests, out the EV's rear."
""The refreshed Hyundai Kona Electric is now on sale, with prices inclusive of the £3,000 government plug-in car grant starting from £30,125. The all-electric SUV has been given a visual refresh, with more technology introduced across the range too" says CarWow: "Opt for a range-topping Ultimate spec, and that rises to £40,375. All cars get a 10.25-inch digital driver's display and equally-sized infotainment system as standard, along with rear parking sensors and a reversing camera. Adaptive cruise control and keyless entr.y. Upgrade to the 64kWh and that's paired to a 150kw, 204hp motor. That boosts range up to 300 miles as well. Both versions are said to be capable of being charged from 10-80% in 47 minutes."
https://www.carwow.co.uk/news/5151/2021-hyundai-kona-electric-prices-revealed
You can listen to all 1016 previous episodes of this this for free, where you get your podcasts from, plus the blog https://www.evnewsdaily.com/ – remember to subscribe, which means you don't have to think about downloading the show each day, plus you get it first and free and automatically.
Come and say hi on Facebook, LinkedIn or Twitter just search EV News Daily, have a wonderful day, I'll catch you tomorrow and remember…there's no such thing as a self-charging hybrid.
PHIL ROBERTS / ELECTRIC FUTURE (PREMIUM PARTNER)
BRAD CROSBY (PREMIUM PARTNER)
PORSCHE OF THE VILLAGE CINCINNATI (PREMIUM PARTNER)
AUDI CINCINNATI EAST (PREMIUM PARTNER)
VOLVO CARS CINCINNATI EAST (PREMIUM PARTNER)
NATIONALCARCHARGING.COM and ALOHACHARGE.COM (PREMIUM PARTNER)
DEREK REILLY FROM THE EV REVIEW IRELAND YOUTUBE CHANNEL (PREMIUM PARTNER)
RICHARD AT RSEV.CO.UK – FOR BUYING AND SELLING EVS IN THE UK (PREMIUM PARTNER)
DAVID AND LISA ALLEN (PARTNER)
GARETH HAMER (PARTNER)
eMOBILITY NORWAY HTTPS://WWW.EMOBILITYNORWAY.COM/ (PARTNER)
BOB BOOTHBY FROM MILLBROOK COTTAGES – 5* GOLD SELF CATERING COTTAGES (PARTNER)
DARIN MCLESKEY FROM DENOVO REAL ESTATE (PARTNER)
JUKKA KUKONEN FROM WWW.SHIFT2ELECTRIC.COM
RAJEEV NARAYAN (PARTNER)
IAIN SEAR (PARTNER)
ADRIAN BOND (EXECUTIVE PRODUCER)
ALAN SHEDD (EXECUTIVE PRODUCER)
ALEX BANAHENE (EXECUTIVE PRODUCER)
ALEXANDER FRANK @ https://www.youtube.com/c/alexsuniverse42
ANDERS HOVE (EXECUTIVE PRODUCER)
ANDREA JEFFERSON (EXECUTIVE PRODUCER)
ANDREW GREEN (EXECUTIVE PRODUCER)
ANDY NANCARROW AND LILIAN KASS (EXECUTIVE PRODUCER)
ASEER KHALID (EXECUTIVE PRODUCER)
BÅRD FJUKSTAD (EXECUTIVE PRODUCER)
BLUNDERBUSS JONES (EXECUTIVE PRODUCER
BRIAN THOMPSON (EXECUTIVE PRODUCER)
BRUCE BOHANNAN (EXECUTIVE PRODUCER)
CHARLES HALL (EXECUTIVE PRODUCER)
CHRIS HOPKINS (EXECUTIVE PRODUCER)
CHRISTOPHER BARTH (EXECUTIVE PRODUCER)
COLIN HENNESSY AND CAMBSEV (EXECUTIVE PRODUCER)
CRAIG ROGERS (EXECUTIVE PRODUCER)
DAMIEN DAVIS (EXECUTIVE PRODUCER)
DAVID FINCH (EXECUTIVE PRODUCER)
DAVID MOORE (EXECUTIVE PRODUCER)
DAVID PARTINGTON (EXECUTIVE PRODUCER)
DAVID PRESCOTT (EXECUTIVE PRODUCER)
DON MCALLISTER / SCREENCASTSONLINE.COM (EXECUTIVE PRODUCER)
ED CORTREEN (EXECUTIVE PRODUCER)
ERIC HANSEN (EXECUTIVE PRODUCER)
ERU KYEYUNE-NYOMBI (EXECUTIVE PRODUCER)
FREDRIK ROVIK (EXECUTIVE PRODUCER)
GENE RUBIN (EXECUTIVE PRODUCER)
HEDLEY WRIGHT (EXECUTIVE PRODUCER)
HEINRICH LIESNER (EXECUTIVE PRODUCER)
IAN GRIFFITHS (EXECUTIVE PRODUCER)
IAN (WATTIE) WATKINS (EXECUTIVE PRODUCER)
JACK OAKLEY (EXECUTIVE PRODUCER)
JAMES STORR (EXECUTIVE PRODUCER)
JAVIER CARMELO DÍAZ PÉREZ (EXECUTIVE PRODUCER)
JIM MORRIS (EXECUTIVE PRODUCER)
JOHN SCHROEDER (EXECUTIVE PRODUCER)
JON AKA BEARDY MCBEARDFACE FROM KENT EVS (EXECUTIVE PRODUCER)
JON MANCHAK (EXECUTIVE PRODUCER)
JUAN GONZALEZ (EXECUTIVE PRODUCER)
KEVIN MEYERSON (EXECUTIVE PRODUCER)
LAURENCE D ALLEN (EXECUTIVE PRODUCER)
LEE BROWN (EXECUTIVE PRODUCER)
LUKE CULLEY (EXECUTIVE PRODUCER)
MARCEL WARD (EXECUTIVE PRODUCER)
MARTY YOUNG (EXECUTIVE PRODUCER)
MIA OPPELSTRUP (PARTNER)
MIKE WINTER (EXECUTIVE PRODUCER)
NATHAN GORE-BROWN (EXECUTIVE PRODUCER)
NATHANIEL FREEDMAN (EXECUTIVE PRODUCER)
NEIL E ROBERTS FROM SUSSEX EVS (EXECUTIVE PRODUCER)
OHAD ASTON (EXECUTIVE PRODUCER)
PAUL STEPHENSON (EXECUTIVE PRODUCER)
PETE GLASS (EXECUTIVE PRODUCER)
PETE GORTON (EXECUTIVE PRODUCER)
PETER & DEE ROBERTS FROM OXON EVS (EXECUTIVE PRODUCER)
PHIL MOUCHET (EXECUTIVE PRODUCER)
PHILIP TRAUTMAN (EXECUTIVE PRODUCER)
RAYMOND ROWLEDGE (EXECUTIVE PRODUCER)
RENE KEEMIK (EXECUTIVE PRODUCER)
RENÉ SCHNEIDER (EXECUTIVE PRODUCER)
ROB HERMANS (EXECUTIVE PRODUCER)
ROB FROM THE RSTHINKS EV CHANNEL ON YOUTUBE (EXECUTIVE PRODUCER)
ROBERT GRACE (EXECUTIVE PRODUCER)
RUPERT MITCHELL (EXECUTIVE PRODUCER)
SEIKI PAYNE (EXECUTIVE PRODUCER)
STEPHEN PENN (EXECUTIVE PRODUCER)
STEVE JOHN (EXECUTIVE PRODUCER)
THOMAS J. THIAS (EXECUTIVE PRODUCER)
TODD OAKES (EXECUTIVE PRODUCER)
THE PLUGSEEKER – EV YOUTUBE CHANNEL (EXECUTIVE PRODUCER)
EVne.ws/itu nes
Check out MYEV.com for more details: https://www.myev.com


The infamous Istanbul Convention on Violence against Women was ratified by our spineless government on March 8 2019, International Women's Day, in an act of craven surrender to the radical feminist lobby. Since it came out in 2011 this appalling document has never been discussed in press, radio or TV. Not once. Men's Voices has campaigned against it ceaselessly. We phoned journalists, reporters, spoke to members of the Oireachtas Justice Committee and asked to make a presentation to them, all to no avail. We wrote articles and sent them to newspapers, to Opinion editors of all the main dailies; they weren't interested, they didn't even respond.
So much for the press and media claim to be the cornerstone of democracy, the watchdog of a free society.
This was the most disgraceful betrayal in a lifetime and demonstrates beyond doubt that our media is a timid, pathetic, pitiful, poodle totally under the thumb of the radical feminist lobby and their male feminist counterparts in the Irish Times, Irish Independent, Irish Examiner and RTE. Newstalk and Today FM are no better, they hardly broached this issue either.
We have written about the Convention at great length elsewhere on the website. It is entirely worthy of a totalitarian Stalinist state which explains why the cowardly despicable media and political parties did not dare debate it in public at any time in the past 5 years.
"The purposes of the Istanbul Convention are noble". It did not however deign to enlighten the public on these noble purposes at any time in the preceding years.
Any person who finds this noble is beyond redemption and is merely a mouthpiece for a vile ideology.
The Irish Times had no editorial on the subject, possibly because there would have been a torrent of comments underneath if it did. The Irish Independent allows no comments.
The Ministers responsible for this outrage: Frances Fitzgerald who initiated the process and put it before Cabinet where it was signed in Nov 2016 and Charley Flanagan the Minister who ratified it. We don't forget either the Taoiseach responsible Leo Varadkar. By this action men and boys are now relegated to third class status as citizens of this benighted state.
We pledge these things will not be forgotten.
There is a more expansive account of the hearings elsewhere on the website.
On the rights of fathers, Keith Walsh told the committee that from a practical viewpoint but without empirical evidence, it appears that fathers who wish to have extensive access with their children face an uphill battle in the Irish courts.
MVI was contacted by Drivetime on Feb 20 and asked to contact men we knew who would be willing to go on radio and talk about their experiences. This was not an easy matter. Many men will not go on radio and be identified fearing that it could interfere with their precarious access arrangements. This is the fear that no one will talk about.


text:
Home Life in SG Life in SG - Lifestyle Tee it up on Thursdays
Tee it up on Thursdays
Anyone is welcome to join in and play a few rounds, Louise Ferreira says.
ANZA Ladies Golf Christmas Day
If you play golf and want to enjoy a friendly 18 holes with keen golfers, then look no further! ANZA Ladies Golf group was formed in 1999 by three keen golfers, and since has grown strong with 24 members – and usually around 12 players each week.
Our group includes ladies from countries other than Australia and New Zealand. Members also hail from England, Ireland, Switzerland, USA, Slovakia, Hungary, Philippines, Holland and South Africa.
You only need to be a paid up member of ANZA and to have, or have had, a handicap to join us. The current members have a range of handicaps from single figures to 38.
We play 18 holes every Thursday morning at various courses in Singapore such as Orchid Country Club, Sembawang CC, Raffles CC, Jurong CC and Warren CC. We occasionally play at Tanah Merah Country Club and Sentosa CC.
A couple of times a year we venture further to play over the border in Malaysia at either Horizon Hills or Palm Resort. We also play beautiful Ria Bintan on Bintan Island. If you are concerned about the heat, be assured that all games are played with golf carts – which are compulsory – and we also recommend consuming about 2-3 litres of water per round! The average cost of a game including cart hire is around $130 SGD.
We try to keep the format relaxed and fun, typically playing Stableford with a twist – like 'Better Nine', Hidden Holes or a team game. We play in the morning, followed by lunch at the club where the winners for the day are announced and all important prizes handed out – usually a golf ball!
We currently don't have a beginners group, but are happy to provide advice on how to go about learning golf in Singapore. We can also advise how to get a local handicap with the Singapore Golf Association (SGA).
On days like Australia Day and Waitangi Day, we dress in the respective countries colours and make a competition out of it. Nothing like a bit of Aussie and Kiwi sporting rivalry to create some good-natured banter and competitive spirit.
Our two coordinators, Hazel Tebbutt and Paula Chepelsky, do a fantastic job of organising our games every week, and we all thank them for their efforts liaising with the clubs and with all the comings and goings of the group – Hazel is leaving us soon to return to England and her warm and friendly nature and keen golfing spirit will be missed. Tanya Richardson is stepping in to assist Paula.
Paula had a recent moment of glory by achieving a hole-in-one in December at Orchid Country Club. The second hole on the Vanda course is a 126-metre Par 3 and Paula hit a fantastic tee shot, perfectly directed towards the hole.
The ball bounced a couple of times on the green and went straight in, causing much excitement and hugging amongst the four ladies on the tee box.
Incredibly, Paula has played golf since she was a child and plays off a single-figure handicap, but has never had a hole-in-one, so this was a very special day for her. Hopefully the flood gates have opened now.
If anyone is interested in more information on ANZA Ladies Golf, please email Paula or Tanya at ladiesgolf@anza.org.sg.
Previous articleWhy I Travel
Next articleNo calm at the Commonwealth Cup
Barista Academy
Serene Sentosa
Turquoise Treasure


text:
Shameful and embarrassing
Published by Brian Burch at October 7, 2019
This is really embarrassing.
Late Saturday, the New York Times ran a breathless bombshell story alleging that a new allegation had surfaced against Justice Brett Kavanaugh from his days as a Yale undergraduate. The insinuation is that Kavanaugh lied under oath during his confirmation hearing.
By Sunday afternoon, Cory Booker called for hearings against Justice Kavanaugh. Elizabeth Warren and Kamala Harris went a step further and called for his outright impeachment.
Explosive stuff.
Except the allegation wasn't new.
Nor did the Times report that the alleged "victim" refused to talk about it to investigators — and admitted she has no recollection of the alleged incident! The story was based on hearsay, from her supposed "friends."
In fact, shortly after releasing the story Saturday, the Times was forced to publish a correction, admitting that the alleged victim had no recollection of the incident in question. In short, the Times admitted they had completely left out this exculpatory evidence. This from the so-called "paper of record."
That's not just an oversight. That's an outrage!
You should also know this —
The Senate Judiciary Committee had already investigated this allegation. The Committee found no verifiable evidence to support her claim.
Despite seven attempts by investigators, the alleged victim declined to provide any evidence to support her claim, refused to meet with investigators, and refused to provide even a written statement to the Committee.
According to the New York Times, the alleged victim also told friends she couldn't be sure Kavanaugh was even involved in the incident.
Are you thinking what I am thinking?
It's obvious what's going on. The radical Left is sowing seeds of division in case a new vacancy on the Court opens up, or in case the Supreme Court finally decides to dismantle the judicial travesty of Roe v. Wade.
The Left can't even deny this.
Get this: Debra Katz was the attorney for Christine Blasey Ford (who testified in the explosive hearings against Kavanaugh). Katz recently said her client was motivated to testify because of her support for legal abortion.
Katz said of Kavanaugh: "He will always have an asterisk next to his name. When he takes a scalpel to Roe v. Wade, we will know who he is, we know his character, and we know what motivates him, and that is important; it is important that we know, and that is part of what motivated Christine."
This new round of mudslinging is about one thing: abortion, abortion, abortion.
You know the abortion lobby is notoriously shameless. No principle, rule, process, or institution will be spared in this campaign to protect legal abortion.
But the radical Left is now openly rejecting the results of free elections and the will of the American people — and even the New York Times has been reduced to a partisan tabloid.
The Left called for the impeachment of President Trump over a phony Russian collusion story. Now they've calling for the impeachment of Justice Kavanaugh — with no evidence whatsoever.
I recall what Sen. Lindsey Graham, R-SC, said after Senate Democrats smeared Kavanaugh during last year's feverish confirmation hearings….
"Boy y'all want power. God, I hope you never get it."


6 Loud Air Conditioning Noises and Their Causes. A Florida Tech Explains.
Is your air conditioner making a loud, annoying noise? Want to know if it's serious?
Here are the 6 most common noises an air conditioner makes along with their causes.
The situation: A high-pitched hissing or screaming sound. Occurs at the outside air conditioning unit when the AC first turns on. Usually lasts 10-15 seconds before stopping. The AC unit itself may shut off and turn back on frequently.
Most likely cause: Your compressor. There's probably high pressure building up in your system, causing the compressor to scream.
The situation: When the outdoor unit runs, there's a clanging or banging noise coming from it. The noise doesn't happen with you turn your thermostat to FAN.
Most likely cause: The outdoor unit's fan is hitting something. Could be an obstruction that shouldn't be there (like a stick) or that the fan has come loose from the mount and is wobbling and hitting its protective cage.
Should I keep running my AC? No. Continuing to run your air conditioner could cause even bigger problems. Turn your AC off and get it fixed by a professional air conditioning contractor.
The situation: A gurgling noise while your air conditioner runs. It may be difficult to tell exactly where the noise is coming from.
Most likely causes: The condensate drain line is gurgling, or your AC may have a refrigerant leak.
Should I keep running my AC? It probably won't hurt anything. Make sure your condensate drain line has a proper trap. If you think it's a refrigerant issue, have a professional check it out.
The situation: When your air conditioner turns on, the outside unit makes a very loud screeching noise — like metal on metal. The sound persists until the unit shuts off.
Most likely cause: The fan motor bearings are shot. If this is the case, you'll need to have your fan motor replaced.
Should I keep running my AC? You can continue to run it if you absolutely have to (like in 100-degree heat while you wait for a repairman). But get it fixed ASAP.
The situation: When your AC, heater or fan is on, you notice a squealing noise coming from your inside unit. It may come and go but it's fairly regular.
Most likely cause: The fan belt is misaligned or worn. Some units have a belt that connects the fan and motor. Over time this belt can wear out or become misaligned, leading to a squealing noise. The sound can come and go as different temperatures and humidity levels cause the belt to expand and contract.
Should I keep running my AC? You can continue to run it, but the belt may eventually break and leave you without air. So get it fixed.
The situation: Repeated clicking noises coming from the outside unit that gradually get faster and closer together as your air conditioner turns on.
Should I keep running my AC? Remove the obstruction first. Then continue to run your air conditioner.
The situation: Steady clicking noises when your outside air conditioning unit tries to turn on. The unit doesn't turn on, but continues to click.
Most likely cause: There's an electrical problem that needs to be corrected. It could be a faulty thermostat, a compressor problem or a capacitor.
Should I keep running my AC? N/A since the unit won't start.
Is your AC making a strange noise? Want a professional to take a look?
Advanced Air serves Southwest Florida—including Fort Myers, Naples, Cape Coral, Estero, Bonita Springs, Port Charlotte and more. Give us a call or contact us online for help with your air conditioning noise.


I like using a yoga bag (like the Gaiam Everything Fits or Metro Gym Bag) as my carry-on bag and rolling up my Tempur-pedic pillow where the yoga mat usually goes. Then my second carry-on is my purse. It works pretty well for me.
Here's a great Packing List for Women from Rick Steves. And a Packing List for Men from StyleGirlfriend.com. And another general packing list from ApartmentTherapy.com.
And one more, in case there are children involved–a Travel Kit for Kids from RealSimple.com.
If you're flying and checking your luggage, make sure you have one full set of clothes in your carry-on (including under garments). And whatever you do, travel, experience, and enjoy the journey!


On November 5th, Mr. Juarez's Drawing/Painting I students skyped with Midwest Artist Studios (MAS) artist, Todd Mrozinski. The MAS project aims to connect art education with regional contemporary artists through studio visits, curriculum documentation, and opportunities for educator outreach.
Todd is a full-time artist living and working in Milwaukee, Wisconsin. He is currently the 2015-2016 Pfister Artist in Residence.
Born in Rensselaer, IN in 1974, Todd has loved to paint for as long as he can remember. He acquired his BFA in painting from the Milwaukee Institute of Art and Design in 1997 and in 1996 attended The New York Studio Program. He has been in solo and group exhibitions nationwide and his work is in various public and private collections. By focusing on two main areas, shadows and clothing, he explores the power of a subject's presence through its absence. Meditation and contemplation as well as following inspiration and free flowing expression are essential to his working practice. Todd sees and shares the beauty and illumination of light and personality through drips and skeins and piles of paint. He and his wife, Renee Bebeau, have a studio in The Nut Factory, Riverwest, Wisconsin, where they offer art classes and workshops. He is currently represented by Woodman/Shimko Gallery, Palm Springs, California.
Text highlighted in orange are live links to websites.
The Midwest Artist Studios Project is supported by a grant from the Kohler Foundation, Inc., Wisconsin Art Education Association, and the National Art Education Foundation.


Spiritual direction is as old as the Christian faith. Today, there is an ever-growing demand for this ministry. The Bible has always had a privileged place in the Christian's toolkit. It is a source of wisdom and encouragement, provides material for prayer and reflection, challenges belief and behavior in the struggle to discern God's will, and sets boundaries for orthodoxy in Christian experience.
With this in mind, author Liz Hoare suggests that spiritual direction is not just for individuals but for the flourishing of the Church as a whole. There is evidence of a loosening of the links between Christian orthodoxy and the practice of spiritual direction. It is also often perceived as a private and individualistic pursuit. Hoare asks how the Bible challenges this interpretation of a key but often unacknowledged ministry in the Church, and how it may help the whole Church to own spiritual direction and benefit the wider world.
Learn more about spiritual direction with Navigating the Interior Life: Spiritual Direction and the Journey to God.
Liz Hoare is the tutor in spiritual formation and dean for women at Wycliffe Hall, Oxford. She trained for the ministry at Ridley Hall, Cambridge and was one of the first women to be ordained priest in the Church of England. She writes a weekly column for the Church of England Newspaper.