Long running query that never finishes (six days at 100%CPU)

It would help even more to show the original “RT query” that generated
this SQL.

Eric Schultz
United Online

It would help even more to show the original “RT query” that generated
this SQL.

Here you go.

Thanks,
Brian

[13/Jul/2006:10:09:30 -0400] x.x.x.x SSLv3 RC4-MD5 “GET
/Search/Results.html?Order=ASC&Query=%20Priority%20%3D%2075%20AND%20Created%20%3E%20’1%2F1%2F2006’%20AND%20Queue%20%3D%20’alerts’%20AND%20’CF.%7BActionable%7D’%20LIKE%20’Yes’%20AND%20’CF.%7BIR%7D’%20LIKE%20’Yes’%20AND%20Content%20NOT%20LIKE%20’Incident%20Report’&Rows=&OrderBy=id&Format=’%20%20%20%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’’%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’
HTTP/1.1” 52331