organizations to grow revenue, gain competitive advantage, and increase customer satisfaction.
At Halo, we want you to be able to manage your whole supply chain more efficiently, not just pieces of it. We bring the power of data, innovative technology, and passionate people to help sales, operations, manufacturing and finance managers quickly and easily gain accurate insight across multiple data sources – both inside and outside the organization – that increase revenue and improve customer satisfaction.
Halo's scalable supply chain intelligence and data discovery platform includes easy-to-use pre-packaged self-service solutions with alerts, what-if modeling, dashboards and predictive analytics for faster and more accurate decisions that bring agility to end-to-end supply chain planning.
Keith is a senior executive with 14 years' experience driving the growth of innovative data and analytics businesses including Experian, Nielsen, and Mitchell ClaimsLab. He was previously COO of Claritas and President of Integras, a division of Claritas. He has published multiple academic works in analytics and Big Data, with a focus on supply chain applications. Keith holds a Ph.D. from Vanderbilt University. He is currently President and CEO of Halo and board member of Innovare Holdings.
Brandon is a senior sales and business development executive with over 17 years' experience leading sales groups and developing new business for industry-leading companies such as Fiserv and Epicor. Leading Halo's North American effort for the last 8 years, Brandon has overseen many of Halo's largest and most successful client implementations. Brandon is a certified Microsoft Professional in Business Intelligence, and has been named to Microsoft Dynamics Top 100 most Influential People. He holds a degree in Marketing from California State University, San Diego.
Erin joined Halo in 2013, leading account and finance functions. She later assumed responsibility for talent acquisition, contracts, payroll and compensation functions. Today, Erin manages all general and administrative functions at Halo and spearheads process improvement initiatives. Erin previously worked for Active.com and has a degree from Saint Louis University.
Steve has been with Halo since 2013 and currently oversees the Professional Services and Product Management functions. His main responsibilities are defining and creating products that meet our customers' needs, and ensuring they are properly implemented for our customers. Prior to Halo, he held similar roles at companies such as Qualcomm and Nielsen. Steve holds a degree in Computer Science from Washington University in St. Louis.
Joseph oversees engineering, operations, business systems and enterprise architecture for Halo. Joseph previously worked as Director of Distributed Analytics and defined Halo's technology vision and underlying roadmap to meet the challenges of Halo's customers and partners. Before joining Halo, Joseph was manager of software development at Navman Wireless and Practice Manager at Hyro Idaptive. Joseph holds a degree in Computer Science and Engineering from Monash University in Australia.
Halo Helps is a regionally based program created to assist local community leaders, educators, and organizations that assist underserved areas of San Diego, CA. We partner with nonprofits, non-governmental organizations, and community based organizations. We support organizations and individuals that share our vision with funding, scholarships, expertise, and technology. For information on how to partner with Halo, please submit your inquiry to halohelps@halobi.com.
A collaborative platform for self-service supply chain planning and data discovery helping you accurately measure performance.


text:
Adoption (Örökbefogadás) est un film hongrois réalisé par Márta Mészáros, sorti en 1975.

Synopsis
La rencontre d'une adolescente, Anna, issue d'un foyer pour délinquantes, et de Kata, une ouvrière en menuiserie, qui éprouve le besoin éperdu d'avoir un enfant. Kata finit par s'attacher à la jeune femme et la prend en charge. Anna rencontre bientôt un garçon et pourra, grâce à Kata, l'épouser. De son côté, l'ouvrière réalise son vœu le plus cher : adopter un bébé...

Fiche technique
 Titre : Adoption
 Titre original : Örökbefogadás
 Réalisation : Márta Mészáros
 Scénario : Ferenc Grunwalsky, Márta Mészáros et Gyula Hernádi
 Musique : György Kovács
 Photographie : Lajos Koltai et Márta Mészáros
 Montage : Éva Kármentõ
 Pays d'origine : Hongrie
 Format : Noir et blanc - Mono
 Genre : Drame
 Durée : 83 minutes
 Date de sortie : 1975

Distribution
 Katalin Berek : Csontosné, Kata
 Gyöngyvér Vigh : Bálint Anna
 Péter Fried : Sanyi
 László Szabó : Jóska

Distinctions
 Ours d'or à la Berlinale 1975.

Commentaires
Selon Jean-Pierre Jeancolas, Adoption  (in : Le cinéma hongrois 1963-1988, Éditions du CNRS) Brossant un portrait des deux protagonistes féminins, le critique ajoute :

Voir aussi

Lien interne
 Liste des longs métrages hongrois proposés à l'Oscar du meilleur film en langue étrangère

Liens externes

Film hongrois sorti en 1975
Film dramatique hongrois
Film réalisé par Márta Mészáros
Film hongrois en noir et blanc
Ours d'or
Film en hongrois
Film sur l'adoption

redpajama_set_name: RedPajamaWikipedia


text:
Leona F. Smith;
Of New Britain
Leona F. Smith of Erwin Home, New Britain, died Tuesday at Highview Healthcare Center in Middletown. She was 93.
She was born in Wallkill, N.Y., and lived in New Britain since 1923. She had been employed at the former North & Judd Manufacturing Co. for many years and was a member of Trinity United Methodist Church and the Women's Society of the church. She was also a member of Order of Amaranth, White Shrine of Jerusalem, Emma Hart Willard Chapter--DAR, and the New Britain Salvation Army Auxiliary.
She is survived by a son, Robert F. Smith of Stewart, Fla.; three grandchildren; two great-grandsons; and several nieces and nephews.
A memorial service will be Friday at 11 a.m. at Carlson Funeral Home, 45 Franklin Square, New Britain. Burial will be private in Bruynswick Rural Cemetery, Wallkill, N.Y. There are no calling hours.
Donations may be made to Trinity United Methodist Church, 169 Main St., New Britain, CT 06051.
John Schaffer Jr.;
Of Southington
John Winter Schaffer Jr. of Lyndonville, Vt. and Andrews Street, Southington, died Monday in Lyndonville, Vt. He was 24.
He was born in New Britain and was a lifelong Southington resident. He was a 1997 graduate of Southington High School where he participated in lacrosse and football. He had been a member of the National Ski Patrol since the age of 14 at Mount Southington. He completed four years at Lyndon State College and was serving his internship in ski area management at Burke Mountain, Vt.
He is survived by his parents, John Winter Schaffer Sr. and Mari Bitel Schaffer; a brother, Matt Schaffer of Southington; and his maternal grandparents, Helyne and Walter Bitel of Kensington.
The funeral will be Saturday at 9:15 a.m. from the DellaVecchia Funeral Home, 211 N. Main St., Southington, to St. Dominic Church for a Mass at 10 a.m. Burial will be in Oak Hill Cemetery. Calling hours are Friday from 5 to 8 p.m. at the funeral home.
Donations may be made to Eastern Division Memorial Fund, c/o Mt. Southington Ski Patrol, P.O. Box 347, Southington, CT 06489.
Clifford Plocharsky,
82; Of Bristol
Clifford W. Plocharsky of Bristol died Tuesday at Nursing Care Center of Bristol. He was 82.
He was born in Bristol and was a lifelong Bristol resident. He was employed at Wallace Barnes for 35 years before retiring.
He is survived by his wife, Margaret Longo Plocharsky; three sons, David Plocharsky of Bristol, Peter Plocharsky of Burlington and James Plocharsky of Orlando, Fla.; a daughter, Sandra Plocharsky of Bristol; six grandchildren; and several nieces and nephews.
The funeral and burial will be private. Calling hours are Friday from 6 to 8 p.m. at Funk Funeral Home, 35 Bellevue Ave., Bristol.
Donations may be made to the Bristol Soccer Club, 441 Emmett St., Bristol, CT 06010.

redpajama_set_name: RedPajamaCommonCrawl


text:
Capital Gains: Bigcommerce Gets Bigger, Kik Messenger's New Round and More
Big commerce gets $50 million, Kik gets $38 million and more funding news.
By Noah Kulwin Nov 23, 2014, 12:00pm EST
Share All sharing options for: Capital Gains: Bigcommerce Gets Bigger, Kik Messenger's New Round and More
Vjeran Pavic
Here's a roundup of the funding news from this week:
Bigcommerce, a software service that helps small businesses set up online shops, announced a $50 million investment round led by SoftBank Capital, with additional funding from American Express Ventures, Telstra Ventures, Revolution Growth and General Catalyst. To date, Bigcommerce has raised $125 million in total.
The makers of the messaging app Kik raised $38 million in a new round, bringing the company's total funding since 2009 to $70 million. Kik also acquired the GIF-focused messaging service Relay.
Custom T-shirt startup Teespring closed a $35 million funding round led by Khosla Ventures, amid a number of legal disputes involving trademark violations. Khosla Ventures' Keith Rabois will be joining the Teespring board.
The ride-sharing startup Getaround closed a $24 million Series B funding round, led by AutoTrader owner Cox Enterprises, with participation from Menlo Ventures, Triangle Peak Partners and SOS Ventures.
Accompani, a professional network manager co-founded by former Google execs, said in a press release that it had raised $15 million in a Series B funding round. Investors in this round included Iconiq Capital, Charles River Ventures and Cowboy Ventures.
The video ad technology startup Eyeview said it landed a $15 million investment from Marker LLC, which was already an investor in the company.
PlutoTV, which makes a TV guide for Web video, raised $13 million in a Series A funding round led by U.S. Venture Partners, with participation from returning investors Chicago Ventures, Great Oaks Venture Capital, Luminari Capital and the satellite TV operator Sky.
The Finnish gaming startup Seriously said that it raised an additional $5 million from prior investors, giving the company a total of $10 million in funding to date.
Assembly, a startup founded last year that is working on profit-sharing technology for open-source projects, announced a $2.9 million funding deal (The Verge).
The photo-sharing startup Cooliris said on its website that it had been acquired by Yahoo.


