Select
  hands.TOTAL_POT,
  cards.CARD As BOARD1,
  cards1.CARD As BOARD2,
  cards2.CARD As BOARD3,
  cards3.CARD As BOARD4,
  cards4.CARD As BOARD5,
  cards5.CARD As CARD1,
  cards6.CARD As CARD2,
  summary.ACTION,
  player.Name As SUMMARY_NAME,
  summary.AMOUNT,
  summary.HAND_DESCRIPTION,
  player1.Name As OWN_PLAYER_NAME
From
  reg_users Inner Join
  table_names_mapping
    On table_names_mapping.UserID = reg_users.ID Inner Join
  table_names
    On table_names_mapping.TABLE_NAME_ID = table_names.ID Inner Join
  hands
    On hands.TableNameID = table_names.ID Inner Join
  summary
    On summary.HandID = hands.HandID Inner Join
  cards
    On hands.BOARD1 = cards.ID Inner Join
  cards cards1
    On hands.BOARD2 = cards1.ID Inner Join
  cards cards2
    On hands.BOARD3 = cards2.ID Inner Join
  cards cards3
    On hands.BOARD4 = cards3.ID Inner Join
  cards cards4
    On hands.BOARD5 = cards4.ID Inner Join
  cards cards5
    On hands.OWN_CARD1 = cards5.ID Inner Join
  cards cards6
    On hands.OWN_CARD2 = cards6.ID Inner Join
  player
    On summary.NAME = player.ID Inner Join
  player player1
    On hands.OWN_PLAYER = player1.ID
Where
  (reg_users.ID = 1 And
  summary.ACTION = 9) Or
  (summary.ACTION = 14)

  
  Select
  hands.TOTAL_POT,
  cards.CARD As BOARD1,
  cards1.CARD As BOARD2,
  cards2.CARD As BOARD3,
  cards3.CARD As BOARD4,
  cards4.CARD As BOARD5,
  cards5.CARD As CARD1,
  cards6.CARD As CARD2,
  summary.ACTION,
  player.Name As SUMMARY_NAME,
  summary.AMOUNT,
  summary.HAND_DESCRIPTION,
  player1.Name As OWN_PLAYER_NAME
From
  reg_users Inner Join
  tournaments
    On tournaments.UserID = reg_users.ID Inner Join
  hands
    On hands.TournamentID = tournaments.TournamentID Inner Join
  summary
    On summary.HandID = hands.HandID Inner Join
  cards
    On hands.BOARD1 = cards.ID Inner Join
  cards cards1
    On hands.BOARD2 = cards1.ID Inner Join
  cards cards2
    On hands.BOARD3 = cards2.ID Inner Join
  cards cards3
    On hands.BOARD4 = cards3.ID Inner Join
  cards cards4
    On hands.BOARD5 = cards4.ID Inner Join
  cards cards5
    On hands.OWN_CARD1 = cards5.ID Inner Join
  cards cards6
    On hands.OWN_CARD2 = cards6.ID Inner Join
  player
    On summary.NAME = player.ID Inner Join
  player player1
    On hands.OWN_PLAYER = player1.ID
Where
  (reg_users.ID = 1 And
  summary.ACTION = 9) Or
  (summary.ACTION = 14)
