T1._Q_001_F_001,
T1._Q_001_F_002RRef,
T1._Q_001_F_003RRef,
T1._Q_001_F_004RRef,
T1._Q_001_F_005RRef,
MIN(CASE WHEN T2._Q_001_F_049 IS NULL THEN FALSE ELSE TRUE END),
MAX(CASE WHEN (T1._Q_001_F_010 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_009RRef END),
MAX(CASE WHEN (T1._Q_001_F_010 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_008 ELSE FALSE END),
MAX(T1._Q_001_F_010),
MAX(CASE WHEN (T1._Q_001_F_011 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_012RRef END),
MAX(CASE WHEN (T1._Q_001_F_011 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_011 ELSE FALSE END),
MAX(T1._Q_001_F_011),
MAX(CASE WHEN (T1._Q_001_F_012 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_015_TYPE END),
CASE WHEN MAX(CASE WHEN (T1._Q_001_F_012 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_015_TYPE END) = '\\010'::bytea THEN SUBSTR(MAX(CASE WHEN (T1._Q_001_F_012 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_015_RTRef END || CASE WHEN (T1._Q_001_F_012 > CAST(0 AS NUMERIC)) THEN T2._Q_001_F_015_RRRef END),1,4) ELSE CASE WHEN MAX(CASE WHEN (T1._Q_001_F_012 > CAST(0 AS
нет
Если подскажите манипуляции, то постараюсь помочь полный запрос достать
Обсуждают сегодня