I try to execute the following query, but I always get 0 rows back :(
SELECT id, post_name, post_date FROM wp_posts WHERE guid = '2e9e0429-4d51-4452-a942-124e85478e30'
There is a row in wp_posts with the specified guid, so I really don't understand why I can't retrieve it with my query?
One other thing: What method is used to determine the post slug? I have noticed that it makes sure post slug are unique, so I would love to use that functionality in my upload script.