SHARE
TWEET

Extra Data

a guest May 2nd, 2018 176 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO `player_match_points` (`id`, `player_id`, `match_id`, `points`) VALUES
  2. (1, 179038, 1, 2),
  3. (2, 181406, 1, 2),
  4. (3, 184320, 1, 2),
  5. (4, 190962, 1, 2),
  6. (5, 207809, 1, 2),
  7. (6, 208016, 1, 2),
  8. (7, 217172, 1, 2),
  9. (8, 218284, 1, 2),
  10. (9, 218306, 1, 2),
  11. (10, 233952, 1, 2),
  12. (11, 239424, 1, 2),
  13. (12, 271043, 1, 2),
  14. (13, 289964, 1, 2),
  15. (14, 298613, 1, 2),
  16. (15, 298959, 1, 2),
  17. (16, 309426, 1, 2),
  18. (17, 312868, 1, 2),
  19. (18, 314197, 1, 2),
  20. (19, 318172, 1, 2),
  21. (20, 356669, 1, 2),
  22. (21, 362727, 1, 2),
  23. (22, 367913, 1, 2),
  24. (23, 367918, 1, 2),
  25. (24, 179038, 2, 2),
  26. (25, 181406, 2, 2),
  27. (26, 184320, 2, 2),
  28. (27, 190962, 2, 2),
  29. (28, 207809, 2, 2),
  30. (29, 208016, 2, 2),
  31. (30, 217172, 2, 2),
  32. (31, 218284, 2, 2),
  33. (32, 218306, 2, 2),
  34. (33, 233952, 2, 2),
  35. (34, 239424, 2, 2),
  36. (35, 271043, 2, 2),
  37. (36, 289964, 2, 2),
  38. (37, 298613, 2, 2),
  39. (38, 298959, 2, 2),
  40. (39, 309426, 2, 2),
  41. (40, 312868, 2, 2),
  42. (41, 314197, 2, 2),
  43. (42, 318172, 2, 2),
  44. (43, 356669, 2, 2),
  45. (44, 362727, 2, 2),
  46. (45, 367913, 2, 2),
  47. (46, 367918, 2, 2),
  48. (47, 175546, 2, 2),
  49. (48, 178119, 2, 2),
  50. (49, 195231, 2, 2),
  51. (50, 209960, 2, 2),
  52. (51, 215285, 2, 2),
  53. (52, 218253, 2, 2),
  54. (53, 227851, 2, 2),
  55. (54, 228599, 2, 2),
  56. (55, 234551, 2, 2),
  57. (56, 238112, 2, 2),
  58. (57, 251352, 2, 2),
  59. (58, 289195, 2, 2),
  60. (59, 303394, 2, 2),
  61. (60, 308082, 2, 2),
  62. (61, 319311, 2, 2),
  63. (62, 329092, 2, 2),
  64. (63, 336722, 2, 2),
  65. (64, 350124, 2, 2),
  66. (65, 350129, 2, 2),
  67. (66, 356731, 2, 2),
  68. (67, 371042, 2, 2),
  69. (68, 371044, 2, 2),
  70. (69, 379264, 2, 2),
  71. (70, 179038, 3, 2),
  72. (71, 181406, 3, 2),
  73. (72, 184320, 3, 2),
  74. (73, 190962, 3, 2),
  75. (74, 207809, 3, 2),
  76. (75, 208016, 3, 2),
  77. (76, 217172, 3, 2),
  78. (77, 218284, 3, 2),
  79. (78, 218306, 3, 2),
  80. (79, 233952, 3, 2),
  81. (80, 239424, 3, 2),
  82. (81, 271043, 3, 2),
  83. (82, 289964, 3, 2),
  84. (83, 298613, 3, 2),
  85. (84, 298959, 3, 2),
  86. (85, 309426, 3, 2),
  87. (86, 312868, 3, 2),
  88. (87, 314197, 3, 2),
  89. (88, 318172, 3, 2),
  90. (89, 356669, 3, 2),
  91. (90, 362727, 3, 2),
  92. (91, 367913, 3, 2),
  93. (92, 367918, 3, 2),
  94. (93, 175546, 3, 2),
  95. (94, 178119, 3, 2),
  96. (95, 195231, 3, 2),
  97. (96, 209960, 3, 2),
  98. (97, 215285, 3, 2),
  99. (98, 218253, 3, 2),
  100. (99, 227851, 3, 2),
  101. (100, 228599, 3, 2),
  102. (101, 234551, 3, 2),
  103. (102, 238112, 3, 2),
  104. (103, 251352, 3, 2),
  105. (104, 289195, 3, 2),
  106. (105, 303394, 3, 2),
  107. (106, 308082, 3, 2),
  108. (107, 319311, 3, 2),
  109. (108, 329092, 3, 2),
  110. (109, 336722, 3, 2),
  111. (110, 350124, 3, 2),
  112. (111, 350129, 3, 2),
  113. (112, 356731, 3, 2),
  114. (113, 371042, 3, 2),
  115. (114, 371044, 3, 2),
  116. (115, 379264, 3, 2),
  117. (116, 175413, 3, 2),
  118. (117, 176644, 3, 2),
  119. (118, 177855, 3, 2),
  120. (119, 183857, 3, 2),
  121. (120, 183864, 3, 2),
  122. (121, 200176, 3, 2),
  123. (122, 200179, 3, 2),
  124. (123, 207528, 3, 2),
  125. (124, 207906, 3, 2),
  126. (125, 216814, 3, 2),
  127. (126, 216820, 3, 2),
  128. (127, 216973, 3, 2),
  129. (128, 229884, 3, 2),
  130. (129, 267811, 3, 2),
  131. (130, 269859, 3, 2),
  132. (131, 270714, 3, 2),
  133. (132, 270948, 3, 2),
  134. (133, 297705, 3, 2),
  135. (134, 303034, 3, 2),
  136. (135, 306954, 3, 2),
  137. (136, 313410, 3, 2),
  138. (137, 318601, 3, 2),
  139. (138, 367920, 3, 2);
  140.  
  141.  
  142. INSERT INTO `squads` (`id`, `user_id`, `transfer_period_id`, `formation`, `captain_id`, `vice_captain_id`, `is_triple_captain`, `created_at`, `updated_at`) VALUES
  143. (1, 2, 2, '442', 1, 1, 0),
  144. (2, 3, 2, '532', 1, 1, 0),
  145. (3, 4, 2, '442', 1, 1, 0),
  146. (4, 5, 2, '532', 1, 1, 0),
  147. (5, 6, 2, '442', 1, 1, 0),
  148. (6, 7, 2, '541', 1, 1, 0),
  149. (7, 8, 2, '541', 1, 1, 0),
  150. (8, 9, 2, '442', 1, 1, 0),
  151. (9, 10, 2, '541', 1, 1, 0),
  152. (10, 11, 2, '442', 1, 1, 0);
  153.  
  154.  
  155. INSERT INTO `squad_players` (`id`, `squad_id`, `user_id`, `player_id`, `position`, `priority`) VALUES
  156. (1, 1, 2, 159304, 'goalkeeper', 0),
  157. (2, 1, 2, 184856, 'goalkeeper', 1),
  158. (3, 1, 2, 213878, 'defender', 2),
  159. (4, 1, 2, 375754, 'defender', 3),
  160. (5, 1, 2, 218284, 'defender', 4),
  161. (7, 1, 2, 297230, 'defender', 6),
  162. (11, 1, 2, 357991, 'midfielder', 10),
  163. (12, 1, 2, 290824, 'midfielder', 11),
  164. (13, 1, 2, 233500, 'forward', 12),
  165. (14, 1, 2, 177927, 'forward', 13),
  166. (15, 1, 2, 296994, 'forward', 14),
  167. (17, 2, 3, 303419, 'goalkeeper', 1),
  168. (18, 2, 3, 254141, 'defender', 2),
  169. (19, 2, 3, 336085, 'defender', 3),
  170. (20, 2, 3, 236533, 'defender', 4),
  171. (21, 2, 3, 317072, 'defender', 5),
  172. (23, 2, 3, 200935, 'midfielder', 7),
  173. (24, 2, 3, 234463, 'midfielder', 8),
  174. (25, 2, 3, 312868, 'midfielder', 9),
  175. (27, 2, 3, 366573, 'midfielder', 11),
  176. (28, 2, 3, 216970, 'forward', 12),
  177. (30, 2, 3, 369990, 'forward', 14),
  178. (31, 3, 4, 184856, 'goalkeeper', 0),
  179. (32, 3, 4, 367558, 'goalkeeper', 1),
  180. (35, 3, 4, 306410, 'defender', 4),
  181. (36, 3, 4, 289964, 'defender', 5),
  182. (38, 3, 4, 296273, 'midfielder', 7),
  183. (39, 3, 4, 177768, 'midfielder', 8),
  184. (40, 3, 4, 330689, 'midfielder', 9),
  185. (41, 3, 4, 316997, 'midfielder', 10),
  186. (42, 3, 4, 234463, 'midfielder', 11),
  187. (43, 3, 4, 364763, 'forward', 12),
  188. (44, 3, 4, 373400, 'forward', 13),
  189. (46, 4, 5, 303419, 'goalkeeper', 0),
  190. (47, 4, 5, 253999, 'goalkeeper', 1),
  191. (48, 4, 5, 296303, 'defender', 2),
  192. (51, 4, 5, 276132, 'defender', 5),
  193. (52, 4, 5, 210702, 'defender', 6),
  194. (53, 4, 5, 215623, 'midfielder', 7),
  195. (55, 4, 5, 291329, 'midfielder', 9),
  196. (57, 4, 5, 183000, 'midfielder', 11),
  197. (58, 4, 5, 216435, 'forward', 12),
  198. (59, 4, 5, 180936, 'forward', 13),
  199. (60, 4, 5, 187258, 'forward', 14),
  200. (61, 5, 6, 299066, 'goalkeeper', 0),
  201. (62, 5, 6, 214581, 'goalkeeper', 1),
  202. (63, 5, 6, 356162, 'defender', 2),
  203. (64, 5, 6, 306364, 'defender', 3),
  204. (66, 5, 6, 178119, 'defender', 5),
  205. (67, 5, 6, 375754, 'defender', 6),
  206. (70, 5, 6, 270400, 'midfielder', 9),
  207. (72, 5, 6, 379995, 'midfielder', 11),
  208. (73, 5, 6, 373224, 'forward', 12),
  209. (74, 5, 6, 347716, 'forward', 13),
  210. (75, 5, 6, 201787, 'forward', 14),
  211. (76, 6, 7, 323574, 'goalkeeper', 0),
  212. (77, 6, 7, 178958, 'goalkeeper', 1),
  213. (79, 6, 7, 358046, 'defender', 3),
  214. (80, 6, 7, 370469, 'defender', 4),
  215. (81, 6, 7, 215274, 'defender', 5),
  216. (82, 6, 7, 311174, 'defender', 6),
  217. (83, 6, 7, 300402, 'midfielder', 7),
  218. (84, 6, 7, 367918, 'midfielder', 8),
  219. (85, 6, 7, 266800, 'midfielder', 9),
  220. (88, 6, 7, 359235, 'forward', 12),
  221. (89, 6, 7, 312316, 'forward', 13),
  222. (91, 7, 8, 189300, 'goalkeeper', 0),
  223. (92, 7, 8, 356676, 'goalkeeper', 1),
  224. (93, 7, 8, 228617, 'defender', 2),
  225. (94, 7, 8, 319432, 'defender', 3),
  226. (95, 7, 8, 213878, 'defender', 4),
  227. (99, 7, 8, 376349, 'midfielder', 8),
  228. (101, 7, 8, 358732, 'midfielder', 10),
  229. (102, 7, 8, 216650, 'midfielder', 11),
  230. (103, 7, 8, 373224, 'forward', 12),
  231. (104, 7, 8, 309316, 'forward', 13),
  232. (105, 7, 8, 356399, 'forward', 14),
  233. (106, 8, 9, 298655, 'goalkeeper', 0),
  234. (107, 8, 9, 176644, 'goalkeeper', 1),
  235. (108, 8, 9, 228936, 'defender', 2),
  236. (109, 8, 9, 238381, 'defender', 3),
  237. (110, 8, 9, 209940, 'defender', 4),
  238. (111, 8, 9, 319340, 'defender', 5),
  239. (112, 8, 9, 207946, 'defender', 6),
  240. (115, 8, 9, 196752, 'midfielder', 9),
  241. (116, 8, 9, 299198, 'midfielder', 10),
  242. (119, 8, 9, 356399, 'forward', 13),
  243. (120, 8, 9, 358048, 'forward', 14),
  244. (121, 9, 10, 356933, 'goalkeeper', 0),
  245. (122, 9, 10, 178630, 'goalkeeper', 1),
  246. (123, 9, 10, 176971, 'defender', 2),
  247. (124, 9, 10, 229443, 'defender', 3),
  248. (126, 9, 10, 271043, 'defender', 5),
  249. (127, 9, 10, 356518, 'defender', 6),
  250. (128, 9, 10, 332827, 'midfielder', 7),
  251. (130, 9, 10, 214571, 'midfielder', 9),
  252. (132, 9, 10, 184447, 'midfielder', 11),
  253. (134, 9, 10, 306206, 'forward', 13),
  254. (135, 9, 10, 201787, 'forward', 14),
  255. (136, 10, 11, 298655, 'goalkeeper', 0),
  256. (137, 10, 11, 215017, 'goalkeeper', 1),
  257. (138, 10, 11, 269784, 'defender', 2),
  258. (139, 10, 11, 311148, 'defender', 3),
  259. (140, 10, 11, 305768, 'defender', 4),
  260. (141, 10, 11, 367557, 'defender', 5),
  261. (142, 10, 11, 305764, 'defender', 6),
  262. (143, 10, 11, 361222, 'midfielder', 7),
  263. (148, 10, 11, 311554, 'forward', 12),
  264. (149, 10, 11, 214228, 'forward', 13),
  265. (150, 10, 11, 233500, 'forward', 14),
  266. (151, 8, 9, 290821, 'midfielder', 7),
  267. (152, 8, 9, 233530, 'midfielder', 8),
  268. (153, 8, 9, 305378, 'midfielder', 11),
  269. (154, 8, 9, 267834, 'forward', 12),
  270. (155, 5, 6, 291332, 'defender', 4),
  271. (156, 5, 6, 216964, 'midfielder', 7),
  272. (157, 5, 6, 329737, 'midfielder', 8),
  273. (158, 5, 6, 367555, 'midfielder', 10),
  274. (159, 1, 2, 379985, 'defender', 5),
  275. (160, 1, 2, 280487, 'midfielder', 7),
  276. (161, 1, 2, 233530, 'midfielder', 8),
  277. (162, 1, 2, 319311, 'midfielder', 9),
  278. (163, 3, 4, 306634, 'defender', 2),
  279. (164, 3, 4, 289195, 'defender', 3),
  280. (165, 3, 4, 306954, 'defender', 6),
  281. (166, 3, 4, 180936, 'forward', 14),
  282. (167, 7, 8, 312432, 'defender', 5),
  283. (168, 7, 8, 358022, 'defender', 6),
  284. (169, 7, 8, 362727, 'midfielder', 7),
  285. (170, 7, 8, 329092, 'midfielder', 9),
  286. (171, 2, 3, 380009, 'goalkeeper', 0),
  287. (172, 2, 3, 288824, 'defender', 6),
  288. (173, 2, 3, 379910, 'midfielder', 10),
  289. (174, 2, 3, 201200, 'forward', 13),
  290. (175, 6, 7, 184373, 'defender', 2),
  291. (176, 6, 7, 304934, 'midfielder', 10),
  292. (177, 6, 7, 305036, 'midfielder', 11),
  293. (178, 6, 7, 356399, 'forward', 14),
  294. (179, 9, 10, 186793, 'defender', 4),
  295. (180, 9, 10, 185359, 'midfielder', 8),
  296. (181, 9, 10, 197409, 'midfielder', 10),
  297. (182, 9, 10, 270144, 'forward', 12),
  298. (183, 4, 5, 290864, 'defender', 3),
  299. (184, 4, 5, 286481, 'defender', 4),
  300. (185, 4, 5, 299086, 'midfielder', 8),
  301. (186, 4, 5, 298676, 'midfielder', 10),
  302. (187, 10, 11, 358099, 'midfielder', 8),
  303. (188, 10, 11, 175524, 'midfielder', 9),
  304. (189, 10, 11, 358891, 'midfielder', 10),
  305. (190, 10, 11, 202544, 'midfielder', 11);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top