0.0020 | SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1952 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1952 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 25493 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (5457,5369,5447,5396,5306,5401,5334,5430,5474,5337,5415,5353,5368,5446,5387,5304,5411,5331,5429,5473,5336,5414,5352,5456,5367,5445,5384,5303,5412,5322,5428,5472,5346,5424,5351,5455,5366,5444,5382,5302,5409,5319,5427,5471,5347,5425,5350,5454,5365,5443,5381,5301,5400,5317,5437,5470,5344,5295,5349,5453,5364,5442,5380,5300,5397,5316,5438,5469,5335,5359,5464,5363,5441,5379,5299,5395,5315,5436,5468,5332,5360,5462,5362,5440,5378,5298,5394,5314,5413,5467,5330,5357,5426,5372,5451,5377,5297,5393,5313,5410,5466,5329,5348,5423,5449,5376,5307,5392,5312,5408,5477,5328,5345,5422,5373,5465,5375,5308,5391,5311,5407,5478,5327,5343,5421,5370,5463,5385,5305,5390,5310,5406,5475,5326,5342,5420,5361,5461,5386,5296,5389,5320,5405,5439,5325,5434,5341,5419,5358,5460,5383,5452,5388,5321,5404,5435,5324,5433,5340,5418,5356,5459,5374,5450,5398,5318,5403,5323,5432,5339,5417,5355,5458,5371,5448,5399,5309,5402,5333,5431,5476,5338,5416,5354) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC |