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 
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
very good information you write it very clean. I’m very lucky to get this information from
you.
nice share, good article, very usefull for me…thanks
Great article Thank
you so much!
Thanks for this useful article.
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.