Recent Comments
Blogroll
Ads by Google
Site Search
Monthly Archives: January 2009
SQL list of WordPress posts and categories
Ever wanted a listing of all your posts along with which categories they are in? Want it in SQL outside of WordPress? Then use this code – select wpr.object_id, wp_terms.name from wp_terms inner join wp_term_taxonomy on wp_terms.term_id = wp_term_taxonomy.term_id inner join wp_term_relationships wpr on wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id where taxonomy= “category” order by object_id; Or for [...]
Year of the Ox
This Chinese new year is the year of the Ox. The BBC has lunar new year preparations in pictures. Jan 26th marks the start of the year, and people born under the Ox are said to be “Born leaders who will work hard to achieve their aims”, and are said to inspire confidence in others. [...]
Posted in Life and opinion
Tagged with : Chinese, Happy New Year, Obama
Comments are closed for this entry.
Chinese censor Obama
I found this fascinating. The very section of Obama’s address that I mentioned yesterday was censored (amongst other bits) by Chinese state television. Of course the part I quoted yesterday was only a very thinly veiled dig at them, but still, they are quick off the mark in chopping Obama’s speeches. Meanwhile, back in this [...]
President Barack Obama
Some 40 years after Martin Luther King’s dream, President Obama is sworn in to the White House in America. Thousands of people crowded into Washington DC to witness the event. As can be expected from Obama, he gave an impressive speach. I was particularly interested with this phrase “To those who cling to power through [...]
Service blips, tags
First off, apologies for the various outages that have plagued this site for the past 48hrs. This has been down to infrastructure issues at my hosting provider, which have hopefully now been sorted. Secondly, I’m working my way through the blog archives and adding tags to the articles. This should hopefully increase the accessibility, especially [...]