A radical new campaign group is being launched today with the aim of reforming Scotland's grouse moors.
A radical new campaign group is being launched today with the aim of reforming Scotland's grouse moors.
Called Revive, the organisation is a coalition of social, environmental and animal welfare charities.
Partners include Common Weal, OneKind, Friends of the Earth Scotland, League Against Cruel Sports and Raptor Persecution UK.
The coalition has backing from naturalist and broadcaster Chris Packham and Scottish Green MSP and land reform campaigner Andy Wightman.
To coincide with the launch, the organisation is unveiling a new report that puts the case for changing the way grouse-shooting estates are run, to benefit communities, wildlife and the environment.
Revive's senior campaigner Max Wiszniewski said: "We are under no illusion that this will be a short campaign, but we have laid the foundations to take the first steps towards reform and we relish the challenges ahead.
It's estimated around a fifth of Scotland's land is managed to rear grouse for sport.
In order to maximise the number of birds available for commercial shooting, a range of techniques are employed. These includes heather burning, predator control, including culls of mountain hares, use of medicated grit to reduce parasites and construction of roads and tracks.
Revive members believe these measures have negative social, environmental and welfare impacts.
But estates say the new group is setting out to destroy valuable rural livelihoods.
A Scottish Government commission has been set up to examine the environmental impacts of grouse shooting, with conclusions expected in spring next year. The review was set up after an SNH report showed almost a third of golden eagles in a satellite-tracking project had disappeared in "suspicious" circumstances.


Livefyre is a San Francisco-based technology company that provides embeddable social media widgets that websites can use for actions including commenting, live blogging, live chatting and user reviews.
Want to download the full LiveFyre list? Use the search to the left!


text:
package lx.af.test;

import android.content.pm.ApplicationInfo;
import android.content.pm.PackageInfo;
import android.content.pm.PackageManager;
import android.content.pm.PermissionInfo;

import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import java.util.Random;

/**
 * author: lx
 * date: 16-3-22
 */
public class TestDataHelper {

    private static ArrayList<String> mNameList;
    private static ArrayList<String> mLongStringList;
    private static ArrayList<String> mAddressList;

    public static String getRandomName() {
        if (mNameList == null) {
            PackageManager pm = Test.sApp.getPackageManager();
            List<ApplicationInfo> appList = pm.getInstalledApplications(PackageManager.GET_META_DATA);
            mNameList = new ArrayList<>(appList.size());
            for (ApplicationInfo ai : appList) {
                mNameList.add(ai.loadLabel(pm).toString());
            }
        }
        if (mNameList == null || mNameList.size() == 0) {
            return "Default Name";
        }
        int idx = random(mNameList.size());
        return mNameList.get(idx);
    }

    public static String getRandomLongString() {
        if (mLongStringList == null) {
            initLongStringList();
        }
        if (mLongStringList == null) {
            return "Laziness is a feature of a programmer.";
        }
        int idx = random(mLongStringList.size());
        return mLongStringList.get(idx);
    }

    public static String getRandomShortString() {
        return getRandomName();
    }

    public static String getRandomAddress() {
        if (mAddressList == null) {
            initAddressList();
        }
        int idx = random(mAddressList.size());
        return mAddressList.get(idx);
    }

    public static long getRandomTime() {
        Calendar time = Calendar.getInstance();
        int day = 1 + random(time.get(Calendar.DAY_OF_MONTH));
        int hour = 1 + random(22);
        int minute = 1 + random(56);
        time.set(Calendar.DAY_OF_MONTH, day);
        time.set(Calendar.HOUR_OF_DAY, hour);
        time.set(Calendar.MINUTE, minute);
        return time.getTimeInMillis();
    }

    public static int random(int n) {
        return (new Random()).nextInt(n);
    }

    private static void initLongStringList() {
        PackageManager pm = Test.sApp.getPackageManager();
        try {
            PackageInfo pi = pm.getPackageInfo(Test.sApp.getPackageName(), 0);
            String pkgName = pi.packageName;
            PackageInfo pkgInfo = pm.getPackageInfo(pkgName, PackageManager.GET_PERMISSIONS);
            String sharedPkgList[] = pkgInfo.requestedPermissions;
            mLongStringList = new ArrayList<>();
            for (String name : sharedPkgList) {
                PermissionInfo perm = pm.getPermissionInfo(name, 0);
                mLongStringList.add(name + ": " + perm.loadDescription(pm).toString());
            }
        } catch (PackageManager.NameNotFoundException e) {
            e.printStackTrace();
        }
    }

    private static void initAddressList() {
        mAddressList = new ArrayList<>();
        mAddressList.add("Jining, home town, China.");
        mAddressList.add("Yantai, university, China.");
        mAddressList.add("Qinhuangdao, university, China.");
        mAddressList.add("Beijing, first job, China.");
        mAddressList.add("Jinan, work place, China.");
        mAddressList.add("Landon, England.");
        mAddressList.add("Paris, French.");
        mAddressList.add("Moscow, Russia.");
        mAddressList.add("Tokyo, Japan.");
        mAddressList.add("Washington, USA.");
        mAddressList.add("Rio, Brazil.");
    }

}

redpajama_set_name: RedPajamaGithub


Average and median rental rates for all property types in Canada have risen for a third consecutive month as demand increases with the arrival of the prime spring leasing season, reports Rentals.ca and Bullpen Research & Consulting.
The average property listed on Rentals.ca in February was offered for rent at $1,888 per month in Canada overall, an increase of 1.8 per cent monthly from $1,854 in January. The median rent was $1,800 per month, up from $1,747 in January.
Ontario continues to hold on to the top spot for average and medium asking rents by province with an average rent at $2,197 per month and a median price at $2,100. Average and median asking rents for Ontario are about $1,000 more than the provinces of Quebec ($1,209 and $1,020), Manitoba ($1,159 and $1,076) and Saskatchewan ($1,168 and $1,150).
Newfoundland remains the only province in the three-figure range for average and median rents at $883 and $840.
Average rental rates continue to climb in Toronto, despite affordability concerns. A number factors have contributed to the increase in rental demand including: Rising resale condo prices, tighter mortgage credit availability, expanded rent control, reduced-unit turnover, and high population growth.
More than 10,000 apartments have been built in the Toronto CMA over the past six months (condo and rental), which has not dampened rent growth yet. The metro area likely needs closer to 30,000 units annually to satisfy demand, and that level of growth isn't likely to happen in 2019.
In Ottawa, nearly 65 per cent of Rentals.ca listings in February were available from $1,000 to $1,999 per month. About 22 per cent of the rental apartment market is comprised of one-bedroom units available from $1,000 to $1,999 per month and 20 per cent of the market is made up of two-bedroom units available in the same rent range.
Landlords are asking $2,430 per month on average for condos in Canada, which are smaller on average than the older rental apartments at 758 square feet. Leasing of condo apartments is much more prevalent in Toronto, which contributes to the high national rental rate for these smaller units.
To rent a one-bedroom condo in Toronto ($2,416), a tenant will need to shell out about $350 more than in North York and Etobicoke on average. For a two-bedroom unit, a tenant looking in Toronto ($2,934) will need about $400 more on average than in North York and Etobicoke. The biggest difference is in the asking rents for three-bedroom units, where North York and Etobicoke suites are larger than Toronto by over 150 square feet, but the asking rental rates for the Toronto units are over $1,000 per month more on average.
"Less than stellar national economic data will likely put any interest rate hikes on hold for the remainder of the year, and several lenders are reducing their mortgage rates, which may induce some prospective buyers to purchase a home and relieve some pressure on the rental market," said Ben Myers, president of Bullpen Research & Consulting.


text:
Official Trailer for Duncan Bridgeman's Hecho en Mexico Released
Pantelion Films has released the official trailer for the music history documentary 'Hecho en Mexico,' which was written, directed and produced by Duncan Bridgeman. The trailer features several of the movie's stars, including Alejandro Fernandez, Kinky, Carla Morrison and Chavela Vargas.
'Hecho en Mexico,' which is set to be theatrically released on November 30, features original songs, conversations, reflections, wisdom and humor from many of the greatest performers and minds from Mexico. The film showcases the richness of Mexican music, including traditional, pop rock and rap. The movie also features interviews with such known Mexican personalities as Diego Luna and Lila Downs.
Watch the official trailer from 'Hecho en Mexico' below.
Written by: Karen Benardello
Box Office Report: Paranormal Activity 4 possess top spot; Argo barely flinches
Movie News Cheat Sheet: Shailene Woodley For Divergent, James Ransone For Oldboy, Aaron Paul For Need For Speed And More


Browse our great range of Hentastic Poultry Feeders Drinkers & Kits from Hyperdrug the oldest pet and equine pharmacy online. Buy Hentastic Poultry Feeders Drinkers & Kits at great prices with great customer service.
Hentastic Foraging Cake Feeder. Especially designed for use with Hentastic foraging cakes. This strong wire feeder can be anchored to stop movement.
Hentastic Smart Start Chick Feeder. Specially designed ground feeder to suit young chickens from hatching to point of lay. Brightly coloured to attract the young birds, easy to load and clean.
Hentastic Foraging Feast Chicken Feeder. This antimicrobial feeder is manufactured in the UK and impregnated with proven biomaster silver ion technology which destroys 99.9% of bacteria.
Hentastic Twist & Shake Dispenser. Simply fill with pellets then when in position twist to open and shake to scatter the pellets for a true foraging experience.


text:
National Center for Children in Poverty (NCCP) is an American non-partisan research center that promotes the interests of children in low-income families. The center covers a number of topics, including child poverty, adolescent health and youth development, healthy development, low-wage work, and children's mental health.

The center was established at Columbia University in 1989 as part of the Mailman School of Public Health. In July 2019, NCCP moved from Columbia University to join the Bank Street College of Education.

The NCCP conducts research in areas relevant to family well-being and publishes over 30 documents a year, ranging from fact sheets to full reports, including a compendium of sources related to child well-being collected from more than 200 journals and websites.

The NCCP is supported through government sources, corporations and foundations, and individual and private owners. It is primarily funded by foundation grants and federal funding.

References

External links

Columbia University
Poverty-related organizations
Research on poverty
Child poverty


Finding a healthy, chemical-free set of skincare products has been an absolute nightmare for me lately! There are so many reputable companies proudly claiming that their products are paraben-free, phlalate-free, and sulfate-free, but the ingredients in their formulas say the exact opposite. Some days I research products for hours without finding any cleansers, toners, serums, or moisturizers that are truly chemical-free.
Not to mention, fad ingredients like Rosehip are becoming widespread amongst the little guys and huge corporations producing skincare products for the face and body. And while Rose hydrosol is an incredibly beneficial ingredient for balancing your overall complexion, its sister ingredient, Rosehip, is an absolute nightmare for your hormones because it naturally increases your estrogen levels. Be careful not to mistake the two ingredients when reading the label of a product because though they do share a similar source, one can benefit your overall body while the other can act as a hormone disruptor.
Little side notes like these are crucial for me when choosing a skincare regime because I'm already fighting against estrogen dominance. I need a product that is going to compliment my health not capitalize on an existing issue. Is this such a grand request to make for the products I put on the most absorbable organ in the human body? We may not always see the pores in our skin, but they're there just the same and they will absorb the cosmetic products you put atop them.
I've gotten to a point where looking to cosmetic companies for products containing clean and healthy ingredients is no longer an option. Honestly, with the large amounts of poor quality ingredients being approved for use these days, finding good-quality skincare products is yet another overwhelming feat to accomplish. It's seriously almost as difficult as trying to find organic jalapenos at the grocery store. Whenever I do find them, I can't help but do a little victory dance in the produce section. I may look crazy, but I just found pesticide-free jalapenos…and do you know what that means?? Bacon, Jalapeno, and goat cheese grilled cheese sandwiches! Yum (psst…there's a link to the recipe included)!
Should we just give up and use the substandard products? Oh how those cosmetic companies would love for you to do this and use their products! But, my answer will always be no! I already have seizures, I'm not exactly looking to add anything else to my medical history. If you're teetering between using the standard chemical-filled products and truly healthy products, remember this one very important fact: You deserve better! Your body deserves better! And so does your overall self-esteem!
Be better than synthetic-filled products! Living a healthy lifestyle just feels good because it's good for you! Also, if you're experiencing problems with acne and breakouts, consider this: are these chemicals helping to clear up your issue or are they contributing to it? Logic tells us that bad ingredients will produce bad results while good ingredients can't help but improve upon your body. When you put a moisturizer, for example, on your face, the effects are far more than just skin deep, contrary to what you see in the mirror.
I recently took the high road and ditched the commercial skincare products altogether. They weren't producing the results I was looking for anyway, plus I wasn't feeding my body nutrients by putting those chemicals onto my skin. In reality, I was actually poisoning my body and getting nothing in return except poor health. No extra soft skin, no perfect pH balance, no clear skin. I've reached the point where I'm no longer asking "Which product should I try next?" rather I'm starting to wonder "Why am I choosing to poison my body?" It's as though I've hit a brick wall in the search for the perfect skincare regime. Honestly, now I'm questioning my methods altogether.
Well, the dilemma with this confusion brings us right back to the commercial skincare industry.
Society tells us that we should use these amazing and cutting-edge brands that have not only been promoted by well-known dermatologists, but are advertise incessantly on social media platforms, television, and paper advertisements. We don't always realize it, but we're bombarded by this industry on a daily basis to believe their lies…one lie in particular: buy these types of products if you want positive results. So it really shouldn't come as that much of a shock to discover that everyone and their brother not only uses this particular method, but views it as the normal way (and sometimes the only way) to treat skin issues, as well.
If you want to get really complicated, you can also try the Korean method which uses anywhere from 7-15 different products in the routine. I wouldn't recommend this method to anyone who is typically in a rush in the mornings. Not only is it time-consuming, but it is also complicated. I have tried this method and I have to admit that using 7 products for my regime did produce decent results in my skin, but it was nothing to brag about. In fact, I've actually had better results from using only 3-4 products. As you can imagine, this amount of products from a name brand company cost a pretty penny! Worst of all, at the end of the day, the penny was prettier than my skin and I was sick of it!
I then moved on to a more natural form of skin treatment. I found some products by a company called Rawsum Organics that are natural enough to eat. The company called their product raw skincare because not only were their ingredients natural, they were also organic and food grade! Their set consisted of the standard cleanser, toner, moisturizer, and exfoliant. However, instead of a huge ingredient list only found on the packaging because it is literally too long to fit on the product itself, the entire set of skincare printed each ingredient label loud and proud on the very front of each bottle. Why? Probably because the ingredient list for the cleanser only consisted of four ingredients total, the toner 3 ingredients, the moisturizer 3 ingredients, and the exfoliant also 3 ingredients. You could combine the ingredient lists of the all four products and it would still be less than the ingredient list of one commercial product. Who knew this even existed??? I was shocked when I found the set, but more than anything it restored my hope that maybe the cosmetic industry isn't completely devoid of good quality manufacturers.
I used these edible skincare products for almost two months and never experienced any interference with my epilepsy. Typically, skincare products contain the soy-derived ingredient, Tocopherol, which is a seizure trigger for me, personally. To my great relief, Rawsum did NOT use any soy-derived ingredients. To my great dismay, they did use other ingredients that just did not react well with my skin-type. I have oily skin naturally and although I noticed the Jojoba Oil, Olive Oil, and Castor Oil ingredients on the labels, I was desperate for something free of chemicals. As expected, my skin reacted with increased breakouts and an incredibly uneven skin tone. It reached a point that made it absolutely necessary for me to make a change. I still recommend the Rawsum products to anyone with a dry skin complex, but Oily-Combination skin types should be wary. There is no guarantee that your skin will react the same way mine did, but it's always good to be careful!
When the raw products didn't work out, I had absolutely no idea what to do next. Finding the Rawsum products was a miracle from God, I knew that trying to find something similar was going to be a long shot. I stopped researching products being sold by other organizations and started researching DIY skincare. I've always enjoyed cooking, I do it with food all the time, so why couldn't I do it with my skin products, too? Plus, if I was able to find a decent recipe for a cleanser, toner, and moisturizer, it would be a guarantee that I was finally feeding my skin instead of harming it.
Why hadn't I thought of this sooner??? Well, I have but other rabbit trails got in the way and my actually pursuing the idea. Part of me probably thought it was going to be too much work and the other part of me still had faith in the skincare industry. I was also skeptical about whether or not I could actually make something that would be beneficial, not just some crazy concoction that pales in comparison to the typical products with the perfect texture being sold today. I failed to look past the outer and focus on the inner because the ingredients of these products are far from perfect.
This time around, I was out of any other ideas, I had already tried the majority of options provided by commercial products, and my skin was NOT looking good.
I was way past the point of "pulling out the big guns" and I had reached the state of desperation where, as anyone who has also been in my shoes knows, anything is possible. And I do mean anything!
My skin had seen better days and I wanted nothing more than to clear it up. The acne on my face and neck confirmed the obvious…my pores were being clogged by my previous choice of skincare and the visible blockage was spreading quickly…I needed a miracle and I needed it yesterday.
As I researched recipes for a healthy cleanser, one ingredient kept popping up in a majority of the recipes. It was Raw Honey. Huh…so simple. Was it actually possible with its natural sucrose structure to improve my acne rather than add to the existing problem? The answer is yes. Honey is famous for being anti-bacterial and healing to the skin. Though we mostly use honey for eating purposes these days, this delicious nature given product was commonly used amongst medical professionals as a disinfectant to treat burns, cuts, and other minor injuries. As it turns out, honey has been used to heal the skin for generations…we just forgot this helpful information thanks to all of the commercial products that have been created over the years to replace it (although not one of them has ever been able to compete with the natural abilities of raw honey). You can't create God-given abilities in a lab, no matter how hard those scientists try! I'm sorry to burst those scientists' bubble (actually, I'm not), but Honey is one of a kind! I just like to give a shout out to those hard working bees across the globe…thanks for doing what you little guys do day in and day out!
Right now, I don't know what I would do without raw honey and I hate to think about what my skin might look like if this simple product wasn't the beneficial powerhouse history has proven it to be!
I decided to skip a DIY recipe and go back to the basics instead. I started using just straight up organic raw honey (I prefer Tropical Traditions, you can't beat the quality of their product!) on my face instead. After I get out of the shower, I spread an even layer of honey on my face and let it sit for 5-10 minutes. I usually leave it on my face for the full ten minutes just so that the honey has plenty of time to really get into my pores and clear out the bacteria causing my breakouts. After ten minutes, I wet my hands with warm water, not hot water! Hot water will kill the beneficial elements in the honey that not only clean your skin, but naturally balance the pH levels in your skin, as well. Bye, bye red blotchy skin when you use raw honey as your cleanser and toner!
Once your hands are wet, take some time to thoroughly rub the honey into your skin. Think of it as working the honey even deeper into those pores. In this way, you will also incorporate water into the honey mask, loosening the sticky layer, and making it much easier to wash off.
Once the honey is completely removed, I like to pat dry my skin using a washcloth. Instead of rubbing the cloth across your face, pat your skin so that you are not wiping away any honey residue that might be left. When I say residue, I mean the good stuff that is happily soaked into your skin already, not the leftover sticky substance that was missed while washing. I'm not expecting you to leave any honey on your face all day, that would be inconvenient for anyone. By all means, wet your washcloth and wipe that honey off!
The pat dry method helps to further work the honey soaked into your pores further into your skin. You definitely want this on your skin all day, which is why I have chosen not to use a toner afterward.
The toner is a potent cleansing device that will wipe away anything on the surface of the skin. It does not discriminate, therefore, it will wipe away the beneficial matter in addition to the detrimental matter. Using a toner means removing the healthy leftover honey in your pores, you do not want to do this nor do you need to! The honey is already attending to this issue.
The toner is also created to help restore balance in your skin's pH levels, but the honey takes care of this issue too (and much more successfully than any other product I've used in the past). So I have found it to be irrelevant in my honey based skincare routine.
I do, however, still follow up the honey with my moisturizer despite the fact that I am yet to find a chemical-free commercial moisturizer product or a decent diy recipe for this particular product. I'm still on the lookout and once I find one I will be sure to announce it here on Seize the Day Blog. Until then, I'm stuck with what I have. I tried only using the honey and not following it up with anything, but my skin felt shriveled, tight, and like it needed a serious drink of water. If you have any suggestions for a natural and chemical free moisturizer, please comment!
I apologize that I do not have a healthy moisturizer to recommend in combination with the Raw Honey. However, if you are interested in the moisturizer I am currently using and which I have found to be the best yet in accordance with all skin types, I can most definitely share that info!
The brand is Karin Herzog and it is called Oxygen Face. For a more intense moisture delivery I recommend the brand's Vitamin H Cream. My mom uses this one and she loves it! Both products ship the fastest from amazon if you are interested in trying them out (there is a link with the product name above and in the sources list below). The ingredient list isn't perfect, but it is free of soy-derived ingredients and I do not have a seizure when I use it! This is a huge benefit for me and also says something for the overall quality of the moisturizer despite the chemicals.
Who knew that something as well-known as honey, could be so beneficial for human skin? It took about three days to begin seeing serious changes in the amount of acne on my face, but it only took one use to begin seeing healing. I honestly could not believe my skin when I looked in the mirror after rinsing off the honey mask for the first time. Not only that, it felt good to put something on my skin that I knew was healthy for it, truly healthy. I haven't been able to say that about my skincare in a long time! Finally, an affordable product that will treat your skin at a miraculous rate! Honey is fed to people from all walks of life on a daily basis, so why not feed it to your skin too???
The information posted on Seize the Day Blog, including but not limited to, articles, images, recipes, text and other material are shared for informational purposes only. None of the writings should be looked upon as advice meant to replace that of an actual medical professional. If you suspect you have a serious medical condition you should seek help from a healthcare professional immediately. Please be aware that the author of this website is posting information simply to inform NOT to recommend others about health-related topics. Before following any information (i.e. undertaking a new healthcare or diet routine) found here on Seize the Day Blog, you should always consult a medical professional first. Please be sure to never disregard any medicinal advice because of something you have read on this website.


