close

Ingrea tu correo electrónico y la orden de compra

Buscar pedido
close

Error description: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ecocopter.pd.precio' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT distinct(p.id), p.nombre, p.thumbs, p.marca_id, if((select posicion from posicion_productos where producto_id = p.id and linea_id = 16 ) IS NOT NULL, (select posicion from posicion_productos where produCto_id = p.id and linea_id = 16), 999999) as posicionProducto, MIN(if(pd.descuento > 0, pd.descuento, pd.precio)) as valorMenor, pd.precio, pd.descuento FROM productos p, productos_detalles pd, lineas_productos lp, lineas l, marcas m WHERE p.id = pd.producto_id AND lp.producto_id = p.id AND l.id = lp.linea_id AND l.id = 16 AND p.marca_id = m.id AND p.publicado = 1 and pd.precio > 0 group by p.id ORDER BY posicionProducto asc