SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type FROM guntr_auctions a FORCE INDEX(auctions_end_time) WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND a.creation_in_progress=0 AND (a.category_id IN (1870, 1890, 1891, 1892, 1894, 1895, 1896, 1893, 1889, 1897) OR a.addl_category_id IN (1870, 1890, 1891, 1892, 1894, 1895, 1896, 1893, 1889, 1897)) ORDER BY a.end_time ASC LIMIT 0, 20