SELECT 
      UNIX_TIMESTAMP(date)
 FROM 
      `isparduotuve_biddings`
 ORDER BY 
      `Id` DESC
 LIMIT 
      1 

 
 SELECT 
      a.id,
      p.Pavadinimas_LT AS title,
      a.section AS auction_section,
      a.defect,
      a.finish_date,
      a.type AS auction_type,
      UNIX_TIMESTAMP(a.start_date) AS pubDate,
      UNIX_TIMESTAMP(a.finish_date) AS finish_time,
      UNIX_TIMESTAMP(MAX(b.date)) AS lastBidDate,
      IFNULL(MAX(b.price),
      a.minimal_bidding_price ) AS price_now,
      a.price AS fixed_price,
      m.name AS manufacturer,
      p.skuid
 FROM 
      isparduotuve_product AS a LEFT JOIN
      mon_prekes p ON (a.sku_id  =  p.Skuid) LEFT JOIN
      mon_manufacturer m ON (m.id  =  p.gamintojas_id) LEFT JOIN
      isparduotuve_biddings AS b ON a.id = b.auction_id
 WHERE 
      a.section  =  'started' OR
      (a.section  =  'ended' AND
      UNIX_TIMESTAMP() - UNIX_TIMESTAMP(a.finish_date) < 176400 AND
      a.finish_date < NOW() ) AND
      a.start_date < NOW()
 GROUP BY 
      a.id
 ORDER BY 
      a.section,
      a.finish_date ASC