This list hits on the right items but should be refined based on Gail Shaw's comments and a few other. I thought about passing this to our developers but because...

Note: using CONVERT( varchar(10), LQ.Date_IN, 101) BETWEEN @DateFr AND @DateTo  may eliminate the use of an index on LQ.Date_IN column which may be undesireable!