text:
Q: How to delete huge duplicate data except one record without identical column/Primary key I want to delete duplicate rows in a table when no primary key
is defined(Non normalised DB).
My problem is - My table has approx 540 million records. Previously I used CTE to delete the records but it was taking time more than 8 hours. I want to optimize the query.
For example: If we have table1 with data as below,
ID FNAME LNAME
1 AAA CCC
2 BBB DDD
1 AAA CCC
2 BBB DDD
1 AAA CCC
2 BBB DDD
3 BCB DGD

Remove duplicate rows and keep the data in to the table like this using single query.
ID FNAME LNAME
1 AAA CCC
2 BBB DDD
3 BCB DGD

Previously I applied this type of query-
;with TBLCTE(EmpID,Ranking)
AS
(
select
EmpID,
Ranking = DENSE_RANK() over (PARTITION BY EmpID order by newID())
from @TBL
)
delete from TBLCTE where Ranking > 1
select * from @TBL order by EmpID

But it is taking too much time.
I want a solution which answer these conditions:

*

*No primary key or identical column

*Data is more then 540 million, query should take less time to delete the records.

A: Transferring into the NewTable data from an OldTable by chunks:
DECLARE @ChunkSize INT = 1000;

WHILE (EXISTS(
    SELECT TOP(1)1 FROM OldTable ot
    WHERE
        NOT EXISTS(
            SELECT TOP(1) 1
              FROM NewTable nt
            WHERE
              nt.FNAME = ot.FNAME AND nt.LNAME = ot.LNAME)))
BEGIN

    BEGIN TRANSACTION;

        INSERT INTO NewTable(FNAME, LNAME)
        SELECT DISTINCT TOP(@ChunkSize)
            FNAME, LNAME
          FROM
            OldTable ot
        WHERE
            NOT EXISTS(
                SELECT TOP(1) 1
                  FROM NewTable nt
                WHERE
                    nt.FNAME = ot.FNAME AND
                    nt.LNAME = ot.LNAME);

    COMMIT TRANSACTION;

END;

Clear source table
TRUNCATE TABLE OldTable;

Transferring data back to OldTable
WHILE (EXISTS(
    SELECT TOP(1)1 FROM NewTable nt
    WHERE
        NOT EXISTS(
            SELECT TOP(1) 1
              FROM OldTable ot
            WHERE
              nt.FNAME = ot.FNAME AND nt.LNAME = ot.LNAME)))
BEGIN

    BEGIN TRANSACTION;

        INSERT INTO OldTable(FNAME, LNAME)
        SELECT DISTINCT TOP(@ChunkSize)
            FNAME, LNAME
          FROM
            NewTable nt
        WHERE
            NOT EXISTS(
                SELECT TOP(1) 1
                  FROM OldTable ot
                WHERE
                    nt.FNAME = ot.FNAME AND
                    nt.LNAME = ot.LNAME);

    COMMIT TRANSACTION;

END;

Clear transfer table:
TRUNCATE TABLE NewTable;

SELECT TOP(1000) * FROM OldTable

Result:

I think using of SSIS the fastest way to transfer data to another table and then return them back.
Try right mouse button click on your DB, Tasks->Import data. Then select same DB as the data source and choose "Write custom query..." option: SELECT DISTINCT FNAME, LNAME FROM Old Table and choose NewTable as destination table.
And finally, run an import

A: Try this
 WITH TempId AS (
 SELECT *,
 row_number() OVER(PARTITION BY ID, FNAME,LNAME ORDER BY ID) AS [Num]
 FROM Employee)

DELETE TempId WHERE [Num] > 1

Select * from Employee

Find the solution in Fiddle http://sqlfiddle.com/#!6/394a9/1

A: Try this
Select * into #temp from @TBL
create nonclustered index Temp_Index on #temp(EmpId)

;with TBLCTE(EmpID,Ranking)
AS
(
select
EmpID,
Ranking = DENSE_RANK() over (PARTITION BY EmpID order by newID())
from #temp
)
delete from #temp where Ranking > 1

truncate table @TBL
insert into @TBL
Select * from #temp

A: You have to delete the duplicated data in smaller chunks - make a loop and process chunks after each other. The smallest chunk is defined as all duplicates of 1 unique record...
Your statement is taking so long, because it has to create the whole snapshot in the memory.

A: You can do this:
1.Insert the distinct records in a temporary table.
2.Truncate the original table.
3.Insert back the record to the original table.
SELECT DISTINCT T.*
INTO #TEMPTABLE
FROM T;

TRUNCATE TABLE T;

INSERT INTO t
    SELECT tt.*
    FROM #temptable tt;

OR
1.Insert the distinct records in a temporary table.
2.Drop the original table.
3.Rename the temporary table
SELECT DISTINCT *
INTO NewTable
FROM OldTable;

DROP TABLE OldTable;

EXEC sp_rename 'OldTable', 'NewTable'

You can replace SELECT DISTINCT with a faster way to get distinct records. But the procedure still stays the same.
Here is super fast DISTINCT using recursive CTE by Paul White. See this for reference:
CREATE  CLUSTERED INDEX c ON dbo.T(EmpID);

WITH    RecursiveCTE
AS      (
        SELECT  data = MIN(T.data)
        FROM    dbo.Test T
        UNION   ALL
        SELECT  R.data
        FROM    (
                -- A cunning way to use TOP in the recursive part of a CTE :)
                SELECT  T.data,
                        rn = ROW_NUMBER() OVER (ORDER BY T.data)
                FROM    dbo.Test T
                JOIN    RecursiveCTE R
                        ON  R.data < T.data
                ) R
        WHERE   R.rn = 1
        )
SELECT  *
FROM    RecursiveCTE
OPTION  (MAXRECURSION 0);


text:
Twitter investors sue Elon Musk and platform over takeover bid
Twitter investors are suing Elon Musk and the social media platform over the handling of the billionaire's $44bn (£34.9bn) bid for the company.
The case alleges he violated California corporate laws in a number of ways.
It accuses the Tesla boss of "wrongful conduct" as his "false statements and market manipulation have created 'chaos' at Twitter's headquarters in San Francisco".
Twitter shares are around 27% lower than Mr Musk's $54.20 offer price.
The lawsuit also said Mr Musk benefitted financially by delaying the disclosure of his significant stake in Twitter, and his plan to become a board member of the company.
It also claimed that several tweets posted by Mr Musk, who is a regular Twitter user with more than 95m followers, were "misleading".
This included a post in which Mr Musk said his takeover bid for the social media firm was on hold because of his doubts over the number of fake accounts on the platform.
The tweet on 13 May "constituted an effort to manipulate the market for Twitter shares as he knew about the fake accounts," the lawsuit said.
It also said Mr Musk "doubled down" on his allegations four days later, by stating on Twitter that the deal "cannot go forward".
On Friday, Frank Bottini, who is one of the lawyers representing the Twitter investors, told the BBC that the lawsuit was filed as Mr Musk "continues to disparage the company he wants to buy for $44bn in an effort to renegotiate the purchase price".
"The complaint we filed in San Francisco seeks to hold Musk liable for his unlawful conduct," Mr Bottini said.
Analysts have speculated that Mr Musk may be looking for ways to lower his takeover offer or walk away from the deal.
He has tweeted several times that he was concerned about the number of fake accounts, or bots, on Twitter.
A bot is a software programme that sends out automated posts and is often associated with misinformation on social media platforms.
Mr Musk has also hinted that he may seek to pay less for Twitter than the $44bn agreed with the company's board in March.
Speaking at a technology conference earlier this month, he said striking a deal at a lower price was "not out of the question".
The proposed class-action lawsuit was filed this week at the US District Court for the Northern District of California by investor William Heresniak, who said he was acting "on behalf of himself and all others similarly situated".
A class-action is a lawsuit that has been filed or is defended by an individual acting on behalf of a group of people.
Mr Musk's lawyers and Tesla did not immediately respond to a BBC request for comment on Friday.
Twitter declined to comment when contacted by the BBC.
Earlier this month, Twitter confirmed that two of its bosses who had been leading its consumer and revenue operations were leaving the company.
The firm has also paused most hiring except for "business critical roles".
American actor Ray Liotta dead at 67

redpajama_set_name: RedPajamaCommonCrawl


This week Bryce insisted we go retro, then he didn't show up. :) I know hand drawn animation!?! But was it good? well you can ask us in Discord; even better listen to the show!
It's November. If you want to send us goodies, we often don't say no. (pie, cake and cookies, papercraft, OG comics; like many listeners have) ...and if you can't do that will take your pitty or votes and [insert OG-bribes here]. We appreciate the votes, donations, and comments even if we don't read them on the show... and iTunes reviews. Word-of-mouth advertising is also appreaciated. Thanks for the support!


