SELECT * 
FROM 
`s2mbaj_posts` p left JOIN
`s2mbaj_postmeta` pm on p.ID = pm.meta_value
where p.post_type = 'attachment' and ifnull(pm.post_id,-1) = -1