text:
The Missionaries will divide their group in such a way that while some strive in community to acquire the virtues and knowledge proper to a good missionary, others are travelling in the rural areas proclaiming the Word of God.
When their apostolic journeys are over, they will return to the community to rest from their labours by exercising a ministry that is less demanding, and to prepare themselves through meditation and study for a more fruitful ministry when next called upon to undertake new work.
Equilibrium: Eugene wanted a balanced lifestyle of distinct moments of being nourished through prayer, study and a quieter community life in order to be missionaries with more energy, spirituality and knowledge. Unfortunately the zeal of the missionaries overturned this idyllic picture because they could not resist responding with generosity to every urgent need that moved them deeply. Their health was to suffer, and several died in their 20’s. Eugene himself led the pack in exhausting himself for the most abandoned, and on a number of occasions had to be banished by Henri Tempier into a forced rest and recuperation.
The ideal of this equilibrium was wise, and as Eugene got older and wiser we find him urging his Oblates to live by it. He himself as bishop had a demanding daily program as Pastor of the second-largest city of France and Superior General of an expanding missionary congregation – yet he was faithful to his daily times of prolonged prayer, study of Scripture and theology, set times to meet people in his office, and moments of rest.
Complementarity, in that while one group was out in the countryside preaching, those of the community who remained supported them in work and prayer. The missionaries who were out preaching knew that their ministry was being supported and strengthened by the prayers of their brothers.
This entry was posted in RULE and tagged community, parish missions, prayer, study. Bookmark the permalink.
Balance – equilibrium! When we are “most passionate” it is easy to rush off and “do” and yet without the balance of prayer and community mission may suffer.
Equality – complementary! Sometimes we want to “go out”, we want to be missionaries and directly loving the most poor and abandoned – yet we are called directly to stay back within our community to love and support through prayer and a different kind of work. One cannot happen without the other. God gave each of us a unique and special way to live out the call to love. I dare say that one way is not less or more than the other, but rather they are equal in that they complement each other, cannot be done with out the other.

tokenized:
The Missionaries will divide their group in such a way that while some strive in community to acquire the virtues and knowledge proper to a good missionary , others are travelling in the rural areas proclaiming the Word of God .
 When their apostolic journeys are over , they will return to the community to rest from their labours by exercising a ministry that is less demanding , and to prepare themselves through meditation and study for a more fruitful ministry when next called upon to undertake new work .
 Equilibrium : Eugene wanted a balanced lifestyle of distinct moments of being nourished through prayer , study and a quieter community life in order to be missionaries with more energy , spirituality and knowledge . Unfortunately the zeal of the missionaries overturned this idyllic picture because they could not resist responding with generosity to every urgent need that moved them deeply . Their health was to suffer , and several died in their 20 ’s . Eugene himself led the pack in exhausting himself for the most abandoned , and on a number of occasions had to be banished by Henri Tempier into a forced rest and recuperation .
 The ideal of this equilibrium was wise , and as Eugene got older and wiser we find him urging his Oblates to live by it . He himself as bishop had a demanding daily program as Pastor of the second - largest city of France and Superior General of an expanding missionary congregation – yet he was faithful to his daily times of prolonged prayer , study of Scripture and theology , set times to meet people in his office , and moments of rest .
 Complementarity , in that while one group was out in the countryside preaching , those of the community who remained supported them in work and prayer . The missionaries who were out preaching knew that their ministry was being supported and strengthened by the prayers of their brothers .
 This entry was posted in RULE and tagged community , parish missions , prayer , study . Bookmark the permalink .
 Balance – equilibrium ! When we are “ most passionate ” it is easy to rush off and “ do ” and yet without the balance of prayer and community mission may suffer .
 Equality – complementary ! Sometimes we want to “ go out ” , we want to be missionaries and directly loving the most poor and abandoned – yet we are called directly to stay back within our community to love and support through prayer and a different kind of work . One can not happen without the other . God gave each of us a unique and special way to live out the call to love . I dare say that one way is not less or more than the other , but rather they are equal in that they complement each other , can not be done with out the other .


text:
How to talk to girls at parties.
Publisher: [United States] : Dark Horse Comics, 2016.
Publisher: Milwaukie, OR : Dark Horse Books, 2016.
8 of 9 copies available at NOBLE (All Libraries).

tokenized:
How to talk to girls at parties .
 Publisher : [ United States ] : Dark Horse Comics , 2016 .
 Publisher : Milwaukie , OR : Dark Horse Books , 2016 .
 8 of 9 copies available at NOBLE ( All Libraries ) .


text:
East Anglia is a beautiful land of ghosts. In the 13th century this was the most densely populated part of Britain, but the last 700 years have seen a slow decline. As England’s primary economic focus shifted from trade with the Low Countries to its Empire and the great Atlantic ports in the west, large-scale depopulation occured in the east. A common sight in this region today is an incongruously huge medieval church towering over a tiny, shrunken village….
Coastal erosion has been responsible for destroying more of this medieval world, eating into the coast over the centuries, swallowing acres of land and dozens of villages. Even the much-loved waterways of the Norfolk Broads, once thought to be a natural feature, are now known to be the remnants of a peat-digging industry which collapsed after a catastrophic tidal surge of the North Sea in 1287.
Yet elsewhere the ghosts of the past remain intertwined with modern life. In parts of Cambridgeshire and south-east Essex the land is still farmed in grids of small, irregular fields laid out during the Iron Age or Roman period. This is also where you will find one of England’s oldest towns, Colchester. A major settlement for the Celtic tribe the Trinovantes for at least 400 years, it was seized by Claudius’ invading Roman army in 43 AD.
In an attempt to consolidate their grip on the region, the Romans transformed the settlement into an army veterans’ colony, Camulodunum, but this did not save it from the rampaging Iceni, who destroyed the city during their rebellion under Boudicca in 60-61AD.
Today you can see traces of the Roman city, including sections of its walls and the fragmentary Balkerne Gate, the last surviving Roman gateway in Britain. The museum at Colchester Castle, built in the 11th century over a Roman temple, is the best place to assess the city’s history.
The nearby village of Coggeshall boasts two supreme examples of medieval craftsmanship: the late 15th century Paycocke’s House, decorated inside and out with wonderful wood carvings, and the large 13th century Grange Barn, the oldest surviving timber-framed barn in Europe.
To the west near Bishop’s Stortford is another survivor from the 13th century, Hatfield Forest. A forest in the original sense, it has areas of managed woodland alongside open spaces for deer and cattle, plus a man-made rabbit warren. Because the land-use has been consistent for so long, this is also a good place to see wild flowers and plants eradicated in many places by modern agriculture.
A few miles further north, the town of Saffron Walden has several medieval buildings and a huge church, St Mary’s, that the locals will tell you is the largest in Essex. Nearby is Audley End, one of the finest Jacobean houses in England, built for Thomas Howard, Earl of Suffolk. It was later a favourite residence of Charles II, who stayed here when attending the races at Newmarket.
Cambridge has a dizzying number of architectural treasures, most of which are connected to the university. Among the greatest is the 15th century King’s College chapel. Also very worthy are the pretty Tudor courts of Queens’ College, and the light and airy Wren Library, lined with white stucco walls and wooden bookcases by the architect of St Paul’s Cathedral. The Fitzwilliam Museum, a first-class collection of art and antiquities, is the best of the other historical attractions.
On a patch of high ground among the Fens to the north is the cathedral city of Ely. It is perhaps most famous for the exploits of Hereward the Wake, who held out against the Norman army here in 1070, before the Fens had been reclaimed from the marshes and when Ely was still really an island.
The most striking feature of the mostly 13th century cathedral is the octagonal tower at its centre, built after the original collapsed in 1322. You can also visit Oliver Cromwell’s house, where the Protector lived while working as a tithe collector before his rise to fame.
Precisely because of its diminishing status since the Middle Ages, Norwich is still a recognisably medieval city, with an enormous Norman castle. This houses an entertaining museum and art gallery. There is a beautiful cathedral, dominated by its huge spire, the second highest in England. Inside there are some fascinating features, including the 1,106 roof bosses in the nave, on which are carved Biblical scenes from Genesis to Revelations. The interior feels much brighter than in many medieval cathedrals, thanks to the light-coloured stone used in its construction.
Blickling Hall, the superb Jacobean mansion built for the Lord Chief Justice Sir Henry Hobart in 1619, is 15 miles north of Norwich. It replaced an earlier house in which Anne Boleyn spent part of her childhood. According to legend the dead Queen still haunts Blickling, drawing up outside the house on the anniversary of her execution in a coach pulled by headless horses and driven by headless horsemen, holding her own head on her lap.
Among Norfolk’s other memorable stately homes is Houghton Hall, built in the opulent Palladian style for Sir Robert Walpole in 1730, and full of ostentatious decorative touches, such as the carved marble fittings of the Marble Parlour.
The most important historical site in the quiet county of Suffolk is Sutton Hoo. Here one of the greatest archaeological discoveries of the 20th century was made in 1939: the ship burial of a 7th-century Saxon warrior, possibly Raedwald, King of East Anglia, high on a hill above the River Deben. There is an excellent visitor centre and you can walk round the mounds of the burial site.
Further east, towards the border with Essex, you can explore the Stour Valley, searching for the scenes painted by John Constable in the late 18th and early 19th centuries. Flatford Mill is just recognisable as the location of The Hay Wain, near the village of Dedham. Further upstream, the town of Sudbury is linked to another great painter, Thomas Gainsborough, who was born here in 1727 in a house now used as a gallery for his work.
Suffolk is home to some unbelievably pretty villages of timber buildings. The two most celebrated are Long Melford and Lavenham. But the most evocative place in the county is Dunwich, now a tiny village with a museum that tells the story of the death of the medieval town, including six churches and two monasteries, lost to the sea. You can walk along lanes that run straight over the edge of the cliffs, and on stormy nights hear the drowned church bells ringing beneath the waves.

tokenized:
East Anglia is a beautiful land of ghosts . In the 13th century this was the most densely populated part of Britain , but the last 700 years have seen a slow decline . As England ’s primary economic focus shifted from trade with the Low Countries to its Empire and the great Atlantic ports in the west , large - scale depopulation occured in the east . A common sight in this region today is an incongruously huge medieval church towering over a tiny , shrunken village … .
 Coastal erosion has been responsible for destroying more of this medieval world , eating into the coast over the centuries , swallowing acres of land and dozens of villages . Even the much - loved waterways of the Norfolk Broads , once thought to be a natural feature , are now known to be the remnants of a peat - digging industry which collapsed after a catastrophic tidal surge of the North Sea in 1287 .
 Yet elsewhere the ghosts of the past remain intertwined with modern life . In parts of Cambridgeshire and south - east Essex the land is still farmed in grids of small , irregular fields laid out during the Iron Age or Roman period . This is also where you will find one of England ’s oldest towns , Colchester . A major settlement for the Celtic tribe the Trinovantes for at least 400 years , it was seized by Claudius ’ invading Roman army in 43 AD .
 In an attempt to consolidate their grip on the region , the Romans transformed the settlement into an army veterans ’ colony , Camulodunum , but this did not save it from the rampaging Iceni , who destroyed the city during their rebellion under Boudicca in 60 - 61AD .
 Today you can see traces of the Roman city , including sections of its walls and the fragmentary Balkerne Gate , the last surviving Roman gateway in Britain . The museum at Colchester Castle , built in the 11th century over a Roman temple , is the best place to assess the city ’s history .
 The nearby village of Coggeshall boasts two supreme examples of medieval craftsmanship : the late 15th century Paycocke ’s House , decorated inside and out with wonderful wood carvings , and the large 13th century Grange Barn , the oldest surviving timber - framed barn in Europe .
 To the west near Bishop ’s Stortford is another survivor from the 13th century , Hatfield Forest . A forest in the original sense , it has areas of managed woodland alongside open spaces for deer and cattle , plus a man - made rabbit warren . Because the land - use has been consistent for so long , this is also a good place to see wild flowers and plants eradicated in many places by modern agriculture .
 A few miles further north , the town of Saffron Walden has several medieval buildings and a huge church , St Mary ’s , that the locals will tell you is the largest in Essex . Nearby is Audley End , one of the finest Jacobean houses in England , built for Thomas Howard , Earl of Suffolk . It was later a favourite residence of Charles II , who stayed here when attending the races at Newmarket .
 Cambridge has a dizzying number of architectural treasures , most of which are connected to the university . Among the greatest is the 15th century King ’s College chapel . Also very worthy are the pretty Tudor courts of Queens ’ College , and the light and airy Wren Library , lined with white stucco walls and wooden bookcases by the architect of St Paul ’s Cathedral . The Fitzwilliam Museum , a first - class collection of art and antiquities , is the best of the other historical attractions .
 On a patch of high ground among the Fens to the north is the cathedral city of Ely . It is perhaps most famous for the exploits of Hereward the Wake , who held out against the Norman army here in 1070 , before the Fens had been reclaimed from the marshes and when Ely was still really an island .
 The most striking feature of the mostly 13th century cathedral is the octagonal tower at its centre , built after the original collapsed in 1322 . You can also visit Oliver Cromwell ’s house , where the Protector lived while working as a tithe collector before his rise to fame .
 Precisely because of its diminishing status since the Middle Ages , Norwich is still a recognisably medieval city , with an enormous Norman castle . This houses an entertaining museum and art gallery . There is a beautiful cathedral , dominated by its huge spire , the second highest in England . Inside there are some fascinating features , including the 1,106 roof bosses in the nave , on which are carved Biblical scenes from Genesis to Revelations . The interior feels much brighter than in many medieval cathedrals , thanks to the light - coloured stone used in its construction .
 Blickling Hall , the superb Jacobean mansion built for the Lord Chief Justice Sir Henry Hobart in 1619 , is 15 miles north of Norwich . It replaced an earlier house in which Anne Boleyn spent part of her childhood . According to legend the dead Queen still haunts Blickling , drawing up outside the house on the anniversary of her execution in a coach pulled by headless horses and driven by headless horsemen , holding her own head on her lap .
 Among Norfolk ’s other memorable stately homes is Houghton Hall , built in the opulent Palladian style for Sir Robert Walpole in 1730 , and full of ostentatious decorative touches , such as the carved marble fittings of the Marble Parlour .
 The most important historical site in the quiet county of Suffolk is Sutton Hoo . Here one of the greatest archaeological discoveries of the 20th century was made in 1939 : the ship burial of a 7th - century Saxon warrior , possibly Raedwald , King of East Anglia , high on a hill above the River Deben . There is an excellent visitor centre and you can walk round the mounds of the burial site .
 Further east , towards the border with Essex , you can explore the Stour Valley , searching for the scenes painted by John Constable in the late 18th and early 19th centuries . Flatford Mill is just recognisable as the location of The Hay Wain , near the village of Dedham . Further upstream , the town of Sudbury is linked to another great painter , Thomas Gainsborough , who was born here in 1727 in a house now used as a gallery for his work .
 Suffolk is home to some unbelievably pretty villages of timber buildings . The two most celebrated are Long Melford and Lavenham . But the most evocative place in the county is Dunwich , now a tiny village with a museum that tells the story of the death of the medieval town , including six churches and two monasteries , lost to the sea . You can walk along lanes that run straight over the edge of the cliffs , and on stormy nights hear the drowned church bells ringing beneath the waves .


text:
President's Letter - Craig Sterle "Evolution of the Minnesota Division"; Notes from the Fall Board; 2019 Strategic Plan; Conservation Issues Update; Upper Mississippi River Initiative; Energy Committee Update; THANK YOU TO OUR VOLUNTEERS AND DONORS; Fond Farewell; Fay Harrington Memorial Forest; Winter Board of Directors Weekend; Join the Environmental Issues Committee.
President's Letter - Craig Sterle "The Importance of Energy - Part 3"; Notes from the National Convention, Report on Upper Mississippi River Initiative; Notes from the Summer Gathering & Board of Directors'; Ikes in the News; New staff Piper Donlin; Fall Board of Directors' & Strategic Planning info; Help needed to host 2021 National Convention and more.
President's Letter - Craig Sterle "The Importance of Energy - Part 2"; Ikes Step Up for Conservation!; Notes from the Annual Meeting; 2018 Issues Resolutions; Awards Honorees; Announcement Summer Gathering & Board of Directors'; Help Us Host the National Convention.
President's Letter - Craig Sterle "The Importance of Energy"; Don Arnosti - new Division Employee; Notes from the Mid-winter IWLA Board meeting; Notes from the Winter Minnesota Division board meeting; Call for Resolutions; Call for Silent Auction Items; Call for Awards Nominations; Annual Meeting & State Convention information.
President's Letter; Are You Satisfied With Your Outdoor Experience?; Fall Meeting information; News from the National Convention; Len Anderson; Scholarship Winner announced.
President's Letter; Problems Posed by PolyMet; Protect the BWCAW's Watershed; News from the Winter Meeting; Mid-winter IWLA Board meeting; Annual Meeting agenda; Call for Resolutions; Make Awards Nominations; Silent Auction Items needed; Water Action Day; Dakota Access Pipeline; Protect Our Pollinators.
President's Letter -DAPL; What Hath We Wrought - Don Arnosti; Buffer Law Implementation - Jill Crafton; Fall Board of Directors'- Rich Staffon; Great Lakes Ballast Water Project - Rich Staffon; The Pipleline Paradox - Craig Sterle; Thank You to Our Donors & Volunteers!; 2016-2017 Scholarship Winners; Winter Strategic Planning & Board of Directors information.
President's Letter: I am Proud to Be an Ike; National Convention; 2016 IWLA Issues Resolutions; Summer BOD Notes; Larry Dolphin Honored; Conservation Issues' Chair Don Arnosti: Sweating the Details; Gary Clancy WMA Memorial; Deep Portage Learning Camp; Fall Gathering & Board of Directors information.
President's Letter (newly elected President John Crampton; Welcome to New Division President by former President Barry Drazkowski; 2016 Legislative Session; News from the Annual Meeting & State Convention; New Officers elected; 2016 Resolutions; In Memoriam: Phil Hinderaker and Al Layman; Spring Appeal.
President's Letter; 2016 Environmental Issues priorities; Chapter news; Report from Winter BOD; 2016 Annual Meeting & State Convention.
President's Letter; Stop PolyMet!; News from the Fall BOD weekend; Kristi Harrington's Tiny House; Call for Awards Nominations; Fossil Fuels; Winter Gathering & BOD info.
Thank You Julie Henricksson!; President's Letter - Ikes Press Forward!; Of Moose & Sharptails; Scholarship Winners; Notes from the Minnesota Division Summer BOD & National Convention; Fall Gathering & BOD Meeting; and more.
All articles written in the following editions of the Waltonian (unless otherwise specified) are written by former Editor Julie Henricksson. THANK YOU JULIE!
President's Letter: Issues & Action; Fifth Annual Legacy Forum; Roads Taking Their Toll on Turtles; MN GreenStep Cities; Call for Resolutions; Award Nominations; Annual Meeting Registration/Information.
President's Letter: Threat to Wetlands Conservation Act; Issues Committee priorities; Jill Crafton; Fall Board Notes; Chapter News; Winter Board of Directors' and Strategic Planning Meeting announcement; Thank you to Volunteers and Donors; New Member Offer; Forest Memorials; Watershed 2015 Summit date announced.
Welcome Don Arnosti to the Environmental Issues team!; New Member Offer; Summer Board Notes; Chapter News; Impacts of Bakken oil in Minnesota; Suggested reading; SNA Update; and news from the National Convention.
President's Letter "Renew Yourself & Engage"; News from the Annual Meeting & State Convention; Awards; Scholarship Auction; Issues Resolutions; Obituary - George Barthel; Natural Playgrounds; Wood Duck Houses Project; Summer BOD announcement and info.
President's Letter "Thank You, Ikes"; Winter Board & Strategic Planning summaries; Farm Bill recap; PolyMet SDEIS public meetings; Monarch Butterfly's dwindling numbers; Watershed Summit recap; Managing Minnesota's Water event recap; Minnesota Valley State Trail; Scholarship program; Call for Awards nominations & Resolutions; Annual Meeting & State Convention agenda & registration.
The Minnesota Waltonian is published four times a year December, March, June & September. Copy deadline is the 8th of the month prior to publication.

