| 2 | SELECT [Dashboard].[name] AS [Dashboard__name], [Dashboard].[sql] AS [Dashboard__sql], [Dashboard].[report_id] AS [Dashboard__report_id], [Dashboard].[slug] AS [Dashboard__slug] FROM [CVS_reporting_roles_dashboards] AS [ReportingRolesDashboard] INNER JOIN [CVS_dashboards] AS [Dashboard] ON ([Dashboard].[id] = [ReportingRolesDashboard].[dashboard_id]) WHERE [ReportingRolesDashboard].[reporting_role_id] IS NULL AND [Dashboard].[footer] = '1' | | 0 | 0 | 3 |