close

Ingrea tu correo electrónico y la orden de compra

Buscar pedido
close

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

SELECT p.id, p.nombre, p.thumbs, p.marca_id, pd.id, if((select posicion from posicion_productos where producto_id = p.id and categoria_id = 34) IS NOT NULL, (select posicion from posicion_productos where producto_id = p.id and categoria_id = 34), 999999) as posicionProducto, pd.precio, pd.descuento FROM productos p, productos_detalles pd, lineas_productos lp, categorias c, marcas m WHERE p.id = pd.producto_id AND lp.producto_id = p.id AND c.id = lp.categoria_id AND c.id = 34 AND p.marca_id = m.id AND p.publicado = 1 and pd.precio > 0 group by p.id