Submitted by: Ivan Pisarevsky (ivan_pisarevsky)

when client tries to execute query with "wide" resultset (more then 64k) client "becomes crazy".
server 3.0 with client 3.0 and server2.5 with client 2.5 works correctly.
test case below

SET SQL DIALECT 3;

SET NAMES WIN1251;

CREATE DATABASE 'test.fdb'
USER 'SYSDBA'
PAGE_SIZE 8192
DEFAULT CHARACTER SET WIN1251 COLLATION WIN1251;

CREATE TABLE GROUPS_SPAG_PARAM (
ID_GR NUMERIC(18,0) DEFAULT 0 NOT NULL,
SPAG_PARAM NUMERIC(18,0) DEFAULT 0 NOT NULL,
SORTINDEX INTEGER DEFAULT 0 NOT NULL,
PVALUE VARCHAR(2048) DEFAULT '' NOT NULL COLLATE PXW_CYRL,
LOGIN VARCHAR(20) DEFAULT current_user NOT NULL COLLATE PXW_CYRL,
TIMEP TIMESTAMP DEFAULT current_timestamp NOT NULL,
IS_FILTER SMALLINT
);

CREATE TABLE SPAG (
ID NUMERIC(18,0) NOT NULL,
SUBGR NUMERIC(18,0) DEFAULT -1 NOT NULL,
OPLGR NUMERIC(18,0) DEFAULT 0 NOT NULL,
IND VARCHAR(10) NOT NULL COLLATE PXW_CYRL,
DIND VARCHAR(10) DEFAULT '' NOT NULL COLLATE PXW_CYRL,
PRIND VARCHAR(10) COLLATE PXW_CYRL,
PRIZNAK VARCHAR(10) NOT NULL COLLATE PXW_CYRL,
NAME VARCHAR(50) NOT NULL COLLATE PXW_CYRL,
XAR VARCHAR(20) COLLATE PXW_CYRL,
COLSIZ VARCHAR(20) COLLATE PXW_CYRL,
PROIZV VARCHAR(10) COLLATE PXW_CYRL,
VES NUMERIC(15,3) NOT NULL,
ED_IZM VARCHAR(4) COLLATE PXW_CYRL,
FAS CHAR(1) COLLATE PXW_CYRL,
ARTIC VARCHAR(21) COLLATE PXW_CYRL,
KOLF NUMERIC(18,3) DEFAULT 1 NOT NULL,
KDK NUMERIC(18,4) DEFAULT 0,
BRAND NUMERIC(18,0) DEFAULT 0 NOT NULL,
PRO_ID NUMERIC(18,0) DEFAULT 0 NOT NULL,
PRCOUNTRY SMALLINT DEFAULT 0 NOT NULL,
IND_TARA VARCHAR(8) COLLATE PXW_CYRL,
OT_LOGIST VARCHAR(20),
OT_MARKET VARCHAR(20),
"PACKAGE" CHAR(1) COLLATE PXW_CYRL,
L_TOV NUMERIC(6,2) DEFAULT 0 NOT NULL,
W_TOV NUMERIC(6,2) DEFAULT 0 NOT NULL,
H_TOV NUMERIC(6,2) DEFAULT 0 NOT NULL,
V_BRUT NUMERIC(6,3) DEFAULT 0 NOT NULL,
V_UPAK NUMERIC(6,3) DEFAULT 0 NOT NULL,
BARSTOP SMALLINT DEFAULT 0 NOT NULL,
SNABSTOP SMALLINT DEFAULT 0 NOT NULL,
LG SMALLINT DEFAULT 0 NOT NULL,
SP SMALLINT DEFAULT 0 NOT NULL,
SEGM SMALLINT DEFAULT 0 NOT NULL,
SEZON INTEGER DEFAULT 0 NOT NULL,
OKEI VARCHAR(4) COLLATE PXW_CYRL,
NP SMALLINT DEFAULT 0 NOT NULL,
SROK INTEGER DEFAULT -1 NOT NULL,
O_L SMALLINT DEFAULT 0 NOT NULL,
R_L SMALLINT DEFAULT 0 NOT NULL,
SN SMALLINT DEFAULT 0 NOT NULL,
SK SMALLINT DEFAULT 0 NOT NULL,
PRC NUMERIC(5,2) DEFAULT 0 NOT NULL,
GIFT SMALLINT DEFAULT 0 NOT NULL,
GUID VARCHAR(38) DEFAULT '' NOT NULL,
VID_TARA VARCHAR(50) COLLATE PXW_CYRL,
DATA DATE DEFAULT CURRENT_DATE,
LAST_UPD TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
LAST_LOGIN VARCHAR(20) DEFAULT CURRENT_USER COLLATE PXW_CYRL,
PST_CODE VARCHAR(10) COLLATE PXW_CYRL,
L_TM NUMERIC(6,2) DEFAULT 0,
W_TM NUMERIC(6,2) DEFAULT 0,
H_TM NUMERIC(6,2) DEFAULT 0,
BARCODE VARCHAR(13) COLLATE PXW_CYRL,
CENGR VARCHAR(2) COLLATE PXW_CYRL,
STATUS SMALLINT DEFAULT 0,
STATUS1 SMALLINT DEFAULT 0,
FOR_MIN DATE,
UTIL VARCHAR(5) COLLATE PXW_CYRL,
CLIM NUMERIC(7,2) DEFAULT 0,
CMP SMALLINT DEFAULT 0,
SNABGR NUMERIC(18,0) DEFAULT 0,
INFO VARCHAR(10) COLLATE PXW_CYRL,
VISIBLE SMALLINT DEFAULT 1 NOT NULL,
LOGIN VARCHAR(20) DEFAULT USER NOT NULL
);

CREATE TABLE SPAG_PARAM (
ID NUMERIC(18,0) NOT NULL,
GUID VARCHAR(38) DEFAULT '' NOT NULL,
NAME VARCHAR(100) NOT NULL COLLATE PXW_CYRL,
PTYPE INTEGER DEFAULT 0 NOT NULL,
OKEI VARCHAR(4) DEFAULT '000' NOT NULL COLLATE PXW_CYRL,
TIMEP TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
LAST_UPD TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
LOGIN VARCHAR(20) DEFAULT CURRENT_USER NOT NULL
);

CREATE TABLE SPAG_PARAM_VALUE (
SPAG NUMERIC(18,0) NOT NULL,
PARAM NUMERIC(18,0) NOT NULL,
PVALUE VARCHAR(2048) NOT NULL COLLATE PXW_CYRL,
FC SMALLINT DEFAULT 1 NOT NULL,
SORTINDEX INTEGER DEFAULT 0 NOT NULL,
TIMEP TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
LAST_UPD TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
LOGIN VARCHAR(20) DEFAULT CURRENT_USER NOT NULL
);

INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 90, 1, '0', 'A.HAZOVA', '2014-09-16 10:20:40', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 90, 1, '0', 'A.HAZOVA', '2014-09-16 10:20:40', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 706, 3, '0', 'A.HAZOVA', '2014-09-16 10:20:44', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 706, 2, '0', 'A.HAZOVA', '2014-09-16 10:20:44', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 1341, 5, '0', 'A.HAZOVA', '2014-09-16 10:20:56', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 1341, 4, '0', 'A.HAZOVA', '2014-09-16 10:20:56', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 184, 7, '0', 'A.HAZOVA', '2014-09-16 10:21:06', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 184, 6, '0', 'A.HAZOVA', '2014-09-16 10:21:06', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 185, 8, '0', 'A.HAZOVA', '2014-09-16 10:21:33', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 185, 7, '0', 'A.HAZOVA', '2014-09-16 10:21:33', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 362, 12, '0', 'A.HAZOVA', '2014-09-16 10:21:38', NULL);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 362, 10, '0', 'A.HAZOVA', '2014-09-16 10:21:38', NULL);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 9, 13, '0', 'A.HAZOVA', '2014-09-16 10:21:41', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 9, 11, '0', 'A.HAZOVA', '2014-09-16 10:21:41', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 1323, 14, '0', 'A.HAZOVA', '2014-09-16 10:31:02', NULL);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 1323, 12, '0', 'A.HAZOVA', '2014-09-16 10:31:02', NULL);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 1641, 9, '0', 'A.HAZOVA', '2016-01-29 17:51:09', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 1641, 11, '0', 'A.HAZOVA', '2016-01-29 17:51:27', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 1467, 15, '', 'A.HAZOVA', '2017-01-13 11:18:02', 0);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 1467, 13, '', 'A.HAZOVA', '2017-01-13 11:18:02', 0);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 1342, 6, '0', 'A.ZABAVIN', '2015-12-15 16:43:28', 0);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 1342, 5, '0', 'A.ZABAVIN', '2015-12-15 16:43:28', 0);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, -141, 2, '0', 'A.ZABAVIN', '2015-12-15 16:44:00', 0);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 196, 9, '0', 'A.ZABAVIN', '2015-12-15 16:47:27', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 1438, 0, '', 'A.ZABAVIN', '2016-01-12 15:43:31', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 1438, 0, '', 'A.ZABAVIN', '2016-01-12 15:43:31', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9064, 158, 4, '', 'A.ZABAVIN', '2016-01-12 15:43:49', 1);
INSERT INTO GROUPS_SPAG_PARAM (ID_GR, SPAG_PARAM, SORTINDEX, PVALUE, LOGIN, TIMEP, IS_FILTER) VALUES (9065, 158, 3, '', 'A.ZABAVIN', '2016-01-12 15:43:49', 1);
INSERT INTO SPAG (ID, SUBGR, OPLGR, IND, DIND, PRIND, PRIZNAK, NAME, XAR, COLSIZ, PROIZV, VES, ED_IZM, FAS, ARTIC, KOLF, KDK, BRAND, PRO_ID, PRCOUNTRY, IND_TARA, OT_LOGIST, OT_MARKET, "PACKAGE", L_TOV, W_TOV, H_TOV, V_BRUT, V_UPAK, BARSTOP, SNABSTOP, LG, SP, SEGM, SEZON, OKEI, NP, SROK, O_L, R_L, SN, SK, PRC, GIFT, GUID, VID_TARA, DATA, LAST_UPD, LAST_LOGIN, PST_CODE, L_TM, W_TM, H_TM, BARCODE, CENGR, STATUS, STATUS1, FOR_MIN, UTIL, CLIM, CMP, SNABGR, INFO, VISIBLE, LOGIN) VALUES (14001, 9065, 5137, '15102лк', '15102лк', '15102лк', 'инстр', 'Дрель 6408', '530Вт БЗП', '10мм рег об рев', 'Makita', 1, 'шт', 'м', '6408', 1, 0, 216, 189, 840, NULL, 'I.ZABAVINA', 'S.POPOV', NULL, 22.5, 8, 29.5, 2.8, 0, 0, 0, 0, 0, 3, 0, '796', 0, -1, 1, 0, 0, 0, 0, 0, '862dbc56-9fdf-e011-8d39-00259018b8c8', NULL, '2002-10-14', '2015-08-17 15:41:04', 'S.POPOV', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, '', 0, 0, 0, NULL, 1, 'SYSDBA');
INSERT INTO SPAG (ID, SUBGR, OPLGR, IND, DIND, PRIND, PRIZNAK, NAME, XAR, COLSIZ, PROIZV, VES, ED_IZM, FAS, ARTIC, KOLF, KDK, BRAND, PRO_ID, PRCOUNTRY, IND_TARA, OT_LOGIST, OT_MARKET, "PACKAGE", L_TOV, W_TOV, H_TOV, V_BRUT, V_UPAK, BARSTOP, SNABSTOP, LG, SP, SEGM, SEZON, OKEI, NP, SROK, O_L, R_L, SN, SK, PRC, GIFT, GUID, VID_TARA, DATA, LAST_UPD, LAST_LOGIN, PST_CODE, L_TM, W_TM, H_TM, BARCODE, CENGR, STATUS, STATUS1, FOR_MIN, UTIL, CLIM, CMP, SNABGR, INFO, VISIBLE, LOGIN) VALUES (21478, 9064, 5137, '22310лк', '22310лк', '22310лк', 'инстр', 'Дрель BUR-150 CET KL(бзп) ударная рег.момента', '600Вт БЗП', '13мм рег об рев', 'Sparky', 1, 'шт', 'м', '1(2)0000011701', 1, 0, 221, 328, 156, NULL, 'I.ZABAVINA', 'S.POPOV', NULL, 22.5, 8, 29.5, 2.8, 0, 0, 0, 0, 0, 2, 0, '796', 0, -1, 0, 0, 0, 0, 0, 0, '087c8bc4-a0df-e011-8d39-00259018b8c8', NULL, '2004-02-26', '2016-07-20 13:04:06', 'E.AKIFIEVA', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, '', 0, 0, 0, NULL, 1, 'SYSDBA');
INSERT INTO SPAG (ID, SUBGR, OPLGR, IND, DIND, PRIND, PRIZNAK, NAME, XAR, COLSIZ, PROIZV, VES, ED_IZM, FAS, ARTIC, KOLF, KDK, BRAND, PRO_ID, PRCOUNTRY, IND_TARA, OT_LOGIST, OT_MARKET, "PACKAGE", L_TOV, W_TOV, H_TOV, V_BRUT, V_UPAK, BARSTOP, SNABSTOP, LG, SP, SEGM, SEZON, OKEI, NP, SROK, O_L, R_L, SN, SK, PRC, GIFT, GUID, VID_TARA, DATA, LAST_UPD, LAST_LOGIN, PST_CODE, L_TM, W_TM, H_TM, BARCODE, CENGR, STATUS, STATUS1, FOR_MIN, UTIL, CLIM, CMP, SNABGR, INFO, VISIBLE, LOGIN) VALUES (89963, 9065, 5137, '89963лк', '89963лк', '89963лк', 'инстр', 'Дрель 6413', '450Вт БЗП', '10мм рег об рев', 'Makita', 1, 'шт', 'м', '6413', 1, 0, 216, 189, 156, NULL, 'I.ZABAVINA', 'S.POPOV', NULL, 22.5, 8, 29.5, 2.8, 0, 0, 0, 0, 0, 3, 0, '796', 0, -1, 1, 0, 0, 0, 0, 0, 'c0322595-501f-e111-a94d-00259018b8c8', NULL, '2008-10-06', '2010-10-16 01:57:28', 'SYSDBA', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, 1, 'S.DANILOVA');
INSERT INTO SPAG (ID, SUBGR, OPLGR, IND, DIND, PRIND, PRIZNAK, NAME, XAR, COLSIZ, PROIZV, VES, ED_IZM, FAS, ARTIC, KOLF, KDK, BRAND, PRO_ID, PRCOUNTRY, IND_TARA, OT_LOGIST, OT_MARKET, "PACKAGE", L_TOV, W_TOV, H_TOV, V_BRUT, V_UPAK, BARSTOP, SNABSTOP, LG, SP, SEGM, SEZON, OKEI, NP, SROK, O_L, R_L, SN, SK, PRC, GIFT, GUID, VID_TARA, DATA, LAST_UPD, LAST_LOGIN, PST_CODE, L_TM, W_TM, H_TM, BARCODE, CENGR, STATUS, STATUS1, FOR_MIN, UTIL, CLIM, CMP, SNABGR, INFO, VISIBLE, LOGIN) VALUES (124015, 9065, 0, '124015лк', '124015лк', '124015лк', 'инстр', 'Дрель DP4011', '720Вт БЗП', '13мм', 'Makita', 1, 'шт', 'м', 'DP4011', 1, 0, 216, 189, 0, NULL, 'I.ZABAVINA', 'S.POPOV', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '796', 0, -1, 0, 0, 0, 0, 0, 0, '4a1aab50-6331-e111-9d14-00259018b8c8', NULL, '2011-04-12', '2011-04-22 12:02:50', 'S.MAKSIMOVA', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, 1, 'S.DANILOVA');
INSERT INTO SPAG (ID, SUBGR, OPLGR, IND, DIND, PRIND, PRIZNAK, NAME, XAR, COLSIZ, PROIZV, VES, ED_IZM, FAS, ARTIC, KOLF, KDK, BRAND, PRO_ID, PRCOUNTRY, IND_TARA, OT_LOGIST, OT_MARKET, "PACKAGE", L_TOV, W_TOV, H_TOV, V_BRUT, V_UPAK, BARSTOP, SNABSTOP, LG, SP, SEGM, SEZON, OKEI, NP, SROK, O_L, R_L, SN, SK, PRC, GIFT, GUID, VID_TARA, DATA, LAST_UPD, LAST_LOGIN, PST_CODE, L_TM, W_TM, H_TM, BARCODE, CENGR, STATUS, STATUS1, FOR_MIN, UTIL, CLIM, CMP, SNABGR, INFO, VISIBLE, LOGIN) VALUES (206304, 9065, 0, '206304лк', '206304лк', '206304лк', 'инстр', 'Дрель BE 650', '650Вт БЗП', '13мм рег об рев', 'Metabo', 1, 'шт', 'м', '600360930', 1, 0, 219, 389, 156, NULL, 'I.ZABAVINA', 'S.POPOV', NULL, 32, 26, 8.5, 2.23, 0, 0, 0, 0, 0, 0, 0, '796', 0, -1, 0, 0, 0, 0, 0, 0, '238bc5f2-d664-4977-981e-e917473aff24', NULL, '2017-01-24', '2017-01-24 13:25:03', 'S.POPOV', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, 0, NULL, 1, 'S.POPOV');
INSERT INTO SPAG (ID, SUBGR, OPLGR, IND, DIND, PRIND, PRIZNAK, NAME, XAR, COLSIZ, PROIZV, VES, ED_IZM, FAS, ARTIC, KOLF, KDK, BRAND, PRO_ID, PRCOUNTRY, IND_TARA, OT_LOGIST, OT_MARKET, "PACKAGE", L_TOV, W_TOV, H_TOV, V_BRUT, V_UPAK, BARSTOP, SNABSTOP, LG, SP, SEGM, SEZON, OKEI, NP, SROK, O_L, R_L, SN, SK, PRC, GIFT, GUID, VID_TARA, DATA, LAST_UPD, LAST_LOGIN, PST_CODE, L_TM, W_TM, H_TM, BARCODE, CENGR, STATUS, STATUS1, FOR_MIN, UTIL, CLIM, CMP, SNABGR, INFO, VISIBLE, LOGIN) VALUES (207989, 9064, 0, '207989лк', '207989лк', '207989лк', 'инстр', 'Дрель DP2011', '370Вт ЗВП', '6.5мм', 'Makita', 1, 'шт', 'м', 'DP2011', 1, 0, 216, 189, 156, NULL, 'I.ZABAVINA', 'S.POPOV', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '796', 0, -1, 0, 0, 0, 0, 0, 0, '2f4459d6-c9f5-49d4-82ca-5b88d8d2ef0f', NULL, '2017-02-16', '2017-02-16 15:47:46', 'I.ZABAVINA', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, 0, NULL, 1, 'I.ZABAVINA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (9, '82091f7e-7204-e111-8bb1-00259018b8c8', 'Вес,', 1, '166', '1858-11-17 00:00:00', '1858-11-17 00:00:00', 'ALEX');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (-107, '8e60a750-d2db-e111-b54a-00259018b8c8', 'Наличие реверса', 5, '000', '2012-08-01 16:13:34', '2012-08-01 16:13:34', 'V.TONKONOG');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (90, 'd611227e-7204-e111-8bb1-00259018b8c8', 'Мощность,', 1, '212', '1858-11-17 00:00:00', '2013-11-08 11:57:55', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (-112, '0e33b950-d2db-e111-b54a-00259018b8c8', 'Крутящий момент max, (Нм)', 1, '000', '2012-08-01 16:13:34', '2012-08-01 16:13:34', 'V.TONKONOG');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (144, 'd28973c8-83b0-e111-a5a5-00259018b8c8', 'Длина кабеля,', 1, '006', '1858-11-17 00:00:00', '1858-11-17 00:00:00', 'A.MARSHEV');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (158, 'bac60faa-2abc-e111-a191-00259018b8c8', 'Тип патрона', 5, '000', '1858-11-17 00:00:00', '1858-11-17 00:00:00', 'I.PRIHODCHENKO');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (184, 'c4e2c1b1-5ebc-e111-9db3-00259018b8c8', 'Диаметр сверления (дерево) max,', 1, '003', '1858-11-17 00:00:00', '2014-02-12 11:50:15', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (185, 'c4e2e4b6-5ebc-e111-9db3-00259018b8c8', 'Диаметр сверления (сталь) max,', 1, '003', '1858-11-17 00:00:00', '2014-02-12 11:50:32', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (362, 'bc42a14f-59f6-e111-a9cd-00259018b8c8', 'Упаковка', 5, '000', '2012-09-04 10:25:24', '2012-09-04 10:25:24', 'S.POPOV');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (196, 'd6c2934e-82bf-e111-81ab-00259018b8c8', 'Диаметр сверления (кирпич) max,', 1, '003', '1858-11-17 00:00:00', '2014-02-12 11:50:23', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (277, 'cab1f4b4-91bf-e111-81ab-00259018b8c8', 'Наличие подсветки', 5, '000', '1858-11-17 00:00:00', '1858-11-17 00:00:00', 'V.TONKONOG');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1438, 'd436e9bd-468d-2500-9018-b8c800040000', 'Тип дрели', 5, '000', '2015-01-15 11:16:01', '2015-01-15 11:16:01', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (-8, '261bfa7a-51c4-e111-b5d4-00259018b8c8', 'Поддержание постоянных оборотов под нагрузкой', 5, '000', '2012-07-06 12:00:00', '2012-07-06 12:00:00', 'SYSDBA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (-113, '7a7bc850-d2db-e111-b54a-00259018b8c8', 'Диаметр сверления (бетон) max,', 1, '003', '2012-08-01 16:13:34', '2012-08-01 16:13:34', 'V.TONKONOG');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (-141, '705140a5-6bdc-e111-ab2c-00259018b8c8', 'Кол-во ударов, (уд/мин)', 0, '000', '2012-08-02 10:31:08', '2012-08-02 10:31:08', 'V.TONKONOG');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1341, '5aee9fa8-f8b2-2500-9018-b8c8f0530f41', 'Размер патрона max,', 1, '003', '2014-07-03 15:24:55', '2014-07-03 15:24:55', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1342, 'ca4c9cb0-f8b2-2500-9018-b8c8f0530f41', 'Размер патрона min,', 1, '003', '2014-07-03 15:25:08', '2014-07-03 15:25:08', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1466, '3cf28207-fd8d-2500-9018-b8c800040000', 'Яндекс.Маркет', 1, '000', '2015-04-16 13:55:00', '2015-04-16 13:55:00', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1467, '4425a765-8385-2500-9018-b8c800040000', 'Гарантия производителя', 5, '000', '2015-05-12 15:49:58', '2015-05-12 15:49:58', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (706, '30e5a547-01b0-2500-9018-b8c8e0aff4e7', 'Кол-во скоростей', 5, '000', '2013-02-01 11:44:59', '2013-02-01 11:44:59', 'S.POPOV');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1234, '880d0f3f-f0ab-2500-9018-b8c8f0b339c4', 'Автоматическое отключение при износе щетки', 5, '000', '2013-12-16 11:47:00', '2013-12-16 11:47:00', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1323, '52228d5f-88a0-2500-9018-b8c8f063d972', 'Гарантия,', 1, '366', '2014-05-26 11:28:46', '2014-05-26 11:28:46', 'A.HAZOVA');
INSERT INTO SPAG_PARAM (ID, GUID, NAME, PTYPE, OKEI, TIMEP, LAST_UPD, LOGIN) VALUES (1641, 'ae00c834-9483-2500-9067-2abe34000000', 'Число оборотов max,', 1, '331', '2016-01-29 16:00:00', '2016-01-29 16:00:00', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 144, '2', 1, 8, '2016-02-04 14:59:53', '2016-06-23 16:12:27', 'E.HOHLOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 1342, '1', 1, 5, '2016-02-04 14:59:53', '2016-06-23 16:11:45', 'E.HOHLOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 1466, '1039521', 1, 15, '2015-08-24 19:16:15', '2015-08-24 19:16:15', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 1467, 'Да', 1, 16, '2015-08-24 19:16:18', '2017-01-12 17:17:19', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 1466, '949175', 1, 14, '2015-09-25 14:47:41', '2015-09-25 14:47:41', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 144, '2.5', 1, 8, '2016-04-12 11:34:21', '2016-06-23 16:04:35', 'E.HOHLOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 1342, '1.5', 1, 5, '2016-04-12 11:34:21', '2016-06-23 16:03:12', 'E.HOHLOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 1342, '1.5', 1, 6, '2016-05-10 16:46:40', '2016-12-22 12:22:33', 'I.OHOTNIKOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 196, '15', 1, 9, '2016-05-10 16:46:40', '2016-12-22 12:23:00', 'I.OHOTNIKOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 1467, 'Да', 1, 13, '2017-01-12 17:17:19', '2017-04-11 09:46:40', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 1467, 'Да', 1, 13, '2017-01-12 17:17:19', '2017-01-13 13:03:38', 'D.TRIFONOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 1467, '0', 1, 15, '2017-01-17 14:59:49', '2017-01-17 14:59:49', 'I.ZABAVINA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 90, '650', 1, 1, '2017-01-25 16:14:39', '2017-01-25 16:19:27', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 706, '1', 1, 2, '2017-01-25 16:14:39', '2017-01-25 16:19:37', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 1341, '13', 1, 4, '2017-01-25 16:14:39', '2017-01-25 16:20:04', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 184, '30', 1, 6, '2017-01-25 16:14:39', '2017-01-25 16:20:33', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 185, '13', 1, 7, '2017-01-25 16:14:39', '2017-01-25 16:20:42', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 362, 'картонная коробка', 1, 10, '2017-01-25 16:14:39', '2017-01-25 16:20:59', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 9, '1.8', 1, 11, '2017-01-25 16:14:39', '2017-01-25 16:21:10', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 1323, '1', 1, 12, '2017-01-25 16:14:39', '2017-01-25 16:21:23', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 1641, '2800', 1, 9, '2017-01-25 16:14:39', '2017-01-25 16:20:50', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 1467, 'Да', 1, 13, '2017-01-25 16:14:39', '2017-01-25 16:21:31', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 1342, '1.5', 1, 5, '2017-01-25 16:14:39', '2017-01-25 16:20:19', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 1438, 'безударная', 1, 0, '2017-01-25 16:14:39', '2017-01-25 16:19:10', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (206304, 158, 'быстрозажимной', 1, 3, '2017-01-25 16:14:39', '2017-01-25 16:19:54', 'S.POPOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 90, '0', 1, 1, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 706, '0', 1, 3, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 1341, '0', 1, 5, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 184, '0', 1, 7, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 185, '0', 1, 8, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 362, '0', 1, 12, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 9, '0', 1, 13, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 1323, '0', 1, 14, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 1641, '0', 1, 11, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 1467, '0', 1, 15, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 1342, '0', 1, 6, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, -141, '0', 1, 2, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 196, '0', 1, 9, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 1438, '0', 1, 0, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (207989, 158, '0', 1, 4, '2017-04-11 09:46:43', '2017-04-11 09:46:43', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 1323, '1', 1, 12, '2012-09-04 12:55:52', '2016-02-04 14:59:53', 'S.PENIN');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 90, '720', 1, 1, '2012-08-01 16:13:34', '2014-12-24 09:11:19', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 706, '2', 1, 2, '2012-08-01 16:13:34', '2016-04-12 11:34:21', 'N.VASENEVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 1341, '13', 1, 4, '2012-08-01 16:13:34', '2016-04-12 11:34:21', 'N.VASENEVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 184, '40', 1, 6, '2012-08-01 16:13:34', '2014-12-24 09:11:19', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 185, '13', 1, 7, '2012-08-01 16:13:34', '2015-01-27 14:39:14', 'A.VDOVENKO');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 1641, '2900', 1, 9, '2012-08-01 16:13:34', '2016-04-12 11:34:21', 'N.VASENEVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, -8, 'Нет', 1, 14, '2012-08-01 16:13:34', '2016-04-14 16:20:32', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 1234, 'Нет', 1, 15, '2012-08-01 16:13:34', '2016-04-14 15:50:47', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 277, 'Нет', 1, 16, '2012-08-01 16:13:34', '2016-04-14 16:24:44', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, -107, 'Да', 1, 17, '2012-08-01 16:13:34', '2016-04-14 16:25:11', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 9, '2.2', 1, 11, '2012-08-01 16:13:34', '2016-04-12 11:34:21', 'N.VASENEVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 90, '530', 1, 1, '2012-08-01 16:13:34', '2014-12-17 17:02:48', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 706, '1', 1, 2, '2012-08-01 16:13:34', '2016-06-22 09:21:30', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 184, '25', 1, 6, '2012-08-01 16:13:34', '2014-06-30 12:47:08', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 185, '10', 1, 7, '2012-08-01 16:13:34', '2015-01-21 16:19:47', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 1641, '2500', 1, 9, '2012-08-01 16:13:34', '2016-06-22 09:21:30', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 277, 'Нет', 1, 12, '2012-08-01 16:13:34', '2016-04-14 16:24:44', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, -107, 'Да', 1, 13, '2012-08-01 16:13:34', '2016-04-14 16:25:11', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 9, '1.4', 1, 11, '2012-08-01 16:13:34', '2016-06-22 09:21:30', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 90, '450', 1, 1, '2012-08-01 16:13:34', '2014-12-24 09:11:35', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 706, '1', 1, 2, '2012-08-01 16:13:34', '2016-04-04 09:31:27', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 184, '25', 1, 6, '2012-08-01 16:13:34', '2014-12-24 09:11:35', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 185, '10', 1, 7, '2012-08-01 16:13:34', '2015-01-22 12:37:57', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 1641, '3000', 1, 9, '2012-08-01 16:13:34', '2016-02-04 14:59:53', 'S.PENIN');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 277, 'Нет', 1, 12, '2012-08-01 16:13:34', '2016-04-14 16:24:44', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, -107, 'Да', 1, 14, '2012-08-01 16:13:34', '2016-04-14 16:25:12', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 9, '1.2', 1, 11, '2012-08-01 16:13:34', '2016-02-04 14:59:53', 'S.PENIN');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 90, '600', 1, 1, '2012-08-01 16:13:34', '2014-07-16 15:39:42', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 706, '1', 1, 3, '2012-08-01 16:13:34', '2016-04-04 09:31:27', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, -113, '15', 1, 12, '2012-08-01 16:13:34', '2015-03-20 08:21:59', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 184, '25', 1, 7, '2012-08-01 16:13:34', '2016-05-10 16:46:40', 'D.MAKSIMOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 185, '13', 1, 8, '2012-08-01 16:13:34', '2016-05-10 16:46:40', 'D.MAKSIMOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, -112, '5.5', 1, 13, '2012-08-01 16:13:34', '2015-03-20 08:21:59', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 1641, '2500', 1, 11, '2012-08-01 16:13:34', '2016-05-10 16:46:40', 'D.MAKSIMOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, -141, '37500', 1, 2, '2012-08-01 16:13:34', '2016-05-10 16:46:40', 'D.MAKSIMOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 277, 'Нет', 1, 17, '2012-08-01 16:13:34', '2016-04-14 16:24:44', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, -107, 'Да', 1, 18, '2012-08-01 16:13:34', '2016-04-14 16:25:12', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, -8, 'Да', 1, 19, '2012-08-01 16:13:34', '2016-04-14 16:20:32', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 1234, 'Да', 1, 20, '2012-08-01 16:13:34', '2016-04-14 15:50:48', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 9, '2.0', 1, 13, '2012-08-01 16:13:34', '2016-08-29 14:27:59', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 1323, '1', 0, 12, '2012-09-04 12:20:53', '2016-06-22 09:21:30', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 362, 'картонная коробка', 0, 10, '2012-09-04 12:37:20', '2016-06-22 09:21:30', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 362, 'картонная коробка', 1, 10, '2012-09-04 12:43:22', '2016-02-04 14:59:53', 'S.PENIN');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 158, 'быстрозажимной', 1, 3, '2014-06-26 16:45:54', '2016-06-22 09:21:30', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 1341, '10', 1, 4, '2014-06-26 16:46:01', '2016-06-22 09:21:30', 'A.HAZOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 158, 'быстрозажимной', 1, 3, '2014-06-26 16:46:19', '2016-02-04 14:59:53', 'S.PENIN');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 1341, '10', 1, 4, '2014-06-26 16:46:24', '2016-02-04 14:59:53', 'S.PENIN');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 158, 'быстрозажимной', 1, 4, '2014-06-26 16:47:59', '2015-03-30 13:49:22', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 1341, '13', 1, 5, '2014-06-26 16:48:07', '2014-12-24 09:22:35', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 144, '2.5', 1, 8, '2016-06-22 09:21:30', '2016-06-23 16:02:04', 'E.HOHLOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 1342, '1', 1, 5, '2016-06-22 09:21:30', '2016-06-23 16:01:30', 'E.HOHLOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 158, 'ключевой', 1, 3, '2014-12-24 09:11:19', '2016-04-12 11:34:21', 'N.VASENEVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 362, 'картонная коробка', 1, 10, '2014-12-24 09:11:19', '2016-04-12 11:34:21', 'N.VASENEVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 1323, '1', 1, 12, '2014-12-24 09:11:19', '2016-04-12 11:34:21', 'N.VASENEVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (124015, 1438, 'безударная', 1, 0, '2014-12-24 09:11:19', '2015-03-26 16:03:21', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (89963, 1438, 'безударная', 1, 0, '2014-12-24 09:11:35', '2015-03-30 13:06:11', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 362, 'картонная коробка', 1, 12, '2014-12-24 09:22:35', '2016-05-10 16:46:40', 'D.MAKSIMOV');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 1323, '.', 1, 14, '2014-12-24 09:22:35', '2016-12-22 12:23:28', 'I.OHOTNIKOVA1');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (21478, 1438, 'ударная', 1, 0, '2014-12-24 09:22:35', '2015-03-30 13:08:51', 'A.HAZOVA');
INSERT INTO SPAG_PARAM_VALUE (SPAG, PARAM, PVALUE, FC, SORTINDEX, TIMEP, LAST_UPD, LOGIN) VALUES (14001, 1438, 'безударная', 1, 0, '2013-07-03 14:06:17', '2015-03-30 13:05:58', 'A.HAZOVA');