Accounting schools in Kansas offer a broad array of programs to match the needs and interests of students from diverse backgrounds. These programs can prepare you for a satisfying career in a range of accounting roles, such as public accountant, controller, tax accountant, and auditor. Accounting programs range from broad undergraduate degrees to specialized graduate degrees, and students can choose from different specializations, tracks, and electives. Continue reading below to find out more information about school rankings, career outlooks for accounting graduates, and professional accounting licensure in the state of Kansas.
At Wichita State University's W. Frank Barton School of Business, students can earn a Bachelor of Business Administration (BBA) in Accounting. This program is ideal for those interested in further graduate study in accounting and a career in the field. Undergraduate students are required to take courses such as Financial Accounting and Reporting, Accounting for Decision Making and Control, Taxation of Business Entities, and Principles of Auditing. Undergraduates study how to measure costs, perform business analysis, prepare budgets, and do business and tax planning. Through this coursework, students learn accounting skills necessary to making business decisions in the real world. Wichita State also offers a Master of Accountancy degree with an optional Tax or Accounting Information Systems concentration.
The University of Kansas offers a Bachelor of Science in Business (BSB) degree in Accounting. The curriculum focuses on the skills needed for a successful career in the accounting industry. Students start with a broad business foundation before moving on to specialized accounting courses. Through customizing electives, students can choose a specialization, such as Business Law, Management, International Business, or Information Systems. Courses encourage entrepreneurship, and many students choose to pursue further graduate accounting studies. Many complete an internship prior to graduation, and the KU also provides networking and professional development opportunities. Graduates from this program can go on to work in academia, government, industry, and public accounting.
Students at Friends University can pursue a Bachelor of Science (BS) in Accounting. This degree provides a foundation for a career in accounting, and the coursework emphasizes accounting knowledge as well as leadership and management skills. Students learn accounting and business theory in their classes, but the curriculum also focuses on applying this knowledge to decision-making and critical analysis. The core curriculum covers taxation, auditing, cost management, and research. All students learn how to research, prepare, and communicate financial data from an accounting perspective. Graduates from this program frequently go on to pursue the Certified Management Accountant (CMA) designation or further graduate study to achieve the CPA designation.
Kansas State University's College of Business Administration offers a Master of Accountancy (MAcc) degree. This one-year graduate program teaches students the advanced accounting knowledge needed to succeed in the industry. The curriculum includes a few core classes, but most of the courses in the program are electives. Depending on a student's career goals and areas of interest, he or she can choose from electives such as Fraud and Forensics, International Accounting, Merger and Acquisition Taxation, and Advanced Management Accounting. Students can also supplement their coursework with experiential learning opportunities, from internships to study abroad programs. For post-graduation opportunities, students can take advantage of a large alumni network and university connections with corporate partners. Undergraduate students in the Bachelor of Science in Business Administration (BSBA) in Accounting program at KSU can enroll in the MAcc program and apply some academic credit to both degrees.
At the University of Kansas, students can earn a Master of Accounting (MAcc) degree. This program is open to those with or without academic accounting backgrounds. Accounting undergrads can complete this graduate degree in as little as a year, and non-accounting undergraduates can finish the program in a year and a half to two years. The curriculum focuses on the skills needed to succeed in the accounting profession as well as the subjects covered by the educational requirements for CPA licensure. Students can take advantage of experiential learning opportunities by completing short-term study abroad programs or volunteering in the local community. Through tailoring their electives, students can also choose between multiple tracks, such as Advising and Consulting Services, Assurance/Audit, Corporate, and Tax. Graduates can go on to work in international public accounting firms, regional and local public accounting firms, industry, government, and academia.
Fort Hays State University offers a Bachelor of Business Administration (BBA) degree with a major in Accounting that can be completed entirely online or on-campus. Both formats follow an identical curriculum that emphasizes theoretical knowledge as well as practical skills necessary for an accounting career. Coursework focuses on how to communicate accounting information, and students also learn the computer applications and software commonly used in the industry. Students first complete a general education core, then specialized accounting courses. Accounting majors can also choose from numerous electives ranging from Governmental and Institutional Accounting to Advanced Tax Procedure and Fraud Examination. Graduates can go on to work in entry-level positions in the accounting field or pursue advanced degrees in the field.
Students can earn a Master of Accountancy (MAcc) entirely online through Emporia State University. This graduate degree is based around accelerated 7-week courses, and it can be completed in as few as 12 months. Students follow a curriculum of advanced courses in taxation, management accounting, budgeting and pricing, and tax accounting. Emporia emphasizes the application of accounting theory in business strategy, and graduate students learn the financial reporting and decision-making skills needed for their careers. This degree meets the educational requirements for CPA licensure in most states, and many graduates choose to sit for the examination. The MAcc degree prepares graduates for roles in public accounting, internal auditing, controllership, forensic accounting, and many other positions in the accounting industry.
The Kansas Board of Accountancy requires that CPA candidates complete 150 semester hours in both accounting and business studies. Many students pursue a master's degree in accounting to meet the educational requirements and prepare for the CPA examination. After passing the examination, applicants must complete at least 2,000 hours of work in public accounting that is verified by a licensed CPA. Those who have met all the application conditions can then apply for CPA licensure, and practicing CPAs must fulfill Continuing Professional Education (CPE) hours to maintain their licensure.
There are many opportunities for Kansas accounting grads to start their own accounting firms or work in public, private, or government accounting. Berberich Trahan & Co., P.A. in Topeka and Grant Thornton, in Wichita are two of the biggest CPA firms in Kansas. Graduates may find opportunities with these large CPA firms or with other firms around the state. Other large companies, such as aerospace company Spirit AeroSystems and telecommunications company Embarq, are based in the state and may have positions for accounting graduates with financial expertise. Students can find opportunities to work in local businesses or start their own, and Kansas is also home to many different governmental or nonprofit agencies. Those with accounting degrees in the state can find many different opportunities to work in accounting roles after graduation.


text:
Sasha Ingber
A graveyard in the ocean…the end of coral as we know...
Sasha Ingber - Sep 7, 2016
Coral reefs are vanishing faster than rain forests. Why? Every day for the last decade, our ocean has absorbed roughly 22 million tons of carbon dioxide.
Breaking the glass ceiling in outer space
Sasha Ingber - Mar 15, 2016
NASA's first female astronauts paved the way for a generation of girls, like 13-year-old Alyssa Carson.
Will she be the first person on Mars?
Sasha Ingber - Mar 9, 2015
"I am the Mars Generation," wrote 13-year-old Alyssa Carson on Facebook in January. She wants to be the first person to set foot on the...
Can tolerance be taught?
Sasha Ingber - Jan 23, 2015
Tolerance is the wrong word, says Erin Gruwell. What people can learn, and what she hopes babies are born with, is acceptance. The former...
Melting away
"Ice is alive in some strange kind of way," says James Balog, who has chronicled the disappearance of glaciers through the Extreme Ice Survey since...
We're all on the same grid
The first community powered by crowd-sourced energy is about to switch on. More than 200 microhouses will provide refuge to people with disabilities who...
At the top of the world, she vows to help others...
Sasha Ingber - Jan 9, 2015
"Will I last long enough?" wondered Ilina Arsova. The 30-year-old Macedonian was into her third week climbing Mount Everest, with "warm" days of minus 16...
Ten years after one of the world's deadliest tsunamis, are we...
Sasha Ingber - Dec 24, 2014
The entire planet vibrated on December 26, 2004, as an earthquake erupted in the Indian Ocean. The destruction — 1.6 million people displaced, another...
Turning the page on homelessness [video]
http://youtu.be/H3M2WD0iqiQ James Davis will never forget the cold nights that he slept on park benches. Today, he is an electronics mechanic and one of 130 vendors...


Hoops Brewing is brewer-driven, with the maxim Don't brew scared. "I'm doing this the way I dreamed of doing it." says owner and brewer Dave Hoops. Hoops offers 15 to 30 beers on tap at a time, from easy drinkers to brews with intense character. The beer hall does not include a restaurant but take-in and delivery food options from neighboring eateries is encouraged.
The Green Mill Restaurant & Bar adds a delicious dimension to your stay. For breakfast, lunch and dinner, Green Mill presents an outstanding menu with a variety of sensational entrees and award-winning specialty pizzas. Unwind in the bar with your favorite cocktail. Happy hours twice a night double the fun!
Old Chicago's menu boasts an array of other items which include appetizers, burgers, sandwiches, classic American dinners, calzones, entree salads and desserts. All menu items are prepared daily with local high-quality, fresh ingredients from original recipes. The bar area of each restaurant offers over 110 different beers with up to 30 of them on draught. Customers can enjoy sports programs shown on large screen televisions throughout the restaurant.
The original Saloon & Grill opened on the shores of Lake Superior in Duluth, MN, in 1976. A second location is conveniently located near Miller Hill in the Duluth mall area. As the founder and continuing sponsor of Grandma's Marathon, the state's largest marathon, Grandma's Saloon & Grill not only draws people from around the region but from around the world. Truly a "must see" when in Duluth. And both locations offer deck dining during the warmer months.
Authentic Italian thin crust pizza, both traditional and California gourmet style, is the Sports Garden's claim to fame. We also offer unique overstuffed sandwiches, burgers, signature salads served on a freshly baked thin crust pizza, full array of appetizers, and home of the $7.99 large cheese pizza. Located in the Canal Park entertainment district of Duluth, MN, we're the most popular night spot in town if you're looking for late night adventure!
Little Angie's Cantina is a restaurant with a real American Southwestern flair for food. Loaded with original Tex Mex artifacts and hand-carved ornate pillars. The menu features delicious sizzling fajitas, Southwest salads, cowboy burgers, and other original recipe favorites. The bar is highlighted by a Wall of Tequila and a whole menu full of margarita selections. Full wine, beer, and beverage selections also available. Angie's Cantina is truly a restaurant with attitude.
Bellisio's Italian Restaurant & Wine Bar is stacked to the rafters with over 4,000 bottles of wine representing over 500 selections, 125 are served by the glass.Bellisio's Italian Restaurant & Wine Bar recently received the Best of Award of Excellence from Wine Spectator magazine. Experience dining at its best.
Fair and square, Famous Dave's offers great barbecue and fun. But that's for you to judge, 'cause after all, you're our best critics. Come on in, we'll treat y'all right.


What follows is a remarkable piece of social history, embracing the first quarter of the twentieth century. It is remarkable not only for its content, but the fact that the writer, Winifred Onions, had no formal schooling after the age of ten. The manuscript is kept by Winifred's daughters, Barbara Merrick and Carol Keay.
In 2005 the manuscript was published by Peter Leigh, for the Pattingham History Society, with the permission, help and encouragement of Barbara and Carol. With their help Peter was able to introduce some dates and place descriptions; to illustrate the story using family photographs supplied by them; and to add a relatively brief postscript of the rest of Winifred's life, and memories of the Warner family in Pattingham.
The family have given permission for this story to appear on this web site. We are very grateful to the family and to Peter Leigh for their help. Frank Sharman has added some photos of places mentioned by Winifred and, for the purposes of web presentation, has added all the cross headings.
But 98% of the writing is still Winifred's.
Use the buttons at the bottom of this and the other pages to read the story.


