MySQL Log

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!