A Mysql error has occurred while running the script:
- The query you are trying to run is invalid
- Mysql Error Output: Unknown column 'a.total_sold' in 'field list'
- SQL Query: SELECT a.auction_id, a.name,a.start_preview_time, a.direct_payment, a.quantity, a.max_bid, a.start_price, a.total_sold,
if(a.nb_bids>0,a.max_bid,a.start_price) as price, a.nb_bids, a.buyout_price,
a.currency, a.end_time, a.closed, a.bold, a.hl, a.is_offer, a.reserve_price, a.owner_id, a.subtitle, a.postage_amount,
a.fb_current_bid, a.auction_type, a.state, a.country, a.charity_for, a.charity_amount, u.username, c.flag, a.category_id FROM
auction_auctions a FORCE INDEX(auctions_max_bid)
LEFT JOIN auction_users u ON u.user_id=a.owner_id
LEFT JOIN auction_countries c ON c.id=a.country
WHERE a.active=1 AND a.approved=1 AND a.end_time >= (1714606230) AND a.deleted=0 AND
a.list_in!='store' AND a.creation_in_progress=0 AND a.nb_bids>0
GROUP BY a.auction_id
ORDER BY price DESC LIMIT 0, 10
- Reference Point:
- Date / Time of Error: 02 May 2024 19:30:31