mode: 58 archiv: urlMode:
manualCriteria:
modeCriteria: AND (A.Auktion = 58) AND (A.KatNr >= ) AND (A.KatNr <= ) AND not isNull(A.Verkauf)
qry all: SELECT A.Auktion, A.ObjNr, Kateg_Freiverkauf,
If(Not IsNull(Kateg_TopSales),'TOP',
If(Status='ARC' Or Status='NVK',
If(IsNull(Verkauf) AND IsNull(Ueberg_Dat),'NVK','ARC'),'AKT')) AS aStatus
FROM (Artikel A
INNER JOIN Auktionen T ON A.Auktion = T.Nr) WHERE 1=1 ORDER BY A.Auktion DESC, A.KatNr
fltMode:
artist: integer int(-1)
qry lots: SELECT
A.*,
T.Nr, T.Termin_de,
K.BildRe, K.UrhG_yr,
If(Not IsNull(Kateg_TopSales),'TOP',
If(Status='ARC' Or Status='NVK',
If(IsNull(Verkauf) AND IsNull(Ueberg_Dat),'NVK','ARC'),'AKT')) AS aStatus,
kateg_Art
FROM Artikel A
LEFT OUTER JOIN Kuenstler K ON A.Kuenstler = K.KueId
LEFT OUTER JOIN Auktionen T ON A.Auktion = T.Nr
LEFT OUTER JOIN KatalogKategorie kk ON A.Kateg = kk.KatId WHERE 1=1 AND (A.Auktion = 58) AND (A.KatNr >= ) AND (A.KatNr <= ) AND not isNull(A.Verkauf) ORDER BY A.Auktion DESC, A.KatNr
ctAll: 0 affected rows: -1
Prices shown are estimate prices. The majority of the lots is taxed according to "Differenzbesteuerung", so there is no V.A.T. on
the item itself.
* Item of artist registered with the VG Bildkunst, upon which a droit-de-suite fee will be raised, are marked
as "Droit-de-suite of 2,5 % applies"".
(conditions of sale paragr. 7.4.)