8Nov/096
SQL query for WordPress Posts
I have been trying to write a SQL select query for getting the all the posts made in wordpress blog (to create a latest news banner). This seem easy enough, doesn't it. The problems arose due to the post revising done by the wordpress blog application, this was just added a layer of confusion. The wordpress blog database stores multiple records for a single post, one record each saved version of the post. However removing this layer, I found that a simple select query will do the job nicely, and here it is:
SELECT * FROM 'wp_posts' WHERE post_status='publish' order by post_date DESC
Nice and Simple 
February 9th, 2010 - 16:17
I absolutely enjoyed reading your blog and turn up it both illuminating and interesting. I wish for be sure to bookmark it and plague it as again as I can.
Thanks
Bernice Franklin
May 23rd, 2010 - 16:49
very good information you write it very clean. I’m very lucky to get this information from
you.
May 30th, 2010 - 12:45
nice share, good article, very usefull for me…thanks
May 30th, 2010 - 17:40
Great article Thank
you so much!
June 5th, 2010 - 11:01
Thanks for this useful article.
June 9th, 2010 - 04:43
Hi, I’m very interested in Linux but Im a Super Newbie and I’m having trouble deciding on the right distribution for me (Havent you heard this a million times?) anyway here is my problem, I need a distribution that can switch between reading and writing in English and Japanese (Japanese Language Support) with out restarting the operating system.