Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.49 KB | None | 0 0
  1. SELECT ex.ex, ex.lv, ex.tt, ex.td, dn2.ex AS trex, dn2.dn, dn2.mn, ap.ap, ap.ui, ap.uq
  2. FROM ex
  3. INNER JOIN lv ON (lv.lv = ex.lv)
  4. INNER JOIN dn ON (dn.ex = ex.ex)
  5. INNER JOIN dn AS dn2 ON (dn2.mn = dn.mn)
  6. INNER JOIN mn ON (mn.mn = dn2.mn)
  7. INNER JOIN ap ON (ap.ap = mn.ap)
  8. WHERE
  9. lcvc(lv.lc, lv.vc) IN ('eng-000') AND
  10. dn.ex != dn2.ex AND
  11. dn2.ex IN (74)
  12. ORDER BY ex.ex, ap.ui, ap.uq
  13. LIMIT 2000;
  14.  
  15. ex | lv | tt | td | trex | dn | mn | ap | ui | uq
  16. ----------+-----+-------------+-------------+------+----------+----------+------+------+----
  17. 8263 | 187 | Chachi | chachi | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
  18. 13355 | 187 | good | good | 74 | 119 | 4 | 1 | 1 | 8
  19. 13355 | 187 | good | good | 74 | 29882 | 17521 | 6 | 6 | 9
  20. 13355 | 187 | good | good | 74 | 512340 | 89539 | 9 | 9 | 4
  21. 13355 | 187 | good | good | 74 | 512344 | 89540 | 9 | 9 | 4
  22. 13355 | 187 | good | good | 74 | 845082 | 126222 | 12 | 12 | 2
  23. 13355 | 187 | good | good | 74 | 961652 | 31705 | 15 | 15 | 2
  24. 13355 | 187 | good | good | 74 | 1042368 | 149610 | 19 | 19 | 2
  25. 13355 | 187 | good | good | 74 | 19923694 | 6888546 | 494 | 494 | 5
  26. 13355 | 187 | good | good | 74 | 49298500 | 19684612 | 787 | 787 | 4
  27. 13355 | 187 | good | good | 74 | 49298605 | 19684632 | 787 | 787 | 4
  28. 13355 | 187 | good | good | 74 | 33113758 | 12737839 | 1006 | 1006 | 5
  29. 13355 | 187 | good | good | 74 | 31225676 | 11906885 | 1445 | 1445 | 2
  30. 13355 | 187 | good | good | 74 | 32077939 | 12330230 | 1505 | 1505 | 3
  31. 13355 | 187 | good | good | 74 | 32315916 | 12352064 | 1505 | 1505 | 3
  32. 13355 | 187 | good | good | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
  33. 13355 | 187 | good | good | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  34. 13355 | 187 | good | good | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
  35. 13355 | 187 | good | good | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
  36. 13355 | 187 | good | good | 74 | 32082963 | 12330706 | 1505 | 1505 | 3
  37. 13355 | 187 | good | good | 74 | 50331015 | 19869714 | 1573 | 1573 | 3
  38. 13355 | 187 | good | good | 74 | 49479082 | 19702128 | 2409 | 2409 | 5
  39. 13355 | 187 | good | good | 74 | 51745418 | 20272484 | 3937 | 3937 | 5
  40. 350758 | 187 | bang-up | bangup | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
  41. 353197 | 187 | beautiful | beautiful | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  42. 353197 | 187 | beautiful | beautiful | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
  43. 354822 | 187 | benevolent | benevolent | 74 | 49298605 | 19684632 | 787 | 787 | 4
  44. 359957 | 187 | bond | bond | 74 | 7463261 | 2148231 | 80 | 80 | 5
  45. 359957 | 187 | bond | bond | 74 | 19898348 | 6875873 | 494 | 494 | 5
  46. 359957 | 187 | bond | bond | 74 | 31203606 | 11895850 | 1445 | 1445 | 2
  47. 370665 | 187 | certain | certain | 74 | 32082963 | 12330706 | 1505 | 1505 | 3
  48. 382807 | 187 | corking | corking | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
  49. 384018 | 187 | coupon | coupon | 74 | 31211404 | 11899749 | 1445 | 1445 | 2
  50. 389816 | 187 | decent | decent | 74 | 31212928 | 11900511 | 1445 | 1445 | 2
  51. 391183 | 187 | delicious | delicious | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
  52. 404330 | 187 | elegant | elegant | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  53. 411400 | 187 | fair | fair | 74 | 31221088 | 11904591 | 1445 | 1445 | 2
  54. 414514 | 187 | fine | fine | 74 | 845082 | 126222 | 12 | 12 | 2
  55. 414514 | 187 | fine | fine | 74 | 859926 | 126649 | 12 | 12 | 2
  56. 414514 | 187 | fine | fine | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
  57. 415001 | 187 | first-class | firstclass | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
  58. 417720 | 187 | foppish | foppish | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
  59. 420241 | 187 | friendly | friendly | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  60. 433728 | 187 | healthy | healthy | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
  61. 457790 | 187 | kind | kind | 74 | 31234160 | 11911127 | 1445 | 1445 | 2
  62. 457790 | 187 | kind | kind | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
  63. 488876 | 187 | neat | neat | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  64. 490714 | 187 | nice | nice | 74 | 276733 | 49708 | 8 | 8 | 7
  65. 490714 | 187 | nice | nice | 74 | 845082 | 126222 | 12 | 12 | 2
  66. 490714 | 187 | nice | nice | 74 | 19944236 | 6898817 | 494 | 494 | 5
  67. 490714 | 187 | nice | nice | 74 | 33113760 | 12737840 | 1006 | 1006 | 5
  68. 490714 | 187 | nice | nice | 74 | 31242858 | 11915476 | 1445 | 1445 | 2
  69. 490714 | 187 | nice | nice | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
  70. 490714 | 187 | nice | nice | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
  71. 490714 | 187 | nice | nice | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
  72. 490714 | 187 | nice | nice | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  73. 497084 | 187 | okay | okay | 74 | 845082 | 126222 | 12 | 12 | 2
  74. 497084 | 187 | okay | okay | 74 | 859926 | 126649 | 12 | 12 | 2
  75. 497084 | 187 | okay | okay | 74 | 19945542 | 6899470 | 494 | 494 | 5
  76. 497084 | 187 | okay | okay | 74 | 33113762 | 12737841 | 1006 | 1006 | 5
  77. 507964 | 187 | phenomenal | phenomenal | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
  78. 515046 | 187 | pretty | pretty | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  79. 515046 | 187 | pretty | pretty | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
  80. 529281 | 187 | right | right | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
  81. 548752 | 187 | sound | sound | 74 | 49298500 | 19684612 | 787 | 787 | 4
  82. 558034 | 187 | superb | superb | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
  83. 559377 | 187 | sweet | sweet | 74 | 32188047 | 12340386 | 1505 | 1505 | 3
  84. 559947 | 187 | sympathetic | sympathetic | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
  85. 562517 | 187 | tasty | tasty | 74 | 32188047 | 12340386 | 1505 | 1505 | 3
  86. 562517 | 187 | tasty | tasty | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
  87. 562517 | 187 | tasty | tasty | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
  88. 613429 | 187 | voucher | voucher | 74 | 31278572 | 11933333 | 1445 | 1445 | 2
  89. 616917 | 187 | well | well | 74 | 32077939 | 12330230 | 1505 | 1505 | 3
  90. 616917 | 187 | well | well | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
  91. 1690908 | 187 | OK | ok | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
  92. 19285759 | 187 | whizzy | whizzy | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement