I'm trying to get the image url and ID for images attached to a particular post from the post meta table, joining onto the posts table using the Query below.
The query as it stands returns an empty set. If I remove the WHERE posts.post_parent = $intPostId clause, it returns all the image attachments, which is nearly what I want -- but too much!
What change do I need to make to the query to get the data I want?
// $intPostID contains the post ID of the post where all the images are attached.
SELECT
meta.post_id AS image_id, meta.meta_value AS url
FROM
$wpdb->posts AS posts LEFT JOIN $wpdb->postmeta AS meta
ON
posts.ID = meta.post_id
WHERE
posts.post_parent = $intPostId
AND
meta.meta_key = '_wp_attached_file'
ORDER BY
posts.post_date DESC