Crazy Query

[Hise, Jeremy]

Hi:
 
We have a set-up that consists of mySQL running on Linux (rh6.2) with
Crystal Reports running reports on another machine. Everytime the report is
ran and CR grabs it's data through the query listed below, it ties up mySQL
(top reports processor % used is 90%+) and never seems to end. We've even
added a limit 50 on the end with no success.
Now, I look at posting my query as the same as someone posting code and
asking others to debug it. But I don't know what else to do at this point.
The query is pretty clean, as you can see. Any ideas?
 

Thanks!!!!
 
SELECT DISTINCT

    bid_journal1.time, bid_journal1.ugroup, bid_journal1.type,

    bid1.id, bid1.status, bid1.int_1_time_1, bid1.int_2_time_1,
bid1.int_3_time_1, bid1.no_show, bid1.offered_rate, bid1.offered_salary,
bid1.settled_rate, bid1.settled_salary,

    job1.id, job1.title, job1.rate,

    agency1.time, agency1.rank, agency1.name,

    agency_location1.capability, agency_location1.location,
agency_location1.type,

    job_admin_releases1.id,

    job_releases1.id,

    job_agency_releases1.job_release_id

FROM

    bid_journal bid_journal1,

    bid bid1,

    job job1,

    agency agency1,

    agency_location agency_location1,

    job_admin_releases job_admin_releases1,

    job_releases job_releases1,

    job_agency_releases job_agency_releases1

WHERE

    bid_journal1.bid_id = bid1.id AND

    bid1.job_id = job1.id AND

    bid1.agency_id = agency1.id AND

    agency1.id = agency_location1.agency_id AND

    job1.id = job_admin_releases1.job_id AND

    job_admin_releases1.id = job_releases1.job_admin_release_id AND

    job_releases1.id = job_agency_releases1.job_release_id

ORDER BY

    agency1.name ASC,

    job1.id ASC,

    bid1.id ASC

 
Jeremy