anaprof 2006
the tauro fc is the only team with a single lost ( pp ) in the 2006 season of anaprof .
{'scope': 'all', 'row': '1', 'col': '6', 'col_other': '2', 'criterion': 'equal', 'value': '1', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'lost ( pp )', '1'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose lost ( pp ) record is equal to 1 .', 'tostr': 'filter_eq { all_rows ; lost ( pp ) ; 1 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; lost ( pp ) ; 1 } }', 'tointer': 'select the rows whose lost ( pp ) record is equal to 1 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'lost ( pp )', '1'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose lost ( pp ) record is equal to 1 .', 'tostr': 'filter_eq { all_rows ; lost ( pp ) ; 1 }'}, 'team ( equipo )'], 'result': 'tauro fc', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; lost ( pp ) ; 1 } ; team ( equipo ) }'}, 'tauro fc'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; lost ( pp ) ; 1 } ; team ( equipo ) } ; tauro fc }', 'tointer': 'the team ( equipo ) record of this unqiue row is tauro fc .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; lost ( pp ) ; 1 } } ; eq { hop { filter_eq { all_rows ; lost ( pp ) ; 1 } ; team ( equipo ) } ; tauro fc } } = true', 'tointer': 'select the rows whose lost ( pp ) record is equal to 1 . there is only one such row in the table . the team ( equipo ) record of this unqiue row is tauro fc .'}
and { only { filter_eq { all_rows ; lost ( pp ) ; 1 } } ; eq { hop { filter_eq { all_rows ; lost ( pp ) ; 1 } ; team ( equipo ) } ; tauro fc } } = true
select the rows whose lost ( pp ) record is equal to 1 . there is only one such row in the table . the team ( equipo ) record of this unqiue row is tauro fc .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_eq_0': 'filter_eq', 'all_rows_6': 'all_rows', 'lost (pp)_7': 'lost ( pp )', '1_8': '1', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'team (equipo)_9': 'team ( equipo )', 'tauro fc_10': 'tauro fc'}
['place ( posición )', 'team ( equipo )', 'played ( pj )', 'won ( pg )', 'draw ( pe )', 'lost ( pp )', 'goals scored ( gf )', 'goals conceded ( gc )', '+ / - ( dif )', 'points ( pts )']
[['1', 'tauro fc', '18', '10', '7', '1', '31', '17', '+ 14', '37'], ['2', 'san francisco fc', '18', '11', '2', '5', '40', '25', '+ 15', '35'], ['3', 'arabe unido', '18', '10', '3', '5', '30', '20', '+ 10', '33'], ['4', 'atlético veragüense', '18', '9', '6', '3', '22', '16', '+ 6', '33'], ['5', 'plaza amador', '18', '9', '4', '5', '25', '17', '+ 8', '31'], ['6', 'alianza fc', '18', '8', '2', '8', '29', '31', '- 2', '26'], ['7', 'municipal chorrillo', '18', '6', '6', '6', '24', '23', '+ 1', '24'], ['8', "sporting ' 89", '18', '4', '1', '13', '17', '31', '- 14', '13'], ['9', 'atlético chiriquí', '18', '2', '4', '12', '14', '30', '- 16', '10'], ['10', 'policia nacional', '18', '3', '1', '14', '17', '39', '- 22', '10']]