Canada’s Magazine Store | Magazines Canada

 SELECT contactID, magazineNameEn, magazineNameFR FROM `crm.magazines` LEFT JOIN `crm.contacts` USING ( contactID ) where contactID in (select contactID from `view.primary.address` where province in () )
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') )' at line 3