The ICT suite at Sidcot school presented us with a slighty more unusual space with its vaulted ceiling. The old fine fissured tiles looked dated and brought the space down. As the photos demonstrate, the replacement Armstrong ceiling, along with the installation of flat panel lighting, has really helped to lift the room and make the most of the space.


NEW release coming soon for teen readers!
We are happy to announce the good news! The final part of McLean Twins series by Jennifer Loiske will be released in time, so you will all have an opportunity to get it for Halloween! What could be a better way to spend the spooky holiday than a book full of witches and demons! Here's a little teaser for you…Please, remember, even if it is not yet edited, it is still a copyrighted work.
"I can't go there," She turned to her twin brother.
Ian put a hand on her shoulder. "I know, but we have to." Shannon bit her lip. "Sis, we have to," Ian's gaze nailed her on the spot, warning her, he would not give in an inch.
"I know," Shannon breathed, turning back to the manor. Ian was right, of course, but in that moment she would have given anything to go back to London under her weird aunt's witchy eyes, and to see her silly cousins, Bo and Blossom. As if that would never happen. Instead she had a demon to beat, and not just any demon, but her father.
Ian touched her hand gently, his features softening a bit. She grabbed his hand in hers before he had a chance to pull it back. Okay, she thought. I can do this. It's just a house, no biggie, and whatever was inside of it couldn't be worse than she'd experienced before. She inhaled deeply and took a step forward, dragging Ian with her. So quiet, she thought, a vein throbbing on her forehead, so peaceful and safe looking. It. Is. Just. A. House. She mentally kicked herself again before looking at Ian. He nodded reassuringly.
"Together," she nodded firmly and took another step, even when her mind screamed her to run away.
The house was beautiful, and emanated timelessness. It was a masterpiece from another century, a place that should be crawling life, happiness and joy, rather than being this quiet tomb, a place so similar of a graveyard. No one was to be seen in or outside of the house. Nothing moved. Not even the leafs of an ivy which was covering the grey stonewalls. Shannon lifted her face and looked up. The sun was peeking through the clouds, making the place look inviting. She laughed out loud and a crow joined her with its raspy voice.
A car door was opened close and a man leaped behind them.
Simon growled. This was the last place on earth he wanted to be, but there was no way he'd leave those kids without a proper back up. A devilish grin flashed on his face. Yes, they might be witches, but he was a demon. Simon placed his heavy hands on their shoulders. Ian stole a quick peek of Simon's grim face, before focusing on the house again.
Simon's black eyes were hollow, the scar across his face being unnaturally visible on his pale skin. The demon in him lifted its head, making the tattoos entwining his muscled arms squirm as if they were alive. He could sense the evil inside, the devil lurking in the shadows, waiting for the opportunity to strike Shannon and Ian down. His grip on the kids' shoulders tightened. He knew he shouldn't go into the house. Not when the darkness was whispering in his veins, urging him to do terrible things. The pull was nearly unbearable and yet he knew there was no power, in or outside of this world, which could have forced him to break a hair from his protégées. He would rather die than hurt them.
If you haven't started to read McLean Twins series yet, you can find the first part of the series here!
This entry was posted in McLean Twins Series and tagged Books, Demons, Jennifer Loiske, McLean Twins Series, Paranormal, Spells, suspense, Teens, urban paranormal, Witches, Young Adult fiction, Young Adults. Bookmark the permalink.
1 Response to NEW release coming soon for teen readers!
My new release, Black Coven, will be out soon!!!


text:
City Gardens Educate, Create Community
Girard Children's Community Garden in Washington, D.C.
A big city might not seem like the best place to learn about nature and the environment. But one group in Washington, D.C. is trying to change that.
City Blossoms is a non-profit organization with the goal of bringing nature to children who might not otherwise have green spaces. The organization has assisted in creating green space at seven elementary schools, two high schools and 18 early childhood centers across D.C.
City Blossoms has its own educators who teach children lessons centered on gardening and nature.
Tara McNerney is the director of City Blossoms and a former teacher. She said City Blossoms' lessons center on environmental science, healthy living skills like cooking, and artistic expression.
In the garden, students can learn environmental ideas like plant lifecycles or ecosystems. But teachers can also use the green space for reading lessons by reading a garden-related book or learning nature vocabulary. Even math could be taught in the garden.
"We're really able to adapt into the subjects that the teachers are wanting to teach," McNerney said.
City Blossoms' partnerships with local schools are meant to last at least three to four years. City Blossoms assists schools in creating and caring for the garden. But the gardens are mainly operated by the schools. McNerney said she partners with schools that already understand the importance of an outdoor education and that want to keep the garden at the school for many years.
"It's a school-run program that City Blossoms is supporting," McNerney said. "We don't want it to be a 'plop and drop' garden where it's seen as a City Blossoms garden and it's not fully embraced by the community, because that won't really lead to a sustainable garden program."
Volunteers work at the LaSalle-Backus Elementary School garden in Washington, D.C.
In City Blossoms' five other community gardens, the organization supports the garden and provides nature activities for the community. But the spaces remain community-driven.
"At the end of the day, we're not designing these sites," said Isa Zambrano. She helps maintain the community spaces for City Blossoms. "The community designs it. Every garden takes the shape of the community and the culture that exists there."
Young children and older adults have gotten involved with the community green spaces, said Kendra Hazel. She oversees the community gardens for City Blossoms. During cooking lessons, for example, people will tell about meals that are special to their culture.
The community gardens represent the diversity of D.C., Zambrano said. "It's like putting pieces together of so many different people and cultures and neighborhoods."
Food deserts
Healthy food is hard to find in some parts of Washington, D.C., especially in poorer areas. About 15 percent of D.C. is a "food desert." A food desert is an area where the nearest supermarket is more than 1.6 kilometers away. In the two poorest sections of Washington, D.C. -- Ward 7 and 8 -- there are just three supermarkets for 160,000 people.
Seven of City Blossoms' gardens are in those two wards. Part of the organization's mission is to "grow in spaces that might not otherwise have green spaces, and might not have fresh, healthy food," McNerney said.
For older students at two D.C. high schools, students learn how to grow and harvest crops through City Blossoms' Mighty Greens program. Students in the program also sell their vegetables and herbs at local farmers markets.
Signs welcome visitors to Girard Children's Community Garden in Washington, D.C.
'Getting your hands dirty'
While City Blossoms' main goal is to teach children, many older families and adults have also gotten involved. The organization holds gardening lessons for all ages.
Hazel said the pandemic has made people want to spend more time outside experiencing nature.
"People have really woken up to the fact that green spaces are really important in our communities," Hazel said. They have realized the good that comes from "being outside and being disconnected from technology, and just being," she added. "And getting your hands dirty."
I'm Dan Novak.
Dan Novak wrote this story. Ashley Thompson was the editor.
Quiz- City Gardens Educate, Create Community
Start the Quiz to find out
garden — n. an area of ground where plants such as flowers or vegetables are grown
adapt — v. to change your behavior so that it is easier to live in a particular place or situation
plop — v. to sit or lie down in a heavy or careless way
embrace — v. to accept readily or gladly
sustainable — adj. able to last or continue for a long time
maintain — v. to keep (something) in good condition by making repairs, correcting problems, etc.
diversity — n. the state of having people who are different races or who have different cultures in a group or organization
supermarket — n. a store where customers can buy a variety of foods and usually household items
ward — n. one of the sections into which a city or town is divided for the purposes of an election
See comments (13)
School Gardening Becomes More Popular in US
Community Centers, Museums Become Schools
City Gardening Expands in US During Pandemic
How to Garden When You Have Too Much Water


