Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $consulta="SELECT id as idPel, ident, titcastellano, titoriginal,
- anoestreno, soporte, genero, nacionalidad, produccion, guion,
- fotografia, musica, sinopsis, codcalmor, duracion,
- clasificacion, imdb, (SELECT
- CONCAT(d.nombre,' ',d.apellidos)
- FROM tbldirectoresporpelicula tdp
- INNER JOIN tbldirectores d ON tdp.iddirector = d.id
- WHERE tdp.idpelicula=p.id
- GROUP BY CONCAT(d.nombre,d.apellidos)
- LIMIT 1) AS DirectionNA
- FROM tblpeliculas p GROUP BY DirectionNA";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement