Browse Listings in Home, Furniture & DIY
.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 (3695, 9060, 9061, 9062, 9063, 9064, 9065, 9066, 9067, 9068, 9069, 9070, 9071, 9072, 9073, 9074, 9075, 9076, 9077, 9078, 9079, 9080, 9086, 9432, 9081, 9082, 9083, 9084, 9085, 9087, 9088, 9090, 9089, 9091, 9092, 9095, 9093, 9094, 9096, 9097, 9098, 9100, 9101, 9099, 9102, 9103, 9104, 9105, 9127, 9106, 9107, 9108, 9109, 9110, 9111, 9113, 9112, 9114, 9115, 9116, 9117, 9118, 9119, 9120, 9121, 9122, 9123, 9124, 9125, 9126, 9128, 9131, 9132, 9133, 9129, 9134, 9136, 9130, 9135, 9137, 9138, 9139, 9140, 9141, 9143, 9142, 9144, 9145, 9146, 9147, 9148, 9149, 9150, 9152, 9151, 9153, 9159, 9154, 9155, 9156, 9160, 9157, 9158, 9161, 9162, 9163, 9164, 9165, 9166, 9167, 9168, 9171, 9169, 9170, 9172, 9174, 9175, 9173, 9177, 9176, 9178, 9179, 9180, 9181, 9182, 9183, 9184, 9195, 9185, 9196, 9186, 9187, 9188, 9189, 9190, 9191, 9192, 9193, 9194, 9197, 9198, 9199, 9203, 9200, 9201, 9202, 9204, 9205, 9206, 9207, 9208, 9209, 9210, 9215, 9211, 9212, 9213, 9214, 9216, 9217, 9218, 9219, 9220, 9221, 9222, 9225, 9224, 9223, 9226, 9227, 9228, 9229, 9230, 9231, 9232, 9233, 9234, 9235, 9236, 9247, 9237, 9238, 9239, 9240, 9241, 9242, 9243, 9244, 9245, 9246, 9248, 9250, 9249, 9251, 9252, 9253, 9254, 9255, 9256, 9257, 9258, 9259, 9269, 9260, 9261, 9262, 9263, 9265, 9264, 9266, 9267, 9268, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9284, 9278, 9279, 9281, 9280, 9282, 9283, 9285, 9286, 9287, 9288, 9289, 9290, 9291, 9292, 9293, 9294, 9295, 9296, 9297, 9298, 9299, 9300, 9301, 9302, 9303, 9304, 9315, 9305, 9306, 9307, 9309, 9308, 9310, 9311, 9312, 9313, 9314, 9317, 9316, 9318, 9319, 9320, 9321, 9322, 9323, 9324, 9325, 9326, 9333, 9327, 9328, 9329, 9330, 9331, 9332, 9334, 9335, 9336, 9337, 9338, 9340, 9339, 9341, 9342, 9343, 9344, 9345, 9346, 9349, 9347, 9350, 9348, 9351, 9352, 9353, 9354, 9355, 9356, 9357, 9358, 9364, 9359, 9360, 9361, 9362, 9363, 9365, 9366, 9367, 9368, 9373, 9369, 9370, 9371, 9372, 9374, 9375, 9376, 9377, 9378, 9379, 9384, 9380, 9381, 9383, 9382, 9385, 9387, 9386, 9388, 9389, 9390, 9391, 9397, 9392, 9393, 9394, 9395, 9396, 9398, 9399, 9409, 9400, 9401, 9402, 9403, 9404, 9405, 9406, 9407, 9408, 9410, 9411, 9412, 9413, 9414, 9415, 9416, 9417, 9418, 9419, 9420, 9421, 9431, 9422, 9423, 9424, 9425, 9426, 9427, 9428, 9429, 9430) OR l.addl_category_id IN (3695, 9060, 9061, 9062, 9063, 9064, 9065, 9066, 9067, 9068, 9069, 9070, 9071, 9072, 9073, 9074, 9075, 9076, 9077, 9078, 9079, 9080, 9086, 9432, 9081, 9082, 9083, 9084, 9085, 9087, 9088, 9090, 9089, 9091, 9092, 9095, 9093, 9094, 9096, 9097, 9098, 9100, 9101, 9099, 9102, 9103, 9104, 9105, 9127, 9106, 9107, 9108, 9109, 9110, 9111, 9113, 9112, 9114, 9115, 9116, 9117, 9118, 9119, 9120, 9121, 9122, 9123, 9124, 9125, 9126, 9128, 9131, 9132, 9133, 9129, 9134, 9136, 9130, 9135, 9137, 9138, 9139, 9140, 9141, 9143, 9142, 9144, 9145, 9146, 9147, 9148, 9149, 9150, 9152, 9151, 9153, 9159, 9154, 9155, 9156, 9160, 9157, 9158, 9161, 9162, 9163, 9164, 9165, 9166, 9167, 9168, 9171, 9169, 9170, 9172, 9174, 9175, 9173, 9177, 9176, 9178, 9179, 9180, 9181, 9182, 9183, 9184, 9195, 9185, 9196, 9186, 9187, 9188, 9189, 9190, 9191, 9192, 9193, 9194, 9197, 9198, 9199, 9203, 9200, 9201, 9202, 9204, 9205, 9206, 9207, 9208, 9209, 9210, 9215, 9211, 9212, 9213, 9214, 9216, 9217, 9218, 9219, 9220, 9221, 9222, 9225, 9224, 9223, 9226, 9227, 9228, 9229, 9230, 9231, 9232, 9233, 9234, 9235, 9236, 9247, 9237, 9238, 9239, 9240, 9241, 9242, 9243, 9244, 9245, 9246, 9248, 9250, 9249, 9251, 9252, 9253, 9254, 9255, 9256, 9257, 9258, 9259, 9269, 9260, 9261, 9262, 9263, 9265, 9264, 9266, 9267, 9268, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9284, 9278, 9279, 9281, 9280, 9282, 9283, 9285, 9286, 9287, 9288, 9289, 9290, 9291, 9292, 9293, 9294, 9295, 9296, 9297, 9298, 9299, 9300, 9301, 9302, 9303, 9304, 9315, 9305, 9306, 9307, 9309, 9308, 9310, 9311, 9312, 9313, 9314, 9317, 9316, 9318, 9319, 9320, 9321, 9322, 9323, 9324, 9325, 9326, 9333, 9327, 9328, 9329, 9330, 9331, 9332, 9334, 9335, 9336, 9337, 9338, 9340, 9339, 9341, 9342, 9343, 9344, 9345, 9346, 9349, 9347, 9350, 9348, 9351, 9352, 9353, 9354, 9355, 9356, 9357, 9358, 9364, 9359, 9360, 9361, 9362, 9363, 9365, 9366, 9367, 9368, 9373, 9369, 9370, 9371, 9372, 9374, 9375, 9376, 9377, 9378, 9379, 9384, 9380, 9381, 9383, 9382, 9385, 9387, 9386, 9388, 9389, 9390, 9391, 9397, 9392, 9393, 9394, 9395, 9396, 9398, 9399, 9409, 9400, 9401, 9402, 9403, 9404, 9405, 9406, 9407, 9408, 9410, 9411, 9412, 9413, 9414, 9415, 9416, 9417, 9418, 9419, 9420, 9421, 9431, 9422, 9423, 9424, 9425, 9426, 9427, 9428, 9429, 9430)) 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 (3695, 9060, 9061, 9062, 9063, 9064, 9065, 9066, 9067, 9068, 9069, 9070, 9071, 9072, 9073, 9074, 9075, 9076, 9077, 9078, 9079, 9080, 9086, 9432, 9081, 9082, 9083, 9084, 9085, 9087, 9088, 9090, 9089, 9091, 9092, 9095, 9093, 9094, 9096, 9097, 9098, 9100, 9101, 9099, 9102, 9103, 9104, 9105, 9127, 9106, 9107, 9108, 9109, 9110, 9111, 9113, 9112, 9114, 9115, 9116, 9117, 9118, 9119, 9120, 9121, 9122, 9123, 9124, 9125, 9126, 9128, 9131, 9132, 9133, 9129, 9134, 9136, 9130, 9135, 9137, 9138, 9139, 9140, 9141, 9143, 9142, 9144, 9145, 9146, 9147, 9148, 9149, 9150, 9152, 9151, 9153, 9159, 9154, 9155, 9156, 9160, 9157, 9158, 9161, 9162, 9163, 9164, 9165, 9166, 9167, 9168, 9171, 9169, 9170, 9172, 9174, 9175, 9173, 9177, 9176, 9178, 9179, 9180, 9181, 9182, 9183, 9184, 9195, 9185, 9196, 9186, 9187, 9188, 9189, 9190, 9191, 9192, 9193, 9194, 9197, 9198, 9199, 9203, 9200, 9201, 9202, 9204, 9205, 9206, 9207, 9208, 9209, 9210, 9215, 9211, 9212, 9213, 9214, 9216, 9217, 9218, 9219, 9220, 9221, 9222, 9225, 9224, 9223, 9226, 9227, 9228, 9229, 9230, 9231, 9232, 9233, 9234, 9235, 9236, 9247, 9237, 9238, 9239, 9240, 9241, 9242, 9243, 9244, 9245, 9246, 9248, 9250, 9249, 9251, 9252, 9253, 9254, 9255, 9256, 9257, 9258, 9259, 9269, 9260, 9261, 9262, 9263, 9265, 9264, 9266, 9267, 9268, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9284, 9278, 9279, 9281, 9280, 9282, 9283, 9285, 9286, 9287, 9288, 9289, 9290, 9291, 9292, 9293, 9294, 9295, 9296, 9297, 9298, 9299, 9300, 9301, 9302, 9303, 9304, 9315, 9305, 9306, 9307, 9309, 9308, 9310, 9311, 9312, 9313, 9314, 9317, 9316, 9318, 9319, 9320, 9321, 9322, 9323, 9324, 9325, 9326, 9333, 9327, 9328, 9329, 9330, 9331, 9332, 9334, 9335, 9336, 9337, 9338, 9340, 9339, 9341, 9342, 9343, 9344, 9345, 9346, 9349, 9347, 9350, 9348, 9351, 9352, 9353, 9354, 9355, 9356, 9357, 9358, 9364, 9359, 9360, 9361, 9362, 9363, 9365, 9366, 9367, 9368, 9373, 9369, 9370, 9371, 9372, 9374, 9375, 9376, 9377, 9378, 9379, 9384, 9380, 9381, 9383, 9382, 9385, 9387, 9386, 9388, 9389, 9390, 9391, 9397, 9392, 9393, 9394, 9395, 9396, 9398, 9399, 9409, 9400, 9401, 9402, 9403, 9404, 9405, 9406, 9407, 9408, 9410, 9411, 9412, 9413, 9414, 9415, 9416, 9417, 9418, 9419, 9420, 9421, 9431, 9422, 9423, 9424, 9425, 9426, 9427, 9428, 9429, 9430) OR l.addl_category_id IN (3695, 9060, 9061, 9062, 9063, 9064, 9065, 9066, 9067, 9068, 9069, 9070, 9071, 9072, 9073, 9074, 9075, 9076, 9077, 9078, 9079, 9080, 9086, 9432, 9081, 9082, 9083, 9084, 9085, 9087, 9088, 9090, 9089, 9091, 9092, 9095, 9093, 9094, 9096, 9097, 9098, 9100, 9101, 9099, 9102, 9103, 9104, 9105, 9127, 9106, 9107, 9108, 9109, 9110, 9111, 9113, 9112, 9114, 9115, 9116, 9117, 9118, 9119, 9120, 9121, 9122, 9123, 9124, 9125, 9126, 9128, 9131, 9132, 9133, 9129, 9134, 9136, 9130, 9135, 9137, 9138, 9139, 9140, 9141, 9143, 9142, 9144, 9145, 9146, 9147, 9148, 9149, 9150, 9152, 9151, 9153, 9159, 9154, 9155, 9156, 9160, 9157, 9158, 9161, 9162, 9163, 9164, 9165, 9166, 9167, 9168, 9171, 9169, 9170, 9172, 9174, 9175, 9173, 9177, 9176, 9178, 9179, 9180, 9181, 9182, 9183, 9184, 9195, 9185, 9196, 9186, 9187, 9188, 9189, 9190, 9191, 9192, 9193, 9194, 9197, 9198, 9199, 9203, 9200, 9201, 9202, 9204, 9205, 9206, 9207, 9208, 9209, 9210, 9215, 9211, 9212, 9213, 9214, 9216, 9217, 9218, 9219, 9220, 9221, 9222, 9225, 9224, 9223, 9226, 9227, 9228, 9229, 9230, 9231, 9232, 9233, 9234, 9235, 9236, 9247, 9237, 9238, 9239, 9240, 9241, 9242, 9243, 9244, 9245, 9246, 9248, 9250, 9249, 9251, 9252, 9253, 9254, 9255, 9256, 9257, 9258, 9259, 9269, 9260, 9261, 9262, 9263, 9265, 9264, 9266, 9267, 9268, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9284, 9278, 9279, 9281, 9280, 9282, 9283, 9285, 9286, 9287, 9288, 9289, 9290, 9291, 9292, 9293, 9294, 9295, 9296, 9297, 9298, 9299, 9300, 9301, 9302, 9303, 9304, 9315, 9305, 9306, 9307, 9309, 9308, 9310, 9311, 9312, 9313, 9314, 9317, 9316, 9318, 9319, 9320, 9321, 9322, 9323, 9324, 9325, 9326, 9333, 9327, 9328, 9329, 9330, 9331, 9332, 9334, 9335, 9336, 9337, 9338, 9340, 9339, 9341, 9342, 9343, 9344, 9345, 9346, 9349, 9347, 9350, 9348, 9351, 9352, 9353, 9354, 9355, 9356, 9357, 9358, 9364, 9359, 9360, 9361, 9362, 9363, 9365, 9366, 9367, 9368, 9373, 9369, 9370, 9371, 9372, 9374, 9375, 9376, 9377, 9378, 9379, 9384, 9380, 9381, 9383, 9382, 9385, 9387, 9386, 9388, 9389, 9390, 9391, 9397, 9392, 9393, 9394, 9395, 9396, 9398, 9399, 9409, 9400, 9401, 9402, 9403, 9404, 9405, 9406, 9407, 9408, 9410, 9411, 9412, 9413, 9414, 9415, 9416, 9417, 9418, 9419, 9420, 9421, 9431, 9422, 9423, 9424, 9425, 9426, 9427, 9428, 9429, 9430)) 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