SELECT	p.pid AS pid, 
			p.sid AS sid, 
			s.squadnm AS squadnm, 
			p.charnm AS charnm, 
			p.chartag AS chartag,
			l.shortnm AS loc_shortnm,
			l.longnm AS loc_longnm,
			p.glob_rank AS glob_rank,
			p.loc_rank AS loc_rank,
			p.turns AS turns,
			p.turns_faucet AS turns_faucet,
			p.outs AS outs,
			p.ins AS ins,
			p.calc_market AS calc_market,
			p.cash AS cash,
			p.bank AS bank,
			p.calc_val AS calc_val,
			p.f_newb AS f_newb,
			p.f_hodler AS f_hodler,
			p.f_whale AS f_whale,
			p.f_shill AS f_shill,
			p.f_youtuber AS f_youtuber,
			p.f_redditor AS f_redditor,
			p.f_anon AS f_anon,
			p.f_karen AS f_karen,
			p.f_reporter AS f_reporter,
			p.f_politician AS f_politician,
			p.it_by AS it_by,
			p.it_exp AS it_exp,
			p.a51_by AS a51_by,
			p.fud_by AS fud_by,
			p.fud_exp AS fud_exp,
			p.flight_exp AS flight_exp
		FROM Player p
		JOIN Location l ON l.id = p.loc
		LEFT JOIN Squad s ON s.sid = p.sid
		WHERE login_id = ?;