text:
FDA Seeks Input on Regulations for Neurodiagnostic Devices
Follow News Comments
With annotations Without annotations
With growing interest in testing treatments for Alzheimer's disease at early stages, trialists need better ways to detect subtle cognitive change. Both computerized cognitive assessments and electroencephalography (EEG) can track subtle decline, but neither has been validated in diagnoses or as quantitative trial outcome measures. What's more, because these technologies are new, the Food and Drug Administration has no clear guidelines for how such validation might be achieved. On November 19-20, the FDA's Office of Device Evaluation hosted a workshop seeking input on how to evaluate these neurodiagnostics. Stakeholders from academia, federal agencies, and advocacy groups discussed the devices' ability to detect early symptoms, but also the risks of misdiagnosis that stem from their use. As is often the case with regulatory deliberations, much was said but few concrete conclusions were reached right away. "The information collected by the FDA will help the agency develop an appropriate risk-based strategy and regulatory framework for these devices," FDA media spokesperson Deborah Kotz wrote to Alzforum. Some devices have received clearance for clinical use but remain short of approval as qualified biomarkers for trials.
"Computerized diagnostic tests will become the norm. This meeting served to jump-start dialogue and gather public feedback about the way forward," Murali Doraiswamy at Duke University, Durham, North Carolina, wrote to Alzforum. Doraiswamy advises companies such as Neuronetrix in Louisville, Kentucky, which markets an EEG device for measuring cognitive performance.
Regulation is critical, some speakers suggested, because pharmaceutical companies are beginning to incorporate new neurodiagnostic measures into dementia trials and many commercial devices are being developed or already sold. Dallas Hack, a retired colonel who oversaw military brain health research programs, noted that in the absence of specific regulations, many companies are marketing devices that do not meet basic safety and efficacy standards. "It could become a Wild West," Hack said at the workshop.
Interest in these devices is growing because researchers urgently need more sensitive cognitive outcome measures for early trials. In people at the earliest stages of cognitive decline, existing instruments like the ADAS-Cog are inadequate because everyone aces the test. Some trialists have turned to the CDR-sb, which detects subtle impairment and can stage disease accurately. However, some experts say CDR-sb does not measure changes finely enough to be useful as an outcome measure in trials of preclinical or early dementia (see Nov 2015 conference news). Researchers fear trials may miss a treatment effect due to the bluntness of the instrument used to measure it. To better capture decline, some groups have developed cognitive composites or functional questionnaires, which look promising in initial studies (see Feb 2013 Webinar; Jun 2014 news; Mar 2015 news). However, most of these tools remain in research use only, and have yet to receive either marketing clearance or validation as biomarkers from the FDA.
Workshop Mulls Path to Market for Neurodiagnostics
The FDA workshop mainly discussed how new neurodiagnostic devices might enter the market for clinical use. How stringent the validation is depends on how the FDA categorizes the device, and that hinges on its intended use, agency representatives explained. Class I devices are low-risk gadgets, such as a toothbrush, and require no special regulation. Class II devices are higher-risk, for example a transcranial magnetic stimulation system, and need regulations specific to each device within the class. Class III devices, exemplified by deep-brain stimulation, are highest risk and require the most stringent controls, including proof of safety and efficacy. Jay Gupta at the FDA noted that neurodiagnostic devices can serve distinct purposes: they can screen people for cognitive impairment, probe specific cognitive domains, measure whether a therapy is working, aid in diagnosis, or provide a stand-alone diagnosis. These uses might involve different levels of risk and put devices into different classes. "A number of these device types do not yet have regulations," Gupta said.
The FDA's Timothy Marjenin said that many neurodiagnostic devices will probably fall into Class II, whose regulatory standard is lower than that of drugs. Manufacturers typically do not have to demonstrate a benefit to patients to put such devices on the market. They only have to show that the device works as advertised. If the invention is similar to something already on the market, manufacturers can get clearance for clinical use by filing an FDA 510(k) premarket notification, usually without submitting any clinical data. Such devices are considered "cleared" for clinical use, but not "approved." Approval requires proof of efficacy. Only for Class III devices must manufacturers submit a premarket approval application to the FDA.
If, on the other hand, a device represents the first of its kind, manufacturers must file a de novo application and will typically need clinical data, even for Class II devices. The FDA recently designated a new device category called computerized cognitive assessment aids based on a de novo application for the Cognivue cognitive assessment system. Made by Cerebral Assessment Systems, a medical services company in Pittsford, New York, Cognivue evaluates cognitive health based on a person's ability to click on specific regions of a computer screen in response to subtle visual cues. Computerized cognitive assessment aids are defined as Class II devices that interpret a user's level of cognitive function based on a battery of test scores, Kotz wrote to Alzforum.
Will all neurodiagnostic devices fall into Class II? Workshop participants agreed that devices for certain purposes might require tougher regulations even if they are not invasive. While devices that simply provide a cognitive score or aid in diagnosis might be low-risk, those that claim to make a stand-alone diagnosis could be designated Class III because they could have serious consequences for patients and families if they get it wrong, Doraiswamy predicted. Complicating this classification is the eagerness of many diagnosed or suspected AD patients to slow or stop their disease. "Families impacted by Alzheimer's are willing to take on a higher level of risk than what was put forward in the technical discussions at the meeting … to me this underscores the importance of making sure that the patient voice is fully heard in these debates," wrote Stacy Haller of the BrightFocus Foundation, which advocates for and funds AD research (see full comment below).
FDA personnel stayed mum about how the workshop discussions might affect their future decisions.
Could EEG Signals Be Useful Biomarkers?
Also notably lacking was discussion of EEG devices which, after all, have already received Class II device clearance. Alzheimer's researchers are becoming more interested in these systems, as they measure synaptic function. Event-related potentials (ERPs), which are EEG signals generated in response to a stimulus, can detect declines in cognition (see Nov 2011 conference news; Nov 2011 conference news; Nov 2012 conference news). In small studies, changes in the ERP signal correlated with progression from MCI to AD, hinting that it could serve as an outcome measure (see, e.g., Lai et al., 2010; Chapman et al., 2011; Papaliagkas et al., 2011).
Despite thousands of scientific papers on ERP, the technology has only recently made it to primary care clinics. Traditionally, ERP measurements required complicated hardware, shielding from even weak magnetic fields, and lengthy data analysis. Neuronetrix developed a handheld, automated device and claims it works in primary care settings without specialized knowledge of EEG. The device measures brain activity as people discriminate "oddball" auditory tones from standard tones and white noise, a common ERP paradigm. Clinicians upload test data to an online database for comparison with population norms, simplifying analysis. The Cognision system was recently cleared for clinical use by the FDA and is on the market (see Feb 2015 news). The FDA cleared it via a Class II protocol because ERP systems have been used in research clinics for years. Other companies may also seek FDA clearance. For example, ElMindA, in Herzliya, Israel, is developing an ERP system that can map brain networks.
Getting devices on the market is but a first step. Trialists really want validated outcome measures for people with very early or preclinical AD. Here the path to FDA approval becomes hazy. For biomarkers, the FDA spells out clear requirements: researchers must perform a clinical trial that shows a reproducible difference between patients and controls whose diagnoses have been confirmed by standard clinical methods. However, the FDA does not define how to validate a device, said K.C. Fadem, Neuronetrix CEO.
In the absence of specific guidance, Neuronetrix attempted to meet the existing biomarker standard for Cognision by testing 103 people with probable AD and 101 controls at seven clinical study sites in the United States. The observational trial found the ERP brainwave signal had lower amplitude and was more delayed in people with AD than in controls, suggesting the measure could be a biomarker of AD, Fadem claims. Because the trial confirmed data from previous studies, he believes it met the standard of reproducibility. The data were published September 30 in Alzheimer's & Dementia online (Cecchi et al., 2015).
The FDA has not approved Cognision as a trial outcome marker. "I don't think the FDA is ready to pick an electrophysiological measure as a primary endpoint in Alzheimer's," Fadem said. However, ERP measures have been used as primary endpoints in schizophrenia trials. Even without FDA approval, several companies have incorporated Cognision as a secondary endpoint, for example in the HIV-Associated Neurocognitive Disorders (HAND) trial. At the moment, these trials are using Cognision as a pharmacodynamic marker to demonstrate that the drug hit its target in the brain. "Pharma companies are very interested in biomarkers of synaptic function," Fadem noted.
Meanwhile, Neuronetrix continues to gather data on the device's performance. The researchers are currently analyzing data from their observation trial to develop an algorithm for discriminating AD patients from controls. They will report sensitivity and specificity of this method and then confirm its diagnostic accuracy in a new trial. They are also following up the existing cohort with ERP measurements at one- to two-year intervals to find out whether the signal changes over time. This will be important in deciding whether ERP would make a good trial outcome measure.
Researchers also want to know how well ERP signals reflect brain amyloid. The amyloid hypothesis predicts that the presence of amyloid damages synapses. To test this, Neuronetrix is starting the Amyloid Correlation with Clinical Electrophysiology and Psychometric Tests (ACCEPT) study to link ERP signals with psychometric tests and brain amyloid as seen by PET. The hope is that ERP correlates better with amyloid than psychometric measures do, Fadem said.
Overall, people in the field agree that neurodiagnostic devices are up and coming, as technology is evolving and beginning to turn out inexpensive, easy-to-use devices.—Madolyn Bowman Rogers
Stacy Haller
These technologies hold great promise. They can help better inform families and their doctors, and if they are low-cost and non-invasive they could help researchers by accelerating the recruitment of patients and caregivers into clinical trials.
To me, one of the interesting discussion points during the day was about risk—both institutional and individual. Families impacted by Alzheimer's are willing to take on a level of risk higher than what was put forward in the technical discussions at the meeting. This is a tough question and one that will not be easily resolved, but to me it underscores the importance of making sure that the patient voice is fully heard in these debates.
This is a rapidly evolving field, a point well made by speakers such as Dallas Hack, who suggested a number of improvements on validation of these new technologies and standardizations between trial designs. It is particularly important that these tests be useful to clinicians and, for example, provide data that is meaningful at the individual level, not just to a larger population. We must invest the resources to fully validate these tests at a high level of rigor so they truly help people.
View all comments by Stacy Haller
Outcomes, Outcomes: Cognition is Crux of New Alzheimer's Trials 24 Nov 2015
Test Battery Picks Up Cognitive Decline in Normal Populations 6 Jun 2014
Test Tracks Preclinical Functional Decline 6 Mar 2015
EEG: Coming in From the Margins of Alzheimer's Research? 22 Nov 2011
EEG: Old Method to Lend New Help in AD Drug Development? 23 Nov 2011
CTAD: EEG Gains Luster as More Trials Incorporate Biomarkers 15 Nov 2012
FDA Has Cleared New Cognitive Screening Tests 27 Feb 2015
Lai CL, Lin RT, Liou LM, Liu CK. The role of event-related potentials in cognitive decline in Alzheimer's disease. Clin Neurophysiol. 2010 Feb;121(2):194-9. PubMed.
Chapman RM, McCrary JW, Gardner MN, Sandoval TC, Guillily MD, Reilly LA, Degrush E. Brain ERP components predict which individuals progress to Alzheimer's disease and which do not. Neurobiol Aging. 2011 Oct;32(10):1742-55. PubMed.
Papaliagkas VT, Kimiskidis VK, Tsolaki MN, Anogianakis G. Cognitive event-related potentials: longitudinal changes in mild cognitive impairment. Clin Neurophysiol. 2011 Jul;122(7):1322-6. PubMed.
Cecchi M, Moore DK, Sadowsky CH, Solomon PR, Doraiswamy PM, Smith CD, Jicha GA, Budson AE, Arnold SE, Fadem KC. A clinical trial to validate event-related potential markers of Alzheimer's disease in outpatient settings. Alzheimers Dement. 2015 Dec;1(4):387-94.
computerized cognitive assessment aids
Cognivue cognitive assessment system
Cognision
observational trial
HIV-Associated Neurocognitive Disorders (HAND) trial
Are New Cognitive Tests Ready For Preclinical Trials? 22 Nov 2013
Is Brain Training More Than Just Fun and Games? 12 Jun 2014
Brain Training Database: Treasure Trove for Preclinical Alzheimer's Research? 13 Jun 2014
Try This at Home: Cognitive Testing in the Age of Prevention Trials? 18 Dec 2014
To make an annotation you must Login or Register.


