tpl->dir = /var/www/vhosts/newmelodies.com/httpdocs/en/templates/nuevas/html/iperfil
canciones
13 = ELLA
17 = LLEGAS A MI
15 = NO AGUANTO MAS
18 = PARA MI
12 = PASAJERO
14 = TENGO MUCHO CALOR
19 = VETE MUY LEJOS
11 = VIVO
total_plays = SELECT SUM(valor) as valor FROM cancion_escuchadas as ce LEFT JOIN cancion as c USING (idcancion) WHERE c.idusuario='10'
total_descargas = SELECT COUNT(iddescarga) as valor FROM descarga as d LEFT JOIN cancion as c USING (idcancion) WHERE c.idusuario='10' and d.idusuario IS NOT NULL and d.idusuario!=0
total_descargas = SELECT COUNT(iddescarga) as valor FROM descarga as d LEFT JOIN cancion as c USING (idcancion) WHERE c.idusuario='10' and d.idusuario IS NOT NULL and d.idusuario!=0