tokenized:
President 's Letter - Craig Sterle " Evolution of the Minnesota Division " ; Notes from the Fall Board ; 2019 Strategic Plan ; Conservation Issues Update ; Upper Mississippi River Initiative ; Energy Committee Update ; THANK YOU TO OUR VOLUNTEERS AND DONORS ; Fond Farewell ; Fay Harrington Memorial Forest ; Winter Board of Directors Weekend ; Join the Environmental Issues Committee .
 President 's Letter - Craig Sterle " The Importance of Energy - Part 3 " ; Notes from the National Convention , Report on Upper Mississippi River Initiative ; Notes from the Summer Gathering & Board of Directors ' ; Ikes in the News ; New staff Piper Donlin ; Fall Board of Directors ' & Strategic Planning info ; Help needed to host 2021 National Convention and more .
 President 's Letter - Craig Sterle " The Importance of Energy - Part 2 " ; Ikes Step Up for Conservation ! ; Notes from the Annual Meeting ; 2018 Issues Resolutions ; Awards Honorees ; Announcement Summer Gathering & Board of Directors ' ; Help Us Host the National Convention .
 President 's Letter - Craig Sterle " The Importance of Energy " ; Don Arnosti - new Division Employee ; Notes from the Mid - winter IWLA Board meeting ; Notes from the Winter Minnesota Division board meeting ; Call for Resolutions ; Call for Silent Auction Items ; Call for Awards Nominations ; Annual Meeting & State Convention information .
 President 's Letter ; Are You Satisfied With Your Outdoor Experience ? ; Fall Meeting information ; News from the National Convention ; Len Anderson ; Scholarship Winner announced .
 President 's Letter ; Problems Posed by PolyMet ; Protect the BWCAW 's Watershed ; News from the Winter Meeting ; Mid - winter IWLA Board meeting ; Annual Meeting agenda ; Call for Resolutions ; Make Awards Nominations ; Silent Auction Items needed ; Water Action Day ; Dakota Access Pipeline ; Protect Our Pollinators .
 President 's Letter -DAPL ; What Hath We Wrought - Don Arnosti ; Buffer Law Implementation - Jill Crafton ; Fall Board of Directors'- Rich Staffon ; Great Lakes Ballast Water Project - Rich Staffon ; The Pipleline Paradox - Craig Sterle ; Thank You to Our Donors & Volunteers ! ; 2016 - 2017 Scholarship Winners ; Winter Strategic Planning & Board of Directors information .
 President 's Letter : I am Proud to Be an Ike ; National Convention ; 2016 IWLA Issues Resolutions ; Summer BOD Notes ; Larry Dolphin Honored ; Conservation Issues ' Chair Don Arnosti : Sweating the Details ; Gary Clancy WMA Memorial ; Deep Portage Learning Camp ; Fall Gathering & Board of Directors information .
 President 's Letter ( newly elected President John Crampton ; Welcome to New Division President by former President Barry Drazkowski ; 2016 Legislative Session ; News from the Annual Meeting & State Convention ; New Officers elected ; 2016 Resolutions ; In Memoriam : Phil Hinderaker and Al Layman ; Spring Appeal .
 President 's Letter ; 2016 Environmental Issues priorities ; Chapter news ; Report from Winter BOD ; 2016 Annual Meeting & State Convention .
 President 's Letter ; Stop PolyMet ! ; News from the Fall BOD weekend ; Kristi Harrington 's Tiny House ; Call for Awards Nominations ; Fossil Fuels ; Winter Gathering & BOD info .
 Thank You Julie Henricksson ! ; President 's Letter - Ikes Press Forward ! ; Of Moose & Sharptails ; Scholarship Winners ; Notes from the Minnesota Division Summer BOD & National Convention ; Fall Gathering & BOD Meeting ; and more .
 All articles written in the following editions of the Waltonian ( unless otherwise specified ) are written by former Editor Julie Henricksson . THANK YOU JULIE !
 President 's Letter : Issues & Action ; Fifth Annual Legacy Forum ; Roads Taking Their Toll on Turtles ; MN GreenStep Cities ; Call for Resolutions ; Award Nominations ; Annual Meeting Registration / Information .
 President 's Letter : Threat to Wetlands Conservation Act ; Issues Committee priorities ; Jill Crafton ; Fall Board Notes ; Chapter News ; Winter Board of Directors ' and Strategic Planning Meeting announcement ; Thank you to Volunteers and Donors ; New Member Offer ; Forest Memorials ; Watershed 2015 Summit date announced .
 Welcome Don Arnosti to the Environmental Issues team ! ; New Member Offer ; Summer Board Notes ; Chapter News ; Impacts of Bakken oil in Minnesota ; Suggested reading ; SNA Update ; and news from the National Convention .
 President 's Letter " Renew Yourself & Engage " ; News from the Annual Meeting & State Convention ; Awards ; Scholarship Auction ; Issues Resolutions ; Obituary - George Barthel ; Natural Playgrounds ; Wood Duck Houses Project ; Summer BOD announcement and info .
 President 's Letter " Thank You , Ikes " ; Winter Board & Strategic Planning summaries ; Farm Bill recap ; PolyMet SDEIS public meetings ; Monarch Butterfly 's dwindling numbers ; Watershed Summit recap ; Managing Minnesota 's Water event recap ; Minnesota Valley State Trail ; Scholarship program ; Call for Awards nominations & Resolutions ; Annual Meeting & State Convention agenda & registration .
 The Minnesota Waltonian is published four times a year December , March , June & September . Copy deadline is the 8th of the month prior to publication .


text:
The ability to customise, rework and personalise products along with quality control and inspection services. Providing the ability for a retailer to confidently outsource this requirement with a scalable and cost effective solution.
CML’s value added services (VAS) include a range of solutions that can add a touch of personalisation and customisation to many items. This includes undertaking quality inspection and remedial work in a cost-effective, purpose-built environment. As the desire for ecommerce and omnichannel fulfilment grows, so will the need and ability for a retailer to confidently outsource this.
CML also understands the importance of potential complications around fulfilment. Retailers that are exporting to overseas markets may need to consider different languages, pricing and domestic regulations, difficulties that may be compounded by Brexit in the years ahead. Those selling via international marketplaces may find pre-retailing compliance requirements demand items be relabelled in specific ways. All of this points to the importance of sophisticated value added services (VAS). Flexible and reliable access to such services means retailers better understand their obligations.

tokenized:
The ability to customise , rework and personalise products along with quality control and inspection services . Providing the ability for a retailer to confidently outsource this requirement with a scalable and cost effective solution .
 CML ’s value added services ( VAS ) include a range of solutions that can add a touch of personalisation and customisation to many items . This includes undertaking quality inspection and remedial work in a cost - effective , purpose - built environment . As the desire for ecommerce and omnichannel fulfilment grows , so will the need and ability for a retailer to confidently outsource this .
 CML also understands the importance of potential complications around fulfilment . Retailers that are exporting to overseas markets may need to consider different languages , pricing and domestic regulations , difficulties that may be compounded by Brexit in the years ahead . Those selling via international marketplaces may find pre - retailing compliance requirements demand items be relabelled in specific ways . All of this points to the importance of sophisticated value added services ( VAS ) . Flexible and reliable access to such services means retailers better understand their obligations .


text:
Driveway Paving Guys is going to be there for your goals involving Asphalt Paving in Durkee, OR. We have got a staff of specialized experts and the most advanced technology in the industry to deliver just what you might need. We make sure that you get the most effective services, the best value, and the best quality materials. We intend to provide help to put together choices for your own project, resolve your questions, and set up an appointment with our professionals whenever you give us a call by dialing 800-335-6975.
Saving money is an essential part of the job. In the process, you need the best and finest quality of work for Asphalt Paving in Durkee, OR. We provide you with the very best quality even while still costing you less. Whenever you work with our team, you'll receive the advantages of our own practical experience and quality materials to ensure the project can last while saving your time and funds. As an example, we are very careful to keep clear of pricey mistakes, work fast to help save hours, and ensure that you are given the top bargains on products and work. To be able to save cash, Driveway Paving Guys is the company to get in touch with. We are ready to answer your call at 800-335-6975.
It is important to be informed when it comes to Asphalt Paving in Durkee, OR. We will not inspire you to make unwise judgments, since we know just what we are working at, and we ensure you understand what to expect with the venture. This is exactly why we make every effort to make sure that you understand the process and are not faced with any unexpected surprises. Start out by contacting 800-335-6975 to go over your task. We will address your concerns and questions and set up your initial appointment. We consistently get there at the arranged time, prepared to work together with you.
When you're setting up a process regarding Asphalt Paving in Durkee, OR, there are lots of good reasons to consider Driveway Paving Guys. Our supplies are of the very best quality, our money saving strategies are helpful and efficient, and our customer satisfaction ratings won't be beat. We've got the skills you will want to meet all of your objectives. If you need Asphalt Paving in Durkee, call Driveway Paving Guys by dialing 800-335-6975, and we'll be more than glad to help you.

