Browse Listings in Home Improvement Supplies
Show Only: Closed Lots
[Cube\Exception]
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'rallyaut_v8.bids.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT l.*, max(b.amount) as current_bid, MAX(bids.id) AS bid_id FROM ppb_listings AS l LEFT JOIN ppb_bids AS b ON b.listing_id = l.id INNER JOIN ppb_bids AS bids ON bids.listing_id = l.id WHERE (l.category_id IN (4602)) AND (l.listing_type IN ('auction', 'product')) AND (l.draft = 0) AND (l.active = 1) AND (l.approved = 1) AND (l.list_in != 'store') AND (l.closed = 1) AND (l.deleted = 0) AND (l.end_time <= now()) GROUP BY l.id, l.id ORDER BY bids.id DESC, IF(l.listing_type='auction', IF(max(b.amount) is null, l.start_price, max(b.amount)), l.buyout_price) ASC LIMIT 20
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'rallyaut_v8.bids.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT l.*, max(b.amount) as current_bid, MAX(bids.id) AS bid_id FROM ppb_listings AS l LEFT JOIN ppb_bids AS b ON b.listing_id = l.id INNER JOIN ppb_bids AS bids ON bids.listing_id = l.id WHERE (l.category_id IN (4602)) AND (l.listing_type IN ('auction', 'product')) AND (l.draft = 0) AND (l.active = 1) AND (l.approved = 1) AND (l.list_in != 'store') AND (l.closed = 1) AND (l.deleted = 0) AND (l.end_time <= now()) GROUP BY l.id, l.id ORDER BY bids.id DESC, IF(l.listing_type='auction', IF(max(b.amount) is null, l.start_price, max(b.amount)), l.buyout_price) ASC LIMIT 20