Case statements using NULL in MySql 
If checking for NULL, you cannot use
(CASE column_name WHEN NULL THEN 'N' WHEN '' THEN 'N' ELSE column_name END)

You have to write the CASE differently
(CASE WHEN column_name IS NULL THEN  'N' WHEN column_name = '' THEN 'N' ELSE column_name END)