The SQL below will delete any issues that are in the issuesfordeletion table:
-- Run this once
create table issuesfordeletion (issueid int)
go
-- Insert your issue ids into the table: here we only inserted 1 issue to delete (26)
insert into issuesfordeletion values(26)
go
delete from issuehistory where issueid in (select issueid from issuesfordeletion)
delete from issueattachments where issueid in (select issueid from issuesfordeletion)
delete from issuevotes where issueid in (select issueid from issuesfordeletion)
delete from affectedversion where issueid in (select issueid from issuesfordeletion)
delete from issueresource where issueid in (select issueid from issuesfordeletion)
delete from issuecomponent where issueid in (select issueid from issuesfordeletion)
delete from watchissue where issueid in (select issueid from issuesfordeletion)
delete from issuealerts where issueid in (select issueid from issuesfordeletion)
delete from issuelinks where issueid in (select issueid from issuesfordeletion)
delete from issuelinks where otherissueid in (select issueid from issuesfordeletion)
delete from customfielddata where issueid in (select issueid from issuesfordeletion)
delete from personalfilters where issueid in (select issueid from issuesfordeletion)
delete from sourcecontrolissuefiles where issueid in (select issueid from issuesfordeletion)
delete from timetracking where issueid in (select issueid from issuesfordeletion)
delete from issuecomments where issueid in (select issueid from issuesfordeletion)
delete from issues where issueid in (select issueid from issuesfordeletion)