zurück

ONLINE-CATALOGUE

AUCTION 58 08. Dezember 2018
mode: 58   archiv:   urlMode:
manualCriteria:
modeCriteria: AND (A.Auktion = 58) AND (A.KatNr >= ) AND (A.KatNr <= ) AND 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 isNull(A.Verkauf) ORDER BY A.Auktion DESC, A.KatNr

ctAll: 0  affected rows: -1
Suche more search options
<<<      >>>
<<<      >>>


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.)