2007 - 08 russian volleyball super league
in the 2007 - 08 russian volleyball super league , among the arenas with capacity 5000 , 2 of them are home arenas for team that were ranked 5 or higher in the previous season .
{'scope': 'subset', 'criterion': 'less_than_eq', 'value': '5', 'result': '2', 'col': '1', 'subset': {'col': '4', 'criterion': 'fuzzily_match', 'value': '5000'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_less_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'arena ( capacity )', '5000'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; arena ( capacity ) ; 5000 }', 'tointer': 'select the rows whose arena ( capacity ) record fuzzily matches to 5000 .'}, 'previous season', '5'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose arena ( capacity ) record fuzzily matches to 5000 . among these rows , select the rows whose previous season record is less than or equal to 5 .', 'tostr': 'filter_less_eq { filter_eq { all_rows ; arena ( capacity ) ; 5000 } ; previous season ; 5 }'}], 'result': '2', 'ind': 2, 'tostr': 'count { filter_less_eq { filter_eq { all_rows ; arena ( capacity ) ; 5000 } ; previous season ; 5 } }', 'tointer': 'select the rows whose arena ( capacity ) record fuzzily matches to 5000 . among these rows , select the rows whose previous season record is less than or equal to 5 . the number of such rows is 2 .'}, '2'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_less_eq { filter_eq { all_rows ; arena ( capacity ) ; 5000 } ; previous season ; 5 } } ; 2 } = true', 'tointer': 'select the rows whose arena ( capacity ) record fuzzily matches to 5000 . among these rows , select the rows whose previous season record is less than or equal to 5 . the number of such rows is 2 .'}
eq { count { filter_less_eq { filter_eq { all_rows ; arena ( capacity ) ; 5000 } ; previous season ; 5 } } ; 2 } = true
select the rows whose arena ( capacity ) record fuzzily matches to 5000 . among these rows , select the rows whose previous season record is less than or equal to 5 . the number of such rows is 2 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_less_eq_1': 'filter_less_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'arena (capacity)_6': 'arena ( capacity )', '5000_7': '5000', 'previous season_8': 'previous season', '5_9': '5', '2_10': '2'}
['previous season', 'team', 'town', 'arena ( capacity )', 'website', 'head coach', 'foreign players ( max 2 )']
[['1', 'dynamo - tattransgaz kazan', 'kazan', 'basket - hall arena ( 7 000 )', 'wwwdinamottgru', 'viktor sidelnikov', 'lloy ball clayton stanley'], ['2', 'dynamo moscow', 'moscow', 'dynamo sports palace ( 5 000 )', 'wwwvcdynamoru', 'daniele bagnoli', 'matej černič alan barbosa domingos'], ['3', 'iskra', 'odintsovo', 'volleyball sportiv complex ( 3 500 )', 'wwwvc - iskraru', 'zoran gajić', 'giba jochen schöps'], ['4', 'fakel', 'novy urengoy', 'csc gazodobytchik ( 800 )', 'wwwfakelvolleyru', 'boris kolchin', 'domotor meszaros thomas hoff'], ['5', 'lokomotiv - izumrud', 'ekaterinburg', 'divs uralochka ( 5 000 )', 'loko - izumrudurru', 'valeriy alferov', 'terence martin jason haldane'], ['6', 'dynamo - yantar', 'kaliningrad', 'sc yunost', 'wwwdinamoyantarru', 'yuriy panchenko', 'sean rooney tuomas sammelvuo'], ['7', 'gazprom - yugra', 'surgutsky district', 'sc tennis center', 'wwwzsk - gazpromru', 'rafael habibullin', 'sasa gadnik mahdi hachemi'], ['8', 'lokomotiv belogorie', 'belgorod', 'sports palace cosmos ( 5 000 )', 'wwwbelogorievolleyru', 'genadiy shipulin', 'frank depestel samuel fuchs'], ['9', 'ural', 'ufa', 'foc neftyanik bashkortostana', 'wwwvolleyufaru', 'yuriy marichev', 'loïc thiebaut de kegret renaud herpe'], ['10', 'lokomotiv', 'novosibirsk', 'skk sever ( 2 500 )', 'wwwlokovolleyru', 'pavel borsch', 'william priddy héctor soto'], ['promoted', 'yaroslavich', 'yaroslavl', 'sk atlant', 'wwwyarvolleyru', 'vladimir babakin', 'lukas chaves frederick winters']]