Skip to content

Instantly share code, notes, and snippets.

@tomquist
Created February 14, 2023 09:07
Show Gist options
  • Save tomquist/a58b62d1a15ce99a67657ed636129e9b to your computer and use it in GitHub Desktop.
Save tomquist/a58b62d1a15ce99a67657ed636129e9b to your computer and use it in GitHub Desktop.
with app_user as (select 'a' as id, 'organizationId' as organization_id, 'Africa/Abidjan' as timezone),
employee as (select 'a' as id, 'organizationId' as organization_id, 'a' as user_id, 'a' as manager_id)
SELECT DISTINCT app_user.id FROM app_user LEFT OUTER JOIN employee AS employee_1 ON
employee_1.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_1 ON (employee_1.manager_id = manager_employee_1.id AND manager_employee_1.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Abidjan' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_2 ON
employee_2.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_2 ON (employee_2.manager_id = manager_employee_2.id AND manager_employee_2.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Algiers' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_3 ON
employee_3.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_3 ON (employee_3.manager_id = manager_employee_3.id AND manager_employee_3.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Bissau' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_4 ON
employee_4.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_4 ON (employee_4.manager_id = manager_employee_4.id AND manager_employee_4.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Cairo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_5 ON
employee_5.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_5 ON (employee_5.manager_id = manager_employee_5.id AND manager_employee_5.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Casablanca' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_6 ON
employee_6.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_6 ON (employee_6.manager_id = manager_employee_6.id AND manager_employee_6.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Ceuta' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_7 ON
employee_7.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_7 ON (employee_7.manager_id = manager_employee_7.id AND manager_employee_7.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/El_Aaiun' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_8 ON
employee_8.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_8 ON (employee_8.manager_id = manager_employee_8.id AND manager_employee_8.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Johannesburg' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_9 ON
employee_9.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_9 ON (employee_9.manager_id = manager_employee_9.id AND manager_employee_9.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Juba' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_10 ON
employee_10.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_10 ON (employee_10.manager_id = manager_employee_10.id AND manager_employee_10.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Khartoum' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_11 ON
employee_11.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_11 ON (employee_11.manager_id = manager_employee_11.id AND manager_employee_11.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Lagos' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_12 ON
employee_12.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_12 ON (employee_12.manager_id = manager_employee_12.id AND manager_employee_12.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Maputo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_13 ON
employee_13.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_13 ON (employee_13.manager_id = manager_employee_13.id AND manager_employee_13.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Monrovia' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_14 ON
employee_14.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_14 ON (employee_14.manager_id = manager_employee_14.id AND manager_employee_14.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Nairobi' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_15 ON
employee_15.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_15 ON (employee_15.manager_id = manager_employee_15.id AND manager_employee_15.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Ndjamena' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_16 ON
employee_16.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_16 ON (employee_16.manager_id = manager_employee_16.id AND manager_employee_16.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Sao_Tome' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_17 ON
employee_17.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_17 ON (employee_17.manager_id = manager_employee_17.id AND manager_employee_17.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Tripoli' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_18 ON
employee_18.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_18 ON (employee_18.manager_id = manager_employee_18.id AND manager_employee_18.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Tunis' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_19 ON
employee_19.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_19 ON (employee_19.manager_id = manager_employee_19.id AND manager_employee_19.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Africa/Windhoek' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_20 ON
employee_20.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_20 ON (employee_20.manager_id = manager_employee_20.id AND manager_employee_20.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Adak' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_21 ON
employee_21.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_21 ON (employee_21.manager_id = manager_employee_21.id AND manager_employee_21.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Anchorage' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_22 ON
employee_22.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_22 ON (employee_22.manager_id = manager_employee_22.id AND manager_employee_22.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Araguaina' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_23 ON
employee_23.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_23 ON (employee_23.manager_id = manager_employee_23.id AND manager_employee_23.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Buenos_Aires' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_24 ON
employee_24.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_24 ON (employee_24.manager_id = manager_employee_24.id AND manager_employee_24.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Catamarca' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_25 ON
employee_25.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_25 ON (employee_25.manager_id = manager_employee_25.id AND manager_employee_25.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Cordoba' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_26 ON
employee_26.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_26 ON (employee_26.manager_id = manager_employee_26.id AND manager_employee_26.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Jujuy' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_27 ON
employee_27.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_27 ON (employee_27.manager_id = manager_employee_27.id AND manager_employee_27.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/La_Rioja' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_28 ON
employee_28.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_28 ON (employee_28.manager_id = manager_employee_28.id AND manager_employee_28.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Mendoza' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_29 ON
employee_29.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_29 ON (employee_29.manager_id = manager_employee_29.id AND manager_employee_29.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Rio_Gallegos' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_30 ON
employee_30.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_30 ON (employee_30.manager_id = manager_employee_30.id AND manager_employee_30.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Salta' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_31 ON
employee_31.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_31 ON (employee_31.manager_id = manager_employee_31.id AND manager_employee_31.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/San_Juan' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_32 ON
employee_32.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_32 ON (employee_32.manager_id = manager_employee_32.id AND manager_employee_32.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/San_Luis' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_33 ON
employee_33.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_33 ON (employee_33.manager_id = manager_employee_33.id AND manager_employee_33.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Tucuman' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_34 ON
employee_34.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_34 ON (employee_34.manager_id = manager_employee_34.id AND manager_employee_34.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Argentina/Ushuaia' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_35 ON
employee_35.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_35 ON (employee_35.manager_id = manager_employee_35.id AND manager_employee_35.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Asuncion' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_36 ON
employee_36.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_36 ON (employee_36.manager_id = manager_employee_36.id AND manager_employee_36.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Bahia' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_37 ON
employee_37.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_37 ON (employee_37.manager_id = manager_employee_37.id AND manager_employee_37.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Bahia_Banderas' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_38 ON
employee_38.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_38 ON (employee_38.manager_id = manager_employee_38.id AND manager_employee_38.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Barbados' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_39 ON
employee_39.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_39 ON (employee_39.manager_id = manager_employee_39.id AND manager_employee_39.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Belem' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_40 ON
employee_40.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_40 ON (employee_40.manager_id = manager_employee_40.id AND manager_employee_40.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Belize' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_41 ON
employee_41.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_41 ON (employee_41.manager_id = manager_employee_41.id AND manager_employee_41.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Boa_Vista' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_42 ON
employee_42.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_42 ON (employee_42.manager_id = manager_employee_42.id AND manager_employee_42.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Bogota' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_43 ON
employee_43.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_43 ON (employee_43.manager_id = manager_employee_43.id AND manager_employee_43.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Boise' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_44 ON
employee_44.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_44 ON (employee_44.manager_id = manager_employee_44.id AND manager_employee_44.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Cambridge_Bay' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_45 ON
employee_45.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_45 ON (employee_45.manager_id = manager_employee_45.id AND manager_employee_45.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Campo_Grande' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_46 ON
employee_46.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_46 ON (employee_46.manager_id = manager_employee_46.id AND manager_employee_46.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Cancun' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_47 ON
employee_47.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_47 ON (employee_47.manager_id = manager_employee_47.id AND manager_employee_47.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Caracas' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_48 ON
employee_48.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_48 ON (employee_48.manager_id = manager_employee_48.id AND manager_employee_48.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Cayenne' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_49 ON
employee_49.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_49 ON (employee_49.manager_id = manager_employee_49.id AND manager_employee_49.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Chicago' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_50 ON
employee_50.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_50 ON (employee_50.manager_id = manager_employee_50.id AND manager_employee_50.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Chihuahua' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_51 ON
employee_51.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_51 ON (employee_51.manager_id = manager_employee_51.id AND manager_employee_51.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Costa_Rica' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_52 ON
employee_52.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_52 ON (employee_52.manager_id = manager_employee_52.id AND manager_employee_52.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Cuiaba' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_53 ON
employee_53.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_53 ON (employee_53.manager_id = manager_employee_53.id AND manager_employee_53.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Danmarkshavn' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_54 ON
employee_54.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_54 ON (employee_54.manager_id = manager_employee_54.id AND manager_employee_54.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Dawson' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_55 ON
employee_55.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_55 ON (employee_55.manager_id = manager_employee_55.id AND manager_employee_55.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Dawson_Creek' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_56 ON
employee_56.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_56 ON (employee_56.manager_id = manager_employee_56.id AND manager_employee_56.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Denver' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_57 ON
employee_57.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_57 ON (employee_57.manager_id = manager_employee_57.id AND manager_employee_57.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Detroit' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_58 ON
employee_58.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_58 ON (employee_58.manager_id = manager_employee_58.id AND manager_employee_58.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Edmonton' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_59 ON
employee_59.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_59 ON (employee_59.manager_id = manager_employee_59.id AND manager_employee_59.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Eirunepe' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_60 ON
employee_60.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_60 ON (employee_60.manager_id = manager_employee_60.id AND manager_employee_60.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/El_Salvador' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_61 ON
employee_61.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_61 ON (employee_61.manager_id = manager_employee_61.id AND manager_employee_61.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Fort_Nelson' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_62 ON
employee_62.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_62 ON (employee_62.manager_id = manager_employee_62.id AND manager_employee_62.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Fortaleza' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_63 ON
employee_63.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_63 ON (employee_63.manager_id = manager_employee_63.id AND manager_employee_63.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Glace_Bay' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_64 ON
employee_64.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_64 ON (employee_64.manager_id = manager_employee_64.id AND manager_employee_64.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Goose_Bay' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_65 ON
employee_65.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_65 ON (employee_65.manager_id = manager_employee_65.id AND manager_employee_65.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Grand_Turk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_66 ON
employee_66.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_66 ON (employee_66.manager_id = manager_employee_66.id AND manager_employee_66.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Guatemala' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_67 ON
employee_67.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_67 ON (employee_67.manager_id = manager_employee_67.id AND manager_employee_67.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Guayaquil' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_68 ON
employee_68.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_68 ON (employee_68.manager_id = manager_employee_68.id AND manager_employee_68.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Guyana' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_69 ON
employee_69.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_69 ON (employee_69.manager_id = manager_employee_69.id AND manager_employee_69.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Halifax' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_70 ON
employee_70.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_70 ON (employee_70.manager_id = manager_employee_70.id AND manager_employee_70.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Havana' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_71 ON
employee_71.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_71 ON (employee_71.manager_id = manager_employee_71.id AND manager_employee_71.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Hermosillo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_72 ON
employee_72.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_72 ON (employee_72.manager_id = manager_employee_72.id AND manager_employee_72.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Indianapolis' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_73 ON
employee_73.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_73 ON (employee_73.manager_id = manager_employee_73.id AND manager_employee_73.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Knox' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_74 ON
employee_74.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_74 ON (employee_74.manager_id = manager_employee_74.id AND manager_employee_74.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Marengo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_75 ON
employee_75.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_75 ON (employee_75.manager_id = manager_employee_75.id AND manager_employee_75.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Petersburg' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_76 ON
employee_76.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_76 ON (employee_76.manager_id = manager_employee_76.id AND manager_employee_76.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Tell_City' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_77 ON
employee_77.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_77 ON (employee_77.manager_id = manager_employee_77.id AND manager_employee_77.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Vevay' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_78 ON
employee_78.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_78 ON (employee_78.manager_id = manager_employee_78.id AND manager_employee_78.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Vincennes' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_79 ON
employee_79.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_79 ON (employee_79.manager_id = manager_employee_79.id AND manager_employee_79.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Indiana/Winamac' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_80 ON
employee_80.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_80 ON (employee_80.manager_id = manager_employee_80.id AND manager_employee_80.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Inuvik' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_81 ON
employee_81.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_81 ON (employee_81.manager_id = manager_employee_81.id AND manager_employee_81.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Iqaluit' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_82 ON
employee_82.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_82 ON (employee_82.manager_id = manager_employee_82.id AND manager_employee_82.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Jamaica' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_83 ON
employee_83.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_83 ON (employee_83.manager_id = manager_employee_83.id AND manager_employee_83.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Juneau' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_84 ON
employee_84.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_84 ON (employee_84.manager_id = manager_employee_84.id AND manager_employee_84.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Kentucky/Louisville' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_85 ON
employee_85.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_85 ON (employee_85.manager_id = manager_employee_85.id AND manager_employee_85.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Kentucky/Monticello' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_86 ON
employee_86.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_86 ON (employee_86.manager_id = manager_employee_86.id AND manager_employee_86.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/La_Paz' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_87 ON
employee_87.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_87 ON (employee_87.manager_id = manager_employee_87.id AND manager_employee_87.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Lima' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_88 ON
employee_88.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_88 ON (employee_88.manager_id = manager_employee_88.id AND manager_employee_88.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Los_Angeles' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_89 ON
employee_89.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_89 ON (employee_89.manager_id = manager_employee_89.id AND manager_employee_89.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Maceio' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_90 ON
employee_90.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_90 ON (employee_90.manager_id = manager_employee_90.id AND manager_employee_90.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Managua' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_91 ON
employee_91.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_91 ON (employee_91.manager_id = manager_employee_91.id AND manager_employee_91.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Manaus' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_92 ON
employee_92.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_92 ON (employee_92.manager_id = manager_employee_92.id AND manager_employee_92.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Martinique' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_93 ON
employee_93.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_93 ON (employee_93.manager_id = manager_employee_93.id AND manager_employee_93.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Matamoros' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_94 ON
employee_94.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_94 ON (employee_94.manager_id = manager_employee_94.id AND manager_employee_94.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Mazatlan' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_95 ON
employee_95.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_95 ON (employee_95.manager_id = manager_employee_95.id AND manager_employee_95.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Menominee' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_96 ON
employee_96.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_96 ON (employee_96.manager_id = manager_employee_96.id AND manager_employee_96.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Merida' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_97 ON
employee_97.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_97 ON (employee_97.manager_id = manager_employee_97.id AND manager_employee_97.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Metlakatla' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_98 ON
employee_98.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_98 ON (employee_98.manager_id = manager_employee_98.id AND manager_employee_98.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Mexico_City' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_99 ON
employee_99.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_99 ON (employee_99.manager_id = manager_employee_99.id AND manager_employee_99.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Miquelon' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_100 ON
employee_100.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_100 ON (employee_100.manager_id = manager_employee_100.id AND manager_employee_100.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Moncton' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_101 ON
employee_101.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_101 ON (employee_101.manager_id = manager_employee_101.id AND manager_employee_101.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Monterrey' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_102 ON
employee_102.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_102 ON (employee_102.manager_id = manager_employee_102.id AND manager_employee_102.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Montevideo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_103 ON
employee_103.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_103 ON (employee_103.manager_id = manager_employee_103.id AND manager_employee_103.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/New_York' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_104 ON
employee_104.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_104 ON (employee_104.manager_id = manager_employee_104.id AND manager_employee_104.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Nipigon' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_105 ON
employee_105.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_105 ON (employee_105.manager_id = manager_employee_105.id AND manager_employee_105.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Nome' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_106 ON
employee_106.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_106 ON (employee_106.manager_id = manager_employee_106.id AND manager_employee_106.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Noronha' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_107 ON
employee_107.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_107 ON (employee_107.manager_id = manager_employee_107.id AND manager_employee_107.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/North_Dakota/Beulah' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_108 ON
employee_108.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_108 ON (employee_108.manager_id = manager_employee_108.id AND manager_employee_108.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/North_Dakota/Center' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_109 ON
employee_109.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_109 ON (employee_109.manager_id = manager_employee_109.id AND manager_employee_109.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/North_Dakota/New_Salem' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_110 ON
employee_110.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_110 ON (employee_110.manager_id = manager_employee_110.id AND manager_employee_110.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Nuuk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_111 ON
employee_111.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_111 ON (employee_111.manager_id = manager_employee_111.id AND manager_employee_111.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Ojinaga' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_112 ON
employee_112.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_112 ON (employee_112.manager_id = manager_employee_112.id AND manager_employee_112.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Panama' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_113 ON
employee_113.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_113 ON (employee_113.manager_id = manager_employee_113.id AND manager_employee_113.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Pangnirtung' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_114 ON
employee_114.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_114 ON (employee_114.manager_id = manager_employee_114.id AND manager_employee_114.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Paramaribo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_115 ON
employee_115.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_115 ON (employee_115.manager_id = manager_employee_115.id AND manager_employee_115.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Phoenix' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_116 ON
employee_116.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_116 ON (employee_116.manager_id = manager_employee_116.id AND manager_employee_116.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Port-au-Prince' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_117 ON
employee_117.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_117 ON (employee_117.manager_id = manager_employee_117.id AND manager_employee_117.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Porto_Velho' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_118 ON
employee_118.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_118 ON (employee_118.manager_id = manager_employee_118.id AND manager_employee_118.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Puerto_Rico' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_119 ON
employee_119.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_119 ON (employee_119.manager_id = manager_employee_119.id AND manager_employee_119.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Punta_Arenas' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_120 ON
employee_120.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_120 ON (employee_120.manager_id = manager_employee_120.id AND manager_employee_120.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Rainy_River' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_121 ON
employee_121.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_121 ON (employee_121.manager_id = manager_employee_121.id AND manager_employee_121.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Rankin_Inlet' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_122 ON
employee_122.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_122 ON (employee_122.manager_id = manager_employee_122.id AND manager_employee_122.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Recife' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_123 ON
employee_123.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_123 ON (employee_123.manager_id = manager_employee_123.id AND manager_employee_123.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Regina' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_124 ON
employee_124.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_124 ON (employee_124.manager_id = manager_employee_124.id AND manager_employee_124.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Resolute' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_125 ON
employee_125.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_125 ON (employee_125.manager_id = manager_employee_125.id AND manager_employee_125.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Rio_Branco' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_126 ON
employee_126.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_126 ON (employee_126.manager_id = manager_employee_126.id AND manager_employee_126.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Santarem' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_127 ON
employee_127.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_127 ON (employee_127.manager_id = manager_employee_127.id AND manager_employee_127.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Santiago' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_128 ON
employee_128.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_128 ON (employee_128.manager_id = manager_employee_128.id AND manager_employee_128.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Santo_Domingo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_129 ON
employee_129.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_129 ON (employee_129.manager_id = manager_employee_129.id AND manager_employee_129.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Sao_Paulo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_130 ON
employee_130.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_130 ON (employee_130.manager_id = manager_employee_130.id AND manager_employee_130.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Scoresbysund' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_131 ON
employee_131.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_131 ON (employee_131.manager_id = manager_employee_131.id AND manager_employee_131.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Sitka' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_132 ON
employee_132.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_132 ON (employee_132.manager_id = manager_employee_132.id AND manager_employee_132.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/St_Johns' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_133 ON
employee_133.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_133 ON (employee_133.manager_id = manager_employee_133.id AND manager_employee_133.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Swift_Current' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_134 ON
employee_134.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_134 ON (employee_134.manager_id = manager_employee_134.id AND manager_employee_134.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Tegucigalpa' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_135 ON
employee_135.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_135 ON (employee_135.manager_id = manager_employee_135.id AND manager_employee_135.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Thule' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_136 ON
employee_136.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_136 ON (employee_136.manager_id = manager_employee_136.id AND manager_employee_136.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Thunder_Bay' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_137 ON
employee_137.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_137 ON (employee_137.manager_id = manager_employee_137.id AND manager_employee_137.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Tijuana' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_138 ON
employee_138.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_138 ON (employee_138.manager_id = manager_employee_138.id AND manager_employee_138.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Toronto' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_139 ON
employee_139.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_139 ON (employee_139.manager_id = manager_employee_139.id AND manager_employee_139.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Vancouver' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_140 ON
employee_140.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_140 ON (employee_140.manager_id = manager_employee_140.id AND manager_employee_140.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Whitehorse' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_141 ON
employee_141.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_141 ON (employee_141.manager_id = manager_employee_141.id AND manager_employee_141.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Winnipeg' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_142 ON
employee_142.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_142 ON (employee_142.manager_id = manager_employee_142.id AND manager_employee_142.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Yakutat' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_143 ON
employee_143.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_143 ON (employee_143.manager_id = manager_employee_143.id AND manager_employee_143.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'America/Yellowknife' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_144 ON
employee_144.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_144 ON (employee_144.manager_id = manager_employee_144.id AND manager_employee_144.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Antarctica/Casey' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_145 ON
employee_145.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_145 ON (employee_145.manager_id = manager_employee_145.id AND manager_employee_145.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Antarctica/Davis' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_146 ON
employee_146.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_146 ON (employee_146.manager_id = manager_employee_146.id AND manager_employee_146.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Antarctica/Macquarie' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_147 ON
employee_147.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_147 ON (employee_147.manager_id = manager_employee_147.id AND manager_employee_147.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Antarctica/Mawson' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_148 ON
employee_148.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_148 ON (employee_148.manager_id = manager_employee_148.id AND manager_employee_148.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Antarctica/Palmer' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_149 ON
employee_149.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_149 ON (employee_149.manager_id = manager_employee_149.id AND manager_employee_149.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Antarctica/Rothera' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_150 ON
employee_150.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_150 ON (employee_150.manager_id = manager_employee_150.id AND manager_employee_150.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Antarctica/Troll' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_151 ON
employee_151.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_151 ON (employee_151.manager_id = manager_employee_151.id AND manager_employee_151.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Almaty' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_152 ON
employee_152.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_152 ON (employee_152.manager_id = manager_employee_152.id AND manager_employee_152.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Amman' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_153 ON
employee_153.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_153 ON (employee_153.manager_id = manager_employee_153.id AND manager_employee_153.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Anadyr' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_154 ON
employee_154.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_154 ON (employee_154.manager_id = manager_employee_154.id AND manager_employee_154.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Aqtau' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_155 ON
employee_155.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_155 ON (employee_155.manager_id = manager_employee_155.id AND manager_employee_155.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Aqtobe' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_156 ON
employee_156.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_156 ON (employee_156.manager_id = manager_employee_156.id AND manager_employee_156.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Ashgabat' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_157 ON
employee_157.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_157 ON (employee_157.manager_id = manager_employee_157.id AND manager_employee_157.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Atyrau' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_158 ON
employee_158.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_158 ON (employee_158.manager_id = manager_employee_158.id AND manager_employee_158.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Baghdad' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_159 ON
employee_159.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_159 ON (employee_159.manager_id = manager_employee_159.id AND manager_employee_159.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Baku' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_160 ON
employee_160.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_160 ON (employee_160.manager_id = manager_employee_160.id AND manager_employee_160.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Bangkok' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_161 ON
employee_161.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_161 ON (employee_161.manager_id = manager_employee_161.id AND manager_employee_161.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Barnaul' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_162 ON
employee_162.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_162 ON (employee_162.manager_id = manager_employee_162.id AND manager_employee_162.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Beirut' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_163 ON
employee_163.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_163 ON (employee_163.manager_id = manager_employee_163.id AND manager_employee_163.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Bishkek' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_164 ON
employee_164.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_164 ON (employee_164.manager_id = manager_employee_164.id AND manager_employee_164.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Chita' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_165 ON
employee_165.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_165 ON (employee_165.manager_id = manager_employee_165.id AND manager_employee_165.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Choibalsan' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_166 ON
employee_166.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_166 ON (employee_166.manager_id = manager_employee_166.id AND manager_employee_166.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Colombo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_167 ON
employee_167.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_167 ON (employee_167.manager_id = manager_employee_167.id AND manager_employee_167.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Damascus' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_168 ON
employee_168.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_168 ON (employee_168.manager_id = manager_employee_168.id AND manager_employee_168.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Dhaka' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_169 ON
employee_169.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_169 ON (employee_169.manager_id = manager_employee_169.id AND manager_employee_169.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Dili' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_170 ON
employee_170.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_170 ON (employee_170.manager_id = manager_employee_170.id AND manager_employee_170.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Dubai' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_171 ON
employee_171.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_171 ON (employee_171.manager_id = manager_employee_171.id AND manager_employee_171.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Dushanbe' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_172 ON
employee_172.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_172 ON (employee_172.manager_id = manager_employee_172.id AND manager_employee_172.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Famagusta' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_173 ON
employee_173.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_173 ON (employee_173.manager_id = manager_employee_173.id AND manager_employee_173.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Gaza' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_174 ON
employee_174.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_174 ON (employee_174.manager_id = manager_employee_174.id AND manager_employee_174.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Hebron' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_175 ON
employee_175.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_175 ON (employee_175.manager_id = manager_employee_175.id AND manager_employee_175.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Ho_Chi_Minh' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_176 ON
employee_176.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_176 ON (employee_176.manager_id = manager_employee_176.id AND manager_employee_176.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Hong_Kong' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_177 ON
employee_177.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_177 ON (employee_177.manager_id = manager_employee_177.id AND manager_employee_177.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Hovd' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_178 ON
employee_178.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_178 ON (employee_178.manager_id = manager_employee_178.id AND manager_employee_178.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Irkutsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_179 ON
employee_179.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_179 ON (employee_179.manager_id = manager_employee_179.id AND manager_employee_179.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Jakarta' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_180 ON
employee_180.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_180 ON (employee_180.manager_id = manager_employee_180.id AND manager_employee_180.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Jayapura' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_181 ON
employee_181.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_181 ON (employee_181.manager_id = manager_employee_181.id AND manager_employee_181.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Jerusalem' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_182 ON
employee_182.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_182 ON (employee_182.manager_id = manager_employee_182.id AND manager_employee_182.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Kabul' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_183 ON
employee_183.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_183 ON (employee_183.manager_id = manager_employee_183.id AND manager_employee_183.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Kamchatka' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_184 ON
employee_184.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_184 ON (employee_184.manager_id = manager_employee_184.id AND manager_employee_184.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Karachi' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_185 ON
employee_185.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_185 ON (employee_185.manager_id = manager_employee_185.id AND manager_employee_185.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Kathmandu' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_186 ON
employee_186.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_186 ON (employee_186.manager_id = manager_employee_186.id AND manager_employee_186.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Khandyga' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_187 ON
employee_187.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_187 ON (employee_187.manager_id = manager_employee_187.id AND manager_employee_187.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Kolkata' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_188 ON
employee_188.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_188 ON (employee_188.manager_id = manager_employee_188.id AND manager_employee_188.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Krasnoyarsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_189 ON
employee_189.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_189 ON (employee_189.manager_id = manager_employee_189.id AND manager_employee_189.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Kuching' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_190 ON
employee_190.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_190 ON (employee_190.manager_id = manager_employee_190.id AND manager_employee_190.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Macau' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_191 ON
employee_191.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_191 ON (employee_191.manager_id = manager_employee_191.id AND manager_employee_191.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Magadan' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_192 ON
employee_192.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_192 ON (employee_192.manager_id = manager_employee_192.id AND manager_employee_192.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Makassar' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_193 ON
employee_193.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_193 ON (employee_193.manager_id = manager_employee_193.id AND manager_employee_193.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Manila' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_194 ON
employee_194.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_194 ON (employee_194.manager_id = manager_employee_194.id AND manager_employee_194.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Nicosia' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_195 ON
employee_195.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_195 ON (employee_195.manager_id = manager_employee_195.id AND manager_employee_195.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Novokuznetsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_196 ON
employee_196.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_196 ON (employee_196.manager_id = manager_employee_196.id AND manager_employee_196.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Novosibirsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_197 ON
employee_197.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_197 ON (employee_197.manager_id = manager_employee_197.id AND manager_employee_197.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Omsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_198 ON
employee_198.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_198 ON (employee_198.manager_id = manager_employee_198.id AND manager_employee_198.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Oral' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_199 ON
employee_199.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_199 ON (employee_199.manager_id = manager_employee_199.id AND manager_employee_199.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Pontianak' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_200 ON
employee_200.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_200 ON (employee_200.manager_id = manager_employee_200.id AND manager_employee_200.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Pyongyang' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_201 ON
employee_201.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_201 ON (employee_201.manager_id = manager_employee_201.id AND manager_employee_201.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Qatar' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_202 ON
employee_202.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_202 ON (employee_202.manager_id = manager_employee_202.id AND manager_employee_202.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Qostanay' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_203 ON
employee_203.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_203 ON (employee_203.manager_id = manager_employee_203.id AND manager_employee_203.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Qyzylorda' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_204 ON
employee_204.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_204 ON (employee_204.manager_id = manager_employee_204.id AND manager_employee_204.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Riyadh' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_205 ON
employee_205.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_205 ON (employee_205.manager_id = manager_employee_205.id AND manager_employee_205.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Sakhalin' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_206 ON
employee_206.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_206 ON (employee_206.manager_id = manager_employee_206.id AND manager_employee_206.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Samarkand' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_207 ON
employee_207.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_207 ON (employee_207.manager_id = manager_employee_207.id AND manager_employee_207.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Seoul' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_208 ON
employee_208.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_208 ON (employee_208.manager_id = manager_employee_208.id AND manager_employee_208.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Shanghai' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_209 ON
employee_209.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_209 ON (employee_209.manager_id = manager_employee_209.id AND manager_employee_209.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Singapore' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_210 ON
employee_210.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_210 ON (employee_210.manager_id = manager_employee_210.id AND manager_employee_210.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Srednekolymsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_211 ON
employee_211.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_211 ON (employee_211.manager_id = manager_employee_211.id AND manager_employee_211.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Taipei' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_212 ON
employee_212.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_212 ON (employee_212.manager_id = manager_employee_212.id AND manager_employee_212.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Tashkent' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_213 ON
employee_213.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_213 ON (employee_213.manager_id = manager_employee_213.id AND manager_employee_213.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Tbilisi' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_214 ON
employee_214.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_214 ON (employee_214.manager_id = manager_employee_214.id AND manager_employee_214.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Tehran' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_215 ON
employee_215.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_215 ON (employee_215.manager_id = manager_employee_215.id AND manager_employee_215.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Thimphu' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_216 ON
employee_216.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_216 ON (employee_216.manager_id = manager_employee_216.id AND manager_employee_216.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Tokyo' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_217 ON
employee_217.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_217 ON (employee_217.manager_id = manager_employee_217.id AND manager_employee_217.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Tomsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_218 ON
employee_218.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_218 ON (employee_218.manager_id = manager_employee_218.id AND manager_employee_218.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Ulaanbaatar' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_219 ON
employee_219.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_219 ON (employee_219.manager_id = manager_employee_219.id AND manager_employee_219.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Urumqi' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_220 ON
employee_220.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_220 ON (employee_220.manager_id = manager_employee_220.id AND manager_employee_220.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Ust-Nera' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_221 ON
employee_221.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_221 ON (employee_221.manager_id = manager_employee_221.id AND manager_employee_221.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Vladivostok' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_222 ON
employee_222.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_222 ON (employee_222.manager_id = manager_employee_222.id AND manager_employee_222.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Yakutsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_223 ON
employee_223.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_223 ON (employee_223.manager_id = manager_employee_223.id AND manager_employee_223.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Yangon' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_224 ON
employee_224.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_224 ON (employee_224.manager_id = manager_employee_224.id AND manager_employee_224.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Yekaterinburg' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_225 ON
employee_225.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_225 ON (employee_225.manager_id = manager_employee_225.id AND manager_employee_225.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Asia/Yerevan' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_226 ON
employee_226.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_226 ON (employee_226.manager_id = manager_employee_226.id AND manager_employee_226.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/Azores' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_227 ON
employee_227.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_227 ON (employee_227.manager_id = manager_employee_227.id AND manager_employee_227.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/Bermuda' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_228 ON
employee_228.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_228 ON (employee_228.manager_id = manager_employee_228.id AND manager_employee_228.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/Canary' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_229 ON
employee_229.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_229 ON (employee_229.manager_id = manager_employee_229.id AND manager_employee_229.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/Cape_Verde' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_230 ON
employee_230.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_230 ON (employee_230.manager_id = manager_employee_230.id AND manager_employee_230.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/Faroe' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_231 ON
employee_231.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_231 ON (employee_231.manager_id = manager_employee_231.id AND manager_employee_231.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/Madeira' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_232 ON
employee_232.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_232 ON (employee_232.manager_id = manager_employee_232.id AND manager_employee_232.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/South_Georgia' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_233 ON
employee_233.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_233 ON (employee_233.manager_id = manager_employee_233.id AND manager_employee_233.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Atlantic/Stanley' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_234 ON
employee_234.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_234 ON (employee_234.manager_id = manager_employee_234.id AND manager_employee_234.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Adelaide' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_235 ON
employee_235.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_235 ON (employee_235.manager_id = manager_employee_235.id AND manager_employee_235.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Brisbane' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_236 ON
employee_236.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_236 ON (employee_236.manager_id = manager_employee_236.id AND manager_employee_236.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Broken_Hill' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_237 ON
employee_237.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_237 ON (employee_237.manager_id = manager_employee_237.id AND manager_employee_237.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Darwin' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_238 ON
employee_238.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_238 ON (employee_238.manager_id = manager_employee_238.id AND manager_employee_238.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Eucla' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_239 ON
employee_239.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_239 ON (employee_239.manager_id = manager_employee_239.id AND manager_employee_239.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Hobart' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_240 ON
employee_240.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_240 ON (employee_240.manager_id = manager_employee_240.id AND manager_employee_240.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Lindeman' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_241 ON
employee_241.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_241 ON (employee_241.manager_id = manager_employee_241.id AND manager_employee_241.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Lord_Howe' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_242 ON
employee_242.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_242 ON (employee_242.manager_id = manager_employee_242.id AND manager_employee_242.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Melbourne' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_243 ON
employee_243.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_243 ON (employee_243.manager_id = manager_employee_243.id AND manager_employee_243.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Perth' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_244 ON
employee_244.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_244 ON (employee_244.manager_id = manager_employee_244.id AND manager_employee_244.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Australia/Sydney' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_245 ON
employee_245.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_245 ON (employee_245.manager_id = manager_employee_245.id AND manager_employee_245.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Andorra' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_246 ON
employee_246.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_246 ON (employee_246.manager_id = manager_employee_246.id AND manager_employee_246.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Astrakhan' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_247 ON
employee_247.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_247 ON (employee_247.manager_id = manager_employee_247.id AND manager_employee_247.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Athens' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_248 ON
employee_248.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_248 ON (employee_248.manager_id = manager_employee_248.id AND manager_employee_248.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Belgrade' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_249 ON
employee_249.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_249 ON (employee_249.manager_id = manager_employee_249.id AND manager_employee_249.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Berlin' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_250 ON
employee_250.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_250 ON (employee_250.manager_id = manager_employee_250.id AND manager_employee_250.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Brussels' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_251 ON
employee_251.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_251 ON (employee_251.manager_id = manager_employee_251.id AND manager_employee_251.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Bucharest' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_252 ON
employee_252.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_252 ON (employee_252.manager_id = manager_employee_252.id AND manager_employee_252.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Budapest' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_253 ON
employee_253.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_253 ON (employee_253.manager_id = manager_employee_253.id AND manager_employee_253.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Chisinau' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_254 ON
employee_254.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_254 ON (employee_254.manager_id = manager_employee_254.id AND manager_employee_254.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Dublin' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_255 ON
employee_255.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_255 ON (employee_255.manager_id = manager_employee_255.id AND manager_employee_255.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Gibraltar' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_256 ON
employee_256.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_256 ON (employee_256.manager_id = manager_employee_256.id AND manager_employee_256.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Helsinki' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_257 ON
employee_257.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_257 ON (employee_257.manager_id = manager_employee_257.id AND manager_employee_257.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Istanbul' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_258 ON
employee_258.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_258 ON (employee_258.manager_id = manager_employee_258.id AND manager_employee_258.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Kaliningrad' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_259 ON
employee_259.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_259 ON (employee_259.manager_id = manager_employee_259.id AND manager_employee_259.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Kirov' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_260 ON
employee_260.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_260 ON (employee_260.manager_id = manager_employee_260.id AND manager_employee_260.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Kyiv' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_261 ON
employee_261.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_261 ON (employee_261.manager_id = manager_employee_261.id AND manager_employee_261.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Lisbon' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_262 ON
employee_262.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_262 ON (employee_262.manager_id = manager_employee_262.id AND manager_employee_262.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/London' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_263 ON
employee_263.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_263 ON (employee_263.manager_id = manager_employee_263.id AND manager_employee_263.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Madrid' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_264 ON
employee_264.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_264 ON (employee_264.manager_id = manager_employee_264.id AND manager_employee_264.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Malta' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_265 ON
employee_265.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_265 ON (employee_265.manager_id = manager_employee_265.id AND manager_employee_265.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Minsk' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_266 ON
employee_266.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_266 ON (employee_266.manager_id = manager_employee_266.id AND manager_employee_266.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Moscow' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_267 ON
employee_267.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_267 ON (employee_267.manager_id = manager_employee_267.id AND manager_employee_267.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Paris' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_268 ON
employee_268.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_268 ON (employee_268.manager_id = manager_employee_268.id AND manager_employee_268.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Prague' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_269 ON
employee_269.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_269 ON (employee_269.manager_id = manager_employee_269.id AND manager_employee_269.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Riga' AND app_user.organization_id = 'organizationId')))
LEFT OUTER JOIN employee AS employee_270 ON
employee_270.user_id = app_user.id LEFT OUTER JOIN employee AS manager_employee_270 ON (employee_270.manager_id = manager_employee_270.id AND manager_employee_270.user_id IN (SELECT app_user.id FROM app_user WHERE (app_user.timezone = 'Europe/Rome' AND app_user.organization_id = 'organizationId')));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment