[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 (3687, 7330, 7331, 7328, 7332, 7333, 7334, 7326, 7325, 7335, 7329, 7327, 7340, 7336, 7342, 7337, 7338, 7339, 7341, 7355, 7356, 7359, 7357, 7358, 7344, 7343, 7345, 7346, 7347, 7348, 7349, 7354, 7350, 7351, 7352, 7353, 7360, 7361, 7362, 7363, 7364, 7365, 7366, 7367, 7368, 7369, 7370, 7371, 7372, 7373, 7374, 7375, 7376, 7377, 7378, 7387, 7379, 7380, 7381, 7382, 7383, 7384, 7385, 7386, 7400, 7388, 7389, 7391, 7390, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7409, 7410, 7408, 7414, 7411, 7412, 7413, 7415, 7416, 7417, 7418, 7419, 7420, 7423, 7421, 7422, 7424, 7426, 7425, 7427, 7428, 7429, 7435, 7430, 7432, 7431, 7433, 7434, 7436, 7437, 7439, 7438, 7448, 7440, 7441, 7442, 7443, 7444, 7445, 7446, 7447, 7449, 7452, 7450, 7451, 7454, 7453, 7457, 7458, 7459, 7455, 7461, 7460, 7456, 7467, 7462, 7463, 7464, 7465, 7466, 7468, 7469, 7470, 7471, 7472, 7473, 7478, 7474, 7475, 7476, 7477, 7482, 7479, 7481, 7480) OR l.addl_category_id IN (3687, 7330, 7331, 7328, 7332, 7333, 7334, 7326, 7325, 7335, 7329, 7327, 7340, 7336, 7342, 7337, 7338, 7339, 7341, 7355, 7356, 7359, 7357, 7358, 7344, 7343, 7345, 7346, 7347, 7348, 7349, 7354, 7350, 7351, 7352, 7353, 7360, 7361, 7362, 7363, 7364, 7365, 7366, 7367, 7368, 7369, 7370, 7371, 7372, 7373, 7374, 7375, 7376, 7377, 7378, 7387, 7379, 7380, 7381, 7382, 7383, 7384, 7385, 7386, 7400, 7388, 7389, 7391, 7390, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7409, 7410, 7408, 7414, 7411, 7412, 7413, 7415, 7416, 7417, 7418, 7419, 7420, 7423, 7421, 7422, 7424, 7426, 7425, 7427, 7428, 7429, 7435, 7430, 7432, 7431, 7433, 7434, 7436, 7437, 7439, 7438, 7448, 7440, 7441, 7442, 7443, 7444, 7445, 7446, 7447, 7449, 7452, 7450, 7451, 7454, 7453, 7457, 7458, 7459, 7455, 7461, 7460, 7456, 7467, 7462, 7463, 7464, 7465, 7466, 7468, 7469, 7470, 7471, 7472, 7473, 7478, 7474, 7475, 7476, 7477, 7482, 7479, 7481, 7480)) 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 20
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 (3687, 7330, 7331, 7328, 7332, 7333, 7334, 7326, 7325, 7335, 7329, 7327, 7340, 7336, 7342, 7337, 7338, 7339, 7341, 7355, 7356, 7359, 7357, 7358, 7344, 7343, 7345, 7346, 7347, 7348, 7349, 7354, 7350, 7351, 7352, 7353, 7360, 7361, 7362, 7363, 7364, 7365, 7366, 7367, 7368, 7369, 7370, 7371, 7372, 7373, 7374, 7375, 7376, 7377, 7378, 7387, 7379, 7380, 7381, 7382, 7383, 7384, 7385, 7386, 7400, 7388, 7389, 7391, 7390, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7409, 7410, 7408, 7414, 7411, 7412, 7413, 7415, 7416, 7417, 7418, 7419, 7420, 7423, 7421, 7422, 7424, 7426, 7425, 7427, 7428, 7429, 7435, 7430, 7432, 7431, 7433, 7434, 7436, 7437, 7439, 7438, 7448, 7440, 7441, 7442, 7443, 7444, 7445, 7446, 7447, 7449, 7452, 7450, 7451, 7454, 7453, 7457, 7458, 7459, 7455, 7461, 7460, 7456, 7467, 7462, 7463, 7464, 7465, 7466, 7468, 7469, 7470, 7471, 7472, 7473, 7478, 7474, 7475, 7476, 7477, 7482, 7479, 7481, 7480) OR l.addl_category_id IN (3687, 7330, 7331, 7328, 7332, 7333, 7334, 7326, 7325, 7335, 7329, 7327, 7340, 7336, 7342, 7337, 7338, 7339, 7341, 7355, 7356, 7359, 7357, 7358, 7344, 7343, 7345, 7346, 7347, 7348, 7349, 7354, 7350, 7351, 7352, 7353, 7360, 7361, 7362, 7363, 7364, 7365, 7366, 7367, 7368, 7369, 7370, 7371, 7372, 7373, 7374, 7375, 7376, 7377, 7378, 7387, 7379, 7380, 7381, 7382, 7383, 7384, 7385, 7386, 7400, 7388, 7389, 7391, 7390, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7409, 7410, 7408, 7414, 7411, 7412, 7413, 7415, 7416, 7417, 7418, 7419, 7420, 7423, 7421, 7422, 7424, 7426, 7425, 7427, 7428, 7429, 7435, 7430, 7432, 7431, 7433, 7434, 7436, 7437, 7439, 7438, 7448, 7440, 7441, 7442, 7443, 7444, 7445, 7446, 7447, 7449, 7452, 7450, 7451, 7454, 7453, 7457, 7458, 7459, 7455, 7461, 7460, 7456, 7467, 7462, 7463, 7464, 7465, 7466, 7468, 7469, 7470, 7471, 7472, 7473, 7478, 7474, 7475, 7476, 7477, 7482, 7479, 7481, 7480)) 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 20