SELECT post_title, guid FROM wp_posts WHERE post_type = 'attachment' AND (guid LIKE '%.pdf' AND post_title LIKE '%Redhoodie%' AND post_parent = 0)