SELECT * FROM `wp14_posts` WHERE `post_status` = 'publish' AND `post_type` = 'log' ORDER BY `post_date` DESC