A Mysql error has occurred while running the script:
- The query you are trying to run is invalid
- Mysql Error Output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FORCE INDEX(auctions_max_bid)
WHERE a.active=1 AND a.approved=1 AND a.delete' at line 5
- SQL Query: 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.vat_percent,
a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap, a.list_in, a.category_id, a.addl_category_id,
u.username as u_username, u.user_id as u_user_id, c.default_vat_value as c_default_vat_value FROM
probid_auctions a INNER JOIN probid_categories c ON c.category_id=a.category_id INNER JOIN probid_users u ON u.user_id=a.owner_id FORCE INDEX(auctions_max_bid)
WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND
a.list_in!='store' AND a.creation_in_progress=0 AND a.nb_bids>0 AND a.closed=0 and end_time>1736822685
GROUP BY a.auction_id
ORDER BY a.max_bid DESC LIMIT 0, 10