[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 (3681, 4161, 4162, 4163, 4165, 4164, 4166, 4167, 4168, 4169, 4171, 4170, 4172, 4181, 4173, 4174, 4175, 4176, 4177, 4178, 4179, 4180, 4182, 4183, 4190, 4184, 4185, 4187, 4188, 4186, 4189, 4191, 4192, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4209, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4210, 4211, 4212, 4216, 4213, 4214, 4215, 4217, 4218, 4219, 4221, 4222, 4220, 4225, 4223, 4224, 4226, 4227, 4228, 4229, 4230, 4231, 4232, 4233, 4234, 4235, 4249, 4236, 4237, 4238, 4239, 4240, 4241, 4242, 4243, 4244, 4245, 4246, 4247, 4248, 4250, 4251, 4252, 4253, 4254, 4255, 4259, 4256, 4257, 4258, 4260, 4261, 4262, 4263, 4264, 4265, 4266, 4267, 4268, 4273, 4269, 4270, 4271, 4272, 4278, 4274, 4275, 4276, 4277, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4288, 4286, 4287, 4289, 4290, 4291, 4292, 4293, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303, 4301, 4302, 4304, 4305, 4306, 4307, 4308, 4309, 4310, 4322, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4323, 4324, 4325, 4326, 4327, 4328, 4339, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4340, 4341, 4342, 4343, 4344, 4350, 4345, 4346, 4347, 4348, 4349, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4362, 4359, 4360, 4361, 4363, 4365, 4364, 4366, 4367, 4368, 4375, 4369, 4370, 4371, 4372, 4373, 4374, 4376, 4377, 4378, 4379, 4380) OR l.addl_category_id IN (3681, 4161, 4162, 4163, 4165, 4164, 4166, 4167, 4168, 4169, 4171, 4170, 4172, 4181, 4173, 4174, 4175, 4176, 4177, 4178, 4179, 4180, 4182, 4183, 4190, 4184, 4185, 4187, 4188, 4186, 4189, 4191, 4192, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4209, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4210, 4211, 4212, 4216, 4213, 4214, 4215, 4217, 4218, 4219, 4221, 4222, 4220, 4225, 4223, 4224, 4226, 4227, 4228, 4229, 4230, 4231, 4232, 4233, 4234, 4235, 4249, 4236, 4237, 4238, 4239, 4240, 4241, 4242, 4243, 4244, 4245, 4246, 4247, 4248, 4250, 4251, 4252, 4253, 4254, 4255, 4259, 4256, 4257, 4258, 4260, 4261, 4262, 4263, 4264, 4265, 4266, 4267, 4268, 4273, 4269, 4270, 4271, 4272, 4278, 4274, 4275, 4276, 4277, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4288, 4286, 4287, 4289, 4290, 4291, 4292, 4293, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303, 4301, 4302, 4304, 4305, 4306, 4307, 4308, 4309, 4310, 4322, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4323, 4324, 4325, 4326, 4327, 4328, 4339, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4340, 4341, 4342, 4343, 4344, 4350, 4345, 4346, 4347, 4348, 4349, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4362, 4359, 4360, 4361, 4363, 4365, 4364, 4366, 4367, 4368, 4375, 4369, 4370, 4371, 4372, 4373, 4374, 4376, 4377, 4378, 4379, 4380)) 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 (3681, 4161, 4162, 4163, 4165, 4164, 4166, 4167, 4168, 4169, 4171, 4170, 4172, 4181, 4173, 4174, 4175, 4176, 4177, 4178, 4179, 4180, 4182, 4183, 4190, 4184, 4185, 4187, 4188, 4186, 4189, 4191, 4192, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4209, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4210, 4211, 4212, 4216, 4213, 4214, 4215, 4217, 4218, 4219, 4221, 4222, 4220, 4225, 4223, 4224, 4226, 4227, 4228, 4229, 4230, 4231, 4232, 4233, 4234, 4235, 4249, 4236, 4237, 4238, 4239, 4240, 4241, 4242, 4243, 4244, 4245, 4246, 4247, 4248, 4250, 4251, 4252, 4253, 4254, 4255, 4259, 4256, 4257, 4258, 4260, 4261, 4262, 4263, 4264, 4265, 4266, 4267, 4268, 4273, 4269, 4270, 4271, 4272, 4278, 4274, 4275, 4276, 4277, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4288, 4286, 4287, 4289, 4290, 4291, 4292, 4293, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303, 4301, 4302, 4304, 4305, 4306, 4307, 4308, 4309, 4310, 4322, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4323, 4324, 4325, 4326, 4327, 4328, 4339, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4340, 4341, 4342, 4343, 4344, 4350, 4345, 4346, 4347, 4348, 4349, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4362, 4359, 4360, 4361, 4363, 4365, 4364, 4366, 4367, 4368, 4375, 4369, 4370, 4371, 4372, 4373, 4374, 4376, 4377, 4378, 4379, 4380) OR l.addl_category_id IN (3681, 4161, 4162, 4163, 4165, 4164, 4166, 4167, 4168, 4169, 4171, 4170, 4172, 4181, 4173, 4174, 4175, 4176, 4177, 4178, 4179, 4180, 4182, 4183, 4190, 4184, 4185, 4187, 4188, 4186, 4189, 4191, 4192, 4193, 4194, 4195, 4196, 4197, 4198, 4199, 4200, 4201, 4209, 4202, 4203, 4204, 4205, 4206, 4207, 4208, 4210, 4211, 4212, 4216, 4213, 4214, 4215, 4217, 4218, 4219, 4221, 4222, 4220, 4225, 4223, 4224, 4226, 4227, 4228, 4229, 4230, 4231, 4232, 4233, 4234, 4235, 4249, 4236, 4237, 4238, 4239, 4240, 4241, 4242, 4243, 4244, 4245, 4246, 4247, 4248, 4250, 4251, 4252, 4253, 4254, 4255, 4259, 4256, 4257, 4258, 4260, 4261, 4262, 4263, 4264, 4265, 4266, 4267, 4268, 4273, 4269, 4270, 4271, 4272, 4278, 4274, 4275, 4276, 4277, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4288, 4286, 4287, 4289, 4290, 4291, 4292, 4293, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303, 4301, 4302, 4304, 4305, 4306, 4307, 4308, 4309, 4310, 4322, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4323, 4324, 4325, 4326, 4327, 4328, 4339, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4340, 4341, 4342, 4343, 4344, 4350, 4345, 4346, 4347, 4348, 4349, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4362, 4359, 4360, 4361, 4363, 4365, 4364, 4366, 4367, 4368, 4375, 4369, 4370, 4371, 4372, 4373, 4374, 4376, 4377, 4378, 4379, 4380)) 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