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