Gracias por tu ayuda, al final lo he conseguido hacer así
Código PHP:
$query_Recordset1 = "SELECT DISTINCT vbookie_bets_placed.bet_placed, user.username, vbookie_items.item_title, vbookie_bets_placed.bet_amount_placed, user.vbookie_cash FROM user INNER JOIN vbookie_bets_placed ON user.userid=vbookie_bets_placed.userid INNER JOIN vbookie_items ON vbookie_bets_placed.item_id = vbookie_items.item_id INNER JOIN vbookie_item_options ON vbookie_items.item_id =vbookie_item_options.item_id ORDER BY username DESC";