A neutrino detector is a physics apparatus which is designed to study neutrinos. Because neutrinos only weakly interact with other particles of matter, neutrino detectors must be very large to detect a significant number of neutrinos. Neutrino detectors are often built underground, to isolate the detector from cosmic rays and other background radiation. The field of neutrino astronomy is still very much in its infancy – the only confirmed extraterrestrial sources so far as of 2018 are the Sun and the supernova 1987A in the nearby Large Magellenic Cloud. Another likely source (3 standard deviations ) is the blazar TXS 0506+056 about 3.7 billion light years away. Neutrino observatories will "give astronomers fresh eyes with which to study the universe."
Various detection methods have been used. Super Kamiokande is a large volume of water surrounded by phototubes that watch for the Cherenkov radiation emitted when an incoming neutrino creates an electron or muon in the water. The Sudbury Neutrino Observatory is similar, but uses heavy water as the detecting medium. Other detectors have consisted of large volumes of chlorine or gallium which are periodically checked for excesses of argon or germanium, respectively, which are created by neutrinos interacting with the original substance. MINOS uses a solid plastic scintillator watched by phototubes; Borexino uses a liquid pseudocumene scintillator also watched by phototubes; and the NOνA detector uses a liquid scintillator watched by avalanche photodiodes.
The proposed acoustic detection of neutrinos via the thermoacoustic effect is the subject of dedicated studies done by the ANTARES, IceCube, and KM3NeT collaborations.
Neutrinos are omnipresent in nature such that every second, tens of billions of them "pass through every square centimetre of our bodies without us ever noticing." Many were created during the big bang and others are generated by nuclear reactions inside stars, planets, and other interstellar processes. Some may also originate from events in the universe such as "colliding black holes, gamma ray bursts from exploding stars, and/or violent events at the cores of distant galaxies," according to speculation by scientists.
In a neutral current interaction, the neutrino enters and then leaves the detector after having transferred some of its energy and momentum to a target particle. If the target particle is charged and sufficiently light (e.g. an electron), it may be accelerated to a relativistic speed and consequently emit Cherenkov radiation, which can be observed directly. All three neutrino flavors can participate regardless of the neutrino energy. However, no neutrino flavor information is left behind.
In a charged current interaction, a high-energy neutrino transforms into its partner lepton (electron, muon, or tau). However, if the neutrino does not have sufficient energy to create its heavier partner's mass, the charged current interaction is unavailable to it. Neutrinos from the sun and from nuclear reactors have enough energy to create electrons. Most accelerator-based neutrino beams can also create muons, and a few can create taus. A detector which can distinguish among these leptons can reveal the flavor of the incident neutrino in a charged current interaction. Because the interaction involves the exchange of a charged boson, the target particle also changes character (e.g., neutron → proton).
Antineutrinos were first detected near the Savannah River nuclear reactor by the Cowan–Reines neutrino experiment in 1956. Frederick Reines and Clyde Cowan used two targets containing a solution of cadmium chloride in water. Two scintillation detectors were placed next to the water targets. Antineutrinos with an energy above the threshold of 1.8 MeV caused charged current "inverse beta-decay" interactions with the protons in the water, producing positrons and neutrons. The resulting positron annihilations with electrons created pairs of coincident photons with an energy of about 0.5 MeV each, which could be detected by the two scintillation detectors above and below the target. The neutrons were captured by cadmium nuclei resulting in delayed gamma rays of about 8 MeV that were detected a few microseconds after the photons from a positron annihilation event.
This experiment was designed by Cowan and Reines to give a unique signature for antineutrinos, to prove the existence of these particles. It was not the experimental goal to measure the total antineutrino flux. The detected antineutrinos thus all carried an energy greater 1.8 MeV, which is the threshold for the reaction channel used (1.8 MeV is the energy needed to create a positron and a neutron from a proton). Only about 3% of the antineutrinos from a nuclear reactor carry enough energy for the reaction to occur.
A more recently built and much larger KamLAND detector used similar techniques to study oscillations of antineutrinos from 53 Japanese nuclear power plants. A smaller, but more radiopure Borexino detector was able to measure the most important components of the neutrino spectrum from the Sun, as well as antineutrinos from Earth and nuclear reactors.
Chlorine detectors, based on the method suggested by Bruno Pontecorvo, consist of a tank filled with a chlorine containing fluid such as tetrachloroethylene. A neutrino converts a chlorine-37 atom into one of argon-37 via the charged current interaction. The threshold neutrino energy for this reaction is 0.814 MeV. The fluid is periodically purged with helium gas which would remove the argon. The helium is then cooled to separate out the argon, and the argon atoms are counted based on their electron capture radioactive decays. A chlorine detector in the former Homestake Mine near Lead, South Dakota, containing 520 short tons (470 metric tons) of fluid, was the first to detect the solar neutrinos, and made the first measurement of the deficit of electron neutrinos from the sun (see Solar neutrino problem).
A similar detector design, with a much lower detection threshold of 0.233 MeV, uses a gallium → germanium transformation which is sensitive to lower-energy neutrinos. A neutrino is able to react with an atom of gallium-71, converting it into an atom of the unstable isotope germanium-71. The germanium was then chemically extracted and concentrated. Neutrinos were thus detected by measuring the radioactive decay of germanium. This latter method is nicknamed the "Alsace-Lorraine" technique because of the reaction sequence (gallium-germanium-gallium) involved. Gallium and germanium are named after France and Germany, respectively, and ownership of the Alsace-Lorraine territory has historically been a point of contention between France and Germany, thus the nickname of the technique. These radiochemical detection methods are useful only for counting neutrinos; no neutrino direction or energy information is available. The SAGE experiment in Russia used about 50 tons, and the GALLEX/GNO experiments in Italy about 30 tons, of gallium as reaction mass. This experiment is difficult to scale up due to the prohibitive cost of gallium. Larger experiments have therefore turned to a cheaper reaction mass.
"Ring-imaging" Cherenkov detectors take advantage of a phenomenon called Cherenkov light. Cherenkov radiation is produced whenever charged particles such as electrons or muons are moving through a given detector medium somewhat faster than the speed of light in that medium. In a Cherenkov detector, a large volume of clear material such as water or ice is surrounded by light-sensitive photomultiplier tubes. A charged lepton produced with sufficient energy and moving through such a detector does travel somewhat faster than the speed of light in the detector medium (although somewhat slower than the speed of light in a vacuum). The charged lepton generates a visible "optical shockwave" of Cherenkov radiation. This radiation is detected by the photomultiplier tubes and shows up as a characteristic ring-like pattern of activity in the array of photomultiplier tubes. As neutrinos can interact with atomic nuclei to produce charged leptons which emit Cherenkov radiation, this pattern can be used to infer direction, energy, and (sometimes) flavor information about incident neutrinos.
Two water-filled detectors of this type (Kamiokande and IMB) recorded a neutrino burst from supernova SN 1987A. Scientists detected 19 neutrinos from an explosion of a star inside the Large Magellanic Cloud—only 19 out of the octodecillion (1057) neutrinos emitted by the supernova. The Kamiokande detector was able to detect the burst of neutrinos associated with this supernova, and in 1988 it was used to directly confirm the production of solar neutrinos. The largest such detector is the water-filled Super-Kamiokande. This detector uses 50,000 tons of pure water surrounded by 11,000 photomultiplier tubes buried 1 km underground.
The Sudbury Neutrino Observatory (SNO) uses 1,000 tonnes of ultrapure heavy water contained in a 12-metre-diameter vessel made of acrylic plastic surrounded by a cylinder of ultrapure ordinary water 22 metres in diameter and 34 metres high. In addition to the neutrino interactions visible in a regular water detector, a neutrino can break up the deuterium in heavy water. The resulting free neutron is subsequently captured, releasing a burst of gamma rays that can be detected. All three neutrino flavors participate equally in this dissociation reaction.
The MiniBooNE detector employs pure mineral oil as its detection medium. Mineral oil is a natural scintillator, so charged particles without sufficient energy to produce Cherenkov light still produce scintillation light. Low-energy muons and protons, invisible in water, can be detected.
An illustration of the Antares neutrino detector deployed under water.
Located at a depth of about 2.5 km in the Mediterranean Sea, the ANTARES (Astronomy with a Neutrino Telescope and Abyss environmental RESearch) is fully operational since May 30, 2008. Consisting of an array of twelve separate 350-meter-long vertical detector strings 70 meters apart, each with 75 photomultiplier optical modules, this detector uses the surrounding sea water as the detector medium. The next generation deep sea neutrino telescope KM3NeT will have a total instrumented volume of about 5 km3. The detector will be distributed over three installation sites in the Mediterranean. Implementation of the first phase of the telescope was started in 2013.
The Antarctic Muon And Neutrino Detector Array (AMANDA) operated from 1996 to 2004. This detector used photomultiplier tubes mounted in strings buried deep (1.5–2 km) inside Antarctic glacial ice near the South Pole. The ice itself is the detector medium. The direction of incident neutrinos is determined by recording the arrival time of individual photons using a three-dimensional array of detector modules each containing one photomultiplier tube. This method allows detection of neutrinos above 50 GeV with a spatial resolution of approximately 2 degrees. AMANDA was used to generate neutrino maps of the northern sky to search for extraterrestrial neutrino sources and to search for dark matter. AMANDA has been upgraded to the IceCube observatory, eventually increasing the volume of the detector array to one cubic kilometer.
The Radio Ice Cherenkov Experiment uses antennas to detect Cherenkov radiation from high-energy neutrinos in Antarctica. The Antarctic Impulse Transient Antenna (ANITA) is a balloon-borne device flying over Antarctica and detecting Askaryan radiation produced by ultra-high-energy neutrinos interacting with the ice below.
Tracking calorimeters such as the MINOS detectors use alternating planes of absorber material and detector material. The absorber planes provide detector mass while the detector planes provide the tracking information. Steel is a popular absorber choice, being relatively dense and inexpensive and having the advantage that it can be magnetised. The NOνA proposal suggests eliminating the absorber planes in favor of using a very large active detector volume. The active detector is often liquid or plastic scintillator, read out with photomultiplier tubes, although various kinds of ionisation chambers have also been used.
At low energies, a neutrino can scatter from the entire nucleus of an atom, rather than the individual nucleons, in a process known as "Coherent Neutral Current Neutrino-Nucleus Elastic Scattering". This effect has been used to make an extremely small neutrino detector. Unlike most other detection methods, coherent scattering does not depend on the flavor of the neutrino.
Most neutrino experiments must address the flux of cosmic rays that bombard the Earth's surface.
The higher-energy (>50 MeV or so) neutrino experiments often cover or surround the primary detector with a "veto" detector which reveals when a cosmic ray passes into the primary detector, allowing the corresponding activity in the primary detector to be ignored ("vetoed").
For lower-energy experiments, the cosmic rays are not directly the problem. Instead, the spallation neutrons and radioisotopes produced by the cosmic rays may mimic the desired signals. For these experiments, the solution is to place the detector deep underground so that the earth above can reduce the cosmic ray rate to acceptable levels.
Neutrino detectors can be aimed at astrophysics observations, many astrophysics events being believed to emit neutrinos.
Gran Sasso National Laboratories (LNGS), Italy, site of Borexino, CUORE, and other experiments.
^ a b c KENNETH CHANG (April 26, 2005). "Tiny, Plentiful and Really Hard to Catch". The New York Times. Retrieved 2011-06-16. In 1987, astronomers counted 19 neutrinos from an explosion of a star in the nearby Large Magellanic Cloud, 19 out of the billion trillion trillion trillion trillion neutrinos that flew from the supernova.
^ IceCube Collaboration; Fermi-LAT; MAGIC; AGILE; ASAS-SN; HAWC; INTEGRAL; Swift/NuSTAR; VERITAS; VLA/17B-403 teams (2018). "Multimessenger observations of a flaring blazar coincident with high-energy neutrino IceCube-170922A". Science. 361 (6398): eaat1378. arXiv:1807.08816. Bibcode:2018Sci...361.1378I. doi:10.1126/science.aat1378. PMID 30002226.
^ a b Ian Sample (23 January 2011). "The hunt for neutrinos in the Antarctic". The Guardian. Retrieved 2011-06-16. The $272m (£170m) IceCube instrument is not your typical telescope. Instead of collecting light from the stars, planets or other celestial objects, IceCube looks for ghostly particles called neutrinos that hurtle across space with high-energy cosmic rays. If all goes to plan, the observatory will reveal where these mysterious rays come from, and how they get to be so energetic. But that is just the start. Neutrino observatories such as IceCube will ultimately give astronomers fresh eyes with which to study the universe.
^ Pierre Le Hir (22 March 2011). "Tracking down the crafty neutrino". Guardian Weekly. Retrieved 2011-06-16. But they are nevertheless almost undetectable: in just one second several tens of billions of neutrinos pass through every square centimetre of our bodies without us ever noticing. ... No magnetic field diverts them from their course, shooting straight ahead at almost the speed of light. ... Almost nothing stops them. ... Neutrinos are remarkably tricky customers. There are three types or flavours: electron, muon, and tau neutrinos, named after three other particles to which they give rise when they collide with an atom.
^ "All About Neutrinos". icecube.wisc.edu. Retrieved 2018-04-19.
^ MALCOLM W. BROWNE (February 28, 1995). "Four Telescopes in Neutrino Hunt". The New York Times. Retrieved 2011-06-16. NEUTRINO astronomy was given a strong push in 1987 when a supernova in a galaxy only one-quarter of a million light-years away from Earth flared into view—the closest supernova in 400 years.
^ J.P. (Dec 1, 2010). "Hang on, that's not a neutrino". The Economist. Retrieved 2011-06-16. The largest, IceCube, sits deep underneath the South Pole in a cubic kilometre of perfectly clear, bubble-free ancient ice and is set to start working in earnest early next year. All rely on detecting the flickers of light emitted on the exceedingly rare occasions when a neutrino does interact with an atom of ice or water.
^ Winslow, Lindley (Oct. 18, 2012). Coherent Neutrino Scattering, UCLA. Retrieved 29 Sept. 2017.
^ Akimov, D.; Albert, J. B.; An, P.; Awe, C.; Barbeau, P. S.; Becker, B.; Belov, V.; Brown, A.; Bolozdynya, A.; Cabrera-Palmer, B.; Cervantes, M.; Collar, J. I.; Cooper, R. J.; Cooper, R. L.; Cuesta, C.; Dean, D. J.; Detwiler, J. A.; Eberhardt, A.; Efremenko, Y.; Elliott, S. R.; Erkela, E. M.; Fabris, L.; Febbraro, M.; Fields, N. E.; Fox, W.; Fu, Z.; Galindo-Uribarri, A.; Green, M. P.; Hai, M.; et al. (2017). "Observation of coherent elastic neutrino-nucleus scattering". Science. 357 (6356): 1123–1126. Bibcode:2017Sci...357.1123C. doi:10.1126/science.aao0990. PMID 28775215.
^ "Neutrino detection goes small". Physics Today. 2017. doi:10.1063/PT.6.1.20170817b.
^ Levy, Dawn (Aug. 3 2017). "World's smallest neutrino detector finds big physics fingerprint", Oak Ridge National Laboratory. Retrieved 29 Sept. 2017.