COMMIT WORK;

ALTER TABLE GROUPS_SPAG_PARAM ADD CONSTRAINT PK_GROUPS_SPAG_PARAM PRIMARY KEY (ID_GR, SPAG_PARAM);
ALTER TABLE SPAG ADD CONSTRAINT PK_SPAG PRIMARY KEY (ID);
ALTER TABLE SPAG_PARAM ADD CONSTRAINT PK_SPAG_PARAM PRIMARY KEY (ID);
ALTER TABLE SPAG_PARAM_VALUE ADD CONSTRAINT PK_SPAG_PARAM_VALUE PRIMARY KEY (SPAG, PARAM);
ALTER TABLE SPAG_PARAM_VALUE ADD CONSTRAINT FK_SPAG_PARAM_VALUE_1 FOREIGN KEY (PARAM) REFERENCES SPAG_PARAM (ID);
ALTER TABLE SPAG_PARAM_VALUE ADD CONSTRAINT FK_SPAG_PARAM_VALUE_2 FOREIGN KEY (SPAG) REFERENCES SPAG (ID) ON DELETE CASCADE;

select http://s.id
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -582 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -582) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -582), 'XXXXXXXXXX') end as "fld-582"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -220 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -220) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -220), 'XXXXXXXXXX') end as "fld-220"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -174 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -174) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -174), 'XXXXXXXXXX') end as "fld-174"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -169 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -169) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -169), 'XXXXXXXXXX') end as "fld-169"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -152 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -152) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -152), 'XXXXXXXXXX') end as "fld-152"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -150 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -150) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -150), 'XXXXXXXXXX') end as "fld-150"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -141 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -141) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -141), 'XXXXXXXXXX') end as "fld-141"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -136 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -136) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -136), 'XXXXXXXXXX') end as "fld-136"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -135 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -135) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -135), 'XXXXXXXXXX') end as "fld-135"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -125 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -125) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -125), 'XXXXXXXXXX') end as "fld-125"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -124 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -124) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -124), 'XXXXXXXXXX') end as "fld-124"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -113 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -113) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -113), 'XXXXXXXXXX') end as "fld-113"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -112 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -112) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -112), 'XXXXXXXXXX') end as "fld-112"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -107 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -107) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -107), 'XXXXXXXXXX') end as "fld-107"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -66 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -66) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -66), 'XXXXXXXXXX') end as "fld-66"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -41 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -41) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -41), 'XXXXXXXXXX') end as "fld-41"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -13 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -13) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -13), 'XXXXXXXXXX') end as "fld-13"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -12 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -12) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -12), 'XXXXXXXXXX') end as "fld-12"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -9 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -9) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -9), 'XXXXXXXXXX') end as "fld-9"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = -8 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -8) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = -8), 'XXXXXXXXXX') end as "fld-8"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 9 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 9) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 9), 'XXXXXXXXXX') end as "fld9"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 19 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 19) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 19), 'XXXXXXXXXX') end as "fld19"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 32 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 32) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 32), 'XXXXXXXXXX') end as "fld32"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 69 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 69) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 69), 'XXXXXXXXXX') end as "fld69"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 90 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 90) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 90), 'XXXXXXXXXX') end as "fld90"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 144 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 144) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 144), 'XXXXXXXXXX') end as "fld144"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 158 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 158) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 158), 'XXXXXXXXXX') end as "fld158"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 178 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 178) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 178), 'XXXXXXXXXX') end as "fld178"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 179 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 179) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 179), 'XXXXXXXXXX') end as "fld179"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 180 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 180) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 180), 'XXXXXXXXXX') end as "fld180"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 184 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 184) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 184), 'XXXXXXXXXX') end as "fld184"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 185 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 185) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 185), 'XXXXXXXXXX') end as "fld185"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 196 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 196) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 196), 'XXXXXXXXXX') end as "fld196"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 202 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 202) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 202), 'XXXXXXXXXX') end as "fld202"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 277 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 277) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 277), 'XXXXXXXXXX') end as "fld277"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 316 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 316) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 316), 'XXXXXXXXXX') end as "fld316"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 362 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 362) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 362), 'XXXXXXXXXX') end as "fld362"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 519 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 519) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 519), 'XXXXXXXXXX') end as "fld519"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 706 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 706) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 706), 'XXXXXXXXXX') end as "fld706"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1090 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1090) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1090), 'XXXXXXXXXX') end as "fld1090"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1151 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1151) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1151), 'XXXXXXXXXX') end as "fld1151"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1234 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1234) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1234), 'XXXXXXXXXX') end as "fld1234"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1237 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1237) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1237), 'XXXXXXXXXX') end as "fld1237"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1249 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1249) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1249), 'XXXXXXXXXX') end as "fld1249"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1307 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1307) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1307), 'XXXXXXXXXX') end as "fld1307"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1323 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1323) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1323), 'XXXXXXXXXX') end as "fld1323"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1341 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1341) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1341), 'XXXXXXXXXX') end as "fld1341"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1342 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1342) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1342), 'XXXXXXXXXX') end as "fld1342"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1438 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1438) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1438), 'XXXXXXXXXX') end as "fld1438"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1466 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1466) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1466), 'XXXXXXXXXX') end as "fld1466"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1467 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1467) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1467), 'XXXXXXXXXX') end as "fld1467"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1559 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1559) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1559), 'XXXXXXXXXX') end as "fld1559"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1623 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1623) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1623), 'XXXXXXXXXX') end as "fld1623"
,case when exists (select 1 from groups_spag_param gsp where gsp.spag_param = 1641 and gsp.id_gr = s.subgr) then (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1641) else coalesce( (select pvalue from spag_param_value spv where spv.spag = http://s.id and spv.param = 1641), 'XXXXXXXXXX') end as "fld1641"

from SPAG S