>     CASE 
>         WHEN K4.Id Is Not Null  THEN K4.Id 
>         WHEN K3.Id Is Not Null THEN K3.Id
>         WHEN K2.Id Is Not Null THEN K2.Id
>         ELSE K1.Id END AS "priceId",

ne geriau tokį keisą keisti į COALESCE?

-- 
bn/mj
skype : bala.nemate
"The blues ain't about making yourself feel better.
it's about making other people feel worse."
				-- Bleeding Gums Murphy