320 Angebote
Lot_typen: 1,2,3,4,5,6,7,8,9,10,11,12,30,31,32,33,34,35,101,102,103,104,105,106,107,
angebote - - 25 - 1 - 0
select l.lot
from lot_permanent_archiv l
join franchise_nehmer f on(l.franchise_nr=f.nr)
where l.datum_start>0 and l.datum_ende>0 and l.flag_delete=0 and l.flag_auktion=1 and l.verlagsobjektplan_id=? and ( l.lot_typ IN (1,2,3,4,5,6,7,8,9,10,11,12,30,31,32,33,34,35,101,102,103,104,105,106,107) or l.lot_typ_2 IN (1,2,3,4,5,6,7,8,9,10,11,12,30,31,32,33,34,35,101,102,103,104,105,106,107) ) group by l.lot order by l.datum_ende ASC limit 30 OFFSET 30