 |
|
|
|
|
Unknown column 'me.idMedico' in 'where clause'select distinct m.id, m.apellido, m.nombre , ifnull((select sum(r.puntaje) from rating r where r.idMedico = m.id and r.idCategoria = 1),'-') as c1, ifnull((select sum(r.puntaje) from rating r where r.idMedico = m.id and r.idCategoria = 2),'-') as c2, ifnull((select sum(r.puntaje) from rating r where r.idMedico = m.id and r.idCategoria = 3),'-') as c3 from medicos m, medicosespecialidades me where me.idMedico = m.id group by m.id order by c1 DESC, m.apellido ASC, m.nombre ASC |
