text:
About Dates Book Now
Home > What's On > Pottervision
Pottervision
A ridiculous recreation of Harry Potter and The Philosopher's Stone full of DIY props, charity shop costumes and wizarding wigs.
The McCarthy
2h (including interval)
Four performers are all set to recreate Harry Potter and The Philosopher's Stone but, when two of them drop out on the day (and take all the props and costumes with them), Tom and Lukas must go it alone and make do with the limited resources they have.
With DIY props, charity shop costumes and both performers having to play multiple characters, Pottervision is a wig-changing, wizard-impersonating, audience-immersing Ford Anglia ride through all the ridiculousness of that first magical movie.
What could possibly go wrong? Come and find out! Appropriate for ages 16+, Pottervision is a fantastical spectacular for everyone from the most casual fan to the most avid squib.
"Great comedic timing and an ability to connect with the audience that other companies can only dream of."
Broadway Baby
"Big laughs and a fabulous finale."
Squirrel Comedy
"A fun ride not to be missed."
The National Student
What are your Ts & Cs?
Re-sales & exchanges: We must have the ticket at the Box Office in order to perform a re-sale or exchange. We regret we cannot refund money but four or more days prior to the performance we will exchange it for an alternative performance, within three days of the performance we will attempt to re-sell the ticket on your behalf. Both services are subject to a charge of £1.50 per ticket. Latecomers: Anyone arriving once the performance has begun will not be admitted until a suitable break which, on occasion, may be the interval. Content: Where possible we do indicate if strong language and/or adult content is used. Customers are advised to contact the Box Office with any concerns before booking tickets. Please note: the re-sale of tickets is prohibited.


Pruritus is the medical term for itching. This symptom can be a problem in palliative care settings where treatments for cancer or severe kidney disease are given at the same time. In this updated review, we searched for high quality clinical trials of drugs for preventing or treating itch in palliative care.
In June 2016, we found 50 studies that tested 39 different drugs in 1916 people with itch. An ideal antipruritic (anti-itch) therapy is currently lacking. However, there was enough evidence to point out some possibly useful treatments for particular causes of the itch. These included gabapentin, nalfurafine and cromolyn sodium for itch associated with chronic kidney disease, and rifampicin and flumecinol for itch associated with liver problems. Paroxetine may be useful for palliative care patients whatever the cause of the itching, although evidence was only available from one study. Overall, most of the drugs caused few and mild side effects. Naltrexone showed by far the most side effects. Overall the evidence ranged from very low to moderate quality.
Research in palliative care is challenging and often limited to a restricted period of time at the end of life. More high-quality studies on preventing and treating itch (pruritus) are needed.
Different interventions tended to be effective for CP and UP. However, therapies for patients with malignancies are still lacking. Due to the small sample sizes in most meta-analyses and the heterogeneous methodological quality of the included trials, the results should be interpreted cautiously in terms of generalisability.
This is an update of the original Cochrane review published in 2013 (Issue 6). Pruritus occurs in patients with disparate underlying diseases and is caused by different pathologic mechanisms. In palliative care patients, pruritus is not the most prevalent but is one of the most puzzling symptoms. It can cause considerable discomfort and affects patients' quality of life.
To assess the effects of different pharmacological treatments for preventing or treating pruritus in adult palliative care patients.
For this update, we searched CENTRAL (the Cochrane Library), and MEDLINE (OVID) up to 9 June 2016 and Embase (OVID) up to 7 June 2016. In addition, we searched trial registries and checked the reference lists of all relevant studies, key textbooks, reviews and websites, and we contacted investigators and specialists in pruritus and palliative care regarding unpublished data.
We included randomised controlled trials (RCTs) assessing the effects of different pharmacological treatments, compared with a placebo, no treatment, or an alternative treatment, for preventing or treating pruritus in palliative care patients.
Two review authors independently assessed the identified titles and abstracts, performed data extraction and assessed the risk of bias and methodological quality. We summarised the results descriptively and quantitatively (meta-analyses) according to the different pharmacological interventions and the diseases associated with pruritus. We assessed the evidence using GRADE (Grading of Recommendations Assessment, Development and Evaluation) and created 10 'Summary of findings' tables.
In total, we included 50 studies and 1916 participants in the review. We added 10 studies with 627 participants for this update. Altogether, we included 39 different treatments for pruritus in four different patient groups.
The overall risk of bias profile was heterogeneous and ranged from high to low risk. However, 48 studies (96%) had a high risk of bias due to low sample size (i.e. fewer than 50 participants per treatment arm). Using GRADE criteria, we downgraded our judgement on the quality of evidence to moderate in seven and to low in three comparisons for our primary outcome (pruritus), mainly due to imprecision and risk of bias.
In palliative care participants with pruritus of different nature, the treatment with the drug paroxetine, a selective serotonin reuptake inhibitor, reduced pruritus by 0.78 points (numerical analogue scale from 0 to 10; 95% confidence interval (CI) −1.19 to −0.37; one RCT, N = 48, quality of evidence: moderate) compared to placebo.
For participants suffering from uraemic pruritus (UP), gabapentin was more effective than placebo (visual analogue scale (VAS): 0 to 10), mean difference (MD) −5.91, 95% CI −6.87 to −4.96; two RCTs, N = 118, quality of evidence: moderate). The κ-opioid receptor agonist nalfurafine showed amelioration of UP (VAS 0 to 10, MD −0.95, 95% CI −1.32 to −0.58; three RCTs, N = 422, quality of evidence: moderate) and only few adverse events. Moreover, cromolyn sodium relieved UP participants from pruritus by 2.94 points on the VAS (0 to 10) (95% CI −4.04 to −1.83; two RCTs, N = 100, quality of evidence: moderate) compared to placebo.
In participants with cholestatic pruritus (CP), data favoured rifampin (VAS: 0 to 100, MD −24.64, 95% CI −31.08 to −18.21; two RCTs, N = 42, quality of evidence: low) and flumecinol (RR > 1 favours treatment group; RR 1.89, 95% CI 1.05 to 3.39; two RCTs, N = 69, quality of evidence: low) and showed a low incidence of adverse events in comparison with placebo. The opioid antagonist naltrexone reduced pruritus for participants with CP (VAS: 0 to 10, MD −2.26, 95% CI −3.19 to −1.33; two RCTs, N = 52, quality of evidence: moderate) compared to placebo. However, effects in participants with UP were inconclusive (percentage difference −12.30%, 95% CI −25.82% to 1.22%, one RCT, N = 32). Furthermore, large doses of opioid antagonists (e.g. naltrexone) could be inappropriate in palliative care patients because of the risk of reducing analgesia.
For participants with HIV-associated pruritus, it is uncertain whether drug treatment with hydroxyzine hydrochloride, pentoxifylline, triamcinolone or indomethacin reduces pruritus because the evidence was of very low quality (e.g. small sample size, lack of blinding).


text:
Q: Android application with phonegap I have developed a application using Phonegap. HTML is created using HYPE. Functionality wise the application works well. The problem I am facing is, the application is too slow with animations. I have done enough search on google but it didn't solve my problem. What should I do now to get a smoother animation?
Thanks

A: Is it running to slow on the actual device (which one) or in the emulator?
You can try to do some profiling. If not already done, try to encapsulate the frontend code, so you can test in a desktop Webbrowser. Then you can do some performance tests in i.e. Firebug

redpajama_set_name: RedPajamaStackExchange


text:
Don Baylor breaks leg on first pitch
ANAHEIM, Calif. -- Los Angeles Angels hitting coach Don Baylor broke his right leg while catching Vladimir Guerrero's ceremonial first pitch Monday night.
Baylor will have surgery Tuesday on his right femur.
The injury cast a pall over Opening Day at Angel Stadium. Baylor, who joined the Angels' coaching staff in the offseason, had to be helped off the field after squatting to catch Guerrero's off-target throw.
Baylor was taken to a hospital before the Angels' 10-3 loss to the Seattle Mariners.
"Our thoughts and prayers are with Don right now," Angels manager Mike Scioscia said. "Obviously it's a freak (injury). We'll see how it turns out."
Baylor couldn't stand up after Guerrero's throw, his right leg bending awkwardly beneath him while he was held up by Guerrero, who initially thought Baylor was kidding around. Two team employees helped Baylor to the dugout, leaving the Angels in disbelief on the field.
"It got me sick when I was warming up and hearing what happened in the dugout," said Mike Trout, who hit a two-run homer in the first inning.
Baylor, 64, is a survivor of multiple myeloma, a cancer that attacks bone marrow. He was diagnosed with the cancer in 2003, and he is active in fundraising efforts to combat the disease.
Baylor, the former manager of the Rockies and Cubs, left the Arizona Diamondbacks in the offseason to return to Anaheim, where he played six seasons with the California Angels.
He replaced Jim Eppard as the Angels' hitting coach in October. Los Angeles also hired assistant hitting coach Dave Hansen, who was the Mariners' hitting coach last season.
Baylor and Guerrero are the only American League MVPs in Angels franchise history. Baylor won the award in 1979 during arguably the best season of his 19-year major league career with seven teams.
Guerrero threw the ceremonial first pitch to celebrate his retirement with the Angels on a one-day contract.
Trout Homers In Angels' Loss To M's
Highlight Of The Night: Mike Trout hit a two-run homer in his first at-bat, but the Angels fell to the Mariners 10-3.
sportsespndon baylorvlad guerrerofirst pitchmlblos angeles angelsvladimir guerrero
Man suffered severe burns after explosion at Table Mountain Casino
Foggy Day School Schedules, Fog Tracker from ABC30
Domestic violence suspect arrested after standoff with Fresno police
Man accused of killing 2 in Fresno County booked in LA County jail
Body of Missy Hernandez recovered from aqueduct near Huron
All 3 suspects arrested in connection to Tulare County murder
Man guilty for killing Kerman couple must wait for new trial decision
Will inflation continue to rise? We talked to a local expert
Central CA Food Bank facing shortages with supplies, volunteers
Teen killed, another injured in shooting in Orange Cove
At-home COVID-19 test request website goes live 1 day early
1 killed in crash in Madera, Yosemite Ave closed for investigation

