What exactly is the problem here? What results are you getting?

Are you looking for the correct way to do it with Laravel? If so, I'd suggest taking a good read of the Docs: http://laravel.com/docs/4.2/eloquent#relationships

There is a ton of info there that should help.

If you have, you might want to have a look at RAW: http://laravel.com/docs/4.2/queries#raw-expressions

If you have more complicated queries that Eloquent can't handle, then it is a good bet RAW will help you.

Hope that helps.

I am new to this and I have gone through the docs but they are not that clear to me... I want someone to take a look and let me know if this is right if that is not too much to ask. I imagine when I learn this, I should be able to just look at the schema linked and just know how to do the query or the models...but I'm not quite there yet so I need some examples to help me solidify my understanding.