SELECT issue.id, issue.magazine_id FROM issue INNER JOIN magazine ON issue.magazine_id = magazine.id INNER JOIN user ON magazine.publisher_id = user.publisher_id WHERE user.login = 'publogin' AND replace(magazine.name,' ','_') = 'AVN' AND issue.issue_no = 6 LIMIT 1