{
	"name": "query/link/memori_task_child_count.json",
	"table": [{
		"table": "link",
		"record_type": [""]
	}],
	"parameter": {
		"parent_id_list": "",
		"show_sql": true
	},
	"query": [
		["link.parent_id", "in", "parent_id_list"]
	],
	"qroup_by": ["link.parent_id"],
	"field": ["link.parent_id"],
	"fieldX": ["link.parent_id", {
		"name": "child_count",
		"aggregate": "count(*)"
	}],
	"select_sql_example": "parent_id, count(*) FROM link WHERE link.parent_id IN (parent_id_list) GROUP BY parent_id"
}