Non equi joins Q on SO

This is an internal list for me to get an idea of the type of Q that come up often, and how many Q could potentially benefit from non-equi joins.. (+ aggregate/update feature of data.table). These are the Q I've come across so far.

Date	Link
29.06.2014	http://stackoverflow.com/q/24480031/559784
01.10.2014	http://stackoverflow.com/q/26134707/559784
21.10.2014	http://stackoverflow.com/q/26482559/559784
15.11.2014	http://stackoverflow.com/q/26944565/559784
23.03.2016	http://stackoverflow.com/q/36190921/559784
29.03.2016	http://stackoverflow.com/q/36284173/559784
06.04.2016	http://stackoverflow.com/q/36454565/559784
10.04.2016	http://stackoverflow.com/q/36533139/559784
09.06.2016	http://stackoverflow.com/q/37727617/559784
22.06.2016	http://stackoverflow.com/q/37978658/559784
24.06.2016	http://stackoverflow.com/q/38017753/559784
25.06.2016	http://stackoverflow.com/q/37163070/559784
27.06.2016	http://stackoverflow.com/q/38061961/559784
10.07.2016	http://stackoverflow.com/q/38297148/559784
12.07.2016	http://stackoverflow.com/q/38327158/559784
18.07.2016	http://stackoverflow.com/q/38433873/559784
18.07.2016	http://stackoverflow.com/q/38426821/559784
18.07.2016	http://stackoverflow.com/q/38424301/559784