 Broadband PIM Test solutions for all applications. Made in Germany by Rosenberger.
High-speed data transmission in today's global mobile communication networks demands high efficiency of network infrastructure. Passive Intermodulation (PIM) in a network can cause serious interferences and significantly degrade the network quality and impact KPI figures.
The cause of Passive Intermodulation is very complex and uncertain.
The Rosenberger portable and multifunctional broadband PIM Site Analyzer alpha provides the best alternative of performing the most precise and efficient PIM tests on site.
Field proven, robust design for fast & precise multiband testing in production environment. Future-proof T&M equipment for R&D / Lab Testing.
Broadband or single band units for high portability and flexibility in production lines / R&D / Test labs.
No matter which model, there is some basic accessories which we deliver with every new unit. Some of the content is equipment type or country specific (e.g. power plug, manual) please see data sheet to find out which one is suitable to your application.
This optionally available accessory kit with low PIM components includes adaptors, test cables and tools frequently used and needed in production and lab environment.
This optionally available accessory kit is optimized for field use and includes most frequently used adaptors, test cables, tools as well as a low pim termination.
Datasheet "Accessory Kit On Site"
Rosenberger Passive Intermodulation Analyzers are provided with a 12 months warranty.
To ensure highest precision of measurements, we recommend a calibration interval of 12 months. On-site calibration service is optionally available. If you wish to send back a unit for calibration or repair, for smooth transaction please find handling information in our fact sheet or simply contact us.
Register here to receive update notifications for the PIM Site Analyzer alpha software.
Contact – we are here for you!
© Copyright 2019, Rosenberger Hochfrequenztechnik GmbH & Co. KG. All rights reserved.
We do not collect any personal data (such as names, birthdays, addresses) via our web page unless provided voluntarily (e.g. by registration procedures, questionnaires, orders). In order to recognize the sites you have already visited and to meet your interests when visiting our web sites, we may store connection data, the Internet Browser you used, visited sites, etc. In some cases we might also store "cookies" or make use of active components (e.g. JAVA Scripts).
This website uses Google Analytics, a web analytics service provided by Google Inc. ("Google"). Google Analytics uses so called "Cookies" enabling us to analyze your usage of our online offer. The information generated by the cookie about your use of our online offer will generally be transmitted to and stored by Google on servers in the United States. In case of anonymous IP activation on this website, however, Google will shorten your IP address within Member States of the European Union or in other countries that are parties to the European Economic Area Agreement. Only under exceptional circumstances is the complete IP address transmitted to a server of Google in the United States and shortened there. Under the authority of the provider of this website, Google will use this information for the purpose of evaluating your use of the website, for compiling reports on website activity and providing further services relating to website activity and Internet usage for the website operator. In accordance with Google Analytics, your IP address, which is transmitted via your browser, will not be associated with any other data held by Google. You may refuse the storage of cookies by selecting the appropriate settings on your browser; however, please note that if you do this you may not be able to use the full functionality of this website. Furthermore, you can prevent the collection of data generated by the cookie about your use of the website (including your IP address) and its processing by Google by downloading and installing the browser plug-in available from the following link https://tools.google.com/dlpage/gaoptout?hl=de.
The Rosenberger Hochfrequenztechnik GmbH & Co. KG website may contain links to other websites, but Rosenberger Hochfrequenztechnik GmbH & Co. KG is not responsible for their privacy practices or content.


text:
COVID + Cold Weather = Ingenuity
March 11, 2021 / Andrea Wenger
Ingenuity — along with technical know-how, 1,000 feet of microphone cable, an FM radio transmitter, four sound boards, seven speakers, two stereos, a lot of small rooms, and perseverance — were required for EMHS Touring Choir to rehearse safely indoors this winter.
After last fall semester's Touring Choir section rehearsed outdoors, this semester's choir members rehearsed together in separate practice rooms, dressing rooms and hallways connected by mic cables and equipped with speakers.
The rooms were each wired with speakers so students could hear Jared Stutzman, choir director, and each other without the sound delay characteristic of online platforms. From the classroom, Stutzman managed the piano, distance learning students on the big screen, and the feed to eight students on his soundboard and laptop.
Watch a video that shows the set up.
Setting up the configuration took Stutzman approximately 15 hours and into the early morning hours at the start of the semester. "With the weather making it impossible to sing outside, I needed to find a way for us to sing inside. It was important that I get it set up before my two-week paternity leave, so that my substitute (Sue Swartz — thanks Sue!) could facilitate singing with the choir while I was out." Jared, his wife Rebekah and three big sisters welcomed baby Lev Raleigh to the family February 4.
"It wasn't an ideal system, but it worked. It was really neat to be able to sing together inside without delays. Students could even take their masks off to sing, because they were each in a separate enclosed space."
Warmer weather and updated school guidelines for COVID safety protocol prompted Stutzman to take down the music-making system last week. The group is now able to sing outside and inside (with masks) with a 6 foot, rather than 10 foot, distance between them.
EMS administrators and teachers have referred to guidelines from Centers for Disease Control, Virginia Department of Health and, particularly, the "Colorado Study" for best practices for singing during COVID. "This study is the seminal research conducted by experts that provides guidance on choral and instrumental music in schools during the pandemic," explains Justin King, high school principal.
Forty-one students took part in Touring Choir this academic year over the two-semester schedule. The 4×4 block schedule has meant that the full group wasn't able to be enrolled at the same time at any point in the year. Their first opportunity to sing together will occur during the school's annual out-of-the classroom E-term experience April 19-21. The choir will meet for outdoor rehearsal sessions at Highland Retreat Center in Bergton. Several outdoor spring concerts at local churches are planned, though the spring touring season will be limited in comparison to past years.
"COVID has been especially hard on the performing arts," says Stutzman. The entire spring 2020 Touring Choir program schedule was cancelled, as was the group's biennial European tour, which would have taken place in June 2020 in the UK, Netherlands, and Germany. "It's taken most of the year to figure out ways to sing together meaningfully, but with the weather warming up and some concerts planned, we have a lot of hope and joy about this spring."
Posted in Academics tagged: COVID-19, music, the arts, touring choir

redpajama_set_name: RedPajamaCommonCrawl


just kate.: cool summer nights.
I recently announced via Instagram that I'm partnering with Aeropostale to introduce their new fall line! Their new line is more mature and very versatile. I love this knit sweater that can easily transition into fall and winter. These boyfriend shorts are already a favorite piece of mine in my closet. They're so comfortable!
Be sure to shop Aero's new line. It's worth checking out!


text:
B J Kang Law PC
Firm Perspectives
A Tug-of-War: The Impact of § 247(b) of the Immigration and Nationality Act on IRC § 893 Exemption
In 1935 the Austrian government sought to impose Austrian income tax on several employees of the United States whom were working in Austria. The U.S., in an attempt to appease the Austrian government and secure some sort of reciprocal agreement, amended §116 of the Revenue Act of 1934. This amendment, now codified in the Internal Revenue Code ("IRC") in § 893, provides an important U.S. income tax exemption to certain employees of a foreign government whom are working in the U.S.
IRC § 893 ("U.S. Income Tax Exemption") gives a U.S. income tax exemption to individuals who are employees of a foreign government, working in the United States, and who:
Are not citizens of the United States;
Perform similar services of a character that employees of the U.S. government in foreign countries would do; and
Are employed by a foreign government that grants an equivalent exemption
The usefulness of this exemption is relatively straightforward for most individuals working in the U.S. on behalf of their governments. However, for a few individuals, this exemption is absurd. Why would a tax exemption ever be absurd? Well, the individuals who find it absurd are most likely looking at it in conjunction with the Immigration and Nationality Act ("INA").
Section 247(a) of the INA requires the Attorney General to adjust the immigration status of an "immigrant" to a "nonimmigrant" if, at any point in time, the immigrant acquires an occupational status entitling him or herself to a non-immigrant status. Such occupational statuses are those which pertain to A (Government Officials), E (Treaty Traders), or G (International Organization Representatives) visas.
The impact of changing someone from an "immigrant" to a "nonimmigrant" is substantial since only immigrants may become permanent residents and obtain permanent residency. Permanent residency is a key requirement for naturalization. The question then became: how can The U.S. government give these individuals some leeway to work around this automatic change in immigration status? The U.S. government knew that many A, E, and G visa holders may want to eventually become U.S. citizens after spending time in the States. Section 247(b) of the INA, consequently, was enacted to provide these individuals some leeway.
Section 247(b) of the INA opens up an opportunity for an individual affected by § 247(a) to file a waiver "of all rights, privileges, exemptions, and immunities..." that would accrue to the individual vis-a-vis their occupational status. By submitting this waiver, the Attorney General does not adjust the individual's status as an "immigrant" to a "nonimmigrant." A resident employee of a foreign government who is, or becomes, eligible for an A, E, or G visa may file the §247(b) waiver in order to preserve their status as an immigrant and remain eligible for U.S. naturalization – if such individual desires, or believes that one day they may desire, to become a U.S. citizen.
The effect of such waiver, however, results in this individual losing their U.S. Income Tax Exemption as such exemption arises from their occupational status as a non-U.S. citizen employee and the individual, by signing the waiver, has waived all exemptions accruing from their occupational status. Fortunately, there are ways around the loss of the coveted U.S. Income Tax Exemption – mainly U.S.-Foreign government treaties. Many immigrants, however, who are unsure whether they actually want to become a naturalized U.S. citizen in the future find themselves in a tricky situation: to sign the waiver (and possibly lose their U.S. income tax exemption) or not to sign the waiver (and possibly lose their ability to become a U.S. citizen in the future).
International Individual
International-Individual
J-1 Exchange Visitor Visa
New Tax Law
B.J. Kang JD, CPA
Josh Portman JD, LL.M
Habeeb Syed JD
Nora Ji Li LL.M
The information contained on this web-site is not legal advice. The information may not reflect the most up-to-date legal developments. Unless otherwise indicated in writing, any US federal tax advice contained in this web-site is not intended to be used, and cannot be used to (i) avoid penalties under the US Internal Revenue Code, or (ii) promote, market or recommend to another party any matter addressed herein.
100 Daingerfield Rd., STE 101, Alexandria, VA 22314
3003 N. First St., San Jose, CA 95134 (CA Branch: KIC-SV)
Harvard Sq., 1 Mifflin Pl., STE 400, Cambridge, MA 02138 (MA Branch)
Telephone : 703-595-2836 Fax : 703-722-9168
Copyright © 2019 B.J. Kang Law, PC. All rights reserved.


Like many other websites on the Internet The Pirate Bay makes its money from ads. Due to its reputation the torrent site generally has to settle for lower grade banners, but the Canadian Government recently broke this trend. This week ads from the Canadian Department of Finance's Economic Action Plan appeared on The Pirate Bay. Unfortunately for the infamous torrent site, the feds pulled the banner campaign as soon as they were alerted to it.
The Pirate Bay is among the 50 most visited websites in Canada. Considering this popularity, it wouldn't be strange for the government to reward the site for its loyal service to the Canadian public.
However, the banner campaign for the Department of Finance's Economic Action Plan that went on display this week was not supposed to show up on The Pirate Bay.
The Ottawa Citizen reports that The Pirate Bay ran the ads but that the site wasn't targeted intentionally. Instead, the feds are quick to point the finger at one of the advertising networks they teamed up with.
"The Department of Finance did not purchase ad space on The Pirate Bay web site. We did however, include four ad networks in our media buy (Bell Media, Canoe, Microsoft, Yahoo)," The Department of Finance explains.
According to the Finance Department the advertising networks they work with follow strict guidelines and have "brand safety filters" in place. However, somewhere down the line a mistake was made and the feds point their finger at Yahoo.
"Each network confirmed that this site is not owned by them and that the appearance of the ad on this site is unauthorized. However, upon further research it was determined that some banner ads were appearing with an 'ad choices icon' which traces back to Yahoo," the department states.
However, Yahoo! say they have conducted a thorough investigation into the misplaced banner and conclude that actually Sympatico is to blame.
And so the finger pointing continues.
The Pirate Bay has witnessed the drama with a smile and has even considered plastering their entire site, especially the home page, with ads for Economic Action Plan. There's no way the Department of Finance can stop that.
But first they have to buy a boat and loads of rum using the Canadian tax dollars generated by the ads.


by GbsaasvgFaR » Wed Apr 24, 2019 7:55 pm » in Has Anyone Had a Success Using This Address?
by GbsaasvgFaR » Wed Apr 24, 2019 7:55 pm » in Is My Autograph Authentic?
by GbsaasvgFaR » Wed Apr 24, 2019 7:46 pm » in Has Anyone Had a Success Using This Address?
by GbsaasvgFaR » Wed Apr 24, 2019 7:45 pm » in Is My Autograph Authentic?
by GbsaasvgFaR » Wed Apr 24, 2019 7:43 pm » in Is This Address Still Up-To-Date?


There are days when I sit pensive and review things in my life. Yesterday was one of those. I'm not sure it's always a good idea to do this. Looking back I smile at the wonder I had as a child, the dreams I had as a teenager, the ambition I had as a young adult, the joy I had becoming a mother, the smiles my children gave me as they were growing up, and I remember how much I loved their father, and the reflection they gave me of that love for him.
So, one might think, with all those great memories, what is wrong with looking back on them? I suppose the combination, frankly, of admission of lack of knowledge of how to deal with what was not so good. Had I focussed on that first paragraph, would things have been different? Might I have alluded my eating disorder, and later my reliance on wine to tame the wild knots of stress in my stomach? Would I have made different choices and refused to try to please everyone, but instead simply please the needs inside of me, not all others' expectations of me?
Realistically the woulds and mights really mean nothing now. My children are growing up primarily with their father and friends, my husband (now ex) is loving someone else, and my ambitions have dried up. Gone are the days of wanting to make it in a man's world, of over-extended hours of volunteering, or over-extended hours of working. Gone are my needs to prove anything to anyone but myself. Found is a life of dogs, writing, reading, learning, solitude, in a quaint little apartment with little but my needs to provide for myself and my two little companions, Jenny and Rolly. Now a third, actually, Sparta my kitten. I am on-call for counseling for my children the odd day of the month. I am on-demand counseling for the other tenants in this farm house outside the surrounding cities. At 49 with several dreams I chased, and somehow caught, but watch fizzle into dust, I do not chase dreams anymore.
I stare quietly outside my window while I type and watch the cars drive by. I sometimes wonder how much time I have left on this earth, why I kept a squeezy-squeally plastic cow that sits on my desk staring back at me when I glimpse up. I wonder what steps I want to take forward, and it is a wonder because for the first time in my life I cannot see a path to take. Not even one less travelled.
Don't get me wrong. None of this is depressing. It's actually quite thought provoking. I have three copyrights waiting for a book to be completed, a cartoon character that can easily be sent out for publishing, I have empty canvasses and unopened paint waiting for an artistic hand to pass a brush across them. I have several books to read, incomplete knitting projects and sewing projects, a flute that has accumulated dust, a box of letters saved since I was 11 years old and a box of over 2000 pictures that need to be catalogued. I have friends to contact, and family too. I, however, have, in the past three months, remained quiet, complacent and thoughtful. For the past month, I have sent out resumes to non-demanding jobs, and become somewhat intrigued by shows on television that I really didn't care to watch before such as Dr. Phil, Anderson and Dragon's Den.
I wonder if I am doing this in search of my true self, or simply to take a time out from all the hustle and bustle my life projected in the first 49 years. The joy, the sorrow, the internal pain that I couldn't command that fell prey to bulimia and alcohol. Maybe now without either of those two crutches I'm actually realizing that maybe along the way there was something I missed. Maybe it was as simple as that first paragraph.
The following time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I imply, I do know it was my choice to learn, but I truly thought youd have one thing attention-grabbing to say. All I hear is a bunch of whining about one thing that you possibly can fix in the event you werent too busy looking for attention.
I feel I need to thank you for this comment, as this is the misconception most people have. If you actually took time to read more about this you would not be posting such a response. God Bless you and I hope that your ignorance on the subject can grow to understanding through not only this site, but many others out there.


text:
We remain committed to our Associates, partners and communities. Stay informed on our response to COVID-19.
Your Current Selection Global
For over a century, we've been driven by a belief that the world we want tomorrow starts with how we do business today. As a global, family-owned business, this idea remains at the heart of how we transform, innovate and evolve in ways that affirm our commitment to making a positive impact.
Our Principles form the foundation of how we do business today and every day.
Mars Compass
The Mars Compass serves as a guide to keep us on track and ensures we're heading in the right direction towards our vision of the world we want tomorrow.
No matter the visible or invisible differences, we have long-been committed to fostering an environment where everyone has an equal opportunity to reach their full potential.
Our global leadership team is responsible for building on our storied history while setting the vision for our path forward.
For more than five generations, Mars has evolved to create products and services that people (and their pets) love.
Every day is an opportunity to take action to create the world we want tomorrow. Our policies and practices are what help shape that future, and they're non-negotiable.
For generations, families and their four-legged friends have enjoyed our brands, products and services. Our Associates work tirelessly to ensure we deliver: A Better World for Pets™, Better Moments Make the World Smile, Better Food Today. A Better World Tomorrow and Better Lives Through Nutrition.
Pet nutrition, health, & veterinary services to make a better world for pets.
Some of the world's most beloved chocolates, treats and snacks that bring better moments and more smiles.
Healthy, tasty, affordable, convenient and sustainably-sourced meals shared on the dinner tables around the world.
Using the latest science, data, and technology to support human health through nutrition.
We're committed to helping create a safe, healthy and sustainable world for our partners and the communities in which we operate. It is the vision at the heart of our Sustainable in a Generation Plan - one where the planet is healthy, people and pets are thriving, and society is inclusive.
Sustainable in a Generation Plan
View progress & impact report
Water Stewardship
Transparency & Measurement
Full Potential for Women
Our Workplaces
Our Marketplace
See how our Associates are creating a better world tomorrow in our latest stories, news and press releases from around the globe.
Recently Searched Terms
All Mars
Featured Search Terms
Menu Search...
Mars Search
Mars Food
Mars Food Works to Deliver Better Food Today
We believe that a better world tomorrow is one where everyone has access to healthy meals, that is why we are introducing our first annual Purpose in Action report.
Better Cities For Pets™ Annual Report Highlights Seven Pet-Friendly Trends
FRANKLIN, Tenn. (November 5, 2019) – Today, Mars Petcare and its BETTER CITIES FOR PETS™ program released its first Annual Report, demonstrating how pet ownership is shaping our communities...
VCA Second Annual Impact Report Continues Legacy of Animal Care
VCA, a leading provider of pet health care services has released its second-ever impact report highlighting its top-of-the-line animal treatment.
VCA Hospitals Provide Pet Care & Improve Family Life
We believe that pets truly make the world a better place. That's why we're thrilled our second annual VCA Impact Report 2019 shows how we positively impacted the lives of more animals than...
Mars Wrigley Publicly Supports and Champions the Cocoa Living Income Differential
At Mars Wrigley, we are committed to creating a more modern, inclusive and sustainable cocoa supply chain for the next generations. But today's supply chain is not in line with our ambition...
New Banfield Pet Hospital Research Reveals One in Three U.S. Pets Is Overweight
Read about Banfield Pet Hospital's State of Pet Health Report, highlighting a widespread trend of overweight pets nationwide.
Health & Sustainability Commitments Results in New Report
Read Mars sixth annual Principles in Action Summary, spotlighting progress the company has made in sustainability, health and wellbeing, food safety, and more.
See how Mars is making sure everyone around the world enjoys a healthy, tasty, affordable, convenient & sustainably sourced meal. Food is more than what we eat.


As a responsible parent I have decided that I must come to terms with the fact that my beloved young one was born in the wrong body.
But today, I came home and found him in the bathroom, drinking from the toilet. That was the last straw, I may not think it was normal or right, but it was right for him.
Ha! Had me going in a different direction! Good play!
I don't think he's a dog. I do think he wasn't properly mentored by his mother. Maybe starting slow, like with da bird cat toy, you can teach him to love to chase mousies. As for the bathroom thing, he could just not like the kind of litter you buy. It happens!
he walks up to any stranger in the house and Meows, then runs if they try to touch him. I have used 4 types of litter, and still he would rather go in the back yard. the only thing he is more affraid of then mice is birds. he has 2 bird toy, but no intrest. I think he was inprinted by a dog, I got him from a shelter a while back, but its all good I love my orange meowing dog.
as long as you both are happy together… that's all that counts!
Drinking at work should be allowed.


The following press release was published by Lytro on 9 July 2015.
A clockwise two-finger gesture on the camera's Playback Screen opens the aperture to a maximum of f1; the opposite counter clockwise gesture tightens the Virtual Aperture to f16.
A single finger gesture can be used to select your refocus area. Pause slightly while touching the screen to start the Perspective Shift mode. By dragging on the Living Picture, the image's perspective will interactively shift on screen.
Native Editing in Adobe® Photoshop®: Streamline editing by exporting Living Pictures to Adobe®Photoshop® as editable image stacks, with individual layers, in one step. Edit any of the layers in Adobe®Photoshop® and save the file; those changes are then automatically applied to the Living Picture in Lytro Desktop.
Depth Map Editing: Living Pictures provide an additional option for personal creativity with the DepthMap. Depth Map editing allows light field photographers to make adjustments to depth (e.g., touch up in areas that may have been missed, clean up the contours of objects in the scene, remove artifacts orfix cloud and sky scenes) and see the results instantly without ever leaving Lytro Desktop.
Lenticular Printing: Lytro Desktop 4.3 can automatically export a series of images with a captured focus range for the creation of full color 3D prints by a lenticular print vendor. This allows viewers to see printed photographs in 3D without polarized or red/blue anaglyph glasses. The Lytro ILLUM 2.0 and Lytro Desktop 4.3 updates are free – as are all updates to the software and firmware for Lytro users – and available for download now. Visit Lytro.com for more information on these updates and more. See, experience and share Living Pictures at pictures.lytro.com.
Lytro is building the world's most powerful Light Field imaging platform enabling artists, scientists and innovators to pursue their goals with an unprecedented level of freedom and control. This revolutionary technology developed by Lytro will unlock new opportunities for photography, cinematography, virtual reality, scientific and industrial application. For additional information, visit Lytro.com.


text:
Kosovo's Political Coherence during Pandemics and Negotiations with Serbia
debate with Albin Kurti, former Prime Minister of the Republic of Kosovo
Albin Kurti, former Prime Minister of the Republic of Kosovo
Chaired by
Vessela Tcherneva, Deputy Director, ECFR
The European Council on Foreign Relations is delighted to invite you to an online debate on Kosovo's political coherence during pandemics and in the face of a re-start of the dialogue with Serbia.
Kosovo, like other regional countries has been hit hard by the COVID-19 pandemic and other accompanying political crises such as the toppling of a popular government and the Special Prosecutors indictment concerning the President of the country and a major political party leader. The current troubled political scene as well as the poor management of the pandemic have prompted many pundits to project yet another change of government. The already weak governing coalition has been showing signs of discontent on how to move forward, in particular with regards to negotiations with Serbia. The questions that need prodding are: can Kosovo mount the necessary political unity to face present challenges or are new early elections on the horizon? How can the EU support the process?
The debate will be on the record and held in English. Dial-in details will be provided after registration.


For more than 25 years, IntraHealth has collaborated with Uganda's government, national health associations, and health training institutions to strengthen the country's health workforce and improve health services.
Uganda has made notable progress in the past decade: decreasing poverty, reducing child mortality by half, increasing life expectancy, and almost doubling the modern contraceptive prevalence rate.
Yet the country is still far from its goal of universal health coverage. IntraHealth is working with the government and other partners to accelerate progress by increasing the number of health workers, maximizing the performance of the existing health workforce, and strengthening health service delivery to reach people most in need with high-quality care.
Develop and implement national- and district-level strategies and approaches that strengthen Uganda's health workforce and systems.
Help health training institutions increase their graduates and better prepare students for careers in health care.
Expand access to and use of high-quality health services to those most in need.
Use the power of data to advocate for greater funding for Uganda's health sector.
Develop and implement digital health solutions, including iHRIS, IntraHealth's open source data management software for the health workforce.
7,200 new health workers hired thanks to the power of data.
$20 million increase in funding for human resources for health.
168,000+ health worker records tracked and managed through iHRIS.
Helped 112 districts and 33 central organizations in Uganda develop and implement a human resource information system to track their health workers and identify workforce gaps. 97% of these organizations are now independently managing the system.
Helped Uganda to increase the number of filled positions in the health sector from 53% in 2009 to 73% in 2017.
Slashed unapproved absenteeism in Uganda's health workforce from 50% in 2015 to 11.9% in 2017.
Helped increase funding allocation in Uganda for human resources for health by $20 million, allowing hiring of new health workers and doubling the salaries for some doctors.
Successfully launched an SMS service to empower patients to verify that a clinic or a medical professional is registered and licensed in Uganda, helping people avoid "quack" practitioners.


Volkswagen Beetle Engine Fire - I realize that you're seeking articles on our blog within the headline Volkswagen Beetle Engine Fire of choices of articles that we got. If you are trying to find Volkswagen Beetle Engine Fire article and you fails to dwell right here, you can see from several of the articles that may suit your needs right down below. We are going to help you to get articles Volkswagen Beetle Engine Fire you're looking at some of our content which might be suitable as you are looking for the material.
Volkswagen Beetle Engine Fire - Volkswagen beetle - wikipedia, The volkswagen beetle—officially the volkswagen type 1, informally in german the käfer (meaning "beetle"), in parts of the english-speaking world the bug, and known by many other nicknames in other languages—is a two-door, rear-engine economy car, intended for five occupants (later, beetles were only allowed for four people in some countries), that was manufactured and marketed by german. Rebuilt vw air cooled stock beetle engine - gex international, Gex premium beetle engine stock long block vw beetle 1961-1979. early bus 1960-1971. squareback, fastback, notchback 1962-1973. the german engineered volkswagen line of vehicles are some of the most popular small passenger cars and vans in the world.. 2019 volkswagen beetle final edition marks beetle, The volkswagen beetle is bowing out for the 2019 model year with a commemorative final edition model. although the current version has nothing in common with the original, rear-engine beetle bar a. Vw engine & transmission - premium rebuilt volkswagen, Gex international is your connection for rebuilt volkswagen air cooled engines, vw transmissions, vw parts, vw performance engines, volkswagen diesel engines, volkswagen air cooled engines, rebuilt vw engines and air cooled vw engines. 1974 volkswagen beetle spark plug wire/ distributor cap, Firing order is 1-4-3-2. with the distributor cap off, turn the engine until a notch or mark in the pulley is at the top, lined up with the edge between the two sides off the engine case, and the rotor points toward a notch on the edge of the distributor base.. Vintage volkswagen beetle fuel pressure – 1967 vw beetle, Now, turn the engine by hand until the push rod is at its lowest height. it should extend above the fuel pump block by about 8mm. subtracting 8mm from 13mm, we reach the stroke value.. How check ignition coil aircooled volkswagen, How to check an ignition coil on an aircooled volkswagen beetle. before checking the ignition coil, ensure there is 12v going to the terminal 15 on the coil. note: terminal 15 is positive, terminal 1 is negative. turn your ignition switch. M & manufacturing - selling volkswagen parts , Our history. we have been manufacturing and selling classic volkswagen parts ever since 1975. we are approaching forty years of service to the volkswagen restorer!. Volkswagen beetle questions - flush motor, Yes i have used diesel but i don't recommend it. after you have cleaned out the oil pickup screen, put in a small amount of engine oil in each cylinder and turn it over by hand, then pop off the valve covers and check the valve adjustments and for water in there, replace the gaskets if they are not the good rubber ones, install new bosch spark plugs, clean the air filter assembly if it still.


The Elite Rifle is the most popular guard performance rifle on the market. The Elite Rifle's design and quality is ideal for both High school and College programs.
The new Elite color guard rifle is a hybrid of our popular Elite rifles. The Elite 5 gives you the presence of a larger rifle on the field while the slightly smaller and lighter weight allows performers of any size and strength to give a great toss.


Amount to be added to the character balance of the specified virtual currency. Maximum VC balance is Int32 (2,147,483,647). Any increase over this value will be discarded.
PlayFab unique identifier of the user whose virtual currency balance is to be incremented.
Name of the virtual currency which is to be incremented.


text:
Battle of Méribel
Title: Battle of Méribel
Subject: War of the First Coalition, 1793 in France, Battle of Marquain, Capture of Porrentruy, Siege of Maastricht (1793)
Collection: 1793 in France, Battles Involving Savoy, Battles of the French Revolutionary Wars, Conflicts in 1793
The Battle of Méribel took place at Méribel (now in Haute-Savoie, France) on 13 September 1793, when the forces of the Kingdom of Sardinia were defeated by the French Army.
In 1792, Revolutionary French forces had marched into Savoy to "bring freedom" to its people as part of the French Revolution. A decree annexing it to France was signed on 27 November of the same year, and it became the 85th département of France, renamed as the Mont Blanc département.
Following the execution of King Louis XVI, the French Revolution became widely despised and feared elsewhere in Europe. In 1793, the French Republic raised an army of 300,000 men, while only few Savoyards signed up for service. A much larger force of Savoyards, conducted by the Royalist camp attacked the French Army, and reconquered the Alpine valleys and Annecy.
Articles lacking sources from September 2007
United Kingdom, European Union, Italy, Canada, Spain
World War I, World War II, French Foreign Legion, France, Napoleonic Wars
War of the First Coalition
Spain, Kingdom of Great Britain, French Revolutionary Wars, Kingdom of Prussia, Portugal
1793 in France
France, 1793, History of France, 1792 in France, 1791 in France


Cyber Risk Management Archives - ABEX Affiliated Brokers Exchange Inc.
Funds transfer fraud – whereby fraudsters dupe innocent businesses and individuals into transferring what they believe are legitimate payments to fraudulent bank accounts – is becoming an increasingly common problem.
In an insurance context, most cyber policies with crime cover in place will provide some form of protection for situations where policyholders lose their own money in this way. For example, if a fraudster manages to impersonate the policyholder's CEO and gets a member of the finance team to send a payment over to a fraudulent bank account, the policyholder's business will have suffered a financial loss. All being well, this loss can then be recovered under their cyber policy.
However, it's not always the policyholder's business that suffers a loss in this way, but the policyholder's customers. Customer payment fraud describes a situation in which a business is impersonated by a fraudster, who then dupes some of the business's customers into making payments to a fraudulent account.
To make this concept a little easier to digest, let's take a look at a real-life example.
We recently dealt with a claim involving an insurance brokerage that is primarily involved in arranging property and casualty insurance cover for SME businesses. One of the brokerage's employees had their email account compromised by a fraudster, which allowed the fraudster to monitor the broker's inbox and identify an opportunity to misdirect funds. The broker had been working on the renewal of a package policy with one of the brokerage's existing clients and all that remained was for the client to transfer the premium over to the brokerage, who would then pass it on to the insurer.
Having chosen a suitable target, the fraudster then sent an email from the broker's account and explained that the premium would have to be sent to an international account due to an audit on the brokerage's usual account. Assuming that this was a legitimate request, the customer duly transferred the premium over to this fraudulent account. It was only when the broker chased the customer about the payment some weeks later that the scam was uncovered. This meant that the premium still remained unpaid, but as the fraudulent communications appeared to come from the broker, the customer put the blame on the brokerage and refused to pay the premium twice. Given this, the brokerage accepted responsibility for the incident and decided to pay their customer's premium from their own funds.
In this case, the primary victim of the loss was not the brokerage but their customer. As it wasn't the brokerage that was tricked into transferring funds, the crime cover on most cyber insurance policies would not be triggered, unless there is some form of specific cover for customer reimbursement in place. However, under CFC's cyber crime insuring clause, losses of this nature are covered up to a maximum of $50,000, providing a valuable safety net and helping to maintain good customer relations for policyholders who are impersonated in this way.
Click here to Read CFC's latest study about funds transfer fraud.


The Cougars got off to a brilliant start, executing strongly in the first half taking a 29-22 lead into the break. Carmel's JT Byrne was contained to 6 points on 2 of 5 shooting and HMB sizzled, making 12 of its first 22 shots committing only 3 turnovers in the half. This time, the field goal accuracy held up in the second half (11 for 22), but the defensive intensity fell off. The Cougars gave up thirty seven 2nd half shots to the Padres, many of which led to 2nd and 3rd chance baskets and committed ten 2nd half turnovers. Byrne responded with 16 second half points and finished with a game high 22 points on 9 of 16 shooting. He was complimented by Carmel's Joe Garella who made four treys and was 4 of 5 from the line in the 4th quarter to score 20. Leading the way for the Cougars was Mykola Ediger, whose stat line was 19 points on 7 of 15 from the field, 2 rebounds, 5 blocks, and 6 assists. Other Cougars in double digits were Ben McKnight with 14 and Sean Kennedy with 10. The Cougars are home again Saturday at Half Moon Bay High School with a tip off against Capuchino at 7:00pm.


I know Christmas hasn't even happened yet but my mind is already on New Years Eve. This year Bill and I are hosting our first married NYE party and I'm SO excited! This will not only be the first time some of our friends will be seeing the apartment but also our first real chance to use some of the entertaining pieces from our registry!
I'm a pretty traditional person who loves sending out invitations but sometimes you just either don't have enough time to print them and get them out to your guests. This happened to me this year because I was so focused on wedding planning that I instead decided to use Paperless Post and send e-vites instead! Now I know what you're thinking but I promise there are tons of adorable options and it doesn't in anyway make it less personal. Honestly I feel like friends like receiving these better because they can just reply either yes or (better not!) no right away and not forget to respond.
Paperless Post is a great option for all events though, we even used them for our rehearsal dinner so it was one less thing we had to run to the post office! You can also use them for custom baby shower invitations, surprise parties, BBQ and picnic parties, and one that I have used many times in the past and actually how I originally found Paperless post, charities and fundraisers. These are just a few of the many, many types of invitations to choose from.
What I love about Paperless Post though, is that just in case you didn't want to send out an e-vite, you still have the option to mail them as a paper card. This option would be great for say a baby shower where the friends of the mommy to be would love an e-vite but I don't think grandma would! You can still even send out matching cards!
Another great feature is you can save your address book so each year when it comes time to send out Christmas cards you don't have to retype any of the names, the lazy mans dream! You can also go back and see any invitations or cards that you have sent out in the past, as well as invites or cards you received. A great way to track your event calendar and make sure you never lose a party address again, since no one wants to have to be the person asking the host the day of "what's your address again?".
Making a bunch of delicious appetizers instead of a big meal. So much less work and planning and plus it makes it easier for friends to come and go as they please. On the menu will definitely be these adorable mini burritos and make ahead buffalo chicken pinwheels. The more things you can make ahead the better!
Cute and easy party favors, such as these 2017 crowns and noisemakers! Sorry neighbors!
For decorations I think we need this adorable balloon wall hanger. How cute is it?!
I cannot wait to use our new drink dispenser to make a festive cocktail!
Then, for whomever stays over I think we'll have to try out one of these waffle recipes the next morning!
This post is in partnership with Nakturnal but all opinions are my own. Thank you for supporting the partnerships that keep Sequins & Strawberries up and running!


text:
Insights: News Seven Kilpatrick Townsend Attorneys Recognized by Southern California Super Lawyers
LOS ANGELES (June 10) – Kilpatrick Townsend & Stockton announced today that seven of the firm's attorneys were recently recognized by Southern California Super Lawyers as either a Super Lawyer or a Rising Star.
Super Lawyers selects attorneys using a patented multiphase selection process. Peer nominations and evaluations are combined with independent research. Each candidate is evaluated on 12 indicators of peer recognition and professional achievement. Selections are made on an annual, state-by-state basis. The objective is to create a credible, comprehensive and diverse listing of outstanding attorneys that can be used as a resource for attorneys and consumers searching for legal counsel.
The seven Kilpatrick Townsend attorneys named include:
Raymond Aghaian is an experienced trial lawyer and former federal prosecutor focusing his practice on white collar criminal defense, cybersecurity, complex civil litigation, and internal investigations. As a federal prosecutor with the Cyber & Intellectual Property Crimes Section of the U.S. Attorney's Office in the Central District of California, Mr. Aghaian helped lead the U.S. Justice Department's efforts in investigating and prosecuting an array of white collar crimes. (Super Lawyer 2014-2019)
Caroline "Carrie" Barbee focuses her practice on all areas of intellectual property litigation and enforcement, including copyright and trademark infringement litigation, as well as registering, policing and enforcing trademarks and copyrights. In addition to litigating copyright and trademark infringement cases, Ms. Barbee has experience litigating general commercial disputes involving breach of contract, interference with contractual relations and prospective business advantage, defamation, false advertising and other forms of unfair competition. (Rising Star 2010-2019)
Mary Craig Calkins leads Kilpatrick Townsend's West Coast Insurance Practice, representing policyholders in high stakes litigation. Her extensive coverage experience includes directors and officers liability, professional errors and omissions, entertainment and intellectual property claims, cyber liabilities, e-commerce and technology claims, labor and employment claims, construction defects, first party property and business interruption losses, and broker liability issues. She also counsels clients on maximizing coverage under their policies. (Super Lawyer 2005-2019)
Brittany Elias Kandela focuses her practice on trademark portfolio and conflict management. She advises on issues relating to complex international trademark clearance and prosecution, foreign and domestic disputes, brand protection and litigation matters. She also counsels clients on a wide range of domestic enforcement issues, including both offensive and defensive disputes, and proceedings before the TTAB. (Rising Star 2017-2019)
Larry McFarland is the Managing Partner of the firm's Los Angeles office. He focuses his practice on litigation and counseling in all areas of intellectual property law, including copyright, trademark, rights of publicity and privacy, and unfair competition. Mr. McFarland has successfully represented start-up to Fortune 500 companies across a broad spectrum of industries. (Super Lawyer 2015-2019)
Dennis Wilson focuses his practice on complex litigation involving trademark, copyright, entertainment and Internet law issues. Mr. Wilson represents many of the world's largest media and technology companies creating and directing their international rights enforcement programs. He provides strategic counseling to businesses on a wide range of related issues including false advertising, idea submission, rights of publicity and unfair business practices. (Super Lawyer 2007-2018)
Kollin Zimmermann focuses his practice on intellectual property litigation, particularly cases involving trademark, copyright, unfair competition, false advertising, and trade secret claims, as well as related business disputes. Mr. Zimmermann has litigated cases in a broad range of industries, including apparel, consumer electronics, entertainment, and gaming. He also has substantial experience litigating matters involving e-commerce and other internet-based intellectual property issues. (Rising Star 2015-2019)
Follow the firm on Twitter: @KTS_Law.
Raymond O. Aghaian
Larry W. McFarland
Dennis L. Wilson
Caroline Y. Barbee
Brittany Kandela
Kollin J. Zimmermann
Cybersecurity, Privacy & Data Governance
Copyright Litigation & Counseling
Trademark, Copyright & Advertising
Seven Kilpatrick Townsend Attorneys Recognized by Southern California Super Lawyers


Welcome to the Pangea Source Guide. Here you can find a simple guidline which will help you to learn how to use the news agency aggregator tool made by Pangea. In case you have any questions or comments, please contact our Customer Care Team.
Pangea Source, ia news agency aggregator tool designed to help journalist to keep up-to-date on the latest news from prestigious agencies. Source is a responsive application, so you can access it from any device mobile, tablets or computers.
Source works with Azure (Microsoft Technology), meaning that the same login you use for the RFERL corporate e-mail is the same login you will use to access Source, this means one less password to remember.
Search: With the amazing amount of content Source provides,(archives from 1998) Source comes with a powerful full-text search, meaning you can type a word or a phrase and source will search for it across all the content.
Sources: Select one or multiple sources, the content will display the relevant results refined by the sources.
Search or clear refiners: once you are done selecting your refiners click the search button and the application will give you the most relevant content based on keywords and refiners, if you select clear filter criteria the system will clear the refiners and give you the latest news as a search result.
Share and bookmark your search refiners: have a set of refiners that covers your favorite sources, you can bookmark it or share url, this way you always will get the latest news from the selected Agencies.
Content: The application provide content from over 40 agencies around the world, it unifies all content parsed from emails, pdf, doc and HTML into a beautiful interface, where journalist can consume the content.
Beta Version: Source is in beta version, meaning there is still plenty of new ideas and features to come, please take a look and use it and let us know what are your thoughts, ideas etc.


text:
Visitors Guide to Kerrville, Texas
Kerrville, Texas - A Hill Country Find
Elizabeth R. Rose
Expert in cultural tourism, writing about the southwestern United States; also an award-winning photographer
Courtesy: Kerrville CVB
In the hub of the Texas Hill Country lies Kerrville, a purebred-Texas community of 20,000 which sits on the Edwards Plateau eco-region and is noted for its rugged country of stony hills, broad divides, rangy cedar, towering cypress and the beautiful Guadalupe River.
Kerrville lies 60 miles NW of San Antonio on I-10 and is 104 miles from Austin, 248 from Houston and 306 from Dallas, making a "trip to the Hill Country" easily accessible from all parts of Texas. Map
Sparkling spring-fed creeks meander through the rugged terrain and rolling hills of the Guadalupe River Valley, where the focal point is the wandering Guadalupe River, which roams through the valley overlooked by scenic hills and ranches.

Kerrville actually has a bustling downtown, where you can park the car and explore on foot, seeing a lot in a very short time. The original H.E.B. Grocery Store, famed Texas chain, began in Kerrville. Stand in front of 211 Earl Garrett and reflect that Mrs. C.C. Butt's Grocery Store was opened in 1916 with an investment of $50! Pick up a historical tour map and see where the Smokehouse, Arcadia Theatre, Pampell Opera House and Schreiner Dept. Store were housed.
Walk across the street and enter the Hill Country Museum (open Wed-Sat. 11:30-3:30), built in 1879 by expert masons and stone carvers from Germany for Capt. Charles Schreiner, a foremost and prominent developer of Kerrville. Notable is the parquet floor, made of ten hardwoods, and period furnishings and artifacts from the 1850s to 1930s. Ask your docent about the "tunnel" the Captain used to store money for his cowboys!
Next door, in the former post office, is the Kerr Arts & Cultural Center, where fifteen art and cultural groups have made this a premier art destination. It features changing exhibits throughout the year, highlighted by the Texas Furniture Makers Show each fall. Events are listed on Center's website.
Walk on down to Water Street and stroll through some of the galleries…a great choice is Rivers Edge Gallery at 832 Water St. Roxie the dog will "welcome you", and stunning western and contemporary art, prints, sculpture, carvings and more may entice you into a purchase. Find something you like and let their expert custom framer turn it into a personal treasure for you. Further on down, step back into time at Sunrise Antique Mall, another two-story old mercantile now housing dozens of antique vendors displaying and selling china, glassware, furniture, vintage clothing, books, Coca Cola memorabilia, art, and more. A smiling Rosetta is usually on hand to welcome you and listen to your tales of "we used to have one of these" as your prized purchase is rung up for a keepsake of the day.
You'll have time before lunch to head out to 1550 Bandera Hwy. to the Museum of Western Art. Wind your way past manicured grounds up to the entrance, where bronzed Western sculpture and the building's rugged timber and stacked limestone exterior lead you into 14,000 sq ft of gallery space, dedicated to the talented artistry of those whose passion it is to preserve the culture of the early west, Plains Indians, mountain men and more. The "Journey West" children's gallery will entice your youngsters to climb up into a real chuckwagon, crawl into a real teepee, peer into trunks filled with wagon supplies and learn about the long journey west from a youngster's viewpoint. Allow a minimum of an hour. This will surely be a highlight of your trip!
Hungry? You now have a decision to make, and it's a hard one! Great restaurants abound in Kerrville, and a dozen or more offer up views of the beautiful Guadalupe River, so take your pick and head west out of downtown onto Junction Hwy. How about some Northern Italian creations at Rivers Edge Tuscan Grille, surrounded on three sides with water views. Or try some home cookin' at the Lakehouse, or Billy Gene's specialties at BG's Steakhouse, or even Chili's or a quick stop at Starbucks? Further on down is Jazz, a Louisiana Kitchen, Guadalupe River Club, or rustic Café Riverstone, featuring savory creations such as pecan encrusted antelope. You won't make a bad choice. They're all good!
After lunch you have a few choices. Keep heading west out to Hwy 27 to FM 1340 for a very unique photo op in an unexpected place…. fascinating replicas of Stonehenge and Easter Island, erected in an open field. On the way back, stop at old Ingram loop and check out the galleries and boutiques…Clint Orms Silversmiths and Engravers showcases stunning silver buckles….ask who some of their famous clients have been – you'll be impressed!

Prefer to walk off lunch? Try the Riverside Nature Center, with self-guided nature trails wending their way down to the Guadalupe. Great for bird and butterfly watching, this center is dedicated to the natural resources of the Hill Country and features 150 species of wildflowers, cacti, and many native trees. Take time to walk inside the nature center and visit "Martha" the tarantula and "Lizzie" the snake, and check out the nature-based gift shop on site.
Maybe you're into hand crafted jewelry? Visit the headquarters of James Avery Craftsman, off of I-10 exit 505. The creations of Avery craftsmen are now sold in retail stores in some of the more upscale malls throughout the state. Visit the welcome center and watch the 15-minute video explaining the history, then view craftsmen creating stunning pieces. Of course, there's a retail shop … take home a treasure!
Worth the short drive is Camp Verde, where you'll find the Camp Verde General Store, just 10 miles south of town near the intersection of Hwy 173 and FM 480. Back in 1854, then Secretary of War Jefferson Davis commissioned Congress to appropriate funds for an experimental operation to use camels for military transport. Learn what happened between 1856 and 1865 and what became of the camels. For over 150 years, this has been a general store and post office, so take time to mail a postcard and have fun exploring the wide array of specialty gift items, jewelry, t-shirts, candles and more, then refresh yourself with a cold drink or ice cream before you head out of town.

There's much more... golfing, tennis, Kerrville-Schreiner Park, the famed Y-O Ranch, riding, biking, canoeing or kayaking on the Guadalupe River, wildlife and birdwatching, and more. Make this a hub and explore other Hill Country areas such as Fredericksburg, Bandera, Boerne or San Antonio. See for yourself why Kerrville has such a high repeat visitor rate…it is a result of people truly "losing their heart to the hills."
Information Courtesty Kerrville Convention and Visitors Bureau
Where to Find Wildflowers in the Texas Hill Country
Great Things to See in the Texas Hill Country
The Best Neighborhoods in Fort Worth
The Top 10 Things to Do in San Francisco's Presidio
The Best Hikes Near San Antonio
Where to Go Shopping in San Antonio
Best Things to Do During Winter in Texas
Best Day Trips to Take From San Antonio
Fun Things to Do With Kids in the Texas Hill Country
The Top 10 Neighborhoods in San Antonio
The Best Time to Visit San Antonio
3-Day Wildflower Itinerary
San Antonio Guide: Planning Your Trip
Popular Things to Do in Austin
10 Hill Country Towns With Festive Holiday Lights and Events
The Complete Guide to the San Antonio Riverwalk


text:
Q: TSQL Replicating LAG() function with dynamic offset I'm trying to recreate the LAG() function without using LAG() but has a dynamic Offset that is dependent on a column.  I'm going to copy this code into SparkSQL.
Here is my sample data:
if object_id('tempdb.dbo.#myTable') is not null drop table #myTable
create table #myTable (id int,dates int, flag char, FromToFlagType varchar(2),FromToCounter INT)

insert into #myTable values(1,  '20181031','V','VV',1)
insert into #myTable values(2,  '20181130','V','VV',2)
insert into #myTable values(3,  '20181231','V','VV',3)
insert into #myTable values(4,  '20190131','F','VF',1)
insert into #myTable values(5,  '20190228','F','FF',2)
insert into #myTable values(6,  '20190331','F','FF',3)
insert into #myTable values(7,  '20190430','F','FF',4)
insert into #myTable values(8,  '20190531','V','FV',1)
insert into #myTable values(9,  '20190630','V','VV',2)
insert into #myTable values(10, '20190731','V','VV',3)

id  dates       flag    FromToFlagType  FromToCounter
1     20181031    V           VV                1
2     20181130    V           VV                2
3     20181231    V           VV                3
4     20190131    F           VF                1
5     20190228    F           FF                2
6     20190331    F           FF                3
7     20190430    F           FF                4
8     20190531    V           VF                1
9     20190630    V           VV                2
10  20190731      V           VV                3

So what I want to do is to replicate the following result, but without using a dynamic Offset:
select
  *
  ,LAG(FromToFlagType,FromToCounter-1) OVER ( ORDER BY dates) AS FromToStage
from
  #mytable

id  dates     flag  FromToFlagType  FromToCounter   FromToStage
1     20181031  V             VV              1             VV
2     20181130  V             VV              2             VV
3     20181231  V             VV              3             VV
4     20190131  F             VF              1             VF
5     20190228  F             FF              2             VF
6     20190331  F             FF              3             VF
7     20190430  F             FF              4             VF
8     20190531  V             FV              1             FV
9     20190630  V             VV              2             FV
10  20190731    V             VV              3             FV

I know that you can replicate LAG() with CTE and JOIN, but it seems to only work if you know ahead of time what the offset is going to be. I've tried something similar here, but I'm just not able to get the same result.
I've found something similar here, but I'm new to Spark and I need a solution what uses SparkSQL. I figured that if I can just replicate the function that I can copy it over to 'Spark'.
WITH FromToStage AS(
select
    *
    ,id-(FromToCounter-1) AS id_2
    from #mytable
   --order by dates
)
SELECT
  a.*
  ,b.FromToFlagType as FromToStage
FROM
  FromToStage a
    JOIN
  FromToStage b
  ON
  a.id = b.id_2
order by dates

A: Based on your logic, you want first_value()
select t.*,
       first_value(FromToFlagType) over (partition by seqnum - seqnum_2 order by date)_ as first_FromToFlagType
from (select t.*,
             row_number() over order by date) as seqnum,
             row_number() over (partition by flag order by date) as seqnum_2
      from #mytable t
     ) t;

redpajama_set_name: RedPajamaStackExchange


text:
With the introduction of the [Doctrine 2 ORM](http://www.doctrine-project.org/) a start was made to integrate parts of the [Symfony 2 framework](http://symfony.com/). The ORM took over all of the database write/delete/update queries and some of the read queries. So reducing the amount of legacy code already

The first step was to introduce an AppKernel with a Janus CoreBunde for Janus dependencies, a SSPIntegrationBundle for integration with [SimpleSamlPhp](https://simplesamlphp.org/) and various vendor bundles like the [DoctrineBundle](https://github.com/doctrine/DoctrineBundle). This also introduced a few new directories:
- `app`: The Symfony application and config
- `src`: The new domain and Symfony bundle code

Since the first attempt to use Doctrine was done without using Symfony a separate Dependency injection container based on [Pimple](http://pimple.sensiolabs.org/) was added, part of this still remains

The second step was to add REST functionality which added another dir
- `web`: The Symfony app index file

The 3rd step was to combine all the existing configuration of Janus and the new Config which came with Doctrine and Symfony. The existing config was a php file located in the SimpleSamlPhp `config` dir. The Symfony config was in Yaml files located in the `app\config` dir (and the various bundles).
The chosen solution was to adapt the Symfony config style which meant that the existing Janus configuration had to be converted to Yaml. This was also an ideal oppurtunity to change the format of some configuration to a more desired format. In some cases this was even demanded by symfony. All config will now be parsed by Symfony so a [config definition](https://github.com/janus-ssp/janus/blob/develop/src/Janus/ServiceRegistry/Bundle/CoreBundle/DependencyInjection/Configuration.php) had to be created. this configuration is currently quite basic but could be improved by adding more default values, validation rules etc.

Converting existing configurations from php to yaml can be automated by using the `bin/migrateConfig` command.

## Present

Currently two codebases exist more or less next each other sometimes with confusing directory names: `www` versus `web` or `lib` versus `src`. All new code is namespaced using the [PSR-2 standard](https://github.com/php-fig/fig-standards/blob/master/accepted/PSR-2-coding-style-guide.md)

## Future

All legacy code should be gradually refactored to blend in the new style of code. This means:
- All classes in the `lib` dir should be evaluated and combined/split up where needed and at least conform to the PSR-2 coding standard. Furthermore they need to be tested, this will probably introduce some injection refactoring.

These are the parts that currently remain in the `lib` dir:

# Symfony integration

## Past

With the introduction of the [Doctrine 2 ORM](http://www.doctrine-project.org/) a start was made to integrate parts of the [Symfony 2 framework](http://symfony.com/). The ORM took over all of the database write/delete/update queries and some of the read queries. So reducing the amount of legacy code already

The first step was to introduce an AppKernel with a Janus CoreBunde for Janus dependencies, a SSPIntegrationBundle for integration with [SimpleSamlPhp](https://simplesamlphp.org/) and various vendor bundles like the [DoctrineBundle](https://github.com/doctrine/DoctrineBundle). This also introduced a few new directories:
| `app`: The Symfony application and config
| `src`: The new domain and Symfony bundle code

Since the first attempt to use Doctrine was done without using Symfony a separate Dependency injection container based on [Pimple](http://pimple.sensiolabs.org/) was added, part of this still remains

The second step was to add REST functionality which added another dir
| `web`: The Symfony app index file

The 3rd step was to combine all the existing configuration of Janus and the new Config which came with Doctrine and Symfony. The existing config was a php file located in the SimpleSamlPhp `config` dir. The Symfony config was in Yaml files located in the `app\config` dir (and the various bundles).
The chosen solution was to adapt the Symfony config style which meant that the existing Janus configuration had to be converted to Yaml. This was also an ideal oppurtunity to change the format of some configuration to a more desired format. In some cases this was even demanded by symfony. All config will now be parsed by Symfony so a [config definition](https://github.com/janus-ssp/janus/blob/develop/src/Janus/ServiceRegistry/Bundle/CoreBundle/DependencyInjection/Configuration.php) had to be created. this configuration is currently quite basic but could be improved by adding more default values, validation rules etc.

Converting existing configurations from php to yaml can be automated by using the `bin/migrateConfig` command.

## Present

Currently two codebases exist more or less next each other sometimes with confusing directory names: `www` versus `web` or `lib` versus `src`. All new code is namespaced using the [PSR-2 standard](https://github.com/php-fig/fig-standards/blob/master/accepted/PSR-2-coding-style-guide.md)

## Future

All legacy code should be gradually refactored to blend in the new style of code. This means:
- All classes in the `lib` dir should be evaluated and combined/split up where needed and at least conform to the PSR-2 coding standard. Furthermore they need to be tested, this will probably introduce some injection refactoring.

These are the parts that currently remain in the `lib` dir:

| Dir/File | Todo/Desc. |
|----------|-----|
| `Cron` | Not used by OpenConext, if no other users use it remove it |
| `Exception` | Just move somewhere in `src` dir |
| `Exporter` | Apart from this export there are also the new REST API, the Janus Tools, see if this is still needed. |
| `Messenger` | Not used by OpenConext, if no other users use it remove it |
| `Metadata` | Metadata converter, already a bit more modern, is used for importing (which is currently broken) |
| `REST` | Old API can be removed when the new API is approved (almost!) |
| `Validation` | A bunch of basic validation functions, can be easily translated to proper validators |
| `Xml` | A converter for xs:duration to unix timestamp., according to @relaxnow this is no longer necessary |
| `AdminUtil.php` | A bunch of connection related queries which need to be move to the connection service and repository |
| `CertificateFactory.php` | A factory for certificates, can probably be moved to the [x509 validate lib](https://github.com/janus-ssp/php-x509-validate)|
| `CustomDictionaryLoader.php` | A workaround for adding extra translations to a SimpleSamlPhp based template, can be removed if no templates use this anymore |
| `Database.php` | Base class for classes which do not (fully) use the ORM yet, can be removed when this is resolved |
| `DiContainer.php` | Di container which is used to get dependencies of which the most already defer to the Symfony service container. Can be removed when all requests are run through symfony AND all dependencies are properly injected an [issue](https://github.com/janus-ssp/janus/issues/453) for this has been created. |
| `Entity.php` | An 'active record' like implementation for connections, should be merged with the existing service and repository and replaced with a DTO |
| `EntityController.php` | A 'active record factory'?! style implementation for connections, should also be merged with existing service and repository |
| `Exporter.php` | Part of the Exporter package, see above. |
| `Messenger.php` |Part of the Messenger package, see above. |
| `MetaExport.php` | |
| `Metadata.php` | A Write DTO like object for metadata information, it's functionality should be moved elsewhere to make it a real DTO. A `sspmod_janus_Metadata` object is constructed based on `sspmod_janus_MetadataField` object |
| `MetadataField.php` | A Read DTO like object for metadata information, it's functionality should be moved elsewhere to make it a real DTO. |
| `MetadataFieldBuilder.php` | A Builder for building Metadatafield objects |
| `Postman.php` | A notifier which notifies when a new user has been created. Not used by OpenConext, might be removed.  |
| `User.php` | An 'active record' like implementation for users, should be merged with the existing service and repository and replaced with a DTO |
| `UserController.php` | A bunch of use AND connection related queries which should be moved to their corresponding services and repositories. |

Aside from classes there are is also a frontend part which is located in the `www` and `templates` dirs. This part also needs refactoring. A general remark is that most files in the `www` dir are more or less page scripts, some are quite big, others are bigger. However the most important thing would be to move all routing to symfony. This could be achieved by wrapping the contents of the page scripts in Symfony controllers and gradually extracting business logic out of it.

Page scripts to controllers

| File                               | Split up | Extract functions | Extract classes | Desc. |
| -----------------------------------|----------|-------------------|-----------------|-------|
| AJAXRequestHandler.php             | X        | X                 | -               | Ajax handler for all pages that use ajax, this functionality could be split up into various 'postAction' controller methods |
│ dashboard\connections.php          | -        | -                 | -               | Shows a list of (filterable connections *Could be replaced by the [GuiBundle](https://github.com/janus-ssp/ServiceRegistryGuiBundle)  which also offers a list of connections already using ORM and Twig* |
| dashboard.php                      | X        | X                 | -               | Shows various tabs and needs to be split up per tab and maybe even more granular |
│ editentity\arp.php                 | -        | -                 | -               | Shows tab to edit an connection ARP |
│ editentity\revisions.php           | -        | -                 | -               | Shows a tab where a connection revisions can be compared|
| editentity.php                     | X        | X                 | -               | Shows various tabs regarding editing connections and needs to be split up per tab and maybe even more granular  |
| exportentity.php                   | -        | -                 | -               | Shows a page to export a connection |
| get-entity-certificate.php         | -        | -                 | X               | Outputs connection certificates as json |
| get-entity-endpoints.php           | -        | -                 | X               | Outputs connection endpoints as json |
| get-entity-metadata-validations.php| -        | -                 | X               | Outputs validation of connection metadata as json      |
| history.php                        | -        | -                 | -               | Shows the history of a connection |
| importentity.php                   | X        | X                 | -               | Shows page where connection can be imported and handles import data |
| _includes.php                      | -        | -                 | -               | Can be replaced by composer autoload |
| index.php                          | -        | -                 | -               | -     |
| metadataexport.php                 | X        | -                 | -               | Shows page where connection can be export and builds export |
| metalisting.php                    | X        | -                 | -               | Not cleat what this does however it cannot handle large amounts of Connections (timeout) |
| newUser.php                        | -        | -                 | -               | Page where a new user can be created     |
| noNewUser.php                      | -        | -                 | -               | Error page for new user cannot be created automatically |
| previewfile.php                    | -        | -                 | -               | Shows preview of uploaed file |
| services/rest/index.php            | -        | -                 | -               | Can be removed when the new API is in production |
| show-entities-validation.php       | -        | -                 | -               | Shows a page where connections can be validated |
| util/upgrade.php                   | -        | -                 | -               | very old upgrade script, if it is kept it should be moved somewhere else|

All templates are php files based on the SimpleSamlPhp template. These could be split up since some templates contain code for a lot of different purposes (tabs). Each template could then be freed from it's SimpleSamlPhp dependency and converted to a more simple format like [Twig](http://twig.sensiolabs.org/) html which is also the defactor Symfony template engine.

Some templates also contain a lot of javascript, this could be extracted to separate files.

| Dir/File                     | Split up | Extract Js/Css | Convert to Twig |
|------------------------------|----------|----------------|--------|
| dashboard\connections.php    |  -       | -              | X      |
| dashboard.php                | X        | X              | X      |
| editentity\arp.php           | -        | -              | X      |
| editentity\history.php       | -        | -              | X      |
| editentity\whiteblacklist.php| -        | -              | X      |
| editentity.php               | X        | X              | X      |
| error.php                    | -        | -              | X      |
| metadataexport.php           | -        | X              | X      |
| metalisting.php              | -        | -              | X      |
| nonewuser.php                | -        | -              | X      |
| importentity.php             | -        | -              | X      |
| metadata.php                 | -        | -              | X      |
| newuser.php                  | -        | -              | X      |
| show-entities-validation.php | -        | -              | X      |

redpajama_set_name: RedPajamaGithub