SELECT FROM SELECT collaboration_id created_at created_by finished_at

1
SELECT r.* FROM (SELECT collaboration_id,created_at,created_by,finished_at AS completed_at,definition_id,from_mosaic,is_simulation,instance_id AS id,name,type,version,file,OBJECT_VALUES(resources_executed) as resources_executed,CASE WHEN status.failed THEN "failed" WHEN status.terminated THEN "terminated" WHEN status.completed THEN "completed" WHEN status.suspended THEN "suspended" ELSE "running" END AS status,status AS status_raw,terminated,OBJECT_LENGTH(tokens) as tokens,updated_at,updated_by,OBJECT_VALUES(activities) as activities,tenant FROM default t WHERE REGEXP_LIKE(META(t).id, 'instances:.*')) r WHERE 1 AND tenant IN ['nextflow'] ORDER BY META(default).id LIMIT 10