Browse Listings in Antiques
[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 (3677, 3712, 3720, 3741, 3755, 3774, 3782, 3783, 3789, 3795, 3805, 3806, 3807, 3813, 3857, 3845, 3851, 3824, 3828, 3831, 3713, 3718, 3714, 3715, 3716, 3719, 3717, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3733, 3734, 3735, 3740, 3736, 3737, 3738, 3739, 3742, 3743, 3744, 3745, 3746, 3747, 3748, 3749, 3754, 3750, 3751, 3752, 3753, 3756, 3758, 3759, 3757, 3760, 3761, 3762, 3763, 3764, 3765, 3773, 3766, 3767, 3768, 3769, 3770, 3771, 3772, 3775, 3776, 3777, 3778, 3781, 3779, 3780, 3784, 3785, 3786, 3787, 3788, 3790, 3791, 3792, 3793, 3794, 3796, 3797, 3798, 3799, 3804, 3800, 3801, 3802, 3803, 3808, 3809, 3810, 3811, 3812, 3814, 3815, 3816, 3817, 3818, 3823, 3819, 3820, 3821, 3822, 3825, 3827, 3826, 3829, 3830, 3832, 3833, 3834, 3835, 3836, 3844, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3846, 3847, 3848, 3849, 3850, 3852, 3853, 3854, 3855, 3856) OR l.addl_category_id IN (3677, 3712, 3720, 3741, 3755, 3774, 3782, 3783, 3789, 3795, 3805, 3806, 3807, 3813, 3857, 3845, 3851, 3824, 3828, 3831, 3713, 3718, 3714, 3715, 3716, 3719, 3717, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3733, 3734, 3735, 3740, 3736, 3737, 3738, 3739, 3742, 3743, 3744, 3745, 3746, 3747, 3748, 3749, 3754, 3750, 3751, 3752, 3753, 3756, 3758, 3759, 3757, 3760, 3761, 3762, 3763, 3764, 3765, 3773, 3766, 3767, 3768, 3769, 3770, 3771, 3772, 3775, 3776, 3777, 3778, 3781, 3779, 3780, 3784, 3785, 3786, 3787, 3788, 3790, 3791, 3792, 3793, 3794, 3796, 3797, 3798, 3799, 3804, 3800, 3801, 3802, 3803, 3808, 3809, 3810, 3811, 3812, 3814, 3815, 3816, 3817, 3818, 3823, 3819, 3820, 3821, 3822, 3825, 3827, 3826, 3829, 3830, 3832, 3833, 3834, 3835, 3836, 3844, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3846, 3847, 3848, 3849, 3850, 3852, 3853, 3854, 3855, 3856)) 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 10
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 (3677, 3712, 3720, 3741, 3755, 3774, 3782, 3783, 3789, 3795, 3805, 3806, 3807, 3813, 3857, 3845, 3851, 3824, 3828, 3831, 3713, 3718, 3714, 3715, 3716, 3719, 3717, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3733, 3734, 3735, 3740, 3736, 3737, 3738, 3739, 3742, 3743, 3744, 3745, 3746, 3747, 3748, 3749, 3754, 3750, 3751, 3752, 3753, 3756, 3758, 3759, 3757, 3760, 3761, 3762, 3763, 3764, 3765, 3773, 3766, 3767, 3768, 3769, 3770, 3771, 3772, 3775, 3776, 3777, 3778, 3781, 3779, 3780, 3784, 3785, 3786, 3787, 3788, 3790, 3791, 3792, 3793, 3794, 3796, 3797, 3798, 3799, 3804, 3800, 3801, 3802, 3803, 3808, 3809, 3810, 3811, 3812, 3814, 3815, 3816, 3817, 3818, 3823, 3819, 3820, 3821, 3822, 3825, 3827, 3826, 3829, 3830, 3832, 3833, 3834, 3835, 3836, 3844, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3846, 3847, 3848, 3849, 3850, 3852, 3853, 3854, 3855, 3856) OR l.addl_category_id IN (3677, 3712, 3720, 3741, 3755, 3774, 3782, 3783, 3789, 3795, 3805, 3806, 3807, 3813, 3857, 3845, 3851, 3824, 3828, 3831, 3713, 3718, 3714, 3715, 3716, 3719, 3717, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3733, 3734, 3735, 3740, 3736, 3737, 3738, 3739, 3742, 3743, 3744, 3745, 3746, 3747, 3748, 3749, 3754, 3750, 3751, 3752, 3753, 3756, 3758, 3759, 3757, 3760, 3761, 3762, 3763, 3764, 3765, 3773, 3766, 3767, 3768, 3769, 3770, 3771, 3772, 3775, 3776, 3777, 3778, 3781, 3779, 3780, 3784, 3785, 3786, 3787, 3788, 3790, 3791, 3792, 3793, 3794, 3796, 3797, 3798, 3799, 3804, 3800, 3801, 3802, 3803, 3808, 3809, 3810, 3811, 3812, 3814, 3815, 3816, 3817, 3818, 3823, 3819, 3820, 3821, 3822, 3825, 3827, 3826, 3829, 3830, 3832, 3833, 3834, 3835, 3836, 3844, 3837, 3838, 3839, 3840, 3841, 3842, 3843, 3846, 3847, 3848, 3849, 3850, 3852, 3853, 3854, 3855, 3856)) 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 10