-- this is right syntax for MS SQL 2005 ... You might be able to convert to mysql using this..
SELECT DISTINCT [WORK EMAIL]
FROM Manager_Database
INNER JOIN Manager_Skills ON Manager_Database.ID = Manager_Skills.ID
LEFT OUTER JOIN Suppressions ON Manager_Database.[WORK EMAIL] = Suppressions.[Email]
WHERE
(
Manager_Database.[WORK EMAIL] LIKE '%.ac.uk'
OR Manager_Database.[WORK EMAIL] LIKE '%.sch.uk'
)
AND
(
Manager_Skills.[Skill Category] LIKE 'T_EDUCATION'
OR Manager_Skills.[Skill Category] LIKE 'EDUCATION – LOCAL ED'
OR Manager_Skills.[Skill Category] LIKE 'EDUCATION – UNIVERSITIES'
)
AND
(
Manager_Skills.[Skill Description] LIKE 'T_EDUCATION'
OR Manager_Skills.[Skill Description] LIKE 'EDUCATION – LOCAL ED'
OR Manager_Skills.[Skill Description] LIKE 'EDUCATION – UNIVERSITIES'
)
AND Manager_Database.[WORK EMAIL] REGEXP '^[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9]@[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9]\.[a-zA-Z]{2,4}$'
AND Suppressions.[Email] IS NULL