-- 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