Ingrea tu correo electrónico y la orden de compra

Buscar pedido
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.nombre, p.thumbs, p.marca_id, if((select posicion from posicion_productos where producto_id = and linea_id = 8 ) IS NOT NULL, (select posicion from posicion_productos where produCto_id = and linea_id = 8), 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 = pd.producto_id AND lp.producto_id = AND = lp.linea_id AND = 8 AND p.marca_id = AND p.publicado = 1 and pd.precio > 0 group by ORDER BY posicionProducto asc