0.0147 | 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 events1943 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1943 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 25528 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 (1214,1205,1112,1033,1142,1051,1159,1072,1182,1080,1128,1173,1096,1212,1202,1111,1032,1141,1049,1158,1076,1181,1092,1127,1172,1095,1211,1201,1110,1031,1232,1140,1047,1156,1065,1180,1086,1126,1170,1094,1210,1200,1109,1029,1230,1139,1046,1155,1063,1179,1090,1125,1169,1106,1209,1198,1108,1028,1229,1138,1045,1154,1061,1178,1079,1124,1168,1100,1208,1197,1120,1027,1228,1137,1043,1153,1060,1190,1077,1123,1167,1104,1196,1114,1026,1226,1136,1042,1152,1059,1185,1075,1122,1166,1093,1207,1195,1118,1025,1225,1148,1041,1151,1057,1074,1134,1165,1091,1206,1194,1107,1024,1224,1143,1040,1150,1056,1073,1132,1164,1089,1213,1193,1105,1036,1223,1146,1039,1162,1055,1071,1191,1176,1088,1217,1192,1103,1030,1222,1121,1038,1157,1054,1070,1189,1171,1087,1023,1204,1102,1034,1221,1119,1050,1160,1053,1069,1188,1174,1085,1135,1199,1101,1219,1220,1117,1044,1149,1052,1068,1187,1084,1133,1203,1099,1218,1233,1116,1048,1147,1064,1067,1186,1083,1131,1098,1216,1227,1115,1037,1145,1058,1163,1066,1184,1082,1130,1177,1215,1231) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC |