0.0021 | 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 events1949 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1949 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 25503 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 (4136,4169,4155,4291,4190,4202,4230,4287,4261,4210,4122,4133,4166,4157,4294,4191,4199,4270,4283,4259,4219,4171,4130,4162,4147,4302,4194,4272,4244,4255,4216,4180,4127,4132,4160,4146,4299,4196,4197,4276,4245,4252,4231,4176,4123,4141,4148,4295,4187,4206,4266,4247,4234,4284,4120,4137,4158,4156,4292,4185,4264,4249,4250,4236,4285,4217,4167,4153,4118,4188,4267,4240,4256,4227,4288,4092,4220,4177,4163,4149,4290,4195,4275,4238,4203,4225,4289,4128,4222,4178,4138,4300,4192,4273,4241,4204,4228,4280,4124,4213,4181,4139,4145,4296,4186,4268,4248,4207,4235,4278,4257,4211,4183,4125,4142,4154,4164,4265,4242,4209,4232,4281,4258,4214,4174,4126,4144,4150,4165,4184,4271,4239,4200,4229,4286,4260,4221,4172,4129,4134,4168,4193,4297,4263,4198,4226,4282,4262,4218,4182,4135,4223,4170,4189,4298,4274,4237,4201,4279,4253,4215,4179,4131,4143,4159,4151,4301,4269,4246,4208,4224,4251,4212,4175,4121,4140,4161,4152,4293,4243,4205,4233,4277,4254,4173,4119,4117,4116,4115,4114,4113,4112,4111,4110,4109,4108,4107,4106,4105,4104) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC |