Browse Stores

Stores / Browse Stores / Charity Fundraiser Auctions

Banner

[Cube\Exception]
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #52 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'larrys10_auction.l.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT u.*, s.featured_store, l.id AS listing_id FROM ppb7_users AS u LEFT JOIN ppb7_stores_subscriptions AS s ON s.id = u.store_subscription_id LEFT JOIN ppb7_listings AS l ON l.user_id = u.id WHERE (u.active = 1) AND (u.approved = 1) AND (u.store_active = 1) AND (l.list_in != 'site') AND (l.closed = 0) AND (l.deleted = 0) AND (l.active = 1) AND (l.approved = 1) AND (u.store_category_id IN (9579, 9584, 9585, 9586, 9587)) AND (s.featured_store = 1 OR u.store_subscription_id IS NULL) GROUP BY u.id ORDER BY rand() LIMIT 8