Query MySQL się nie wykonuje (Node.js)

Chcę, query wykonywało się gdy użytkownik chce stworzyć konto i aby zredukować ilość zapytań zrobiłem po prostu wszystko w jednym, ale niestety nie działa.

app.post('/api/create_account', async (req, res) => {
  let name = req.body.name;
  let surname = req.body.surname;
  let username = req.body.username;
  let password = req.body.username;
  let confirm_password = req.body.confirm_password;
  let email = req.body.email;
  let country = req.body.country;
  if(password != confirm_password){
    res.redirect('/account/create-account')
    res.end();
  }
  let query = "INSERT INTO users (username, password, email) VALUES(?, ?, ?);" +
  "INSERT INTO additional_info(id, name, surname, country) VALUES(" +
  "(SELECT id FROM users WHERE username = ? AND password = ? AND email = ?)" +
  ", ?, ?, ?);" +
  "INSERT INTO verified (id, verified) VALUES (" +
  "(SELECT id FROM users WHERE username = ? AND password = ? AND email = ?)" +
  ", 0);" +
  "INSERT INTO theme (id, theme) VALUES (" +
  "(SELECT id FROM users WHERE username = ? AND password = ? AND email = ?)" +
  ", '?');" +
  "INSERT INTO profpic (id, location) VALUES (" +
  "(SELECT id FROM users WHERE username = ? AND password = ? AND email = ?)" +
  ", 'profpic/default.png');";
  console.log(query)
  con.query(query,[username, password, email,
      username, password, email, name, surname, country,
      username, password, email,
      username, password, email, req.session.theme,
      username, password, email
    ], () => {
    res.redirect('/account/email_confirmation')
  });
})

https://github.com/mysqljs/mysql#multiple-statement-queries

Btw, nie zapomnij o begin transaction; oraz commit; :-)