Browse Listings in Toys & Games
.png)
[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 (3707, 6411, 6412, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6431, 6422, 6423, 6424, 6425, 6637, 6426, 6427, 6428, 6429, 6430, 6432, 6433, 6434, 6435, 6436, 6437, 6438, 6439, 6443, 6440, 6441, 6442, 6444, 6445, 6455, 6446, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6456, 6457, 6458, 6459, 6460, 6461, 6462, 6465, 6463, 6464, 6466, 6467, 6468, 6469, 6470, 6471, 6472, 6473, 6474, 6475, 6476, 6477, 6540, 6478, 6479, 6480, 6481, 6482, 6483, 6484, 6485, 6486, 6487, 6488, 6489, 6490, 6491, 6492, 6493, 6494, 6495, 6496, 6497, 6498, 6499, 6500, 6501, 6502, 6503, 6541, 6504, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6542, 6515, 6516, 6517, 6518, 6519, 6520, 6521, 6522, 6523, 6524, 6525, 6526, 6527, 6528, 6529, 6530, 6532, 6531, 6533, 6534, 6539, 6535, 6536, 6537, 6538, 6543, 6544, 6545, 6546, 6547, 6548, 6553, 6549, 6550, 6551, 6552, 6554, 6555, 6556, 6557, 6558, 6559, 6561, 6560, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6570, 6571, 6578, 6572, 6573, 6574, 6579, 6575, 6576, 6577, 6580, 6584, 6581, 6582, 6583, 6588, 6585, 6590, 6589, 6586, 6587, 6591, 6592, 6593, 6594, 6595, 6596, 6597, 6598, 6599, 6616, 6600, 6601, 6602, 6603, 6604, 6605, 6606, 6607, 6608, 6609, 6610, 6611, 6612, 6613, 6614, 6615, 6617, 6618, 6619, 6620, 6621, 6622, 6628, 6623, 6624, 6625, 6627, 6626, 6629, 6630, 6631, 6632, 6633, 6636, 6634, 6635, 6643, 6644, 6645, 6646, 6647, 6648, 6649, 6650, 6651, 6655, 6652, 6653, 6654, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6672, 6665, 6666, 6667, 6668, 6669, 6670, 6671, 6673, 6674, 6683, 6675, 6684, 6676, 6682, 6677, 6678, 6679, 6680, 6681, 6640, 6638, 6642, 6639, 6641) OR l.addl_category_id IN (3707, 6411, 6412, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6431, 6422, 6423, 6424, 6425, 6637, 6426, 6427, 6428, 6429, 6430, 6432, 6433, 6434, 6435, 6436, 6437, 6438, 6439, 6443, 6440, 6441, 6442, 6444, 6445, 6455, 6446, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6456, 6457, 6458, 6459, 6460, 6461, 6462, 6465, 6463, 6464, 6466, 6467, 6468, 6469, 6470, 6471, 6472, 6473, 6474, 6475, 6476, 6477, 6540, 6478, 6479, 6480, 6481, 6482, 6483, 6484, 6485, 6486, 6487, 6488, 6489, 6490, 6491, 6492, 6493, 6494, 6495, 6496, 6497, 6498, 6499, 6500, 6501, 6502, 6503, 6541, 6504, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6542, 6515, 6516, 6517, 6518, 6519, 6520, 6521, 6522, 6523, 6524, 6525, 6526, 6527, 6528, 6529, 6530, 6532, 6531, 6533, 6534, 6539, 6535, 6536, 6537, 6538, 6543, 6544, 6545, 6546, 6547, 6548, 6553, 6549, 6550, 6551, 6552, 6554, 6555, 6556, 6557, 6558, 6559, 6561, 6560, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6570, 6571, 6578, 6572, 6573, 6574, 6579, 6575, 6576, 6577, 6580, 6584, 6581, 6582, 6583, 6588, 6585, 6590, 6589, 6586, 6587, 6591, 6592, 6593, 6594, 6595, 6596, 6597, 6598, 6599, 6616, 6600, 6601, 6602, 6603, 6604, 6605, 6606, 6607, 6608, 6609, 6610, 6611, 6612, 6613, 6614, 6615, 6617, 6618, 6619, 6620, 6621, 6622, 6628, 6623, 6624, 6625, 6627, 6626, 6629, 6630, 6631, 6632, 6633, 6636, 6634, 6635, 6643, 6644, 6645, 6646, 6647, 6648, 6649, 6650, 6651, 6655, 6652, 6653, 6654, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6672, 6665, 6666, 6667, 6668, 6669, 6670, 6671, 6673, 6674, 6683, 6675, 6684, 6676, 6682, 6677, 6678, 6679, 6680, 6681, 6640, 6638, 6642, 6639, 6641)) 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 (3707, 6411, 6412, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6431, 6422, 6423, 6424, 6425, 6637, 6426, 6427, 6428, 6429, 6430, 6432, 6433, 6434, 6435, 6436, 6437, 6438, 6439, 6443, 6440, 6441, 6442, 6444, 6445, 6455, 6446, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6456, 6457, 6458, 6459, 6460, 6461, 6462, 6465, 6463, 6464, 6466, 6467, 6468, 6469, 6470, 6471, 6472, 6473, 6474, 6475, 6476, 6477, 6540, 6478, 6479, 6480, 6481, 6482, 6483, 6484, 6485, 6486, 6487, 6488, 6489, 6490, 6491, 6492, 6493, 6494, 6495, 6496, 6497, 6498, 6499, 6500, 6501, 6502, 6503, 6541, 6504, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6542, 6515, 6516, 6517, 6518, 6519, 6520, 6521, 6522, 6523, 6524, 6525, 6526, 6527, 6528, 6529, 6530, 6532, 6531, 6533, 6534, 6539, 6535, 6536, 6537, 6538, 6543, 6544, 6545, 6546, 6547, 6548, 6553, 6549, 6550, 6551, 6552, 6554, 6555, 6556, 6557, 6558, 6559, 6561, 6560, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6570, 6571, 6578, 6572, 6573, 6574, 6579, 6575, 6576, 6577, 6580, 6584, 6581, 6582, 6583, 6588, 6585, 6590, 6589, 6586, 6587, 6591, 6592, 6593, 6594, 6595, 6596, 6597, 6598, 6599, 6616, 6600, 6601, 6602, 6603, 6604, 6605, 6606, 6607, 6608, 6609, 6610, 6611, 6612, 6613, 6614, 6615, 6617, 6618, 6619, 6620, 6621, 6622, 6628, 6623, 6624, 6625, 6627, 6626, 6629, 6630, 6631, 6632, 6633, 6636, 6634, 6635, 6643, 6644, 6645, 6646, 6647, 6648, 6649, 6650, 6651, 6655, 6652, 6653, 6654, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6672, 6665, 6666, 6667, 6668, 6669, 6670, 6671, 6673, 6674, 6683, 6675, 6684, 6676, 6682, 6677, 6678, 6679, 6680, 6681, 6640, 6638, 6642, 6639, 6641) OR l.addl_category_id IN (3707, 6411, 6412, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6431, 6422, 6423, 6424, 6425, 6637, 6426, 6427, 6428, 6429, 6430, 6432, 6433, 6434, 6435, 6436, 6437, 6438, 6439, 6443, 6440, 6441, 6442, 6444, 6445, 6455, 6446, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6456, 6457, 6458, 6459, 6460, 6461, 6462, 6465, 6463, 6464, 6466, 6467, 6468, 6469, 6470, 6471, 6472, 6473, 6474, 6475, 6476, 6477, 6540, 6478, 6479, 6480, 6481, 6482, 6483, 6484, 6485, 6486, 6487, 6488, 6489, 6490, 6491, 6492, 6493, 6494, 6495, 6496, 6497, 6498, 6499, 6500, 6501, 6502, 6503, 6541, 6504, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6542, 6515, 6516, 6517, 6518, 6519, 6520, 6521, 6522, 6523, 6524, 6525, 6526, 6527, 6528, 6529, 6530, 6532, 6531, 6533, 6534, 6539, 6535, 6536, 6537, 6538, 6543, 6544, 6545, 6546, 6547, 6548, 6553, 6549, 6550, 6551, 6552, 6554, 6555, 6556, 6557, 6558, 6559, 6561, 6560, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6570, 6571, 6578, 6572, 6573, 6574, 6579, 6575, 6576, 6577, 6580, 6584, 6581, 6582, 6583, 6588, 6585, 6590, 6589, 6586, 6587, 6591, 6592, 6593, 6594, 6595, 6596, 6597, 6598, 6599, 6616, 6600, 6601, 6602, 6603, 6604, 6605, 6606, 6607, 6608, 6609, 6610, 6611, 6612, 6613, 6614, 6615, 6617, 6618, 6619, 6620, 6621, 6622, 6628, 6623, 6624, 6625, 6627, 6626, 6629, 6630, 6631, 6632, 6633, 6636, 6634, 6635, 6643, 6644, 6645, 6646, 6647, 6648, 6649, 6650, 6651, 6655, 6652, 6653, 6654, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6672, 6665, 6666, 6667, 6668, 6669, 6670, 6671, 6673, 6674, 6683, 6675, 6684, 6676, 6682, 6677, 6678, 6679, 6680, 6681, 6640, 6638, 6642, 6639, 6641)) 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