Optimizing a MySQL query with several joins?

Is results. Report_id indexed? It's failing to find a key and doing a table scan it looks like.

I'm assuming results.id is actually the primary key.

I would use STRAIGHT_JOIN and go with your second query that has the patients_reports table first and secondarily join to the patient table for their name info. Additionally, if I didn't see it, was there an index on the patients_reports table by the PATIENT_ID column either by itself, or as first element of a compound index key?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.