resources

blah

SELECT paged_results.* FROM (SELECT reports.certname, reports.configuration_version, reports.containment_path, reports.end_time, reports.environment, reports.event_status, reports.file, reports.hash, reports.line, reports.message, reports.new_value, reports.old_value, reports.property, reports.puppet_version, reports.receive_time, reports.report_format, reports.resource_title, reports.resource_type, reports.start_time, reports.status, reports.timestamp, reports.transaction_uuid FROM ( select reports.hash,
                       reports.certname,
                       reports.puppet_version,
                       reports.report_format,
                       reports.configuration_version,
                       reports.start_time,
                       reports.end_time,
                       reports.receive_time,
                       reports.transaction_uuid,
                       environments.name as environment,
                       report_statuses.status as status,
                       re.report,
                       re.status as event_status,
                       re.timestamp,
                       re.resource_type,
                       re.resource_title,
                       re.property,
                       re.new_value,
                       re.old_value,
                       re.message,
                       re.file,
                       re.line,
                       re.containment_path,
                       re.containing_class
                       FROM reports
                       INNER JOIN resource_events re on reports.hash=re.report
                       LEFT OUTER JOIN environments on reports.environment_id = environments.id
                       LEFT OUTER JOIN report_statuses on reports.status_id = report_statuses.id ) AS reports WHERE status = 'changed') paged_results
                 WHERE
                 (hash, puppet_version, receive_time, report_format,
                 start_time, end_time, transaction_uuid,
                 COALESCE(paged_results.status, ''),
                 COALESCE(paged_results.environment, ''),
                 configuration_version, certname) IN
                 (SELECT DISTINCT
                 hash, puppet_version, receive_time, report_format,
                 start_time, end_time, transaction_uuid,
                 COALESCE(distinct_names.status, ''),
                 COALESCE(distinct_names.environment,''),
                 configuration_version, certname FROM (SELECT reports.certname, reports.configuration_version, reports.containment_path, reports.end_time, reports.environment, reports.event_status, reports.file, reports.hash, reports.line, reports.message, reports.new_value, reports.old_value, reports.property, reports.puppet_version, reports.receive_time, reports.report_format, reports.resource_title, reports.resource_type, reports.start_time, reports.status, reports.timestamp, reports.transaction_uuid FROM ( select reports.hash,
                       reports.certname,
                       reports.puppet_version,
                       reports.report_format,
                       reports.configuration_version,
                       reports.start_time,
                       reports.end_time,
                       reports.receive_time,
                       reports.transaction_uuid,
                       environments.name as environment,
                       report_statuses.status as status,
                       re.report,
                       re.status as event_status,
                       re.timestamp,
                       re.resource_type,
                       re.resource_title,
                       re.property,
                       re.new_value,
                       re.old_value,
                       re.message,
                       re.file,
                       re.line,
                       re.containment_path,
                       re.containing_class
                       FROM reports
                       INNER JOIN resource_events re on reports.hash=re.report
                       LEFT OUTER JOIN environments on reports.environment_id = environments.id
                       LEFT OUTER JOIN report_statuses on reports.status_id = report_statuses.id ) AS reports WHERE status = 'changed') distinct_names )