Hi Guys,

I have LEFT OUTER JOIN some tables in order to display the rest of the information, but the query takes 14:16 minutes to retrieve 42017 rows, which in my opinion is considerable too long.

Is there no other way i can write this in a simple manner that is fast?