Error: Unknown column 'm.partner' in 'where clause'<br />Error No: 1054<br />SELECT m.country_id, c.name FROM `member` m LEFT JOIN `country` c ON (m.country_id = c.country_id) WHERE m.partner = '1' GROUP BY m.country_id ORDER BY c.name ASC