with Nickantony Quach and "Skydio One", his first self-flying camera.
This is Mason and Nina.
They are having fun with "Skydio One", my first self-flying camera.
Mason is using Skydio for the very first time.
As soon as Skydio takes off, it turns around and look for the filming subject.
By default it follows the subject.
However, Mason is switching it from "Follow-mode" to "Lead-mode".
Skydio is in front of Mason. Can you spot it?
While "Skydio One" is filming, Nina captures everything on her cell phone.
I'm gonna come down the stairs.
Tell him to focus on walking not looking at the camera.
then up again on the last moment.
the day after I met Mason and Nina.
As I crossed the street so did the shadow of "Skydio One".
"Skydio One" is my new buddy.
Today, we will tell you at once two different stories: Thumos and Skydio.
I'm crossing the Seekonk River on the Henderson Bridge.
At the end of the bridge is the city of Providence in Rhode Island, the smallest state in America.
Here is a view of its campus.
A student from this school and I in 2014 took a walk across this bridge.
he disclosed the trouble he was having in his relationship with his parents.
14 years ago and 2000 miles away from this bridge, I came up with a mantra for my son.
It is a short sentence with only five words.
It is the one and only lesson from me to my son throughout while he was in first grade.
I told the student, why don't you take the mantra with you this summer and discharge its power at home.
Half of your relationship problems should disappear.
This is later known as the "First Thumos Mantra".
It is the single lesson for my son in first grade. Its power could erase half of the unwanted drama in life.
"Skydio One" and I are now in the city of Providence.
My self-flying camera does not record any sound.
Audio recording is done by the cell phone in my pocket.
Can you hear me struggling riding up the hill now?
Two months later, I received an email from the student I mentioned earlier.
The email stopped me in my track.
Right after reading the email, I wanted to write a book about my discovery.
Wayland Square is coming up.
and show you where we normally work together on the book.
The second house on the left is the coffee shop where we spent a lot of time writing the book.
few weeks before the September 11th attacks.
on a bridge 2000 miles away–the Henderson bridge.
the focus on foresight for your ideal self.
It helps you foresee on whom you truly want to become.
As I turn right into this parking lot, "Skydio One" does the same.
That is possible because it can foresee where I'm going to be next.
"Skydio One" keeps going but only for a little bit further.
And then it realized what happened and tried to catch up with me.
I have a better way to tell you more about the first version of Thumos philosophy.
talking about how to revise our book material again and again.
The first version of anything is never perfect.
This is true for Thumos.
This is also true for Skydio.
Skydio-One cannot foresee far enough.
Look at the tree ahead.
That's why it slows down at the tree and then catches up with me afterward.
Thumos philosophy is designed to be improved over time .
It has to be improved over time.
Thumos3 is the group that produced the first version of Thumos philosophy.
I met my neighbor Mike, while he was building an igloo in our backyard.
Weeks later, he introduced me to Mark Canny, who is now my coauthor.
Although Mike did not write, he helped us think deeper.
It was Mike who got us to think about the term Thumos and he named our group Thumos3.
My name is Mark Canny and I am a coauthor of the book Thumos.
So I had three different audiences in my mind.
One audience was anyone who suffers from frequent relationship conflict .
university and college is supposed to solve those problems for us.
But most people I know feel like they're in this second group of people.
They've pursued a path up until this point and they're not certain or secure in it.
or they're just in it because, for survival-related reasons.
anyone who feel like they lack a sense of personal philosophy.
it came down to one collective group of people which is university students.
So this message is for university students.
and be proactive for you in the near future.
take a walk around the town for brainstorming purposes.
The scenery along this waterfront often gives our inspiration a boost.
and how it helped a senior student at Brown University 14 years later.
At the start of our project, Mark was impressed with the mantra and its origin.
But he did not internalize it until six weeks later.
on that day, we walked by this red-brick building, right here, on the right.
It belongs to the RISD Architecture Department.
Mark was shocked as he fully grasped the true meaning of the five-word mantra.
He felt necessary to collapse himself and expressed what was going on in his mind at the time.
You can see where I stand.
That was where Mark collapsed.
told me how powerful the first Thumos mantra is.
For me this location is called Thumos Landing.
12 months later we found our first test subject.
He was a visiting professor at Brown University.
almost a year before the book was published.
Skydio was released as a product.
It's the first self-flying camera with foreseeing technology.
Skydio is backing away from the branches.
Skydio; that means, master of the sky.
Luck? Or did Skydio foresee this black wire here, coming up?
Do you think Skydio can see this black wire?
Skydio can definitely see this lamp.
Come on, Skydio, you can follow me.
Go under it. Yes, you did it!
As I bring down the music, you can hear the noise from Skydio.
show you why Skydio means "master of the sky".
Donate! Support our work, please.
I came up with the first Thumos mantra.
and yet arguably the most powerful mantra of all.
It has only five words.
This mantra lead us to our work on the Thumos philosophy.
while he was working on the book with me.
Philosophy; that means, accepted wisdom.
"Shared undertanding of terms" is now accepted as the wisdom of Thumos philosophy.
Its creativity is powered by the precision in its nomenclature.
Using Thumos jargon, you can articulate your deliberation in expressing your ideal self.
and thus make others understand how to avoid interfering with our ideals.
It is a better way to command a full respect from others.
Many thanks to all who agreed to be on this YouTube channel.
Many more thanks to Mike, Mark, and so many others in the creation of Thumos philosophy.
Its jargon gets your there faster.
Donate! Please support our work.


text:
Q: How to subtract consecutive even rows from odd rows in MYSQL? I have the following snapshot of the mysql table.
ID      NAME          TIME                     TYPE
911018  AAA 2016-11-07 08:10:04.000000       0
911018  AAA 2016-11-07 10:10:55.000000       1
911018  AAA 2016-11-07 10:15:31.000000       0
911018  AAA 2016-11-07 11:15:50.000000       1
911018  AAA 2016-11-07 11:49:21.000000       0
911018  AAA 2016-11-07 12:13:02.000000       1
911018  AAA 2016-11-07 12:14:26.000000       0
911018  AAA 2016-11-07 13:14:33.000000       1
911018  AAA 2016-11-07 13:21:26.000000       0
911018  AAA 2016-11-07 13:51:43.000000       1
911018  AAA 2016-11-07 13:53:29.000000       0
911018  AAA 2016-11-07 15:44:45.000000       1
911018  AAA 2016-11-07 15:46:25.000000       0
911018  AAA 2016-11-07 16:45:44.000000       1
911018  AAA 2016-11-07 17:01:58.000000       0
911018  AAA 2016-11-07 18:07:18.000000       1
911018  AAA 2016-11-07 18:09:00.000000       0
911018  AAA 2016-11-07 19:15:33.000000       1

