[% struktorierte_daten.place.name %]
[% struktorierte_daten.place.address.streetAddress %]
[% struktorierte_daten.place.address.addressLocality %]
[% struktorierte_daten.place.address.postalCode %]
Alle Angebote
select l.lot, l.gruppe, l.preis_akt_gebot, l.datum_ende, l.anzahl_gruppe, 0 as relevanz
, l.verlagsobjektplan_id, (l.anzahl_gruppe - y.weg) as anzahl_rest
, IF(l.flag_zuschlag>0, 10000000,0)+IF(l.datum_ende<UNIX_TIMESTAMP(NOW()),10000000,0) + (l.preis_akt_gebot * 100) + TIME_TO_SEC(TIME(FROM_UNIXTIME(l.datum_ende))) as summe
from lot_permanent l
JOIN (
select x.gruppe, x.verlagsobjektplan_id, min(x.summe) as summe
,sum( IF(flag_zuschlag=1 or datum_ende<unix_timestamp(now()), 1, 0) ) as weg
FROM (
select lot, gruppe, verlagsobjektplan_id, flag_zuschlag, datum_ende
, IF(flag_zuschlag>0, 10000000,0)+IF(datum_ende<UNIX_TIMESTAMP(NOW()),10000000,0) + (preis_akt_gebot * 100) + TIME_TO_SEC(TIME(FROM_UNIXTIME(datum_ende))) as summe
from lot_permanent
where verlagsobjektplan_id=4 and flag_delete=0 and flag_auktion=1 and datum_start>0 and datum_ende>0
) x
group by x.gruppe
) y on(l.gruppe=y.gruppe and l.verlagsobjektplan_id=y.verlagsobjektplan_id and IF(l.flag_zuschlag>0, 10000000,0)+IF(l.datum_ende<UNIX_TIMESTAMP(NOW()),10000000,0) + (l.preis_akt_gebot * 100) + TIME_TO_SEC(TIME(FROM_UNIXTIME(l.datum_ende)))=y.summe and y.verlagsobjektplan_id=4 )
WHERE l.flag_auktion=1
AND l.datum_start>0
AND l.datum_ende>0
AND l.flag_delete=0
AND l.verlagsobjektplan_id=4
order by l.datum_ende ASC limit 12 OFFSET 0