text:
Basic Science Research
Rotation Schedule Overview
Resident Benefits and Salary
Joseph H. Boyes Hand Fellowship
Spine Medicine Fellowship
Joint Arthoplasty Fellowship
Orthopaedic Trauma Fellowship
Spine Fellowship
Sports Medicine Fellowship
Newschristopher2019-01-29T15:55:56+00:00
Orthopaedics Surgery Grand Rounds, September 13, 2018
Speaker: Kevin Bozic, MD, MBA, Dell Medical School at the University of Texas, Austin Date :September 13, 2018 Location: Catherine and Joseph Aresty Conference Center Lower Ground Level, Norris Research Tower 1450 Biggy Street, Los Angeles, CA 90033 Download the flyer for this event. Title :Annual SOGOS Lecture, "Lessons… Read More »
Search All News - 12 results
Speaker: Kevin Bozic, MD, MBA, Dell Medical School at the University of Texas, Austin Date :September 13, 2018 Location: Catherine and Joseph Aresty Conference Center Lower Ground Level, Norris Research Tower 1450… Read More »
Epstein family gift enhances sports medicine research and care at USC
Epstein Family Foundation donates $10 million to name the USC Epstein Family Center for Sports Medicine. LOS ANGELES – Researchers and clinicians at the Keck School of Medicine of USC's Department… Read More »
Small molecule could make a big difference for arthritis patients
When RCGD 423 was injected into the knees of rats with damaged cartilage, the animals could more effectively heal their injuries, shown in red. (Photo: Keck School of Medicine of USC) Will… Read More »
Keck School of Medicine of USC Receives $2.2 Million NIH Grant to Fund Research on Healing Difficult Bone Injuries
Keck School of Medicine of USC researcher Dr. Jay R. Lieberman has received a $2.2 million NIH grant to fund gene therapy research for enhancing repair of extensive bone injuries. Five-year award… Read More »
Bone defects inspire perfect union between surgeon-scientist and stem cell researchers at USC
One winning team brings together Jay R. Lieberman (center), a clinical orthopaedic surgeon and chair of the Department of Orthopaedic Surgery, and two researchers within the Eli and Edythe Broad Center for… Read More »
Keck School faculty provide care to Rose Bowl champions
From left, C. Thomas Vangsness, James Tibone, Reza Omid, George Hatch, Jay Lieberman and Seth Gamradt are seen at the Los Angeles Memorial Coliseum. The physicians, joined by Alex Weber, are the… Read More »
Keck School of Medicine receives $2.5 Million grant for translational osteoarthritis research
Denis Evseenko, MD, PhD Keck School of Medicine of the University of Southern California (USC) is one of four institutions to receive a multi-million dollar grant from the California Institute for Regenerative… Read More »
Faculty physicians keep singers, musicians and actors in peak shape
Injuries won't keep these performing artists out of the spotlight. Illustration by Chris Gash Javen Smith was singing for hours a day preparing for a major role in a USC production of the… Read More »
Keck Medicine of USC hospitals rises in rankings among nation's best
For the eighth consecutive year, the hospitals of Keck Medicine of the University of Southern California (USC) have been named among the best in the country by U.S. News & World Report,… Read More »
USC Stem Cell names second cohort of Broad Clinical Research Fellows
From left, Broad Clinical Research Fellows Christopher Schlieve, Gene K. Lee and R. Kiran Alluri The second cohort of Broad Clinical Research Fellows is making strides towards finding stem cell-based therapies for… Read More »


Koehler, M. and Haller, H. and Hartmann, E.
Diapedesis of leukocytes: Antisense oligonucleotides for rescue.
Dragun, D. and Haller, H.
The renin-angiotensin system and renal function in transgenic (mRen2)27 rats.
Gross, V. and Lippoldt, A. and Bohlender, J. and Ganten, D. and Ganten, U. and Luft, F.C.
Focal overexpression of collagen IV characterizes the initiation of epithelial changes in polycystic kidney disease.
Schaefer, K. and Bader, M. and Gretz, N. and Oberbaeumer, I. and Bachmann, S.
This list was generated on Mon Apr 22 02:26:46 2019 CEST.


text:
Spy shots of SpaceX droneship reveal 'Optimus Prime' landing-assist robot
By Kyle
A recent flyover of the SpaceX "Of Course I Still Love You" (OCISLY) barge stationed off the coast of Florida reveals a new robot designed to assist with the landing of Falcon 9 rockets as they return back to earth.
OCISLY is an ASDS or Autonomous Spaceport Droneship which is a new platform designed by SpaceX to enable the recovery of Stage 1 rockets at sea. Depending on the amount of fuel required for some geostationary launches, there isn't always enough fuel in the rocket to allow it to return to the original launchpad. Thus requiring the rocket to land at a distance away from the launchpad and at sea.
Utilizing an ASDS improves the efficiency of the launch by optimizing the weight of the rocket for the primary objective while also adding flexibility to the schedule as the ASDS enables recovery in more locations than just at a spaceport.
Now comes new spy shots, taken from a helicopter and posted by Redditor riddlerthc, revealing a robot assembly appearing on the deck of the OCISLY droneship. According to Redditor old_sellsword, the robot is internally named 'Optimus Prime', after the lead character from the Transformers TV shows and movies, and meant to serve as a landing-assist vehicle for Falcon 9. They went as far as noting the presumed intended functions of the components seen in the spy shots.
Source: Imgur
The ASDS is also home to a new garage that was purpose-built for Optimus Prime and meant to keep it out of the elements, especially from the harsh ocean air which has a corrosive effect on most metals. The new robot will be used after a rocket lands on the pad, motoring out into position under the booster, then raising up the four hydraulic arms and latch onto the booster legs.
Automating the process allows the SpaceX team to secure the Falcon 9 booster without the need for manual intervention. Perhaps more importantly, it will allow SpaceX to reduce the amount of preparation time needed between rocket launches. This will become increasingly more important as the pace of future launches continues to increase.
Chevy Bolt isn't a Tesla Model 3 competitor: erratic pricing, poor buying experience
SpaceX expands facility in Cape Canaveral, gears up for "extremely high rate" of launch-and-land missions


Nomination, following the legacy of the tradition of Florentine goldsmiths, has been able, for more than thirty years, to combine the taste of fine and accurate craftsmanship, typical of "made in Italy", with state of the art of technological evolution. Thanks to this combination of craftsmanship and innovation, unique and recognizable jewellery originated, not only for the workmanship, but also for the technical solutions they represent and the materials that make them up. The company's iconic product is the COMPOSABLE bracelet, world-renowned for its design quality, combination of materials and powerful communication language.
The project renewal of the business information system, which began in early 2015 following a careful selection phase that ended with the choice of Oracle JDE E1, had to take into account many factors, primarily the business sector of Nomination: the fashion world, of which the company is a renowned exponent, is in fact based on peculiar characteristics such as seasonality and the continuous need to design, implement and propose to the market new models and new collections, that could also be related to certain events or occurrences.
In Nomination all these aspects, typical of the field, are even more emphasized in relation to the world of modular jewellery, which by their very nature are highly customizable in terms of materials, subjects, sizes and finishes. Every single jewel realized therefore has a highly unique character, which makes it more similar to a hand-made product than a mass-produced piece; this, however, is in the context of a worldwide market and with countless extremely high-volume items.
The Oracle JDE E1 management solution was therefore to combine the vocation of Nomination for tailor-made products with the processes, control and performance of a competitive SME on the global market.
The go-live of the new system, which took place on 1/1/2016, was preceded by intense testing of the implemented solution, migration of data from the previous application and training to end users.
A key aspect of the project has been to guarantee Nomination extremely high solution performances, capable of supporting the company's rhythms, also and above all during the peak periods of business, providing users with a fast system of immediate responses. This was made possible thanks to the adoption of an entirely "Oracle on Oracle" infrastructure, where hardware, databases, operating systems and ERP system are engineered to work together in order to achieve maximum performance.
Ensure compliance with the main legal regulations related to both the traceability of precious material, through the prompt reconstruction of valuable raw material supply pathways, and its intrinsic characteristics like the presence of allergens.
"I followed the choice, training and implementation of JDE in our company in all its phases and peculiarities. For Nomination it has been a major challenge and the Alfa Sistemi team has been able to support our workgroup very well, even though the first months were exciting and stressful, as typically happens in similar situations. My compliments must go to the management of our partner, who have always had a role of support and exemplary coordination. The management system, in addition to the expected performances of such an evolved system, has allowed our staff to be part of a general internal corporate change and to lay the foundations for an always closer collaboration between the various departments."


text:
ʻIolani Palace – Royal Residence of the Kingdom of Hawaii- Virtual Tour
ʻIolani Palace – Virtual Tour
The ʻIolani Palace was the royal residence of the rulers of the Kingdom of Hawaii, beginning with Kamehameha III in 1845 and ending with Queen Liliʻuokalani in 1893.
Kamehameha III, the third king of the Kingdom of Hawaii from 1825 to 1854, developed his Royal Residence after moving the capital of the Kingdom of Hawaii to Honolulu.
The Palace served as the official residence of the monarch during the reigns of Kamehameha III, Kamehameha IV, Kamehameha V, Lunalilo, and the first part of Kalākaua's reign.
Initially, the Palace was primarily meant for receiving foreign dignitaries and state functions with the monarch preferring to sleep in private homes.
Kalākaua was the first monarch to travel around the world. While visiting Europe, he took note of the grand palaces owned by other rulers.
He commissioned the construction of a new ʻIolani Palace to become the official Palace of the Hawaiian monarchy. It had electricity and telephones even before the White House.
Iolani Palace Music Room
The ʻIolani Palace features architecture seen nowhere else in the world. This unique style is known as American Florentine. It then served as the official residence of the Hawaiian monarch until the 1893 overthrow of the Kingdom of Hawaii.
After the monarchy was overthrown, the building was used as the capitol building. It was used for the Provisional Government, Republic, Territory, and the State of Hawaiʻi until 1969.
The ʻIolani Palace is the only Royal Palace on U.S. soil, and it opened a museum in 1978. ʻIolani Palace is one of the only places in Hawaii where the flag of Hawaii can officially fly alone without the American flag.
Highlights of the ʻIolani Palace
The Throne Room
A Staircase of koa wood
A Koa Wood Piano
Private Royal Library
Bedrooms of the Hawaiian Monarchs
The Grounds of ʻIolani Palace
Historical Exhibits about the Rulers of the Kingdom of Hawaii
Exhibits on the Palace lifestyle in nineteenth-century
Historic documents, photographs, and archival manuscripts
King's Private Study, Iolani Palace
Museum: ʻIolani Palace
City: Honolulu
Type: Historic House Museum
Location: 364 S King St, Honolulu, HI 96813, United States
ʻIolani Palace Map
ʻIolani Palace – 360 Views
ʻIolani Palace- 360 Views
A Tour of the Top Museums in the USA
Museums in New York
Museums in Washington, D.C.
Museums in Boston
Museums in San Francisco
Museums in Chicago
Museums in Cleveland
Museums in Philadelphia
Museums in Wilmington
Museums in Houston
Museums in Honolulu
Museums in Columbus
Museums in New Haven
Museums in Baltimore
Museums in Massachusetts
Museums in Buffalo, New York
Museums in Fort Worth, Texas
Museums in Detroit
Museums in St. Louis
Museums in Indianapolis
Museums in Denver
Museums in Dallas
Cincinnati Museums
American Proverbs and Quotes
"The loveliest fleet of islands that lies anchored in any ocean."
Photo Credit: PaulT (Gunther Tschuch) / CC BY-SA (creativecommons.org/licenses/by-sa/4.0); Mark Miller / CC BY-SA (creativecommons.org/licenses/by-sa/4.0); Daniel Ramirez from Honolulu, USA / CC BY (creativecommons.org/licenses/by/2.0)


A House committee gave the go-ahead to a controversial bill that would allow Colorado to join other states in opting out of national health care reform that was passed last year.
House Bill 1273, dubbed the Health Care Opportunity and Patient Empowerment (HOPE) Act, would create an interstate compact that would trump federal law.
"HOPE is our way of telling Washington, D.C. that the changes 'Obama care' brought to our state simply do not work," said Rep. Amy Stephens, R-Monument, the bill's sponsor.
Stephens, the House Majority Leader, is also the sponsor of Senate Bill 200, which would set up health benefits exchanges in Colorado, which is a central facet of health care reform.
H.B. 1273 next heads to the House Appropriations Committee before it reaches the House floor for debate and a vote.


text:
Q: Spring boot deserialization for two models I want to deserialize json into two models which are not related, after some research about custom deserialization in JACKSON I cannot see how I can do it?
I know I can solve the issue by creating a wrapper model for the two models but isnt there a way to deserialize on the fly without JACKSON?

A: I can use ObjectMapper twice for the same json input. you may need some annotation like
@JsonIgnoreProperties(ignoreUnknown = true)

and/or
@JsonInclude(Include.NON_NULL)

on the producer side can help too.
if you give us your two models ?

redpajama_set_name: RedPajamaStackExchange


When I was fifteen I went from being a fundamentalist Christian one week to a revolutionary socialist the next. This is probably quite an unusual and swift about face in terms of beliefs and identity. I didn't do it because I was confused about who I was. I did it to be accepted and have a peer group to belong to. I was at school some years before the Asperger's diagnosis became available where I lived so had gone through school as the loner, the 'weirdo', the target of apparently every single bully in the place. While as a small child I was confident and liked myself, years of bullying and harassment at school taught me I was stupid, worthless, ugly and everything else. I thought it had to be true or why would so many people say it about me? I didn't think anyone would want me to be their friend with my evidently deficient personality so I joined a peer group where all I had to do was toe the party line and agree with what everyone else said. To this purpose, a group with clearly described and stated beliefs was quite easy to join – hence the revolutionary socialists. (I was brought up in the Christian group so that was sort of my default peer group or 'culture' from which I joined the socialists.) In order to be accepted with the socialists – or anyone really – I took on a persona which fitted with their views. I was like an actor studying a role. I observed my new peer group,saw what they did and how they spoke and took it on as part of me. I had in fact ben doing tis at high school for some time already. In school I had tried to be inconspicuous and avoid detection but it was about was effective as trying to hold back the tide!
I left home at 17 and became an independent adult. I worked so I took on the role of 'good employee' when at work. I had the odd experience of being probably the only revolutionary socialist ever to win Worker of the Month! When I was at work I put on my diligent employee 'hat' and at protests I was radical Jeanette complain gin about 'the bosses' and saying rude things about politicians.
It is probably evident to you that this would have affected my sense of self, my identity. It did but teenagers are not always the most self reflective of people and I simply didn't see it. I was unaware of this part of me. It became second nature. ada[ted to whatever setting I was in. It was like putting a chameleon on a rainbow t-shirt!
All this was unhealthy but it got worse. Regular readers of my various things will know I spent time in prison in my twenties I am not going into detail about hat here. It is easy enough to find information about that and a blog post needs to be reasonably short! Anyway the day I went to prison I put my acting skills to effect. This was a world I was only vaguely aware of and I wanted to ensure I didn't get anything 'wrong; socially. I realised as soon as I got there that this was essentially high school but the bullies would do more than call you names if you messed up. My effectiveness at turning from middle class leftie student to criminal in a space of days, and the fact that in the over three years I was there that I was never physically assaulted by the other women, amazes me. I always talk about doing what works and in that situation I somehow did what worked for me to stay safe (at least from other people). This was great in terms of my personal safety in a very dangerous place but in terms of my identity it was a disaster. I took on my criminal role so effectively it took some years to move past it. My act even fooled me!
In 2000 I found myself wanting an end to the world I knew as a criminal. I hated who I was – negative violent, self-destructive, disrespectful of others, socially devalued and alienated form all that was good. I had the amazing privilege to get to attend a residential therapy program which, while its target audience was those wth a misdiagnosis I had acquired, was in fact very helpful. While doing this course I realised I didn't know who I was and didn't really like what I saw in terms of my behaviour and attitudes, I decided to change.
I am someone who came from a dark place and was filled with remorse and shame at who I had been. I had a blank canvas. I got to decide who I would. be. A scary and empowering proposition. As soon as I accepted my Autism diagnosis I started heading in the right direction. I had never accepted that little 'A'; word and I think that was because I was not comfortable being myself. Autism to me was like an insult, something not to mention in polite company. My new self was comfortable with her Autism – although not so much as I am now.
Over the course of a few years I built my new 'me.' It didn't mean I stopped taking on mannerisms of people around me. One of my public housing neighbours thought I was 'fake' because he heard me talking to one of my university lecturers on the phone and my speech and use of language were different I was in fact unaware of that occurring – chameleons apparently take some time to change back to there regional green! These days I have a very strong sense of who I am. I don;t do so much 'acting' and think if someone doesn't like me because I'm a bit quirky that it is their loss. Identity can be hard but I ended up with a 'me' that I quite like.
While the social chameleon is often seen as a descriptor of the female Autistic 'type' that is not always the case. We need to be really careful when using those Autism and gender 'types'. Gender identity is not just sis gender male and female. Gender is a much more complex and nuanced thing than just male and female. A large percentage of Autistic people identify as trans, non-binary and other genders which makes a static notion of male or camel Autistic 'types' quite problematic.
Often people 'acting' do not realise they are doing it.
While it can be a useful way of avoiding being singled out for unwanted negative attention, 'acting' can come at the cost of a sense of identity to varying degrees.
For a lot of Autistic people identity is complicated by a number of factors such as how they view their Autism, the peer group they mix with or their other, intersectional identities, such as Aboriginally or sexuality.
Many Autistic people feel a great sense of belonging within their own Autistic community. For quite a few of us this happens after a diagnosis in adulthood.
Posted on June 14, 2017 by Yenn	Bookmark the permalink.
I've heard that a fair number of professional actors as aspies.
Thanks for your article, i've sound lots of similarities between you and me and i'm in the middle of "resetting" myself after a long period of fooling myself trying to be another person.


