SELECT users.userid, users.url, IF(commitments.anonymous = "Y", " ", AS country, users.loginid, users.desc1, commitments.datein AS usersince, commitments.primarycommitmentid, commitments.anonymous, onbehalfoftypes.onbehalfoftype AS onbehalfoftype, IF(commitments.anonymous = "Y", "Anonymous", users.displayname) AS displayname, IF(commitments.anonymous = "Y", 1, 0) AS isanonymous, ( SELECT count(1) as c FROM donations d INNER JOIN commitments c ON d.commitmentid = c.commitmentid WHERE c.userid = users.userid AND c.type = 2 ) AS isThreeHundredMember, SUM( donations.amount - donations.refundamount ) AS total_posted_active, SUM( commitments.amount / ( select count(1) from donations where donations.commitmentid = commitments.commitmentid ) ) AS total_pledged FROM commitments INNER JOIN donations ON donations.commitmentid = commitments.commitmentid INNER JOIN users ON users.userid = donations.onbehalfofid INNER JOIN destinations ON destinations.ID = donations.destination INNER JOIN goodstypes ON goodstypes.ID = commitments.goodstype INNER JOIN projects ON projects.ID = donations.project INNER JOIN commitmenttypes ON commitmenttypes.ID = commitments.type INNER JOIN onbehalfoftypes ON onbehalfoftypes.ID = donations.onbehalfoftype WHERE goodstypes.goodstype = "Cash" AND users.displayname != "" AND commitmenttypes.debit = "Y" AND = "Y" AND commitments.display = "Y" AND commitments.includeincalc = "Y" AND = "Y" AND donations.verified = "Y" AND commitments.verified="Y" GROUP BY commitments.onbehalfofid, isanonymous ORDER BY usersince DESC ERROR: Table 'mfoundation_2015.commitments' doesn't exist