1.ALTER TABLE customer CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

unreadNotificationCountByType
SELECT count() AS total FROM (SELECT FROM notification WHERE customer_id In (0,69165) AND type = 0 AND status = 1) n LEFT JOIN (SELECT notification_id FROM notification_read WHERE customer_id = 69165) nr ON (n.notification_id = nr.notification_id) WHERE isnull(nr.notification_id)

SELECT n.,isnull(nr.notification_id) AS unread FROM (SELECT FROM notification WHERE customer_id IN (0,69165) AND type = 0 AND status = 1) n LEFT JOIN (SELECT notification_id,deleted FROM notification_read WHERE customer_id = 69165) nr ON (n.notification_id = nr.notification_id) WHERE isnull(nr.deleted) OR nr.deleted = 0 ORDER BY n.created_at DESC LIMIT 0,1