Browse Listings in Stamps
.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 (3706, 5565, 5566, 5567, 5568, 5569, 5570, 5571, 5564, 5572, 5573, 5574, 5580, 5578, 5579, 5577, 5575, 5576, 5587, 5601, 5588, 5589, 5583, 5585, 5581, 5590, 5591, 5584, 5582, 5592, 5593, 5602, 5594, 5595, 5596, 5597, 5598, 5599, 5600, 5586, 5603, 5604, 5605, 5606, 5607, 5608, 5609, 5610, 5611, 5612, 5652, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5625, 5626, 5627, 5628, 5629, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5653, 5638, 5639, 5640, 5641, 5642, 5643, 5644, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5654, 5655, 5656, 5657, 5658, 5659, 5660, 5686, 5661, 5662, 5663, 5664, 5665, 5666, 5667, 5668, 5669, 5670, 5671, 5672, 5673, 5674, 5687, 5675, 5676, 5677, 5678, 5679, 5680, 5681, 5682, 5683, 5684, 5685, 5688, 5701, 5689, 5690, 5691, 5692, 5693, 5702, 5694, 5695, 5696, 5697, 5698, 5699, 5700, 5703, 5704, 5705, 5706, 5707, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5724, 5778, 5725, 5726, 5727, 5728, 5729, 5730, 5731, 5732, 5733, 5734, 5735, 5736, 5737, 5738, 5739, 5740, 5741, 5742, 5743, 5744, 5745, 5746, 5747, 5748, 5749, 5750, 5751, 5752, 5753, 5754, 5779, 5755, 5756, 5757, 5758, 5763, 5764, 5765, 5766, 5767, 5768, 5769, 5770, 5771, 5759, 5760, 5761, 5762, 5772, 5773, 5774, 5775, 5776, 5777, 5780, 5781, 5782, 5794, 5783, 5784, 5785, 5786, 5787, 5788, 5795, 5789, 5790, 5791, 5792, 5793, 5796, 5797, 5798, 5799, 5800, 5815, 5801, 5802, 5803, 5804, 5805, 5806, 5807, 5808, 5816, 5809, 5810, 5811, 5812, 5813, 5814, 5818, 5819, 5820, 5821, 5822, 5823, 5824, 5825, 5866, 5826, 5827, 5828, 5829, 5830, 5817, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5850, 5867, 5851, 5852, 5853, 5854, 5855, 5856, 5857, 5858, 5859, 5860, 5861, 5862, 5863, 5864, 5865, 5868, 5869, 5883, 5870, 5871, 5872, 5873, 5874, 5875, 5876, 5884, 5877, 5878, 5879, 5880, 5881, 5882, 5885, 5886, 5889, 5891, 5890, 5887, 5888, 5892, 5901, 5893, 5894, 5895, 5902, 5896, 5897, 5898, 5899, 5900, 5909, 5903, 5904, 5910, 5905, 5906, 5907, 5908, 5911, 5912, 5913, 5914, 5927, 5915, 5916, 5917, 5918, 5928, 5919, 5920, 5921, 5922, 5923, 5924, 5925, 5926, 5929, 5930, 5931, 5934, 5932, 5933, 5935, 5936, 5941, 5937, 5938, 5939, 5940) OR l.addl_category_id IN (3706, 5565, 5566, 5567, 5568, 5569, 5570, 5571, 5564, 5572, 5573, 5574, 5580, 5578, 5579, 5577, 5575, 5576, 5587, 5601, 5588, 5589, 5583, 5585, 5581, 5590, 5591, 5584, 5582, 5592, 5593, 5602, 5594, 5595, 5596, 5597, 5598, 5599, 5600, 5586, 5603, 5604, 5605, 5606, 5607, 5608, 5609, 5610, 5611, 5612, 5652, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5625, 5626, 5627, 5628, 5629, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5653, 5638, 5639, 5640, 5641, 5642, 5643, 5644, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5654, 5655, 5656, 5657, 5658, 5659, 5660, 5686, 5661, 5662, 5663, 5664, 5665, 5666, 5667, 5668, 5669, 5670, 5671, 5672, 5673, 5674, 5687, 5675, 5676, 5677, 5678, 5679, 5680, 5681, 5682, 5683, 5684, 5685, 5688, 5701, 5689, 5690, 5691, 5692, 5693, 5702, 5694, 5695, 5696, 5697, 5698, 5699, 5700, 5703, 5704, 5705, 5706, 5707, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5724, 5778, 5725, 5726, 5727, 5728, 5729, 5730, 5731, 5732, 5733, 5734, 5735, 5736, 5737, 5738, 5739, 5740, 5741, 5742, 5743, 5744, 5745, 5746, 5747, 5748, 5749, 5750, 5751, 5752, 5753, 5754, 5779, 5755, 5756, 5757, 5758, 5763, 5764, 5765, 5766, 5767, 5768, 5769, 5770, 5771, 5759, 5760, 5761, 5762, 5772, 5773, 5774, 5775, 5776, 5777, 5780, 5781, 5782, 5794, 5783, 5784, 5785, 5786, 5787, 5788, 5795, 5789, 5790, 5791, 5792, 5793, 5796, 5797, 5798, 5799, 5800, 5815, 5801, 5802, 5803, 5804, 5805, 5806, 5807, 5808, 5816, 5809, 5810, 5811, 5812, 5813, 5814, 5818, 5819, 5820, 5821, 5822, 5823, 5824, 5825, 5866, 5826, 5827, 5828, 5829, 5830, 5817, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5850, 5867, 5851, 5852, 5853, 5854, 5855, 5856, 5857, 5858, 5859, 5860, 5861, 5862, 5863, 5864, 5865, 5868, 5869, 5883, 5870, 5871, 5872, 5873, 5874, 5875, 5876, 5884, 5877, 5878, 5879, 5880, 5881, 5882, 5885, 5886, 5889, 5891, 5890, 5887, 5888, 5892, 5901, 5893, 5894, 5895, 5902, 5896, 5897, 5898, 5899, 5900, 5909, 5903, 5904, 5910, 5905, 5906, 5907, 5908, 5911, 5912, 5913, 5914, 5927, 5915, 5916, 5917, 5918, 5928, 5919, 5920, 5921, 5922, 5923, 5924, 5925, 5926, 5929, 5930, 5931, 5934, 5932, 5933, 5935, 5936, 5941, 5937, 5938, 5939, 5940)) 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 (3706, 5565, 5566, 5567, 5568, 5569, 5570, 5571, 5564, 5572, 5573, 5574, 5580, 5578, 5579, 5577, 5575, 5576, 5587, 5601, 5588, 5589, 5583, 5585, 5581, 5590, 5591, 5584, 5582, 5592, 5593, 5602, 5594, 5595, 5596, 5597, 5598, 5599, 5600, 5586, 5603, 5604, 5605, 5606, 5607, 5608, 5609, 5610, 5611, 5612, 5652, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5625, 5626, 5627, 5628, 5629, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5653, 5638, 5639, 5640, 5641, 5642, 5643, 5644, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5654, 5655, 5656, 5657, 5658, 5659, 5660, 5686, 5661, 5662, 5663, 5664, 5665, 5666, 5667, 5668, 5669, 5670, 5671, 5672, 5673, 5674, 5687, 5675, 5676, 5677, 5678, 5679, 5680, 5681, 5682, 5683, 5684, 5685, 5688, 5701, 5689, 5690, 5691, 5692, 5693, 5702, 5694, 5695, 5696, 5697, 5698, 5699, 5700, 5703, 5704, 5705, 5706, 5707, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5724, 5778, 5725, 5726, 5727, 5728, 5729, 5730, 5731, 5732, 5733, 5734, 5735, 5736, 5737, 5738, 5739, 5740, 5741, 5742, 5743, 5744, 5745, 5746, 5747, 5748, 5749, 5750, 5751, 5752, 5753, 5754, 5779, 5755, 5756, 5757, 5758, 5763, 5764, 5765, 5766, 5767, 5768, 5769, 5770, 5771, 5759, 5760, 5761, 5762, 5772, 5773, 5774, 5775, 5776, 5777, 5780, 5781, 5782, 5794, 5783, 5784, 5785, 5786, 5787, 5788, 5795, 5789, 5790, 5791, 5792, 5793, 5796, 5797, 5798, 5799, 5800, 5815, 5801, 5802, 5803, 5804, 5805, 5806, 5807, 5808, 5816, 5809, 5810, 5811, 5812, 5813, 5814, 5818, 5819, 5820, 5821, 5822, 5823, 5824, 5825, 5866, 5826, 5827, 5828, 5829, 5830, 5817, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5850, 5867, 5851, 5852, 5853, 5854, 5855, 5856, 5857, 5858, 5859, 5860, 5861, 5862, 5863, 5864, 5865, 5868, 5869, 5883, 5870, 5871, 5872, 5873, 5874, 5875, 5876, 5884, 5877, 5878, 5879, 5880, 5881, 5882, 5885, 5886, 5889, 5891, 5890, 5887, 5888, 5892, 5901, 5893, 5894, 5895, 5902, 5896, 5897, 5898, 5899, 5900, 5909, 5903, 5904, 5910, 5905, 5906, 5907, 5908, 5911, 5912, 5913, 5914, 5927, 5915, 5916, 5917, 5918, 5928, 5919, 5920, 5921, 5922, 5923, 5924, 5925, 5926, 5929, 5930, 5931, 5934, 5932, 5933, 5935, 5936, 5941, 5937, 5938, 5939, 5940) OR l.addl_category_id IN (3706, 5565, 5566, 5567, 5568, 5569, 5570, 5571, 5564, 5572, 5573, 5574, 5580, 5578, 5579, 5577, 5575, 5576, 5587, 5601, 5588, 5589, 5583, 5585, 5581, 5590, 5591, 5584, 5582, 5592, 5593, 5602, 5594, 5595, 5596, 5597, 5598, 5599, 5600, 5586, 5603, 5604, 5605, 5606, 5607, 5608, 5609, 5610, 5611, 5612, 5652, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5625, 5626, 5627, 5628, 5629, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5653, 5638, 5639, 5640, 5641, 5642, 5643, 5644, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5654, 5655, 5656, 5657, 5658, 5659, 5660, 5686, 5661, 5662, 5663, 5664, 5665, 5666, 5667, 5668, 5669, 5670, 5671, 5672, 5673, 5674, 5687, 5675, 5676, 5677, 5678, 5679, 5680, 5681, 5682, 5683, 5684, 5685, 5688, 5701, 5689, 5690, 5691, 5692, 5693, 5702, 5694, 5695, 5696, 5697, 5698, 5699, 5700, 5703, 5704, 5705, 5706, 5707, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5724, 5778, 5725, 5726, 5727, 5728, 5729, 5730, 5731, 5732, 5733, 5734, 5735, 5736, 5737, 5738, 5739, 5740, 5741, 5742, 5743, 5744, 5745, 5746, 5747, 5748, 5749, 5750, 5751, 5752, 5753, 5754, 5779, 5755, 5756, 5757, 5758, 5763, 5764, 5765, 5766, 5767, 5768, 5769, 5770, 5771, 5759, 5760, 5761, 5762, 5772, 5773, 5774, 5775, 5776, 5777, 5780, 5781, 5782, 5794, 5783, 5784, 5785, 5786, 5787, 5788, 5795, 5789, 5790, 5791, 5792, 5793, 5796, 5797, 5798, 5799, 5800, 5815, 5801, 5802, 5803, 5804, 5805, 5806, 5807, 5808, 5816, 5809, 5810, 5811, 5812, 5813, 5814, 5818, 5819, 5820, 5821, 5822, 5823, 5824, 5825, 5866, 5826, 5827, 5828, 5829, 5830, 5817, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5850, 5867, 5851, 5852, 5853, 5854, 5855, 5856, 5857, 5858, 5859, 5860, 5861, 5862, 5863, 5864, 5865, 5868, 5869, 5883, 5870, 5871, 5872, 5873, 5874, 5875, 5876, 5884, 5877, 5878, 5879, 5880, 5881, 5882, 5885, 5886, 5889, 5891, 5890, 5887, 5888, 5892, 5901, 5893, 5894, 5895, 5902, 5896, 5897, 5898, 5899, 5900, 5909, 5903, 5904, 5910, 5905, 5906, 5907, 5908, 5911, 5912, 5913, 5914, 5927, 5915, 5916, 5917, 5918, 5928, 5919, 5920, 5921, 5922, 5923, 5924, 5925, 5926, 5929, 5930, 5931, 5934, 5932, 5933, 5935, 5936, 5941, 5937, 5938, 5939, 5940)) 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