text:
Thursday, May 23, 2013 ... / /
By the number of mathematical papers he wrote, Augustin-Louis Cauchy was second just to Leonhard Euler. As many college freshmen may testify, more theorems and concepts in mathematics were named after Cauchy than anyone else. And a conservative theoretical physicist shouldn't omit a CV of Cauchy because Cauchy was... well... very conservative!
He died on May 23rd, 1857, i.e. exactly 156 years ago. But before he managed to do that, he had to do many other things. For example, he had to be born – in August 1789, just a month after Bastille was stormed by a crowd on the street, a mess we often call the beginning of the French Revolution.
Louis François Cauchy, i.e. Cauchy's father, had really nothing to do with this mess. He was a high official in the Parisian police before the revolution took over (during the "New Regime"). During the Reign of Communist Terror in 1794, when Cauchy was five, the family had to move to Arcueil. Things got safer when Robespierre – a guy who worked to transform bourgeoisie to a gang of leftwingers – was finally executed in 1794 and the family could return. When Napoleon took over 5 years later, Cauchy's father returned to police.
He was working directly under another high-tier policeman called Pierre-Simon Laplace who is today known, ehm, as a top mathematician. Joseph Louis Lagrange was well-known to the Cauchy family, too.
In fact, Lagrange advised Cauchy's father to enroll his son into the Central School of Pantheon. And no, Lagrange didn't want Cauchy to learn some proper mathematics. Due to uncle Lagrange's advices, Cauchy was supposed to learn classical languages and humanities. And he has won many prices in Latin and humanities, indeed. But despite the attempts by Lagrange to direct young Cauchy to this sissies' stuff, he chose an engineering career. In 1802, he scored among top 1% of the applicants to École Polytechnique and was accepted. He had some problems with the military-style rules in the school but he finished the school when he was 18, with the highest honors, and continued with civil engineering at the School for Bridges and Roads.
When he was 21, he already started to work as an engineer as well as a manager at something that Napoleon intended to become a naval base, Cherbourg. He had enough time to work on mathematical papers, anyway. His first two manuscripts on polyhedra were accepted; the third one on conic sections was rejected.
When he was 23, he realized he was overworked and the engineering job sucked, so he returned to Paris. He formally remained an engineer but was working for the ministry of interior and was on an unpaid sick leave etc. More importantly, he would work on higher-order algebraic equations, symmetric groups, symmetric functions, and the other Galois-like stuff (Évariste Galois himself was just an infant at that moment!).
In 1815, Napoleon was defeated in Waterloo – just to be sure, the place is very far from the Perimeter Institute – and Bourbon king Louis XVIII led the restoration attempts. So at the Academy of Sciences, mathematician Gaspard Monge and thermodynamics pioneer Lazare Carnot had to be fired for political reasons while Cauchy could have been hired for the same reasons. ;-)
Cauchy accepted but because a big part of the academic establishment was already composed of politically correct, left-wing activists, the reaction of his peers to his acceptance was harsh. He earned many enemies. In 1815, Cauchy could finally quit the engineering job and take the professor chair at École Polytechnique after Louis Poinsot who left for health reasons. Before that, Cauchy had already proven Fermat's polygonal number theorems. Many liberal activists could have been fired from the Bonapartist school while conservative Cauchy – whom Wikipedia calls "reactionary" – could be promoted.
He was living with his parents when he was 28 but his dad found a wife for him – a babe from a family that published most of Cauchy's writings. They had two daughters. Incidentally, Cauchy had brothers who became lawyers and one of them partly a mathematician, too.
As a mathematical factory, Cauchy flourished in the mid-to-late 1820s because he was lucky to live in a conservative political atmosphere. In 1824, Louis XVIII died and was superseded by an even more right-wing king, Charles X, which made Cauchy even more happy and more productive. He was also teaching at several schools simultaneously.
Things changed discontinuously in 1830. Charles X had to flee and the leadership was hijacked by a non-Bourbon king Louis-Philippe. Riots involving ignorant students took place near Cauchy's home. It had to be really annoying. Cauchy's lust to publish papers went nearly to zero – it's similar to my year around 2005 except that I had to be satisfied with a "relative conservative" in the form of Larry Summers who was finally removed in 2006. ;-)
Cauchy went to exile. In Switzerland, they still wanted him to endorse the new regime. He refused so he lost all positions he had in France. He went to Turin, Italy in 1831 and became a foreign member of the Royal Swedish Academy of Sciences.
Prague in 1830
In 1833, Cauchy moved to Prague in my homeland, the Austrian Empire ;-), to become a tutor of Henri of Artois, a spoiled brat from an aristocratic family. Back in Paris, Cauchy was already a bad lecturer and his teaching style resembled that of Sheldon Cooper. These difficulties escalated with young Henri who had no respect for Cauchy, mathematics, or anything of the sort, so even though Cauchy took the job very seriously, it was a disaster. The two main results of this tutoring was that an irrelevant Henri became a life-long math hater; and Cauchy hadn't done any research for 5 years. In 1838, he returned to Paris with his family that had been accompanying him in Prague since 1834.
He couldn't return to teaching – formally because he refused to endorse the new regime – but he badly wanted to be formally recognized by the science establishment in Paris again. He decided to get "there" though the Bureau to Determine the Longitude. He didn't need the oath so he was elected but the king was refusing to approve him for 4 years in which Cauchy was getting no money and had no academic rights (e.g. submitting papers). After that, Cauchy was eliminated altogether and replaced by Poinsot. Note that the opposite replacement was discussed above.
Throughout the 19th century, France was converging towards the separation of state and church, entities that Cauchy always wanted to unify. He became an enthusiastic Jesuit and officer in various Catholic and Jesus Society institutes. His colleagues would have full mouths of non-discrimination and so on but when this top mathematician of the French history applied for an ordinary chair in mathematics, he got just 3 out of 45 votes. Leftwingers have been a biased scum for at least 150 years.
The pan-European revolution of 1848 was mostly good news for Cauchy. The oath was removed from the law and he could regain the professorship again. He died on this day in 1857, sort of respected again. His name is one of the 72 names inscribed into the Eiffel Tower.
In his early career, he made lots of advances about the Appolonius problem of circles touching three other circles; Euler's formulae for polyhedra; he introduced the notion of convergence, and other things. He was quickly becoming a pioneer of mathematical analysis – that's the part of maths dealing with functions, sums, integrals, derivatives, and... (this is why it's more advanced than just calculus – which is otherwise almost the same thing) with all kinds of limits.
He also made contributions to physics – wave mechanics (Fresnel's wave theory) and elasticity (Cauchy stress tensor). Add various things about membranes, vibrations, and so on. I have already mentioned the Fermat polygonal number theorem.
When it comes to mathematical analysis, he really laid the foundations of the holomorphic functions of complex variables, e.g.\[
\oint_C f(z)\dd z = 0
\] if there are no singularities inside the closed contour \(C\). Seeds of this theorem already existed in 1814; the complete form was given in 1825. He figured out how to compute residues either from limits determining the Taylor expansion; or from the contour integrals. Pierre-Alphonse Laurent was the first man after Cauchy who contributed to this essential mathematical knowledge (Laurent series in 1843).
Cauchy tended to praise the mathematical rigor. Already in 1821, he was working with the infinitesimals – formally infinitely small numbers – but he was the first visible guy to have introduced the \(\varepsilon\)-\(\delta\) gymnastics (games with limits) as the rigorous incarnation of the infinitesimal numbers.
It's an excessive task to enumerate everything that Cauchy has done in mathematics. I find it sort of funny to copy-and-paste a list of insights named after Cauchy:
Binet–Cauchy identity
Cauchy's argument principle
Cauchy–Binet formula
Cauchy boundary condition
Cauchy condensation test
Cauchy's convergence test
Cauchy (crater)
Cauchy determinant
Cauchy's equation
Cauchy–Euler equation
Cauchy functional equation
Cauchy formula for repeated integration
Cauchy–Frobenius lemma
Cauchy–Hadamard theorem
Cauchy horizon
Cauchy's integral formula
Cauchy's integral theorem
Cauchy interlacing theorem
Cauchy–Kovalevskaya theorem
Cauchy matrix
Cauchy momentum equation
Cauchy–Peano theorem
Cauchy principal value
Cauchy problem
Cauchy product
Cauchy's radical test
Cauchy–Riemann equations
Cauchy–Schwarz inequality
Cauchy sequence
Cauchy surface
Cauchy's mean value theorem
Cauchy stress tensor
Cauchy's theorem (geometry)
Cauchy's theorem (group theory)
Euler-Cauchy stress principle
Maclaurin–Cauchy test
Let me remind you: this guy was voted as unworthy the chair of an ordinary scholar in mathematics by 42 out of 45 self-described "pro-Enlightment" researchers in mathematics. Certain left-wing portions of the Academia have been rotten for centuries.
And that's the memo.
Vystavil Luboš Motl v 10:54 AM | |
Other texts on similar topics: France, mathematics, science and society
reader George Christodoulides said...
May 23, 2013, 10:40:00 PM ...
Yea, I like this funny post too :-)
Even though the fact that so many people who should have known better did not acknowledge this bright awesome Mathematician for stupid political reasons that have nothing to do with science, is rather annoying...
If I remember correctly, Sheldon's teaching methods are fun :-D
May 24, 2013, 1:17:00 AM ...
reader R2D2 said...
Poor Lubos, it seems like you wake at night screaming "the left-wingins are knocking at my door". Just let it go, you will be fine.
reader yovisto.com said...
Cauchy really was an extraordinary mathematician! Thanks for your list of mathematical concepts named after him. Yesterday (August 21) was Cauchy's birthday, and we have also dedicated an article to him in our 'Daily History of Science, Technology, and Arts' Blog. If you are interested in our article on Cauchy, you will find it here: http://yovisto.blogspot.de/2013/08/augustin-louis-cauchy-and-rigor-of.html
Aug 22, 2013, 9:28:00 PM ...
reader lucretius said...
This is a an entertaining and quite accurate account of Cauchy's life and mathematical achievements. The part about politics is a little anachronistic. In particular Cauchy's favourable treatment at the time of the restoration was primarily due to the fact that he was about the only famous scientist and mathematician who was not considered very close to Napoleon. Monge, Laplace and Lagrange were personal friends of the emperor, who was an excellent mathematician and keenly interested in science. Laplace, in fact, was Napoleon's examiner at the Ecole Militaire in Paris and wrote a fascinating report in which he characterized the young Corsican as "very applied to the study of the abstract sciences, little curious as to the others…".
Napoleon (who was of course trained as an artillery officer) was able to converse with great mathematicians on almost equal terms. There is a well known and story of during the campaing in Egypt Napoleon told Laplace and Lagrange about Mascheroni constructions. (Mascheroni proved that any construction that could be performed with compass and straighedge can be performed with compass alone). Napoleon learned about this during his Italian camaping (which made him famous). It is sometimes claimed that he even visited Mascheroni who was gravely ill and died soon afterwards). Apparently Laplace and Lagrange were quite surprised by these results and exclaimed "general, the last thing we expected from you was a lecture on geometry".
Anyway, because Napoleon heaped favours on Monge, Laplace, Lagrange, Fourier , Poisson and others (he even made Laplace minister of interior for a year), they all found themselves in various degrees of disfavour after the restoration. This provided an opportunity for Cauchy, whose family was well know for its royalist sympathies. In spite of that Cauchy's father was made a senator under Napoleon - but he was also able to keep that post under the Bourbons. That helped Cauchy to become a member of the Academy, which he was unable to do before, in spite Laplace's support (Cauchy was still very young and the competition was tough).
Now to redress a little the balance on Cauchy himself I will just quote (or rather translate from Russian) a passage from an article entitled "What is mathematics" by one of my favourite 20th century mathematicians Vladimir Arnold. In this passage he is writing about Abel, but Cauchy also makes an appearance ;-)
"The works of Abel, connecting so many different areas of mathematics were submitted by him for publication to the Paris Academy of Sciences, which asked Cauchy to assess them. As the result Abel's texts were lost for many years, becaue the Academy found itself unable to assess them due to their "excessive novelty" (in exactly the same way the Academy and Cauchy dealt a few years later with the works of Galois). "
There is also a footnote: "Abel complained that French mathematicians only want to teach but do not want to learn anything themselves: one of them is only interested in his celestical mechanics (Laplace), the second only in elasticity theory (Poisson), the third only in the theory of heat (Fourier) and Cauchy only thinks about his own priority in solving all of the world's problems (including Fermat's problem).
The last passage is unrelated to Cauchy but so interesting that I have decided to quote it anyway:
"The French also wrote in a newspaper when Abel finally left for home, that the pauper who had lived in Paris was so poor that he had to return to his part of Siberia known as Norway, on foot, by walking across the Atlantic Ocean on ice. Actually Abel returned on one of the first steam ships and had enough money to pay for his ticket."
Aug 22, 2013, 11:18:00 PM ...


Breaking through the "glass ceiling"
The glass ceiling describes the restraints that inhibit women rising to the rope levels, without there being active discrimination by employers. Discrimination against women still does present itself every now and then in the corporate space.In a study done by Procurement leaders in 2017, of the 1300 professionals that were surveyed, only a tenth were females that occupied senior/management positions. Which leads me to the question of whether or not most management positions are being reserved for males and why that is still the case in this new age where women have proved themselves equally capable and able over the years.
Do you believe the"glass ceiling" concept still exist for women in the workplace? Why or why not?
Definitely glass ceiling still exists everywhere even in Jamaica, the country that tops the charts on having the most number of women executives. Based on interviews with women from Jamaica, they still believe that a lot should still be done, especially in the male-dominated industries like manufacturing.
I work for a Fortune 500 company. Fortunately for me, our company supports diversity very much. The ratio of male to female employees is almost 1:1. There are countries where the country managing head is a woman.
Yes, I think to an extent there is still a level of prejudice in a sense that men are promoted more quickly than women with equivalent qualifications, even in traditionally female settings such as nursing and education.
From personal experience this is not true of all professions. The medical profession is one example where having children as a doctor, nurse, physio etc. will not necessarily hinder your chances of advancement. The glass ceiling is removed if women choose not to have children in many cases but this is hardly encouraging.
Agree. I want to add the fact that although Jamaica has the highest percentage of female managers, most of the female managers are in middle management, only 24% in top management. So, still a long way to go.
I believe it still exists. The company I work for has more men executives. Women are given positions that are more prone to criticisms. It's like you're already expecting them to fail.
The glass ceiling as a concept seems obsolete faced with the tangled reality of women in the workplace in the wake of feminism. More and more women are competing for the same positions as men and giving them a run for their money, rightfully so.
We really need to break all those barriers. We need more women on top management so that there can be more opportunities for women to enter the workplace. We can only count on women to create company policies that are supportive of women.
Right, how can men create breastfeeding policies in the company and things like that. Only women would be able to relate. And only women in top management would be able to make those policies into effect.
Rightly said. That is why we need to have mommy-friendly work place policies to allow women the flexibility they need to have both a career life and mommy life.
The glass ceiling as a concept seems obsolete faced with the tangled reality of women in the workplace in the wake of feminism. I believe factors such as socialization of gender and the existence of gendered spaces are better for interpreting issues of women in the workplace.
It sure does. I've noticed that some companies may put a woman in a senior position but have a male counterpart there, just for control. They avoid having a sole female member heading up any team possibly because some men have no regard for women and will not respect their authority.


text:
You are here: Home / Julie Bindel / News: Fiona Apple, Fire Island, John Boehner, Kevin Clash
News: Fiona Apple, Fire Island, John Boehner, Kevin Clash
Thanks, David Mixner!
With no dunes left due to Hurricane Sandy, Fire Island fears winter storm will destroy it.
White House marks 'Transgender Day of Remembrance' at meeting with more than two dozen trans and allied activists and organizations.
VIDEO: Second Kevin Clash (Elmo) accuser speaks out.
California couples await Prop 8 decision:
"Interestingly enough, many local couples said they would prefer the
quicker but less definitive resolution. 'I suspect we will be in line at
the courthouse that day,' said Thom Watson, 50, of Daly City. Watson
and his fiance, Jeff Tobaco, said while they could have obtained a legal
marriage in another state, it's important to them to make their vows
close to home."
Maine news anchors resign live on the air.
Hackers attack Israeli Vice PM Silvan Shalom:
"Not only have they defaced his Facebook, Twitter, YouTube, as well as
his blog on Blogger, but they also claim to have access to his Gmail
account and are threatening to leak his emails tomorrow."
VIDEO: Christina Aguilera performs "Let There Be Love" on The Voice.
Fiona Apple writes brutally heart-wrenching letter to fans about her dying dog: "I have a dog Janet, and she's been ill for almost two years now, as a tumor has been idling in her chest, growing ever so slowly… She's my best friend and my mother and my daughter, and my benefactor, and she's the one who taught me what love is… I can't come to South America. Not now. When I got back from the last leg of the US tour, there was a big, big difference. She doesn't even want to go for walks anymore… So I am staying home, and I am listening to her snore and wheeze, and reveling in the swampiest, most awful breath that ever emanated from an angel."
ABC News profiles Immigration Equality, plight of gays in foreign lands.
Mosque for gay Muslims to open in France: "Mohammed Ludovic Lütfi Zahed, who is originally from Algeria and lives in France, plans to open the special mosque on 30 November. The venue will initially be housed inside a Buddhist chapel. Zahed, himself a homosexual, has decided to open such a place of worship as an alternative to conventional mosques, which can provide an intimidating atmosphere for gay men."
Leonardo DiCaprio makes out with Ab Fab star Joanna Lumley.
John Krasinski mugs for Nuvo.
Newly-elected gay House members talk LGBT issues: "A number of new faces will join the LGBT representation in Congress: Kyrsten Sinema of Arizona, who'll be the first openly bisexual member of Congress; Sean Patrick Maloney, who'll be the first out congressman from New York; Mark Takano of California, who'll be the first openly gay Asian-American in Congress; and Mark Pocan of Wisconsin, who'll take lesbian Rep. Tammy Baldwin's seat in the U.S. House."
Why Ke$ha's new memoir is 2012's answer to The Feminine Mystique.
Judge rejects electrolysis for transgender inmate.
John Boehner reverses course, says he'll repeal Obamacare through oversight: "The tactics of our repeal efforts will have to change. But the strategic imperative remains the same. If we're serious about getting our economy moving again, solving our debt and restoring prosperity for American families, we need to repeal Obamacare and enact common-sense, step-by-step reforms that start with lowering the cost of health care. […] Congress has a constitutional responsibility to conduct thorough oversight of the executive branch, and congressional oversight will play a critical role in repealing Obamacare going forward."
November 21, 2012 Filed Under: Julie Bindel
Previous Post: « Meet Casey Legler, a Woman Working as a Male Model: VIDEO
Next Post: Towleroad Guide to the Tube #1253 »

redpajama_set_name: RedPajamaCommonCrawl


There are many, many plants with personality. A source of continuing amazement to South Florida gardeners is the number and variety of endlessly fascinating plants that thrive here. And it seems more and more are being imported, tested, and put on the South Florida market as they are discovered in similar habitats around the world.


