text:
"If George Washington Carver Invented Peanut Butter, Then Who Invented Jelly?"
On March 23, 2015 By Tamarah RockwoodIn As A Woman, Uncategorized
These are the questions that keep us up at night, over here in the forest.
My daughter was doing her history lesson the other day, and she was learning about George Washington Carver. I told her, in a very short and broad summary, that George Washington Carver was the man who invented peanut butter.
Now, the thing is, the longer story of George Washington Carver is amazingly fascinating. The reason why he focused on peanut crops, among other crops like sweet potatoes and soybeans, was because they helped to heal the nitrogen depleted soil that was almost useless after too many cotton harvests.
After graduating with a degree in agriculture, Carver began working at the University of Iowa, but it was a letter from Booker T. Washington that changed his course:
"In April 1896, Carver received a letter from Booker T. Washington of Tuskegee Institute, one of the first African American colleges in the United States. "I cannot offer you money, position or fame," read this letter. "The first two you have. The last from the position you now occupy you will no doubt achieve. These things I now ask you to give up. I offer you in their place: work – hard work, the task of bringing people from degradation, poverty and waste to full manhood. Your department exists only on paper and your laboratory will have to be in your head."
"Carver was determined to use his knowledge to help poor farmers of the rural South. He began by introducing the idea of crop rotation. In the Tuskegee experimental fields, Carver settled on peanuts because it was a simple crop to grow and had excellent nitrogen fixating properties to improve soil depleted by growing cotton."
It wasn't an interest in peanuts that drove Carver, but it was filling a need in the South and helping farmers sustain their farms that motivated him in his career in agriculture….which is amazing stuff. He was an amazing man who helped rebuild the nation (and I'm kind of a sucker for good history).
But, back to our history lesson:
After I summarized Carver's works, she looked puzzled and asked, "If George Washington Carver invented peanut butter, then who invented jelly?"
I…have no idea. I kind of figured it was just a recipe that has been around forever to preserve fruits.
But there should be some answer out there…to Google!
Naturally, this is creating a few rabbit trails.
On one hand, there is a really boring story. There is the general idea that jelly was acquired through the road of trades and commerce in the Far East: "Although, the exact date is unknown, the making of jam and jelly probably began centuries ago in the Middle Eastern countries, where sugar cane grew naturally. It is believed that the returning Crusaders first introduced jam and jelly to Europe. By the late Middle Ages, jams, jellies and fruit conserves were popular there. The use of sugar cane to make jam and jelly can be traced back to the 16th century when the Spanish came to the West Indies where they preserved fruit. " (link)
That is probably true. But there is no good story in there, so I kept looking for any other theories on the origins of jelly. Lo and behold, I found one!
There is an epic tale of an esteemed Roman man who was stuffed with incredible self-discipline, curiosity, culinary intrigue, and loads and loads of money.
Which is helpful when you go around being a writer for a living…
In the first century there was a man named Marcus Gavius Apicius who published a recipe book, and this book included a recipe for fruit preserves:
"The world's first known book of recipes, written by the famous 1st century AD Roman epicure, Marcus Gavius Apicius, includes a recipe for quince jam."
Simple enough story. Straightforward. Easy. But….
Who was this Marcus Gavius Apicius, though?
So statuesque.
"Marcus Gavius Apicius is believed to have been a Roman gourmet and lover of luxury, who lived sometime in the 1st century AD, during the reign of Tiberius. The Roman cookbook Apicius is often attributed to him, though its impossible to prove the connection."
and yet,
"Evidence for the life of M. Gavius Apicius derives partly from contemporary or almost-contemporary sources but is partly filtered through the above-named work by Apion, whose purpose was presumably to explain the names and origins of luxury foods, especially those anecdotally linked to Apicius. From these sources the following anecdotes about M. Gavius Apicius (hereafter called Apicius) survive: to what extent they form a real biography is doubtful."
Nevertheless, Apicius was an interesting dude.
– Apicius dined with Maecenas (70 – 8 BC), Augustus's adviser: Martial, Epigrams 10.73. It is possible that Martial drew this idea from a facile comparison made bySeneca between Maecenas, cultural adviser, and Apicius, gastronomic adviser.
– Drusus (13 BC – 14 September AD 23), son of Tiberius, was persuaded by Apicius not to eat cymae, cabbage tops or cabbage sprouts, because they were a common food…
– Apicius was "born to enjoy every extravagant luxury that could be contrived". He advised that red mullet were at their best if, before cooking, they had been drowned in a bath of fish sauce made from red mullet…
– Apicius advised that flamingo's tongue was of superb flavour…
Run Away!!!
– Based on existing methods of producing goose liver (foie gras), Apicius devised a similar method of producing pork liver. He fed his pigs with dried figs and slaughtered them with an overdose of mulsum (honeyed wine)…
– Having spent a fortune of 100 million sestertii on his kitchen, spent all the gifts he had received from the Imperial court, and thus swallowed up his income in lavish hospitality, Apicius found that he had only 10 million sestertii left. Afraid of dying in relative poverty, he poisoned himself…
It is, indeed, the Roman way.
What was most interesting about my little trip down the gastronomical legend of Marcus Gavius Apicius, was not the report of the lavishes of flamingo tongues; it was his perfect 5 course Roman meal plan:
Appetizer: Olive Caviar
Starter: Sweet Ham
Main Course: Imperial Chicken
Cheese: Herbed Cheese
Dessert: Honeyed Dates
Not much has changed in +2000 years…!
And so, without further ado…Apicius' Quince Jelly Recipe:
Thank you to The Joy Kitchen for providing the recipe!
"The quince has played part in humankind's orchard for centuries at least. The quince was Paris's offering to Aphrodite, and Apicius's ancient Roman cookbook contains recipes for stewing quince with honey."
Quince Jelly – The Joy Kitchen
Makes about 3 to 4 half-pints
– Wash, remove stems and chop into 1/4-inch pieces:
3 1/2 pounds quinces
– Place in a large heavy saucepan with:
– Cover and bring to a boil, then reduce the heat and simmer, mashing and stirring frequently, until the fruit is thoroughly soft, about 30 minutes to 1 hour. Strain through a jelly bag or a clean, doubled kitchen towel (I used a flour sack towel folded over on itself). Reserve the pulp to make membrillo, below.
– For each 1 cup of clear juice, add:
– Stir in:
– Boil rapidly, stirring frequently, to the jelling point*. Remove from the heat and skim off any foam. Pour the hot jelly into hot sterilized 1/2-pint jars, leaving 1/4-inch headspace. Process in a water bath for 5 minutes.
* Generally, the easiest way to tell you've reached the jelling point is when the liquid reaches 220˚F, but for quince, which contains a lot of pectin, you may want to remove it from the heat at about 218˚F. You can also use the quick-chill test. Put a plate in the freezer before you start making the jelly. As the liquid cooks and thickens, occasionally drop a small amount of the liquid onto the cold plate. Put the plate back in the freezer for a couple minutes. If, the liquid wrinkles when you run your finger through it, the liquid has reached the jelling point.
Who Are You? – Chocolate Covered Braaaaiiinnnssss
Today's Forecast: Thunderstorms and Rant-Fests. Writers Are Weird.


What to do with a nice piece of tuna at sashimi grade?
First of all lets prepare the eggs.
Onsen Tamago are eggs that remain soft.
For this purpose put a small pan with water to boil.
When boiling add cautiously the 2 eggs and after 30 seconds (the water must still be boiling) put the pan aside for 30 minutes.
Was the rice thouroghly until the water is clean. Then add to a pan with the water (I use 1.25 cups water per cup of rice) and bring to boil. I prefer heavy pans like Creusets with the lid.
Cut 200 grs of the tuna in small cubes and marinate with the soya sauce, the mirin and the sake and the sesame seeds.
Cut the remaining 200 grs in small cubes, almost like a tartar.
Add the mix of Mayonnaise, Sri Racha and Chili oil. Add some spring onion stalks cut thinly and mix well.
Now that the rice has cool down, take 2 bowl and fill the bottom with it.
arrange on top the 2 tuna mixes and the Ikura.
At the end crack open gently one end of the eggs and let the egg slowly slip out on the fish bowl.
You now can add some shichimi togarashi on the top and you are ready for a delicious meal!


How to lose 3 kg in 48 hours – Prepare this Smoothie today!
There is a growing desire by people who are overweight to lose some of their weight. However, very few people are willing to shed excess weight by working out hard in a gym and also staying faithful to a healthy nutrition and dietary plan. If you fall into this category, then you might want to stick around and learn how to make a natural recipe that will help you shed 3 kg of excess weight in only 2 days. That's right, in just 48 hours you will lose 3 kg with this amazing healthy remedy that you can make at home today.
The recipe will boost your metabolism to ensure that you burn calories quicker, it will give you a feeling of satiety to help you eat less and ultimately curb your weight gain. You should take the recipe half an hour before you have breakfast, also avoid consuming a high amount of whole grains and sugar for some days during and after the consumption of the recipe.


text:
The Top 5 Most Ridiculous Reasons Not To Buy Life Insurance (With Anthony Anderson)
October 14, 2015 January 19, 2016 by bamalliance
Anthony Anderson is a funny dude. The Emmy-nominated actor has been making people laugh on television and in film for 20 years. But now he's bringing his sense of humor to a surprisingly unfunny topic—the need for life insurance.
The big question I had for him was: Why? Why, with your career exploding and recent Emmy nomination (for lead actor in the show Black-ish), are you investing time and effort to be the spokesperson for Life Insurance Awareness Month?
"I know firsthand from friends and other family members who've never had a policy, who've never thought about having a policy. And then all of a sudden someone passes in their family and they don't know what to do," Anderson told me.
Fair enough. Many people aren't even aware of the need for life insurance, and that lack of education is a big concern for Anderson, and a major driver of his dedication to public awareness. But as we continued our conversation, it shifted focus. What it seemed to begin revealing were some of the tragically comic, ridiculous reasons that many people choose not to buy life insurance. Here are the Top 5:
5) I've got more important things to insure.
"People insure their flat screen televisions, they insure their cars, they insure jewelry, but they don't insure themselves," says Anderson with a chuckle. He's also evidently frustrated by this reality. "If it weren't for themselves, they would have none of those things to insure."
Even if we don't have our possessions insured, we can replace them. "The only thing that's different in that is we cannot replace the person who has passed on, but because you've got the 'extended warranty' in life insurance, life still goes on the way that you're accustomed to it going on, and you don't have a worry [about the money]," says Anderson.
4) I don't want to deal with a life insurance salesperson.
Yes, there are some insurance agents who have helped perpetuate the stereotype. You know the one. It involves a pushy salesman with a comb-over and a fascination with death. But there are many more insurance agents who see their business as nothing short of a public service.
Anderson grew up on the streets of Compton—as in Straight Outta Compton, the popular new movie based on the lives of the young men who comprised the rap group and cultural phenomenon NWA. "That was my childhood you watched on that screen," he says. "That's what I lived through. I used to go see World Class Wreckin' Cru and Andre Young, who went on to become Dr. Dre, at Skateland U.S.A. I lived that as a 16-year-old kid."
But when Anderson turned 18, he came face-to-face with another member of the Compton establishment—Mary, "the insurance lady." Mary walked those tough streets, going door-to-door, becoming a reliable friend to the families who lived there, including Anderson's parents. And when he crossed the official barrier into adulthood, she hit him with the question, "Well, Anthony, have you ever thought about life insurance?"
"Not really," he said.
Thank goodness for Mary, the insurance lady.
3) I've got to die to get something out of this.
"Wow, I can get $25,000 for $12 a month. Sign me up!" Anderson recalls. Of course, he didn't entirely understand how it worked at the time. He thought he was paying his $12 a month to have access to $25,000 in cash should he need it.
"What I didn't think through, in order for me to cash the policy in, I had to die. I was like 'Oh, wait a minute, wait a minute, I didn't think this through.'" But regardless of the pretense, Anderson became the proud owner of his first insurance policy, a policy he still owns to this day.
Now he understands that while some life insurance policies do offer their holders financial benefits during their lives, the primary purpose of life insurance is to take care of those we leave behind. And Anderson seeks to educate others about this fact. The benefit to us as policyholders is knowing that we did the right thing, and that we can help take care of our family even after we're gone.
2) It's too expensive.
Life insurance can be expensive. Even though $12 per month for Anderson's first policy at the age of 18 sounds like a premium most could live with, it was likely a more expensive form of permanent life insurance with a savings component attached to it. Because, for just $13 per month today, a healthy 18-year-old guy can get $250,000 of 20-year term life insurance.
A 30-year-old man who is the picture of health can get a million dollar policy for just $37 per month—a premium guaranteed for 20 years—to ensure his family would have sufficient cash to survive financially in the case of his untimely death. A healthy, 30-year-old woman would pay even less, about $31 monthly.
Yes, insurance can be expensive, depending on the type of coverage and the age and health of the person insured. But it can also be surprisingly inexpensive, eliminating as a viable excuse the second most ridiculous reason not to buy life insurance.
1) I'll do it—later.
Another cause Anderson supports is education and awareness regarding diabetes, and this is another one that hits close to home. He and his mother both suffer from adult onset, type-two diabetes. If Anderson applied for a new life insurance policy today, it would be vastly more expensive—perhaps prohibitively so—due to an illness he didn't even have when he bought his first few policies. And his mother, who tried to update one of her own policies recently, was flatly denied because of her health issues.
But the primary point of life insurance isn't to pay a benefit when we expect to die many years from now. It's to provide an infusion of cash for our loved ones in the event we leave this earth when we don't expect to die.
My guess is that Anthony Anderson's success as an actor and comedian has put him in a unique position, one in which he doesn't actually need any life insurance to ensure that his family would be financially secure if he died today at the age of 45. But that's not the case for most 45-year-olds with a spouse and children in college, and it's even less likely for new 30-something parents or 20-something newlyweds.
"In the past year and a half, I've had four or five childhood friends and family members of those childhood friends pass away," Anderson told me. "Guess what? None of them had life insurance."
That's why he's taking time out of his busy career to talk about life insurance. He's seen it work. Sadly, he's seen many more situations where a lack of life insurance made a horrible situation even worse.
"But all I can do is give you the information," Anderson says. "Then it's up to you."
This commentary originally appeared September 27 on Forbes.com

redpajama_set_name: RedPajamaCommonCrawl


WITH the massive rain event that inundated northern Queensland over, miners are counting their blessings and getting back to work, although the impact of the closure of the Townsville rail line is unclear.
Mt Carlton in drier times.
Fertiliser and explosives maker Incitec Pivot said the line had been closed between its Phosphate Hill plant and Townsville and it was still awaiting news on how long that line would be out of action.
BOM issued an 'all clear' on Monday after Veronica crossed the coast over the weekend.


The name Xiaomi has been showing up more and more when talking about IoT, especially when talking about affordable IoT. In march 2016 Xiaomi created a company dedicated to 'smart home' products, this company was called Mijia (Chinese for 'Smart home'). Xiaomi is mostly focused on the Chinese market but has been slowly expanding to Europe (mostly phones). They are very good at combining a well-rounded product with good design for an insanely low price, but one of the main disadvantages is that the products are (almost) only available in China but can be imported via various sites like Gearbest.
If you have bought Xiaomi/Mijia products before, this little box won't surprise you. The box is the same as every other Xiaomi product with a slight Apple feel to it. The box's design is very minimal and clean, with the product on front and white as primary color.
On the top you have a Mijia icon and under that the Honeywell icon. On the back you have product information but that's in Chinese.
The smoke detector is packed in a small box without any filling, the product itself is really sturdy so it should not be damaged easily in shipping.
It definitely looks better than your average smoke detector, I think Xiaomi always hits the nail on the head for design.
On the back there is some product information, but to no one's surprise it is all in Chinese.
The smoke detector has multiple 'smart' features, but if you don't pair it to the gateway it's just your average dumb smoke detector. I will you how to connect it to the Gateway in the following paragraph.
When the smoke detector gets triggered it willll send you a notification via the Mi Home App, even outside your home. Because of this you'll be able to get to the starting fire faster and prevent it from burning your whole house down.
You can 'self test' the device in the Mi-Home app. This will send a self-check request to the device, after which a screen will show up asking you "Did you hear the sound?". If you did hear it, your device is functioning normally! If you didn't hear anything, it is probably because the distance between your gateway and the smoke detector is too far. If you want you can enable monthly reminder. The Mi-Home app will send you a notification that it is time for the monthly test and it will execute the self-test.
Above normal amount of smoke (e.g. kitchen or close to the fireplace).
While this is not the most exciting 'smart' feature, the ability to tandem your smoke detector with your gateway is not to be forgotten. My house is three stories and let's say my smoke detector at the bottom of my house gets triggered, it'll be hard for me to hear it upstairs (image if I am sleeping or showering!). That's why pairing it with your gateway is a nice solution for this. This way I'll be able to hear it upstairs, even though the alarm is downstairs.
If you want more than just a 'dumb' smoke detector, you can pair it to your gateway. This can be done via the Mi Home app, available on the Play store and the App store. The app is mostly English but some parts are still Chinese, it is still very usable though. The pairing process is quite easy, the gallery under here will guide you through it (enable information for instructions!).
After that you have unlocked the smart features! If you click on the smoke detector you will be able to edit things like installation site or enable tandem mode.
If the smoke detector get's triggered, you will have to disable the alarm by click the Sound stop/Self check button, you can find this on the front of the device. After you have clicked this button the alarm and light will immediately stop, but the device will also disable itself for 70 seconds.
What can trigger the alarm?
Hair or insect spray (directly on the device).
Cigarette smoke or other incendiary substances.
Smoke from e-cigarettes or alike devices.
Smoke or steam from cooking.
Condensation on the device (so do not install it outdoors or in bathrooms).
If you want to test the sound of the device, you can simulate it going off (without actually burning something). This can be done by holding the button for 3 seconds. The light will begin to flash and the alarm will go off progressively, this means it'll get louder with every beep. As soon as you let go it'll stop the simulation mode.
You can self-test the device without the app! This can be done by clicking the button on the device for one second, the light will and sound will indicate the status of your smoke detector.
If your device is going off and the indicator light is yellow (not red), it means the battery is empty and it wants you to change it. You can press the button once to disable it for 12 hours, after those 12 hours it will continue to go off until you replace it with a new battery. You can (but not recommend) disable the low battery warning by holding the button for 3 seconds to return it to normal operation mode. It will continue to work as usual but this is not recommended because you might forget to replace it. Because of this it will not be able to warn you anymore (because you returned it to normal mode).
The device is powered by a CR123a battery, which some of you might know from being used in (old-ish) cameras. These might be hard to get from a local shop (at least it was for me) or really pricey (like 10 euro a piece), I was able to pick up some Duracell one's for 2 euro a piece. But I have ordered some rechargeable ones which I would totally recommend doing, this way you don't have to buy new ones every couple of years (and way, way better for the environment!). If you replace an old battery make sure to self-check the device after you have replaced the old battery, you want to be sure the battery is working properly.
The main idea for me was that I can add them to my HomeAssistant. After some struggles of identifying the devices, they worked perfectly. They also work for Domoticz but I do not use it myself.
I have setup 3 around my house, already gave them a quick test with holding 4 burning matches close to the detector.
It will show the smoke density and the battery level.
In conclusion, the device actually quite surprised me. I did not expect for it to have this many features, like the self testing via the app or buttons or setting the sensitivity with the installation site. The device even has tons of features without pairing it with the gateway, like certain beeping and light combinations for device status or battery warnings that you can disable for a certain time period. Being able to choose if you want to mount it with screws or adhesive was also a, not expected, but certainly welcome surprise, mounting the device itself was also super easy and can be done in a minute. The design itself it one of the best things though. They are so small that you barely notice them on your ceiling. And even if you did notice them, you would not mind it because they look so premium and well rounded. I think Mijia and Honeywell did a great collaboration on this one and I would love to see more products from them (please make a smart thermostat). At first I expected a smoke detector with an IoT sticker on it, but was definitely surprised with how feature packed it was. For the price tag of 20,61 euro I can't even find a comparable product. So if you are obsessed with IoT and needed a good excuse to replace your old smoke detectors, don't look any further.
This is really helpful! Not easy to find this type of information lately. Not really sure why. Thanks again.
I wish I can turn off the alarm using the mihome app. Can that be done? I am afraid of false alarms in the middle of the night, can there is no way to turn it off unless I press the little button on the device.
Great post! Not easy to find this type of data lately. Not clear why. I do have several questions but want to re-read first before typing something really stupid. Appreciate it.
If you go to the Zigbee wiki, you can see the range for Zigbee is anywhere between 10-70m (70m is a perfect situation without walls or anything). You will probably need another gateway if you want to use them that far away.
Zigbee (what the gateway uses) is the same as Wi-Fi, walls and distance will make it harder to reach the target.


studies by accessing your DICOM Worklist Server (where patient information can be stored).
data will be entered into the system and the study will be activated for that patient.
Click the [+] box to display the lists of Exam types; to hide the lists, click the [–] box.
Use the checkboxes to select the desired Exam types.


