[Qgis-user] Virtual Layer: ORDER BY ignored?

[Bernd Vogelgesang]

Hi,

I'm experimenting with virtual layers and struggle again with the
(un)logic of that.

SELECT
a.geometry,a.fid,a.typ,a.kasten_nr,a.kastenart,a.zielart,a.revier,a.gebiet,b.bemerkung,b.status,b.zustand,b.massnahmen,b.reinigung
FROM (SELECT * FROM Kaesten where Kaesten.status=1 AND Kaesten.typ="BI")
as a
LEFT JOIN  kastenkontrolle as b
     ON a.kasten_nr= b.kasten_nr
     WHERE b.kasten_nr IS NOT NULL AND b.status="nv"
ORDER BY a.kastenart desc;


I'm joining a subset of points with a subset of a non-spatial table.
Now I would like to have the resulting attribute table be ordered, but
whatever I try, the thing follows some inner will and wont order.

Is ORDER BY not supported or do I miss sth basic?

Thankful for any input,

Bernd