Entry 3094

SELECT
	P.DOR_KOD, P.PUTST_ID, P.ID_STP, P.ID_NPK, 
	MS KMMN, MS KMMK,

	CASE WHEN J.LMM IS NULL OR J.LMM=0 
	THEN 1000
	ELSE J.LMM END L
FROM
	ICP0.HP_STP P
LEFT JOIN
	IPV0.H_STP_X X 
	ON (P.ID_STP=X.ID_STP 
		AND X.DOR_KOD=P.DOR_KOD 
		AND X.DATE_KD='31.12.2009')
LEFT JOIN
	IC00.H_STP_PRJ J
	ON	(X.ID_PROJECT=J.STP_PRJ_ID
		AND J.DATE_KD='31.12.9999')
WHERE
	P.DATE_KD='31.12.9999'
	AND P.DOR_KOD=61
	AND VALUE(P.PUTST_ID, 0)>0