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 < '2024-04-19 06:40:43' 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

September 25, 2006

Filed under: Uncategorized — ros @ 12:28 pm

I have a thing called “Counterize” on this site. It tells me the IP addresses of who visits here, what referred them here and, if they got me from Google, what questions they asked to get here. It also tracks what pages they look at.

Believe it or not, the search engine hits  make an interesting and amusing read. For a start there are the bizarre searches for things such as  ‘woman eating live fish,’ and ‘vegetable porn.’ 

Also, a load of people seem to look for BBC or Waitrose recipes on here. You do know they have their own recipe websites, right? The links are right there on the sidebar.

Then there are the people who are obviously confused when Google refers them here and their search item is not at the top of the page. They then click randomly on various pages befire giving up in frustration (or so it would seem). Almost without fail, these people are looking for ‘beef mince recipes.’ 

So if you are one of the  frustrated ‘beef mince recipe’ searchers, I’ve got two things to make your life easier. There is a link to recipes at the top of this page and I’ve also moved the site’s search facilty to a new, more prominent position.

If you’re looking for vegetable porn, I’m about to share a flat with a man who starred in this video,  so you may yet find what you’re looking for.

PS. What’s with all you lurkers? Over 800 visitors and about 10 have commented. :p

2 Comments »

  1. Congratulations on your 100th post, keep em’ coming please, I love it!! And now I get why you’ve eaten at Vienna too, isn’t their hot seafood platter to die for?? Can’t wait to find out what you’re up to on Thursday…
    Miss O.

    Comment by MissOyster — September 26, 2006 @ 9:12 am

  2. hahahaha nice post
    I recently placed one of those trackers on my site as well and am fascinated at how people make their way to my site. My highest traffic generator is my post about roast marrowbone… who’da thunk so many people are making roast marrowbone??

    I also feel for you about the few comments… I get lots of hits per day.. but the same 3 or 4 people are the only ones who comment! Let me tell you, I love those 3 or 4 people! sometimes I feel like I’m making my posts just for them! ha! ;-)

    Comment by Lea — September 26, 2006 @ 2:06 pm

RSS feed for comments on this post. TrackBack URI

Leave a comment

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