Error description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and p.id <> 8134 AND p.publicado = 1 AND ((pd.stock - pd.stock_reserva) > 0 OR p' at line 1
SELECT pd.id, CONCAT(UPPER(SUBSTRING(pd.nombre, 1, 1)), LOWER(SUBSTRING(pd.nombre, 2))) AS nombre_capitalizado, p.id, p.para_despacho, p.para_retiro, p.thumbs, MIN(if(pd.descuento > 0, pd.descuento, pd.precio)) as valorMenor, pd.stock, pd.stock_reserva, pd.stock_proveedor, pd.origen, pd.ancho, pd.alto, pd.largo, pd.peso FROM productos p, productos_detalles pd, lineas_productos lp, categorias c WHERE p.id = pd.producto_id AND pd.producto_id = lp.producto_id AND lp.categoria_id = c.id and c.id = and p.id <> 8134 AND p.publicado = 1 AND ((pd.stock - pd.stock_reserva) > 0 OR pd.stock_proveedor > 0 ) AND pd.precio > 100 AND p.thumbs != '' GROUP BY p.id ORDER BY p.fecha_modificacion desc limit 10