Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ex.ex, ex.lv, ex.tt, ex.td, dn2.ex AS trex, dn2.dn, dn2.mn, ap.ap, ap.ui, ap.uq
- FROM ex
- INNER JOIN lv ON (lv.lv = ex.lv)
- INNER JOIN dn ON (dn.ex = ex.ex)
- INNER JOIN dn AS dn2 ON (dn2.mn = dn.mn)
- INNER JOIN mn ON (mn.mn = dn2.mn)
- INNER JOIN ap ON (ap.ap = mn.ap)
- WHERE
- lcvc(lv.lc, lv.vc) IN ('eng-000') AND
- dn.ex != dn2.ex AND
- dn2.ex IN (74)
- ORDER BY ex.ex, ap.ui, ap.uq
- LIMIT 2000;
- ex | lv | tt | td | trex | dn | mn | ap | ui | uq
- ----------+-----+-------------+-------------+------+----------+----------+------+------+----
- 8263 | 187 | Chachi | chachi | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
- 13355 | 187 | good | good | 74 | 119 | 4 | 1 | 1 | 8
- 13355 | 187 | good | good | 74 | 29882 | 17521 | 6 | 6 | 9
- 13355 | 187 | good | good | 74 | 512340 | 89539 | 9 | 9 | 4
- 13355 | 187 | good | good | 74 | 512344 | 89540 | 9 | 9 | 4
- 13355 | 187 | good | good | 74 | 845082 | 126222 | 12 | 12 | 2
- 13355 | 187 | good | good | 74 | 961652 | 31705 | 15 | 15 | 2
- 13355 | 187 | good | good | 74 | 1042368 | 149610 | 19 | 19 | 2
- 13355 | 187 | good | good | 74 | 19923694 | 6888546 | 494 | 494 | 5
- 13355 | 187 | good | good | 74 | 49298500 | 19684612 | 787 | 787 | 4
- 13355 | 187 | good | good | 74 | 49298605 | 19684632 | 787 | 787 | 4
- 13355 | 187 | good | good | 74 | 33113758 | 12737839 | 1006 | 1006 | 5
- 13355 | 187 | good | good | 74 | 31225676 | 11906885 | 1445 | 1445 | 2
- 13355 | 187 | good | good | 74 | 32077939 | 12330230 | 1505 | 1505 | 3
- 13355 | 187 | good | good | 74 | 32315916 | 12352064 | 1505 | 1505 | 3
- 13355 | 187 | good | good | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
- 13355 | 187 | good | good | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 13355 | 187 | good | good | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
- 13355 | 187 | good | good | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
- 13355 | 187 | good | good | 74 | 32082963 | 12330706 | 1505 | 1505 | 3
- 13355 | 187 | good | good | 74 | 50331015 | 19869714 | 1573 | 1573 | 3
- 13355 | 187 | good | good | 74 | 49479082 | 19702128 | 2409 | 2409 | 5
- 13355 | 187 | good | good | 74 | 51745418 | 20272484 | 3937 | 3937 | 5
- 350758 | 187 | bang-up | bangup | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
- 353197 | 187 | beautiful | beautiful | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 353197 | 187 | beautiful | beautiful | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
- 354822 | 187 | benevolent | benevolent | 74 | 49298605 | 19684632 | 787 | 787 | 4
- 359957 | 187 | bond | bond | 74 | 7463261 | 2148231 | 80 | 80 | 5
- 359957 | 187 | bond | bond | 74 | 19898348 | 6875873 | 494 | 494 | 5
- 359957 | 187 | bond | bond | 74 | 31203606 | 11895850 | 1445 | 1445 | 2
- 370665 | 187 | certain | certain | 74 | 32082963 | 12330706 | 1505 | 1505 | 3
- 382807 | 187 | corking | corking | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
- 384018 | 187 | coupon | coupon | 74 | 31211404 | 11899749 | 1445 | 1445 | 2
- 389816 | 187 | decent | decent | 74 | 31212928 | 11900511 | 1445 | 1445 | 2
- 391183 | 187 | delicious | delicious | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
- 404330 | 187 | elegant | elegant | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 411400 | 187 | fair | fair | 74 | 31221088 | 11904591 | 1445 | 1445 | 2
- 414514 | 187 | fine | fine | 74 | 845082 | 126222 | 12 | 12 | 2
- 414514 | 187 | fine | fine | 74 | 859926 | 126649 | 12 | 12 | 2
- 414514 | 187 | fine | fine | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
- 415001 | 187 | first-class | firstclass | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
- 417720 | 187 | foppish | foppish | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
- 420241 | 187 | friendly | friendly | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 433728 | 187 | healthy | healthy | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
- 457790 | 187 | kind | kind | 74 | 31234160 | 11911127 | 1445 | 1445 | 2
- 457790 | 187 | kind | kind | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
- 488876 | 187 | neat | neat | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 490714 | 187 | nice | nice | 74 | 276733 | 49708 | 8 | 8 | 7
- 490714 | 187 | nice | nice | 74 | 845082 | 126222 | 12 | 12 | 2
- 490714 | 187 | nice | nice | 74 | 19944236 | 6898817 | 494 | 494 | 5
- 490714 | 187 | nice | nice | 74 | 33113760 | 12737840 | 1006 | 1006 | 5
- 490714 | 187 | nice | nice | 74 | 31242858 | 11915476 | 1445 | 1445 | 2
- 490714 | 187 | nice | nice | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
- 490714 | 187 | nice | nice | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
- 490714 | 187 | nice | nice | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
- 490714 | 187 | nice | nice | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 497084 | 187 | okay | okay | 74 | 845082 | 126222 | 12 | 12 | 2
- 497084 | 187 | okay | okay | 74 | 859926 | 126649 | 12 | 12 | 2
- 497084 | 187 | okay | okay | 74 | 19945542 | 6899470 | 494 | 494 | 5
- 497084 | 187 | okay | okay | 74 | 33113762 | 12737841 | 1006 | 1006 | 5
- 507964 | 187 | phenomenal | phenomenal | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
- 515046 | 187 | pretty | pretty | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 515046 | 187 | pretty | pretty | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
- 529281 | 187 | right | right | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
- 548752 | 187 | sound | sound | 74 | 49298500 | 19684612 | 787 | 787 | 4
- 558034 | 187 | superb | superb | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
- 559377 | 187 | sweet | sweet | 74 | 32188047 | 12340386 | 1505 | 1505 | 3
- 559947 | 187 | sympathetic | sympathetic | 74 | 32157358 | 12337601 | 1505 | 1505 | 3
- 562517 | 187 | tasty | tasty | 74 | 32188047 | 12340386 | 1505 | 1505 | 3
- 562517 | 187 | tasty | tasty | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
- 562517 | 187 | tasty | tasty | 74 | 32266815 | 12347541 | 1505 | 1505 | 3
- 613429 | 187 | voucher | voucher | 74 | 31278572 | 11933333 | 1445 | 1445 | 2
- 616917 | 187 | well | well | 74 | 32077939 | 12330230 | 1505 | 1505 | 3
- 616917 | 187 | well | well | 74 | 32151897 | 12337101 | 1505 | 1505 | 3
- 1690908 | 187 | OK | ok | 74 | 32077836 | 12330224 | 1505 | 1505 | 3
- 19285759 | 187 | whizzy | whizzy | 74 | 52617892 | 20647172 | 3991 | 3991 | 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement