API tools faq
paste
Advertisement
Guest User

rnk_yearly

a guest
Oct 23rd, 2019
88
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 5.37 KB | None | 0 0
raw download clone embed print report
  1. SELECT t1.id as 'id'
  2.       ,t1.fonograma as 'fonograma'
  3.       ,t1.genero as 'genero'
  4.       ,t1.artista as 'artista'
  5.       ,t1.mes as 'mes'
  6.       ,t1.dia as 'dia'
  7.       ,t1.categoria as 'categoria'
  8.       ,(t1.uf1 + t2.uf1 + t3.uf1 + t4.uf1 + t5.uf1 + t6.uf1 + t7.uf1 + t8.uf1 + t9.uf1 + t10.uf1 + t11.uf1 + t12.uf1) as 'uf1'
  9.       ,(t1.uf2 + t2.uf2 + t3.uf2 + t4.uf2 + t5.uf2 + t6.uf2 + t7.uf2 + t8.uf2 + t9.uf2 + t10.uf2 + t11.uf2 + t12.uf2) as 'uf2'
  10.       ,(t1.uf3 + t2.uf3 + t3.uf3 + t4.uf3 + t5.uf3 + t6.uf3 + t7.uf3 + t8.uf3 + t9.uf3 + t10.uf3 + t11.uf3 + t12.uf3) as 'uf3'
  11.       ,(t1.uf4 + t2.uf4 + t3.uf4 + t4.uf4 + t5.uf4 + t6.uf4 + t7.uf4 + t8.uf4 + t9.uf4 + t10.uf4 + t11.uf4 + t12.uf4) as 'uf4'
  12.       ,(t1.uf5 + t2.uf5 + t3.uf5 + t4.uf5 + t5.uf5 + t6.uf5 + t7.uf5 + t8.uf5 + t9.uf5 + t10.uf5 + t11.uf5 + t12.uf5) as 'uf5'
  13.       ,(t1.uf6 + t2.uf6 + t3.uf6 + t4.uf6 + t5.uf6 + t6.uf6 + t7.uf6 + t8.uf6 + t9.uf6 + t10.uf6 + t11.uf6 + t12.uf6) as 'uf6'
  14.       ,(t1.uf8 + t2.uf8 + t3.uf8 + t4.uf8 + t5.uf8 + t6.uf8 + t7.uf8 + t8.uf8 + t9.uf8 + t10.uf8 + t11.uf8 + t12.uf8) as 'uf8'
  15.       ,(t1.uf9 + t2.uf9 + t3.uf9 + t4.uf9 + t5.uf9 + t6.uf9 + t7.uf9 + t8.uf9 + t9.uf9 + t10.uf9 + t11.uf9 + t12.uf9) as 'uf9'
  16.       ,(t1.uf10 + t2.uf10 + t3.uf10 + t4.uf10 + t5.uf10 + t6.uf10 + t7.uf10 + t8.uf10 + t9.uf10 + t10.uf10 + t11.uf10 + t12.uf10) as 'uf10'
  17.       ,(t1.uf11 + t2.uf11 + t3.uf11 + t4.uf11 + t5.uf11 + t6.uf11 + t7.uf11 + t8.uf11 + t9.uf11 + t10.uf11 + t11.uf11 + t12.uf11) as 'uf11'
  18.       ,(t1.uf12 + t2.uf12 + t3.uf12 + t4.uf12 + t5.uf12 + t6.uf12 + t7.uf12 + t8.uf12 + t9.uf12 + t10.uf12 + t11.uf12 + t12.uf12) as 'uf12'
  19.       ,(t1.uf13 + t2.uf13 + t3.uf13 + t4.uf13 + t5.uf13 + t6.uf13 + t7.uf13 + t8.uf13 + t9.uf13 + t10.uf13 + t11.uf13 + t12.uf13) as 'uf13'
  20.       ,(t1.uf14 + t2.uf14 + t3.uf14 + t4.uf14 + t5.uf14 + t6.uf14 + t7.uf14 + t8.uf14 + t9.uf14 + t10.uf14 + t11.uf14 + t12.uf14) as 'uf14'
  21.       ,(t1.uf15 + t2.uf15 + t3.uf15 + t4.uf15 + t5.uf15 + t6.uf15 + t7.uf15 + t8.uf15 + t9.uf15 + t10.uf15 + t11.uf15 + t12.uf15) as 'uf15'
  22.       ,(t1.uf16 + t2.uf16 + t3.uf16 + t4.uf16 + t5.uf16 + t6.uf16 + t7.uf16 + t8.uf16 + t9.uf16 + t10.uf16 + t11.uf16 + t12.uf16) as 'uf16'
  23.       ,(t1.uf17 + t2.uf17 + t3.uf17 + t4.uf17 + t5.uf17 + t6.uf17 + t7.uf17 + t8.uf17 + t9.uf17 + t10.uf17 + t11.uf17 + t12.uf17) as 'uf17'
  24.       ,(t1.uf18 + t2.uf18 + t3.uf18 + t4.uf18 + t5.uf18 + t6.uf18 + t7.uf18 + t8.uf18 + t9.uf18 + t10.uf18 + t11.uf18 + t12.uf18) as 'uf18'
  25.       ,(t1.uf19 + t2.uf19 + t3.uf19 + t4.uf19 + t5.uf19 + t6.uf19 + t7.uf19 + t8.uf19 + t9.uf19 + t10.uf19 + t11.uf19 + t12.uf19) as 'uf19'
  26.       ,(t1.uf20 + t2.uf20 + t3.uf20 + t4.uf20 + t5.uf20 + t6.uf20 + t7.uf20 + t8.uf20 + t9.uf20 + t10.uf20 + t11.uf20 + t12.uf20) as 'uf20'
  27.       ,(t1.uf21 + t2.uf21 + t3.uf21 + t4.uf21 + t5.uf21 + t6.uf21 + t7.uf21 + t8.uf21 + t9.uf21 + t10.uf21 + t11.uf21 + t12.uf21) as 'uf21'
  28.       ,(t1.uf22 + t2.uf22 + t3.uf22 + t4.uf22 + t5.uf22 + t6.uf22 + t7.uf22 + t8.uf22 + t9.uf22 + t10.uf22 + t11.uf22 + t12.uf22) as 'uf22'
  29.       ,(t1.uf23 + t2.uf23 + t3.uf23 + t4.uf23 + t5.uf23 + t6.uf23 + t7.uf23 + t8.uf23 + t9.uf23 + t10.uf23 + t11.uf23 + t12.uf23) as 'uf23'
  30.       ,(t1.uf24 + t2.uf24 + t3.uf24 + t4.uf24 + t5.uf24 + t6.uf24 + t7.uf24 + t8.uf24 + t9.uf24 + t10.uf24 + t11.uf24 + t12.uf24) as 'uf24'
  31.       ,(t1.uf25 + t2.uf25 + t3.uf25 + t4.uf25 + t5.uf25 + t6.uf25 + t7.uf25 + t8.uf25 + t9.uf25 + t10.uf25 + t11.uf25 + t12.uf25) as 'uf25'
  32.       ,(t1.uf26 + t2.uf26 + t3.uf26 + t4.uf26 + t5.uf26 + t6.uf26 + t7.uf26 + t8.uf26 + t9.uf26 + t10.uf26 + t11.uf26 + t12.uf26) as 'uf26'
  33.       ,(t1.uf27 + t2.uf27 + t3.uf27 + t4.uf27 + t5.uf27 + t6.uf27 + t7.uf27 + t8.uf27 + t9.uf27 + t10.uf27 + t11.uf27 + t12.uf27) as 'uf27'
  34.       ,(t1.uf34 + t2.uf34 + t3.uf34 + t4.uf34 + t5.uf34 + t6.uf34 + t7.uf34 + t8.uf34 + t9.uf34 + t10.uf34 + t11.uf34 + t12.uf34) as 'uf34'
  35.       ,(t1.r1 + t2.r1 + t3.r1 + t4.r1 + t5.r1 + t6.r1 + t7.r1 + t8.r1 + t9.r1 + t10.r1 + t11.r1 + t12.r1) as 'r1'
  36.       ,(t1.r2 + t2.r2 + t3.r2 + t4.r2 + t5.r2 + t6.r2 + t7.r2 + t8.r2 + t9.r2 + t10.r2 + t11.r2 + t12.r2) as 'r2'
  37.       ,(t1.r3 + t2.r3 + t3.r3 + t4.r3 + t5.r3 + t6.r3 + t7.r3 + t8.r3 + t9.r3 + t10.r3 + t11.r3 + t12.r3) as 'r3'
  38.       ,(t1.r4 + t2.r4 + t3.r4 + t4.r4 + t5.r4 + t6.r4 + t7.r4 + t8.r4 + t9.r4 + t10.r4 + t11.r4 + t12.r4) as 'r4'
  39.       ,(t1.r5 + t2.r5 + t3.r5 + t4.r5 + t5.r5 + t6.r5 + t7.r5 + t8.r5 + t9.r5 + t10.r5 + t11.r5 + t12.r5) as 'r5'
  40.       ,(t1.total + t2.total + t3.total + t4.total + t5.total + t6.total + t7.total + t8.total + t9.total + t10.total + t11.total + t12.total) as 'total'
  41. FROM rnk201901a t1
  42. LEFT JOIN rnk201902a t2 ON t1.fonograma = t2.fonograma AND t1.dia = t2.dia
  43. LEFT JOIN rnk201903a t3 ON t1.fonograma = t3.fonograma AND t1.dia = t3.dia
  44. LEFT JOIN rnk201904a t4 ON t1.fonograma = t4.fonograma AND t1.dia = t4.dia
  45. LEFT JOIN rnk201905a t5 ON t1.fonograma = t5.fonograma AND t1.dia = t5.dia
  46. LEFT JOIN rnk201906a t6 ON t1.fonograma = t6.fonograma AND t1.dia = t6.dia
  47. LEFT JOIN rnk201907a t7 ON t1.fonograma = t7.fonograma AND t1.dia = t7.dia
  48. LEFT JOIN rnk201908a t8 ON t1.fonograma = t8.fonograma AND t1.dia = t8.dia
  49. LEFT JOIN rnk201909a t9 ON t1.fonograma = t9.fonograma AND t1.dia = t9.dia
  50. LEFT JOIN rnk2019010a t10 ON t1.fonograma = t10.fonograma AND t1.dia = t10.dia
  51. LEFT JOIN rnk2019011a t11 ON t1.fonograma = t11.fonograma AND t1.dia = t11.dia
  52. LEFT JOIN rnk2019012a t12 ON t1.fonograma = t12.fonograma AND t1.dia = t12.dia;
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!