query

SELECT bt.bid, bt.max_bid, bt.floor_bidder, ali.lot_num_prefix, ali.lot_num, ali.lot_num_ext, us.state, us.zip, ui.referrer_host
FROM bid_transaction bt
LEFT JOIN user_info ui ON bt.user_id = ui.user_id
LEFT JOIN user_shipping us ON bt.user_id = us.user_id
INNER JOIN auction_lot_item ali ON (ali.auction_id = bt.auction_id AND ali.lot_item_id = bt.lot_item_id)
WHERE bt.auction_id = 2621 AND ali.lot_status_id IN (1,2,3);