SELECT 
	v.number,
	v.model, 
	v.addressing,
	sum(v.PLU_NEW) as PLU_NEW,
	sum(v.PLU_LOAD) as PLU_LOAD,
	sum(v.PLU_LOADED) as PLU_LOADED,
	sum(v.PLU_ERROR) as PLU_ERROR,
	sum(v.OFFLINE_ERROR) as OFFLINE_ERROR,
	v.name,
	v.plu_generation_method
 from 
(
select 
	distinct
	s.number,
	s.code,
	s.model, 
	s.addressing,
	case l0.status when 0 then 1 else 0 end as PLU_NEW,
	case l1.status when 1 then 1 else 0 end as PLU_LOAD,
	case l2.status when 2 then 1 else 0 end as PLU_LOADED,
	case l3.status when 3 then 1 else 0 end as PLU_ERROR,
	case l3_p.status when 3 then 1 else 0 end as OFFLINE_ERROR,
	l0.id,
	l1.id,
	l2.id,
	l3.id,
	l3_p.id,
	t.name,
	t.plu_generation_method
from 
	scales_scales s 
	join scales_template t on t.id = s.scales_template_id
	join scales_plues p on 1=1
	left join scales_linktoplu l1  on l1.scales_code = s.code and p.id = l1.id_plu and l1.status = 1
	left join scales_linktoplu l2  on l2.scales_code = s.code and p.id = l2.id_plu and l2.status = 2
	left join scales_linktoplu l3  on l3.scales_code = s.code and p.id = l3.id_plu and l3.status = 3 and l3.lasterrorcode <> 'PORT-ERROR'
	left join scales_linktoplu l3_p on l3_p.scales_code = s.code and p.id = l3_p.id_plu and l3_p.status = 3 and l3_p.lasterrorcode = 'PORT-ERROR'
	left join scales_linktoplu l0  on l0.scales_code = s.code and p.id = l0.id_plu and l0.status = 0
where 
	s.deleted = false
) v
group by 
	number,
	model, 
	addressing,
	name,
	plu_generation_method
order by 
	number

TRUNCATE scales_productentity CASCADE;

UPDATE un_cg_price
SET    senttoscales = FALSE
WHERE  product_marking IN
        (SELECT markingofthegood
         FROM   un_cg_product_weight)
       AND (enddate IS null OR enddate > now());

UPDATE un_cg_price
SET    senttoscales = FALSE
WHERE  product_marking IN (SELECT markingofthegood
                           FROM   un_cg_product
                           WHERE  plugin_class_name =
              'ru.crystals.pos.catalog.billets.ProductPieceWeightEntityBillet'
                                  AND status = '99')
       AND (enddate IS null OR enddate > now());

TRUNCATE scales_productentity CASCADE;

UPDATE un_cg_price
SET    senttoscales = FALSE
WHERE  product_marking IN (SELECT markingofthegood
                           FROM   un_cg_product_weight)
       AND ( enddate IS NULL
              OR enddate > Now() ); 

UPDATE un_cg_price
SET    senttoscales = FALSE
WHERE  product_marking IN (SELECT markingofthegood
                           FROM   un_cg_product
                           WHERE  plugin_class_name =
              'ru.crystals.pos.catalog.billets.ProductPieceWeightEntityBillet'
                                  AND status = '99')
       AND ( enddate IS NULL
              OR enddate > Now() ); 

SELECT distinct
          ucp.product_marking, ucp.*,
          ucl.*
FROM
          un_cg_price ucp
          join
                    un_cg_barcode ucb
                    on
                    ucb.product_marking = ucp.product_marking
          left join
                    un_cg_likond ucl
                    on
                    substring(ucp.product_marking from 1 for 6) = ucl.marking
where
          ucp.begindate          < now()
          and (ucp.enddate is null or ucp.enddate        > now())
          and ucp.senttoscales   = false
          and ucp.product_status = 99
          and ucp.product_marking in
          (
                 SELECT
                        markingofthegood
                 from
                        un_cg_product_weight
          )
          and
          (
                    (
                              ucl.begin_date   < (now()-'10 minutes'::interval)
                              and ucl.end_date > now())
                    or ucl.marking is null)

SELECT *
FROM   scales_linktoplu slp
       left join scales_scales ss
              ON (slp.scales_code = ss.code)
       left join scales_plues sp
              ON (slp.id_plu = sp."id")
WHERE  ss.number = 'номер весов'
       AND sp."number" IN ('номер plu')