Browse Listings in Vehicle Parts & Accessories

[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 (3708, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6203, 6410, 6204, 6205, 6206, 6207, 6208, 6212, 6210, 6211, 6209, 6217, 6213, 6214, 6215, 6216, 6218, 6219, 6220, 6221, 6222, 6223, 6224, 6225, 6228, 6226, 6227, 6229, 6230, 6231, 6232, 6233, 6235, 6234, 6299, 6236, 6237, 6238, 6239, 6240, 6241, 6242, 6300, 6243, 6244, 6245, 6246, 6247, 6248, 6249, 6250, 6251, 6252, 6254, 6253, 6255, 6298, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6266, 6265, 6267, 6268, 6269, 6270, 6301, 6271, 6304, 6302, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6282, 6281, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6303, 6291, 6293, 6292, 6294, 6295, 6296, 6297, 6305, 6306, 6307, 6308, 6309, 6310, 6311, 6312, 6313, 6314, 6315, 6316, 6317, 6323, 6318, 6319, 6320, 6321, 6322, 6326, 6324, 6325, 6328, 6327, 6329, 6336, 6332, 6333, 6334, 6330, 6335, 6331, 6338, 6337, 6339, 6341, 6340, 6342, 6343, 6344, 6345, 6349, 6346, 6347, 6348, 6350, 6351, 6352, 6353, 6354, 6360, 6355, 6356, 6357, 6358, 6359, 6361, 6362, 6363, 6364, 6365, 6366, 6367, 6368, 6369, 6377, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6378, 6379, 6380, 6385, 6383, 6381, 6382, 6384, 6386, 6387, 6388, 6389, 6390, 6391, 6392, 6393, 6394, 6395, 6396, 6397, 6398, 6399, 6400, 6405, 6401, 6402, 6403, 6404, 6406, 6407, 6408, 6409) OR l.addl_category_id IN (3708, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6203, 6410, 6204, 6205, 6206, 6207, 6208, 6212, 6210, 6211, 6209, 6217, 6213, 6214, 6215, 6216, 6218, 6219, 6220, 6221, 6222, 6223, 6224, 6225, 6228, 6226, 6227, 6229, 6230, 6231, 6232, 6233, 6235, 6234, 6299, 6236, 6237, 6238, 6239, 6240, 6241, 6242, 6300, 6243, 6244, 6245, 6246, 6247, 6248, 6249, 6250, 6251, 6252, 6254, 6253, 6255, 6298, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6266, 6265, 6267, 6268, 6269, 6270, 6301, 6271, 6304, 6302, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6282, 6281, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6303, 6291, 6293, 6292, 6294, 6295, 6296, 6297, 6305, 6306, 6307, 6308, 6309, 6310, 6311, 6312, 6313, 6314, 6315, 6316, 6317, 6323, 6318, 6319, 6320, 6321, 6322, 6326, 6324, 6325, 6328, 6327, 6329, 6336, 6332, 6333, 6334, 6330, 6335, 6331, 6338, 6337, 6339, 6341, 6340, 6342, 6343, 6344, 6345, 6349, 6346, 6347, 6348, 6350, 6351, 6352, 6353, 6354, 6360, 6355, 6356, 6357, 6358, 6359, 6361, 6362, 6363, 6364, 6365, 6366, 6367, 6368, 6369, 6377, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6378, 6379, 6380, 6385, 6383, 6381, 6382, 6384, 6386, 6387, 6388, 6389, 6390, 6391, 6392, 6393, 6394, 6395, 6396, 6397, 6398, 6399, 6400, 6405, 6401, 6402, 6403, 6404, 6406, 6407, 6408, 6409)) 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