[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 (3684, 4649, 4650, 9603, 4651, 4652, 4653, 4654, 4662, 4655, 4656, 4657, 4659, 4658, 4660, 4661, 4664, 4663, 4666, 4665, 4668, 4667, 4671, 4669, 4672, 4670, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4697, 4680, 4682, 4681, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4698, 4691, 4692, 4693, 4694, 4695, 4696, 4699, 4715, 4700, 4701, 4702, 4703, 4704, 4705, 4706, 4716, 4707, 4708, 4709, 4710, 4712, 4711, 4713, 4714, 4717, 4718, 4719, 4723, 4720, 4721, 4722, 4725, 4726, 4727, 4730, 4724, 4728, 4729, 4735, 4733, 4732, 4734, 4736, 4737, 4739, 4740, 4741, 4731, 4738, 4760, 4743, 4742, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4761, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4783, 4784, 4785, 4786, 4762, 4781, 4763, 4764, 4765, 4779, 4766, 4767, 4768, 4769, 4780, 4778, 4782, 4770, 4771, 4772, 4773, 4774, 4775, 4776, 4777, 4787, 4788, 4789, 4793, 4790, 4791, 4792, 4794, 4795, 4796, 4797, 4798, 4802, 4799, 4800, 4801, 9606, 9604, 9605, 9607, 9608) OR l.addl_category_id IN (3684, 4649, 4650, 9603, 4651, 4652, 4653, 4654, 4662, 4655, 4656, 4657, 4659, 4658, 4660, 4661, 4664, 4663, 4666, 4665, 4668, 4667, 4671, 4669, 4672, 4670, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4697, 4680, 4682, 4681, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4698, 4691, 4692, 4693, 4694, 4695, 4696, 4699, 4715, 4700, 4701, 4702, 4703, 4704, 4705, 4706, 4716, 4707, 4708, 4709, 4710, 4712, 4711, 4713, 4714, 4717, 4718, 4719, 4723, 4720, 4721, 4722, 4725, 4726, 4727, 4730, 4724, 4728, 4729, 4735, 4733, 4732, 4734, 4736, 4737, 4739, 4740, 4741, 4731, 4738, 4760, 4743, 4742, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4761, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4783, 4784, 4785, 4786, 4762, 4781, 4763, 4764, 4765, 4779, 4766, 4767, 4768, 4769, 4780, 4778, 4782, 4770, 4771, 4772, 4773, 4774, 4775, 4776, 4777, 4787, 4788, 4789, 4793, 4790, 4791, 4792, 4794, 4795, 4796, 4797, 4798, 4802, 4799, 4800, 4801, 9606, 9604, 9605, 9607, 9608)) 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) ASC 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 (3684, 4649, 4650, 9603, 4651, 4652, 4653, 4654, 4662, 4655, 4656, 4657, 4659, 4658, 4660, 4661, 4664, 4663, 4666, 4665, 4668, 4667, 4671, 4669, 4672, 4670, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4697, 4680, 4682, 4681, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4698, 4691, 4692, 4693, 4694, 4695, 4696, 4699, 4715, 4700, 4701, 4702, 4703, 4704, 4705, 4706, 4716, 4707, 4708, 4709, 4710, 4712, 4711, 4713, 4714, 4717, 4718, 4719, 4723, 4720, 4721, 4722, 4725, 4726, 4727, 4730, 4724, 4728, 4729, 4735, 4733, 4732, 4734, 4736, 4737, 4739, 4740, 4741, 4731, 4738, 4760, 4743, 4742, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4761, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4783, 4784, 4785, 4786, 4762, 4781, 4763, 4764, 4765, 4779, 4766, 4767, 4768, 4769, 4780, 4778, 4782, 4770, 4771, 4772, 4773, 4774, 4775, 4776, 4777, 4787, 4788, 4789, 4793, 4790, 4791, 4792, 4794, 4795, 4796, 4797, 4798, 4802, 4799, 4800, 4801, 9606, 9604, 9605, 9607, 9608) OR l.addl_category_id IN (3684, 4649, 4650, 9603, 4651, 4652, 4653, 4654, 4662, 4655, 4656, 4657, 4659, 4658, 4660, 4661, 4664, 4663, 4666, 4665, 4668, 4667, 4671, 4669, 4672, 4670, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4697, 4680, 4682, 4681, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4698, 4691, 4692, 4693, 4694, 4695, 4696, 4699, 4715, 4700, 4701, 4702, 4703, 4704, 4705, 4706, 4716, 4707, 4708, 4709, 4710, 4712, 4711, 4713, 4714, 4717, 4718, 4719, 4723, 4720, 4721, 4722, 4725, 4726, 4727, 4730, 4724, 4728, 4729, 4735, 4733, 4732, 4734, 4736, 4737, 4739, 4740, 4741, 4731, 4738, 4760, 4743, 4742, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4761, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4783, 4784, 4785, 4786, 4762, 4781, 4763, 4764, 4765, 4779, 4766, 4767, 4768, 4769, 4780, 4778, 4782, 4770, 4771, 4772, 4773, 4774, 4775, 4776, 4777, 4787, 4788, 4789, 4793, 4790, 4791, 4792, 4794, 4795, 4796, 4797, 4798, 4802, 4799, 4800, 4801, 9606, 9604, 9605, 9607, 9608)) 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) ASC LIMIT 20