select tecmoplayer.*, player_atts.*, logo, city, tname from player_atts, tecmoplayer, tecmoteam where pUID = 647 AND pUID = pID AND plUID = 0 AND tID = ptttID order by psUID desc