Active records and complex join query

[eluser]softsaurus[/eluser]
Hi there guys, sorry for the late response, I've been away much lately.
But nothing sucks more than an unresolved topic so let me clarify.

@seanloving your approach is totally valid!
Thank you both for your suggestions and sollution, it's working fine right now.
Can't link you to my project for it's still undergoing development, but I thank you!

Again, sorry for keeping you waiting so long.