tokenized:
Driveway Paving Guys is going to be there for your goals involving Asphalt Paving in Durkee , OR . We have got a staff of specialized experts and the most advanced technology in the industry to deliver just what you might need . We make sure that you get the most effective services , the best value , and the best quality materials . We intend to provide help to put together choices for your own project , resolve your questions , and set up an appointment with our professionals whenever you give us a call by dialing 800 - 335 - 6975 .
 Saving money is an essential part of the job . In the process , you need the best and finest quality of work for Asphalt Paving in Durkee , OR . We provide you with the very best quality even while still costing you less . Whenever you work with our team , you 'll receive the advantages of our own practical experience and quality materials to ensure the project can last while saving your time and funds . As an example , we are very careful to keep clear of pricey mistakes , work fast to help save hours , and ensure that you are given the top bargains on products and work . To be able to save cash , Driveway Paving Guys is the company to get in touch with . We are ready to answer your call at 800 - 335 - 6975 .
 It is important to be informed when it comes to Asphalt Paving in Durkee , OR . We will not inspire you to make unwise judgments , since we know just what we are working at , and we ensure you understand what to expect with the venture . This is exactly why we make every effort to make sure that you understand the process and are not faced with any unexpected surprises . Start out by contacting 800 - 335 - 6975 to go over your task . We will address your concerns and questions and set up your initial appointment . We consistently get there at the arranged time , prepared to work together with you .
 When you 're setting up a process regarding Asphalt Paving in Durkee , OR , there are lots of good reasons to consider Driveway Paving Guys . Our supplies are of the very best quality , our money saving strategies are helpful and efficient , and our customer satisfaction ratings wo n't be beat . We 've got the skills you will want to meet all of your objectives . If you need Asphalt Paving in Durkee , call Driveway Paving Guys by dialing 800 - 335 - 6975 , and we 'll be more than glad to help you .


text:
Some of you know that we're enthusiasts of Japanese culture and have Japan in our sights in a 20 year plan.
Today we received word from some Japanese producers that we reached out to. They want representatives from V.C.R Entertainment to come to Japan to discuss possible collaborations! So excited!!!!!!!
So excited to get some production steps! Two photo shoots coming up for our newest shorts (scheduled to start filmming next year).
"White Room" in association with IdolCULTure Entertainment and a project we are keeping under wraps for now.

tokenized:
Some of you know that we 're enthusiasts of Japanese culture and have Japan in our sights in a 20 year plan .
 Today we received word from some Japanese producers that we reached out to . They want representatives from V.C.R Entertainment to come to Japan to discuss possible collaborations ! So excited ! ! ! ! ! ! !
 So excited to get some production steps ! Two photo shoots coming up for our newest shorts ( scheduled to start filmming next year ) .
 " White Room " in association with IdolCULTure Entertainment and a project we are keeping under wraps for now .


text:
Does The Mother of the Bride Carry Flowers?
When I got married 30 years ago, my mother wore a small corsage that was made of the same flowers as the bridal bouquets. It fit her outfit perfectly. That was the trend at the time and wearing a corsage happened to work for the outfit she wore, but what about today?
First, let’s talk a little about flowers at the wedding. (That’s a whole topic in itself!) The bride’s bouquet is the ‘centerpiece’ of the wedding. This bouquet is what should receive the most attention and be the most elaborate and beautiful.
The flowers for the mother of the groom, bridesmaids, grandmothers and other female relatives of the bride and groom should be smaller and more simple than the bridal bouquet.
Flowers are given to the other bridal party members as a gesture that they, too, are important to the bride.
Giving flowers to the mother of the bride is a sweet gesture that notes the importance of the mother of the bride, all of her contributions to the wedding planning and her presence at the ceremony. She should be part of picking out the arrangement that she either wears or carries since it will affect the overall look of her outfit that day.
In order to make the most of this gesture, the mother and the daughter should discuss what would work best with the wedding decor, the featured wedding flowers AND the style and color of the mother of the bride dress.
Depending on the dress, the mother may still choose to wear a small corsage, of course, or she may choose to carry a small bouquet of flowers during the wedding. She could also choose just to carry a single flower such as a rose. As I mentioned, the mother of the bride dress will dictate what’s best for her as well as her own personal style.
Another unique idea (once again, depending on the dress) is to pin a small corsage to the waistline sash where a sparkly brooch might go.
If there is a step-mother at the wedding, it would also be a nice gesture to present her with flowers as a kind, sentimental touch.
Ultimately, the size and make-up of the floral arrangements and the people that receive them are up to the bride and what fits with her style, the theme of the wedding and her sentiments.

tokenized:
Does The Mother of the Bride Carry Flowers ?
 When I got married 30 years ago , my mother wore a small corsage that was made of the same flowers as the bridal bouquets . It fit her outfit perfectly . That was the trend at the time and wearing a corsage happened to work for the outfit she wore , but what about today ?
 First , let ’s talk a little about flowers at the wedding . ( That ’s a whole topic in itself ! ) The bride ’s bouquet is the ‘ centerpiece ’ of the wedding . This bouquet is what should receive the most attention and be the most elaborate and beautiful .
 The flowers for the mother of the groom , bridesmaids , grandmothers and other female relatives of the bride and groom should be smaller and more simple than the bridal bouquet .
 Flowers are given to the other bridal party members as a gesture that they , too , are important to the bride .
 Giving flowers to the mother of the bride is a sweet gesture that notes the importance of the mother of the bride , all of her contributions to the wedding planning and her presence at the ceremony . She should be part of picking out the arrangement that she either wears or carries since it will affect the overall look of her outfit that day .
 In order to make the most of this gesture , the mother and the daughter should discuss what would work best with the wedding decor , the featured wedding flowers AND the style and color of the mother of the bride dress .
 Depending on the dress , the mother may still choose to wear a small corsage , of course , or she may choose to carry a small bouquet of flowers during the wedding . She could also choose just to carry a single flower such as a rose . As I mentioned , the mother of the bride dress will dictate what ’s best for her as well as her own personal style .
 Another unique idea ( once again , depending on the dress ) is to pin a small corsage to the waistline sash where a sparkly brooch might go .
 If there is a step - mother at the wedding , it would also be a nice gesture to present her with flowers as a kind , sentimental touch .
 Ultimately , the size and make - up of the floral arrangements and the people that receive them are up to the bride and what fits with her style , the theme of the wedding and her sentiments .


text:
In the Kentucky spring, old men’s heads turn to horseracing, bourbon and awards banquets — like the one in the former Lexington distillery where Dr. Gonzo, Hunter S. Thompson, prodigal son of the Commonwealth, was finally inducted into the Kentucky Journalism Hall of Fame. The hall, whose members really are voted in by a secret committee, is selected by the University of Kentucky Journalism Alumni organization.
Is he a journalist? Is he an abomination? Is his work the beginning of what is right? Isn’t he the guy who said there is absolutely no objective journalism outside of boxscores and stock tabs? Isn’t he the guy who said “Today’s weirdness is tomorrow’s reason why”? He has certainly been for decades the best-known Kentucky journalist the world over (Well, if you don’t count Diane Sawyer. Hell, even if you do count Diane Sawyer). Discuss amongst yourselves.
As of May 2014, he’s a Hall of Famer with, yes, a Gonzo Foundation Hunter S. Thompson Scholarship at the University of Kentucky School of Journalism and Telecommunications.
Jonathan Bastian, who is the well-known “Morning Edition” host on Louisville’s NPR affiliate WFPL-FM, accepted the posthumous honor for Hunter S. Thompson on behalf of his widow, Anita Thompson. Bastian was the right pick. He grew up in Woody Creek, Colorado, in the next house over from Thompson’s Owl Farm compound. His father, Ed Bastian, became a close friend of Thompson’s and even ran Thompson’s political campaign for sheriff of Aspen.
Bastian told the crowd of the extraordinary library of the world’s greatest literature that Thompson had at Woody Creek and reminded them of the great stylistic training of the writer who would break the rigid Who What When Where Why inverted pyramid into a spiraling Mobius prism of “Whaa?!!!” To break through, one must learn the fine contours of the boundaries. Bastian told of the young Thompson, copying the works of F. Scott Fitzgerald and Ernest Hemingway to get a deep feel and understanding of their precision styles. Dionysius of Halicarnassas, eat your heart out.
Now I love me some Johnny Depp acting. And I love Hunter S. Thompson’s work. But I will never see that movie.
That’s because of my singular relationship with “Fear and Loathing in Las Vegas.” I first read those first lines in the first edition paperback. I was 12. I read it as a “How-To” book. And from that I learned some things, including how to turn the pyramid mobius.
In the Kentucky spring, surrounded by the now-nearly old men who have been the backbone of the traditional, bounded, inverted pyramid, Pulitzer-adorned greatness of Kentucky journalism — former Herald-Leader/Baltimore Sun/Los Angeles Times Editor John S. Carroll, who was probably in Vietnam during the 1970 Kentucky Derby; former Kentucky Post Editor Mike Philipps, who was certainly in Cambodia on that day; and former Louisville Courier-Journal Editor David Hawpe, who was making the transition from radical Kentucky Kernel editor to C-J Hazard correspondent, I watched the entirity of the Kentucky press corps fully embrace its brilliant wild one and the what might have been.
Last year, they buried Dust Commander, the horse that won the 1970 Kentucky Derby (Decadent and Depraved) at Churchill Downs. If, on your next Derby Day, you happen to spill a finger or two of your mint julep on the grave, it may find its way home.
This year, as we move at University of Kentucky to celebrate in 2015, the 100th year of journalism education in Kentucky, we may also look to slightly alter the name of the School of Journalism and Telecommunications.
Kakie Urch is an assistant professor of multimedia in the University of Kentucky School of Journalism and Telecommunications.
Ralph Steadman, the British illustrator famous for his Gonzo collaborations with Hunter S. Thompson, is the subject of a new documentary, For No Good Reason (out April 25). Johnny Depp, who appears in the movie, offers his appreciation of an artist whose “boldness is shocking” in a May 2 bylined piece in “Entertainment Weekly”.
Next articleCivil Discourse: Are the required readings ‘morally sound’?

