{
	"name": "query/manager/order/order_row/sales/kaukonenkymalainen_original.json",
	"info": "---- ?? tarkoittaa epäselvää",
	"table": [{
		"record_type": [""],
		"table": "order_row"
	}],
	"query": [
		["sor_HAE_AVOIMET", ["false"]],
		["_set_CREATE", ["sor_tbl", "sor_OpenRows_tmp"]],
		["txt", "=", "600 SONET"],
		["_qry_Fld", ["0", ["pr.product_group", "<>", "600 SONET"], "false", "false"]],
		["_sel_RELATE_MANY_SELECTION", ["ordr.product_id"]],
		["_set_CREATE", ["sor_tbl", "sor_OpenRows_tmp2"]],
		["_set_INTERSECTION", ["sor_tbl", "sor_OpenRows_tmp", "sor_OpenRows_tmp2", "sor_OpenRows_tmp"]],
		["_txt", "=", "KAUKONEN"],
		["_qry_Fld", ["0", ["ord.person_id", "=", "KAUKONEN"], "*", "false", "false"]],
		["_txt", "=", "KYMÄLÄINEN"],
		["_qry_Fld", ["0", ["ord.person_id", "=", "KYMÄLÄINEN"], "|", "false", "false"]],
		["_sel_RELATE_MANY_SELECTION", ["ordr.order_id"]],
		["_set_CREATE", ["sor_tbl", "sor_OpenRows_tmp2"]],
		["_set_INTERSECTION", ["sor_tbl", "sor_OpenRows_tmp", "sor_OpenRows_tmp2", "sor_OpenRows_tmp"]],
		["_set_USE", ["sor_tbl", "sor_OpenRows_tmp"]],
		["_set_CLEAR", ["sor_tbl", "sor_OpenRows_tmp"]],
		["_set_CLEAR", ["sor_tbl", "sor_OpenRows_tmp2"]]
	]
}