SELECT "resource"."name" "EMPLEAT", "attendance"."name" "DATA", "attendance"."action" "ACCIO", "attendance"."action_desc" "MOTIU", "attendance"."sheet_id" "FULL", "hr_action_reason"."action_type" "MOTIU"


FROM "public"."hr_attendance" "attendance", "public"."hr_employee" "employee", "public"."resource_resource" "resource", "public"."hr_action_reason" "hr_action_reason"


WHERE "attendance"."employee_id" = "employee"."id" AND "employee"."resource_id" = "resource"."id" AND "attendance"."action_desc" = "hr_action_reason"."id"

ORDER BY "DATA" DESC