CJ's only Easter book finesses the issue of Jesus's death. The book starts with 10 pages of cartoons about how much Jesus loved little children — and apparently little lambs and bunnies, too. Then there's one page that says "But not everyone loved Jesus" with a slightly cloudy pastoral scene where you can barely see three tiny crosses on a far hilltop. And then on the very next page an angel is standing by the mouth of the cave, with good news!
But CJ's church childcare, which she used to call The Pooh-Bear Room, doesn't pull any punches.
"Because he wasn't in Noah's Ark?" I asked, trying to connect the passion to one of the only other Bible stories she knows.
"No, that's not right. He died because he needed to. Because he put on an old dress and it was teared, and they gave him a glass of wine and he didn't want to drink it.
"And they gave him a big piece of wood but it was too heavy for him and he fell and died.
"That's weird, Jesus," I said.


So, the ballot for the World Fantasy Award arrived in my mailbox yesterday.
I have no idea what to nominate. If I can't think of enough stuff to nominate, I'll just toss the ballot. But first, I thought I'd ask you all for recommendations.
Did you read any 2017 short fiction that you really liked and would like to see nominated? I can think of just a few novellas — Martha Well's Murderbot, which I'm a bit uncomfortable with because it was SF and not fantasy; and Bujold's latest Penric novella, which I liked a lot. What am I forgetting? I feel like there was at least one more novella I really liked.
What about short stories, anything I should check out quickly? Collections?
It looks like CJC still has not received a Life Achievement Award, so I'll nominate her. It says here that nominees should be at least 62 years old, which I hadn't realized, but according to Wikipedia, CJC is over that age, so that's fine.Anybody else I should think of for that?
I think Sherwood Smith would be a solid Lifetime Achievement choice…. I have never read any CJC books. Which one should I start with?
It's always hard to pick a starting point (and her series vary in flavor a lot – I don't actually care for many of them, though they are well written). Personally, I liked the Morgaine Cycle, the Faded Sun trilogy, the Ealdwood books, and her Russian fantasy books. The first two are science fiction and the second two are fantasy. I do not particularly like her Foreigner series, although that is probably what she is best known for and it is an extremely popular series.
Since it's World Fantasy, to start with CJC I suppose it ought to be fantasy of which she has written some, but not as much as SF. So….
Celtic flavored would be Tree of Swords and Jewels, and Dreamstone (reverse the reading order). Last I looked there was an omnibus, which might have been titled "Arafel's Saga".
Also Celtic flavored would be Faery in Shadow, which the author reportedly considers a comedy, to the amazement of readers.
Russian/Slavic based is the Rusalka trilogy which was vastly improved in the e-book editions, available at her publishing site "closed circle press." titles: Rusalka, Chernegov, Yvgenie. Many find them dreary or confusing. I like them. My Teen loves them.
Asian: The Paladin, which is a standalone vaguely Chinese or Japanese ( not knowledgeable enough about sources to tell) But I recall someone in the early days of the 'net analysing the first page and saying that it matched the rhythm of Chinese writing in poetry. I like it, so does our Hostess.
Central European The Goblin Mirror which I rather like and again is a standalone.
And the doorstop, FORTRESS, beginning with Fortress in the Eye of Time, and continuing through three sequels all with Fortress in the titles (Eagles, Owls, Dragons) and a fourth that shouldn't have been written. I really like this set. So do my Teen and my husband, and we rarely all three agree on books.
Sunfall is a collection of – IIRC – six short stories set at the end of the sun… in different cities – basically fantasy, for all the 'future' setting. No idea how available it is, but there's a fair spread of style in it. I remember Paris and London stories, not which others were included.
The Morgaine quartet has futuristic trappings, but reads like portal hopping fantasy. Its first installment is Gate of Ivrel. It was CJC's first published work.
Angel with a Sword is set on a future planet, settled and abandoned but humans are still there, living vaguely Renaissance level lives. My memory says the setting is sort of Venice. So basically fantasy in feel.
The two Rider books are also set on a planet settled by humans, but read like fantasy crossed with westerns. If you like westerns that might be where to start. Rider at the Gate is the first.
Charlotte, thanks, Sherwood Smith is definitely a good choice.
The thing about CJC is, *I* love her Foreigner series, which is up to something like 19 books, but I doubt very much that would be the place to start because 19 books!
Something to be prepared for is that a lot of CJC's work starts slowly. The entire first Foreigner book is setup for the series, but when I re-read, I also often skip the first fifty pages or so of Cyteen and Fortress in the Eye of Time as well.
Some people like CJC's SF better than her fantasy. I love both.
For you, I'd recommend Fortress in the Eye of Time — fantasy, and the series is great, but not the most recent book, which is a standalone that (I agree with Elaine here) is just not up to the quality of the earlier books in the series. I really think you'd like this world.
The Chanur series is really good space opera. There's book one that more or less stands alone, then a very connected trilogy, then a standalone later book which in this case is excellent.
One of my absolute favorites is Cuckoo's Egg, a short standalone that's available used from Amazon.
I personally loved Paladin, set in an alternate China, and I feel like you would too. It's slooow, but in a good way imo.
I detested the Russian dulogy and finally gave them away.
just dropping a note here to say Shadow Twin is on my Kindle.


It's time to cast away this nightmare Presidunce with this political anti Trump Dunce Crusoe design. Make your statement with all of our Funny, Anti-Trump products.
The only unique, political anti Trump Dunce Crusoe design!
With our products you can do more than just express your political opinion and make a statement. This political anti Trump Dunce Crusoe design is great for birthdays, gifts, presents, holidays & more!


Does it ever end??? - CAPSTONE!
I know all of my posts seem to be so depressing but I feel as if the universe is against me like does it ever end? We have less than a month left of capstone and bad things just keep happening to me. I know that I pull of some of my best work under pressure but this is not what I imagined at all like if its not one thing its another and these are things outside of the obstacles I already have with working full time and being a single parent. I swear everyday I feel like just say forget it and dropping out until things get easier but I have already come so far so its just hard to give up but I do not want to fail and I do not want to have to tell my son I gave up because things got to hard but I swear I really do not know what to do there are not enough hours in the day enough money in my pocket or enough people around to support me it is just me and my son and it starting to just take a toll on my whole outlook on this course and upcoming graduation because I do not see me making it past that finish line. I really need my life to turn around and good energy to come my way because 2015 has been the worst year so far and I really cannot take any more bad. I hope that this week things turn around for me.
Hang in there, CIerra! The finish line is SO close: 37 days to be exact. This whole experience will make you stronger, do it for your son, he will respect your hard work so much more in the long run.


I started my career in precision engineering in 1987 and used various types of machinery making a wide range of products in metals, plastics and composites for the marine and aerospace industries. Having gained these skills I decided to pursue my interest in custom knives and made my first knife in 1996. I made a handful of different types of knives over the next few years and found myself drawn towards integral knives. I knew this was what I wanted to do so I set up my own workshop. I prefer to work with stainless tool steels, stainless Damascus, and Titanium for my knives and like to use natural materials for my handles. My knives are precision machined on a manual milling machine, then meticulously shaped and finished by hand. This is a very time consuming and labor intensive process but I believe that the end result is worth the effort. I make all my own handle bolts, screws, fasteners etc, and do all my own leather work. All knives leaving my workshop have been professionally heat treated, fully tested and certified free from any flaws/defects of any kind in a metallurgical laboratory. This serves as a guarantee that my knives are fit for purpose and ready to serve the owner a lifetime of trouble free use. All my knives are a "one off" unless otherwise stated giving the owner a knife that is something special and unique!


text:
<?php
namespace HtCountryModule\Validator;

use Zend\Validator\AbstractValidator;
use Phine\Country\Loader;
use Phine\Country\CountryInterface;

/**
 * Validates ISO 3166-1 alpha-2 code
 */
class CountryValidator extends AbstractValidator
{
    const INVALID               = 'countryInvalid';
    const COUNTRY_NOT_FOUND     = 'countryNotFound';

    /**
     * @var array
     */
    protected $messageTemplates = array(
        self::INVALID               => 'Invalid type given. String expected',
        self::COUNTRY_NOT_FOUND     => 'Country %value% was not found',
    );

    /**
     * @var Loader\LoaderInterface
     */
    protected $loader;

    /**
     * Constructor
     *
     * @param Loader\LoaderInterface|null $loader
     */
    public function __construct(Loader\LoaderInterface $loader = null)
    {
        if ($loader !== null) {
            $this->setLoader($loader);
        }
        parent::__construct();
    }

    /**
     * Sets country loader
     *
     * @param  Loader\LoaderInterface $loader
     * @return self
     */
    public function setLoader(Loader\LoaderInterface $loader)
    {
        $this->loader = $loader;

        return $this;
    }

    /**
     * Gets country loader
     *
     * @return Loader\LoaderInterface
     */
    public function getLoader()
    {
        if (!$this->loader instanceof Loader\LoaderInterface) {
            $this->loader = new Loader\Loader();
        }

        return $this->loader;
    }

    /**
     * Returns true if $value is valid ISO 3166-1 alpha-2 or instance of Phine\Country\CountryInterface
     *
     * @return string|CountryInterface $value
     * @return bool
     */
    public function isValid($value)
    {
        $this->setValue($value);

        if ($value instanceof CountryInterface) {
            return true;
        }

        if (!is_string($value)) {
            $this->error(static::INVALID);

            return false;
        }

        $country = $this->getLoader()->loadCountry($value);
        if (!$country instanceof CountryInterface) {
            $this->error(static::COUNTRY_NOT_FOUND);

            return false;
        }

        return true;
    }
}

redpajama_set_name: RedPajamaGithub


text:
Features Go See A Play
Go See a Play: What's Happening July 27 – July 4
Lynn Venhaus June 29, 2018	No Comments #Hawthorne PlayersBankside RepClinton County ShowcasecocaFourth Wall DownIgnite TheatreLooking Glass PlayhouseMax and Louie ProductionsmunyStages St. LouisSummerstage Inc.Take TwoThe Playhouse at Westport
I hear America singing, and dancing, and acting – right here in St. Louis. You can rock out at the community theater debut of "Rock of Ages," ponder a different look at fairy tales in "Into the Woods," delight in the Muny's "Singin' in the Rain" movie magic, or take in a fresh work or youth production.
Stages St. Louis wraps up both its marriage duo, "I Do! I Do!" and youth show, "Madagascar," as does Max and Louie Productions with "End of the Rainbow."
For something different, there is "The Drowning Girls," "Echoes of Valhalla" and the one-man Hells' Angels story, "Outlaw." Before the star-spangled activities and fireworks celebrating Independence Day, go see a play!
"The Complete Works of William Shakespeare, Abridged (Revised)"
The Bankside Repertory Theatre Company
Thursday – Saturday at 7:30 p.m.
The Jacoby Arts Center, 627 E. Broadway in Alton
www.banksiderep.com
What It's About: A comedy crash-course on the Bard's canon, an iambic pentametric delight.
Of Note: For adult audiences.
Fourth Wall Down
Wild Carrot, 3901 Shaw Blvd., in the Shaw Neighborhood
www.fourthwalldown.org
What It's About: This is about England's first serial killer from the point of view of his three brides whom he eventually strangled in their bathtubs, at the turn of the century.
Director: Nick Hendersen
Of Note: Moving Victorian bathtubs are part of the theater in the round set. The whole show is done in an 18′ ring of water. There is an 18′ chandelier above the stage/pool as well. The whole set is meant to be an art installation.
Local artists are displaying works on abuse in an exhibit.
A portion of the proceeds goes to A.L.I.V.E, (Alternatives to Living in a Violent Environments), www.AliveSTL.org
"Echoes of Valhalla"
Hawthorne Players
Saturday, June 30, at 2 and 7 p.m.
Florissant Civic Center Theatre
hawthorneplayers.info.
What It's About: Leading actors from this community theater troupe will bring to life the stories and times of people buried in the historic Valhalla Cemetery on St. Charles Rock Road.
Of Note: For the past eight years, the popular "Voices of Valhalla" events held each October have sold out within the first 24 hours. Author and director Larry Marsh said this time it's inside.
Max and Louie Productions
The Grandel Theatre
June 22 – July 1
www.maxandlouie.com
MetroTix: 314-534-1111
What It's About: One-woman show is set in 1968. Judy Garland is about to make her comeback – again. In a London hotel room, with both her new young fiancé and her adoring accompanist, Garland struggles to get "beyond the rainbow" with her signature cocktail of talent, tenacity and razor-sharp wit.
Featuring some of Garland's most memorable songs, this savagely funny play-with-music offers unique insight into the inner conflict that inspired and consumed one of the most beloved figures of our time.
Director: David New, with music direction by Thomas Conroy
Starring: Angela Ingersoll as Judy Garland, Kyle Hatley as Mickey Deans, Thomas Conroy as Anthony and Paul Cereghino, playing multiple roles.
Of Note: This is a dramatic play, not a tribute or jukebox musical. Ingersoll is the recipient of numerous awards and nominations, recently earning Chicago's Jeff Award, a Broadway World Award and "Top Performances" honors from both the Chicago Tribune and Chicago Sun-Times for her star turn as Judy Garland in "End of the Rainbow" at Porchlight Music Theatre.
"I Do! I Do!"
June 1 – July 1
Robert G. Reim Theatre, Kirkwood Community Center, 111 S. Geyer Road
www.stagestlouis.org
What It's About: This two-character musical version of the comedy-drama "The Fourposter" takes place in a bedroom, telling the poignant story of 50 years in the married lives of Michael and Agnes. It's a frank look at marriage as the couple experiences childbirth, parenthood and eventually settling down to face the future and their advancing years together, starting in 1895.
Director: Michael Hamilton
Cast: David Schmittou and Kari Ely are the Red Cast, while Steve Isom and Corinne Melancon are the Purple Cast
Of Note: From the creators of "The Fantasticks!," the Tom Jones – Harvey Schmidt musical will be performed by two rotating casts at Stages. It was originally written for Broadway stars Mary Martin and Robert Preston.
Couples married 50 or more years receive complimentary tickets. Contact the box office for select dates.
Summerstage Inc.
June 29, 30 and July 1
Friday and Saturday, 7:30 p.m.; Sunday at 2 p.m.
Granite City High School Performing Arts Center
"Madagascar: A Musical Adventure"
Stages St. Louis – Theatre for Young Audiences
Robert G. Reim Theatre, Kirkwood Community Center
111 S. Geyer Road, Kirkwood
www.stagesstlouis.org
What It's About: Take a journey out of the Central Park Zoo and onto an enchanted desert isle with your favorite crack-a-lackin' friends from the DreamWorks blockbuster film, "Madagascar." Join Alex the Lion, Marty the Zebra, Melman the Giraffe, Gloria the hip-hip Hippo, and, of course, mad King Julien for a musical adventure of a lifetime.
Filled with gut-busting laughs galore, rockin' dance moves, and an upbeat up-to-the-minute score that includes "Move It, Move It," exploring a brave new world was never so much ridiculous fun!
The Playhouse @ Westport
Friday at 8 p.m., Saturday at 4 p.m. and 8 p.m., and Sunday at 2 p.m.
www.playhouseatwestport.com
www.GeorgeChristieOutlaw.com.
Tickets: www.metrotix.com or by calling 314-534-1111. Additionally, tickets will be available at the box office one hour prior to show time. Groups of 10 or more should call 314-616-4455 for special rates.
What It's About: For more than three decades, George Christie was among the most prominent leaders of the Hells Angels' biker organization. He was prosecuted and persecuted; hunted and hated, but always respected, even by his enemies, of which there were many. Now, Christie shares his journey from accused (though not convicted) murderer and arsonist to legitimate business owner and family man in the new, solo stage production.
Director: Richard LaPlante (and writer)
Of Note: Based on his memoir "Exile on Front Street: My Life as a Hells Angel and Beyond," the show explores how the son of poor Greek immigrants in Southern California became one of the most influential leaders of the world's most infamous motorcycle club. In 1978, Christie founded the Ventura chapter of the Hells Angels, which he ran until 2011.
After quitting the Hells Angels, Christie began writing, speaking, promoting concerts and consulting for defense attorneys. In 2015, The History Channel produced a documentary series about him, titled "Outlaw Chronicles: Hells Angels." While the documentary focused on the Hells Angels, playwright and co-producer Richard La Plante said the new stage production offers a more personal portrait of Christie.
Take Two Productions
Thursday through Saturday at 7:30 p.m. and Sundays at 2 p.m.
Southampton Presbyterian Church, 4716 Macklind
www.taketwoproductions.org.
What It's About: It's the tail end of the big, bad 1980s in Hollywood, and the party has been raging hard. Aqua Net, Lycra, lace and liquor flow freely at one of the Sunset Strips last legendary venues, a place where sex machine Stacee Jaxx takes the stage and scantily clad groupies line up to turn their fantasies into reality. Amidst the madness, aspiring rock star (and resident toilet cleaner) Drew longs to take the stage as the next big thing — and longs for small-town girl Sherrie, fresh off the bus from Kansas with stars in her eyes. But the rock and roll fairy-tale is about to end when German developers sweep into town with plans to turn the fabled Strip into just another capitalist strip mall. Can Drew, Sherrie, and the gang save the strip – and themselves – before it's too late?
Of Note: Only the music of hit bands Styx, Journey, Bon Jovi, Whitesnake and more hold the answer. Recommended for mature audiences.
The Muny|
Nightly at 8:15 p.m., Forest Park
www.muny.org
What It's About: Musical adaptation of the classic 1952 movie about 'talkies' coming in to the movie business. Songs include the famous title number, "Good Morning," "Make 'Em Laugh" and "All I Do Is Dream of You."
Director: Marc Bruni
Starring: Corbin Bleu, Jeffrey Schecter, Berklea Going
YOUTH COMMUNITY THEATER
"Disney's Alice in Wonderland Jr."
Ignite Children's Theatre
Friday and Saturday at 7 p.m. and Sunday at 1 and 7 p.m.
.Zack, 3224 Locust in Grand Center
www.ignitewithus.org
What It's About: Travel down the rabbit hole and join Alice, one of literature's most beloved heroines, in her madcap adventures. Featuring updated songs from Disney's thrilling animated motion picture, Disney's Alice in Wonderland Jr. is a fast-paced take on the classic tale."
"Disney's Beauty and the Beast Jr. "
Clinton County Showcase
Friday through Sunday at 8 p.m.
Breese Northside Park
1000 N. Main St., Breese, Ill.
www.ccshowcase.com
What It's About: The classic story tells of Belle, a young woman in a provincial town, and the Beast, who is really a young prince trapped under the spell of an enchantress. If the Beast can learn to love and be loved, the curse will end and he will be transformed to his former self. But time is running out. If the Beast does not learn his lesson soon, he and his household will be doomed for all eternity.
"Disney's Mary Poppins Jr."
Friday at 7 p.m. and Saturday at 1 p.m.
Edison Theatre at Washington University
www.cocastl.org
What It's About: Everyone's favorite practically perfect nanny takes the stage in this Supercalifragilisticexpialidocious musical adventure.
Looking Glass Playhouse
7:30 p.m. Friday, 2 and 7:30 p.m. Saturday and 2 p.m. Sunday
301 West St. Louis Street in Lebanon, Ill.
www.lookingglassplayhouse.com.
What It's About: Take a journey out of the Central Park Zoo and onto an enchanted desert isle with your favorite crack-a-lackin' friends from the DreamWorks blockbuster film, "Madagascar." Join Alex the Lion, Marty the Zebra, Melman the Giraffe, Gloria the hip-hip Hippo, and, of course, mad King Julien for a musical adventure of a lifetime. Filled with gut-busting laughs galore, rockin' dance moves, and an upbeat up-to-the-minute score.
Previous Previous post: Peabody Opera House Announces 2018-19 Broadway Series
Next Next post: Bright Lights: The Good Guys and Gals


Craigslist is one of the incredible success stories of the web. And they do it by thumbing their nose at conventional wisdom. They don't care about stunning design, complicated systems or making more money. Craigslist is all about functionality. If you haven't read Wired's August 2009 story on Craigslist it's worth a look behind the veil at one of the web's weirder successes.
As great a techno wonder as Craigslist is, I hate using it. Why? It's nothing wrong with the site, it's the people. Sadly people are often the downfall to many of technology's innovations. Every time I post something on Craigslist I get countless e-mails with stupid questions, drawn out conversations that don't go anywhere and time and time again I'm left hanging.
So here's a tip to improve your Craigslist experience: Be helpful.
Read the listing thoroughly and make sure you're not asking something that's answered in the listing.
If you're looking at a widely available retail product, don't ask the poster inane questions about it. They're not a salesperson. Look it up online. Do your own research.
Don't contact the person unless you're ready to buy. It's OK to contact the seller and ask a few questions, but Craigslist isn't for window shoppers.
When you're ready to contact the seller and buy, get to the point. So many people ask if the item is still available. Assume it is and skip straight to the terms. Don't prolong the purchase with needless back and forth.
Don't leave a seller hanging. If you're interested in the item, follow through. Overly polite sellers might give you first dibs and lose sales waiting on you. Other sellers will skip to the next interested buyer and you'll be out of luck.
Include a picture of your actual item. It may seem like a pain, especially if you're selling a widely available retail product, but it gives you credability. Here's the actual product, I'm not making this up.
Pack your posting full of details. Anticipate questions and include everything you can think of, whether or not it may be relevant. It should go without saying, but be honest.
Be very specific about your terms. Cash or trade? Pick up or drop off? If you don't specify you leave the door open to all sorts of wacky ideas.
As people ask questions, update your listing with the answers. More than likely other people have the same questions.
Delete your post when the item sells and contact any remaining inquirers to let them know the item sold. A quick one-sentence e-mail blind-copied to everyone will do. No one wants to be left hanging.
Not all my experiences on Craigslist are that painful. But I've had enough awkward and pointless interactions to know better. Simply being helpful would have made all the difference.
It's also worth repeating the standard web advice: be careful.


Click on a picture below to see the many items available in that range. Then click on the name to be taken to the page where you will find more details.
Visit the New Sofa Centre in our Cheltenham Store Now!
For British Made Quality Sofas at Low Low prices.
This chunky range has 40mm tops, dovetailed joints etc. Each piece comes with both antique brass and wooden knobs.
Our Rutland Pine range is a great money saving option for bedroom furniture that doesn't compromise on top quality.
The Chalford Rattan Furniture is ideal for the conservatory. Available in White and Walnut.
Our Trewick oak range designed with chamfered corners and antique brass effect handles. With 40mm oak tops it is built to last a lifetime or more.
The Berkeley range of stunning furniture comes in a soft cotton grey painted finish with solid oak tops and stainless steel handles.
All pieces are made using traditional construction methods, no assembly needed at all.
Each lamp is a work of art handmade from flattened seashells and resin.


RUGBY WORLD: So how did you enjoy your first RWC off the field?
WILL GENIA: I loved it. We have a great group of boys and we make an effort to find a balance and organise activities. We had a relaxing few days with our partners in Hanmer Springs, a lovely mountain town.
RW: What's the best thing about NZ?
WG: Just the fact that they love their rugby. That makes it a more exciting atmosphere with a World Cup.
WG: The weather! Boys were kicking in training in Wellington and balls would fly back over their heads!
RW: What would you save if your house was on fire?
WG: Vanessa, my girlfriend; we've been together for four years and she takes care of me. My PlayStation; I'm the best in the team at FIFA 11 – that's not a joke. And my iPhone; I like reggae music.
RW: Who are the Wallabies' jokers?
WG: The old fella, Radike Samo. He's 35 but acts like he's 20. Quade Cooper, James O'Connor and Kurtley Beale like playing pranks too, especially Quade. He does little things like taking your clothes and hiding stuff.
RW: What was the best practical joke at the World Cup?
WG: In the team room we had computers and Digit (analyst Andrew Sullivan) must have left his Facebook account open because someone got on it and posted, 'Oh my god, is it just me or is Robbie Deans the sexiest guy to walk this planet?'!
RW: Who are the best and worst room-mates?
WG: The best is Radike. He takes care of me and likes to keep things tidy. The worst is Digby Ioane – 100%. He doesn't go to bed until 2.30-3am and he listens to music really loud and laughs like a hyena, so you can't get to sleep.
RW: Which team-mate spends the longest in front of the mirror?
WG: There are two without doubt – Quade and James O'Connor. Quade hasn't even got any hair but stands there sorting it out. James does his hair too and they're both into their fashion.
WG: Sending a love message to my mum instead of my girlfriend!
WG: A lot. Sanchez, which is my first name. Dolph, as apparently I look like a dolphin when I'm doing a bench pull because my legs flip up. Midge, short for midget. And Pooh Bear.
WG: I wasn't playing but I saw it on TV. Steve Thompson kissing that Argentina player after a scuffle! What the f***?
WG: Too much talking in meetings. I like them short and sharp. Our captain (James Horwill) can repeat himself a lot.
RW: Who are your three dream dinner party guests?
WG: Michael Jordan – I'm a massive fan. He was dedicated in every way to be as good as he could be. Nelson Mandela and Muhammad Ali.
WG: Going to Papua New Guinea to spend time with my family. My parents live there and I go back every Christmas to spend it with them.
WG: Spiders. I scream like a girl if I see a spider. I don't mind snakes. A friend of mine had a pet snake and I thought about getting one. My girlfriend has to get rid of the spiders. She picks them up and pretends to throw them at me!
WG: Here goes. What do you call a deer with no eyes? No eye-deer.
WG: There's a lot I can't live without. Underpants!
WG: Just to be happy and content with life, whatever I do.
WG: As someone who enjoyed and loved rugby.


text:
Home News Rural Villagers Put Friendship Before Politics
Rural Villagers Put Friendship Before Politics
Brian Calvert and Van Roeun
phnom srok district, Banteay Meanchey province – In some villages across the country, party signs are torn down or defaced, their owners threatened or killed. That kind of election intimidation is documented, complaints are filed, and the run-up to the impending election goes on.
But a more accurate representation of most of Cambodia's rural villages might be found in Traipaing Thmar Kheung Cheung, an average village of farmers, who, passionate as they may be in politics, are, at the end of the day, just an average village of farmers.
In the middle of the village, a Funcinpec sign stands in front of one house. Next door, someone has put up a CPP sign. And across the narrow, rutted road, a man has put up a Sam Rainsy Party sign.
In the volatile world of Cambodian politics, this kind of thing can lead to a shooting, a stabbing or, at the very least, taunting or vandalism. But here, the CPP's logo—a Thevara spirit blessing the land with flowers—and the candle of Sam Rainsy and the stately face of Funcinpec President Prince Norodom Ranariddh all reside peacefully next to each other.
"For this village, there's no problem at all," said Khuth Khuon, 32, CPP chief of Traipaing Thmar Kheung Cheung, whose house displays the Funcinpec sign.
The sign was put there by his father-in-law, who won't take it down, even though Khuth Khuon has told him the village chief's house should be neutral ground.
"For me, it doesn't matter about the party signs," he said. "But this is the village chief's home."
The father-in-law won, though, and the party sign stayed up.
The rest of the village is split between loyalty to the three main parties. "They have different opinions and different love for the parties," Khuth Khuon said, and a crowd of villagers gathered around him agreed.
Those allegiances lead to little more than quiet discussions, Khuth Khuon said, and the crowd agreed.
"We are neighbors, we are relatives, but we can have different support for political parties," Khuth Khuon said.
The crowd agreed.
The only thing that has changed around here, he said, is that people are preoccupied with the election.
"What we feel now, we are thinking about the election," he said. "But after the election, we are carefree. We will just go to the field."
Sun Moeurn, 43, who hung up the Sam Rainsy Party sign, said the same thing.
"I'm not worried at all in this village," he said. "For this village, any villager can vote for whomever they want, and support whatever party they wish. For me, too."
He, too, will be relieved after the elections, so that he can focus on more important things.
"After the election, I will feel OK, and I'll just go to the field, as normal."
© 2003 – 2013, The Cambodia Daily. All rights reserved No part of this article may be reproduced in print, electronically, broadcast, rewritten or redistributed without written permission.
Brian Calvert


Got a new website? Get a site review and get recommendations specific to your website.
You may be a website student or maybe not. Either way, you've got a new website. There are many things in the setup and layout that can make a difference to your site. If you're not a web developer you may not know about these. So what can you do to get a bit of extra help? Get a site review.
Site review can be done with or without you. In a site review I review the following.
Site reviews can be done with you (a Skype review) or without you (a Video review).
In a video review I do the review on my own. I check the site and note what items need to be done. You'll get a short screencast of these items which you can do on your own time. If required (and you give me access), I can also connect Google Analytics, add the Facebook Pixel ID, submit the site map, and register and verify your site in Google webmaster. There is an additional fee for doing connections (see fees below).
When the review is done together, it's done over skype and lasts 30 minutes. I run through my observations and recommendations and we can do updates at the same time. If it runs over (due to questions or number of changes), there is an additional fee depending on time involved. Connections can also be done at this time, time allowing.
Site reviews give you peace of mind. You can go and promote your site knowing that you've given it a professional eye over. These updates can make a big difference to your site in terms of a visitor's experience, whether they want to stay or transact on your page, usability, flow, tracking and SEO.
You can get started here. Unless previously arranged, payment is done in advance. You can pay using the button below. Nothing further is required if you want a video review. If you want a Skype review, schedule a time with me using the 'schedule review' button below.
Get comfort in knowing you've given your website a professional eye over. You'll give yourself a better chance that visitors will have a good experience with your site and will want to engage with you more. You'll know that you have all the basics in place for on-site SEO. Plus, it's easy to get started.
When you sign up, I will be in touch to confirm whether you prefer a Skype or Video review. Contact me here for questions or get started here now.


text:
Financial Services Bill (HC Bill 278)
SCHEDULE 13 continued
Contents page 160-169 170-179 180-189 190-199 200-209 210-219 220-229 230-239 240-249 250-259 260-269 270-284 285-289 290-299 300-308 310-313 Last page
Financial Services BillPage 260
(5) If the statement differs from the draft published under subsection (1)
in a way which is, in the opinion of the regulator, significant, the
regulator must (in addition to complying with subsection (4))
publish details of the difference.
(6) 5A regulator may charge a reasonable fee for providing a person with
a copy of a draft under subsection (1).
(7) This section also applies to a proposal to alter or replace a statement."
7 (1) Section 392 (application of sections 393 and 394) is amended as follows.
(2) In paragraph (a), for "345(2) (whether as a result of subsection (1) of that
10section" substitute "345B(1) (whether as a result of section 345(2), 345A(3)".
(3) In paragraph (b), for "345(3) (whether as a result of subsection (1) of that
section" substitute "345B(4) (whether as a result of section 345(2), 345A(3)".
SCHEDULE 14 Amendments of Part 24 of FSMA 2000: insolvency
1 15Part 24 of FSMA 2000 is amended as follows.
2 In section 355 (interpretation of Part 24) at the end of subsection (1) insert—
" "PRA-regulated person" means a person who—
is or has been a PRA-authorised person,
is or has been an appointed representative whose
20principal (or one of whose principals) is, or was, a
PRA-authorised person, or
is carrying on or has carried on a PRA-regulated
activity in contravention of the general prohibition."
3 (1) Section 356 (powers to participate in proceedings: company voluntary
25arrangements) is amended as follows.
(2) In subsections (1) and (2), for "the Authority" substitute "the appropriate
regulator".
(3) In subsection (3)—
(a) for "the Authority", in the first place, substitute "a regulator", and
(b) 30for "the Authority", in the second place, substitute "the appropriate
(4) After subsection (3) insert—
"(4) The appropriate regulator" means—
(a) in the case of a PRA-authorised person—
(i) 35for the purposes of subsections (1) and (2), the FCA or
the PRA, and
(ii) for the purposes of subsection (3), each of the FCA
and the PRA;
(b) in any other case, the FCA.
(5) If either regulator makes an application to the court under any of
those provisions in relation to a PRA-authorised person, the other
regulator is entitled to be heard at any hearing relating to the
(5) 5In the heading, for "Authority's powers" substitute "Powers of FCA and
PRA".
4 (1) Section 357 (powers to participate in proceedings: individual voluntary
arrangements) is amended as follows.
(2) In subsections (1) to (5), for "Authority" substitute "appropriate regulator".
(3) 10In subsection (6)—
(b) for "the Authority", in the second place, substitute "the appropriate
"(7) 15The appropriate regulator" means—
(i) for the purposes of subsections (1) and (4) to (6), each
of the FCA and the PRA, and
(ii) for the purposes of subsection (3), the FCA or the
20PRA;
(8) If either regulator makes an application to the court under any of the
provisions mentioned in subsection (5) in relation to a PRA-
authorised person, the other regulator is entitled to be heard at any
25hearing relating to the application."
(5) In the heading, for "Authority's powers" substitute "Powers of FCA and
5 (1) Section 358 (powers to participate in proceedings: trust deeds for creditors
in Scotland) is amended as follows.
(2) 30In subsections (2) to (4), for "Authority" substitute "appropriate regulator".
(a) for "the Authority", in the first place, substitute "the appropriate
regulator", and
(b) for "the Authority", in the second place, substitute "that regulator".
(4) 35In subsection (6), for "the Authority" substitute "a regulator".
"(6A) The appropriate regulator" means—
(i) for the purposes of subsections (2), (3) and (4), each of
40the FCA and the PRA, and
PRA;
6 (1) Section 359 (administration order) is amended as follows.
(2) In subsection (1), for "Authority" substitute "FCA".
(3) 5After subsection (1) insert—
"(1A) The PRA may make an administration application under Schedule
B1 to the 1986 Act or Schedule B1 to the 1989 Order in relation to a
company or insolvent partnership which is a PRA-regulated
(4) 10In subsection (2), for "the Authority" substitute "a regulator", and
(5) In subsection (4), in the definition of "authorised deposit taker", for "Part
IV", in both places, substitute "Part 4A".
7 (1) Section 361 (administrator's duty to report) is amended as follows.
(2) In subsection (2), for "Authority" substitute "appropriate regulator".
(3) 15After subsection (2) insert—
(a) where the regulated activity is a PRA-regulated activity, the
FCA and the PRA;
(4) 20For subsection (3) substitute—
"(3) Subsection (2) does not apply where—
(a) the administration arises out of an administration order
made on an application made or petition presented by a
(b) 25the regulator's application or petition depended on a
contravention by the company or partnership of the general
prohibition."
(5) In the heading, for "Authority" substitute "FCA and PRA".
8 (1) Section 362 (powers to participate in proceedings: administration orders) is
30amended as follows.
(2) In subsection (1), omit "other than the Authority".
(3) After subsection (1A) insert—
"(1B) This section also applies in relation to—
(a) the appointment under paragraph 22 of Schedule B1 to the
351986 Act (as applied by order under section 420 of the 1986
Act), or under paragraph 23 of Schedule B1 to the 1989 Order
(as applied by order under Article 364 of the 1989 Order), of
an administrator of a partnership of a kind described in
subsection (1)(a) to (c), or
(b) 40the filing with the court of a copy of notice of intention to
appoint an administrator under either of those paragraphs
(as so applied)."
(4) In subsections (2) to (6), for "Authority" substitute "appropriate regulator",
(a) for the purposes of subsections (2) to (4) and (6)—
(i) 5where the company or partnership is a PRA-
regulated person, each of the FCA and the PRA, and
(ii) in any other case, the FCA;
(b) for the purposes of subsection (5)—
(i) where the company or partnership is a PRA-
10regulated person, the FCA or the PRA, and
(ii) in any other case, the FCA.
(8) But where the administration application was made by a regulator
"the appropriate regulator" does not include that regulator."
15PRA".
9 (1) Section 362A (administrator appointed by company or directors) is
amended as follows.
(2) In subsection (1), after "company" insert "or partnership".
(3) For subsection (2) substitute—
"(2) 20An administrator of the company or partnership may not be
appointed under a provision specified in subsection (2A) without the
consent of the appropriate regulator.
(2A) Those provisions are—
(a) paragraph 22 of Schedule B1 to the 1986 Act (including that
25paragraph as applied in relation to partnerships by order
under section 420 of that Act);
(b) paragraph 23 of Schedule B1 to the 1989 Order (including that
paragraph as applied in relation to partnerships by order
under article 364 of that Order).
(2B) 30"The appropriate regulator" means—
(a) where the company or partnership is a PRA-regulated
person, the PRA, and
10 (1) Section 363 (powers to participate in proceedings: receivership) is amended
35as follows.
(a) for the purposes of subsections (2) to (4)—
(i) 40where the company is a PRA-regulated person, each
(i) where the company is a PRA-regulated person, the
FCA or the PRA, and
5PRA".
11 In section 364 (receiver's duty to report to Authority)—
(a) for "to the Authority without delay" substitute "without delay to the
FCA and, if the regulated activity concerned is a PRA-regulated
activity, to the PRA", and
(b) 10in the heading, for "Authority" substitute "FCA and PRA".
12 (1) Section 365 (powers to participate in proceedings: voluntary winding up) is
(a) for the purposes of subsections (2) to (4), (6) and (7)—
(i) where the company is a PRA-authorised person, each
(b) 20for the purposes of subsection (5)—
(i) where the company is a PRA-authorised person, the
13 (1) Section 366 (insurers effecting or carrying out long-term contracts of
insurance) is amended as follows.
(2) In subsections (1), (2) and (5), for "Authority" substitute "PRA".
(3) At the end insert—
"(9) 30Before giving or refusing consent under subsection (1), the PRA must
consult the FCA.
(10) In the event that the activity of effecting or carrying out long-term
contracts of insurance as principal is not to any extent a PRA-
regulated activity—
(a) 35references to the PRA in subsections (1), (2) and (5) are to be
read as references to the FCA, and
(b) subsection (9) does not apply."
14 (1) Section 367 (winding-up petitions) is amended as follows.
(3) 40After that subsection insert—
"(1A) The PRA may present a petition to the court for the winding up of a
body which is a PRA-regulated person."
(4) In subsection (2), for "subsection (1)" substitute "subsections (1) and (1A)".
(5) In subsection (6), after "(1)" insert "or (1A)".
15 (1) Section 368 (winding-up petitions: EEA and Treaty firms) is amended as
follows.
(2) 5The existing provision becomes subsection (1).
(3) In that subsection—
(a) for "The Authority" substitute "A regulator", and
(b) after "it" insert "or the other regulator".
(4) After that subsection insert—
"(2) 10If a regulator receives from the home state regulator of a body falling
within subsection (1)(a) or (b) a request to present a petition to the
court under section 367 for the winding up of the body, it must—
(a) notify the other regulator of the request, and
(b) provide the other regulator with such information relating to
15the request as it thinks fit."
16 (1) Section 369 (insurers: service of petition etc. on Authority) is amended as
(b) 20for "on the Authority" substitute "on the appropriate regulator".
(b) for "on the Authority" substitute "on the appropriate regulator".
(a) in relation to a PRA-authorised person, the FCA and the PRA,
(4) If either regulator—
(a) 30presents a petition for the winding up of a PRA-authorised
person with permission to effect or carry out contracts of
insurance, or
(b) applies to have a provisional liquidator appointed under
section 135 of the 1986 Act (or Article 115 of the 1989 Order)
35in respect of a PRA-authorised person with permission to
effect or carry out contracts of insurance,
that regulator must serve a copy of the petition or application (as the
case requires) on the other regulator."
17 (1) 40Section 369A (reclaim funds: service of petition etc. on Authority) is
(a) for "other than the Authority" substitute "other than a regulator",
(a) 5for "other than the Authority" substitute "other than a regulator",
(a) 10in relation to an authorised reclaim fund that is a PRA-
authorised person, the FCA and the PRA, and
(b) in relation to any other authorised reclaim fund, the FCA.
(a) presents a petition for the winding up of an authorised
15reclaim fund that is a PRA-authorised person, or
in respect of an authorised reclaim fund that is a PRA-
authorised person,
20that regulator must serve a copy of the petition or application (as the
18 (1) Section 370 (liquidator's duty to report to Authority) is amended as follows.
(2) The existing provision becomes subsection (1).
(a) in paragraph (a), for "a person other than the Authority" substitute
"any person", and
(b) in paragraph (b), for "to the Authority without delay" substitute
"without delay to the FCA and, if the regulated activity concerned is
30a PRA-regulated activity, to the PRA".
(a) a body is being wound up on a petition presented by a
(b) 35the regulator's petition depended on a contravention by the
body of the general prohibition."
19 (1) Section 371 (power to participate in proceedings: winding up by the court)
is amended as follows.
(2) 40In subsection (1), omit "other than the Authority".
(a) for the purposes of subsections (2), (3) and (5)—
(i) where the body is a PRA-regulated person, each of
5the FCA and the PRA, and
(i) where the body is a PRA-regulated person, the FCA
or the PRA, and
(ii) 10in any other case, the FCA.
(7) But where the petition was presented by a regulator "the appropriate
regulator" does not include the regulator which presented the
petition."
20 (1) Section 372 (bankruptcy petitions) is amended as follows.
"(1A) The PRA may present a petition to the court—
(a) 20under section 264 of the 1986 Act (or Article 238 of the 1989
Order) for a bankruptcy order to be made against an
individual who is a PRA-regulated person;
(b) under section 5 of the 1985 Act for the sequestration of the
estate of an individual who is a PRA-regulated person."
(4) 25In subsection (2), for "such a petition may be presented" substitute "a
petition may be presented by virtue of subsection (1) or (1A)".
(5) In subsection (4)(a)—
(a) after "(1)(b)" insert "or (1A)(b)", and
(b) in paragraph (a), for "the Authority" substitute "the regulator by
which the petition is presented".
21 (1) Section 373 (insolvency practitioner's duty to report to Authority) is
(a) in paragraph (a), omit the words from "by virtue of" to "Authority",
(b) for "to the Authority without delay" substitute "without delay to the
40FCA and, if the regulated activity concerned is a PRA-regulated
activity, to the PRA".
"(1A) Subsection (1) does not apply where—
(a) the bankruptcy order or sequestration award is in force by
virtue of a petition presented by a regulator, and
(b) the regulator's petition depended on a contravention by the
individual of the general prohibition."
(4) 5In the heading, for "to Authority" substitute "to FCA and PRA".
22 (1) Section 374 (Authority's powers to participate in proceedings: bankruptcy)
(a) for the purposes of subsections (2) and (3)—
(i) where the individual or entity is a PRA-regulated
person, each of the FCA and the PRA, and
(ii) 15in any other case, the FCA;
person, the FCA or the PRA, and
(8) 20But where the petition was presented by a regulator "the appropriate
(5) In the heading, for "Authority's powers" substitute "Powers of FCA or
23 (1) 25Section 375 (Authority's right to apply for an order relating to debt
avoidance) is amended as follows.
"(1A) The PRA may apply for an order under section 423 of the 1986 Act
30(or Article 367 of the 1989 Order) in relation to a debtor if—
(a) at the time the transaction at an undervalue was entered into,
the debtor was carrying on a PRA-regulated activity
(whether or not in contravention of the general prohibition);
(b) 35a victim of the transaction is or was party to an agreement
entered into with the debtor, the making or performance of
which constituted or was part of a PRA-regulated activity
carried on by the debtor."
(4) In subsection (2), after "subsection (1)(b)" insert "or subsection (1A)(b) (as
40the case may be)".
(5) In the heading, for "Authority's right" substitute "Right of FCA and PRA".
24 (1) Section 376 (continuation of contracts of long-term insurance where insurer
in liquidation) is amended as follows.
(2) In subsection (11)(c), for "Authority" substitute "PRA".
(3) After subsection (11) insert—
"(11A) The PRA must—
(a) consult the FCA before making an application under
5subsection (10), and
(b) provide the FCA with a copy of any actuary's report made to
the PRA under that subsection.
(11B) In the event that the activity of effecting or carrying out long-term
10authorised activity—
(a) the reference in subsection (11)(c) to the PRA is to be read as
a reference to the FCA, and
(b) subsection (11A) does not apply."
SCHEDULE 15 15The consumer financial education body
1 Schedule 1A (further provision about the consumer financial education
body) is amended as follows.
2 In paragraph 1 (ensuring exercise of functions) for "Authority", in each
place, substitute "FCA".
3 20In paragraph 2 (constitution) for "Authority", in each place, substitute
"FCA".
4 In paragraph 4 (discharge of functions by others), in sub-paragraph (1)(a),
for "section 6A(1)" substitute "section 3R(3)".
5 In paragraph 5 in sub-paragraph (1), for "section 6A(1)" substitute "section
253R(3)".
6 For paragraph 6 (and the italic heading before it) substitute—
"Discharge of functions: considerations
6 In discharging the consumer financial education function the
30consumer financial education body must have regard to the duty
of the FCA to advance its operational objectives.
Relationship with the FCA
6A (1) The consumer financial education body and the FCA must each
35take such steps as it considers appropriate to co-operate with the
other in the exercise of their functions under this Act.
(2) The consumer financial education body and the FCA must
prepare and maintain a memorandum describing how they intend
to comply with sub-paragraph (1).
(3) 40The consumer financial education body must ensure that the
memorandum as currently in force is published in the way


Light travel, going inward and outward, going beyond into infinite space. There is a persistent feeling that is so very encompassing and present in this travel, it is pure delight.
The feeling of delight is causing the space around the movement of travel to expand outward and the particles of life are lighting up. From here the particles of life are like fluff balls or light airy orbs dancing within this traveling space.
The sense of movement is very important.
I see now a Goddess appear. She is so happy and so amazing, she is you, the very infinite and powerful you. She is opening her mouth and the sound is making my whole body vibrate. Her power is in her voice and her radiance is the happy delight of movement. She transforms the old stuck energies and frees them from being stagnant to moving them out of the muck and mud. This is your ability now on Earth as a divine linked human to your Goddess. I hear a name, it is like the wind is telling me this name, It is hard to hear.
It is a long name Yeral Nara Irnuiel.
It sounds erythematic like Gaelic or close to that kind of singsong language. She is very ancient and has been around since the beginning of mankind and other life planets. She helps those that are not able to move forward. She does this with travel. I see that her travel is within dream travel, astral travel, and actual physical travel. It is very divine and beautiful.
The ancient ones use to ask for her blessings so that she brought luck in traveling. Protection and adaptation to all situations. Her light and guidance is a part of you and can be accessed through a sense of great "Faith".
I see her inside of your eyes and your bright energy. You are a savior of sorts and loved so deeply by this connection. There are other sub-divine guides that work through her to help you facilitate what she provides.
Yeral Nara Irnuel is your Divine Soul. She became this incredible entity through a natural transition of Evolution in Spirit. Because you are her your DNA and the cells within are in a constant state of light and bubbling joy.
Through your feet you give the rotation of the Earth a kind of jolt, energetically magnetizing the orbital bodies surrounding Earth. Your energy is very great.
I am floating back now, on a cushion of light air, plasma of light and joy. I can smell your spiritual body, it smells like flowers, sweet jasmine and another smell mixed, not of this Earth, a fruity type smell like orange blossoms. It is so beautiful.


text:
LGBTQ+ stars who were told to stay in the closet
By Stars Insider of StarsInsider |
< PREVIOUS SLIDE SLIDE 1 of 33 NEXT SLIDE >
Coming out as a member of the LGBTQ+ community, though it is increasingly celebratory, remains a very difficult thing to do. That challenge is only amplified when your entire career rides on your public image, as it does for so many actors and musicians.
We all know the struggle to come to terms with one's sexuality can be hard enough, but even when a person is ready to share their authentic self with the world, it can be extremely disheartening to feel like the world isn't ready to hear it. Many LGBTQ+ celebrities have even been pressured to stay in the closet, either by agents, casting directors, friends, or family, despite having expressed the desire to come out.
Click through this gallery to see the stars who have been advised at one point or another to stay in the closet for the sake of their career. And let's celebrate the fact that they didn't!
You may also like: George Clooney and other actors who totally transformed their bodies for a movie
More from StarInsiders
Celebrities open up about raising children with disabilities
StarsInsider
© 2023 Microsoft Privacy & Cookies Terms of use About our Ads Feedback Help MSN Entertainment


If you are aged 18 to 30 years of age and hold a valid passport for one of the countries listed below you might be able to apply for a work visa or permit, under one of New Zealand's Working Holiday Schemes. Applicants from some countries can also apply online (only available for the Belgium, Canada, Denmark, Finland, France, Germany, Ireland, Italy, Malta,the Netherlands, Norway, Sweden and USA working holiday schemes other countries will follow. Please check with the New Zealand Immigration Department at a later date).
the amount of funds the New Zealand Immigration Department require you to have when you arrive.
What opportunities are there for a working holiday in New Zealand?
'Will I be able to get a job?' If you're thinking about coming to New Zealand for a working holiday, this is one of the most important questions to ask. And the answer depends on your skills and experience, the kind of work you're looking for, and what's available.
New Zealand is looking for people who value our culture, our country, our way of life. You may only want to come and work for a short time, but these are still important. If you really want to experience New Zealand, your positive attitude will help you get work.
New Zealand's economy is growing and it's stronger now than it's been for several years. There's a high level of employment but it's still a competitive job market. The employment scene scene is changing because of technology and differences in our workforce.
The labour market is diverse and there are different work opportunities in different regions of New Zealand. Seasonal work is popular for people on working holidays. There are opportunities in orchards, vineyards, agriculture, tourist destinations, and the hospitality industry.
Finding work can take some time and effort, but there are agencies and organisations that can help you succeed. The New Zealand Immigration Department will tell you about the skills New Zealand is looking for, what requirements there are for jobs and how to look for employment.
If you want to come to New Zealand under a Working Holiday Scheme, you will probably need to apply for a Work Visa. Find out about visas and permits, and whether you need one.
Nearly all New Zealand's working holiday schemes require you to have comprehensive medical and hospitalisation insurance for the period of your stay in New Zealand.
People covered by New Zealand's Reciprocal Health Agreement with the United Kingdom are entitled to publicly funded health care for immediately necessary medical treatment only. So the New Zealand Immigration Department recommends that you obtain comprehensive medical insurance for the duration of your working holiday, before you leave for New Zealand.
What about my partner or children?
You cannot bring children to New Zealand on a Working Holiday Scheme Work Visa.
they can also meet the scheme requirements and conditions.
Working Holiday Scheme Work Visas are usually multiple visas. This means that you can enter and leave New Zealand freely during the period of stay authorised by your Work Permit. However, any time you spend out of New Zealand does not get added to the time your Work Permit is valid for.
What if I need to stay longer?
If you want to stay in New Zealand longer, you will need to apply for another type of permit as either a temporary worker, student or a resident.
You will need to allow sufficient time for a decision to be made on your application before your current permit expires. If your current permit does expire, your application for a further permit does not make your stay in New Zealand lawful or give you the right to remain in New Zealand while your application is being considered.
A Work Permit is an endorsement or stamp�in your passport or travel document which allows you to work in New Zealand. If your Work Permit is granted when you arrive in New Zealand, it is subject to any conditions stated in your Work Visa.
If your Work Permit is granted by one of the New Zealand Immigration Department branch offices after you arrive in New Zealand, it will state the permit expiry date and the conditions under which you are allowed to work in New Zealand.Conditions can include the type of work you are allowed to do, the employer you may work for, and the location in New Zealand where you may work.
Generally, you need to be resident in your home country when you apply. However if you're from Germany, Ireland, or the USA (working holidays online countries), or Canada, the Netherlands, Malaysia, Norway,�Thailand or Singapore, you do not have to apply from within your home country. Wherever you apply from, you will still need to meet the requirements of your country's scheme.


text:
Q: Select latest timestamped value from table, which has multiple entries for a column id, for each unique column id and data from another table I need to draw data from two tables for a school site.  Users flag (tFlag) topics they have studied and are ready to answer questions on. These choices are recorded in the userTopics table. There are 55 topics (topicID), and there are many questions available (qID) for each topic on the site.
The UserTopics table also lists a rolling rating of their performance, the topicScore, for each topic. There will only be one unique row for any user per topicID.
UserTopics
| ID | userID | topicID | tFlag | topicScore |
| 25 | 1      | 1       | 1     | 25         |
| 29 | 1      | 2       | 1     | 70         |
| 42 | 1      | 3       | 0     | 5          |
| 41 | 1      | 5       | 0     | 5          |
| 35 | 1      | 6       | 1     | 43         |
| 31 | 1      | 7       | 1     | 62         |
| 44 | 1      | 8       | 0     | 0          |
| 32 | 1      | 9       | 0     | 5          |
| 35 | 1      | 12      | 1     | 30         |

The Results table logs the results of each answered question, and timestamps the answer time, so the table can have many records for each question answered by the user, and looks like this (other cols removed)
Results
| resultID | userID | topicID | qID | correct | answerTime          |
| 9        | 1      | 12      | 15  | 1       | 2020-05-28 11:29:18 |
| 10       | 1      | 12      | 26  | 1       | 2020-05-28 11:30:18 |
| 11       | 1      | 1       | 132 | 0       | 2020-06-02 17:03:42 |
| 13       | 1      | 2       | 50  | 0       | 2020-06-02 17:02:53 |
| 14       | 1      | 7       | 10  | 1       | 2020-06-02 17:05:15 |
| 76       | 1      | 6       | 9   | NULL    | 0000-00-00 00:00:00 |
| 75       | 1      | 6       | 9   | NULL    | 0000-00-00 00:00:00 |
| 65       | 1      | 9       | 12  | NULL    | 0000-00-00 00:00:00 |
| 66       | 1      | 9       | 12  | 1       | 2020-06-04 07:34:02 |

In order to have the system automatically assign a question for the student, we need values for topicScore and answerTime for a specific user for every topicID that they are currently learning. One row must be returned for each topicID in the UserTopics table where tFlag = 1 for the user. The most recent answerTime from the Results table for each returned topicID from userTopics should then be fetched.  If, however, the only answerTime listed for a particular topicID is 0000-00-00 00:00:00, I need that returned. (the answerTime col uses ON UPDATE CURRENT_TIMESTAMP, so if they have loaded the question but not answered it, the value here is zero.)
A query result for userID = 1 would hopefully be:
Query result
| topicID | topicScore | answerTime          |
| 1       | 25         | 2020-06-02 17:03:42 |
| 2       | 70         | 2020-06-02 17:02:53 |
| 6       | 43         | 0000-00-00 00:00:00 |
| 7       | 62         | 2020-06-02 17:05:15 |
| 12      | 30         | 2020-06-04 07:34:02 |

I have tried the following query, but it's not getting what I want, and also don't actually understand it as my grasp of mySQL is a bit basic atm. (query written by another)
SELECT
    r.userID,
    r.topicID,
    r.answerTime,
   (SELECT t.topicScore FROM UserTopics t WHERE t.userID = r.userID AND t.topicID = r.topicID) AS topicScore
    FROM Results r
    LEFT JOIN Results r2 ON r2.topicID = r.topicID AND r.answerTime < r2.answerTime
    WHERE r2.answerTime IS NULL AND r.userID = 1
    ORDER BY `r`.`topicID` ASC

I can see it needs to have Where t.tFlag =1 somewhere, but when I put it in the bracketed where clause, it doesn't work either so I assume the whole query needs a re-write. Glad for any help.

A: Here's the query I have now tried and tested following O Jones suggestions below....needed a couple of changes but the core was just what the doctor ordered, works like a charm, thanks.  Needed only one userID per query, and only results where topicScores are not 0. Also as there is only one row per topicID in the UserTopics table, didn't need the MAX statement either.
SELECT ut.topicId,
       ut.topicScore,
       MAX(r.answerTime) answerTime
  FROM UserTopics ut
  LEFT JOIN Results r   ON ut.userId = r.userId
                       AND ut.topicId = r.topicId
WHERE ut.tFlag =1 AND ut.userId = 1 AND ut.topicScore >0
GROUP BY ut.topicId
ORDER BY ut.topicId

A: First of all, using zero datestamps makes for a brittle design. Later versions of MySQL disallow zero datestamps.   You'll need to give this command to make things work, that is to remove the NO_ZERO_DATE mode.
SET sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

You'd be better off using NULL rather than a zero datestamp.  That being said...
This is a job for GROUP BY, where you pull out the maximum score and answerTime for each combination of userId and topicId. (https://www.db-fiddle.com/f/swC1jG2mMHRsAkCouJNfXq/5)
SELECT ut.userId, ut.topicId,
       MAX(ut.topicScore) topicScore,
       MAX(r.answerTime) answerTime
  FROM UserTopics ut
  LEFT JOIN Results r   ON ut.userId = r.userId
                       AND ut.topicId = r.topicId
WHERE ut.tFlag =1
GROUP BY ut.userId, ut.topicId
ORDER BY ut.userId, ut.topicId

redpajama_set_name: RedPajamaStackExchange


Watch "Georgina [The Audition] (Explicit)" music video by Vybz Kartel, directed by Winston "Tyson" Mayhew.
This version, titled the audition, saw a lot of women dancers displaying their skills in hope to be in the official video.
The video was directed by Winston "Tyson" Mayhew.
Watch "Georgina [The Audition] (Explicit)" music video by Vybz Kartel below.


text:
Tables Turned On Revenge Porn Owner!
February 27, 2015 Lara Mills Leave a comment
Haha! Rarely in the news do you get to see a headline that genuinely makes you smile. It's either doom and gloom, weird sex news, or statistics from the latest sex study that has been done. This story is different.
Revenge porn is slowly becoming a crime across the world, and it is right that it should be! Posting a person's private images or videos online without their permission because they pissed you off a bit? How is that even remotely okay?
For one revenge porn site owner, the tables have well and truly turned after his request to have his image removed from sites talking about his crime was denied by Google. Now he is at the mercy of the internet… and the internet is not kind.
Revenge porn website
Craig Brittain, a 28 year old living in America, started a revenge porn website where you could "submit social nudes anonymously". You could submit the nudes anonymously, but you could also include information that would link to the person's mobile number and social media site.
Why the hell someone would do that, I don't know. What is worse is that Brittain made money from the poor victims on the site.
In order to have the images removed from the site, it has been said that victims would be charged up to $500 (£322) for this "privilege". Yes, they would actually be charged to have their own images, which were posted without permission, taken down!
There are a lot of words I can think of to describe this guy, and one of them ends in the word "hole"!
The crime
Law changes in America meant that his website was illegal, and so it wasn't long until the website was banned. It was ceased from operating by America's Federal Trade Commission, and he then faced some severe charges for what happened.
He has since apologised for his crimes, writing the following statement on his website:
"I made a series of poor decisions, then tried to rationalise them, and made it even worse. I am sorry for the damage that I caused to everyone that ended up on my website. I am making amends at every opportunity. I ask for your forgiveness. What I did was wrong."
As you might imagine, this wasn't enough. People still wanted him to pay for what he did, and finally he is.
Begs for images to be removed
In a fantastic turn of events, Brittain has now gone to Google to ask that they remove links to any stories about his past. His reasoning? They contain "unauthorised photos" of him. Oh the irony!
He has attempted to invoke copyright law, stating that his permission was not received for those images and that they should be removed. He has done this multiple times now, trying to use the Digital Millenium Copyright Act (DMCA) to get Google on his side.
Hardly surprisingly, they have said no.
Apparently, if you were to look at America's first amendment principles, there is absolutely no valid legal grounds to remove the images. Now that is what I call a result!
Does he deserve it?
It seems completely ridiculous that he would expect Google to remove his images because he didn't give his permission when the site he started did exactly the same.
What did he expect to happen? Did he really think they would be removed just like that?
I'm glad that his image is still all over Google next to the words "revenge porn site shut down". He has gotten a taste of his own medicine. As far as I am concerned, he deserves it. You cannot do something as disgusting as that and hope to walk away Scott-free.
What do you think? Should Google remove his images? Is his apology enough to make up for what happened to all of those people?
Personally, I don't think it is. "Sorry" doesn't make up for something like that. This is just another lesson on why you should be careful about who you trust. Do you agree? Pay a visit to the Escort Scotland forum and join the debate over there, or leave your thoughts in the comment box below.
BrittaincrimeGooglejusticepornrevengerevenge porn
Previous PostDogging Adventures in Edinburgh!Next Post5 Reasons To Date A Mature Escort


The Central Government Health Scheme (CGHS) has an online portal that enables subscribers to check their medical history, reimbursement claims, medicines, etc. One can log in to this portal with the beneficiary ID and password.
The Central Government Health Scheme (CGHS) is a government-run health insurance scheme designed specially for the central government employees and their dependents. The scheme also covers pensioners who retired from the central government services and their dependents. The CGHS scheme was rolled out by the Ministry of Health and Family Welfare under the government of India in 1954. It offers a comprehensive medical cover to meet the health requirements of employees serving or have served in central government offices. The medical facilities under the CGHS can however, be availed only in CGHS covered cities. As of now, CGHS facilities are operational in 25 cities in India.
For the benefit of the individuals enrolled in the scheme, an official website has been created for the CGHS. The enrolled beneficiaries can log in to the CGHS site and access information regarding the benefits, features, eligibility, treatment procedures, reimbursement claims, etc.
CGHS covers allopathic, homeopathic, and AYUSH treatments.
The enrolled beneficiaries will be given a plastic CGHS card containing the beneficiary's photo and a unique ID number.
Under the scheme, expenses for Out Patient Department (OPD) and cost of medicines are also covered.
Both cashless and reimbursement facilities are available for treatment in empanelled hospitals.
Costs of hearing aids, artificial limbs, etc. will also be reimbursed under the scheme.
In case of emergency hospitalisation at any hospital other than empanelled hospital, the reimbursement will be done based on the CGHS rates and not on the hospital rates.
2 pre-operative and post-operative consultations, hospital room rent, cost of medicines, and all other hospital related expenses are covered under this scheme.
The scheme is self-funded and depending on the pay, a certain amount is deducted every month from the serving employee's salary. For pensioners who wish to avail the CGHS benefits, they can make a one-time payment (for 10 years) or make a yearly contribution.
Family welfare, child health, and maternity services can also be availed under the scheme.
Who is Eligible for the CGHS scheme?
Current and Ex-Members of Parliament.
Judges and Ex-Judges of Supreme Courts and High Courts.
Employees and pensioners of specific autonomous bodies in Delhi.
Journalists in Delhi accredited with Press Information Bureau (PIB).
Delhi Police staff posted in Delhi.
How to Login to the CGHS site and Access Details?
Step 1: Visit the site - www.cghs.nic.in.
Step 2: You will find a tab on the right side of the page that says 'Beneficiary Login'.
Step 3: On clicking the tab, a new window will be opened that says 'Beneficiary Sign in'.
Step 4: Under which you will find a tab to enter your beneficiary ID and password. If you do not have the password, you can generate one by clicking on 'Generate Password'. Or, if you have forgotten your password, you can use the 'Forgot Password' option to reset your password by following the instructions provided.
Step 5: After receiving your password, you can use your login credentials (beneficiary ID and password) and view your details, the status of your claims, your medical history, etc.
Step 6: You can also update your Aadhaar number by clicking on the tab 'Update Aadhaar No.' and click on 'Save'.
Employees currently serving under the central government offices simply need to submit the necessary forms, along with the photographs of eligible family members to the office/department/ministry where he/she is employed. The documents will be forwarded to the Additional Director of CGHS in the city, by the department/office/ministry.
Pensioners can directly approach the office of Additional Director and submit the required form and documents, to get themselves enrolled in the scheme.