Created
February 14, 2023 09:07
-
-
Save tomquist/a58b62d1a15ce99a67657ed636129e9b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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