why do people use right joins. i'll never understand it. especially in this case you when you can just query purchases directly and joining to users is pointless.