redpajama_set_name: RedPajamaCommonCrawl


Sheri came to the 4 weeks to Fab program already looking pretty FAB in my humble opinion, but as Pam mentioned in yesterday's post, we all have our individual goals and plans, and Sheri had just that; a goal to feel better, look better and set a great example. I would say that Sheri's biggest accomplishment has been her CONFIDENCE! Wow, I loved being with her at the shoot and seeing her glow. So proud of you Sheri!!!!
"I was doing a lot of "talking" about needing to become healthier, then I heard about Rita's four week program through a trusted friend. I decided that a four week program was perfect; it was just the right amount of time to see results yet not an unreasonable overwhelming commitment that I could not achieve due to my busy schedule.
Working with Rita has been a true life changing experience. She has taught me that real, healthy food tastes delicious. Rita is an expert in her field, holds such a positive disposition and is a valued mentor. She not only provided the tools necessary to achieve results but was a rock to coach me through the times when I was feeling that I needed someone to lean on.
 Powerful Pam  Marathon Mamma!


text:
Mega Advance Investments Limited
Talent Yield (Euro) Limited
Talent Yield European Limited
Talent Yield Investments Limited
Credit Opinion: Beijing Enterprises Holdings Limited: Update to credit analysis
Credit Opinion: Beijing Enterprises Holdings Limited: Update following ratings affirmation
Credit Opinion: Beijing Enterprises Holdings Limited: Update Credit Opinion
Credit Opinion: Beijing Enterprises Holdings Limited: Weakened standalone credit after overseas investments, mitigated by high government support and core utilities business
Credit Opinion: Beijing Enterprises Holdings Limited: A3 rating under review for downgrade on announced investment in Verkhnechonskneftegaz
Announcement of Periodic Review:
Moody's announces completion of a periodic review of ratings of Beijing Enterprises Holdings Limited
Hong Kong, July 30, 2019 -- Moody's Investors Service ("Moody's") has completed a periodic review of the ratings of Beijing Enterprises Holdings Limited and other ratings that are associated with the same analytical unit. The review was conducted through a portfolio review in which Moody's reassessed the appropriateness of the ratings in the context of the relevant principal methodology(ies), recent developments, and a comparison of the financial and operating profile to similarly rated peers. The review did not involve a rating committee. Since 1 January 2019, Moody's practice has been to issue a press release following each periodic review to announce its completion.
This publication does not announce a credit rating action and is not an indication of whether or not a credit rating action is likely in the near future. Credit ratings and outlook/review status cannot be changed in a portfolio review and hence are not impacted by this announcement. For any credit ratings referenced in this publication, please see the ratings tab on the issuer/entity page on www.moodys.com for the most updated credit rating action information and rating history.
Key rating considerations are summarized below.
Beijing Enterprises Holdings Limited's (BEHL) Baa1 issuer rating incorporates (1) the company's standalone credit strength; and (2) a four-notch uplift for the support from Beijing municipal government and Government of China (A1, Stable), through BEHL's ultimate parent, Beijing Enterprises Group Company Limited (BE Group), in times of need.
BEHL's standalone credit profile is supported by the company's diversified business portfolio and the stable cash flow from its monopoly or leading positions in the less-cyclical gas and water treatment businesses, which back the group's rapid expansion, given the supportive government policies for the two sectors and rising environmental awareness in China.
BEHL's standalone profile also takes into account its increasing structural complexity and heightened business risks in terms of the medium-term integration risks associated with its overseas acquisitions and investments, in particular its acquisition of EEW Holdings GmbH (EEW) in 2016 and its investment in Verknechonskneftegaz (V-gaz) in 2017.
The support assessment reflects (1) BEHL's dominant role in the local natural gas and water utility sectors that are commercially viable but are linked to the public policy goals of Beijing municipal and central government, and (2) majority ownership by BE Group, which in turn is 100% owned by the Beijing municipal government.
This document summarizes Moody's view as of the publication date and will not be updated until the next periodic review announcement, which will incorporate material changes in credit circumstances (if any) during the intervening period.
The principal methodology used for this review was Investment Holding Companies and Conglomerates published in July 2018. Please see the Rating Methodologies page on www.moodys.com for a copy of this methodology.
This publication does not announce a credit rating action. For any credit ratings referenced in this publication, please see the ratings tab on the issuer/entity page on www.moodys.com for the most updated credit rating action information and rating history.
Boris Kan
VP - Senior Credit Officer
Project & Infrastructure Finance
Moody's Investors Service Hong Kong Ltd.
24/F One Pacific Place
88 Queensway
China (Hong Kong S.A.R.)
JOURNALISTS: 852 3758 1350
Client Service: 852 3551 3077
Terry Fanous
MD-Public Proj & Infstr Fin


"The manifestation of a desire is mostly and inner game" writes Ken Haberman in his book "Intimate Modeling". That is absolutely truth. And Intimate Modeling is an "inner game". It's indeed a "game" and it happens "inside".
It requires imagination. And Ken advices to use toolboxes to support the imagination. You can image that if you want to feel like Napoleon Bonaparte – it will be far easier if you're dressed like him, standing on the fields of Waterloo (Belgium – where he lost his final battle) with dressed players around. Then you can more easily imagine the decision process of a leader like Napoleon.
If you are playing a situation in your life that will soon occur – you can use this toolbox. If you want to ask your girlfriend for marriage on a beautiful location – it helps if you have been there and try to image at the place how you will do it.
Money is the thing I desire now. I feel so lucky to enjoy financial freedom to support numerous ecological projects and live a comfortable life with my family.
What I do not understand is what happened next. The moment I worked on clarifying this desire I received an email from a far relation. He invited me for a business talk. That was yesterday.
I cannot go into details now for obvious reasons (to me). But he proposed me a deal that will bring me serious and growing income in a way that supports numerous ecological projects and with the freedom to spend time (and quality time) with my family. The project starts the next months.
Nevertheless – I will refine my desire to also enjoying financial income very soon.
Let's put it straight. If you are not asking for it – you are probably not going to get what you desire. As I am reading "Intimate Modeling" I am asking more often. I'm also asking for things that are out of my comfort zone.
Just a simple example. A company wants to deliver us wooden panels for a trace. They however charge 140 Euro for the delivery. They're right – it's quite heavy (2 tons). I want to get it delivered free. So I asked a few people – and indeed, someone wants to get the panels for me from the factory.


text:
Solutions Through Incorporation
IRS Picks 10 New Advisory Council Members
IR-2007-207, Dec. 21, 2007
WASHINGTON — The Internal Revenue Service announced the selection of 10 new members of the Internal Revenue Service Advisory Council (IRSAC), which provides an organized public forum for IRS officials and representatives of the public to discuss key tax administration issues.
Members are picked to represent the taxpaying public, tax professionals, small and large businesses, state tax administrations, and the payroll community. IRSAC was established in 1953 and provides the IRS Commissioner and division heads with important feedback, observations and suggestions.
2008 Excise Taxes on Air Transportation
WASHINGTON — Today the Internal Revenue Service announced the 2008 inflation adjustments to the excise taxes on air transportation.
Excise taxes apply to the domestic segments of taxable air transportation and to the use of international air facilities. The Consolidated Appropriations Act, 2008, signed into law on Dec. 26, 2007, extends these excise taxes to air transportation that begins or is paid for no later than Feb. 29, 2008.
Hybrid Cars and Alternative Fuel Vehicles
Vehicles Purchased or Placed in Service
The Energy Policy Act of 2005 replaced the clean-fuel burning deduction with a tax credit. A tax credit is subtracted directly from the total amount of federal tax owed, thus reducing or even eliminating the taxpayer's tax obligation. The tax credit for hybrid vehicles applies to vehicles purchased or placed in service on or after January 1, 2006.
The credit is only available to the original purchaser of a new, qualifying vehicle. If a qualifying vehicle is leased to a consumer, the leasing company may claim the credit.
Hybrid vehicles have drive trains powered by both an internal combustion engine and a rechargeable battery. Many currently available hybrid vehicles may qualify for the tax credit.
These models have been certified for the credit in the following amounts:
† This reflects a decrease in the credit amount as of Oct. 1, 2006, due to the manufacturers meeting quarterly sales of 60,000 qualified hybrid cars — See Quarterly Sales, below.
†† This credit amount does not phase out. The full amount of the altenative fuel vehicle credit would be available for vehicles purchased on or before December 31, 2010.


A new $50 million Cooperative Research Centre (CRC) focusing on Cyber Security was announced on 22 September 2017 by the Hon Craig Laundy MP, Assistant Minister for Industry, Innovation and Science and the Hon Dan Tehan MP, Minister assisting the Prime Minister for Cyber Security. This funding will leverage more than $89 million from the 25 industry, research and government partners over the next seven years.
The University is an important partner in the CyberCRC, with researchers from across six schools and three faculties helping shape the programs and their themes for research and innovation. Key Adelaide University researchers have also been named as co-leaders for four of the CRC themes: Professor M. Ali Babar and Professor Chunhua Shen from Computer Science; Professor Matthew Roughan from Mathematical Sciences; and Professor Melissa de Zwart Dean of Law at the Adelaide Law School.


text:
KAWAI CA48 Digital Piano / REVIEW / Wood keys! / Jan 2020
🎹 Kawai CA48 digital piano / Wooden keys / UPDATED REVIEW / January 2020 - The Kawai piano company is headquartered in Japan and is one of the top designers and producers of high quality acoustic & digital pianos. In fact, that's all they do....just pianos. Unlike Yamaha, Roland, Korg, Casio, and others, they don't build non-piano products such as motorcycles, tennis rackets, home audio, synthesizers, beginner keyboards, watches, guitar products, drums, etc. Kawai only builds pianos and has been doing so for nearly 100 years. Their pianos are well known to and used by Universities, professional pianists, piano teachers, studios, pro musicians, and families all around the world. So when it comes to a brand name along with recognition for high quality and innovation, the Kawai piano company is right there at the top and equal to or better than just about everyone out there. But with that being said, there is no perfect piano and there are distinct differences among the many different digital pianos in different price ranges out there.
This is what I recommend in the review below for digital piano shoppers to focus on when looking for a good, satisfying digital piano playing experience, and I believe the new Kawai CA48 lives up to those demands:
Key Action Realism - The way the keys move, the way they feel, their responsiveness to your finger pressure when you press down and let up on the keys, the material that is used to make the keys such as plastic partial wood, all-wood, are the keys individually weighted and/or balanced so that their weight matches a real acoustic piano, also how quiet they are when they move up & down.
Piano sound - Does it start out with a high quality dynamic stereo sampled recording from a quality grand piano, is the sound "expressive," are there variations of piano sounds including mellow, medium, bright, etc
Pedaling response - Are the pedals well built, quiet when being depressed and released, responsive to subtle changes in pedal position, is the damper sustain-decay natural and lengthy like a real piano, does the sustain pedal trigger half-damper effect
Cabinet - Is the cabinet sturdy and built well, does it have front support legs, does it look attractive with ample space on music rack to support sheet music
Digital function & features - Are the built-in digital features and control panel useful, intuitive to use, and are there external controls such as proprietary apps from the manufacturer
The Kawai CA48 home furniture cabinet digital piano, which comes in simulated satin rosewood finish at $2099 internet discount price and satin black finish for $2199 internet discount price, is unique among its peers in its price range (under $2500) in a very special way. Before I get to that feature in this review, it is good to know that all digital piano companies think their piano is the "best" in a given price range....and why would they want you to believe any differently?! They tell you that their piano has the best key action, best and most realistic piano sound, best pedaling response, best functions and features, and the list goes on. But I have been around long enough to know that this cannot be true because obviously not every piano can have the "best" in a given price range since as a piano shopper you may be looking for certain things in a piano that other pianos may not have, but that does not necessarily make one "better" than another...it is somewhat subjective. However, the one thing that generally is thought to be the most important thing in a piano, especially a digital piano, is key action. That is, how closely do the keys move and behave as compared to a real acoustic piano upright and/or grand piano keys in the way they feel when they move under your fingers? Are those keys easy or hard to press down, do they come back up quickly or slowly, or somewhere in-between? Do the keys wiggle or move laterally side to side a lot or are they tighter and more secure? Do the shorter black keys take a lot of extra pressure to push down, especially compared to the white keys, or are they have better balance and note transition. For a lot of people, key action noise is also an issue because most people don't want noisy keys especially when they are playing at lower volumes or using headphones?
There are so many different reasons to want a digital piano piano. As a long time piano teacher, pro musician, composer, arranger, and consultant, among other things, in my opinion the #1 thing to look for in any piano, especially a digital piano...is, as I mentioned earlier, key action. The piano key action is the one thing you cannot replace or change in the piano you will own. Piano sound and pedaling response definitely take a close 2nd place in things to be concerned about and people do want the best piano sound they can get for their price range. But key action realism and authenticity (movement & response of the keys) is the one big thing a piano shopper should be concerned about. When it comes to the key action in the CA48, it is the one and only digital piano in this $2000 price range that has authentic black & white all-wooden grand piano style keys for all 88-notes along with most ivory feel key-tops on the white keys and a smooth matte finish for the black keys which offers a better, smoother playing experience with your fingers. These keys are not just partially made out of wood or just have wooden sides to the keys like other digital piano brands, but have 100% wooden keys and you can even feel the actual wood as you depress a black key and run your fingers along the sides of the keys when you are playing...it's a very organic experience that I normally only get on real pianos when I am playing them. But having wooden keys is just the beginning of the process. Those keys also need to be designed in a way so that when they are installed, each key is independent of the key next to it so that when it moves it is isolated from all other keys just like in a real piano and each key weight inside the piano allows the key to respond as it would on a fine acoustic grand piano (see pic on left of actual CA48 interior keys& weights). The only real way to do this is to install those keys like they way they are installed in a real acoustic piano with a metal pin coming up from the keybed (the bottom of the keys) so that each key has a hole(s) strategically drilled through it near or at the center of that wooden key and then the key is slipped through the metal pin and secured in place so that it cannot move out of its position and is able to move in a see-saw type manner independent of all other keys. Balance pins are also installed so each key can have good balance from front to back and from white to black keys.This type of piano weighted and graded key action is a much more expensive process to offer in a digital piano and up until now the only company that has offered it in the past is this same company Kawai, but those pianos were priced starting at about $3500 discount price until the CA48 recently came out in this low price range.
With the 2020 CA48 priced at under $2200 and offering a real wooden key with real key construction and installation done at the Kawai factory, Kawai is now the only digital piano company that has this type of key movement under $3500 and there is no other digital piano company that comes close in this way. So that's the biggest selling point of the CA48 in my opinion...key action and how good it feels and responds. The keys move quietly, smoothly, with what I would call a "medium" weight to the keys in terms of static down-weight and up-weight which is the amount of pressure it takes for your fingers to press down the keys from a resting position and then have those keys come up and press back up against your fingers. In fact, the key-weight is so realistic in my opinion that it is much closer to a grand piano than an upright piano in terms of how those piano key actions feel when playing the keys. To add extra authenticity to this new wood key action which Kawai calls "Grand Feel Compact," Kawai also designed in to the key action a function called let-off (aka: escapement) which is a slight hesitation of notch that a person would feel from fingers when they press down any key somewhat slowly on a real grand piano about half-way down. This type of thing can give a player more control over the music and just adds even more authenticity to the playing experience of the CA48...especially if you have played real acoustic grand pianos before as I have. Some digital piano companies like Yamaha claim to have this "let-off" feature in their key actions but the Yamaha version is so subtle and light that it is nearly non-existent as far as feeling it really happen so it might as well not be there at all. However with the Kawai CA48 this grand piano let-off feature can definitely be felt in a natural way and although it is still a simulation, nevertheless it gives a player the impression you are actually playing a real acrostic grand piano, and for me, that's a good thing.
I normally don't talk about key actions in my reviews quite this much but the CA48 key action is surprisingly so good and far outclasses anything else in this price range that I believe the subject is worth exploring in detail. Beyond the wooden keys, key weight, movement, let-off function, and installation process is the fact that this Grand-Feel Compact key action has 3 electronic key sensors under each key. Normally speaking when it comes to key actions that more sensors there are then the better the piano can sense your key movement and key travel and where the key is at any given time while you play. In reality a 3-sensor key action helps with having more precise key repetition when playing at a faster rate with more complex music. The extra sensor (many digital pianos have 2 key sensors) picks up key repetition more precisely so your music will be replicated in a more natural way when it comes to playing the keys. Beyond the 3 sensor action, the CA48 also has counter-weights in the bass keys of the piano. The lower bass keys in a piano tend to be heavier than higher treble keys so Kawai has included specially designed counter-weights to help with the key movement so the key responds more quickly, comes back up more precisely when pressed down, and therefore your music becomes more expressive. Most digital piano companies do not offer counter-weights in their keys so the Kawai company continues to innovate when it comes to their key actions.
Another key action feature worth mentioning in more detail is the simulated synthetic matte finish ebony and ivory key tops that are on the keys. This proprietary material that Kawai uses on their keys not only gives the the keys a more classy appearance and cuts down on the glare that plastic keys can sometimes give off, but this synthetic material feel smooth and organic making you believe that your fingers are touching the "real thing" when they are really not. In decades past, acoustic pianos had real ivory and real ebony on their key-tops for better finger traction, better absorption of sweat from the fingers, and smoother finger movement. However, ivory and ebony are organic materials from elephants and trees. Since harvesting ivory from elephants is illegal and the same is true for ebony which come from specialized trees which can take from 60 years to 200 years for one tree to grow and mature. So because these materials are no longer available to use in piano key actions such as what is in digital pianos, some of the digital piano companies have synthetic versions of these materials and now use it on their keys to give you the impression you are touching the real thing. The Kawai simulated proprietary ebony and ivory material that is used not only feels great but is arguably the best and most authentic of any digital piano manufacturer using these synthetic types of material on their pianos. So when it comes to even these key action details, the Kawai company is doing an outstanding job in my opinion on this new model.
When it comes to key actions in this price range or any price range, it's somewhat of a balancing act for these piano companies to try to create a key action that plays really good but at the same time is quiet when the keys are moving up & down. In a real acoustic piano piano those key actions are generally fairly noisy when moving up and down because there are a lot of mechanical parts moving around and making noise. The reason most people are not bothered by that noise or don't hear the noise is because acoustic pianos are always so loud. There is no volume control on a real acoustic pianos so they are either loud or louder...that's how I describe it because I play them, own them, and have been around them all my life. A big advantage to digital pianos is that there is a master volume control so that you can play at a low softer volume. Also, there is a headphone jack so that you can practice in privacy without anyone hearing you which for some people is a really good thing. When playing more quietly or with headphones in a digital piano, some of these key actions can be a bit noisy when the keys are moving. For most people this will not be an issue because there is always some noise in key actions. But for other people who are more sensitive to noise when the keys are moving, then you will be happy to know that based on all my playing time with the Kawai CA48, I can tell you that this Grand Feel Compact key action is very quiet when the keys are going both down and up, especially as compared to other digital piano brands and models. Sometimes keys can be noisy when pressing them down and other pianos can have noisy keys when the keys are coming back up or even noticeably noisy in both directions. With regard to the CA48, the key movement is quiet although it is not silent. There will always be some ambient noise with something mechanical (like a piano key action) is moving. But in comparison to all other digital pianos I have played under priced $3000, Kawai does an outstanding job in eliminating most key noise while still offering expressive, nicely weighted keys that feel great, look great, and operate well.
With regard to piano sound authenticity, the Kawai CA48 has a 192-note polyphony stereo piano sound chip (which is more than enough of piano processing power even when layering another sound)) which offers 2 distinct piano sampled recordings from 2 completely different Kawai acoustic grand pianos, one being more mellow and the other being more resonate and metallic with a fuller sound. There are also other acoustic piano sounds available on this model totaling 8 piano sounds. I do like the tonal dynamics of the main piano sampled recordings which are improved from older Kawai models with wider tone which really allows for good expression on this model because expression not only includes volume changes as you play the keys softer or harder, but the musical expression includes a change of tone from more mellow to becoming brighter and more "alive" as you press the keys harder and harder. So I do like the fact that the Kawai piano sounds allow for noticeably natural piano dynamics and musical expression so that whether you are a student or accomplish piano player, you will appreciate what you can do with the pianos sounds on the CA48. The 192-note polyphony piano chip means that you'll likely never run out of piano note processing power which is important so that you don't have what people call "note-dropout" which can happen if the piano processor can't handle a large amount of stereo piano notes played simultaneously along using the sustain pedal and even layering an additional instrument sound with the piano sound. The CA48 does quite nicely in this area.
If that weren't enough as far as the piano sound goes, Kawai also has a proprietary iOS app (iPad, iPhone) for their digital pianos called Virtual Technician which allows the user to modify and edit the different piano sounds on the CA48 in a way that customizes the sound for your ears as opposed to what other people may like. For instance, if you wanted to change key velocity touch response, you can do this from the app so that you can make the piano sound respond differently if your particular finger touch is hard, or soft, or in-between. Some people do not have much strength in their fingers or maybe they pound on the keys with their fingers hard and are not subtle enough. By changing the key touch sensitivity in the piano you can make it so the piano comes in more quickly and loudly or comes in less quickly and loudly when striking the keys with your fingers. When you make a change for that function then it changes all 88-keys. going even further with the key touch sensitivity, the Virtual Technician app also offers "individual key volume" change rather than changing touch and volume for all keys at once. For instance, maybe your ears are sensitive to one or two particular notes on the 88 keys that seem to be a little too loud or too soft in volume for your ears, especially as compared to the notes around them. The Virtual Technician app allows the user to instantly and easily change the volume of just one, two, three, etc notes either louder or softer while all the other notes stay the same and that change can be saved as a new preset setting within internal app memory so you can have it that way or use another setting instead. What I am saying is that the CA48 can be customized in a variety of ways including changing pedal resonance, dynamic tone, pedal sustain rate, hammer noise, stretch tuning mode, and so much more for people who like technology, have an iOS device, and who may want to customize the piano sound for their own personal tastes besides what Kawai already has built into this piano. You can even have your customer setting be stored in the piano and come up as a default setting when the piano is powered on. There are no other digital piano brands I know of which offers this kind of control over the piano sounds in an all-wood key key action for this price range.
When it comes to shopping for a new furniture cabinet digital piano, one of the things that people sometimes overlook is the 3 pedals attached to the front bottom of the piano. What I mean by "overlook" is that many people just think pedals are pretty much all the same on various digital pianos. That's like saying the piano key action is the same or the piano sound is pretty much the same among many different digital pianos. Well nothing could be further from the truth when it comes to pedals and what they do and how they feel. The 3 pedals include (from right to left) damper/sustain, sostenuto, and soft. The soft pedal does what its name suggests and that is when you are holding down that pedal, what ever note or notes you are playing will be heard at a softer volume. The soft pedal allows you to reduce volume on notes you are playing to make for more expression and feeling when you are playing a song. It allows you soften a note in that way whenever you want to or when the piece calls for it. That pedal is used more often in classical music than other types of music but for most people playing music at a beginning through intermediate recreational level, I find that the soft pedal is (overall) not used very often. The middle pedal is there to sustain (hold) a specific note or notes at any given time while all the other notes have no sustain and would be heard as staccato (short) notes. This pedal is used almost exclusively for classical music and in reality is seldom used any more by people playing at a recreational level. The right pedal is for sustaining any notes that would be played at any given time. This allows for the piano notes to be held for a short to longer period of time to add beauty and fullness to the sound and allow for resonances and richness of tone to occur and is used in all kinds of music by beginners through professional players. The damper/sustain pedal makes your music sound great and actually can help you sound better than you really are as well!
The CA48 does a great job with all three pedals and I was very impressed with the responsiveness of the pedals, especially sustain-decay time of the piano notes when using the sustain pedal. In other words, the longer it takes for the piano sound to fade out when holding down the pedal while playing a note or notes, the better and more realistic the piano sound will be...like that of a real acoustic piano. The CA48 had long sustain times across the keys in the lower octave range to the upper octave range. Beyond that, the damper/sustain pedal also triggered "damper resonance" which means that in a real piano when you hold the right side damper pedal down then the strings can create more natural resonances giving you a very organic natural reverberation which is especially noticeable in the upper octaves of the keyboard. This is something that naturally occurs in all acoustic pianos, but in digital pianos it either is not there or if it is there is is not very noticeable. In the CA48 I found that the damper resonance effect was quite real and added a lot of ambiance to the music which gives it an added organic element that I noticed right away and was very pleased to hear it. The extra resonance came in when it was supposed to and responded like I would expect on a real acoustic piano. The physical weight and resistance of all 3 pedals was very good and had a natural grand piano pedal feel to it with a firmer amount of weight so that when you pushed down the pedals it did not feel like those light-weight keyboard type pedals or lightweight toy-like pedals I have felt on other digital pianos. Not only that, but the pedals were fairly quiet when pressing down on them or when the pedals were coming back up. Although there is some mechanical noise associated with pedals on a real acoustic upright or grand piano, keeping this noise at a minimum is especially important on a digital piano because when playing a digital piano at a lower volume or with headphones the last thing you (or someone else in the room) wants to hear is noisy pedals making clunking sounds like I have heard on many other digital pianos. So when it comes to the 3 pedals and what they do and how they work, in my opinion Kawai has done an excellent jog with this aspect of the piano.
As far as the other non-acoustic piano instrument sounds go, there are 11 of them including some impressive electric pianos, choirs, organs, strings, synthesizers, harpsichords, etc which you can access off the control panel by pushing the sound-function button and pressing a specific white or black key on the piano. Those sounds are very good and much better than on other brands of digital pianos I have played in this price range. I also like the fact that those sounds not only sound great by themselves, but they also make the acoustic piano tones sound even fuller when you layer any of them together with an acoustic piano sound or even layer 2 non-acoustic piano sounds together. So whether you layer acoustic piano & strings, organ & choir, acoustic piano & vintage electric piano, acoustic piano and synthesizer bells (called Atmosphere), or harpsichord & slow strings, the overall quality of those sound combinations are really great in my opinion having played them all with a variety of combinations. Whatever adds to the musical enjoyment when I play a digital piano is what I look for and this piano really does it good. There is a small LED display screen on the control panel to the left of the keyboard which will display what feature/function you are selecting. However when it comes to these instrument sounds and how they are displayed in the LED screen, there is just a number in it showing sound #1, #2, #3 and so on. You would normally need to memorize what that sound is to know what the number means. For some of the other functions (reverb, transpose, touch, etc) there is an abbreviation of that feature so it's a bit easier to understand what you are selecting, but it's not completely satisfying. Also, with the control panel being on the far left side of the piano, depending on the lighting in your room, that area of the piano and the 6 buttons on that panel can get quite dark and therefore the buttons and the names of those buttons become very difficult to see. When there is light shining directly over that control panel then there is no problem, but that isn't always the case. It would have been much better if Kawai had designed the button titles/names as being displayed with LED lights over them so you could more easily tell one button from the next, or even see those buttons at all. So having a well lit are so the control panel is more easily seen is a good idea unless you won't be using those other buttons very often that control other features of the piano.
There is a solution to finding the sounds you want in the CA48 directly on the piano and doing it more quickly. Kawai gives you two very innovative ways to more easily identify the sound and function you are using as well as to control them more intuitively including layering two sounds together at the same time. One of those sound identification functions is called Vocal Assist. The way this feature works is that when you touch and hold the sound select button and then touch specific keys on the keyboard, there is a voice in the piano that verbally tells you what function or sound you are getting when you press that key. For instance, when you press the 1st white key in the bass section, you are triggering the SK concert grand piano sound. The voice (sounds like a lady with a British accent) says "SK Concert Grand" so you can audibly hear what sound or feature you have selected. If you press the 2nd white key then the voice says "EX Concert Grand." If you press the 3rd C key from the bottom then the voice says "Room Reverb," and if you press the 3rd D key the voice says ""Lounge Reverb," and so on. Beyond the voice assist, the piano also has a feature called Sound Preview which plays a short musical run of notes of the exact sound you have selected b y pressing a key on the keyboard so you hear the sound as well and hear a voice that says what the sound is. You can disable the Vocal Assist control and the Sound Preview "run of notes" control so that there is no sound when you activate a new function or sound by pressing a specific key and the sound select button at the same time. These features are very helpful for the sight impaired person who needs help identifying what function or sound they have selected or want to select.
The CA48 can also use a proprietary app that Kawai created to make instrument sound selection even easier and more fun for a few different digital piano models including this one, and that app is called Sound Museum. The Sound Museum app only works with iOS products such as iPhone or iPad and does not work with Android products...sorry Android users! But this is typical with many other useful apps out there in the digital piano world. The Sound Museum app visually lets you see a list of instrument sounds in your device color touch screen that reside within the CA48 and an intuitive easy-to-use interface that quickly lets you select the sounds you want to hear. The app also allows you to layer any two sounds together and even control the relative volume between those two sounds. Its a very cool app and makes using the CA48 even easier and more fun to use. Although the app does not allow control over some of the other functions in the piano, it does the main things that most people care about which are accessing and changing the instrument sounds as well as layering them together. Also in the app, there is a section where you can save your favorite instrument sounds and layered sounds so that you can instantly access them in the "favorites section." The Sound Museum app is also great for audibly impaired people who cannot hear or don't want to use the CA48 function/key way of selecting a sound(s). So whether you want to select a piano sound, harpsichord sound, synth sound, organ sound or you want to layer any 2 sounds together, with pictures of the instruments and the name of the instruments in front of you in the app, using the CA48 to access these things is really a breeze...as long as you have an iOS device as I mentioned earlier. The Kawai apps do not work with Android devices so that is a downside and Kawai unfortunately does not plan to include Andoid devices for these proprietary apps...but I have seen other digital piano companies do the same things for their apps as well.
When you want to connect your external device (such as an iPad) to the CA48 and you want to use interactive MIDI controllable apps such as Sound Museum or Virtual Technician, the Kawai CA48 has a Bluetooth wireless feature that allows you to connect your device to the CA48 without the need of a cable. This pretty cool because the connectivity is nearly instant and then you can put your iPad (or iPhone) wherever you want to and have control over the piano wirelessly and anywhere in the room you want to. Also there are many 3rd party music/piano educational apps for learning how to play the piano in the comfort of your own home and those apps can also be connected by Bluetooth wireless MIDI because the CA48 has that feature. There are some 3rd party education and instrument sound apps that work for both iOS and Android devices so that's a good thing.There is only one drawback when using apps and that is the audio sound of that app (assuming it has music or some type of audio sounds in it) will not be heard through the piano. So you would need to find another source to send the app audio to such as an external speaker system connected to your device directly to hear audio from your phone, tablet, or computer because otherwise the internal music and sounds in the apps would only come through the device speakers which as generally not meant for good quality sound. Although having direct audio streaming through the piano speakers would have nice, that is something I can live with given what the piano is otherwise capable of doing.
The Kawai CA48 has a number of interesting and useful digital features such as layering/mixing 2 different instrument sounds together which can make the over sound experience more dramatic and musically exciting. It has a four-hand mode where two people can practice the same song at the same time playing the same notes by converting the keyboard electronically to 2 separate 44-note keyboards that act independent of one another. There is a digital metronome which is fully adjustable for tempo and time signature which is great for students and learning to stay "on the beat." There are also functions in this piano that allow you to adjust the overall tonal quality of the sound which include reverb (adding a variety of reverberation to the sound), brilliance which allows for brightening up the sound or reducing brightness so the sound is more mellow, and touch sensitivity control which allows you to change the touch to harder, softer, or medium so that when you play the keys the piano sound will come in more quickly for people who play more lightly (less finger pressure) or harder for people who have a harder touch from their fingers, and the harder setting reduces the initial attack volume so that a person with harder finger pressure won't overpower the key volume.
You can also record songs on the CA48 using the piano control panel and then playback to listen to how you are doing. The recording feature has just one track recording for both hands instead of 2-tracks so that you could record and playback right and left hand independently as you can on other digital pianos. I would have preferred a 2-track recorder/playback system but for many people a 1-track recorder playback feature can be enough. You can also save up to 3 recordings in memory so you can retrieve and playback those recorded songs whenever you choose to do that. If you want to record more songs then you have to erase what was previously in the recorder and then you can record new songs. Also included inside this piano is a library of piano lesson songs based on the Alfred piano curriculum along with a few other more advanced piano lesson songs from other lesson methods, all totaling 5 different books of songs. This is useful and fun when combined with the actual lesson books (not included with piano) from these popular publishers that many piano teachers use. Then you can read the lesson and see the song notation while hearing it play in the CA48. You can slow down or speed up tempo while learning and even separate playback of right and left hand parts. This a a really cool feature and can also help with "ear training" along with keeping it more enjoyable when you are playing along. Hearing these lesson songs from the lesson books also helps give the student a better understanding of how the individual songs should go and the library of built-in songs within the CA48 is very good given the fact that no other digital piano brand near this price range offers a feature like this one.
A few other useful functions in this model would include a transpose feature allowing you to digitally change the key you are in without you having to learn the song in a new key which you may not be able to do based on your musical ability. Transpose is a great feature in allowing the player to modulate the song up or down (churches do that a lot with their music) and it's also very useful if you or someone is singing along with you and you need to get the song into your vocal range so then you use the transpose feature to do that and it works well for that purpose. With regard to using headphones for private practice, the CA48 even has specific digital features to make that experience more realistic such as Spatial Headphone sound which electronically changes the sound position in your headphones which gives you the feeling the sound is coming out in a more natural way. The CA48 also has a function which optimizes your headphones so that the headphones sound more natural depending on the type of headphones you have such as "open," "semi-open,"closed," "in-ear," etc. This feature really does work and adds to the overall stereo headphone listening experience for those people who take advantage of what headphones can do for you when it comes to private practice so no-one else can hear you. Finally, when it comes to useful features, the CA48 has a start-up mode which allows you to save/store some of your custom settings that you've done which you may want to have all the time when you first power up the piano. These start-up settings would include a specific sound, reverb, sound combination, metronome beat, Virtual Technician settings, etc. I tend to use this start-up function if the piano model offers it so I find this a very useful thing to have. The Kawai CA48 offers other useful features like I have just mentioned but this should give you an idea of some of the cool things it's able to do.
It's definitely worth mentioning that for a number of years, on certain digital piano models, Kawai has included a special proprietary fun educational learning system for beginner students and for people who may play the piano but just want to have some added musical enjoyment. This unique system is called Concert Magic it is designed to let you play along with familiar songs that are built into the CA48, but in a way that allows for extensive rhythm and timing training while not having to play the "correct notes" for the songs to sound good. In the basic learning mode of the Concert Magic system, the student, even at very young ages, can play any key and get the correct left hand chord and right hand note of the chosen song...all by pressing one note at a time. The point is to press the key(s) in a steady constant beat beat without having to worry about playing the right note or even at the right time. When you can play any note on the keyboard in a constant fashion and have the song sound correct and be recognizable (hearing both left and right hand notes come out in the one key you are pressing, then that encourages you to want to play more because it sounds so good! You can also learn to play the key in the correct rhythm time so that it (the beat) comes out correctly and still not have to know the actual notes yet. This takes a bit of getting used to, but once you do its great fun and it makes even 3 year old children sound great and is fun for the entire family to hear. There are 40 different well known songs from different eras and music categories within the Concert Magic Music Library along with different modes of learning including Easy Beat, Melody Play, and Skillful. I have played with this Concert Magic feature a number of times and I always have fun doing it. So whether you are an adult or child beginner or a more advanced piano player like me, I guarantee you'll have great fun using the Concert Magic system and you'll be especially impressed in how interactive you can be with the song library in making you sound great while you learn the fundamentals of rhythm & timing in a way that no other digital piano brand can do. I will say that not everyone will want or need to use this feature, especially if you are purchasing the piano to play in a normal way and you already know how to play. But for many people, especially children, I believe you'll enjoy this Concert Magic feature quite a bit.
We're now getting into the "home stretch" so I will say a few things about the internal speaker system of the CA48. There a 4 speakers in this model with 2 speakers measuring 5.12" each at the bottom of the piano (1 on each side) pointing down and forward, and there are also 2 smaller "tweeter speakers" measuring 2" each pointing forward from inside the piano above the keys one on each side of the piano which allows for better clarity in the higher frequency tones. The amplification system has 40 watts total (2x20w) of stereo power, so for most rooms the CA48 puts out plenty of volume. However, I personally would have preferred more power out of this piano (perhaps 60 watts for the main speakers) and even another couple of amplifiers powering the tweeter speakers independently of the main speakers. But most digital pianos in this price range only have 2 speakers and 2 amplifiers built in with no more than 40 watts so the CA48 speaker system is an improvement over the others with the 2 additional speakers. I love a piano with a huge sound and even though the CA48 volume and tone will be fine for most applications, their are other digital pianos with more power and more amplifiers, but many are in a higher price range such as the next model up CA58 ($2999 price). Also, the CA48 does not have separate audio outputs so you cannot connect this model to an external audio system. So this piano needs to be free-standing in that way which if it's going in a home is just fine. If you are looking to get this model for your church, school, or another venue that is looking for bigger sound and volume, then you may need to consider another piano with more built-in power or built-in audio outputs.
With regard to external and/or internal connectivity, the CA48 has 2 MIDI ports which supports traditional MIDI plugs and those MIDI ports can also be adapted to an external Bluetooth Audio adapter so that the piano could receive Bluetooth wireless audio through its speaker system. The CA48 does not have audio outputs or inputs but it does have a USB output to host so that you can plug in your computer or device to access programs or apps. However, with the on-board Bluetooth wireless MIDI protocol, you don't need a cable connected to your device and piano to access MIDI responsive apps and programs so this makes it very quick & easy to connect your iPad (as an example) to the piano so that you can instantly use apps such as the Kawai Virtual Technician and Sound Museum as I discussed earlier. This kind of connectivity works well and does the job and there are many digital pianos in this price range and for less money that do not have this feature. Finally, this model has 2 stereo headphones jacks including a mini-jack and a standard 1/4" jack both both types of connections. Having two headphone jacks also allows for two people to play together privately without disturbing other people in or around the immediate area.
When you add it all up for its relatively low price, the CA48 in dark rosewood ($2099 internet discount price) or in the satin (matte) black finish with simulated black wood-grain ($2199 internet discount price) is a real winner in my opinion. Although there are always a few short-comings in most any new digital piano out there in my opinion including the CA48, this impressive model has enough great features and functions to make a digital piano shopper say "yes" I want that one! Measuring in at just 53"x18"x33" and weighing only 125lbs, this model can easily fit into a lot of places. It looks very attractive with a nice cabinet design along with front support legs, a privacy panel below the keyboard, a slide-out key cover, an adjustable music rack with lots of space to put your sheet music or music books, 3 attractive chrome pedals on the black cabinet and brass pedals on the rosewood cabinet, and a comfortable padded matching bench that has music storage inside, in my opinion the new CA48 offers the type of features, functions, cabinet design, and price that most people want who are looking to mainly purchase a digital piano that focuses on the piano playing experience rather than offering all kinds of bells & whistles such as drums, brass, woodwinds, auto-accompaniment, multi-track recording, etc that a lot of people just don't want or need. The CA48 is part of the Concert Artist series of digital pianos for Kawai which is a more prestigious series of digital pianos with that great proprietary longer wood-key key action experience that so many people are looking for in this price range. All the other newer current model Kawai furniture cabinet digital pianos around or under $2000 have the plastic key actions and none of the other digital piano companies have all-wood keys anywhere near this lower price range. Although many plastic key actions can be enjoyable to play and I have played them all, they really don't rise to the level in touch, feel, movement, or response as compared to the wood-key Grand Feel Compact key action in the CA48. Also, I also like the full stereo sampled piano sound coming out of the internal speaker system of this piano and through headphones along with the responsive pedaling that I experienced. I also enjoy using technology to assist me in getting more music out of these digital pianos and I did like the fact that I could quickly and easily get around the CA48 when it came to using the all the instrument sounds and layering through the Sound Museum app on my iPhone.
Given the fact that the Kawai digital pianos are known for their overall reliability and durability over time, this piano still comes with a long factory warranty of 5 year parts & 5 years labor with in-home service. This warranty is a fairly long time in my opinion and covers any factory defect that occurs in the piano, so this 5 years of factory warranty time should give most people peace of mind when it comes to the piano being backed up by a reputable company such as Kawai. Although the CA48 offers some compelling functions and digital features as well as a resonate piano sound, it is really the special proprietary key action that sets this model apart form all the rest. This is not say that a person cannot enjoy playing and owning a Casio AP-650, a Yamaha YDP-184, a Roland HP702, or a Korg G1 Air, as examples, because those pianos can be very enjoyable to play as well and they are all in a similar price range except for the Korg coming in at lower price-point for $1749. I really do like and recommend the Kawai CA48 for all the reasons I talked about here in this review, but at the end of the day it just depends on what your musical goals are, your piano playing experience is, and what type of budget you have. With all that in mind the Kawai CA48 Concert Artist model may just be the perfect piano for you as it is seems to be for so many other people looking to get a home digital piano in a reasonable price range!
Want More Information? Search other posts using these Labels: 2020, CA48, digital piano, Kawai, review
Bob February 10, 2019 at 10:22 AM
How does the key action noise compare to the kawaii kdp110? I have the kdp110 and find the keys to be noisy when you press down and release them, especially when the keys rebound against the top of the keybed
can you please give me an advice.
What should I choose between clp-645 and kawai ca48?
After you review I am not quite sure with kawai because of its 40 watts sound. Comparing to 100 watts of yamaha.
Hi Tim, may I know in your opinion, which is better. Kawai CA48 or the Yamaha Clavinova CLP 635?
D. Costello April 23, 2019 at 6:15 PM
Fantastic reviews! I just devoured 10 of them. Based on your reviews, I've narrowed down my choices to two: the Kawai CA48 and the Korg G1 Air. I will be purchasing one of these for my 2 boys who are taking lessons at a music conservatory. I would prefer an acoustic piano (as would their instructors), but in terms of price and space, a digital piano makes more sense right now. We don't need any bells or whistles, just real key feel and sound. I hate to ask a kind of loaded question like this, but given the choice for 2 budding pianists, which would you suggest? Any thoughts will be greatly appreciated! Thanks much!!
Amit Narula October 5, 2019 at 12:59 PM
I am in the same situation. Can you share which one did you choose and why?


