SELECTn0_.read_atASread_at_0,n0_.idASid_1,n0_.uuidASuuid_2,n0_.createdAScreated_3,n0_.updatedASupdated_4,n1_.typeAStype_5,n1_.categoryAScategory_6,n1_.statusASstatus_7,n1_.titleAStitle_8,n1_.messageASmessage_9,n1_.actionsASactions_10,n1_.idASid_11,n1_.uuidASuuid_12,n1_.createdAScreated_13,n1_.updatedASupdated_14,n0_.notification_idASnotification_id_15,n0_.user_idASuser_id_16,n1_.organisation_idASorganisation_id_17FROMnotifications_notification_recipientn0_INNER JOINnotifications_notificationn1_ONn0_.notification_id=n1_.idWHEREn0_.user_id=?ANDn1_.organisation_id=?AND (n0_.read_atISNOTNULLORn1_.status=?) ORDER BYn0_.read_atDESCLIMIT1
SELECTn0_.read_atASread_at_0,n0_.idASid_1,n0_.uuidASuuid_2,n0_.createdAScreated_3,n0_.updatedASupdated_4,n1_.typeAStype_5,n1_.categoryAScategory_6,n1_.statusASstatus_7,n1_.titleAStitle_8,n1_.messageASmessage_9,n1_.actionsASactions_10,n1_.idASid_11,n1_.uuidASuuid_12,n1_.createdAScreated_13,n1_.updatedASupdated_14,n0_.notification_idASnotification_id_15,n0_.user_idASuser_id_16,n1_.organisation_idASorganisation_id_17FROMnotifications_notification_recipientn0_INNER JOINnotifications_notificationn1_ONn0_.notification_id=n1_.idWHEREn0_.user_id=?ANDn1_.organisation_id=?AND (
n0_.read_atISNOTNULLORn1_.status=?
)
ORDER BYn0_.read_atDESCLIMIT1
SELECTn0_.read_atASread_at_0,n0_.idASid_1,n0_.uuidASuuid_2,n0_.createdAScreated_3,n0_.updatedASupdated_4,n1_.typeAStype_5,n1_.categoryAScategory_6,n1_.statusASstatus_7,n1_.titleAStitle_8,n1_.messageASmessage_9,n1_.actionsASactions_10,n1_.idASid_11,n1_.uuidASuuid_12,n1_.createdAScreated_13,n1_.updatedASupdated_14,n0_.notification_idASnotification_id_15,n0_.user_idASuser_id_16,n1_.organisation_idASorganisation_id_17FROMnotifications_notification_recipientn0_INNER JOINnotifications_notificationn1_ONn0_.notification_id=n1_.idWHEREn0_.user_id=1ANDn1_.organisation_id=1AND (n0_.read_atISNOTNULLORn1_.status='completed') ORDER BYn0_.read_atDESCLIMIT1;