Quote Originally Posted by PAVB
Your query is executing in-line view for each row in main query.

I would seriously consider creating a temp table with the query you are using to populate in-line view, query is creating once and again the same list no matter row selected on main query.

Once you have your temp table you can take out in-line view and replace is for a single additional where clause.

Depending on temp table size an index on temp.wfraud_data.id wouldn't hurt.
Sorry didnt get it ...