m
Size: a a a
m
К
К
К
4
К
4
Y
К
Y
И
И
И
И
И
И
P
G
var
.Id
as ID
, c
.Id
as COLOR_ID
, p
.Id
as PROC_ID
, IF( c.FullName != '', c
.FullName
, c
.Name )
as COLOR_NAME
, IF( p
.FullName != '', p
.FullName
, p
.Name )
as PROC_NAME
FROM used_disccp_variant
var
LEFT JOIN used_disccolor
c
ON var
.Color
=c
.Id
LEFT JOIN used_discprocessway
p
ON var
.Processway
=p
.Id
WHERE var
.CompanyId
= '235'Y
P