4 ms·Love me some lateral join / cross apply. Correlated subqueries and visibility in the where clause?! Whoo.by x-shadowban 3y agoLove me some lateral join / cross apply. Correlated subqueries and visibility in the where clause?! Whoo.