TYPE 0 indicates IN
TYPE 1 indicates OUT
Is there a way to subtract the 2nd row with 1st row(2-1) and 4th row with 3rd row(4-3) and so on.. Then I could to add that and store it in same table or other table maybe (2nd row - 1st row)+(4th row - 3rd row)+(6th row -5th row)so on, it should do it only when the Type is in the pair 0,1,0,1,0,1...
If the pair is 0,0,1,0,1,0... then it should take the the first one similarly IF the pair is 0,1,0,1,1,0,1.. then it should take the 2nd 1
The result would be something like
911018 AAA 2016-11-07 02:00:00.000000 (10:10:04.0000000 - 08:00:00.000000)
911018 AAA 2016-11-07 01:00:00.000000 (11:15:00.0000000 - 10:15:00.000000)
911018 AAA 2016-11-07 00:24:00.000000
911018 AAA 2016-11-07 01:00:00.000000
....

Then maybe a table having the (sum of the time) row like
911018 AAA 2016-11-07 09:30:00.00000

Hope I have explained it in an understandable way.

A: i tested my previous awser and fixed a few things.
select e.id, e.name, e.time, e.type, o.time, (o.time - e.time) test, cast((o.time - e.time) as time ) as test2
from Table1 e
left join Table1 o on o.time = (

    select min(time) from Table1 where (time > e.time) and (type=1)
)

where e.type=0

still missing the gaps in odd and even but its close

i did not test this, but something like this ( might needs tweaking ):
select id, name, (e.time - o.time) as time
from you_sql_table e
left join you_sql_table o ON (e.type=0) and e.time = (select min(time)
from your_sql_table where (type=1) and (time > e.time))

the trick is to select the next value in the join with the select query on the same table.
you can mix values from the main select query.
the example below runs on mysql
carfuel example:
SELECT `n`.`id`, `c`.`current` AS `previous`, `n`.`current`
(IFNULL(n.current,0)-c.current) AS `dist`, `n`.`fuel cost`
(IFNULL(n.current,0)-c.current)/n.`fuel cost` AS `km per euro`,
`n`.`date`, `n`.`rate` FROM `carfuel` AS `c`
LEFT JOIN `carfuel` AS `n` ON n.current = (select min(current)
from carfuel where current > c.current)
WHERE ((IFNULL(n.current,0)-c.current)>0)

id = just a record id
current = the km setting of my car at the moment i filled up my car
fuel cost = the amount i payed to fill up my car.
date = the date i filled up my car ( not needed )
rate = rate of fuel price ( not needed )

A: I would advise you yo make a new field in the table, with "pairID" for each in, out, so you can group by pairID, order by time, and diff the dates.

A: As I understand your question I would do it like this.
with a as
(
SELECT ROW_NUMBER() OVER(ORDER BY [id] DESC) AS RowNumber,
    [name],
    [id],
    [time],

FROM [YourTable]
)
select * from a where RowNumber % 2 = 1

for odd numbers or
select * from a where RowNumber % 2 = 0

for even.

redpajama_set_name: RedPajamaStackExchange


text:
Bonnie Sennott
Born in Wichita, Kansas
Lives and works in Amherst, Massachusetts
1988 MFA, University of Chicago
1979 BA, DePaul University
Kingston Gallery, Boston, MA (2004, 2005, 2007)
Center for the Arts, Northampton, MA (2002)
University Center Gallery, University of Tennessee, Knoxville, TN (2000)
Inside Art Gallery, Chicago, IL (1995, 1998)
Burnett Gallery, Jones Library, Amherst, MA (1998)
Artemisia Gallery, Chicago, IL (1991, 1992)
TWO- and THREE-PERSON EXHIBITIONS
Work by Bonnie Sennott, Lou Peugh, and Emily Tereila, Hosmer Gallery, Thornes Library, Northampton, MA (2019)
"Working the Grid: Three Artists," Towne Art Gallery, Wheelock College, Boston, MA (2005)
"Fiber and Fashion," #LOCAL Gallery, Easthampton, MA (2019)
"Homespun: One Hundred Years of Textile Arts in Holyoke," Wistariahurst Museum, Holyoke, MA (2018)
Fifth Annual Juried Exhibition, Gallery A3, Amherst, MA (2018)
Seventh Annual Small Works Show, Hope and Feathers Gallery, Amherst, MA (2017)
Third Annual Juried Exhibition, Gallery A3, Amherst, MA (2016)
Open Call: NNE (North Northeast), Brattleboro Museum and Art Center, Brattleboro, VT (2015)
Second Annual Juried Exhibition, Gallery A3, Amherst, MA (2015)
First Open Juried Show, Gallery A3, Amherst, MA (2014)
"Small Stories," Urban Alchemist, Brooklyn, NY (2012)
Works on Paper, Center for the Arts, Northampton, MA (2007)
National Prize Show, Cambridge Art Association, Cambridge, MA (2006)
"Site Lines," Kingston Gallery, Boston, MA (2005)
"How Bad Do You Want It," Geoffrey Young Gallery, Great Barrington, MA (2005)
"Down & In," Kingston Gallery, Boston, MA (2004)
"X-Exhibitionists," Center for the Arts, Northampton, MA (2004)
"Wide Turns and Frequent Stops," Kingston Gallery, Boston, MA (2003)
"The New Topography," Geoffrey Young Gallery, Great Barrington, MA (2003)
"The Art of Drawing," Concord Art Association, Concord, MA (2003)
Boston Drawing Project, Bernard Toale Gallery, Boston, MA (2002)
"Mapping New Directions," Artworks! at Dover Street, New Bedford, MA (2001)
"National Drawing 2001," Mesa Arts Center, Mesa, AZ (2001)
"Manifest: A Biennial Survey of Contemporary Art," The Copley Society, Boston, MA (1999)
"A Local Habitation and a Name," Geoffrey Young Gallery, Great Barrington, MA (1999)
"Gridworks," South County Center for the Arts, West Kingston, RI (1999)
"New England/New Talent," Fitchburg Art Museum, Fitchburg, MA (1998)
Group Show, Inside Art Gallery, Chicago, IL (1998)
Springfield Art League 78th National Exhibition, Museum of Fine Arts, Springfield, MA (1997)
"All the Things You Are," Geoffrey Young Gallery, Great Barrington, MA (1997)
"Clay, Wood, Pencil, Paint, Film," Nacul Center Gallery, Amherst, MA (1997)
"Critic's Pick," by Christine Temin, Boston Globe, March 20, 2005
"At a Glance: Invention and Tradition in Six Shows," by Jonathan Fardy, artsMEDIA, March/April, 2005
"Critic's Pick—Visual Arts," by Joanne Silver, Boston Herald, April 9, 2004
"Bonita Sennott: Paintings and Drawings," by Gabrielle Senza, Art New England, February/March, 2003
"Found in Nature," by Fred Camper, Chicago Reader, November 27, 1998
"Heaven in a Grain," by Bonnie Wells, Amherst Bulletin, September 4, 1998
"Fitchburg's Gem of an Art Museum," by Christine Temin, Boston Globe, May 6, 1998
"Area Talent Stands Out at Exhibit," by Eve Rifkah, Worcester Telegram & Gazette, April 29, 1998
Embroidery Instructor, Knack: The Art of Creative Reuse, Easthampton, MA (2013-2016)
Instructor, University of Massachusetts Amherst, Division of Continuing Education/Lifelong Learning, Amherst, MA (1998-2001)
Lecturer, University of Chicago, Center for Continuing Studies, Chicago, IL (1987-1992, 1996)
Adjunct Instructor, Triton College, River Grove, IL (1990)
Lecturer, Richard J. Daley College, Division of Adult Education, Chicago, IL (1987-1988)
Teaching Assistant, University of Chicago, Committee on Art and Design, Chicago, IL (1987-1988)


text:
Multidecadal Variations in the Relationship between the NAO and Winter Precipitation in the Hindu Kush-Karakoram
Winter precipitation over the Hindu Kush-Karakoram (HKK) range in the western Himalayas is generated by westerly perturbations whose dynamics is affected by the North Atlantic Oscillation (NAG). Larger precipitation is typically recorded during the positive NAO phase. In this work, the relationship between the NAO and winter precipitation in the HKK is explored further, using an ensemble of precipitation datasets and the 40-yr ECMWF Re-Analysis (ERA-40) and Twentieth Century Reanalysis (20CR) data. The mechanisms underlying this relationship are discussed, with a focus on the secular variations that occurred in the last century. The NAO exerts its control on HKK precipitation by altering the intensity of westerly winds in the region of the Middle East jet stream (MEJS). Results indicate that evaporation from the Persian Gulf, the northern Arabian Sea, and the Red Sea plays an important role. During positive NAO phases, westerlies are strengthened and enhanced evaporation occurs from these basins owing to higher surface wind speed. The extra moisture combines with stronger westerlies and results in enhanced moisture transport toward the HKK. Precipitation datasets covering the twentieth century show an alternation of periods of strong and weaker influence of the NAO on precipitation in the HKK. It is found that these variations are associated with changes in the spatial pattern of the NAO: the relative position of the two centers of action of the NAO determines to what extent it can modulate the MEJS, affecting precipitation in the HKK.
Multidecadal Variations in the Relationship between the NAO and Winter Precipitation in the Hindu Kush-Karakoram / Filippi, Luca; Palazzi, Elisa; von Hardenberg, Jost; Provenzale, Antonello. - In: JOURNAL OF CLIMATE. - ISSN 0894-8755. - 27:20(2014), pp. 7890-7902.
Titolo: Multidecadal Variations in the Relationship between the NAO and Winter Precipitation in the Hindu Kush-Karakoram
FILIPPI, LUCA
Palazzi, Elisa
GRAF VON HARDENBERG, JOST-DIEDRICH
Provenzale, Antonello
Digital Object Identifier (DOI): http://dx.doi.org/10.1175/JCLI-D-14-00286.1
2014Multidecadaljcli-d-14-00286.1.pdf 2a Post-print versione editoriale / Version of Record PUBBLICO - Tutti i diritti riservati Visibile a tuttiVisualizza/Apri