select dt_auctions.id, dt_auctions.domain_id, dt_auctions.high_bid, dt_auctions.reserve_price, dt_auctions.currency, dt_domains.domain, dt_domains.owner from dt_auctions left join dt_domains on dt_domains.id = dt_auctions.domain_id where dt_auctions.end_date < 2018-07-16 10:29:10