tokenized:
In the Kentucky spring , old men ’s heads turn to horseracing , bourbon and awards banquets — like the one in the former Lexington distillery where Dr. Gonzo , Hunter S. Thompson , prodigal son of the Commonwealth , was finally inducted into the Kentucky Journalism Hall of Fame . The hall , whose members really are voted in by a secret committee , is selected by the University of Kentucky Journalism Alumni organization .
 Is he a journalist ? Is he an abomination ? Is his work the beginning of what is right ? Is n’t he the guy who said there is absolutely no objective journalism outside of boxscores and stock tabs ? Is n’t he the guy who said “ Today ’s weirdness is tomorrow ’s reason why ” ? He has certainly been for decades the best - known Kentucky journalist the world over ( Well , if you do n’t count Diane Sawyer . Hell , even if you do count Diane Sawyer ) . Discuss amongst yourselves .
 As of May 2014 , he ’s a Hall of Famer with , yes , a Gonzo Foundation Hunter S. Thompson Scholarship at the University of Kentucky School of Journalism and Telecommunications .
 Jonathan Bastian , who is the well - known “ Morning Edition ” host on Louisville ’s NPR affiliate WFPL - FM , accepted the posthumous honor for Hunter S. Thompson on behalf of his widow , Anita Thompson . Bastian was the right pick . He grew up in Woody Creek , Colorado , in the next house over from Thompson ’s Owl Farm compound . His father , Ed Bastian , became a close friend of Thompson ’s and even ran Thompson ’s political campaign for sheriff of Aspen .
 Bastian told the crowd of the extraordinary library of the world ’s greatest literature that Thompson had at Woody Creek and reminded them of the great stylistic training of the writer who would break the rigid Who What When Where Why inverted pyramid into a spiraling Mobius prism of “ Whaa ? ! ! ! ” To break through , one must learn the fine contours of the boundaries . Bastian told of the young Thompson , copying the works of F. Scott Fitzgerald and Ernest Hemingway to get a deep feel and understanding of their precision styles . Dionysius of Halicarnassas , eat your heart out .
 Now I love me some Johnny Depp acting . And I love Hunter S. Thompson ’s work . But I will never see that movie .
 That ’s because of my singular relationship with “ Fear and Loathing in Las Vegas . ” I first read those first lines in the first edition paperback . I was 12 . I read it as a “ How - To ” book . And from that I learned some things , including how to turn the pyramid mobius .
 In the Kentucky spring , surrounded by the now - nearly old men who have been the backbone of the traditional , bounded , inverted pyramid , Pulitzer - adorned greatness of Kentucky journalism — former Herald - Leader / Baltimore Sun / Los Angeles Times Editor John S. Carroll , who was probably in Vietnam during the 1970 Kentucky Derby ; former Kentucky Post Editor Mike Philipps , who was certainly in Cambodia on that day ; and former Louisville Courier - Journal Editor David Hawpe , who was making the transition from radical Kentucky Kernel editor to C - J Hazard correspondent , I watched the entirity of the Kentucky press corps fully embrace its brilliant wild one and the what might have been .
 Last year , they buried Dust Commander , the horse that won the 1970 Kentucky Derby ( Decadent and Depraved ) at Churchill Downs . If , on your next Derby Day , you happen to spill a finger or two of your mint julep on the grave , it may find its way home .
 This year , as we move at University of Kentucky to celebrate in 2015 , the 100th year of journalism education in Kentucky , we may also look to slightly alter the name of the School of Journalism and Telecommunications .
 Kakie Urch is an assistant professor of multimedia in the University of Kentucky School of Journalism and Telecommunications .
 Ralph Steadman , the British illustrator famous for his Gonzo collaborations with Hunter S. Thompson , is the subject of a new documentary , For No Good Reason ( out April 25 ) . Johnny Depp , who appears in the movie , offers his appreciation of an artist whose “ boldness is shocking ” in a May 2 bylined piece in “ Entertainment Weekly ” .
 Next articleCivil Discourse : Are the required readings ‘ morally sound ’ ?


text:
Witnesses said the suspect entered the home and forced the people in the home into the basement, except for one man in the home who the robbery suspect did not see.
At which time hte male retrieved a handgun that he keeps for self-defense and when the robbery suspect exited the basement and stepped into the kitchen, the occupant of the home shot the robbery suspect multiple times in the chest.
The man who shot the suspect told police what happened and all of the witnesses are cooperating with the police.

tokenized:
Witnesses said the suspect entered the home and forced the people in the home into the basement , except for one man in the home who the robbery suspect did not see .
 At which time hte male retrieved a handgun that he keeps for self - defense and when the robbery suspect exited the basement and stepped into the kitchen , the occupant of the home shot the robbery suspect multiple times in the chest .
 The man who shot the suspect told police what happened and all of the witnesses are cooperating with the police .


text:
Is there a more efficient way to do this conditional cross-join?
Abstracting the situation: we are monitoring the condition of a variety of units, looking at each unit for a recorded period of time. At any single point in time, there may be nearly 8000 units currently being monitored.
Every unit has an ID (required), a start_date (required), and end_date (may be null, i.e. still being monitored), and the date of the most recent info collected for the unit (latest_data; equal to some date later than start_date).
Every unit gets a periodic check (review), which classifies it into a group, identified by group_ID.
If the unit has not been checked yet, then review_date and group_ID are both null.
What I need to do (for the data warehouse) is create a record of the details for each unit for every day of its life in the system, including its most recent review date and current group_ID.
If the unit is still being monitored, i.e. does not have an end_date, then the daily records should continue up to the date of the most recent info collected for the unit, or sysdate if no data was received yet.
When table_1 and table_2 are left-outer-joined, the result set is about 85k records.
The entire data set and query are stored and running on Oracle 10.2.0.3.
I have tried a number of different configurations for this query, and this one seems to be the most efficient, but it still runs rather slowly -- about 10 minutes per month of data / 2 hours per (fiscal) year of data.
I am currently perusing various Oracle docs and other resources on query tuning, but it's a lot to wade through, and I'm not finding much that directly relates to this kind of situation.
Any suggestions, preferably with explanations and/or references would be very appreciated.
EDIT: Please see reply 18 and 19 for corrections, and reply 23 for sample data and output.
1. Re: Is there a more efficient way to do this conditional cross-join?
This way you don't need the aggregation.
Please post create table and some sample data.
2. Re: Is there a more efficient way to do this conditional cross-join?
Yes, i have tried that way in the past, and it does not appear to be nearly as efficient. Using production data, the revised query below takes several times longer to execute than my first query.
You can compare the EXPLAIN PLANs for the two versions of the query as posted above, they are essentially identical.
It is difficult for me to get SQL Trace output files for TKPROF (because the server is remote, file system remote access controls, whatnot else...), but I will try. I'm still trying to understand EXPLAIN PLAN and TKPROF output, anyway.
3. Re: Is there a more efficient way to do this conditional cross-join?
4. Re: Is there a more efficient way to do this conditional cross-join?
When left join to table_2 why not r.rd=cal. day ?
you can also try connect by on table_1 to generate rows between two dates. I don't have oracle now will play with it tomorrow.
5. Re: Is there a more efficient way to do this conditional cross-join?
Add least(NVL(CR.end_date, CR.latest_data), CR.latest_data, sysdate) column in the subquery "CR" and then reference it in below query and try to use "EXISTS"
6. Re: Is there a more efficient way to do this conditional cross-join?
The first thing you need to do is generate the execution plan for the query; preferably using a method that generates rowsource execution stats so that we can see where the work goes.
a) Oracle may not be able to see how large the calendar set it (perhaps assuming it is one row), so adding the hints /*+ no_merge cardinality(1200) */ to the select that generates the calendar may help the optimizer to choose a better plan.
I haven't considered how this might be applied to your query, but it's possible that a merge join on a targetted calendar date (cal.date > start_date) may do better than a cross join, especially if many of the dates are in the near past rather than the far past.
"group_ID by CR.ID, CR.start_date, CR.end_date, cal.day, cal.month"
Should this be "group by CR.ID .." or "group by "group_id, cr.id ..."
7. Re: Is there a more efficient way to do this conditional cross-join?
8. Re: Is there a more efficient way to do this conditional cross-join?
Thanks, I will try your suggestions either tomorrow or Monday, when I have time.
I'm familiar with WHERE EXISTS () clauses, but can you be more specific?
a) Thanks, I'll try using the no_merge hint.
b) I'm not familiar with the "partition outer join" syntax, I'll look into it.
And thanks for the reference, I'll have to read that tomorrow or Monday, too.
9. Re: Re: Is there a more efficient way to do this conditional cross-join?
I tried your code - got 2125 rows for the first version, 2126 for the second - though I had to delete the reference to t1.month from the second to get the SQL to execute.
There's not really a lot to choose between them.
Obviously a cardinality error means Oracle has chosen a "hash join outer" at operation 2 rather than swapping the join inputs and using a "hash join right outer", but that's a detail that can be fixed.
In the first plan the Nested Loop join is a result of the same cardinality error - but that too can be fixed to give a hash join.
It's hard to tell whether the hash join (dates/table_1) or the connect by on just table_1 will be the more resource intensive - generally I would be cautious about the recursive approach, but it's comparing the two.
10. Re: Is there a more efficient way to do this conditional cross-join?
Thanks Jonathan, I did change t1.month to TRUNC(T1.day,'MM') in my test but I forgot to post the correct version.
Because it's selected in level one in connect by. This can be easily filtered out by adding a "start with" condition but I have a feeling that this row is needed because op used a left join in the first place.
The cardinality is hard to predict because it depends on start_date,end_date, latest_data at each row. The whole point of the rewrite is to replace the left join on (R.rd <= C_cal.day or R.rd is null) with an equal join condition, and get rid of the aggregation at the end. Hopefully the window for each id is not too big.
11. Re: Is there a more efficient way to do this conditional cross-join?
Okay, I didn't connect the comment you'd put in the second statement with the one extra row that appeared.
It's going to be interesting to see how well the strategy works - particularly, perhaps, when the full row lengths are included in the query. You've got rid of the range-based join (which is very elegant) , but it's still hiding (sort of) inside the connect by pump.as the data volume grows from 9 rows to 2125; and we still come to point where the window sort at the end has to sort the entire data set. Strangely the plan for code similar other OPs manages to get the result without doing a window sort (though it IS doing a sort group by - so it may be the multiplication of data that is then aggregated late that is the biggest performance problem).
P.S.. What's the significance of introducing the sys_op_guid() call ?
12. Re: Is there a more efficient way to do this conditional cross-join?
This is because Oracle doesn't see any difference between the prior and current row.
13. Re: Is there a more efficient way to do this conditional cross-join?
I think Jonathan Lewis knows what sys_guid does . Cost-Based Oracle Fundamentals is one of my favorite book (although i do not understand all in that fully). I used to visit his blog Oracle Scratchpad occasionally. He may want to point out something else!
14. Re: Is there a more efficient way to do this conditional cross-join?
Me too, I'm a huge fan of Jonathan's and I learn a lot from him. I translated some of his articles into Chinese and people like them.

tokenized:
Is there a more efficient way to do this conditional cross - join ?
 Abstracting the situation : we are monitoring the condition of a variety of units , looking at each unit for a recorded period of time . At any single point in time , there may be nearly 8000 units currently being monitored .
 Every unit has an ID ( required ) , a start_date ( required ) , and end_date ( may be null , i.e. still being monitored ) , and the date of the most recent info collected for the unit ( latest_data ; equal to some date later than start_date ) .
 Every unit gets a periodic check ( review ) , which classifies it into a group , identified by group_ID .
 If the unit has not been checked yet , then review_date and group_ID are both null .
 What I need to do ( for the data warehouse ) is create a record of the details for each unit for every day of its life in the system , including its most recent review date and current group_ID .
 If the unit is still being monitored , i.e. does not have an end_date , then the daily records should continue up to the date of the most recent info collected for the unit , or sysdate if no data was received yet .
 When table_1 and table_2 are left - outer - joined , the result set is about 85k records .
 The entire data set and query are stored and running on Oracle 10.2.0.3 .
 I have tried a number of different configurations for this query , and this one seems to be the most efficient , but it still runs rather slowly -- about 10 minutes per month of data / 2 hours per ( fiscal ) year of data .
 I am currently perusing various Oracle docs and other resources on query tuning , but it 's a lot to wade through , and I 'm not finding much that directly relates to this kind of situation .
 Any suggestions , preferably with explanations and/or references would be very appreciated .
 EDIT : Please see reply 18 and 19 for corrections , and reply 23 for sample data and output .
 1 . Re : Is there a more efficient way to do this conditional cross - join ?
 This way you do n't need the aggregation .
 Please post create table and some sample data .
 2 . Re : Is there a more efficient way to do this conditional cross - join ?
 Yes , i have tried that way in the past , and it does not appear to be nearly as efficient . Using production data , the revised query below takes several times longer to execute than my first query .
 You can compare the EXPLAIN PLANs for the two versions of the query as posted above , they are essentially identical .
 It is difficult for me to get SQL Trace output files for TKPROF ( because the server is remote , file system remote access controls , whatnot else ... ) , but I will try . I 'm still trying to understand EXPLAIN PLAN and TKPROF output , anyway .
 3 . Re : Is there a more efficient way to do this conditional cross - join ?
 4 . Re : Is there a more efficient way to do this conditional cross - join ?
 When left join to table_2 why not r.rd = cal . day ?
 you can also try connect by on table_1 to generate rows between two dates . I do n't have oracle now will play with it tomorrow .
 5 . Re : Is there a more efficient way to do this conditional cross - join ?
 Add least(NVL(CR.end_date , CR.latest_data ) , CR.latest_data , sysdate ) column in the subquery " CR " and then reference it in below query and try to use " EXISTS "
 6 . Re : Is there a more efficient way to do this conditional cross - join ?
 The first thing you need to do is generate the execution plan for the query ; preferably using a method that generates rowsource execution stats so that we can see where the work goes .
 a ) Oracle may not be able to see how large the calendar set it ( perhaps assuming it is one row ) , so adding the hints /*+ no_merge cardinality(1200 ) * / to the select that generates the calendar may help the optimizer to choose a better plan .
 I have n't considered how this might be applied to your query , but it 's possible that a merge join on a targetted calendar date ( cal.date > start_date ) may do better than a cross join , especially if many of the dates are in the near past rather than the far past .
 " group_ID by CR.ID , CR.start_date , CR.end_date , cal.day , cal.month "
 Should this be " group by CR.ID .. " or " group by " group_id , cr.id ... "
 7 . Re : Is there a more efficient way to do this conditional cross - join ?
 8 . Re : Is there a more efficient way to do this conditional cross - join ?
 Thanks , I will try your suggestions either tomorrow or Monday , when I have time .
 I 'm familiar with WHERE EXISTS ( ) clauses , but can you be more specific ?
 a ) Thanks , I 'll try using the no_merge hint .
 b ) I 'm not familiar with the " partition outer join " syntax , I 'll look into it .
 And thanks for the reference , I 'll have to read that tomorrow or Monday , too .
 9 . Re : Re : Is there a more efficient way to do this conditional cross - join ?
 I tried your code - got 2125 rows for the first version , 2126 for the second - though I had to delete the reference to t1.month from the second to get the SQL to execute .
 There 's not really a lot to choose between them .
 Obviously a cardinality error means Oracle has chosen a " hash join outer " at operation 2 rather than swapping the join inputs and using a " hash join right outer " , but that 's a detail that can be fixed .
 In the first plan the Nested Loop join is a result of the same cardinality error - but that too can be fixed to give a hash join .
 It 's hard to tell whether the hash join ( dates / table_1 ) or the connect by on just table_1 will be the more resource intensive - generally I would be cautious about the recursive approach , but it 's comparing the two .
 10 . Re : Is there a more efficient way to do this conditional cross - join ?
 Thanks Jonathan , I did change t1.month to TRUNC(T1.day,'MM ' ) in my test but I forgot to post the correct version .
 Because it 's selected in level one in connect by . This can be easily filtered out by adding a " start with " condition but I have a feeling that this row is needed because op used a left join in the first place .
 The cardinality is hard to predict because it depends on start_date , end_date , latest_data at each row . The whole point of the rewrite is to replace the left join on ( R.rd < = C_cal.day or R.rd is null ) with an equal join condition , and get rid of the aggregation at the end . Hopefully the window for each i d is not too big .
 11 . Re : Is there a more efficient way to do this conditional cross - join ?
 Okay , I did n't connect the comment you 'd put in the second statement with the one extra row that appeared .
 It 's going to be interesting to see how well the strategy works - particularly , perhaps , when the full row lengths are included in the query . You 've got rid of the range - based join ( which is very elegant ) , but it 's still hiding ( sort of ) inside the connect by pump.as the data volume grows from 9 rows to 2125 ; and we still come to point where the window sort at the end has to sort the entire data set . Strangely the plan for code similar other OPs manages to get the result without doing a window sort ( though it IS doing a sort group by - so it may be the multiplication of data that is then aggregated late that is the biggest performance problem ) .
 P.S .. What 's the significance of introducing the sys_op_guid ( ) call ?
 12 . Re : Is there a more efficient way to do this conditional cross - join ?
 This is because Oracle does n't see any difference between the prior and current row .
 13 . Re : Is there a more efficient way to do this conditional cross - join ?
 I think Jonathan Lewis knows what sys_guid does . Cost - Based Oracle Fundamentals is one of my favorite book ( although i do not understand all in that fully ) . I used to visit his blog Oracle Scratchpad occasionally . He may want to point out something else !
 14 . Re : Is there a more efficient way to do this conditional cross - join ?
 Me too , I 'm a huge fan of Jonathan 's and I learn a lot from him . I translated some of his articles into Chinese and people like them .


text:
How to Buy Your First used cars in Modesto?
In addition, to get the car you need, you may exchange off high bore and besides end up with a car that does not run basically nearby one that was inside your destined cost bunch. Research no fewer than 10 different cars that fall inside your rate group before settling on a decision. Take a good sidekick or relative who is taught regarding cars and trucks to look at them and test drive each vehicle. They will discover centers that could some way or another or another be left behind by you or a car picking up student.
Examination Drive Your Top Three One More Time: Ensure you ask any stresses you may have over the used cars in modesto paying little notice to how senseless they may appear. Getting some data about what number of past owners there were, in case it has truly remained in any mishaps and what the mischief was, have any kind of genuine parts been superseded or restored, has in actuality any individual smoked in the vehicle, or whatever else you should need to know is a reasonable demand.
Do you are Research: Simply knowing the estimation of the vehicle you need is insufficient. Still research the Blue Book regard; yet also discover regular upkeep issues with autos that cannot avoid being that make, plan, and year. Examine the CarMax record on the unequivocal vehicle you are thinking about inspiring the chance to promise it was legitimately secured and moreover in no noteworthy episodes.
Pick Your Car And Prepare To Negotiate: A lot of vehicles are evaluated to mastermind. There is ordinarily concerning 10-15% decrease in cost open, so you require foreseeing it. Once more, carry somebody with you who sees with the cars and truck procuring process and will empower you to envision a clearly better cost.
Think about Conditioning the Car on an Inspection: If the cars and truck is more than a few thousand bucks, or really, in like manner if it is extensively less, you may intend to make the arrangement set upon a perfect assessment. You should figure this examination the spending plan and it can run you as much concerning all expectations and purposes a thousand dollars. Before long, the cerebral pain and disappointment it might save you after some time makes it ivied, regardless of all the inconvenience.
If you seek after these measures and trust money without any other individual to settle on the best choice, you need to finish up with an awesome car that will offer you well.
Previous PostPrevious How to Find the Right Real Estate Agent Website for You?

tokenized:
How to Buy Your First used cars in Modesto ?
 In addition , to get the car you need , you may exchange off high bore and besides end up with a car that does not run basically nearby one that was inside your destined cost bunch . Research no fewer than 10 different cars that fall inside your rate group before settling on a decision . Take a good sidekick or relative who is taught regarding cars and trucks to look at them and test drive each vehicle . They will discover centers that could some way or another or another be left behind by you or a car picking up student .
 Examination Drive Your Top Three One More Time : Ensure you ask any stresses you may have over the used cars in modesto paying little notice to how senseless they may appear . Getting some data about what number of past owners there were , in case it has truly remained in any mishaps and what the mischief was , have any kind of genuine parts been superseded or restored , has in actuality any individual smoked in the vehicle , or whatever else you should need to know is a reasonable demand .
 Do you are Research : Simply knowing the estimation of the vehicle you need is insufficient . Still research the Blue Book regard ; yet also discover regular upkeep issues with autos that can not avoid being that make , plan , and year . Examine the CarMax record on the unequivocal vehicle you are thinking about inspiring the chance to promise it was legitimately secured and moreover in no noteworthy episodes .
 Pick Your Car And Prepare To Negotiate : A lot of vehicles are evaluated to mastermind . There is ordinarily concerning 10 - 15 % decrease in cost open , so you require foreseeing it . Once more , carry somebody with you who sees with the cars and truck procuring process and will empower you to envision a clearly better cost .
 Think about Conditioning the Car on an Inspection : If the cars and truck is more than a few thousand bucks , or really , in like manner if it is extensively less , you may intend to make the arrangement set upon a perfect assessment . You should figure this examination the spending plan and it can run you as much concerning all expectations and purposes a thousand dollars . Before long , the cerebral pain and disappointment it might save you after some time makes it ivied , regardless of all the inconvenience .
 If you seek after these measures and trust money without any other individual to settle on the best choice , you need to finish up with an awesome car that will offer you well .
 Previous PostPrevious How to Find the Right Real Estate Agent Website for You ?


text:
A helicopter tour is the perfect gift to give to a newlywed couple. This type of gift is ideal for couples that are getting married and already have established homes. They do not need another set of China, or an additional blender. Instead you could give them a gift that will give them time together seeing the famous sites of the Big Apple. A helicopter tour in New York is the perfect way to wish the happy couple wedded bliss.
There are several different ways you can give the gift of a helicopter tour. You can check with a helicopter tour service and find out if they have gift certificates, or you can inquire about booking a tentative helicopter tour. This type of gift is one that is going to be hard to keep a secret since you will need to find out exact dates that work for the happy couple. Regardless, they will not forget the beautiful sites they see while taking a grand tour of New York City. A helicopter tour of the Big Apple is a gift that is considered to be priceless.
Couples that are being married in New York City can hire a helicopter charter service to take them to the honeymoon getaway in nearby Marthas Vineyard, the Hampton, or even Atlantic City. Getting married is one of the most whirlwind type of experiences. You can add a little bit of peace to the scenario when you board a helicopter to reach your honeymoon destination. Amid all of the hustle and bustle you can finally relax and look into the eyes of your new spouse as you are flying across New York.
When the reception begins to wind down, you can make a profound exit when you and your new spouse leave to board a helicopter. A courteous and professional pilot that is FAA certified will take you to your honeymoon getaway. Enjoy the scenery below while you are being transported during this special time in your life. Cherish the memories of every part of your wedding, including a charter flight or helicopter tour. Once you have experienced the view from a helicopter, you may want to repeat the experience to celebrate your anniversaries in the years to come.

tokenized:
A helicopter tour is the perfect gift to give to a newlywed couple . This type of gift is ideal for couples that are getting married and already have established homes . They do not need another set of China , or an additional blender . Instead you could give them a gift that will give them time together seeing the famous sites of the Big Apple . A helicopter tour in New York is the perfect way to wish the happy couple wedded bliss .
 There are several different ways you can give the gift of a helicopter tour . You can check with a helicopter tour service and find out if they have gift certificates , or you can inquire about booking a tentative helicopter tour . This type of gift is one that is going to be hard to keep a secret since you will need to find out exact dates that work for the happy couple . Regardless , they will not forget the beautiful sites they see while taking a grand tour of New York City . A helicopter tour of the Big Apple is a gift that is considered to be priceless .
 Couples that are being married in New York City can hire a helicopter charter service to take them to the honeymoon getaway in nearby Marthas Vineyard , the Hampton , or even Atlantic City . Getting married is one of the most whirlwind type of experiences . You can add a little bit of peace to the scenario when you board a helicopter to reach your honeymoon destination . Amid all of the hustle and bustle you can finally relax and look into the eyes of your new spouse as you are flying across New York .
 When the reception begins to wind down , you can make a profound exit when you and your new spouse leave to board a helicopter . A courteous and professional pilot that is FAA certified will take you to your honeymoon getaway . Enjoy the scenery below while you are being transported during this special time in your life . Cherish the memories of every part of your wedding , including a charter flight or helicopter tour . Once you have experienced the view from a helicopter , you may want to repeat the experience to celebrate your anniversaries in the years to come .


text:
In Illinois guardianship is referred to by the state as a “court created responsibility,” however for the family of Mildred Willis it has turned into a four year nightmare which has seen the matriarch lose her freedom, and the family lose much of its assets, including the family home.
With her mother, Mildred Willis, struggling with impending death of her father in 2010, Stacey Willis consulted with a Chicago attorney named Terrance Godbolt who suggested that to relieve some of the stress, Stacey take over temporary guardianship over her mother.
On October 18, 2010, Stacey Willis was named plenary guardian by the Cook County Superior Court.
“He gave me a brochure,” Stacey Willis told RebelPundit, and said she never knew that she’d be responsible for creating a detailed budget, financial plan, and be responsible for accounting for every dime she spent of her mother’s money.
Furthermore, Willis says, after filing all the proper forms for guardianship, Godbolt disappeared, stopped returning phone calls, and was otherwise unavailable to help her navigate the process.
A message to Godbolt’s office was left unreturned.
Willis said she had no idea that in Cook County there is a special office, the Cook County Public Guardian’s Office, which watches all guardianship cases like a hawk and is ready to step in whenever the office feels there is trouble.
That’s exactly what happened when the Cook County Public Guardian’s Office led by Robert Harris accused Stacey Willis of misspending $164,000 of her mother’s money. The office asked the probate judge, Cook County Circuit Court Judge Carolyn Quinn, to have Willis removed as her mother’s guardian and instead have the office appointed on December 17, 2012.
The full statement from the Cook County Public Guardian’s office can be found here and a response from Stacey Willis can be found here.
Willis said the charges against her are lies, citing the fact that her mother didn’t have anywhere close to $164,000 in liquid assets to misspend. Stacey Willis told RebelPundit that her mother had about $30,000 in cash at the start of the process along with a treasury bond worth about $22,000.
Willis said that beside cash her mother receives approximately $3,100 in a monthly pension from the US Postal Service.
And here we have them coming right out and accusing Stacey of stealing $164K from Mildred and going on trips, etc. If true, then I have to wonder why they didn’t press charges. And in fact, wouldn’t they have an obligation to do so?
While Willis acknowledged some money was spent on previously scheduled trips, not only was her mother aware of these expenditures, but Stacey Willis said the majority of the money she spent was for expenses relating to executing the guardianship itself.
Whether or not Willis was misspending her mother’s money, an analysis of the probate file shows in the ensuing years, court officers along with the Cook County Public Guardian’s Office have spent about that much legally in fees, all done presumably to make sure no one misspends Mildred Willis’s estate.
According to one filing, the Cook County asked for and received $26,814 for services rendered from December 17, 2012 through November November 30, 2013.
Every lawyer associated with this case has been allowed to charge $250 per hour for their services. This includes the Guardian ad Litem (GAL), Kyra Payne.
A GAL is an individual, often a lawyer, appointed in especially difficult probate and family law cases to act on behalf of the interests of those considered incapacitated. In family court, that’s usually minor children, but in this case it was Mildred Willis.
“Guardians are adults who are legally responsible for protecting the well-being and interests of their ward, who is usually a minor. A guardian ad litem is a unique type of guardian in a relationship that has been created by a court order only for the duration of a legal action,” according to the website legal dictionary.
The GAL was appointed at the behest of the Cook County Public Guardian’s Office. Payne didn’t respond to a voice-mail at her Chicago office from RebelPundit.
In repeated court filings, the GAL has stipulated that Mildred Willis should remain a ward of the state and she’s been buoyed by the 2010 medical report of Dr. Emerito Natanawan. In that report Dr. Natanawan found a laundry list of physical and mental issues with Mildred Willis which would normally suggest she was near death.
“Dr. Natanawan opined that Midred Willis had multiple medical problems including end stage renal disease, congestive heart failure, hemodialysis, chronic major depression, memory problems suggesting and disability, and is totally incapable of making personal and financial decisions,” read part of his report entered with the court.
Renoire told RebelPundit that this report is dubious. That’s because Dr. Natanawan specializes in internal medicine and yet makes determinations including memory, heart issues, and even depression, none of which would fall within his field of specialty.
Dr. Natanawan works at Advocate Health Care in Chicago and didn’t respond to a voice mail for comment.
A subsequent court report filed by Cook County Public Guardian case manager Tasha Dicks filed on October 15, 2013, cites all the same ailments and a batch of new ones as reasons to continue to provide guardianship for Mildred Willis.
Dicks is a social worker and not a doctor, and it’s not clear what medical opinion she was using to make all these medical determinations.
The Chicago Anti-Eviction Campaign’s Shirley Henderson told Rebel Pundit that the court and the Cook County Public Guardian’s office has ignored medical opinions which bolster the case that Mildred Willis is competent. On August 8, 2013, Dr. Keith Hopkins filed such a report?
The patient states she is sleeping well, eating well, and her concentration is at normal levels. The patient also denies any previous psychological history or contact with mental health professionals.
The patient scored a 25/30 on a mini mental status which is interpreted as normal cognition. She is alert, oriented, with good eye contact, speech is coherent, her thoughts are sequential, and she voiced no thoughts of suicidal or homicidal ideation.
My professional opinion is that Mildred Willis is able to make her own personal and financial decisions.
But Henderson said this report was buried, and any mention of it or any replies or counter-arguments anywhere else in the file are unfound.
Henderson and Stacey Willis also said the court, the GAL, and the Cook County Public Guardian’s office have all repeatedly ignored Mildred Willis’ pleas to be released from guardianship and to move back in with her family at their home.
A statement from the Chicago Anti-Eviction Campaign to Rebel Pundit about this case can be found here.
The family said on August 26, 2014, it suffered its latest humiliation when the Cook County Sheriff’s office came to their family home and confiscated it at the behest of the Cook County Public Guardian’s Office.
According to Henderson, this action was in retaliation for a rally held in front of the Cook County Public Guardian’s office on the previous day.
According to its website, the Cook County Public Guardian’s Office currently manages more than $100 million in ward assets from 800 cases like the Willis case. The Cook County Public Guardian’s Office is a part of the Cook County Circuit Court, run by Timothy Evans, who did not respond to an email.

tokenized:
In Illinois guardianship is referred to by the state as a “ court created responsibility , ” however for the family of Mildred Willis it has turned into a four year nightmare which has seen the matriarch lose her freedom , and the family lose much of its assets , including the family home .
 With her mother , Mildred Willis , struggling with impending death of her father in 2010 , Stacey Willis consulted with a Chicago attorney named Terrance Godbolt who suggested that to relieve some of the stress , Stacey take over temporary guardianship over her mother .
 On October 18 , 2010 , Stacey Willis was named plenary guardian by the Cook County Superior Court .
 “ He gave me a brochure , ” Stacey Willis told RebelPundit , and said she never knew that she ’d be responsible for creating a detailed budget , financial plan , and be responsible for accounting for every dime she spent of her mother ’s money .
 Furthermore , Willis says , after filing all the proper forms for guardianship , Godbolt disappeared , stopped returning phone calls , and was otherwise unavailable to help her navigate the process .
 A message to Godbolt ’s office was left unreturned .
 Willis said she had no idea that in Cook County there is a special office , the Cook County Public Guardian ’s Office , which watches all guardianship cases like a hawk and is ready to step in whenever the office feels there is trouble .
 That ’s exactly what happened when the Cook County Public Guardian ’s Office led by Robert Harris accused Stacey Willis of misspending $ 164,000 of her mother ’s money . The office asked the probate judge , Cook County Circuit Court Judge Carolyn Quinn , to have Willis removed as her mother ’s guardian and instead have the office appointed on December 17 , 2012 .
 The full statement from the Cook County Public Guardian ’s office can be found here and a response from Stacey Willis can be found here .
 Willis said the charges against her are lies , citing the fact that her mother did n’t have anywhere close to $ 164,000 in liquid assets to misspend . Stacey Willis told RebelPundit that her mother had about $ 30,000 in cash at the start of the process along with a treasury bond worth about $ 22,000 .
 Willis said that beside cash her mother receives approximately $ 3,100 in a monthly pension from the US Postal Service .
 And here we have them coming right out and accusing Stacey of stealing $ 164 K from Mildred and going on trips , etc . If true , then I have to wonder why they did n’t press charges . And in fact , would n’t they have an obligation to do so ?
 While Willis acknowledged some money was spent on previously scheduled trips , not only was her mother aware of these expenditures , but Stacey Willis said the majority of the money she spent was for expenses relating to executing the guardianship itself .
 Whether or not Willis was misspending her mother ’s money , an analysis of the probate file shows in the ensuing years , court officers along with the Cook County Public Guardian ’s Office have spent about that much legally in fees , all done presumably to make sure no one misspends Mildred Willis ’s estate .
 According to one filing , the Cook County asked for and received $ 26,814 for services rendered from December 17 , 2012 through November November 30 , 2013 .
 Every lawyer associated with this case has been allowed to charge $ 250 per hour for their services . This includes the Guardian ad Litem ( GAL ) , Kyra Payne .
 A GAL is an individual , often a lawyer , appointed in especially difficult probate and family law cases to act on behalf of the interests of those considered incapacitated . In family court , that ’s usually minor children , but in this case it was Mildred Willis .
 “ Guardians are adults who are legally responsible for protecting the well - being and interests of their ward , who is usually a minor . A guardian ad litem is a unique type of guardian in a relationship that has been created by a court order only for the duration of a legal action , ” according to the website legal dictionary .
 The GAL was appointed at the behest of the Cook County Public Guardian ’s Office . Payne did n’t respond to a voice - mail at her Chicago office from RebelPundit .
 In repeated court filings , the GAL has stipulated that Mildred Willis should remain a ward of the state and she ’s been buoyed by the 2010 medical report of Dr. Emerito Natanawan . In that report Dr. Natanawan found a laundry list of physical and mental issues with Mildred Willis which would normally suggest she was near death .
 “ Dr. Natanawan opined that Midred Willis had multiple medical problems including end stage renal disease , congestive heart failure , hemodialysis , chronic major depression , memory problems suggesting and disability , and is totally incapable of making personal and financial decisions , ” read part of his report entered with the court .
 Renoire told RebelPundit that this report is dubious . That ’s because Dr. Natanawan specializes in internal medicine and yet makes determinations including memory , heart issues , and even depression , none of which would fall within his field of specialty .
 Dr. Natanawan works at Advocate Health Care in Chicago and did n’t respond to a voice mail for comment .
 A subsequent court report filed by Cook County Public Guardian case manager Tasha Dicks filed on October 15 , 2013 , cites all the same ailments and a batch of new ones as reasons to continue to provide guardianship for Mildred Willis .
 Dicks is a social worker and not a doctor , and it ’s not clear what medical opinion she was using to make all these medical determinations .
 The Chicago Anti - Eviction Campaign ’s Shirley Henderson told Rebel Pundit that the court and the Cook County Public Guardian ’s office has ignored medical opinions which bolster the case that Mildred Willis is competent . On August 8 , 2013 , Dr. Keith Hopkins filed such a report ?
 The patient states she is sleeping well , eating well , and her concentration is at normal levels . The patient also denies any previous psychological history or contact with mental health professionals .
 The patient scored a 25/30 on a mini mental status which is interpreted as normal cognition . She is alert , oriented , with good eye contact , speech is coherent , her thoughts are sequential , and she voiced no thoughts of suicidal or homicidal ideation .
 My professional opinion is that Mildred Willis is able to make her own personal and financial decisions .
 But Henderson said this report was buried , and any mention of it or any replies or counter - arguments anywhere else in the file are unfound .
 Henderson and Stacey Willis also said the court , the GAL , and the Cook County Public Guardian ’s office have all repeatedly ignored Mildred Willis ’ pleas to be released from guardianship and to move back in with her family at their home .
 A statement from the Chicago Anti - Eviction Campaign to Rebel Pundit about this case can be found here .
 The family said on August 26 , 2014 , it suffered its latest humiliation when the Cook County Sheriff ’s office came to their family home and confiscated it at the behest of the Cook County Public Guardian ’s Office .
 According to Henderson , this action was in retaliation for a rally held in front of the Cook County Public Guardian ’s office on the previous day .
 According to its website , the Cook County Public Guardian ’s Office currently manages more than $ 100 million in ward assets from 800 cases like the Willis case . The Cook County Public Guardian ’s Office is a part of the Cook County Circuit Court , run by Timothy Evans , who did not respond to an email .


text:
Idalia Borquez began her career with a background in Sales. She received her license in 2004 and found the real estate industry to be her passion. Her driving force has been to excel in client representation. Throughout her real estate career she has taken active roles on the financial areas, has worked as a counselor for real estate government programs, represented sellers and buyers and stays up to date on different areas of the real estate industry in order to be able to provide clients with an outstanding knowledgeable service.
Idalia’s motivation is people. She believes every person is amazing in many ways.
When Idalia isn’t working you’ll find her at home reading, studying, learning about different cultures, doing research, and getting involved in humanitarian projects, she also enjoys outdoor activities such as hiking and mountain climbing.
Idalia currently resides in Calexico and is fluent in English and Spanish.

tokenized:
Idalia Borquez began her career with a background in Sales . She received her license in 2004 and found the real estate industry to be her passion . Her driving force has been to excel in client representation . Throughout her real estate career she has taken active roles on the financial areas , has worked as a counselor for real estate government programs , represented sellers and buyers and stays up to date on different areas of the real estate industry in order to be able to provide clients with an outstanding knowledgeable service .
 Idalia ’s motivation is people . She believes every person is amazing in many ways .
 When Idalia is n’t working you ’ll find her at home reading , studying , learning about different cultures , doing research , and getting involved in humanitarian projects , she also enjoys outdoor activities such as hiking and mountain climbing .
 Idalia currently resides in Calexico and is fluent in English and Spanish .


text: Zeonics Systech Defence & Aerospace Engineers Pvt. Ltd., was established in the year 1981 with the specific purpose of manufacturing High Voltage components & Systems. The unit was started as a Micro Scale unit mainly to design, Develop & Manufacture a wide variety of Highly Specialized Equipment & Components used for Defence & Atomic Energy applications. The unit has one of the most sophisticated R&D labs in the country with state of the art equipment & manufacturing facilities. The unit has now grown into a Macro Scale unit with highly specialised & Sophisticated Research & Development Laboratory, Capable of handling critical projects. The unit manufactures Systems for measurement of Velocity of fast flying projectiles. These Systems are used in Military applications for measuring velocity of Rockets, Missiles, Bullets & Other projectiles. The unit manufactures Spark Gaps, Rail Gaps, Pulse Transformers, Trigger Transformers and a host of other HV Pulse Power Components. The Components manufactured by the unit are cost effective and most reliable, military approvals are available where required. 950 Products are developed in 27 years.

tokenized: Zeonics Systech Defence & Aerospace Engineers Pvt . Ltd. , was established in the year 1981 with the specific purpose of manufacturing High Voltage components & Systems . The unit was started as a Micro Scale unit mainly to design , Develop & Manufacture a wide variety of Highly Specialized Equipment & Components used for Defence & Atomic Energy applications . The unit has one of the most sophisticated R&D labs in the country with state of the art equipment & manufacturing facilities . The unit has now grown into a Macro Scale unit with highly specialised & Sophisticated Research & Development Laboratory , Capable of handling critical projects . The unit manufactures Systems for measurement of Velocity of fast flying projectiles . These Systems are used in Military applications for measuring velocity of Rockets , Missiles , Bullets & Other projectiles . The unit manufactures Spark Gaps , Rail Gaps , Pulse Transformers , Trigger Transformers and a host of other HV Pulse Power Components . The Components manufactured by the unit are cost effective and most reliable , military approvals are available where required . 950 Products are developed in 27 years .


text:
Actuated by 5V electrical pulses.
This series of switches is designed to meet the most demanding carrier class and outdoor optical switching applications.
These switches are designed to meet the most mission-critical optical switching applications.

tokenized:
Actuated by 5V electrical pulses .
 This series of switches is designed to meet the most demanding carrier class and outdoor optical switching applications .
 These switches are designed to meet the most mission - critical optical switching applications .