$users = Users::select('id', 'nrc_state_region', 'nrc_township', 'nrc_citizen', 'nrc_number', 'description', 'office_pdf')
->whereIn('id', function ($query) {
$query->select('id')
->from(function ($subQuery) {
$subQuery->select('id', 'nrc_state_region', 'nrc_township', 'nrc_citizen', 'nrc_number', 'description', 'office_pdf',
DB::raw('ROW_NUMBER() OVER(PARTITION BY nrc_state_region, nrc_township, nrc_citizen, nrc_number ORDER BY id DESC) as row_number'))
->from('users')
->where('force_4', 1);
}, 'sub_alias')
->where('row_number', 1);
})
->get();