API tools faq
paste
Advertisement
Rochet2

Untitled

Rochet2
Feb 24th, 2018
364
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 11.51 KB | None | 0 0
raw download clone embed print report
  1. select distinct itemid, GROUP_CONCAT(modid) as appearancemodid from db_itemmodifiedappearance_25632 group by itemid order by itemid ASC
  2.  
  3. "itemid"    "appearancemodid"
  4. "112935"    "1,3"
  5. "113115"    "5"
  6. "114230"    "6,7,8"
  7. "114231"    "6,7,8"
  8. "114232"    "6,7,8"
  9. "114233"    "6,7,8"
  10. "114234"    "6,7,8"
  11. "114235"    "6,7,8"
  12. "114236"    "6,7,8"
  13. "114237"    "6,7,8"
  14. "114809"    "6,7,8"
  15. "114810"    "6,7,8"
  16. "114811"    "6,7,8"
  17. "114812"    "6,7,8"
  18. "114813"    "6,7,8"
  19. "114814"    "6,7,8"
  20. "114815"    "6,7,8"
  21. "114816"    "6,7,8"
  22. "114817"    "6,7,8"
  23. "114818"    "6,7,8"
  24. "114819"    "6,7,8"
  25. "115794"    "6,7,8"
  26. "115796"    "6,7,8"
  27. "115798"    "6,7,8"
  28. "115799"    "6,7,8"
  29. "115800"    "6,7,8"
  30. "115801"    "6,7,8"
  31. "115996"    "4"
  32. "115997"    "4"
  33. "115998"    "4"
  34. "115999"    "4"
  35. "116000"    "4"
  36. "116001"    "4"
  37. "116002"    "4"
  38. "116003"    "4"
  39. "116004"    "4"
  40. "116005"    "4"
  41. "116006"    "4"
  42. "116007"    "4"
  43. "116008"    "4"
  44. "116009"    "4"
  45. "116010"    "4"
  46. "116011"    "4"
  47. "116012"    "4"
  48. "116013"    "4"
  49. "116014"    "4"
  50. "116015"    "4"
  51. "116016"    "4"
  52. "116017"    "4"
  53. "116018"    "4"
  54. "116019"    "4"
  55. "116021"    "4"
  56. "116022"    "4"
  57. "116025"    "4"
  58. "116026"    "4"
  59. "116027"    "4"
  60. "116028"    "4"
  61. "116029"    "4"
  62. "116030"    "4"
  63. "116032"    "4"
  64. "116033"    "4"
  65. "116034"    "4"
  66. "116035"    "4"
  67. "116036"    "4"
  68. "116037"    "4"
  69. "116038"    "4"
  70. "116039"    "4"
  71. "116040"    "4"
  72. "116041"    "4"
  73. "116042"    "4"
  74. "116044"    "4"
  75. "116045"    "4"
  76. "116046"    "4"
  77. "116047"    "4"
  78. "116048"    "4"
  79. "116049"    "4"
  80. "116050"    "4"
  81. "116051"    "4"
  82. "116171"    "6,7,8"
  83. "116174"    "6,7,8"
  84. "116175"    "6,7,8"
  85. "116176"    "6,7,8"
  86. "116177"    "6,7,8"
  87. "116178"    "6,7,8"
  88. "116179"    "6,7,8"
  89. "116180"    "6,7,8"
  90. "116181"    "6,7,8"
  91. "116182"    "6,7,8"
  92. "116183"    "6,7,8"
  93. "116187"    "6,7,8"
  94. "116188"    "6,7,8"
  95. "116189"    "6,7,8"
  96. "116190"    "6,7,8"
  97. "116191"    "6,7,8"
  98. "116192"    "6,7,8"
  99. "116193"    "6,7,8"
  100. "116194"    "6,7,8"
  101. "116205"    "4"
  102. "116206"    "4"
  103. "116208"    "4"
  104. "116209"    "4"
  105. "116210"    "4"
  106. "116211"    "4"
  107. "116212"    "4"
  108. "116213"    "4"
  109. "116214"    "4"
  110. "116215"    "4"
  111. "116216"    "4"
  112. "116217"    "4"
  113. "116218"    "4"
  114. "116219"    "4"
  115. "116220"    "4"
  116. "116222"    "4"
  117. "116223"    "4"
  118. "116224"    "4"
  119. "116225"    "4"
  120. "116226"    "4"
  121. "116227"    "4"
  122. "116228"    "4"
  123. "116229"    "4"
  124. "116230"    "4"
  125. "116231"    "4"
  126. "116233"    "4"
  127. "116234"    "4"
  128. "116235"    "4"
  129. "116236"    "4"
  130. "116237"    "4"
  131. "116238"    "4"
  132. "116239"    "4"
  133. "116240"    "4"
  134. "116241"    "4"
  135. "116242"    "4"
  136. "116243"    "4"
  137. "116244"    "4"
  138. "116245"    "4"
  139. "116250"    "4"
  140. "116251"    "4"
  141. "116252"    "4"
  142. "116253"    "4"
  143. "116254"    "4"
  144. "116255"    "4"
  145. "116256"    "4"
  146. "116257"    "4"
  147. "116262"    "4"
  148. "116263"    "4"
  149. "116264"    "4"
  150. "116265"    "4"
  151. "116294"    "4"
  152. "116295"    "4"
  153. "116296"    "4"
  154. "116297"    "4"
  155. "116298"    "4"
  156. "116304"    "4"
  157. "116305"    "4"
  158. "116306"    "4"
  159. "116307"    "4"
  160. "116308"    "4"
  161. "116360"    "4"
  162. "116361"    "4"
  163. "116362"    "4"
  164. "116363"    "4"
  165. "116364"    "4"
  166. "116365"    "4"
  167. "116366"    "4"
  168. "116367"    "4"
  169. "116368"    "4"
  170. "116372"    "4"
  171. "116373"    "4"
  172. "116379"    "4"
  173. "116380"    "4"
  174. "116381"    "4"
  175. "116382"    "4"
  176. "116384"    "4"
  177. "116385"    "4"
  178. "116386"    "4"
  179. "116387"    "4"
  180. "116388"    "4"
  181. "116389"    "4"
  182. "116390"    "4"
  183. "116391"    "4"
  184. "116393"    "4"
  185. "116453"    "6,7,8"
  186. "116454"    "6,7,8"
  187. "116644"    "6,7,8"
  188. "116646"    "6,7,8"
  189. "116647"    "6,7,8"
  190. "120259"    "6,7,8"
  191. "120261"    "6,7,8"
  192. "120373"    "4"
  193. "120374"    "4"
  194. "120375"    "4"
  195. "120376"    "4"
  196. "120377"    "4"
  197. "120378"    "4"
  198. "120379"    "4"
  199. "120380"    "4"
  200. "120381"    "4"
  201. "120382"    "4"
  202. "120383"    "4"
  203. "120384"    "4"
  204. "120385"    "4"
  205. "120386"    "4"
  206. "120387"    "4"
  207. "120388"    "4"
  208. "120389"    "4"
  209. "120390"    "4"
  210. "120391"    "4"
  211. "120392"    "4"
  212. "120393"    "4"
  213. "120394"    "4"
  214. "120395"    "4"
  215. "120396"    "4"
  216. "120978"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  217. "123891"    "6"
  218. "123892"    "6"
  219. "123893"    "6"
  220. "123894"    "6"
  221. "123895"    "6"
  222. "123896"    "6"
  223. "123897"    "6"
  224. "123898"    "6"
  225. "123910"    "6"
  226. "123911"    "6"
  227. "123912"    "6"
  228. "123913"    "6"
  229. "123914"    "6"
  230. "123915"    "6"
  231. "123916"    "6"
  232. "123917"    "6"
  233. "126987"    "6"
  234. "126988"    "6"
  235. "126989"    "6"
  236. "126990"    "6"
  237. "126991"    "6"
  238. "126992"    "6"
  239. "126993"    "6"
  240. "126994"    "6"
  241. "126995"    "6"
  242. "126996"    "6"
  243. "126997"    "6"
  244. "126998"    "6"
  245. "126999"    "6"
  246. "127000"    "6"
  247. "127001"    "6"
  248. "127002"    "6"
  249. "127013"    "6,7,8"
  250. "127016"    "6"
  251. "127017"    "6"
  252. "127018"    "6,7,8"
  253. "127019"    "6"
  254. "127020"    "6"
  255. "127031"    "6"
  256. "127032"    "6"
  257. "127033"    "6"
  258. "127034"    "6"
  259. "127829"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  260. "127830"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  261. "127857"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  262. "127971"    "1"
  263. "127972"    "1"
  264. "127973"    "1"
  265. "127974"    "1"
  266. "127975"    "1"
  267. "127981"    "1"
  268. "127982"    "1"
  269. "127983"    "1"
  270. "127984"    "1"
  271. "128028"    "4"
  272. "128029"    "4"
  273. "128030"    "4"
  274. "128031"    "4"
  275. "128032"    "4"
  276. "128033"    "4"
  277. "128034"    "4"
  278. "128035"    "4"
  279. "128036"    "4"
  280. "128037"    "4"
  281. "128038"    "4"
  282. "128039"    "4"
  283. "128040"    "4"
  284. "128041"    "4"
  285. "128042"    "4"
  286. "128043"    "4"
  287. "128044"    "4"
  288. "128045"    "4"
  289. "128046"    "4"
  290. "128047"    "4"
  291. "128048"    "4"
  292. "128049"    "4"
  293. "128050"    "4"
  294. "128051"    "4"
  295. "128052"    "4"
  296. "128053"    "4"
  297. "128054"    "4"
  298. "128055"    "4"
  299. "128056"    "4"
  300. "128057"    "4"
  301. "128058"    "4"
  302. "128059"    "4"
  303. "128060"    "4"
  304. "128061"    "4"
  305. "128062"    "4"
  306. "128063"    "4"
  307. "128064"    "4"
  308. "128065"    "4"
  309. "128066"    "4"
  310. "128067"    "4"
  311. "128068"    "4"
  312. "128069"    "4"
  313. "128070"    "4"
  314. "128071"    "4"
  315. "128072"    "4"
  316. "128073"    "4"
  317. "128074"    "4"
  318. "128075"    "4"
  319. "128076"    "4"
  320. "128077"    "4"
  321. "128078"    "4"
  322. "128079"    "4"
  323. "128080"    "4"
  324. "128081"    "4"
  325. "128082"    "4"
  326. "128083"    "4"
  327. "128084"    "4"
  328. "128085"    "4"
  329. "128086"    "4"
  330. "128087"    "4"
  331. "128088"    "4"
  332. "128089"    "4"
  333. "128090"    "4"
  334. "128091"    "4"
  335. "128092"    "4"
  336. "128093"    "4"
  337. "128094"    "4"
  338. "128095"    "4"
  339. "128096"    "4"
  340. "128097"    "4"
  341. "128098"    "4"
  342. "128099"    "4"
  343. "128100"    "4"
  344. "128101"    "4"
  345. "128102"    "4"
  346. "128103"    "4"
  347. "128104"    "4"
  348. "128105"    "4"
  349. "128106"    "4"
  350. "128112"    "4"
  351. "128118"    "4"
  352. "128119"    "4"
  353. "128120"    "4"
  354. "128121"    "4"
  355. "128122"    "4"
  356. "128123"    "4"
  357. "128124"    "4"
  358. "128125"    "4"
  359. "128126"    "4"
  360. "128127"    "4"
  361. "128128"    "4"
  362. "128129"    "4"
  363. "128130"    "4"
  364. "128131"    "4"
  365. "128132"    "4"
  366. "128133"    "4"
  367. "128134"    "4"
  368. "128135"    "4"
  369. "128136"    "4"
  370. "128137"    "4"
  371. "128138"    "4"
  372. "128139"    "4"
  373. "128167"    "4"
  374. "128168"    "4"
  375. "128170"    "4"
  376. "128171"    "4"
  377. "128174"    "4"
  378. "128175"    "4"
  379. "128176"    "4"
  380. "128177"    "4"
  381. "128186"    "4"
  382. "128187"    "4"
  383. "128188"    "4"
  384. "128189"    "4"
  385. "128190"    "4"
  386. "128191"    "4"
  387. "128192"    "4"
  388. "128193"    "4"
  389. "128194"    "4"
  390. "128195"    "4"
  391. "128196"    "4"
  392. "128197"    "4"
  393. "128198"    "4"
  394. "128199"    "4"
  395. "128200"    "4"
  396. "128201"    "4"
  397. "128202"    "4"
  398. "128288"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  399. "128289"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  400. "128292"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  401. "128293"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  402. "128295"    "4"
  403. "128298"    "4"
  404. "128299"    "4"
  405. "128300"    "4"
  406. "128306"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  407. "128403"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  408. "128476"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  409. "128479"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  410. "128808"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  411. "128819"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  412. "128820"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  413. "128821"    "9,10,11,12"
  414. "128822"    "9,10,11,12"
  415. "128823"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  416. "128824"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  417. "128825"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  418. "128826"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  419. "128827"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  420. "128831"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  421. "128832"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  422. "128858"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  423. "128859"    "9,10,11,12"
  424. "128860"    "9,10,11,12"
  425. "128861"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  426. "128862"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  427. "128866"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  428. "128867"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  429. "128868"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  430. "128869"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  431. "128870"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  432. "128872"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  433. "128873"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  434. "128876"    "6"
  435. "128877"    "6"
  436. "128878"    "6"
  437. "128879"    "6"
  438. "128880"    "6"
  439. "128881"    "6"
  440. "128882"    "6"
  441. "128883"    "6"
  442. "128884"    "6"
  443. "128885"    "6"
  444. "128886"    "6"
  445. "128887"    "6"
  446. "128888"    "6"
  447. "128889"    "6"
  448. "128890"    "6"
  449. "128891"    "6"
  450. "128892"    "6"
  451. "128893"    "6"
  452. "128894"    "6"
  453. "128895"    "6"
  454. "128896"    "6"
  455. "128897"    "6"
  456. "128898"    "6"
  457. "128899"    "6"
  458. "128900"    "6"
  459. "128901"    "6"
  460. "128902"    "6"
  461. "128903"    "6"
  462. "128904"    "6"
  463. "128905"    "6"
  464. "128906"    "6"
  465. "128907"    "6"
  466. "128908"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  467. "128911"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  468. "128934"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  469. "128935"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  470. "128937"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  471. "128938"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  472. "128940"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  473. "128941"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  474. "128942"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  475. "129736"    "17"
  476. "129737"    "21"
  477. "129738"    "25"
  478. "129752"    "13"
  479. "129753"    "17"
  480. "129754"    "21"
  481. "129755"    "25"
  482. "131738"    "13"
  483. "131739"    "17"
  484. "131741"    "22"
  485. "131742"    "18"
  486. "132474"    "9"
  487. "132475"    "9"
  488. "132476"    "9"
  489. "132477"    "9"
  490. "132478"    "9"
  491. "132479"    "13"
  492. "132480"    "13"
  493. "132481"    "13"
  494. "132482"    "13"
  495. "132483"    "13"
  496. "132500"    "6"
  497. "132501"    "6"
  498. "132502"    "6"
  499. "132503"    "6"
  500. "132504"    "6"
  501. "132505"    "6"
  502. "132506"    "6"
  503. "132507"    "6"
  504. "133755"    "9,10,11"
  505. "133948"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  506. "133958"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  507. "133959"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  508. "133963"    "21"
  509. "133964"    "21"
  510. "133965"    "21"
  511. "133966"    "21"
  512. "133967"    "21"
  513. "134552"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  514. "134553"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  515. "134562"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28"
  516. "135582"    "10"
  517. "136593"    "9"
  518. "137246"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"
  519. "137581"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28"
  520. "137582"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28"
  521. "137660"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28"
  522. "137661"    "9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28"
  523. "138191"    "3"
  524. "140211"    "21"
  525. "141006"    "1,3"
  526. "144331"    "6"
  527. "144332"    "6"
  528. "144333"    "6"
  529. "144334"    "6"
  530. "144388"    "3"
  531. "144389"    "3"
  532. "147618"    "7"
  533. "151172"    "1"
  534. "151571"    "6"
  535. "151576"    "6"
  536. "151577"    "6"
  537. "151578"    "6"
  538. "151587"    "6"
  539. "151588"    "6"
  540. "151589"    "6"
  541. "151590"    "6"
  542. "151869"    "3"
  543. "151974"    "6,7"
  544. "153263"    "4"
  545. "153264"    "4"
  546. "153265"    "4"
  547. "153267"    "4"
  548. "153268"    "4"
  549. "153269"    "4"
  550. "153304"    "4"
  551. "153305"    "4"
  552. "153306"    "4"
  553. "153307"    "4"
  554. "153312"    "4"
  555. "153313"    "4"
  556. "153314"    "4"
  557. "153315"    "4"
  558. "153316"    "4"
  559. "153326"    "4"
  560. "153327"    "4"
  561. "153328"    "4"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!