select pID, pos, first, last, face, race, pUID, pttUID, probowl, psUID from player_atts, tecmoplayer where pID = pUID AND probowl = 1 AND plUID = 0 AND psUID = AND pos <= 4 order by pos asc