Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `disenos`.*, `votos`.`valoracion`, `usuario_contacto`.`nombres`,
- `usuario_contacto`.`apellidos`, `users`.`username`, `users`.`avatar` as usuario_avatar,
- COUNT(comentarios.id_comentario) as comentarios,
- COUNT(votos.id_usuario) as votos
- FROM (`disenos`)
- LEFT JOIN `votos` ON `votos`.`id_diseno` = `disenos`.`id_diseno` AND votos.id_usuario = 1
- LEFT JOIN `users` ON `users`.`id_usuario` = `disenos`.`id_usuario`
- LEFT JOIN `usuario_contacto` ON `usuario_contacto`.`id_usuario` = `disenos`.`id_usuario`
- LEFT JOIN `comentarios` ON `comentarios`.`id_diseno` = `disenos`.`id_diseno`
- WHERE `disenos`.`estado` = 1 AND `disenos`.`votacion` = 1
- GROUP BY `disenos`.`id_diseno` LIMIT 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement