WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ros_wp.ros_wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM ros_wp_posts WHERE post_date < '2020-10-30 20:04:37' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

August 28, 2008

Filed under: Uncategorized, Northwest European — ros @ 12:36 pm

The internet is a funny place isn’t it? For a start, it isn’t really a place at all, although it does feel like one: a seperate world where people can quietly have a look into other people’s lives (yes, serial lurkers, I still know you’re there ;) ). It’s a place where one can anonymously irritate and insult perfect strangers all day without getting punched in the face and, on a chatroom somewhere, a lonely guy in his mid forties can start a loving relationship with a beautiful girl in New York without knowing that in reality she’s a fat hairy man from Newcastle.

I’ve heard some people say that one day the internet will be the world’s single source of information and will eliminate the need for books and television. Personally, I hope this doesn’t happen. I’m no stickler for tradition but I think there is one big problem with the net at the moment: search engines. Search engines were designed to be intelligent, but they are, for now, very, very stupid indeed. To demonstrate what I mean, let’s try a little experiment. Open a new tab on your browser (or a whole new browser window if you’re the type to have a messy desktop) and go to www.google.co.uk. Now, search for ‘how to cook couscous’.

Obviously Google, the biggest and most important search engine in the universe, is designed to bring you the best and most useful results for your query. Look down to the bottom of the page (possibly the top of the second page) and you should see a link starting ‘Andy Millar….’

That’s right, in Google’s opinion, one of the world experts on cooking couscous is Goon. The man who the other day served up crunchy pasta in a carbonara, the man who asked me if chocolate truffles were dug up by pigs in France, the man who I recently caught trying to drink sherry soaked raisins straight from a mug, is one of Google’s top choices for advice on cooking this particular carbohydrate.

Needless to say, Goon has never cooked couscous by himself. It is very, very dangerous to trust Google’s recipe choices.

Of course, in reality, I love the internet. Over the last week when my access was limited, I felt like I was going slightly mad. Google is the one of the things I use the most, both for searching and for advertising on my site. However, on occasions it does frustrate me. There are days, when I have a bit of comment abuse from the internuts and I wonder why they have decided to attack me so suddenly. Generally it turns out that Google has put me top of an image search for cute fluffy bunnies and I bet you can guess which posts it links to.

Then there are the occasions where Google does send people with relevant queries to my site but directs them to the wrong place. If you search for beef mince recipes (as a ludicrous number of people appear to do), my blog’s first appearance will direct you to the archive for September 2006, which is totally useless. I do have a page somewhere with beef mince recipes but that obviously isn’t relevant.

Now, one of Google’s favourite pages on my blog appears to be the recipe for devilled kidneys. It was an old page, from before the great hard drive crash of Summer 2006. The picture was gone, the recipe was vague. However it was Google’s 5th hit. I was embarrassed, so I decided to spruce it up and, to make sure that Google doesn’t start sending people to the August 2008 page instead of to the right place, I’m giving it a Google boost.

So, Google spiders, are you watching? This is the recipe for devilled kidneys. That’s right, a devilled kidney recipe. In fact it is a lamb kidney recipe too.  You may wish to call it a deviled kidney recipe  or a recipe for deviled kidneys.

I think that should do it. :) I’m afraid you have to click on one of the links to see the devilled kidney recipe. You’ll see why.


  1. To be fair to Goon, I don’t see too much wrong with taking sherry-soaked raisins from the mug… what kind of sherry? :)

    Comment by Richard — August 28, 2008 @ 12:48 pm

  2. Ros: you have to correct Mr Millar’s probability theory before his progress in life is further bedevilled! :-)

    Comment by Fëanor — August 28, 2008 @ 3:29 pm

  3. Richard, you’re right- there’d be no problem in him *taking* the raisins from the mug, but tipping the mug in a drinking fashion fashion so the raisins fell over his face, now THAT was just silly. It was an Amontillado brand pale dry sherry that I keep for cooking purposes. They rasins were for the tequila chicken I posted a month or two ago.

    Feanor, we must remember he got an E in A-Level further maths. But, yes, that is painful, even more so now that I have quizzed him as to what that post was actually about, Apparently all that gibberish was meant to prove that if a<1 then a^2 < a. Yeek!
    To be honest compared to the blooper my father made (he teaches maths up to GSCE part time) it isn’t that bad. Last Sunday Dad said “I read that the probability of a baby having a non white mother is 0.25. So if the probability of a baby having a non white father is 0.25 then the number of children with two non white parents is (0.25)^2.” AAAAAAARGH! Forget Monty Hall, we need to start teaching common sense!

    Comment by ros — August 28, 2008 @ 10:34 pm

  4. LOL! But you are right, God bless Google, what the hell did I do for entertainment before it?? And where on earth do those pesky internuts come from anyway?? Usually best to keep the head down and wait for them to be distracted and wander off back to their burrows. Or to return to their raunchy conversation with the fat, hairy bloke in Newcastle ;-)

    Comment by Jeanne — August 31, 2008 @ 6:08 pm

  5. So which are you - a cute fluffy bunny, a fat hairy Geordie, or a kidney devil?

    Comment by Mike — September 1, 2008 @ 7:52 pm

  6. I have to say the sherry soaked raisins don’t sound to bad straight from the mug. Once at a party we ran out of booze and the last thing we’d finished off was some sloe gin - we thought it would be a great idea to blend the sloes and make a smoothie - suffice to say it was disgusting!

    Comment by Charles — September 8, 2008 @ 5:43 pm

RSS feed for comments on this post. TrackBack URI

Leave a comment

In the aid of defeating SPAM Comments, please follow these instructions: