[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 (3688, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7128, 7129, 7130, 7131, 7132, 7133, 7135, 7134, 7136, 7137, 7138, 7139, 7147, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7148, 7149, 7151, 7152, 7150, 7153, 7154, 7155, 7164, 7156, 7165, 7157, 7158, 7159, 7160, 7161, 7162, 7163, 7166, 7167, 7168, 7169, 7170, 7171, 7172, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7186, 7185, 7187, 7188, 7189, 7190, 7191, 7192, 7193, 7207, 7194, 7195, 7196, 7197, 7198, 7199, 7200, 7201, 7202, 7203, 7204, 7205, 7206, 7208, 7209, 7210, 7211, 7212, 7213, 7214, 7215, 7216, 7217, 7218, 7219, 7220, 7221, 7222, 7223, 7224, 7225, 7226, 7227, 7228, 7229, 7230, 7231, 7232, 7234, 7233, 7235, 7236, 7237, 7241, 7238, 7239, 7240, 7242, 7243, 7247, 7244, 7245, 7246, 7248, 7249, 7250, 7251, 7252, 7253, 7259, 7254, 7255, 7256, 7257, 7258, 7260, 7261, 7262, 7263, 7264, 7265, 7266, 7267, 7270, 7268, 7269, 7271, 7272, 7275, 7273, 7274, 7285, 7278, 7277, 7279, 7280, 7276, 7283, 7286, 7281, 7284, 7282, 7287, 7289, 7290, 7288, 7291, 7292, 7293, 7295, 7294, 7296, 7298, 7297, 7299, 7300, 7303, 7301, 7302, 7304, 7310, 7305, 7306, 7308, 7307, 7309, 7311, 7312, 7313, 7315, 7314, 7316, 7317, 7318, 7319, 7320, 7324, 7321, 7322, 7323) OR l.addl_category_id IN (3688, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7128, 7129, 7130, 7131, 7132, 7133, 7135, 7134, 7136, 7137, 7138, 7139, 7147, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7148, 7149, 7151, 7152, 7150, 7153, 7154, 7155, 7164, 7156, 7165, 7157, 7158, 7159, 7160, 7161, 7162, 7163, 7166, 7167, 7168, 7169, 7170, 7171, 7172, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7186, 7185, 7187, 7188, 7189, 7190, 7191, 7192, 7193, 7207, 7194, 7195, 7196, 7197, 7198, 7199, 7200, 7201, 7202, 7203, 7204, 7205, 7206, 7208, 7209, 7210, 7211, 7212, 7213, 7214, 7215, 7216, 7217, 7218, 7219, 7220, 7221, 7222, 7223, 7224, 7225, 7226, 7227, 7228, 7229, 7230, 7231, 7232, 7234, 7233, 7235, 7236, 7237, 7241, 7238, 7239, 7240, 7242, 7243, 7247, 7244, 7245, 7246, 7248, 7249, 7250, 7251, 7252, 7253, 7259, 7254, 7255, 7256, 7257, 7258, 7260, 7261, 7262, 7263, 7264, 7265, 7266, 7267, 7270, 7268, 7269, 7271, 7272, 7275, 7273, 7274, 7285, 7278, 7277, 7279, 7280, 7276, 7283, 7286, 7281, 7284, 7282, 7287, 7289, 7290, 7288, 7291, 7292, 7293, 7295, 7294, 7296, 7298, 7297, 7299, 7300, 7303, 7301, 7302, 7304, 7310, 7305, 7306, 7308, 7307, 7309, 7311, 7312, 7313, 7315, 7314, 7316, 7317, 7318, 7319, 7320, 7324, 7321, 7322, 7323)) 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 (3688, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7128, 7129, 7130, 7131, 7132, 7133, 7135, 7134, 7136, 7137, 7138, 7139, 7147, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7148, 7149, 7151, 7152, 7150, 7153, 7154, 7155, 7164, 7156, 7165, 7157, 7158, 7159, 7160, 7161, 7162, 7163, 7166, 7167, 7168, 7169, 7170, 7171, 7172, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7186, 7185, 7187, 7188, 7189, 7190, 7191, 7192, 7193, 7207, 7194, 7195, 7196, 7197, 7198, 7199, 7200, 7201, 7202, 7203, 7204, 7205, 7206, 7208, 7209, 7210, 7211, 7212, 7213, 7214, 7215, 7216, 7217, 7218, 7219, 7220, 7221, 7222, 7223, 7224, 7225, 7226, 7227, 7228, 7229, 7230, 7231, 7232, 7234, 7233, 7235, 7236, 7237, 7241, 7238, 7239, 7240, 7242, 7243, 7247, 7244, 7245, 7246, 7248, 7249, 7250, 7251, 7252, 7253, 7259, 7254, 7255, 7256, 7257, 7258, 7260, 7261, 7262, 7263, 7264, 7265, 7266, 7267, 7270, 7268, 7269, 7271, 7272, 7275, 7273, 7274, 7285, 7278, 7277, 7279, 7280, 7276, 7283, 7286, 7281, 7284, 7282, 7287, 7289, 7290, 7288, 7291, 7292, 7293, 7295, 7294, 7296, 7298, 7297, 7299, 7300, 7303, 7301, 7302, 7304, 7310, 7305, 7306, 7308, 7307, 7309, 7311, 7312, 7313, 7315, 7314, 7316, 7317, 7318, 7319, 7320, 7324, 7321, 7322, 7323) OR l.addl_category_id IN (3688, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7128, 7129, 7130, 7131, 7132, 7133, 7135, 7134, 7136, 7137, 7138, 7139, 7147, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7148, 7149, 7151, 7152, 7150, 7153, 7154, 7155, 7164, 7156, 7165, 7157, 7158, 7159, 7160, 7161, 7162, 7163, 7166, 7167, 7168, 7169, 7170, 7171, 7172, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7186, 7185, 7187, 7188, 7189, 7190, 7191, 7192, 7193, 7207, 7194, 7195, 7196, 7197, 7198, 7199, 7200, 7201, 7202, 7203, 7204, 7205, 7206, 7208, 7209, 7210, 7211, 7212, 7213, 7214, 7215, 7216, 7217, 7218, 7219, 7220, 7221, 7222, 7223, 7224, 7225, 7226, 7227, 7228, 7229, 7230, 7231, 7232, 7234, 7233, 7235, 7236, 7237, 7241, 7238, 7239, 7240, 7242, 7243, 7247, 7244, 7245, 7246, 7248, 7249, 7250, 7251, 7252, 7253, 7259, 7254, 7255, 7256, 7257, 7258, 7260, 7261, 7262, 7263, 7264, 7265, 7266, 7267, 7270, 7268, 7269, 7271, 7272, 7275, 7273, 7274, 7285, 7278, 7277, 7279, 7280, 7276, 7283, 7286, 7281, 7284, 7282, 7287, 7289, 7290, 7288, 7291, 7292, 7293, 7295, 7294, 7296, 7298, 7297, 7299, 7300, 7303, 7301, 7302, 7304, 7310, 7305, 7306, 7308, 7307, 7309, 7311, 7312, 7313, 7315, 7314, 7316, 7317, 7318, 7319, 7320, 7324, 7321, 7322, 7323)) 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