workbooks query 2 inner joins incorrect

[Redrichmond]

Theres 2 inner joins on here I have commented out as else it doesn't work.. adding one reduced the record count which is incorrect and the checksum one cuts all records out...

This runs and brings the correct amount.. Start by the record count of the workbook table and enable and disable joins.. record count should stay the same as the overall workbook table

SELECT DISTINCT T301.asset_key_id AS "Asset_Key_ID (WB)", T301.checksum AS "Checksum (WB)", T301.content_version AS "Content_Version (WB)", T301.created_at AS "Created_At (WB)", T301.data_engine_extracts AS "Data_Engine_Extracts (WB)", T301.data_id AS "Data_ID (WB)", T301.default_view_index AS "Default_View_Index (WB)", T301.description AS "Description (WB)", T301.display_tabs AS "Display_Tabs (WB)", T301.document_version AS "Document_Version (WB)", --T301.embedded AS "Embedded (WB)", T301.extracts_incremented_at AS "Extracts_Incremented_At (WB)", T301.extracts_refreshed_at AS "Extracts_Refreshed_At (WB)", T301.first_published_at AS "First_Published_At (WB)", T301.id AS "Id (WB)", T301.incrementable_extracts AS "Incrementable_Extracts (WB)", T301.last_published_at AS "Last_Published_At (WB)", T301.lock_version AS "Lock_Version (WB)", T301.luid AS "Luid (WB)", T301.name AS "Name (WB)", T301.owner_id AS "Owner_ID (WB)", T301.primary_content_url AS "Primary_Content_Url (WB)", T301.project_id AS "Project_ID (WB)", T301.published_all_sheets AS "Published_All_Sheets (WB)", T301.reduced_data_id AS "Reduced_Data_ID (WB)", T301.refreshable_extracts AS "Refreshable_Extracts (WB)", T301.repository_data_id AS "Repository_Data_ID (WB)", T301.repository_extract_data_id AS "Repository_Extract_Data_ID (WB)", T301.repository_url AS "Repository_Url (WB)", T301.revision AS "Revision (WB)", T301.share_description AS "Share_Description (WB)", T301.show_toolbar AS "Show_Toolbar (WB)", T301.site_id AS "Site_ID (WB)", T301.size AS "Size (WB)", T301.state AS "State (WB)", T301.thumb_user AS "Thumb_User (WB)", T301.updated_at AS "Updated_At (WB)", T301.version AS "Version (WB)", T301.view_count AS "View_Count (WB)" FROM OPENQUERY(TABLEAU,'select * from public.workbooks')T301 LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.data_alerts') T47 ON T301.id = T47.workbook_id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.data_connections') T49 ON T301.id = T49.owner_id AND T49.owner_type = 'Workbook' LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.datasources') T55 ON T301.id = T55.parent_workbook_id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.extracts') T68 ON T301.id = T68.workbook_id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.hist_workbooks') T93 ON T301.id = T93.workbook_id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.most_recent_refreshes') T116 ON T301.id = T116.workbook_id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.next_gen_permissions') T120 ON T301.id = T120.authorizable_id AND T120.authorizable_type = 'Workbook' INNER JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.views') T297 ON T301.id = T297.workbook_id -- INNER JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.workbook_checksums')T299 ON T301.id = T299.workbook_id -- this joins makes query bring back 0 --INNER JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.workbook_versions') T300 ON T301.id = T300.workbook_id -- this join cuts records down by a lot - INNER JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.users')T290 ON T301.owner_id = T290.id INNER JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.projects') T227 ON T301.project_id = T227.id INNER JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.sites') T259 ON T301.site_id = T259.id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC._views') T16 ON T301.id = T16.workbook_id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC._views_stats') T17 ON T301.id = T17.views_workbook_id LEFT JOIN OPENQUERY(TABLEAU,'SELECT * FROM PUBLIC.subscriptions_workbooks')T270 ON T301.repository_url = T270.repository_url