SELECT a.*, ac.counter, u.nick, u.reg_date, u.country, u.zip, u.city FROM webid_auctions a LEFT JOIN webid_users u ON (u.id = a.user) LEFT JOIN webid_auccounter ac ON (ac.auction_id = a.id) WHERE a.id != 0 AND a.closed = 0 AND a.suspended = 0 AND a.winner = 0 AND a.sold='n' ORDER BY ac.counter DESC LIMIT 12