Browse Listings in Sports Memorabilia
[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 (3705, 6685, 6702, 6703, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6701, 6696, 6697, 6698, 6699, 6700, 6704, 6705, 6706, 6710, 6707, 6708, 6709, 6725, 6726, 6730, 6727, 6728, 6729, 6731, 6732, 6733, 6734, 6735, 6742, 6736, 6737, 6738, 6739, 6740, 6741, 6743, 6744, 6745, 6746, 6747, 6748, 6749, 6750, 6751, 6752, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6781, 6792, 6785, 6782, 6787, 6786, 6783, 6779, 6780, 6793, 6788, 6789, 6784, 6790, 6791, 6794, 6795, 6799, 6800, 6798, 6796, 6797, 6801, 6802, 6803, 6804, 6806, 6813, 6807, 6808, 6809, 6810, 6805, 6811, 6812, 6814, 6815, 6816, 6817, 6818, 6819, 6824, 6820, 6821, 6822, 6823, 6825, 6826, 6827, 6831, 6828, 6829, 6830, 6832, 6833, 6834, 6835, 6841, 6836, 6837, 6838, 6839, 6840, 6844, 6846, 6847, 6843, 6855, 6854, 6842, 6849, 6853, 6851, 6850, 6852, 6857, 6848, 6845, 6856, 6858, 6859, 6867, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6868, 6869, 6870, 6878, 6871, 6872, 6873, 6874, 6875, 6876, 6877, 6879, 6880, 6881, 6883, 6882, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6899, 6894, 6896, 6895, 6897, 6898, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6914, 6909, 6910, 6911, 6912, 6913, 6711, 6712, 6713, 6717, 6714, 6715, 6716, 6724, 6723, 6722, 6718, 6721, 6720, 6719) OR l.addl_category_id IN (3705, 6685, 6702, 6703, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6701, 6696, 6697, 6698, 6699, 6700, 6704, 6705, 6706, 6710, 6707, 6708, 6709, 6725, 6726, 6730, 6727, 6728, 6729, 6731, 6732, 6733, 6734, 6735, 6742, 6736, 6737, 6738, 6739, 6740, 6741, 6743, 6744, 6745, 6746, 6747, 6748, 6749, 6750, 6751, 6752, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6781, 6792, 6785, 6782, 6787, 6786, 6783, 6779, 6780, 6793, 6788, 6789, 6784, 6790, 6791, 6794, 6795, 6799, 6800, 6798, 6796, 6797, 6801, 6802, 6803, 6804, 6806, 6813, 6807, 6808, 6809, 6810, 6805, 6811, 6812, 6814, 6815, 6816, 6817, 6818, 6819, 6824, 6820, 6821, 6822, 6823, 6825, 6826, 6827, 6831, 6828, 6829, 6830, 6832, 6833, 6834, 6835, 6841, 6836, 6837, 6838, 6839, 6840, 6844, 6846, 6847, 6843, 6855, 6854, 6842, 6849, 6853, 6851, 6850, 6852, 6857, 6848, 6845, 6856, 6858, 6859, 6867, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6868, 6869, 6870, 6878, 6871, 6872, 6873, 6874, 6875, 6876, 6877, 6879, 6880, 6881, 6883, 6882, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6899, 6894, 6896, 6895, 6897, 6898, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6914, 6909, 6910, 6911, 6912, 6913, 6711, 6712, 6713, 6717, 6714, 6715, 6716, 6724, 6723, 6722, 6718, 6721, 6720, 6719)) 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 (3705, 6685, 6702, 6703, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6701, 6696, 6697, 6698, 6699, 6700, 6704, 6705, 6706, 6710, 6707, 6708, 6709, 6725, 6726, 6730, 6727, 6728, 6729, 6731, 6732, 6733, 6734, 6735, 6742, 6736, 6737, 6738, 6739, 6740, 6741, 6743, 6744, 6745, 6746, 6747, 6748, 6749, 6750, 6751, 6752, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6781, 6792, 6785, 6782, 6787, 6786, 6783, 6779, 6780, 6793, 6788, 6789, 6784, 6790, 6791, 6794, 6795, 6799, 6800, 6798, 6796, 6797, 6801, 6802, 6803, 6804, 6806, 6813, 6807, 6808, 6809, 6810, 6805, 6811, 6812, 6814, 6815, 6816, 6817, 6818, 6819, 6824, 6820, 6821, 6822, 6823, 6825, 6826, 6827, 6831, 6828, 6829, 6830, 6832, 6833, 6834, 6835, 6841, 6836, 6837, 6838, 6839, 6840, 6844, 6846, 6847, 6843, 6855, 6854, 6842, 6849, 6853, 6851, 6850, 6852, 6857, 6848, 6845, 6856, 6858, 6859, 6867, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6868, 6869, 6870, 6878, 6871, 6872, 6873, 6874, 6875, 6876, 6877, 6879, 6880, 6881, 6883, 6882, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6899, 6894, 6896, 6895, 6897, 6898, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6914, 6909, 6910, 6911, 6912, 6913, 6711, 6712, 6713, 6717, 6714, 6715, 6716, 6724, 6723, 6722, 6718, 6721, 6720, 6719) OR l.addl_category_id IN (3705, 6685, 6702, 6703, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6701, 6696, 6697, 6698, 6699, 6700, 6704, 6705, 6706, 6710, 6707, 6708, 6709, 6725, 6726, 6730, 6727, 6728, 6729, 6731, 6732, 6733, 6734, 6735, 6742, 6736, 6737, 6738, 6739, 6740, 6741, 6743, 6744, 6745, 6746, 6747, 6748, 6749, 6750, 6751, 6752, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6781, 6792, 6785, 6782, 6787, 6786, 6783, 6779, 6780, 6793, 6788, 6789, 6784, 6790, 6791, 6794, 6795, 6799, 6800, 6798, 6796, 6797, 6801, 6802, 6803, 6804, 6806, 6813, 6807, 6808, 6809, 6810, 6805, 6811, 6812, 6814, 6815, 6816, 6817, 6818, 6819, 6824, 6820, 6821, 6822, 6823, 6825, 6826, 6827, 6831, 6828, 6829, 6830, 6832, 6833, 6834, 6835, 6841, 6836, 6837, 6838, 6839, 6840, 6844, 6846, 6847, 6843, 6855, 6854, 6842, 6849, 6853, 6851, 6850, 6852, 6857, 6848, 6845, 6856, 6858, 6859, 6867, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6868, 6869, 6870, 6878, 6871, 6872, 6873, 6874, 6875, 6876, 6877, 6879, 6880, 6881, 6883, 6882, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6899, 6894, 6896, 6895, 6897, 6898, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6914, 6909, 6910, 6911, 6912, 6913, 6711, 6712, 6713, 6717, 6714, 6715, 6716, 6724, 6723, 6722, 6718, 6721, 6720, 6719)) 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