text:
BELTEI International University (BELTEI IU in Cambodia)
BELTEI International University signed MOU with
Guangxi Teacher Education University from P.R of China
On April 28, 2017, an MOU signing ceremony between BELTEI International University and IDP Education (Cambodia) was held at the conference hall of BELTEI International University, Campus 1 (Tuol Sleng), authorize BELTEI IU the IELTS International Test Venue, which is authorized by Australians and British. It was presided over by the Honorable His Excellency, Ly Chheng, Director-General of BELTEI Group and President of BELTEI International University and Mr. SRENG Mao, Acting Country Director of IDP Education (Cambodia) with 22 management teams.
H.E. LY Chheng, Director-General of BELTEI Group stated that BELTEI Group provides three main services: I. BELTEI Construction, II. BELTEI Tour, III. BELTEI Education
BELTEI International University was authorized the International Test Center (TOEFL iBT) from ETS Organization, which is located in the United States. Now we have got the right and legal permission to operate another International Test Center (IELTS Authorized Test Venue), which is authorized by Britain and Australia, and this test is conducted in accordance with British System. Students can do these tests to apply for scholarships to study, to work, and to live abroad, especially in countries which use English because IELTS and TOEFL tests are the symbols of quality and proficiency for English. These International Test Centers are located at BELTEI International University (Tuol Sleng) # 21, St 360, Sangkat Boeung Kengkang III, Khan Chamcarmon, Phnom Penh.
Subsequently Mr. SRENG Mao, Acting Country Director stated that IELTS Test is recognized by more than 6000 institutions around the world and it has more than 800 centers located in more than 130 countries. He also expressed his delight and excitement on the signing of MOU between BELTEI International University and IDP Education (Cambodia) for a long-term cooperation.
Last but not least, His Excellency, Ly Chheng, and Mr. SRENG Mao signed the MOU and exchanged souvenirs with each other.
DAILY NEWS & EVENTS
29/06/2019:MoU with British Council of the United Kingdom on the Opening of the International Test Center 17/06/2019:MoU between BELTEI International University and MAHSA University of Malaysia
14/05/2019:H.E. Dr. LY CHHENG receiving an Honorary Doctor of Education From Shinhan Univer, Korea 12/04/2019:BELTEI Group celebrated an annual party for 2500 staff in the occasion of Khmer Year at Koh
09/04/2019:BELTEI International Collaboration Conference 2019 (BICC 2019) 20/02/2019:Honorary Doctor Degree to Dr. Suh, Gab-Won, the President of Shinhan University and former
26/12/2018:BELTEI Group organized the Annual Assembly to assess its works in 2018 and set forth New direction 01/07/2018:BELTEI International University Organized the 3nd Multi-Cultural Festival
21/06/2018:University organized the 1st (BICC 2018)BELTEI International 16/05/2018:The Official Visit of the Thai Delegation And Student Exchange Program From BK Uni.
12/04/2018:BELTEI Group celebrated an annual party for nearly 2,500 staff on occasion of Khmer Year at Koh 20/03/2018:518 BELTEI staff receive HealthCare Card from NSSF
16/03/2018:Signed a Memorandum of Understanding (MoU) with San Mateo Colleges from USA 26/12/2017:Annual Assembly of BELTEI Group to Assess Its Work in 2017 and Set Forth New 2018
14/11/2017:BELTEI International University Welcoming Miss Global 2017 from 60 countries 21/10/2017:University collaborates with New Life Foundation Organized a seminar on "Leadership..."
20/10/2017:University holds "OPEN HOUSE 2017" To Celebrate the Official Launch of National Program 07/09/2017:BELTEI International University Organized the 4th English Speaking Contest Program
31/08/2017:BELTEI IU hosted the 3rd annual ASEAN Academic Alliance Conference 2017 15/07/2017:Signed a Memorandum of Understanding (MOU) with Universal Peace Federation-Cambodia
01/07/2017:Collabor ates with Cambodia Development Center Organized Public ... 25/06/2017:Organized the 2nd Multi-Cultural Festival
21/06/2017:Signed a (MOU) with University Canada West from Canada 05/05/2017:BELTEI Group buys Insurance Cards for Staffs who have work in BELTEI Group up to 3 years
28/04/2017:BELTEI IU has signed MOU with IDP Education (Cambodia) for IELTS Test 12/04/2017:BELTEI Group celebrated an annual party for all the staff in the occasion of Khmer New Year
01/04/2017:BELTEI collaborates with New Life Foundation Organized a seminar on "Leadership, teamwork and Stewar 27/03/2017:2,670 students participated in the 7th World Camp in Cambodia
09/01/2017:H.E. LY Chheng, welcomed Prof. Dr. Xie Shangguo, the President of Guangxi University from China 27/12/2016:Annual Assembly of BELTEI Group to Assess Its Work in 2016 and Set Forth New Direction for 2017