You can set goals all day long, but if you don't know where they are taking you—they are just chores. Drudgery. Items to check off an unending to-do list. And if you're anything like me (and the rest of the Western world), we don't need extra items there.
As a fundraiser, it can be easy to think once you reach an initial financial goal your work is done, and naturally shift into maintenance mode. But that's not the way it should be.
You might be surprised to know, fundraising has little to do with money—and more to do with how you are working with your donors to accomplish something together. We set funding goals not for the money, but to achieve impact for your vision. So we, and our donors, can accomplish something together.
We're told as fundraisers that we are "supposed to" communicate with our donors in a certain way to maintain an acceptable retention rate, that we need to add new donors each year because some will inevitably stop giving, and we feel a sense of panic just thinking about asking current donors to increase their giving.
But if we truly want to make an impact, we have to get out of the place where we set goals because we're "supposed" to do it. Before you set a goal, you need to know why you're setting it in the first place.
Identify the "why" behind your work. The basic idea is to understand what impact your ministry will have. Why do we need more funding? If we are able to see more funding come in, how will that impact people's lives?
Once you've identified what the impact of your work together will be, you'll be shocked at how much funding comes in. Funding flows most freely when it is the only thing holding you back from impact.
2. What would happen if we did nothing at all?
3. What is the greatest need among the community we are serving?
4. If we actually work together as a team (with our donors), what could we accomplish this year?
A huge motivator in goal setting can be asking yourself one simple question: What are the consequences for not getting this done? Again, this has nothing to do with funding and everything to do with the "why" behind your goal setting.
Now that you've discovered the "why," let's block out some time to create a plan that will fund your impact based on the answers to the questions above.
When creating a plan, it is highly beneficial to carve out a day, or a few hours over a few weeks, to work with a fundraising coach to map out a plan you can have confidence in (creating a 12 month plan is probably best). If you don't create a plan, you will end up frustrated because you won't have a clear map to where you are going. But if you know where you are going, you will have a purpose and motivation to move ahead.
Creating a solid plan allows you more time to not work. Proper goal setting allows you to give yourself an allotted time to work toward the goal, and frees you to use the remaining time to focus on whatever you want. Goal setting and planning should relieve pressure from your day-to-day (especially when you have a 12-month plan).
1. Set the funding goal.
What are the funding needs? What is my funding goal?
2. List opportunities for funding.
Look at areas available for increased funding–asking for larger annual gifts each year, increased monthly giving, and re-engaging lapsed donors (those who used to give but don't give now, inviting them to join in giving again).
3. Create milestones or mini-deadlines.
Make a plan with monthly or quarterly deadlines and put tasks or action items with them. Ask yourself, "What are the weekly tasks that will help me reach each of my milestones?
I hope these steps to goal setting will encourage you to start asking yourself why you are pursuing certain goals and to set a fundraising plan in place. Remember, fundraising is not about the money—it's about you working together with your donors to accomplish something beautiful for those in need.


Boston's greenest (and drunkest) day of the year is upon us, and not even a blizzard could stop us from celebrating. St. Patrick's Day is a huge event in Boston's especially in the Irish pubs . . . expect Irish music, dancing, green beer, and week-long celebrations. Here are the top events happening to celebrate St. Paddy's Day!
The huge St. Patrick's Day Parade in South Boston takes center stage on the Sunday closest to March 17th, attracting up to one million spectators. Colorful floats, music and Irish good cheer await you at the annual Boston St. Patrick's Day parade. Celebrate Irish heritage in Boston's most Irish neighborhood.
The parade begins at the Broadway 'T' Station and ends at Andrew Square, South Boston. Your best bet for viewing the parade is to stake out a spot anywhere along Broadway. Marchers continue to Telegraph St to Dorchester St ending at Andrew Square.
It's a St. Patrick's week long tradition!! Boston's own Dropkick Murphys do a string of hometown shows at the House of Blues, near Fenway park.
The 75-90 minute walk led experienced tour guides takes you on 300 fascinating years of Boston's unique Irish history and heritage. You'll discover the Irish role in the Revolutionary War, learn about the 19th century Famine generation and the Irish part in the Civil War. And you'll discover famous and infamous politicians - from Curley and White to Collins and the Kennedys - who put their indelible stamp on the history of the city and the nation.
This famous Irish pub is the perfect place to find Irish music - every night of the week. This year they have lined up the best Irish acts along with the best Irish food! If you've ever experienced the pleasure of a trad session in Ireland, you'll come close to finding the same thing here, along with plenty of Irish 'craic'. The menu features a few Irish specialties, and of course plenty of Guinness at the bar.
The #IrishFilmFest18 program has been finalized and the schedule for all screenings is online, along with ticketing information. Celebrating our 18th year, this year's festival will feature more than 35 Irish productions all presented at the historic Somerville Theatre in Davis Square.
Watch as animals receive green-themed enrichment treats in celebration of St. Patrick's Day!Guests can get creative at our arts and crafts station and discover fun animal facts at an education station.


"CLEVELAND — They are Saint Martin De Porres class of 2015 grads. Cleveland kids empowered by the written word and destined for great things.
They are already published authors of a book titled "The Stories that Chose Us," because their teacher, Ms. Sarah Marcus, saw the possible — and her students delivered.
It's a class project compilation of essays from the inner city.
Real and raw, written by young minds molded in a resistance writing class.
They were empowered by mini but mighty influential mentor, Ms. Marcus.


'Wear your heart on your tee' with our Harriet Tubman unisex ¾ baseball tee. All of our art is unique and hand-drawn with meticulous detail, and you won't find it elsewhere. 10% of profits from this design will go to President Lincoln's Cottage, a national monument in Washington DC.
Relaxed unisex fit raglan baseball tee with ¾ length sleeve.
Super soft, resilient, and wicking tri-blend material - 50% polyester/ 25% combed ring-spun cotton/ 25% rayon jersey; 4.3 oz.


I'm always photographing motel signs that I think are cool, and I always tell my wife that I want to stay in one them. Of course she thinks they are creepy and gross...which might be true in most cases. I finally stayed in one, and the Rabbit Ears was great. I highly recommend it if you are ever in Steamboat.


text:
cmake_minimum_required(VERSION 3.0)

PROJECT(lua C)

IF(NOT LUA_DIR)
  MESSAGE(FATAL_ERROR "Must set LUA_DIR to build lua with CMake")
ENDIF()

FILE(COPY ${CMAKE_CURRENT_LIST_DIR}/luauser.h DESTINATION ${CMAKE_BINARY_DIR})

SET(CMAKE_REQUIRED_INCLUDES
  ${LUA_DIR}
  ${CMAKE_BINARY_DIR})

# Ugly warnings
IF(MSVC)
  ADD_DEFINITIONS(-D_CRT_SECURE_NO_WARNINGS)
ENDIF()

# Various includes
INCLUDE(CheckLibraryExists)
INCLUDE(CheckFunctionExists)
INCLUDE(CheckCSourceCompiles)
INCLUDE(CheckTypeSize)

IF(CMAKE_SIZEOF_VOID_P EQUAL 8)
  ADD_DEFINITIONS(-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE)
ENDIF()

IF(NOT WIN32)
  FIND_LIBRARY(DL_LIBRARY "dl")
  IF(DL_LIBRARY)
    SET(CMAKE_REQUIRED_LIBRARIES ${DL_LIBRARY})
    LIST(APPEND LIBS ${DL_LIBRARY})
  ENDIF()
  CHECK_FUNCTION_EXISTS(dlopen LUA_USE_DLOPEN)
  IF(NOT LUA_USE_DLOPEN)
    MESSAGE(FATAL_ERROR "Cannot compile a useful lua.
Function dlopen() seems not to be supported on your platform.
Apparently you are not on a Windows platform as well.
So lua has no way to deal with shared libraries!")
  ENDIF()
ENDIF()

CHECK_LIBRARY_EXISTS(m sin "" LUA_USE_LIBM)
IF( LUA_USE_LIBM )
  LIST( APPEND LIBS m )
ENDIF()

if($ENV{LUA_TARGET_SHARED})
  add_definitions(-fPIC)
endif()

## SOURCES
SET(SRC_LUALIB
  ${LUA_DIR}/lbaselib.c
  ${LUA_DIR}/lcorolib.c
  ${LUA_DIR}/ldblib.c
  ${LUA_DIR}/liolib.c
  ${LUA_DIR}/lmathlib.c
  ${LUA_DIR}/loadlib.c
  ${LUA_DIR}/loslib.c
  ${LUA_DIR}/lstrlib.c
  ${LUA_DIR}/ltablib.c
  ${LUA_DIR}/lutf8lib.c
)

SET(SRC_LUACORE
  ${LUA_DIR}/lauxlib.c
  ${LUA_DIR}/lapi.c
  ${LUA_DIR}/lcode.c
  ${LUA_DIR}/lctype.c
  ${LUA_DIR}/ldebug.c
  ${LUA_DIR}/ldo.c
  ${LUA_DIR}/ldump.c
  ${LUA_DIR}/lfunc.c
  ${LUA_DIR}/lgc.c
  ${LUA_DIR}/linit.c
  ${LUA_DIR}/llex.c
  ${LUA_DIR}/lmem.c
  ${LUA_DIR}/lobject.c
  ${LUA_DIR}/lopcodes.c
  ${LUA_DIR}/lparser.c
  ${LUA_DIR}/lstate.c
  ${LUA_DIR}/lstring.c
  ${LUA_DIR}/ltable.c
  ${LUA_DIR}/ltm.c
  ${LUA_DIR}/lundump.c
  ${LUA_DIR}/lvm.c
  ${LUA_DIR}/lzio.c
  ${SRC_LUALIB}
)

## GENERATE
IF(WITH_SHARED_LUA)
  IF(IOS OR ANDROID)
    SET(LIBTYPE STATIC)
  ELSE()
    SET(LIBTYPE SHARED)
  ENDIF()
ELSE()
  SET(LIBTYPE STATIC)
ENDIF()
ADD_LIBRARY(lualib ${LIBTYPE} ${SRC_LUACORE})
SET(LUA_COMPILE_DEFINITIONS)
IF(ANDROID OR IOS)
  LIST(APPEND LUA_COMPILE_DEFINITIONS LUA_USER_H="luauser.h")
  INCLUDE_DIRECTORIES(${CMAKE_BINARY_DIR})
ENDIF()
IF(NOT WIN32)
  LIST(APPEND LUA_COMPILE_DEFINITIONS "LUA_USE_POSIX")
ENDIF()

SET_TARGET_PROPERTIES(lualib PROPERTIES
  PREFIX "lib"
  IMPORT_PREFIX "lib"
  COMPILE_DEFINITIONS "${LUA_COMPILE_DEFINITIONS}"
)
IF(LUA_COMPILE_FLAGS)
  SET_TARGET_PROPERTIES(lualib PROPERTIES
    COMPILE_FLAGS ${LUA_COMPILE_FLAGS})
ENDIF()

TARGET_LINK_LIBRARIES(lualib ${LIBS})
SET_TARGET_PROPERTIES(lualib PROPERTIES OUTPUT_NAME "lua54")
if(IOS)
  set_xcode_property(lualib IPHONEOS_DEPLOYMENT_TARGET "9.0" "all")
endif()
LIST(APPEND LIB_LIST lualib)

ADD_EXECUTABLE(lua ${LUA_DIR}/lua.c)
IF(WIN32)
  TARGET_LINK_LIBRARIES(lua lualib)
ELSE()
  TARGET_LINK_LIBRARIES(lua lualib ${LIBS})
ENDIF()

SET(lua_headers
  ${LUA_DIR}/lauxlib.h
  ${LUA_DIR}/lua.h
  ${LUA_DIR}/luaconf.h
  ${LUA_DIR}/lualib.h)

## FIXME:

## USE_64BITS= cmake -H. -BLinux -G"Unix Makefiles" -DCMAKE_BUILD_TYPE=MinSizeRel
## CMake Error at /Users/zhaozg/work/lua-forge/cmake/lua.cmake:154 (INSTALL):
##   INSTALL TARGETS given no ARCHIVE DESTINATION for static library target
##   "lualib".
## Call Stack (most recent call first):
##   /Users/zhaozg/work/lua-forge/CMakeLists.txt:88 (include)
##
##
## CMake Error at /Users/zhaozg/work/lua-forge/cmake/lua.cmake:159 (INSTALL):
##   INSTALL TARGETS given no RUNTIME DESTINATION for executable target "lua".
## Call Stack (most recent call first):
##   /Users/zhaozg/work/lua-forge/CMakeLists.txt:88 (include)

# INSTALL(FILES ${lua_headers} DESTINATION ${CMAKE_INSTALL_INCLUDEDIR}/lua)
# INSTALL(TARGETS lualib DESTINATION ${CMAKE_INSTALL_LIBDIR})
#
# IF(NOT IOS)
#   INSTALL(TARGETS lua DESTINATION ${CMAKE_INSTALL_BINDIR})
# ENDIF()

redpajama_set_name: RedPajamaGithub


All qualified candidates will be scheduled for an interview with Congressman Huffman's Service Academies Advisory Board in December. The Board will interview candidates with a minimum SAT score of 550 verbal and 550 math or ACT score of 23 for English and 27 for math. The College Board reporting numbers are: SAT-#0255 and ACT-#7241. Candidates must also maintain a 3.0 GPA or better. All candidates will be notified in advance of the time and place of their interview.
Upon completion of the interviews, the Service Academies Advisory Board will notify Jared of their recommendations for nomination, and notification will be sent to each applicant.
To request a Military Academy Nomination from my office, please complete and submit the below form to my San Rafael District Office.
Print, sign, and submit this form to my San Rafael District office after this application has been generated (below button). Upon receipt of this form, an application packet will be mailed to the student. Please be advised that application files must be fully completed no later than November 15th in order for students to be considered for a nomination.


text:
Q: Defining custom sectioning commands In a document of mine (scrbook class) I have to describe several different scenarios as part of a subsection. I originally used \subsubsection for each which are not numbered with the default setting of secnumdepth. I could change that counter but having something 1.2.3.1 for a scenario would not look good.
A problem is that I can't proper \reference a specific scenario like this because the \label would point to the parent \subsection. Using a enumerate environment isn't really an option here as well.
I would now define a sectioning-like macro \scenario which

*

*Is formatted like \subsubsection* of the used class (scrbook in my case).

*Starts with Scenario \thescenario:~, where \thescenario would be a single integer (1, 2, ...) independent of the parent section numbers.

*Can be \labeled and referenced correctly using hyperrefs \autoref.

My first approach was the following:
\documentclass{scrbook}
\usepackage{hyperref}
\newcounter{scenario}
\newcommand{\scenarioautorefname}{scenario}
\newcommand{\scenario}[1]{%
   \refstepcounter{scenario}%
   \subsubsection*{Scenario~\thescenario: #1}%
   %\refstepcounter{scenario}%
}%

\begin{document}
\chapter{MWE}
\section{Grandparent}
\subsection{Parent}
\scenario{Foo}\label{sce:foo}
...
\scenario{Bar}\label{sce:bar}
...
In \autoref{sce:foo} ...
\end{document}

This gives me the format of \subsubsection*, but the issue is that it interferes with the \refstepcounter. If I put \refstepcounter{scenario} before it, the scenario number is correct but the \autoref will use subsubsection not scenario for the reference. If I put it at the end of the macro the reference name is correct but the number is off by one, i.e. one to low. Setting the number initially to 1 gives my the correct number in the \scenario line and the correct name in \autoref but there the number is off by one again, this time one to high.
How can I define such a sectioning-like macro? I personally wouldn't mind using Koma-Script macros to do so, but would welcome a class-independent solution more.

A: One possible solution using titlesec (to define a new seccional unit for the "Scenarios"), and hyperref:
\documentclass{scrbook}
\usepackage{titlesec}
\usepackage{hyperref}

\titleclass{\scenario}{straight}[\chapter]
\newcounter{scenario}

\setcounter{secnumdepth}{3}

\titleformat{\scenario}
  {\sffamily\normalsize\bfseries}{}{0em}{Scenario \thescenario:~}
\titlespacing*{\scenario}{0pt}{3.25ex plus 1ex minus .2ex}{1.5ex plus .2ex}

\newcommand{\scenarioautorefname}{scenario}

\begin{document}

\tableofcontents
\chapter{MWE}
\section{Grandparent}
\subsection{Parent}
\scenario{Foo}\label{sce:foo}
\scenario{Bar}\label{sce:bar}
...
In \autoref{sce:foo} ...
In \autoref{sce:bar} ...

\end{document}

EDIT: As Martin Scharrer mentions in the comments, with these settings each scenario has also an associated  PDF bookmark at the chapter level. To control the level of the bookmarks it's enough to define \toclevel@scenario to have the appropriate value (e.g., the depth of the desired sectional unit for the bookmark).
To set the scenario toc depth, it's necessary to define \l@scenario, which will control the actual typesetting of the entries in the ToC.
As an example, to force scenario to behave as a subsubsection in both the ToC (no entry, unless the value of tocdepth is set to 3 or greater) and in the PDF bookmarks (no bookmark), something like the following lines of code need to be added to the example code above:
\makeatletter
  \def\toclevel@scenario{3}
  \def\l@scenario{\@dottedtocline{3}{3.8em}{3.2em}}
\makeatother


text:
Muse: An exploration of the female form
HomeAnimation & Film
10 - 14 ← Prev 14 15 16 17 18 Next → 18 - 22
The Art of Mutafukaz: The Movie
Very Fine in Fine dustjacket, Paris, Ankama, 2018, 1st, 9791033505297, 9.25 inches, 11.25 inches, 368 pages, over 1200 color illustrations, Hardcover, pictorial boards, English, French
This French animation art book is fully bilingual in English and French. Mutafukaz, aka MTKZ, directed by Shoujirou Nishimi and Shinji Kimura from Studio...
From All of Us to All of You: The Disney Christmas Card - Signed First Edition
Jeff Kurtti, Kurtti, Jeff, Very Fine, issued without dustjacket, Los Angeles, Disney Editions, 2018, 1st, 9781368018715, 11 inches, 11.75 inches, 144 pages, color illustrations, Hardcover, pictorial boards, English
A First Printing signed by Jeff Kurtti on November 29th. The first printing is sold out and the publisher is rushing out a second printing. According to...
They Drew as They Pleased, Vol. 4: The Hidden Art of Disney's Mid-Century Era: The 1950s and 1960s
Didier Ghez, Ghez, Didier, Very Fine in Very Fine dustjacket in publisher's shrinkwrap, Chronicle Books, San Francisco, 2018, 978-1452163857, 9.5 inches, 11.5 inches, 224 pages, color and black & white illustrations, Hardcover, pictorial boards, English
Lee Blair, Mary Blair, Tom Oreb, John Dunn, and Walt Peregoy are featured in this volume. From the publisher: The 1950s and 1960s at The Walt Disney...
Daan Jippes
Daan Jippes: Adventurer in Comics and Animation - In English - Signed Limited
Jan-Willem de Vries, Bob Foster, Daan Jippes, de Vries, Bob Foster, Jan-Willem, Jippes, Daan, Very Fine, Groningen, Het Nederlands Stripmuseum, 2017, 1st, 978-90-825963-1-1, 11.75 inches, 8.25 inches, 160 pages, over 360 color and black & white illustrations, Softcover, wraps, English
Signed by Daan Jippes. Daan traveled from the Netherlands and made his only U.S. convention appearance at our booth at WonderCon Anaheim...
They Drew as They Pleased, Vol. 5: The Hidden Art of Disney's Early Renaissance: The 1970s and 1980s
Didier Ghez, Ghez, Didier, Very Fine in Very Fine dustjacket, Chronicle Books, San Francisco, 2019, 9781452178707, 9.5 inches, 11.5 inches, 208 pages, color and black & white illustrations, Hardcover, boards, English
In the 1970s and 1980s, the Disney animation studio redefined its creative vision in the wake of Walt Disney's death. This latest volume from renowned...
Marvel's Ant-Man and the Wasp: The Art of the Movie
Very Fine in Very Fine slipcase, Marvel, 2018, 9781302909062 , 10.75 inches, 11.75 inches, 240 pages, color illustrations, Hardcover, pictorial boards, English
Each entry in Marvel's ART OF series is slipcased and filled with art by the visual development team. This collectible volume contains pages of full-color...
Vinyl Conflict: The World of Godzilla Toys - Exhibition & Auction Catalog
Very Fine, issued without dustjacket, in publisher's shrinkwrap, Peekaboo Gallery, Montrose, 2019, 1st, 11.25 inches, 8.75 inches, 290 pages, over 1000 color illustrations, Hardcover, pictorial boards, English
A beautifully Illustrated, art book and commemorative catalog for the biggest Godzilla exhibition & auction ever. This is a limited edition silver foil...
Marvel's Captain Marvel: The Art of the Movie
Very Fine in Very Fine slipcase, Marvel, New York, 2019, 9781302915278, 10.75 inches, 11.75 inches, 240 pages, color illustrations, Hardcover, pictorial boards, English
Go behind the scenes of the Captain Marvel film. This collectible volume is full of exclusive concept art and interviews with the creators behind Marvel's...
Spider-Man: Homecoming - The Art of the Movie
Go behind the scenes in this new keepsake volume continuing Marvel's popular ART OF THE MOVIE collection! Discover exclusive concept art, production stills...
Tony Benedict
Hanna-Barbera Offices Signed & Numbered Print Set
Tony Benedict, Benedict, Tony, One of 100 numbered copies signed by the artist, Very Fine, Nemo Academy/La Citta della Nuvole, Florence, Italy, 2019, 1st, 11.75 inches, 16.5 inches, black & white, Softcover, English
Hanna-Barbera alum Tony Benedict depicts the executive offices of Bill Hanna and Joe Barbera with all their accoutrements. A pair of limited edition...
Georgii Stenberh, and Vladimir Stenberg
Stenberg Brothers: Constructing a Revolution in Soviet Design
Christopher Mount, Georgii Stenberh, Vladimir Stenberg, Mount, Christopher, Stenberh, Vladimir Stenberg, Georgii, Fine, Museum of Modern Art, New York, 1997, 2nd, 12 inches, 9 inches, 96 pages, color, Softcover, wraps, English
From the publisher: The Stenberg brothers, like their contemporaries Aleksandr Rodchenko and El Lissitzky, were artists of immensely varied interests and...
Florian Satzinger
Duck: Birds and Pencils
Florian Satzinger, Satzinger, Florian, Very Fine, issued without dustjacket, Brandstudio, New York, 2010, 1st, 12.5 inches, 8.75 inches, 48 pages, color, hardcover, pictorial boards, English
Out of print. Alberto Ruiz: "For those of you who don't know who Florian Satzinger is (and there aren't many of you) He's an Austrian animator...
They Drew as They Pleased, Vol. 6: The Hidden Art of Disney's New Golden Age
Award-winning Disney historian Didier Ghez profiles artists Joe Grant, Hans Bacher, Mike Gabriel, and Michael Giaimo. Explores the 1990s through 2010s...
Samwise Didier
Brutal: The Art of Samwise
Samwise Didier, Didier, Samwise, Very Fine, issued without dustjacket, New York, Cernunnos, 2020, 1st, 9781419747755, 11.75 inches, 9 inches, 304 pages, color and black & white illustrations, Hardcover, pictorial boards, English
From the publisher: The first monograph by the art director for leading video game company Blizzard Entertainment Brütal: The Art of Samwise is a...
Laurent Durieux
Mirages: The Art of Laurent Durieux
Laurent Durieux, Durieux, Laurent, Very Fine, issued without dustjacket, New York, Cernunnos, 2020, 1st, 9782374951492, 11.75 inches, 9 inches, 254 pages, color illustrations, Hardcover, pictorial boards, English
From the publisher: Laurent Durieux is a famous Belgian illustrator who is well known by pop culture fans and collectors for his cult movie poster...
The Disney Princess: A Celebration of Art and Creativity
Charles Solomon, Solomon, Charles, Very Fine, issued without dustjacket, Chronicle Books, San Francisco, 2020, 9781452159119, 10.5 inches, 8.5 inches, 240 pages, color and black & white illustrations, Hardcover, boards, English
From the publisher: This landmark book serves as the definitive visual history of the Disney princess from 1937 to today. Get an inside look at how...
How to Paint Characters the Marvel Studios Way
Very Fine in Very Fine dustjacket, New York, Marvel, 2019, 1st, 9781302913144, 11.2 inches, 7.5 inches, 200 pages, over 300 color illustrations, Hardcover, pictorial boards, English
The Artists of Marvel Studios Visual Development: Ryan Meinerding, Charlie Wen, Andy Park, Phil Saunders, Jackson Sze, Rodney Fuentebella, Anthony...
Out of the Inkwell: Max Fleischer and the Animation Revolution
Richard Fleischer, Fleischer, Richard, Very Fine in Very Fine dustjacket, Lexington, University Press of Kentucky, 2005, 1st, 9780813123554, 8.98 inches, 6.32 inches, xiv, 186 pages, 32 pages of black and white photographs, Hardcover, cloth spine, English
The story of animator Max Fleischer written by his son, director Richard Fleischer. Foreword by Leonard Maltin. 200 pages of text plus 32 pages of black and...
Haruhiko Mikimoto Character Design Archives (Updated English Edition)
Haruhiko Mikimoto, Mikimoto, Haruhiko, Very Fine, issued without dustjacket, Tokyo, Pie International, 2020, 1st, 9784756253132, 11.7 inches, 8.3 inches, 208 pages, color and black & white illustrations, Hardcover, pictorial boards, English
From the publisher: The ultimate illustration collection of Haruhiko Mikimoto, one of the greatest character designers in Japanese animation, now...
So Deadly, So Perverse 50 Years of Italian Giallo Films
Troy Howarth, Howarth, Troy, Very Fine, Baltimore, Midnight Marquee Press, Inc., 2015, 1st, 9781936168507, 11 inches, 8.5 inches, 236 pages, color, Softcover, color wraps, English
From the publisher: Vol. 1: 1963-1973 Beginning with the release of Mario Bava's THE GIRL WHO KNEW TOO MUCH in 1963, Italian filmmakers developed and...
The Art of Ghost in the Shell
David S. Cohen, Cohen, David S., Very Fine, issued without dustjacket, in publisher's shrinkwrap, Titan Books, London, 2017, 9781785655272, 13 inches, 9.5 inches, 160 pages, color illustrations, Hardcover, pictorial boards, English
From the publisher: Witness the incredible artwork behind the creation of Ghost in the Shell, the live-action feature film based on the Japanese manga...
Awaking Beauty: The Art of Eyvind Earle (Near Fine)
Ioan Szasz, Eyvind Earle, Szasz, Ioan, Earle, Eyvind, Fine in Near Fine dustjacket (quarter-inch closed tear to otherwise Fine dustjacket), San Francisco, Walt Disney Family Foundation Press, 2017, 3rd, 978-1681882710, 10 inches, 12.5 inches, 176 pages, over 250 color and black & white illustrations, Hardcover, cloth, English
From the publisher: This lavish art book showcases an unprecedented collection of artworks spanning Earle's entire life as an artist - from his early...
Chromaphile
Ragnar, Ragnar, Fine, Los Angeles, Baby Tattoo, 2005, 1st thus, 9780972938891, 11 inches, 8.7 inches, 80 pages, color, softcover, French wraps, English
Ragnar is a designer in the animation industry but he still has time to create posters and prints in a fifties nostalgic flat retro style. This was his...
The Art of Star Wars: Galaxy's Edge
Amy Ratcliffe, Ratcliffe, Amy, Very Fine in Very Fine dustjacket in publisher's shrinkwrap, Harry N. Abrams, New York, 2021, 9781419750120, 11 inches, 11.75 inches, 256 pages, color illustrations, Hardcover, pictorial boards, English
Theme park design and Star Wars! There are not many books dedicated to a theme park attraction--let alone contemporaneous accounts of a new attraction!...


The Brunei restaurant scene is really booming and it's no surprise that more and more quality new restaurants are emerging in Brunei. I was really happy to hear that a chef who has won quite a number of awards in the cooking industry is actually introducing his unique recipes in Brunei.
Chef Sun with his medals from the international culinary scene. Impressive.
He has apprenticed under one of my favourite legendary chefs Martin Yan as well!
You will be able to see one of his medals within the restaurant, which is located at Batu Bersurat's Yi Yuan Ting Pondok Empat Laut. At the moment, the head chef at the restaurant has 25 years experience (worked in Australia, Singapore and Malaysia), trained and worked under Chef Sun for many years together. Chef Sun, himself will come from time to time to ensure quality is maintained while introducing new menus to Brunei.
Yi Yuan Ting showcases quality Chinese Fine Dining dishes that you normally won't see in typical Chinese restaurants. They have quite a comfortable Chinese Oriental décor – round tables for bigger groups and square tables for smaller groups.
Diners who had eaten at Pondok Empat Laut last time – famous for their duck will remember the ambience but this time – the menu is very different and shows a lot of promise thanks to Chef Sun's secret recipes. Now let's take a look at some of their soft launching dishes. At the moment, they have not launched the full menu yet – but there's quite a good selection to choose from.
Of course – you must enjoy it with Chef Sun's Signature Custard Butter Sauce ~~~ oooooh yeshhh!!
We continue with more appetizers – these Golden Shrimp Rolls are really addictive!
Got Cheese? Yes Please ~~~~~ melting goodness!
We're really getting carried away with the fried stuff ~~ but who can say no to these?! Crispy stuffed fish fillet, topped with mango salsa and ebiko ~~ mmmm ~~~ a good combination!
Their Thai style Fish Head Curry is really good as well – Shinny (The Collective Arts) was enjoying this with me and absolutely loved this! The manager shares that this recipe is learned for the Royal Kitchens In Thailand. Seriously good stuff here ~~ now pass me some steamed rice to soak up the gorgeous curry sauce! Shinny says she could drink the curry on its own ~~ like a bowl of soup!!
Next is this very nice crispy fried eggplant – served with chicken floss and crispy ground shrimp flakes (if I am not mistaken) – which is very delicious. I dare say it's one of the best deep fried eggplant dishes I've tasted – texture is seriously yum!
Now this is the epic dish! The Sweet and Sour Chicken – served on ice with assorted diced fruits! What's surprising is that the battered chicken and sauce stays crispy (special technique from using the ice) and goes very well with the fresh fruits! An eye opening dish that's one of the signatures of Chef Sun!
A gorgeous contrast of textures, colour and packed with natural flavours! Spot on! Thumbs up!
Currently Yi Yuan Ting Fine Dining Pondok Empat Laut Restaurant is still in it's soft opening stage but it's good to pop by and try out some of their signature dishes available! I seriously can't wait to try more of the new menus ~~ and Chef Sun himself would come over to launch new dishes from time to time! The restaurant also has Brunei HALAL certification.
Chef Sun will be hosting cooking classes and cooking demonstrations for the Bruneian Public in future – so stay tuned.
Sunday and Public Holiday: 9:30 am – 3:00 pm, 06:00pm – 10:00pm.


text:
THREE YEARS ON: THE EAGLES' GLENN FREY REMEMBERED
by admin | Jan 18, 2019 | Music News
It was three years ago today (January 18th, 2016) that Eagles' co-founder, guitarist, and songwriter Glenn Frey died in New York City due to complications from Rheumatoid Arthritis, Acute Ulcerative Colitis and Pneumonia. He was 67-years-old. Against all odds, after a period of mourning, the surviving Eagles -- Don Henley, Joe Walsh, and Timothy B. Schmit -- decided to forge ahead and hit the road with Frey's then-23-year-old son Deacon Frey and country star Vince Gill stepping in to cover Frey's classic songs.
It was reported earlier this week that on behalf of the Frey estate, Glenn Frey's widow, Cindy Frey, is seeking $12 million from the doctor she blames for her husband's death. Cindy Frey is suing gastroenterologist Dr. Steven Itzkowitz for $12 million in lost earnings to her family due to Glenn's death. She claims that in 2015 -- the year before Frey's death -- Itzkowitz was negligent in treating the Glenn's ulcerative colitis.
PageSix.com reported Cindy Frey's suit puts forth that "the doctor failed to 'promptly and properly assess the patient for respiratory issues and ignored an infection.' As a result of his death, his family was deprived of his care, guidance and support, and they have suffered pecuniary damage." The report states that Itzkowitz believes that Frey could not have earned another $12 million had he lived passed 67.
The first sign that Glenn Frey was in ill health came in November 2015 when it was announced that his upcoming intestinal surgery would push back the Eagles' 2015 Kennedy Center Honors until the following year, due to his suffering a recurrence of "previous intestinal issues, which will require major surgery and a lengthy recovery period." In 1990, Frey underwent surgery to remove a large part of his large intestines. His intestinal troubles have blocked several other Eagles events over the years; back in 1986 stomach issues prevented Frey from reuniting with Don Henley at a rare post-split benefit appearance in California, and the group's 1995 Hell Freezes Over reunion tour was thrown off track while Frey dealt with diverticulitis.
Following Glenn Frey's death, songwriting partner and Eagles co-founder Don Henley spoke lovingly of his late friend in a prepared statement:
He was like a brother to me; we were family, and like most families, there was some dysfunction. But, the bond we forged 45 years ago was never broken, even during the 14 years that the Eagles were dissolved. We were two young men who made the pilgrimage to Los Angeles with the same dream: to make our mark in the music industry -- and with perseverance, a deep love of music, our alliance with other great musicians and our manager, Irving Azoff, we built something that has lasted longer than anyone could have dreamed. But, Glenn was the one who started it all. He was the spark plug, the man with the plan. He had an encyclopedic knowledge of popular music and a work ethic that wouldn't quit. He was funny, bullheaded, mercurial, generous, deeply talented and driven. He loved his wife and kids more than anything. We are all in a state of shock, disbelief and profound sorrow. We brought our two-year History Of The Eagles Tour to a triumphant close at the end of July and now he is gone. I'm not sure I believe in fate, but I know that crossing paths with Glenn Lewis Frey in 1970 changed my life forever, and it eventually had an impact on the lives of millions of other people all over the planet. It will be very strange going forward in a world without him in it. But, I will be grateful, every day, that he was in my life. Rest in peace, my brother. You did what you set out to do, and then some.
We spoke to one of Frey's oldest friends, the great Bob Seger, who described him to us as being like his "little brother." Seger, who co-wrote the Eagles' last Number One hit, "Heartache Tonight," spoke lovingly about his buddy from back home in Detroit: "I knew him 50 years, he was brilliant. He was a classically trained pianist; the chords you hear on 'The Last Resort' and on 'Desperado' -- that's him playing the piano. He wrote those chords. Henley probably wrote the bulk of the lyrics, but that's Glenn. He was a brilliant pianist, classically trained since he was a very young kid. He was (laughs) a joy to be around. I looked forward to seein' him -- I didn't see him all that much over the last 50 years, 'cause he was busy, I was busy, but when I did, it was memorable (laughs), 'cause he had an amazing sense of humor, and just whip smart. Whip smart. And I don't know how you quantify songwriting, but if you do it on the dollars and cents scale -- he's one of the most successful songwriters that ever lived."
Seger, who dedicated his 2017 album, I Knew You When, to Frey, came up with the Eagles leader back home in Detroit and told us that Glenn Frey and music were pretty much, one and the same: "They had a nickname for him in the Eagles, they called him 'The Lone Arranger.' People would bring in a song and Glenn would arrange it. That was his nickname -- 'The Lone Arranger.' And of course, he loved soul music. He loved Marvin Gaye, he loved Al Green, he loved Otis Redding -- he named his last kid after Otis Redding. Otis is his youngest kid, y'know, 16-years-old."
Seger told us that it'll be rough without Glenn Frey: "Y'know, I'm gonna miss him like crazy. We would always get together whenever he came to Detroit. He was. . . He was a good kid. He was a really good kid. I never thought I'd outlive him. I really feel bad for doin' that, 'cause he should've lived longer."
Singer-songwriter J.D. Souther, who scored major solo hits with 1979's "You're Only Lonely" and his 1981 duet with James Taylor on "Her Town Too," is best known for co-writing such Eagles classics as "The Best Of My Love," "Heartache Tonight," "Victim Of Love," "New Kid In Town," and "The Sad Cafe," as well as Don Henley's "The Heart Of The Matter." We asked Souther if while composing with Henley and Frey he ever felt a friendly competition within the trio: "With those guys, yeah, 'cause we were all critical beyond belief. I mean (laughs) y'know. . . I mean we're funny guys, and we were friends so it was a blast to do, but we were very critical while we were writing it. Probably the nicest complement that you would ever hear between the three of us, if someone came up with an idea and deposited a line, the best you would probably hear from the other two guys was, 'Yeah, I think we could say that.' And that was a compliment."
Eagles songwriter and Glenn Frey's solo collaborator, Jack Tempchin, shed light on how the pair came up with Frey's 1985 hit, "Smuggler's Blues": "Glenn came down to visit me in San Diego. He had just purchased the rights to the book Snowblind, and they -- he and (manager) Irving Azoff -- were thinking maybe they were going to make a movie. And the deal was, 'Well, let's write a song, Jack, for this movie.' He already knew he wanted slide guitar and be a cool, bluesy thing called 'Smuggler's Blues' and have it be from the point of view of the guy that sells the drugs, y'know, and flies around. So, we both had a lot of strong political feelings about the so-called 'war on drugs,' y'know? But he already had the concept that this'll be, like, slide guitar and kinda cool. So we just started cutting it in my little studio there."
We asked Glenn Frey if he's ever truly sat down and contemplated the Eagles' importance in popular culture: "Oh listen, we are just a blip on the screen, babe. Y'know, we don't even think about those kind of things, although we've been, we've been around a while now, so we will rank as a band that was around for a while. But it's not for us to say."
Glenn Frey, who co-founded the Eagles in 1971 with Don Henley, Bernie Leadon, and Randy Meisner, will be remembered as one of the most important and consistent hitmakers of the 1970's for the songs he wrote with Henley, and often in conjunction with his pre-fame duo partner, J.D. Souther. Frey co-wrote such era defining tunes as "Tequila Sunrise," "Desperado," "Best Of My Love," "Lyin' Eyes," "Take It To The Limit," "One Of These Nights," "Hotel California," "New Kid In Town," "Life In The Fast Lane," "Victim Of Love," "Heartache Tonight," "I Can't Tell You Why," and "The Long Run" -- along with the band's signature hit, "Take It Easy," which he wrote with Jackson Browne. Like the Beatles, the Eagles shined by featuring two distinct lead voices, with Henley and Frey divvying up their catalogue to suit each other's vocals.
Born on November 6th, 1948 in Detroit, Michigan, Frey had been playing in bands in and around the Motor City for years -- and nearly permanently joined forces in the late-'60s with Bob Seger. He made his way out to L.A. not for a shot at stardom, but as a last-ditch effort to reunite with his ex-girlfriend who had moved west to become a singer. He soon teamed up with J.D. Souther to form the short-lived duo, Longbranch/Pennywhistle, who released one album in 1969 on the Amos label. Frey soon met his musical fate while he and the rest of the soon-to-be Eagles backed Linda Ronstadt for a 1971 summer tour. The Eagles originally split in 1980 and reformed in 1994 and have toured the world regularly ever since.
The Eagles' last collection, 2007's Long Road Out Of Eden, was the band's sixth chart-topper and was the highest selling album of the year. To date, it has sold over seven million copies in the U.S. alone.
With the Eagles, Frey earned six Grammy Awards, and with the band and on his own, landed 24 singles in the Top 40 -- including the chart-toppers "Best Of My Love," "One Of These Nights," "New Kid In Town," "Hotel California," and "Heartache Tonight."
The Eagles, who were inducted into the Rock and Roll Hall of Fame in 1998, have sold over 120 million albums globally. Last August, the Recording Industry Association of America (RIAA) certified the band's 1976 compilation, Their Greatest Hits 1971-1975, 38-times Platinum, accounting for sales and streams of more than 38 million copies since its release in February of 1976. In addition to the new benchmark, the Eagles' followup to the classic compilation, the watershed Hotel California album, released in December 1976, is now the third best-selling album of all time, certified 26-times Platinum by the RIAA for sales and streams of more than 26 million copies.
Don Henley and Glenn Frey were induced into the Songwriters Hall of Fame in 2000.
Following the Eagles' 1980 split, Frey's solo career initially boomed, teaming up with Eagles songwriter Jack Tempchin for a string of Top 40 hits -- including the 1985 Top Two hit, "You Belong To The City" which was featured on the soundtrack to Miami Vice, "Smuggler's Blues" -- which inspired an episode of the NBC cop drama -- and kicked off an acting career for Frey, who was featured in a notable cameo in Cameron Crowe's 1996 film Jerry McGuire. Frey also scored a Top Two hit in '85 with a tune he didn't write -- "The Heat Is On" -- as featured in the classic Eddie Murphy comedy, Beverly Hills Cop.
In 2012, Frey released his first solo album in nearly 20 years, the standards collection, After Hours. The set, which was long awaited followup to Frey's last album, 1992's Strange Weather, featured a string of American classics -- but stretched the "American Songbook" genre to include songs through the 1960's, including Burt Bacharach & Hal David's "The Look Of Love" and Brian Wilson and the Beach Boys' Pet Sounds closer, "Caroline, No."
In 2013 the Eagles released History Of The Eagles Part 1 & 2, the band's three-hour documentary. The three-disc set includes the bonus disc, Eagles Live At The Capital Centre - March 1977, featuring never-before-released performances from the band's two-night stand at Landover, Maryland's Capital Center during the legendary Hotel California tour.
In 2014 Glenn Frey inducted Linda Ronstadt into the Rock and Roll Hall of Fame. The Eagles -- with special guest Bernie Leadon -- toured the world throughout 2013, 2014, and 2015.
Frey was posthumously awarded the Kennedy Center Honor in December 2016.
Released last May is the definitive Glenn Frey solo retrospective, the four-disc set, Above The Clouds: The Collection. Highlights on the set include such solo hits as "The Heat Is On," "The One You Love," "Part Of Me, Part Of You," "You Belong To The City," and "Smuggler's Blues," among others. In addition, the set includes a live DVD featuring Frey performing some of his most beloved Eagles classics taped live on September 15th, 1992 in Dublin, Ireland.
Above The Clouds is most notable for the first CD reissue of the 1969 self-titled Longbranch/Pennywhistle album featuring Frey and frequent Eagles collaborator, J.D. Souther.
AUDIO: GLENN FREY SAYS THE EAGLES DON'T WORRY ABOUT THEIR PLACE IN ROCK HISTORY
AUDIO: JACK TEMPCHIN ON 'SMUGGLER'S BLUES'
AUDIO: J.D. SOUTHER ON WRITING WITH DON HENLEY AND GLENN FREY
AUDIO: BOB SEGER REMEMBERING GLENN FREY
AUDIO: BOB SEGER ON GLENN FREY'S MUSICALITY
AUDIO: BOB SEGER ON GLENN FREY


text:
Home | National | Campaigning at peak in poll bound states
Campaigning at peak in poll bound states
With polling over in Chhattisgarh, campaigning fever has now reached its peak in other election bound states of Rajasthan, Madhya Pradesh, Mizoram and Telangana.
Polling for 230 assembly seats of Madhya Pradesh and 40 seats of Mizoram assembly will take place on 28th of this month.
Voting for 200 seats of Rajasthan assembly and 119 seats of Telangana assembly will be held on December 7.
Counting of votes for all the four states will take place on December 11.
All the political parties are doing their best to woo the voters with stalwarts and senior leaders criss-crossing the states to address election rallies.
Union Home Minister Rajnath Singh is in Madhya Pradesh for campaigning for BJP candidates for the upcoming assembly polls. Addressing a press conference in Bhopal, Rajnath Singh launched a scathing attack on Congress. He said that the party despite ruling for decades failed to deliver and Madhya Pradesh too suffered because of Congress' misrule.
Electioneering has reached a feverish pitch in Mizoram as leaders of various political parties are leaving no stone unturned to woo the voters.
BJP, in its Vision Document has promised the inclusion of Mizo language in 8th Schedule of the Constitution. They also promised pothole-free roads by next 6 months, if voted to power.
The Party also promised to set up 3 engineering colleges, 2 medical colleges and 3 nursing training institutes and create 50,000 job opportunities in next 5 years.
On the other side, Congress President Rahul Gandhi in a rally at Champhai and Aizawl said that in the last 5 years the state achieved 5 percent increase in production of agricultural and horticultural produces.
He said Congress Government has established first medical college in the state and mooting for making the state Global Centre of Car Racing.
BJP blames Congress for 1984 anti-Sikh riots
Police arrest one person involved in Amritsar grenade attack
Four new ministers take oath in Goa Cabinet Reshuffle
Rahul Gandhi to appear before Ahmedabad court in defamation case
BJP targets 50 lakh membership in Odisha
Karnataka Political Crisis: All Congress and JDS Ministers resign
PM Modi launches BJP's membership drive in Varanasi


How Do I Choose A Residential Locksmith in Aspendale Gardens?
Locksmiths in Aspendale Gardens offer a highly demanded service, which generally relates to maintaining and installing the various types of lock systems, from the standard key locks to the complex electronic or biometric locks. The most common types of locksmith professions consist of the emergency, industrial, commercial, and residential, which each of the specific fields requiring different skills and abilities.
Residential work is likely to be the most common of the services provided by a mobile locksmith frankston. A domestic property owner looks at personal security and safety as a key reason when it comes to making sure a home is fully secured against a would-be intruder. A locksmith has gained the experience and knowledge to suggest the most effective locks for a properties doors and windows. Beyond the ability to install new locking systems, the locksmith is also able to repair or replace the locks on the older styled properties. Extra services offered by a local locksmiths offer security advice, a key cutting service, installing locks on a garage or similar outbuilding, and installing at-home safes or vaults.


text:
Q: Convert query from sql type in mongodb type I am working in python with pymongo.
I have a query in psql that looks like this :
cursor.execute("select id13 from nc_durhamallwithorder where date2 >='2010-01-01' and date2<='2011-01-01'"),

Now i want to convert that query in mongodb type.
I did something like this
cursor=mycol1.find({"$and": [ { "date2": { "$gte": "2010-01-01" } }, { "date2": { "$lte":"2011-01-01" } } ]  } )

This works fine but i want to select only id13
I thought something like this:
cursor=mycol1.find({"id13":1},{"$and": [ { "date2": { "$gte": "2010-01-01" } }, { "date2": { "$lte":"2011-01-01" } } ]  } )

But it doesnt work.Can someone help me?

A: You can use pass a second argument with a dict and the fields you want to keep
mycol1.find({"$and": [
        { "date2": { "$gte": "2010-01-01" } },
        { "date2": { "$lte":"2011-01-01" } }
    ]},
    {"id13":1}
)