Browse Stores
[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 'goodfind_newauction.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.*, l.id AS listing_id FROM ppb_users AS u LEFT JOIN ppb_listings AS l ON l.user_id = u.id WHERE (u.store_category_id IN (1244, 1246, 1247, 1248, 1250, 1249, 1251, 1252, 1253, 1254, 1269, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1263, 1262, 1264, 1265, 1266, 1267, 1268)) AND (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) GROUP BY u.id ORDER BY u.created_at DESC LIMIT 20
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #52 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'goodfind_newauction.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.*, l.id AS listing_id FROM ppb_users AS u LEFT JOIN ppb_listings AS l ON l.user_id = u.id WHERE (u.store_category_id IN (1244, 1246, 1247, 1248, 1250, 1249, 1251, 1252, 1253, 1254, 1269, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1263, 1262, 1264, 1265, 1266, 1267, 1268)) AND (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) GROUP BY u.id ORDER BY u.created_at DESC LIMIT 20
