select tecmoplayer.*, player_atts.*, ttTecmoOrder, ttCity, ttName from player_atts, tecmoplayer, standings where pUID = 6802 AND pUID = pID AND pttUID = ttTecmoOrder AND plUID = ttlUID AND plUID = 0 AND psUID =  AND tttID = ptttID AND psUID = ttsUID