Hello,

what scares me about this SQL is the call to FILE function ...
i think FILE has to check harddrive if it exists .. this will most likely slow down the query a lot!

that said i would split the SQL to make sure that FILE is called only on records that are contained in the final resultset ..

Regards
Christian