{
	"name": "query/manager/product/product_work/estimated/productivity_report/old/time_period_old.json",
	"table": [
		{
			"record_type": ["estimated"],
			"table": "product_work"
		}
	],
	"database": "4d",
	"parameter": {
		"end_date2": "",
		"load_group": [
				
			],
		"show_sql": true,
		"start_date2": "",
		"subqueryX": "SELECT record_id FROM work_phase_estimated WHERE CONCAT(work__position_num_id, CONCAT('#', phase_number)) IN (SELECT CONCAT(work__position_num_id, CONCAT('#', work_phase_est_id)) FROM work_phase_actual WHERE date_ BETWEEN '{{start_date2}}' AND '{{end_date2}}' AND work_load_group_id IN ({{load_group}}))",
		"work_pos_num": [
				
			]
	},
	"field": ["prwo.json_data.work__position_num_id", "prwo.json_data.phase_number", "prwo.work_hours"],
	"query": [
		["prwo.json_data.work__position_num_id", "in", "work_pos_num"]
	],
	"queryX": [
		["prwo.record_id", "in", "subquery"]
	]
}