query for current dive conditions failed:  
        SELECT 
            r.*,
            COALESCE(
                (
                    SELECT JSON_ARRAYAGG(
                        JSON_OBJECT(
                            'id', i.id,
                            'active', i.active,
                            'image_order', i.image_order,
                            'original_filename', i.original_filename,
                            'large_filename', i.large_filename,
                            'large_web_path', i.large_web_path,
                            'caption', i.caption,
                            'caption_position', i.caption_position,
                            'branding_position', i.branding_position,
                            'alt_text', i.alt_text,
                            'width', i.width,
                            'height', i.height
                        )
                    )
                    FROM rrdc_reef_report.reef_report_images i
                    WHERE i.reef_report_id = r.id
                      AND i.active = 1
                ),
                JSON_ARRAY()
            ) AS images 
        FROM rrdc_reef_report.reports r
        WHERE r.boat != ''
          AND r.location = 'French Reef'
          AND r.active = 'y'        
        ORDER BY r.time_stamp DESC 
        LIMIT 10 OFFSET 860