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