text:
Home Concealed Carry John Lott addresses the Mexican Legislature on Gun Law
John Lott addresses the Mexican Legislature on Gun Law
Dean Weingarten
On Wednesday, 16 November, 2016, John Lott testified before the Mexican legislature about the benefits of an armed population. He was invited by Senator Jorge Luis Preciado. A reform of the Mexican gun control laws is under serious consideration. On October 6, Senator Preciado published a policy recommendation to emulate the U.S. Second Amendment. This would not be simple legislation, but a change in the Mexican constitution. From John Lott:
The last few days have been very exciting with me testifying before the Mexican Senate and House Constitution Committees as they consider changing the Mexican Constitution. Right now Mexicans are only allowed to have small caliber guns and only in their homes. The proposed changes would again allow people to keep their guns with them in their businesses and cars.
Right now there is also only one gun store in the entire country and it is located in Mexico City, thus making it impossible for poorer people from the rest of the country to legally own a gun. My testimony was well received and was broadcast live on Mexico's two largest television networks as well as their version of C-SPAN. Over a hundred newspaper articles have been published in Mexico after my presentation.
At the CPRC, they have a translation of one of the articles in Melenio, on of the larger national newspapers. From the crimeresearch.org:
"It's easy to talk about what could go wrong in the arms control debate, but you do not have to guess, there are many experiences in a number of countries that can be considered.
"For example, if it has worked in the United States, why not believe that in Mexico too? Since the system has not worked they may not do so as a federal law, but by states and see how it is resulting. Some states may be allowed to experiment, local laws are enforced, some states have high levels of criminality, it is obvious that the system failed, what can they lose if they give people the opportunity to defend themselves? "He asked.
Lott is a member of the forum invited by Senator Jorge Luis Preciado to analyze the use of weapons, titled "Analysis of the reform initiative to the Federal Law on Firearms and Explosives. In self-defense, "to be held today at the Senate.
The makes the possibility of international reciprocity between Mexico and the United States something to consider. It would be a fitting subject for talks on the North American Free Trade Agreement (NAFTA) reform.
©2016 by Dean Weingarten: Permission to share is granted when this notice is included. Link to Gun Watch
Previous articleThe Second Amendment – A Right to be Negligent?
Next articleShoot Straight Gun Range in Ft. Myers. Fresh Pizza For You!
http://gunwatch.blogspot.com
Buying Your First Carry Gun: Here's a Realistic Self-Defense Gear Budget For 2023
mk10108 November 19, 2016 At 19:19
Meanwhile Mexican citizens are being murdered by criminals with guns. Mexican politicians have a vested interest in preventing lawful self defense because the majority of them are paid by criminals. Mexican culture has no moral confict with murder, for them its just business…SO Why would we want international reciprocity with a culture that see killing as another day at the office?
JUST BUILD THE WALL. They stay their side, we on ours.
Ing November 19, 2016 At 19:31
So much fail. Politicians and drug cartels are not the same thing as Mexican culture. Just like the urban yoots doing drivebys aren't the same thing as American culture.
By all means, let's build a wall. It makes sense to control our own borders. But to say that Mexicans are incapable and undeserving of the same freedoms we enjoy? There's a word for that, but I really don't want to use it on you.
NorincoJay November 19, 2016 At 19:56
People do realize that Mexicans and other Latin American people are just A mix of Spanish, Portuguese and Native American right?
Red in CO November 19, 2016 At 20:02
Yeah, but folks like mk10108 like to pretend that they are better than other people, based on almost no knowledge of the people they like to feel superior to them. Hey, you know who else does that? Liberals! But yeah, I agree with you completely. Just because they live south of our border doesn't mean they are fundamentally different from us, or that they don't have the right to the same freedoms we enjoy.
Well Red I would say I know illegal Mexicans, I'm in an industry that see illegals everyday by selling equipment reducing the number of illegals in processing plants (no I don't do robots). I've watch illegals sabotage equipment, I've been threaten not to return to plants or I would be killed. I've watch them steal employers blind despite being paid $15 an hour doing simple task work. I watched illegals turn over a portion of their pay to Mexican line leads (tribute for allowing them to work).
Don't allow the positive lens of our culture to cloud the reality of theirs. Its a mistake we've made and now must take steps to correct policies that allows it.
StuckinChicago November 22, 2016 At 10:48
I hope you know that just because you have seen some bad events/people that you are condemning an entire country of people who share very similar conservative values to many of us and our ancestors? This is like the black lives matter folks saying because a few racist cops were involved in bad shoots that we should just disband the police or that if white supremacists shoot black folks we should get rid of all guns. This logic is dangerous and just plain wrong.
I personally know many hard working, intelligent, and highly respectable Mexicans who just want to protect their families from the extortion, kidnapping, and random violence caused by the cartels. They are running rampant and unopposed because many of the Mexican 'federalies', military, and politicians are influenced by the billion dollar industry. I also know a strong and respectable Mexican man who was detained for bringing his family to the U.S. illegally, seeking safety after he was extorted, kidnapped, abused, and a cousin of his killed, offered refugee status, refused it, and took his family back to Mexico because of the love and hope for his country to turn around this bad period.
Not only would people be able to protect themselves and their families and combat the cartels, but a change that is essentially the addition of a second amendment to a modern country and the possibility of the positive results in the country could become a global example for second amendment supporters and for the power of personal protection in the modern world. This would stand as the ultimate evidence for our case and could also collapse the drug trade and inflow of heroin, cocaine, and marijuana into the U.S. that destroys families and lives and inordinately affects the poor and uneducated. Think about it if it was the other way around and if it was your family, not the BS that the media feeds you about these people.
Use your words and call me whatever you like. The fail is thirty million Mexicans reside in this country because Mexico's 3 major and 7 minor political party's have shit on their citizens for the last 50 years. They've allowed 80K people to be murdered, denied citizens lawful self protection. Without the US economy allowing illegals to send 20 billion to their families, Mexico would border on being a third world shit hole just above the far side sandbox. They don't have the brains or smarts to create economic engines so they import US, German and Japanese companies to build factories while supplying people at low wages.
I'm sick of Mexicans in our country, 50 standing at Home Depot everyday looking for work, not paying taxes, emergency rooms packed with them on the weekends, sanctuary cities protecting them, Obama allowing them to pour into the country, he just shut down aerial surveillance on the border. 30% of all processing in this country is done by illegals. National forest being used to grow pot, damning creeks adding chemicals for drip irrigation and animals dying from drinking water. 50% of illegal fishing is done by illegals, 36% of federal prisons are packed with illegal Mexicans, 90% of meth is made by illegals. Schools and prisons are being paid by the federal government to incarcerate and teach illegals, all the while its dragging down students test scores, and providing profit centers for prisons. All this so democrats stay in power and tax the crap out of us.
Its not about Mexican gun rights, its about removing them and restoring the rule of law.
Restoring the rule of law is the most sensible thing you've said. The lack of it is why we're in this predicament.
You want to blame somebody, don't blame Mexicans, the vast majority of whom are doing the exact same thing you or I would do if we were stuck in the same crappy situation. Blame our politicians and theirs, who created the whole situation and profit from the chaos. Our federal government's single most legitimate job is to secure the borders and regulate immigration — the fact that they flat-out refuse to do it (while wasting massive amounts of time and money on things they should never have started doing) amounts to dereliction of duty at best, sedition at worst.
I'm not going to use the inflammatory word. It gets thrown around too carelessly. Instead I'll just say that I think you've drawn a faulty conclusion from legitimate evidence.
"I'll just say that I think you've drawn a faulty conclusion from legitimate evidence."
Perhaps…only relaying reality on the ground which half this country refuses to acknowledge or understand how it impacts our lives.
Scott Bailey November 20, 2016 At 15:10
Bill November 19, 2016 At 20:38
The US drug war is partially responsible for the violence in Mexico. Gaining control of the border AND ending the drug war would give Mexico a chance to get their own house in order. And a substantial amount of criminal activity in the US is drug related.
Further, after the traditional terror funding channels were ended post-9/11, most terrorists are now funded by drugs. Which do you want: ISIS or legal heroin? You must pick one or the other.
FulMetlJakit November 20, 2016 At 06:13
We all know how alcohol prohibition "worked" we all know how firearm prohibition "works" and we all know how drug prohibition "works."
Drive money away from constructive taxation and into black markets.
As a libertarian if you want to shoot up smack, fine. Just do not cause problems and do not expect my tax money to pay for your health costs, or worse, provide for your children (which I will, because they are kids, but damn your soul for instigating such a sad situation) and you are free to do as you like .
Funny that the left forgets the Obama administration just pledged up to $75 MILLION (on top of the funding and "advisement" we already provide) for them to enforce their own southern border… And that in the past 8 years they have already deported approximately 2.5 million illegals.
Roymond November 20, 2016 At 19:44
I'm surprised I haven't heard lots of calls to end deportation and instead put illegals who have committed a crime here to work building that wall.
Of course IMHO the BATFE ought to be shut down, and the personnel be moved to the Border Patrol, which would make a big supply of people to supervise the builders.
Kendahl November 19, 2016 At 20:56
Bribery has been routine in Mexico for generations. What has changed in the last generation is the amount of money available to the drug cartels for this purpose. They offer an opportunity to become richer than the bribery target ever thought possible. If he declines, they murder him and make the same offer to his successor. Certainly, there is corruption in this country. However, it isn't pervasive like in Mexico.
Building a physical barrier at the southern border won't work. Illegal immigrants will find ways around it just like drug smugglers find ways. Instead, make daily life untenable unless you are here legally. Extend the E-verify system beyond employment. Require it for renting or buying a place to live, opening a bank account or a credit card, getting medical care, enrolling yourself or your children in school. I believe it would work. The question is how many "build a wall" advocates would be willing to live with "Show me your papers."
Even if we find an effective way to discourage illegal immigration, we are left with the issue of illegals who have been here for a long time. Quite a few were brought here at such a young age that, if deported, they would be unable to function in their native countries. There is a longstanding principle in real estate law that, if you tolerate trespassers for a long time, you forfeit the right to keep them off your property. By failing to enforce our immigration laws over decades, we have put ourselves in an equivalent position. Back when ICE was called INS, the agency raided meat packing plants in my state and found that a large fraction of the work force was illegal. The plants complained to their US senator who put pressure on INS to cease the raids.
16V November 20, 2016 At 08:33
I've long argued that the best way to rid ourselves of the problem is to make it impossible to function illegally – you know, like they do in other countries. No citizenship documents/valid visa, no work, no school, Get caught knowingly hiring an illegal, you go to prison.
The illegals have been doing the adverse possession thing for the last 50 years. It's been working, we need to stop it.
LarryinTX November 20, 2016 At 09:32
"The question is how many "build a wall" advocates would be willing to live with "Show me your papers."
They are mutually exclusive? Do we have to choose, for some reason?
uncle_pickle November 19, 2016 At 23:30
One does not simply survive 300 years of rape without having a little kneel in their genes.
I'm down with that! It would take 100 years for the culture to adapt, before any positive effects could appear. Further, the idea is so unlikely that I am pretty sure it would be the first time in recorded history that a disarmed populace were given the right to bear arms by their government.
This! I can't believe more people don't see how great of an opportunity this could be for the people of the gun. There are many regular Mexican business owners, etc, who would gladly carry for self protection. This is exactly what happened in Chicago for so many years, no surprise that 'El Chapo', one of the richest men in the world from billions in drug sales, made Chicago his central distribution and earned his money by destroying american families and lives.
Whatever your political view about Illegals, remember that if the cartel problem is solved, Mexico would clean up and more people would want to stay in Mexico or go back instead of being here illegally. If we make it difficult to be here illegally and help the people to take their country back (not to mention get to sell a bunch of american made guns) then we would solve the immigration issue and put a huge dent in the drug problem in the U.S. Then we just have to deal with the pharmaceutical cartels…who are more infectious.
former water walker November 19, 2016 At 19:40
Well that's just special…trusting the Mexican powers that be. Corrupt for 200years-why would they give up control? Yeah BUILD A WALL for a failed state. A new Mexican revolution is in order…
Geoff PR November 19, 2016 At 19:40
Is this 'Pie-in-the-sky' or something that may actually happen?
Ralph November 19, 2016 At 19:59
The Mexican government wants the people disarmed and wants the cartels to exercise power, as long as the politicians get their cut.
Guns for good people in Mexico is a non-starter. Guns for goons, on the other hand, is Mexican government policy.
Ultimately, there's little difference between Mexico and Chicago.
Pretty much. Quite a few of my co-workers (I work in construction) are immigrants from Mexico (some legal, some not), and they've got quite a few stories. One of the things that really struck me they said is that apparently a sizable chunk of cartel foot soldiers are actually deserters from the Mexican army. Hell, the cartels are so blatant that they literally put up billboards advertising to current soldiers, basically saying, "Hey, we'll pay you more and you can have real power (and all the sex you want, though only if you don't care about such petty things as "consent") if you come work for us! Cash bonus if you bring your own weapons". It's crazy
"apparently a sizable chunk of cartel foot soldiers are actually deserters from the Mexican army."
The Los Zetas cartel was founded by deserters, some very high ranking, from the Mexican commandos. The Zetas provided protection for the Gulf Cartel until they felt strong enough to break away and form their own cartel (now called "Cartel del Norte").
The Del Nortes are now the biggest cartel in Mexico and have extraordinary power and wealth.
Mexico isn't merely a failed state — it's always been that. It's a narco state.
The solution being making "narcotics" legal….
"Garrison Hall November 21, 2016 At 13:44
National Prohibition failed for the same reasons that narcotics prohibition is failing: people want to get high.
jwm November 19, 2016 At 20:19
Lott should talk to the mexican .gov about charging and attempting to extradite Holder for his part in hundreds of murders brought about by Fast and Furious.
Michael November 19, 2016 At 20:40
Send John to Commifornia next.
Mexico, California, same thing.
C.S. November 19, 2016 At 21:17
If Mexico was actually serious about trying to stop illegal guns from flowing in, they might want to help Trump build the wall. Just sayin'.
It's more important for Mexico to export its undesirables and its drugs than it is to interdict American guns headed south. The cartels get all the guns they need from the Mexican military.
But, Hillary and Obama said, 90 percent of the guns recovered in Mexico come from the United States? It must be true…
Guy on the tube yesterday was all bitchy about deporting illegals, but changed his tune when criminals were brought up. Suddenly made me think! Hey! How about, after we secure the border, we adjust our legal system so that we can deport illegal alien criminals to Mexico? And while we're at it, so that we can deport natural born Americans of every race and ethnicity who are violent criminals to Mexico as well! Empty the freaking prisons. If Mexico wants to machine gun all of them, well, shame on them, oh well.
Gringo Cracker November 19, 2016 At 21:48
If natural rights are universal, they ought to transcend national boundaries.
Yes they should, only the greed of governments prevents it.
True dat. Where are the Mexican Washingtons who will place country above political power?
Ted Unlis November 20, 2016 At 05:48
Poor Dean just can't seem to get this international reciprocity delusion out of his mind. Why limit your nutty obsession to Mexico Dean? Why not delude and obsess over Canadian British & French gun laws while you're at it, because the chances of those or any other foreign government changing their laws permitting U.S. visitors to carry handguns are the same as for Mexico, absolutely zero.
uncommon_sense November 20, 2016 At 07:52
I find it interesting that both Panama and Mexico are beginning to consider expanding firearm ownership among their law abiding populations. Toss in the fact that a big-wig at Interpol suggested the same after the Westgate shopping mall attack in Kenya. It's almost like the United States has it right when it comes to keeping and bearing arms. Maybe that saying is true: you cannot stop the signal!
H November 20, 2016 At 08:59
This country doesn't want to cease illegal immigration. If it did the federalies would arrest the owner of the chicken plant and the managers. Instantly, no jobs! But actually the powers that be keep telling us, "the Mexican is taking your jobs" while trying to catch illegals at traffic stops. The owners pay the politicians to look the other way while they don't pay citizens a real wage. The citizens stay angry at the wrong people. It's the Wizard of Oz. "Pay no attention to the man behind the curtain!" Oh, okay.
"Instantly, no jobs!"
Wouldn't that also mean "no chicken"? Got to have me some chicken.
Chicken farming is the most automated, its the processing plants that would suffer. If Trump deports illegals, entire towns will vacate, housing prices would drop. Gives opportunities for LGBT's to move in and spruce up the neighborhood. Think Castro district and South Miami late 70's early eighties and the turnaround in the 90's. If they don't want the job, we can get all the stupid people who think they want to colonize Mars to move in and create ghost towns.
Matt in Tx November 20, 2016 At 21:11
The right to keep and bear arms WAS enshrined in the Mexican constitution…
"The right to keep and bear arms was first recognized as a constitutional right under Article 10 of the Mexican Constitution of 1857.[7] However, as part of the Mexican Constitution of 1917, Article 10 was changed[8] where-by the right to keep and bear arms was given two separate definitions: the right to keep (derecho a poseer in Spanish) and the right to bear (derecho a portar in Spanish).[9] The new version of Article 10 specified that citizens were entitled to keep arms (own them) but may only bear them (carry them) among the population in accordance to police regulation.[10] This modification to Article 10 also introduced the so-called …[arms] for exclusive use of the [military]… (in Spanish: …de uso exclusivo del Ejército…), dictating that the law would stipulate which weapons were reserved for the armed forces, including law enforcement agencies, for being considered weapons of war."
https://en.wikipedia.org/wiki/Gun_laws_in_Mexico
BDub November 21, 2016 At 10:32
Without a cultural understanding and respect for rule-of-law and due-process, any amendment would just be words.
Gordon in MO November 21, 2016 At 11:04
A major problem with reciprocity with Mexico, the cartels would pay who ever they needed to to get a license there, then they could legally carry here. Such a deal.
BDub'sand Gordon's comments condense why wishing for carry reciprocity with a corrupt 3rd world country like Mexico is complete idiocy, but lest we forget, carry reciprocity with Mexico is nothing more than a Dean Weingarten pipe dream that reoccurs each time the pith helmet wearing snowbird experiences butt hurt at the sight of numerous "no guns allowed" signs posted on the U.S. side of the border as a warning before crossing into Mexico.
OldRed November 23, 2016 At 01:26
We are the reason for the Drug cartels in Mexico. We are the market the sell to. If you want to stop illegal drug just make the legal. That way we can tax and do a much better job of controlling them.
There is no built in need for corruption in Mexico. The government does't take in enough tax to pay the Federal workers in the Provences a living wage so the have their hand out for "la mordida," (the bite) that runs about the same as tip 10 to 15% of the value of what is involved to allow things to happen. It works better and cost less if you look at as a tip instead of bribe.
Almost all the Mexican citizens that cross the border illegally are looking for work. Most used to go home once or twice a year. Now they stay on one side or the other as travel is too dangerous.
When drugs got in the mix things on the border got worse and worse. Terrorist are tuning it into Hell.
We must control our borders to stop terrorist, smugglers and slavers from using them as a more or less open highway. A solid wall even of wire causes and serious environmental problem. The wild life ranges and migrated across the border. Mountain Lions and Jaguars will die of thirst trying cross stretches of man proof fence or wall. So some of the fence will have to be open over pretty wide areas to allow wildlife through.
We most get the criminal illegals off our streets. The illegal worker need to be dealt with. Some need papers some need sent home. The all need to be accounted for. We need a good part of them right where they are.


text:
Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing
Yi An Chen, Guan Wen Chen, Hao Hsiang Ku, Tsui Chin Huang, Hsin Yi Chang, Cheng I. Wei, Yung Hsiang Tsai, Tai Yuan Chen
癌症生物學與藥物研發研究所
癌症生物學與藥物研發博士學位學程
臺北醫學大學癌症轉譯研究中心
臨床基因體學暨蛋白質體學碩士學位學程
High-pressure processing (HPP) is a prevailing non-thermal food preservation technology. The inactivation mechanisms of Listeria monocytogenes under HPP at 200 and 400 MPa for 3 min were investigated by label-free quantitative proteomic analysis and functional enrichment analysis in the Kyoto Encyclopedia of Genes and Genomes. HPP treatment at 400 MPa exhibited significant effects on proteins involved in translation, carbon, carbohydrate, lipid and energy metabolism, and peptidoglycan biosynthesis. HPP increased most ribosomal subunits and initiation factors, suggesting it might shift ribosomal biogenesis to translation initiation. However, protein synthesis was impaired by the shortage of proteins responsible for elongation, termination and recycling. HPP stimulated several ATP-dependent Clp proteases, and the global transcriptional regulator Spx, associating with activation of the stress-activated sigma factor Sigma B (σB) and the transcriptional activator positive regulatory factor A (PrfA) regulons. The quantitative proteomics approaches provide fundamental information on L. monocytogenes under different HPP pressures, and provide theoretical support for HPP against Listeriosis illness and for promotion of safer ready-to-eat foods.
文章編號
https://doi.org/10.3390/biology11081152
生物化學、遺傳與分子生物學 (全部)
農業與生物科學 (全部)
10.3390/biology11081152
深入研究「Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing」主題。共同形成了獨特的指紋。
high pressure treatment Agriculture & Biology 100%
Listeria monocytogenes Medicine & Life Sciences 96%
Proteomics Medicine & Life Sciences 75%
proteomics Agriculture & Biology 73%
Food Chemical Compounds 58%
Pressure Medicine & Life Sciences 53%
Peptidoglycan Chemical Compounds 52%
Protein Synthesis Chemical Compounds 43%
Chen, Y. A., Chen, G. W., Ku, H. H., Huang, T. C., Chang, H. Y., Wei, C. I., Tsai, Y. H., & Chen, T. Y. (2022). Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing. Biology, 11(8), [1152]. https://doi.org/10.3390/biology11081152
Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing. / Chen, Yi An; Chen, Guan Wen; Ku, Hao Hsiang 等.
於: Biology, 卷 11, 編號 8, 1152, 08.2022.
Chen, YA, Chen, GW, Ku, HH, Huang, TC, Chang, HY, Wei, CI, Tsai, YH & Chen, TY 2022, 'Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing', Biology, 卷 11, 編號 8, 1152. https://doi.org/10.3390/biology11081152
Chen YA, Chen GW, Ku HH, Huang TC, Chang HY, Wei CI 等. Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing. Biology. 2022 8月;11(8):1152. doi: 10.3390/biology11081152
Chen, Yi An ; Chen, Guan Wen ; Ku, Hao Hsiang 等. / Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing. 於: Biology. 2022 ; 卷 11, 編號 8.
@article{3c0db7dbb8db4cf2b6e94982418e68b7,
title = "Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing",
abstract = "High-pressure processing (HPP) is a prevailing non-thermal food preservation technology. The inactivation mechanisms of Listeria monocytogenes under HPP at 200 and 400 MPa for 3 min were investigated by label-free quantitative proteomic analysis and functional enrichment analysis in the Kyoto Encyclopedia of Genes and Genomes. HPP treatment at 400 MPa exhibited significant effects on proteins involved in translation, carbon, carbohydrate, lipid and energy metabolism, and peptidoglycan biosynthesis. HPP increased most ribosomal subunits and initiation factors, suggesting it might shift ribosomal biogenesis to translation initiation. However, protein synthesis was impaired by the shortage of proteins responsible for elongation, termination and recycling. HPP stimulated several ATP-dependent Clp proteases, and the global transcriptional regulator Spx, associating with activation of the stress-activated sigma factor Sigma B (σB) and the transcriptional activator positive regulatory factor A (PrfA) regulons. The quantitative proteomics approaches provide fundamental information on L. monocytogenes under different HPP pressures, and provide theoretical support for HPP against Listeriosis illness and for promotion of safer ready-to-eat foods.",
keywords = "high-pressure processing, Listeria monocytogenes, quantitative proteomics, stress responses, translation initiation",
author = "Chen, {Yi An} and Chen, {Guan Wen} and Ku, {Hao Hsiang} and Huang, {Tsui Chin} and Chang, {Hsin Yi} and Wei, {Cheng I.} and Tsai, {Yung Hsiang} and Chen, {Tai Yuan}",
note = "Funding Information: This work was supported by the Ministry of Science and Technology of Taiwan (110-2221-E-019-006-; 111-2221-E-019-005-MY2). The funders had no role in research design, data analysis, the decision to publish, or preparation of the manuscript. Mass spectrometric protein identifications and analyses were performed by the Common Mass Spectrometry Facilities sponsored by the Institute of Biological Chemistry, Academia Sinica, Taiwan. Publisher Copyright: {\textcopyright} 2022 by the authors.",
doi = "10.3390/biology11081152",
journal = "Biology",
T1 - Differential Proteomic Analysis of Listeria monocytogenes during High-Pressure Processing
AU - Chen, Yi An
AU - Chen, Guan Wen
AU - Ku, Hao Hsiang
AU - Huang, Tsui Chin
AU - Chang, Hsin Yi
AU - Wei, Cheng I.
AU - Tsai, Yung Hsiang
AU - Chen, Tai Yuan
N1 - Funding Information: This work was supported by the Ministry of Science and Technology of Taiwan (110-2221-E-019-006-; 111-2221-E-019-005-MY2). The funders had no role in research design, data analysis, the decision to publish, or preparation of the manuscript. Mass spectrometric protein identifications and analyses were performed by the Common Mass Spectrometry Facilities sponsored by the Institute of Biological Chemistry, Academia Sinica, Taiwan. Publisher Copyright: © 2022 by the authors.
N2 - High-pressure processing (HPP) is a prevailing non-thermal food preservation technology. The inactivation mechanisms of Listeria monocytogenes under HPP at 200 and 400 MPa for 3 min were investigated by label-free quantitative proteomic analysis and functional enrichment analysis in the Kyoto Encyclopedia of Genes and Genomes. HPP treatment at 400 MPa exhibited significant effects on proteins involved in translation, carbon, carbohydrate, lipid and energy metabolism, and peptidoglycan biosynthesis. HPP increased most ribosomal subunits and initiation factors, suggesting it might shift ribosomal biogenesis to translation initiation. However, protein synthesis was impaired by the shortage of proteins responsible for elongation, termination and recycling. HPP stimulated several ATP-dependent Clp proteases, and the global transcriptional regulator Spx, associating with activation of the stress-activated sigma factor Sigma B (σB) and the transcriptional activator positive regulatory factor A (PrfA) regulons. The quantitative proteomics approaches provide fundamental information on L. monocytogenes under different HPP pressures, and provide theoretical support for HPP against Listeriosis illness and for promotion of safer ready-to-eat foods.
AB - High-pressure processing (HPP) is a prevailing non-thermal food preservation technology. The inactivation mechanisms of Listeria monocytogenes under HPP at 200 and 400 MPa for 3 min were investigated by label-free quantitative proteomic analysis and functional enrichment analysis in the Kyoto Encyclopedia of Genes and Genomes. HPP treatment at 400 MPa exhibited significant effects on proteins involved in translation, carbon, carbohydrate, lipid and energy metabolism, and peptidoglycan biosynthesis. HPP increased most ribosomal subunits and initiation factors, suggesting it might shift ribosomal biogenesis to translation initiation. However, protein synthesis was impaired by the shortage of proteins responsible for elongation, termination and recycling. HPP stimulated several ATP-dependent Clp proteases, and the global transcriptional regulator Spx, associating with activation of the stress-activated sigma factor Sigma B (σB) and the transcriptional activator positive regulatory factor A (PrfA) regulons. The quantitative proteomics approaches provide fundamental information on L. monocytogenes under different HPP pressures, and provide theoretical support for HPP against Listeriosis illness and for promotion of safer ready-to-eat foods.
KW - high-pressure processing
KW - Listeria monocytogenes
KW - quantitative proteomics
KW - stress responses
KW - translation initiation
U2 - 10.3390/biology11081152
DO - 10.3390/biology11081152
JO - Biology
JF - Biology


Frazer Center is a nationally-accredited Atlanta nonprofit that has worked for the inclusion of people with disabilities in the Atlanta community since 1949. Each day at Frazer Center, 85 adults with intellectual and developmental disabilities participate in supported and customized employment and community life engagement programs, and 180 young children with and without disabilities learn together in an inclusive early childhood education program. Frazer Center also operates a social enterprise and community greenspace in the Frazer Forest and Cator Woolford Garden, located on its historic 39-acre campus. Frazer Center's diverse funding base supports an operating budget of $4.7 million and a staff of 85, and generates a healthy reserve to support the organization's stability.


This candelabra seems to float up and down magically on its own.
How to make the Talking Douglas Fir trees with no input jack say what you want them to!
Achieve the look of real lightning made from a circuit and spotlights.
Instructions on how to make totally random blinking rats eyes.
Make books seem to fly around the room all by themselves!
Are you looking for a way to make the time magically change to midnight?
The most realistic looking pillars made from fiberglass roofing and cardboard pouring tubes.
Do you have a knight character in your haunted castle and want a good looking, safe shield?
Got an old house who desperately needs a time piece? Well looky here!
Have a place that needs a fire effect? This effect makes an area flicker as if a fire is nearby.
Got a pond or other water source you want to haunt, then this guy should live there.
A small skeleton child is trapped in a hanging cage for all to see.


text:
create table if not exists ck_org (
	id bigint not null,
	short_name varchar(50) not null,
	name varchar(255) not null,
	modified_date datetime,
	primary key (id)
)engine InnoDB;

alter table o_repositoryentry modify displayname VARCHAR(255);
alter table o_repositoryentry modify resourcename VARCHAR(255);
alter table o_catentry modify name VARCHAR(255);

alter table ck_course change short short_title varchar(255) not null;
alter table ck_course add column short_semester char(4);
alter table ck_course add column enabled char(1)  NOT NULL default '0';

alter table ck_olat_user add column kind_of_mapping VARCHAR(6) NOT NULL default 'MANUAL';
alter table ck_olat_user add column mapping_timestamp timestamp default  CURRENT_TIMESTAMP;
update ck_olat_user set mapping_timestamp=now();

alter table ck_course drop version;
alter table ck_lecturer drop version;
alter table ck_student drop version;
alter table ck_event drop version;
alter table ck_text drop version;

create or replace view ck_not_mapped_students as
select * from ck_student s where s.id in
(select sc.student_id from ck_student_course sc, ck_course c
where sc.course_id = c.id  and c.enabled='1')
and s.id not in(select sap_user_id from ck_olat_user ou where ou.sap_user_type= 'STUDENT');

create or replace view ck_not_mapped_lecturers as
select * from ck_lecturer l where l.id in
(select lc.lecturer_id from ck_lecturer_course lc, ck_course c
where lc.course_id = c.id  and c.enabled='1')
and l.id not in(select sap_user_id from ck_olat_user ou where ou.sap_user_type= 'LECTURER');

create or replace view ck_horizontal_userproperty as
select u.fk_user_id, i.status,
        max(case when u.propname = 'firstname' then u.propvalue end) as first_name,
        max(case when u.propname = 'lastname'  then u.propvalue end) as last_name,
        max(case when u.propname = 'email'     then u.propvalue end) as email,
        max(case when u.propname = 'institutionaluseridentifier' then u.propvalue end) as useridentifier
    from o_userproperty u, o_bs_identity i
    where u.fk_user_id=i.fk_user_id
    and i.status<>199
    group by u.fk_user_id;

create or replace view ck_students_to_be_mapped_manually as
select count(sub.id) as count,
 sub.registration_nr as sap_matrikelnr, sub2.useridentifier as olat_matrikelnr,
 sub.first_name as  sap_firstname, sub2.first_name as  olat_firstname,
 sub.last_name as  sap_lastname, sub2.last_name as  olat_lastname,
 sub.email as  sap_email, sub2.email as  olat_email
 from ck_not_mapped_students sub,
 ck_horizontal_userproperty sub2
 where sub.registration_nr=sub2.useridentifier
or sub.email=sub2.email
or(sub.first_name=sub2.first_name and sub.last_name=sub2.last_name)
group by sub.id;

create or replace view ck_lecturers_to_be_mapped_manually as
select count(sub.id) as count,
 sub.id as sap_personalnr, sub2.useridentifier as olat_personalnr,
 sub.first_name as  sap_firstname, sub2.first_name as  olat_firstname,
 sub.last_name as  sap_lastname, sub2.last_name as  olat_lastname,
 sub.email as  sap_email, sub2.email as  olat_email
 from ck_not_mapped_lecturers sub,
 ck_horizontal_userproperty sub2
 where sub.id=sub2.useridentifier
or sub.email=sub2.email
or(sub.first_name=sub2.first_name and sub.last_name=sub2.last_name)
group by sub.id;

redpajama_set_name: RedPajamaGithub