How to run this raw query in laravel

Posted 3 months ago by tanveerkhanwd
//I am just trying to use this query in my controller:

SELECT *,(select gaw.weight FROM game_activity_wets gaw WHERE gaw.creator_id=game_activity_wets.creator_id AND gaw.type=0 AND gaw.game_id=game_activity_wets.game_id) as startweight FROM `game_activity_wets` WHERE game_id=37 and type=2 GROUP BY creator_id

Please sign in or create an account to participate in this conversation.