| Message: | MySQL Query fail:
SELECT SQL_CALC_FOUND_ROWS
lms_articulo.id,
lms_articulo.titulo,
lms_articulo.descripcion_corta,
lms_articulo.url_rewrite,
lms_articulo.categoria_id,
lms_categoria.titulo AS categoria_titulo,
lms_categoria.url_rewrite AS categoria_url,
lms_articulo.autor_id,
lms_articulo.estado,
lms_articulo.imagen,
lms_articulo.nivel,
lms_articulo.precio,
lms_articulo.date_add,
lms_articulo.date_upd,
DATE_FORMAT(lms_articulo.date_add, '%d/%m/%Y') as fecha_add,
DATE_FORMAT(lms_articulo.date_upd, '%d/%m/%Y') as fecha_upd,
lms_usuario.nombre AS autor_nombre,
lms_usuario.apellidos AS autor_apellidos,
lms_usuario.nickname AS autor_nickname,
lms_usuario.email AS autor_email,
(SELECT COUNT(*) as total_fav FROM lms_usuario_favoritos WHERE articulo_id = lms_articulo.id) AS total_fav,
(SELECT IFNULL(ROUND(AVG(puntos)),0) as media FROM lms_articulo_valoracion WHERE articulo_id = lms_articulo.id) as valoracion_media,
(SELECT IFNULL(COUNT(id),0) as total FROM lms_articulo_valoracion WHERE lms_articulo_valoracion.articulo_id = lms_articulo.id) as valoracion_total,
(SELECT IFNULL(SUM(views_count),0) AS articulo_views FROM lms_articulo_pages WHERE lms_articulo_pages.articulo_id = lms_articulo.id) AS views_count
FROM lms_articulo
INNER JOIN lms_categoria ON lms_categoria.id = lms_articulo.categoria_id
INNER JOIN lms_usuario ON lms_usuario.id = lms_articulo.autor_id
WHERE (lms_articulo.id > 0)
AND lms_articulo.estado = 4
ORDER BY lms_articulo.id DESC
LIMIT 0, 16
|