Adding a constant IF not in an other table
Is this what you are looking for?  

    select * 
    FROM Comment cm left join [Delete] del
     on del.[Target]=cm.Id
    where cm.[Target] = '".$_GET[''pp'']."'
    and Type = 'comment'
    and del.[Target] is null
    and deleted=0