[Cube\Exception]
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'charity_id' in order clause is ambiguous [Query]: SELECT l.*, max(b.amount) as current_bid FROM ppb_listings AS l LEFT JOIN ppb_bids AS b ON b.listing_id = l.id WHERE (l.charity_id IN ('91') OR l.charity_id IS NULL) AND (l.category_id IN (3690, 7483, 7490, 7484, 7485, 7488, 7489, 7491, 7486, 7487, 7492, 7493, 7494, 7495, 7496, 7497, 7498, 7499, 7500, 7501, 7502, 7510, 7503, 7504, 7505, 7506, 7507, 7508, 7509, 7514, 7515, 7511, 7513, 7516, 7512, 7517, 7518, 7519, 7520, 7522, 7521, 7523, 7524, 7525, 7526, 7534, 7527, 7528, 7529, 7530, 7531, 7532, 7533, 7535, 7536, 7537, 7538, 7540, 7539, 7542, 7541, 7543, 7549, 7545, 7546, 7544, 7547, 7548, 7568, 7567, 7566, 7564, 7563, 7565, 7562, 7561, 7560, 7559, 7558, 7550, 7557, 7556, 7555, 7554, 7553, 7552, 7551, 7569, 7570, 7571, 7573, 7572, 7574, 7575, 7576, 7578, 7577, 7579, 7580, 7582, 7581, 7583, 7584, 7585, 7586, 7587, 7588, 7589, 7590, 7591, 7592, 7593, 7594, 7607, 7595, 7596, 7597, 7598, 7599, 7600, 7601, 7602, 7603, 7604, 7605, 7606, 7608, 7609, 7610, 7611, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7628, 7620, 7621, 7622, 7623, 7624, 7625, 7626, 7627) OR l.addl_category_id IN (3690, 7483, 7490, 7484, 7485, 7488, 7489, 7491, 7486, 7487, 7492, 7493, 7494, 7495, 7496, 7497, 7498, 7499, 7500, 7501, 7502, 7510, 7503, 7504, 7505, 7506, 7507, 7508, 7509, 7514, 7515, 7511, 7513, 7516, 7512, 7517, 7518, 7519, 7520, 7522, 7521, 7523, 7524, 7525, 7526, 7534, 7527, 7528, 7529, 7530, 7531, 7532, 7533, 7535, 7536, 7537, 7538, 7540, 7539, 7542, 7541, 7543, 7549, 7545, 7546, 7544, 7547, 7548, 7568, 7567, 7566, 7564, 7563, 7565, 7562, 7561, 7560, 7559, 7558, 7550, 7557, 7556, 7555, 7554, 7553, 7552, 7551, 7569, 7570, 7571, 7573, 7572, 7574, 7575, 7576, 7578, 7577, 7579, 7580, 7582, 7581, 7583, 7584, 7585, 7586, 7587, 7588, 7589, 7590, 7591, 7592, 7593, 7594, 7607, 7595, 7596, 7597, 7598, 7599, 7600, 7601, 7602, 7603, 7604, 7605, 7606, 7608, 7609, 7610, 7611, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7628, 7620, 7621, 7622, 7623, 7624, 7625, 7626, 7627)) AND (l.listing_type IN ('auction', 'product')) AND (l.draft = 0) AND (l.active = 1) AND (l.approved = 1) AND (l.closed = 0) AND (l.deleted = 0) AND (l.list_in != 'store') GROUP BY l.id ORDER BY FIELD(charity_id, 91) DESC, IF(l.listing_type='auction', IF(max(b.amount) is null, l.start_price, max(b.amount)), l.buyout_price) DESC LIMIT 20
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'charity_id' in order clause is ambiguous [Query]: SELECT l.*, max(b.amount) as current_bid FROM ppb_listings AS l LEFT JOIN ppb_bids AS b ON b.listing_id = l.id WHERE (l.charity_id IN ('91') OR l.charity_id IS NULL) AND (l.category_id IN (3690, 7483, 7490, 7484, 7485, 7488, 7489, 7491, 7486, 7487, 7492, 7493, 7494, 7495, 7496, 7497, 7498, 7499, 7500, 7501, 7502, 7510, 7503, 7504, 7505, 7506, 7507, 7508, 7509, 7514, 7515, 7511, 7513, 7516, 7512, 7517, 7518, 7519, 7520, 7522, 7521, 7523, 7524, 7525, 7526, 7534, 7527, 7528, 7529, 7530, 7531, 7532, 7533, 7535, 7536, 7537, 7538, 7540, 7539, 7542, 7541, 7543, 7549, 7545, 7546, 7544, 7547, 7548, 7568, 7567, 7566, 7564, 7563, 7565, 7562, 7561, 7560, 7559, 7558, 7550, 7557, 7556, 7555, 7554, 7553, 7552, 7551, 7569, 7570, 7571, 7573, 7572, 7574, 7575, 7576, 7578, 7577, 7579, 7580, 7582, 7581, 7583, 7584, 7585, 7586, 7587, 7588, 7589, 7590, 7591, 7592, 7593, 7594, 7607, 7595, 7596, 7597, 7598, 7599, 7600, 7601, 7602, 7603, 7604, 7605, 7606, 7608, 7609, 7610, 7611, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7628, 7620, 7621, 7622, 7623, 7624, 7625, 7626, 7627) OR l.addl_category_id IN (3690, 7483, 7490, 7484, 7485, 7488, 7489, 7491, 7486, 7487, 7492, 7493, 7494, 7495, 7496, 7497, 7498, 7499, 7500, 7501, 7502, 7510, 7503, 7504, 7505, 7506, 7507, 7508, 7509, 7514, 7515, 7511, 7513, 7516, 7512, 7517, 7518, 7519, 7520, 7522, 7521, 7523, 7524, 7525, 7526, 7534, 7527, 7528, 7529, 7530, 7531, 7532, 7533, 7535, 7536, 7537, 7538, 7540, 7539, 7542, 7541, 7543, 7549, 7545, 7546, 7544, 7547, 7548, 7568, 7567, 7566, 7564, 7563, 7565, 7562, 7561, 7560, 7559, 7558, 7550, 7557, 7556, 7555, 7554, 7553, 7552, 7551, 7569, 7570, 7571, 7573, 7572, 7574, 7575, 7576, 7578, 7577, 7579, 7580, 7582, 7581, 7583, 7584, 7585, 7586, 7587, 7588, 7589, 7590, 7591, 7592, 7593, 7594, 7607, 7595, 7596, 7597, 7598, 7599, 7600, 7601, 7602, 7603, 7604, 7605, 7606, 7608, 7609, 7610, 7611, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7628, 7620, 7621, 7622, 7623, 7624, 7625, 7626, 7627)) AND (l.listing_type IN ('auction', 'product')) AND (l.draft = 0) AND (l.active = 1) AND (l.approved = 1) AND (l.closed = 0) AND (l.deleted = 0) AND (l.list_in != 'store') GROUP BY l.id ORDER BY FIELD(charity_id, 91) DESC, IF(l.listing_type='auction', IF(max(b.amount) is null, l.start_price, max(b.amount)), l.buyout_price) DESC LIMIT 20