text:
Science and Astronomy Questions
post any science-astronomy related question here
Cantra
Location: Sedna
Re: Science and Astronomy Questions
What if Pluto was truly the last object out there? Like if it was the only thing out beyond neptune along with it's moons.
Location: Gale Crater
Contact Hornblower
Ok, here's a tough one that I'm dying to know the answer to; What would it be like to have causation without correlation. At first glance it seems impossible, but there could be something.
"Space is big. Really big. You just won't believe how vastly, hugely, mind-bogglingly big it is. I mean, you may think it's a long way down the road to the chemist, but that's just peanuts to space." - Douglas Adams
waterlubber
Contact waterlubber
It already exists, we only know about the correlation because we know the cause.
For example, for a while, nobody knew what tides were caused by. Eventually we learned about gravity and tidal forces, and then the correlation between the Moon and the tides made sense.
For existing stuff, think of gravity (why it happens, we have a poor understanding), why life forms, etc.
I remember the old forum!
waterlubber, I already got the answer, it happens in Quantum Mechanics
Quarior
Location: Local Universe/Laniakea/Virgo SC/Local Group/Via Lactea/Orion–Cygnus Arm/Sol System/Gaia
Contact Quarior
I tried to convert coordinate cartesian (AbsPosition in hexadecimal) polar coordinate without success (I test with Proxima), I do not get the same angles and I understand my fault, I took that equator and I had not the ecliptic and a point vernal but how define it the point and the ecliptic ?
Otherwise, There is not a method, algorithm to convert ? I think yes because Space Engine know where to place the stars correctly, ah less than it does not need conversion. Maybe SpaceEngineer has given an answer.
If the algorithm exists, it would be good to implement it in Space Engine to have the most precision possible to place its system stack at the center of a galaxy for example.
PS : I see Equatorial coordinate system.
Native language : French of France (Français de France)
Old profile : quarior14 (http://en.spaceengine.org/index/8-5147)
My mods page on the forum : http://forum.spaceengine.org/viewtopic.php?f=3&p=196#p196
What if Theia hit Venus instead of Earth?
NikolaAnicic007
Starlight Glimmer wrote:
As far as I know, a similar sized object did strike Venus, but at a steep angle. The impact slowed it's rotation, acting as a brake, effectively "killing" the planet.
Richard Feynman said it best:
"Physics is like sex: Sure, it might give some practical results, but that's not why we do it."
NikolaAnicic007 wrote:
What if it didn't hit and became captured?
That's a bit of a hypothetical scenario, but those are often the most entertaining! Let's see what needs to happen for the Venus impactor to become captured. Assuming the impactor was the same size and mass as Mars and orbited the Sun near the L4 point of Venus, you can deduce the following:
Any approach between the two worlds would result in a collision at high velocities, radical orbit migration or an elliptical binary orbit.
Let's look at what can happen in all three scenarios. Assuming the two worlds collided, depending on the exact angle and speed of impact, the event could end with the two bodies being a) pulverized, leaving only small bodies, b) destroyed, leaving one or two large bodies and a belt of small-to-medium asteroids or dwarf planets, c) coalesced, leaving behind a single, pretty massive body and possibly a large moon with up to 4% of the host planet's mass (this also accounts for when a newly formed moon of varying mass spirals into the planet). This collision would happen at pretty high velocities due to the mass of both worlds and their mutual separation.
If we assume the worlds miss each other completely, an orbital migration is pretty likely from their starting position. Assuming the two bodies come very close to each other, their mutual gravitational attraction would fling them in opposite directions and greatly alter their inclination, ellipticity and semimajor axis.
The least likely scenario is that you'll end up with a system of two distinct tidally locked planets orbiting a central barycenter. This system would be easy to disrupt, and the bodies would most likely be in elliptical orbits with relation to the barycenter. Due to the masses involved, and the proximity to the Sun, this is the least likely option. In the off chance it DID become captured, it would cause large tides and would lock Venus into a short tidal rotational period (since a long period would increase the chance the bodies would separate again due to outside influences). Depending on the exact formation of this system, the two bodies could slowly approach one another until they collide, again resulting in one of the above.
Those are some off-the-bat estimates and I'm not exactly an expert, but that's how I can see it going, at least roughly.
Very good estimations! I am thinking that the object would hit at an angle and allow a moon to form. Capturing a body that large is probably very unlikely.
What is the critical breakup velocity of a white dwarf star? When the centrifical force equals the gravitational force I imagine any Star would fling itself apart. (Ignoring radiation pressure and non-uniformity of luminosity). The fastest known rotational velocity of a star is 2 million km/h, it is named VFTS 102. Here are some screenshots of a binary white dwarf and companion star. The white dwarf orbits the other in under 24hrs. Apparently what I see is a flattened star and not an accretion disk. Usually stars with such high rotation rates are Runaways from a binary system where one went supernova. I don't know how to figure out this Stars rotational velocity. I don't really think this is possible.
Gnargenox wrote:
Well, it depends on the white dwarf you're looking at; the more massive white dwarfs obviously take more energy, but it is completely possible for a white dwarf to break up. What is impossible is for massive neutron stars and pulsars to breakup. Because they're so dense, the surface of the star would have to be traveling at speeds faster than light. I think for a white dwarf, we don't have enough information about them, but it might be up there at speeds of around a tenth the speed of light.
P.S. There's no such thing as centrifugal force
Only in a non-accelerating or inertial reference frame. Plus gravity is not a fundamental interaction mediated by a quantum field theory and a gauge particle, it is an entropic force.
You are standing in a field looking at the stars. Your arms are resting freely at your side, and you see that the distant stars are not moving. Now start spinning. The stars are whirling around you and your arms are pulled away from your body. Why should your arms be pulled away when the stars are whirling? Why should they be dangling freely when the stars don't move?
Because local inertial frames are determined by the large scale distribution of matter. The overall distribution of matter determines the metric tensor, which tells you which frame is rotationally stationary. Frame-dragging and conservation of gravitational angular momentum makes this true.
Oh, and am I actually seeing a flattened White Dwarf in the screen shots? Or is it an accretion disk made from cannibalizing the host star?
The accretion disk is not the white dwarf itself; it's just matter being pulled in by it's gravity. About centrifugal force, you may be getting it mixed up with centripetal force. Basically, in circular motion, you're velocity is constantly changing
Because your velocity constantly curves around a focus, it creates an illusion that that object is being pulled.


Sculptor Danny Salzhandler's 30-foot Colombian Mammoth sculpture in San Juan Capistrano. Photo by Jim Babwe.
Although the self-taught welder had previously used his skills for industrial applications, Salzhandler began welding and constructing steel sculptures soon after arriving on the West Coast. Merging his experience in steel construction with his past experience as a zookeeper at the Houston and Waco zoos, he began creating vivariums: steel sculptures that encase terrariums containing animal and plant life. His company "Biosculptures" was subsequently born.
His first vivariums were not only juried into the Del Mar Fine Art Show, but also won People's Choice and 2nd place awards that year. He soon began receiving numerous commissions and requests to exhibit in galleries and museums, including San Diego's Museum of Natural History. In 2006 Salzhandler was selected by the City of Encinitas to create a Biosculpture as a gift for its sister city of Amakusa, Japan.
Salzhandler's roots extend deeply into the local community. An article in "Ocean Magazine" said of him, "Without (his) high level of energy, organizational skills, (and) willingness to donate many hours of time, the nationally recognized Arts Alive Banner Program, The Full Moon Poets, The La Paloma Poetry Slam, among many other projects in progress, would flat-out not exist." As a longstanding member of Encinitas Rotary Club, Salzhandler has frequently donated sculptures created specifically for their fundraising events.
For his tireless volunteer work, promoting the involvement of art in downtown events, and for his ongoing work with the Arts Alive Banner program, Salzhandler was named Volunteer of the Year by Downtown Encinitas Mainstreet Association. In 2008, he and his wife Norma were presented with an official proclamation of appreciation by the City of Encinitas. Two years later, he was recognized as 2010 Citizen of the Year by the Encinitas Chamber of Commerce.
Most recently, Salzhandler was acknowledged by Alison Burns in her book entitled "Legendary Locals of Encinitas" for helping initiate the Arts Alive program in 2000, as well as for creating a five-ton sculpture of a Columbian Mammoth in San Juan Capistrano. Other examples of his work can be viewed locally, including stainless steel dolphin sculptures located in the garden setting of the Mammoth Professional Building on Saxony Road in Encinitas.
More of his work can be seen by visiting his website at biosculptures.com.


text:
Home » Resources » UNC's "Well-Said" Podcast Features Desiree Murray on Self-Regulation
UNC's "Well-Said" Podcast Features Desiree Murray on Self-Regulation
a discussion about the culminating federal report in a series on self-regulation
Desiree Murray
UNC's "Well Said" Podcast featured FPG's Desiree Murray about the fourth and final report in a series on Self-Regulation and Toxic Stress.This and the first three reports are products of a collaboration with researchers at Duke's Center for Child and Family Policy.
From the introduction: "Self-regulation skills in childhood can be predictors of long-term outcomes from economic success to risks for substance use. In this week's episode, we're talking about why self-regulation is important and how to teach these skills with Desiree Murray, associate director of research at the Frank Porter Graham Child Development Institute..."
Foundations for Understanding Self-Regulation from an Applied Developmental Perspective,
A Review of Ecological, Biological, and Developmental Studies of Self-Regulation and Stress,
A Comprehensive Review of Self-Regulation Interventions From Birth Through Young Adulthood, and
Federal Report Recommends Teaching Self-Regulation in Schools.
You also can hear and/or read WCHL Radio's story and interview with Murray.
Delivering the Incredible Years® Dina Treatment Program in Schools for Early Elementary Students With Self-Regulation Difficulties
Reflections on the Relevance of "Self-Regulation" for Native Communities
Self-Regulation Snap Shots
Implementation of the Incredible Years® Dina Dinosaur Treatment Program in Schools for Early Elementary Students with Self-Regulation Difficulties
Science and Solutions from the Frank Porter Graham Child Development Institute


The beginning of the new year has came with alarms in many areas, from the pure financial sector to the commodity sector, to the geopolitical tangle in Middle East. Among those, there is also a terrible performance of the oil price.
Since mid-2014, price per barrel of oil began to decline from an average price of 105-110 USD, which was almost stable for a long while. After this date, prices had started to decrease continuously. Properly speaking, this phenomenon cannot be called as "collapse" or "shock" since it happens smoothly without jumps and it has been a constant descent.
However, it brought with it a number of dynamics which will shape months ahead. Few weeks ago, a remarkable news was the minimum price reached by oil, which brokes though the threshold of 30 USD per barrel.
Generalizing, it is possible to identify three major causes that lead to the actual economic stalemate.
First, the new slowdown of the economy worldwide, which weakens the world demand, with particularly regard to the Chinese giant and oil-consumers economic troubles (USA and UE as firsts). They would boost the economy again, but in vain. While on the emerging countries side, they are facing the FED's choices about interest rate.
The second cause could be described as shale gas effects on prices, which probably trigged this "barrel war" on prices. Benefiting from huge investments in past years, shale production leads oil exporters to overproduce in order to displace them. For some time, new energy producers gained from their low-price positions, making profits. Now the situation has reversed, with a super cheap oil price that in turn displaces frackers. As heard many times in newspapers, shale gas is convenient only if oil price is higher than 60 USD, otherwise they run into losses. That is the strategy Saudi Arabia is putting in place somehow, a sort of dumping policy to kill competitors through even more low prices.
Last, the geopolitical equilibrium in the Middle East, where Iran is trying to establish its influence over the neighboring States and among western diplomats. Iran is developing those key industrial sectors to reach their autonomy: oil and other energy sectors.
Impacts of these new economic wars of oil and gas lead to many losers (Venezuela, Niger, Kazakhstan, American frackers, etc.) and some winners (Saudi Arabia, UAE, Kuwait, Iran). Of course, consumers benefit from this. But on closer inspection, there are not so many winners. Even in these countries they were drafted budgets with estimates oil prices around 20 USD. For instance, Saudi Arabia has recently introduced austerity measures, despite reserve funds of about 700 billions for this purpose. In Russia instead, a similar scenario took place. Here, in face of a fall in prices, ruble offset the change: devaluation occurs reducing costs and inflates profits of exporters, who received a foreign currency exchange. While other less wealthy countries will suffer heavily from this low price.
Looking at this unsustainable and damaging moment, many actors are eager to an agreement to avoid future distresses.
The last sessions show a weak rise in oil price: the Brent returned around 32 USD, driven by the expectation of an imminent emergency summit of OPEC to coordinate a cut in production worldwide. Nevertheless, the OPEC governor is skeptical and foresees a critical issues at least until 2020. The World Bank has revised its forecasts with a negative outlook, with a long period of recovery in prices: 37USD in 2016, 48USD in 2017, 51USD in 2018. Similar estimates have been developed by other banks.


Today's news brings the announcement that an Endsleigh/NUS survey has found that the number of university students working to help fund their studies has risen sharply. About 77% of students now work, up from 59% last year, and 14% of those work full-time during term time. 56% say they work in order to fund their time at university - not just tuition fees, but living expenses as well.
I presume this report is focusing on the 'traditional' constituency of full-time, residential, 18 to 21 year old undergraduate students and not the part-time, adult and often more mature learners whom the flexible learning agenda usually caters for. It is interesting for just that reason. That 'non traditional' group is frequently overlooked. This survey (or the reports of it) didn't see fit to even make that precision clear.
It is equally interesting that even now the 'traditional' student population still doesn't seem to be clamouring for greater flexibility of provision to enable them to combine work and study with relative ease. I wonder why. Is it really that easy to fit work and study around each other? Is this because employers are willing to be flexible? My experience is generally that higher education providers are not willing, or see themselves as unable to provide tuition in a flexible way, which offers learners choices in how, what, when and/or where they learn. That suggests that employers do this much better. Shift work in many parts of the service industry is likely to be the principal source of employment. Yet the report states that 'a large majority (87%) said developing additional skills and enhancing their CV were also important reasons for working whilst studying'. Is bar tending, waitressing or working at McDonalds likely to do that? Or are they finding jobs that have greater potential to fulfil that ambition? If so, what does the flexible working that employers must put into place look like, and what adjustments are they making that HEPs could usefully learn from?
Anecdotally, it seems that the idea of flexible learning isn't yet appealing to 'traditional' students. A number have told me that they prioritise their time at university above all else, not least because they regard it as a rite of passage between school and employment, the final transition between childhood and adulthood, and a protected time and space where they can do that growing and preparing. It is not something they are willing to relinquish; they regard it as a right.
That may well be true. Yet if increasing numbers are working full-time (however that is interpreted) to fund their time at university, then it may well be that at least some are finding jobs with flexible employers where what they are doing in the workplace will have a relevance to their future careers.
The next piece of research needs to investigate what sorts of jobs traditional university students are doing, what proportion of these are likely to be relevant to their future careers, and how employers are adjusting working patterns to accommodate this.


text:
Q: Using ibid. with the biblatex Bath Harvard style I am new to Latex and am using the biblatex Bath Harvard referencing style.
It's a really nice style and does pretty much everything I want except one thing: I'd like to replace duplicated references with ibid.
Is there an easy way for me to do this, as a relative beginner, or am I better off switching to an alternative style, such as authoryear-ibid?

A: biblatex-bath's citation style is based on authoryear-comp and only adds about 15 lines of modifications (see biblatex-bath.dtx, ll. 4196-4251). This means that we can just load authoryear-icomp (the 'ibid' version of authoryear-comp) as citation style and add the modifications from bath.cbx directly to the preamble of your document.
\documentclass[british]{article}
\usepackage[T1]{fontenc}
\usepackage[utf8]{inputenc}
\usepackage{babel}
\usepackage{csquotes}

\usepackage[style=bath, citestyle=authoryear-icomp, backend=biber]{biblatex}

\ExecuteBibliographyOptions{uniquename=init}
\renewcommand*{\compcitedelim}{\addsemicolon\space}
\xpatchbibmacro{cite:labeldate+extradate}{%
  \iffieldundef{labelyear}%
}{%
  \ifboolexpr{
    togl {bbx:nonodate}
    and
    not test {\iflabeldateisdate}}%
}{}{\wlog{WARNING: biblatex-bath failed to patch cite:labeldate+extradate}}
\providetoggle{bbx:labelistitle}
\xpatchbibmacro{cite:label}{%
  \printtext[bibhyperref]{\printfield[citetitle]{labeltitle}}%
}{%
  \printtext[bibhyperref]{\printfield[citetitle]{labeltitle}}%
  \toggletrue{bbx:labelistitle}%
}{}{\wlog{WARNING: biblatex-bath failed to patch cite:label}}

\addbibresource{biblatex-examples.bib}

\begin{document}
Lorem \autocite{sigfridsson}
ipsum \autocite{sigfridsson}
dolor \autocite{worman}
sit \autocite{sigfridsson}
\printbibliography
\end{document}

If you plan to modify the style even further you may be better off using one of the standard styles after all.


Hamilton Mayor Kelly A. Yaede challenges photographers to showcase the township's parks, recreation facilities and events in this year's calendar photo contest.
The theme of the Hamilton's 2014 calendar is "Hamilton Township families enjoying our hometowns." Selected pictures are set to be used in the calendar, which is sent to households in the community.
A committee of township officials are set to will select the final photographs for inclusion based upon the theme. Photo credits will be included in the calendar.
Residents can submit photos reflecting the theme. Suggested subjects are township parks, public areas and community events like Septemberfest, Fall Harvest, Winter Wonderland and parades.
As in past years, participating residents are asked to submit photographs with a signed disclaimer form, giving full permission for the photograph to be used for the calendar. Also, photographs of any person or private object must have the permission of the photographed person or the work's rightful owner for use in the calendar Permission forms are online.
Submissions must be sent via email attachment to ddegregory@hamiltonnj.com no later than Oct. 4. Attached photos should be at least 300 DPI or minimum dimensions of 3000 x 2400 pixels.


text:
Q: SQL insert value in friendship table based on I'm taking a database course and I've got stuck on one of the questions. "For all cases where A is friends with B, and B is friends with C, add a new friendship for the pair A and C".
This is as far as I've got
INSERT INTO
    friend
SELECT DISTINCT
    f1.ID1, f2.ID1
FROM
    friend f1
    JOIN friend f2 using (ID2),
    friend
WHERE
    f1.ID1 <> f2.ID1
AND friend.ID1 <> f1.ID1
AND friend.ID2 <> f1.ID2

The schema is here http://www.sqlfiddle.com/#!5/cf8b5/23
I wonder if somebody could give me a few hints on how to proceed.
Thanks.

A: I think you have the basic concepts.
I'd do it like the following:
INSERT INTO friend
(ID1, ID2)
SELECT DISTINCT f1.ID1, f2.ID2
FROM friend f1
  INNER JOIN f2
    ON f1.ID2 = f2.ID1
      AND f1.ID1 <> f2.ID1
      AND f1.ID2 <> f2.ID2
WHERE f1.ID1 <> f2.ID2

A: I think it may be:
INSERT INTO friend
(ID1, ID2)
SELECT DISTINCT h.ID, f2.ID2
FROM Highschooler h
inner join friend f1 on(h.ID=f1.ID1)
inner join friend f2 on(f1.ID2=f2.ID1)
where h.ID <> f2.ID2
and not exists(select *
               from friend f3
               where f3.ID1=h.ID
               and f3.ID2 = f2.ID2)

A: First of all, I don't see the point of having both FRIEND and LIKES tables.
If friendship is represented by two highschoolers liking each other than one table with two ID columns is sufficient.

A: insert into friend
select f1.id1, f2.id2
from friend f1 join friend f2 on f1.id2 = f2.id1
where f1.id1 <> f2.id2
except
select * from friend