Stammdaten -> Berichte -> Erzeugnisse -> [Top 100] -->> SQL Failure

[tkasulke@…]

SELECT DISTINCT p.id, pfac.factor AS price_factor, p.partnumber,
ioi.description, p.sellprice, p.lastcost, ioi.unit, SUM(ioi.qty) AS soldtotal
FROM parts p LEFT JOIN partsgroup pg ON (pg.id = p.partsgroup_id) LEFT JOIN (
SELECT parts_id, description, serialnumber, trans_id, unit, sellprice, qty,
assemblyitem, 'invoice' AS ioi FROM invoice UNION
SELECT parts_id, description, serialnumber, trans_id, unit, sellprice, qty,
FALSE AS assemblyitem, 'orderitems' AS ioi FROM orderitems
) AS ioi ON ioi.parts_id = p.id LEFT JOIN price_factors pfac ON (pfac.id =
p.price_factor_id) WHERE (1=1) AND (soldtotal ILIKE ?) AND ( p.assembly) AND
(NOT p.obsolete) AND (ioi.qty >= 0) GROUP BY p.id, pfac.factor, p.partnumber,
ioi.description, p.sellprice, p.lastcost, ioi.unit ORDER BY soldtotal DESC LIMIT
100 (%soldtotal%)
ERROR: column "soldtotal" does not exist

weder in der aktuellen unstabel, noch in der 2.4.3 nachvollzoegen.