Гаджимурадов РустамНедописал:
NickDee> Вот у меня есть устройство состоящее из 500 видов деталей.
Подробнее расскажи, что за устройство и что за 500 линейных деталей.
Давай лучше на реально существующем примере расскажу, который работает у клиента...
Есть дверь, которая в общем случае состоит из: Основная створка, дополнительная створка, фрамуга слева, фрамуга справа, фрамуга сверху. На каждой из этих сущностей (панелей), с каждой стороны (внутренней и наружней) может быть:
- МДФ (материал, рисунок фрезеровки, тип фрезеровки, цвет )
- ЛДСП (материал)
- Филёнка (рисунок)
- Накладка (рисунок, цвет рисунка)
- Перфорация (рисунок, цвет)
- Ковка (рисунок, цвет)
В скобках ссылки на справочники. Т.е. у нас имеется 12 ссылок на справочники. И это только для одной стороны панели. Панелей максимум 5 (две створки, три фрамуги) + 2 сторны, итого: 120 ссылок на справочники (12 * 5 * 2).
Эти 120 ссылок НЕ лежат полями в таблице дверей. Они лежат в табличке "СторроныПанели"(там 12 FK).
Потом есть табличка "Панели" с полями: "Выстота", "Ширина", "ВнешняяСторона ->", "ВнутренняяСторона ->" (ссылаются на табличку "СторроныПанели").
В табличке "Двери" есть два 5 полей: "ОсновнаяСтворка ->", "ДополнительнаяСтворка ->", "ЛеваяФрамуга ->", "ПраваяФрамуга ->", "ВерхняяФрамуга ->" (ссылаются на табличку "Панели")
При сохранении заявки мы имеем одну запись в табличке "Двери", две записи в табличке "Панели", 10 записей в табличке "СторроныПанели".
Если вытаскивать дверь одним селектом, например для редактирования или печати, то получается 120 джойнов.
И это без учёта всех остальных характеристик двери (там ещё около 200 полей).
Вот тут ( 15256277 ) я говорил про 175 джойнов и размер запроса в 45 килобайт.
Вот этот запрос, для печати документа (вдохните поглубже :) ):
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.
694.
695.
696.
697.
698.
699.
700.
701.
702.
703.
704.
705.
706.
707.
708.
709.
710.
711.
712.
713.
714.
715.
716.
717.
718.
719.
720.
721.
722.
723.
724.
725.
726.
727.
728.
729.
730.
731.
732.
733.
734.
735.
736.
select "ZAYAVKINADVERI"."ID" as "Id",
"ZAYAVKINADVERI"."NOMERZAKAZA" as "NomerZakaza",
"ZAYAVKINADVERI"."DATAIZGOTOVL" as "DataIzgotovl",
"ZAYAVKINADVERI"."DATAMONTAJA" as "DataMontaja",
"ZAYAVKINADVERI"."ZAKAZCHIK" as "Zakazchik",
"ZAYAVKINADVERI"."ADRES" as "Adres",
"ZAYAVKINADVERI"."FIO" as "FIO",
"ZAYAVKINADVERI"."TELEFON" as "Telefon",
"ZAYAVKINADVERI"."MODELDVERIID" as "ModelDverilId",
"ModeliDverei_1"."NAME" as "FF_1",
"ZAYAVKINADVERI"."STOIMOSTDVERI" as "StoimostDveri",
"ZAYAVKINADVERI"."STOIMOSTOSNSTVORKI" as "StoimostOsnStvorki",
"ZAYAVKINADVERI"."SHIRINAKOROBKI" as "ShirinaKorobki",
"ZAYAVKINADVERI"."SHIRINAKOROBKIPRICE" as "ShirinaKorobkiPrice",
"ZAYAVKINADVERI"."VISOTAKOROBKI" as "VisotaKorobki",
"ZAYAVKINADVERI"."PLOSHADKOROBKI" as "PloshadKorobki",
"ZAYAVKINADVERI"."VISOTAPOROGA" as "VisotaPoroga",
"Naveski_2"."NAME" as "FF_2",
"ZAYAVKINADVERI"."TUPIKSLEVA" as "TupikSleva",
"ZAYAVKINADVERI"."TUPIKSPRAVA" as "TupikSprava",
"ZAYAVKINADVERI"."TUPIKSVERHU" as "TupikSverhu",
"ZAYAVKINADVERI"."TUPIKSNIZU" as "TupikSnizu",
"Zamki_3"."NAME" as "FF_3",
"ZAYAVKINADVERI"."OSNZAMOKCOUNT" as "OsnZamokCount",
"ZAYAVKINADVERI"."OSNZAMOKPRICE" as "OsnZamokPrice",
"ZAYAVKINADVERI"."OSNZAMOKAMOUNT" as "OsnZamokAmount",
"Cilindri_4"."NAME" as "FF_4",
"ZAYAVKINADVERI"."OSNCILINDRCOUNT" as "OsnCilindrCount",
"ZAYAVKINADVERI"."OSNCILINDRPRICE" as "OsnCilindrPrice",
"ZAYAVKINADVERI"."OSNCILINDRAMOUNT" as "OsnCilindrAmount",
"ZAYAVKINADVERI"."OSNCILINDRRAZMER" as "OsnCilindrRazmer",
"Kluchevini_5"."NAME" as "FF_5",
"ZAYAVKINADVERI"."OSNKLUCHEVINACOUNT" as "OsnKluchevinaCount",
"ZAYAVKINADVERI"."OSNKLUCHEVINAPRICE" as "OsnKluchevinaPrice",
"ZAYAVKINADVERI"."OSNKLUCHEVINAAMOUNT" as "OsnKluchevinaAmount",
"ZAYAVKINADVERI"."ISOSNKLUCHEVINAUTOPLENNAYA" as "IsOsnKluchevinaUtoplennaya",
"ZAYAVKINADVERI"."OSNKLUCHEVINAUTOPLENNAYACOUNT" as "OsnKluchevinaUtoplennayaCount",
"ZAYAVKINADVERI"."OSNKLUCHEVINAUTOPLENNAYAPRICE" as "OsnKluchevinaUtoplennayaPrice",
"ZAYAVKINADVERI"."OSNKLUCHEVINAUTOPLENNAYAAMOUNT" as "OsnKluchevinaUtoplennayaAmount",
"Zamki_6"."NAME" as "FF_6",
"ZAYAVKINADVERI"."DOPZAMOKCOUNT" as "DopZamokCount",
"ZAYAVKINADVERI"."DOPZAMOKPRICE" as "DopZamokPrice",
"ZAYAVKINADVERI"."DOPZAMOKAMOUNT" as "DopZamokAmount",
"Cilindri_7"."NAME" as "FF_7",
"ZAYAVKINADVERI"."DOPCILINDRCOUNT" as "DopCilindrCount",
"ZAYAVKINADVERI"."DOPCILINDRPRICE" as "DopCilindrPrice",
"ZAYAVKINADVERI"."DOPCILINDRAMOUNT" as "DopCilindrAmount",
"ZAYAVKINADVERI"."DOPCILINDRRAZMER" as "DopCilindrRazmer",
"Kluchevini_8"."NAME" as "FF_8",
"ZAYAVKINADVERI"."DOPKLUCHEVINACOUNT" as "DopKluchevinaCount",
"ZAYAVKINADVERI"."DOPKLUCHEVINAPRICE" as "DopKluchevinaPrice",
"ZAYAVKINADVERI"."DOPKLUCHEVINAAMOUNT" as "DopKluchevinaAmount",
"ZAYAVKINADVERI"."ISDOPKLUCHEVINAUTOPLENNAYA" as "IsDopKluchevinaUtoplennaya",
"ZAYAVKINADVERI"."DOPKLUCHEVINAUTOPLENNAYACOUNT" as "DopKluchevinaUtoplennayaCount",
"ZAYAVKINADVERI"."DOPKLUCHEVINAUTOPLENNAYAPRICE" as "DopKluchevinaUtoplennayaPrice",
"ZAYAVKINADVERI"."DOPKLUCHEVINAUTOPLENNAYAAMOUNT" as "DopKluchevinaUtoplennayaAmount",
"Ruchki_9"."NAME" as "FF_9",
"ZAYAVKINADVERI"."RUCHKACOUNT" as "RuchkaCount",
"ZAYAVKINADVERI"."RUCHKAPRICE" as "RuchkaPrice",
"ZAYAVKINADVERI"."RUCHKAAMOUNT" as "RuchkaAmount",
"ZAYAVKINADVERI"."ISTYAGI" as "IsTyagi",
"Zadvijki_10"."NAME" as "FF_10",
"ZAYAVKINADVERI"."ZADVIJKACOUNT" as "ZadvijkaCount",
"ZAYAVKINADVERI"."ZADVIJKAPRICE" as "ZadvijkaPrice",
"ZAYAVKINADVERI"."ZADVIJKAAMOUNT" as "ZadvijkaAmount",
"Glazki_11"."NAME" as "FF_11",
"ZAYAVKINADVERI"."GLAZOKCOUNT" as "GlazokCount",
"ZAYAVKINADVERI"."GLAZOKPRICE" as "GlazokPrice",
"ZAYAVKINADVERI"."GLAZOKAMOUNT" as "GlazokAmount",
"ZAYAVKINADVERI"."ISSKRITIESHARNIRI" as "IsSkritieSharniri",
"ZAYAVKINADVERI"."SKRITIESHARNIRIAMOUNT" as "SkritieSharniriAmount",
"ZAYAVKINADVERI"."ISDOPSTVORKA" as "IsDopStvorka",
"ZAYAVKINADVERI"."DOPSTVORKAAMOUNT" as "DopStvorkaAmount",
"ZAYAVKINADVERI"."ISVNUTROTKRIVANIE" as "IsVnutrOtkrivanie",
"ZAYAVKINADVERI"."VNUTROTKRIVANIEAMOUNT" as "VnutrOtkrivanieAmount",
"TorcevieShpingaleti_12"."NAME" as "FF_12",
"ZAYAVKINADVERI"."TORCEVIESHPINGALETIAMOUNT" as "TorcevieShpingaletiAmount",
"Dovodchiki_13"."NAME" as "FF_13",
"ZAYAVKINADVERI"."DOVODCHIKAMOUNT" as "DovodchikAmount",
"TipiUstanovkiDovodchika_14"."NAME" as "FF_14",
"ZAYAVKINADVERI"."TIPUSTANOVKIDOVODCHIKAAMOUNT" as "TipUstanovkiDovodchikaAmount",
"ZAYAVKINADVERI"."ITOGOZAFURNITURUIPROCHEEAMOUNT" as "ItogoZaFurnituruIProcheeAmount",
"ZAYAVKINADVERI"."ISMONTAJ" as "IsMontaj",
"ZAYAVKINADVERI"."MONTAJAMOUNT" as "MontajAmount",
"TipiDemontaja_15"."NAME" as "FF_15",
"ZAYAVKINADVERI"."TIPDEMONTAJAAMOUNT" as "TipDemontajaAmount",
"ZAYAVKINADVERI"."VSEGOZARABOTIAMOUNT" as "VsegoZaRabotiAmount",
"ZAYAVKINADVERI"."VSEGOAMOUNT" as "VsegoAmount",
"ZAYAVKINADVERI"."SKIDKANAIZDELIE" as "SkidkaNaIzdelie",
"ZAYAVKINADVERI"."ITOGOAMOUNT" as "ItogoAmount",
"ZAYAVKINADVERI"."ITOGOTEXT" as "ItogoText",
"ZAYAVKINADVERI"."PREDOPLATAAMOUNT" as "PredoplataAmount",
"ZAYAVKINADVERI"."KREPEJ" as "Krepej",
"ZAYAVKINADVERI"."DOPOLNITELNO" as "Dopolnitelno",
"ZAYAVKINADVERI"."SMI" as "SMI",
"ZAYAVKINADVERI"."SOZDATELID" as "SozdatelId",
"ZAYAVKINADVERI"."DATASOZDANIYA" as "DataSozdaniya",
"Broni_16"."NAME" as "FF_16",
"ZAYAVKINADVERI"."OSNBRONCOUNT" as "OsnBronCount",
"ZAYAVKINADVERI"."OSNBRONPRICE" as "OsnBronPrice",
"ZAYAVKINADVERI"."OSNBRONAMOUNT" as "OsnBronAmount",
"ZAYAVKINADVERI"."ISOSNBRONUTOPLENNAYA" as "IsOsnBronUtoplennaya",
"ZAYAVKINADVERI"."OSNBRONUTOPLENNAYACOUNT" as "OsnBronUtoplennayaCount",
"ZAYAVKINADVERI"."OSNBRONUTOPLENNAYAPRICE" as "OsnBronUtoplennayaPrice",
"ZAYAVKINADVERI"."OSNBRONUTOPLENNAYAAMOUNT" as "OsnBronUtoplennayaAmount",
"Broni_17"."NAME" as "FF_17",
"ZAYAVKINADVERI"."DOPBRONCOUNT" as "DopBronCount",
"ZAYAVKINADVERI"."DOPBRONPRICE" as "DopBronPrice",
"ZAYAVKINADVERI"."DOPBRONAMOUNT" as "DopBronAmount",
"ZAYAVKINADVERI"."ISDOPBRONUTOPLENNAYA" as "IsDopBronUtoplennaya",
"ZAYAVKINADVERI"."DOPBRONUTOPLENNAYACOUNT" as "DopBronUtoplennayaCount",
"ZAYAVKINADVERI"."DOPBRONUTOPLENNAYAPRICE" as "DopBronUtoplennayaPrice",
"ZAYAVKINADVERI"."DOPBRONUTOPLENNAYAAMOUNT" as "DopBronUtoplennayaAmount",
"ZAYAVKINADVERI"."ISPROSTOYPRITVOR" as "IsProstoyPritvor",
"ZAYAVKINADVERI"."PRICEID" as "PriceId",
"ZAYAVKINADVERI"."PROCHEEAMOUNT" as "ProcheeAmount",
"ZAYAVKINADVERI"."POSLEDNIYIZMENILID" as "PosledniyIzmenilId",
"ZAYAVKINADVERI"."DATAIZMENENIYA" as "DataIzmeneniya",
"Cveta_18"."NAME" as "FF_18",
"ZAYAVKINADVERI"."ISPOLOTNODOPPODGOTOVKA" as "IsPolotnoDopPodgotovka",
"ZAYAVKINADVERI"."ISPOLOTNOPOKRITIELAKOM" as "IsPolotnoPokritieLakom",
"ZAYAVKINADVERI"."ISPOLOTNOSHAGREN" as "IsPolotnoShagren",
"ZAYAVKINADVERI"."POLOTNODOPPODGOTOVKAAMOUNT" as "PolotnoDopPodgotovkaAmount",
"ZAYAVKINADVERI"."POLOTNOPOKRITIELAKOMAMOUNT" as "PolotnoPokritieLakomAmount",
"ZAYAVKINADVERI"."POLOTNOPOKRITIEAMOUNT" as "PolotnoPokritieAmount",
"Cveta_19"."NAME" as "FF_19",
"ZAYAVKINADVERI"."ISKOROBDOPPODGOTOVKA" as "IsKorobDopPodgotovka",
"ZAYAVKINADVERI"."ISKOROBPOKRITIELAKOM" as "IsKorobPokritieLakom",
"ZAYAVKINADVERI"."ISKOROBSHAGREN" as "IsKorobShagren",
"ZAYAVKINADVERI"."KOROBDOPPODGOTOVKAAMOUNT" as "KorobDopPodgotovkaAmount",
"ZAYAVKINADVERI"."KOROBPOKRITIELAKOMAMOUNT" as "KorobPokritieLakomAmount",
"ZAYAVKINADVERI"."KOROBPOKRITIEAMOUNT" as "KorobPokritieAmount",
"ZAYAVKINADVERI"."ISCVETKOROBAVCVETPOLOTNA" as "IsCvetKorobaVCvetPolotna",
"ZAYAVKINADVERI"."POKRITIEAMOUNT" as "PokritieAmount",
"Otdelka_22"."NAME" as "FF_20",
"Otdelka_22"."IDENT" as "FF_21",
"Otdelka_22"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_22",
"Cveta_23"."NAME" as "FF_23",
"PanelSides_21"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_24",
"MaterialMdfPanelei_24"."NAME" as "FF_25",
"MaterialMdfPanelei_24"."PICTURE" as "FF_26",
"RisunkiFrezerovkiMdf_25"."NAME" as "FF_27",
"RisunkiFrezerovkiMdf_25"."PICTURE" as "FF_28",
"MaterialLdspPanelei_26"."NAME" as "FF_29",
"MaterialLdspPanelei_26"."PICTURE" as "FF_30",
"RisunkiFilenki_27"."NAME" as "FF_31",
"RisunkiFilenki_27"."PICTURE" as "FF_32",
"RisunkiFilenki_27"."IDENT" as "FF_33",
"PanelSides_21"."FILENKAESKIZZAKAZCHIKA" as "FF_34",
"PanelSides_21"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_35",
"RusunkiNakladok_28"."NAME" as "FF_36",
"RusunkiNakladok_28"."PICTURE" as "FF_37",
"Cveta_29"."NAME" as "FF_38",
"RisunkiPerforacii_30"."NAME" as "FF_39",
"RisunkiPerforacii_30"."PICTURE" as "FF_40",
"Cveta_31"."NAME" as "FF_41",
"RisunkiKovki_32"."NAME" as "FF_42",
"RisunkiKovki_32"."PICTURE" as "FF_43",
"RisunkiKovki_32"."IDENT" as "FF_44",
"PanelSides_21"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_45",
"PanelSides_21"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_46",
"Cveta_33"."NAME" as "FF_47",
"PanelSides_21"."OTDELKAAMOUNT" as "FF_48",
"Otdelka_35"."NAME" as "FF_49",
"Otdelka_35"."IDENT" as "FF_50",
"Otdelka_35"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_51",
"Cveta_36"."NAME" as "FF_52",
"PanelSides_34"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_53",
"MaterialMdfPanelei_37"."NAME" as "FF_54",
"MaterialMdfPanelei_37"."PICTURE" as "FF_55",
"RisunkiFrezerovkiMdf_38"."NAME" as "FF_56",
"RisunkiFrezerovkiMdf_38"."PICTURE" as "FF_57",
"MaterialLdspPanelei_39"."NAME" as "FF_58",
"MaterialLdspPanelei_39"."PICTURE" as "FF_59",
"RisunkiFilenki_40"."NAME" as "FF_60",
"RisunkiFilenki_40"."PICTURE" as "FF_61",
"RisunkiFilenki_40"."IDENT" as "FF_62",
"PanelSides_34"."FILENKAESKIZZAKAZCHIKA" as "FF_63",
"PanelSides_34"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_64",
"RusunkiNakladok_41"."NAME" as "FF_65",
"RusunkiNakladok_41"."PICTURE" as "FF_66",
"Cveta_42"."NAME" as "FF_67",
"RisunkiPerforacii_43"."NAME" as "FF_68",
"RisunkiPerforacii_43"."PICTURE" as "FF_69",
"Cveta_44"."NAME" as "FF_70",
"RisunkiKovki_45"."NAME" as "FF_71",
"RisunkiKovki_45"."PICTURE" as "FF_72",
"RisunkiKovki_45"."IDENT" as "FF_73",
"PanelSides_34"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_74",
"PanelSides_34"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_75",
"Cveta_46"."NAME" as "FF_76",
"Cveta_46"."PRICEZADRUGOICVET" as "FF_77",
"Cveta_44"."PRICEZADRUGOICVET" as "FF_78",
"Cveta_42"."PRICEZADRUGOICVET" as "FF_79",
"Cveta_36"."PRICEZADRUGOICVET" as "FF_80",
"PanelSides_34"."OTDELKAAMOUNT" as "FF_81",
"Panels_20"."SHIRINA" as "FF_82",
"Panels_20"."VISOTA" as "FF_83",
"Panels_20"."PLOSHAD" as "FF_84",
"Panels_20"."STOIMOST" as "FF_85",
"Steklopaketi_47"."NAME" as "FF_86",
"Panels_20"."SHIRINASTEKLOPAKETA" as "FF_87",
"Panels_20"."VISOTASTEKLOPAKETA" as "FF_88",
"Panels_20"."STEKLOPAKETAMOUNT" as "FF_89",
"Otdelka_50"."NAME" as "FF_90",
"Otdelka_50"."IDENT" as "FF_91",
"Otdelka_50"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_92",
"Cveta_51"."NAME" as "FF_93",
"PanelSides_49"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_94",
"MaterialMdfPanelei_52"."NAME" as "FF_95",
"MaterialMdfPanelei_52"."PICTURE" as "FF_96",
"RisunkiFrezerovkiMdf_53"."NAME" as "FF_97",
"RisunkiFrezerovkiMdf_53"."PICTURE" as "FF_98",
"MaterialLdspPanelei_54"."NAME" as "FF_99",
"MaterialLdspPanelei_54"."PICTURE" as "FF_100",
"RisunkiFilenki_55"."NAME" as "FF_101",
"RisunkiFilenki_55"."PICTURE" as "FF_102",
"RisunkiFilenki_55"."IDENT" as "FF_103",
"PanelSides_49"."FILENKAESKIZZAKAZCHIKA" as "FF_104",
"PanelSides_49"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_105",
"RusunkiNakladok_56"."NAME" as "FF_106",
"RusunkiNakladok_56"."PICTURE" as "FF_107",
"Cveta_57"."NAME" as "FF_108",
"RisunkiPerforacii_58"."NAME" as "FF_109",
"RisunkiPerforacii_58"."PICTURE" as "FF_110",
"Cveta_59"."NAME" as "FF_111",
"RisunkiKovki_60"."NAME" as "FF_112",
"RisunkiKovki_60"."PICTURE" as "FF_113",
"RisunkiKovki_60"."IDENT" as "FF_114",
"PanelSides_49"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_115",
"PanelSides_49"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_116",
"Cveta_61"."NAME" as "FF_117",
"PanelSides_49"."OTDELKAAMOUNT" as "FF_118",
"Otdelka_63"."NAME" as "FF_119",
"Otdelka_63"."IDENT" as "FF_120",
"Otdelka_63"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_121",
"Cveta_64"."NAME" as "FF_122",
"PanelSides_62"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_123",
"MaterialMdfPanelei_65"."NAME" as "FF_124",
"MaterialMdfPanelei_65"."PICTURE" as "FF_125",
"RisunkiFrezerovkiMdf_66"."NAME" as "FF_126",
"RisunkiFrezerovkiMdf_66"."PICTURE" as "FF_127",
"MaterialLdspPanelei_67"."NAME" as "FF_128",
"MaterialLdspPanelei_67"."PICTURE" as "FF_129",
"RisunkiFilenki_68"."NAME" as "FF_130",
"RisunkiFilenki_68"."PICTURE" as "FF_131",
"RisunkiFilenki_68"."IDENT" as "FF_132",
"PanelSides_62"."FILENKAESKIZZAKAZCHIKA" as "FF_133",
"PanelSides_62"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_134",
"RusunkiNakladok_69"."NAME" as "FF_135",
"RusunkiNakladok_69"."PICTURE" as "FF_136",
"Cveta_70"."NAME" as "FF_137",
"RisunkiPerforacii_71"."NAME" as "FF_138",
"RisunkiPerforacii_71"."PICTURE" as "FF_139",
"Cveta_72"."NAME" as "FF_140",
"RisunkiKovki_73"."NAME" as "FF_141",
"RisunkiKovki_73"."PICTURE" as "FF_142",
"RisunkiKovki_73"."IDENT" as "FF_143",
"PanelSides_62"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_144",
"PanelSides_62"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_145",
"Cveta_74"."NAME" as "FF_146",
"Cveta_74"."PRICEZADRUGOICVET" as "FF_147",
"PanelSides_62"."OTDELKAAMOUNT" as "FF_148",
"Panels_48"."SHIRINA" as "FF_149",
"Panels_48"."VISOTA" as "FF_150",
"Panels_48"."PLOSHAD" as "FF_151",
"Panels_48"."STOIMOST" as "FF_152",
"Steklopaketi_75"."NAME" as "FF_153",
"Panels_48"."SHIRINASTEKLOPAKETA" as "FF_154",
"Panels_48"."VISOTASTEKLOPAKETA" as "FF_155",
"Panels_48"."STEKLOPAKETAMOUNT" as "FF_156",
"Otdelka_78"."NAME" as "FF_157",
"Otdelka_78"."IDENT" as "FF_158",
"Otdelka_78"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_159",
"Cveta_79"."NAME" as "FF_160",
"PanelSides_77"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_161",
"MaterialMdfPanelei_80"."NAME" as "FF_162",
"MaterialMdfPanelei_80"."PICTURE" as "FF_163",
"RisunkiFrezerovkiMdf_81"."NAME" as "FF_164",
"RisunkiFrezerovkiMdf_81"."PICTURE" as "FF_165",
"MaterialLdspPanelei_82"."NAME" as "FF_166",
"MaterialLdspPanelei_82"."PICTURE" as "FF_167",
"RisunkiFilenki_83"."NAME" as "FF_168",
"RisunkiFilenki_83"."PICTURE" as "FF_169",
"RisunkiFilenki_83"."IDENT" as "FF_170",
"PanelSides_77"."FILENKAESKIZZAKAZCHIKA" as "FF_171",
"PanelSides_77"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_172",
"RusunkiNakladok_84"."NAME" as "FF_173",
"RusunkiNakladok_84"."PICTURE" as "FF_174",
"Cveta_85"."NAME" as "FF_175",
"RisunkiPerforacii_86"."NAME" as "FF_176",
"RisunkiPerforacii_86"."PICTURE" as "FF_177",
"Cveta_87"."NAME" as "FF_178",
"RisunkiKovki_88"."NAME" as "FF_179",
"RisunkiKovki_88"."PICTURE" as "FF_180",
"RisunkiKovki_88"."IDENT" as "FF_181",
"PanelSides_77"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_182",
"PanelSides_77"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_183",
"Cveta_89"."NAME" as "FF_184",
"PanelSides_77"."OTDELKAAMOUNT" as "FF_185",
"Otdelka_91"."NAME" as "FF_186",
"Otdelka_91"."IDENT" as "FF_187",
"Otdelka_91"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_188",
"Cveta_92"."NAME" as "FF_189",
"PanelSides_90"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_190",
"MaterialMdfPanelei_93"."NAME" as "FF_191",
"MaterialMdfPanelei_93"."PICTURE" as "FF_192",
"RisunkiFrezerovkiMdf_94"."NAME" as "FF_193",
"RisunkiFrezerovkiMdf_94"."PICTURE" as "FF_194",
"MaterialLdspPanelei_95"."NAME" as "FF_195",
"MaterialLdspPanelei_95"."PICTURE" as "FF_196",
"RisunkiFilenki_96"."NAME" as "FF_197",
"RisunkiFilenki_96"."PICTURE" as "FF_198",
"RisunkiFilenki_96"."IDENT" as "FF_199",
"PanelSides_90"."FILENKAESKIZZAKAZCHIKA" as "FF_200",
"PanelSides_90"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_201",
"RusunkiNakladok_97"."NAME" as "FF_202",
"RusunkiNakladok_97"."PICTURE" as "FF_203",
"Cveta_98"."NAME" as "FF_204",
"RisunkiPerforacii_99"."NAME" as "FF_205",
"RisunkiPerforacii_99"."PICTURE" as "FF_206",
"Cveta_100"."NAME" as "FF_207",
"RisunkiKovki_101"."NAME" as "FF_208",
"RisunkiKovki_101"."PICTURE" as "FF_209",
"RisunkiKovki_101"."IDENT" as "FF_210",
"PanelSides_90"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_211",
"PanelSides_90"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_212",
"Cveta_102"."NAME" as "FF_213",
"Cveta_102"."PRICEZADRUGOICVET" as "FF_214",
"Cveta_100"."PRICEZADRUGOICVET" as "FF_215",
"Cveta_98"."PRICEZADRUGOICVET" as "FF_216",
"Cveta_92"."PRICEZADRUGOICVET" as "FF_217",
"PanelSides_90"."OTDELKAAMOUNT" as "FF_218",
"Panels_76"."SHIRINA" as "FF_219",
"Panels_76"."VISOTA" as "FF_220",
"Panels_76"."PLOSHAD" as "FF_221",
"Panels_76"."STOIMOST" as "FF_222",
"Steklopaketi_103"."NAME" as "FF_223",
"Panels_76"."SHIRINASTEKLOPAKETA" as "FF_224",
"Panels_76"."VISOTASTEKLOPAKETA" as "FF_225",
"Panels_76"."STEKLOPAKETAMOUNT" as "FF_226",
"Otdelka_106"."NAME" as "FF_227",
"Otdelka_106"."IDENT" as "FF_228",
"Otdelka_106"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_229",
"Cveta_107"."NAME" as "FF_230",
"PanelSides_105"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_231",
"MaterialMdfPanelei_108"."NAME" as "FF_232",
"MaterialMdfPanelei_108"."PICTURE" as "FF_233",
"RisunkiFrezerovkiMdf_109"."NAME" as "FF_234",
"RisunkiFrezerovkiMdf_109"."PICTURE" as "FF_235",
"MaterialLdspPanelei_110"."NAME" as "FF_236",
"MaterialLdspPanelei_110"."PICTURE" as "FF_237",
"RisunkiFilenki_111"."NAME" as "FF_238",
"RisunkiFilenki_111"."PICTURE" as "FF_239",
"RisunkiFilenki_111"."IDENT" as "FF_240",
"PanelSides_105"."FILENKAESKIZZAKAZCHIKA" as "FF_241",
"PanelSides_105"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_242",
"RusunkiNakladok_112"."NAME" as "FF_243",
"RusunkiNakladok_112"."PICTURE" as "FF_244",
"Cveta_113"."NAME" as "FF_245",
"RisunkiPerforacii_114"."NAME" as "FF_246",
"RisunkiPerforacii_114"."PICTURE" as "FF_247",
"Cveta_115"."NAME" as "FF_248",
"RisunkiKovki_116"."NAME" as "FF_249",
"RisunkiKovki_116"."PICTURE" as "FF_250",
"RisunkiKovki_116"."IDENT" as "FF_251",
"PanelSides_105"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_252",
"PanelSides_105"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_253",
"Cveta_117"."NAME" as "FF_254",
"PanelSides_105"."OTDELKAAMOUNT" as "FF_255",
"Otdelka_119"."NAME" as "FF_256",
"Otdelka_119"."IDENT" as "FF_257",
"Otdelka_119"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_258",
"Cveta_120"."NAME" as "FF_259",
"PanelSides_118"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_260",
"MaterialMdfPanelei_121"."NAME" as "FF_261",
"MaterialMdfPanelei_121"."PICTURE" as "FF_262",
"RisunkiFrezerovkiMdf_122"."NAME" as "FF_263",
"RisunkiFrezerovkiMdf_122"."PICTURE" as "FF_264",
"MaterialLdspPanelei_123"."NAME" as "FF_265",
"MaterialLdspPanelei_123"."PICTURE" as "FF_266",
"RisunkiFilenki_124"."NAME" as "FF_267",
"RisunkiFilenki_124"."PICTURE" as "FF_268",
"RisunkiFilenki_124"."IDENT" as "FF_269",
"PanelSides_118"."FILENKAESKIZZAKAZCHIKA" as "FF_270",
"PanelSides_118"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_271",
"RusunkiNakladok_125"."NAME" as "FF_272",
"RusunkiNakladok_125"."PICTURE" as "FF_273",
"Cveta_126"."NAME" as "FF_274",
"RisunkiPerforacii_127"."NAME" as "FF_275",
"RisunkiPerforacii_127"."PICTURE" as "FF_276",
"Cveta_128"."NAME" as "FF_277",
"RisunkiKovki_129"."NAME" as "FF_278",
"RisunkiKovki_129"."PICTURE" as "FF_279",
"RisunkiKovki_129"."IDENT" as "FF_280",
"PanelSides_118"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_281",
"PanelSides_118"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_282",
"Cveta_130"."NAME" as "FF_283",
"Cveta_130"."PRICEZADRUGOICVET" as "FF_284",
"Cveta_128"."PRICEZADRUGOICVET" as "FF_285",
"Cveta_126"."PRICEZADRUGOICVET" as "FF_286",
"Cveta_120"."PRICEZADRUGOICVET" as "FF_287",
"PanelSides_118"."OTDELKAAMOUNT" as "FF_288",
"Panels_104"."SHIRINA" as "FF_289",
"Panels_104"."VISOTA" as "FF_290",
"Panels_104"."PLOSHAD" as "FF_291",
"Panels_104"."STOIMOST" as "FF_292",
"Steklopaketi_131"."NAME" as "FF_293",
"Panels_104"."SHIRINASTEKLOPAKETA" as "FF_294",
"Panels_104"."VISOTASTEKLOPAKETA" as "FF_295",
"Panels_104"."STEKLOPAKETAMOUNT" as "FF_296",
"Otdelka_134"."NAME" as "FF_297",
"Otdelka_134"."IDENT" as "FF_298",
"Otdelka_134"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_299",
"Cveta_135"."NAME" as "FF_300",
"PanelSides_133"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_301",
"MaterialMdfPanelei_136"."NAME" as "FF_302",
"MaterialMdfPanelei_136"."PICTURE" as "FF_303",
"RisunkiFrezerovkiMdf_137"."NAME" as "FF_304",
"RisunkiFrezerovkiMdf_137"."PICTURE" as "FF_305",
"MaterialLdspPanelei_138"."NAME" as "FF_306",
"MaterialLdspPanelei_138"."PICTURE" as "FF_307",
"RisunkiFilenki_139"."NAME" as "FF_308",
"RisunkiFilenki_139"."PICTURE" as "FF_309",
"RisunkiFilenki_139"."IDENT" as "FF_310",
"PanelSides_133"."FILENKAESKIZZAKAZCHIKA" as "FF_311",
"PanelSides_133"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_312",
"RusunkiNakladok_140"."NAME" as "FF_313",
"RusunkiNakladok_140"."PICTURE" as "FF_314",
"Cveta_141"."NAME" as "FF_315",
"RisunkiPerforacii_142"."NAME" as "FF_316",
"RisunkiPerforacii_142"."PICTURE" as "FF_317",
"Cveta_143"."NAME" as "FF_318",
"RisunkiKovki_144"."NAME" as "FF_319",
"RisunkiKovki_144"."PICTURE" as "FF_320",
"RisunkiKovki_144"."IDENT" as "FF_321",
"PanelSides_133"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_322",
"PanelSides_133"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_323",
"Cveta_145"."NAME" as "FF_324",
"PanelSides_133"."OTDELKAAMOUNT" as "FF_325",
"Otdelka_147"."NAME" as "FF_326",
"Otdelka_147"."IDENT" as "FF_327",
"Otdelka_147"."ISSOBSTVENNIYCVETPOVERHNOSTI" as "FF_328",
"Cveta_148"."NAME" as "FF_329",
"PanelSides_146"."DRUGOICVETPOVERHNOSTIAMOUNT" as "FF_330",
"MaterialMdfPanelei_149"."NAME" as "FF_331",
"MaterialMdfPanelei_149"."PICTURE" as "FF_332",
"RisunkiFrezerovkiMdf_150"."NAME" as "FF_333",
"RisunkiFrezerovkiMdf_150"."PICTURE" as "FF_334",
"MaterialLdspPanelei_151"."NAME" as "FF_335",
"MaterialLdspPanelei_151"."PICTURE" as "FF_336",
"RisunkiFilenki_152"."NAME" as "FF_337",
"RisunkiFilenki_152"."PICTURE" as "FF_338",
"RisunkiFilenki_152"."IDENT" as "FF_339",
"PanelSides_146"."FILENKAESKIZZAKAZCHIKA" as "FF_340",
"PanelSides_146"."FILENKAESKIZZAKAZCHIKAAMOUNT" as "FF_341",
"RusunkiNakladok_153"."NAME" as "FF_342",
"RusunkiNakladok_153"."PICTURE" as "FF_343",
"Cveta_154"."NAME" as "FF_344",
"RisunkiPerforacii_155"."NAME" as "FF_345",
"RisunkiPerforacii_155"."PICTURE" as "FF_346",
"Cveta_156"."NAME" as "FF_347",
"RisunkiKovki_157"."NAME" as "FF_348",
"RisunkiKovki_157"."PICTURE" as "FF_349",
"RisunkiKovki_157"."IDENT" as "FF_350",
"PanelSides_146"."KOVKAVARIANTZKAZCHIKAOPISANIE" as "FF_351",
"PanelSides_146"."KOVKAVARIANTZAKAZCHIKAAMOUNT" as "FF_352",
"Cveta_158"."NAME" as "FF_353",
"Cveta_158"."PRICEZADRUGOICVET" as "FF_354",
"Cveta_156"."PRICEZADRUGOICVET" as "FF_355",
"Cveta_154"."PRICEZADRUGOICVET" as "FF_356",
"Cveta_148"."PRICEZADRUGOICVET" as "FF_357",
"PanelSides_146"."OTDELKAAMOUNT" as "FF_358",
"Panels_132"."SHIRINA" as "FF_359",
"Panels_132"."VISOTA" as "FF_360",
"Panels_132"."PLOSHAD" as "FF_361",
"Panels_132"."STOIMOST" as "FF_362",
"Steklopaketi_159"."NAME" as "FF_363",
"Panels_132"."SHIRINASTEKLOPAKETA" as "FF_364",
"Panels_132"."VISOTASTEKLOPAKETA" as "FF_365",
"Panels_132"."STEKLOPAKETAMOUNT" as "FF_366",
"PanelSides_21"."OTDELKAID" as "FF_367",
"PanelSides_34"."OTDELKAID" as "FF_368",
"PanelSides_49"."OTDELKAID" as "FF_369",
"PanelSides_62"."OTDELKAID" as "FF_370",
"PanelSides_77"."OTDELKAID" as "FF_371",
"PanelSides_90"."OTDELKAID" as "FF_372",
"PanelSides_105"."OTDELKAID" as "FF_373",
"PanelSides_118"."OTDELKAID" as "FF_374",
"PanelSides_133"."OTDELKAID" as "FF_375",
"PanelSides_146"."OTDELKAID" as "FF_376",
"ZAYAVKINADVERI"."ISLEVAYAFRAMUGA" as "IsLevayaFramuga",
"ZAYAVKINADVERI"."ISPRAVAYAFRAMUGA" as "IsPravayaFramuga",
"ZAYAVKINADVERI"."ISVERHFRAMUGA" as "IsVerhFramuga",
"Panels_20"."PLOSHADSTEKLOPAKETA" as "FF_377",
"Panels_48"."PLOSHADSTEKLOPAKETA" as "FF_378",
"Panels_76"."PLOSHADSTEKLOPAKETA" as "FF_379",
"Panels_104"."PLOSHADSTEKLOPAKETA" as "FF_380",
"Panels_132"."PLOSHADSTEKLOPAKETA" as "FF_381",
"Users_160"."Fio" as "FF_382",
"ZAYAVKINADVERI"."GLUBINAKOROBKI" as "GlubinaKorobki",
"ProfiliStoek_161"."ISTUPIK" as "FF_383",
"ProfiliStoek_161"."PICTURE" as "FF_384",
"ProfiliStoek_162"."ISTUPIK" as "FF_385",
"ProfiliStoek_162"."PICTURE" as "FF_386",
"ProfiliStoek_163"."ISTUPIK" as "FF_387",
"ProfiliStoek_163"."PICTURE" as "FF_388",
"ProfiliStoek_164"."ISTUPIK" as "FF_389",
"ProfiliStoek_164"."PICTURE" as "FF_390",
"ZAYAVKINADVERI"."ISULICASVERHU" as "IsUlicaSverhu",
"RisunkiDverei_165"."PICTURE" as "FF_391",
"ZAYAVKINADVERI"."ISVERHFRAMUGAAROCHNAYA" as "IsVerhFramugaArochnaya",
"ZAYAVKINADVERI"."KOLICHESTVOSHARNIROV" as "KolichestvoSharnirov",
"ZAYAVKINADVERI"."SHARNIRIAMOUNT" as "SharniriAmount",
"BroniSteklopaketa_166"."NAME" as "FF_392",
"BroniSteklopaketa_167"."NAME" as "FF_393",
"BroniSteklopaketa_168"."NAME" as "FF_394",
"BroniSteklopaketa_169"."NAME" as "FF_395",
"BroniSteklopaketa_170"."NAME" as "FF_396",
"DveriVRabote_171"."PROIZVNOMER" as "FF_397",
"Gerkoni_172"."NAME" as "FF_398",
"ZAYAVKINADVERI"."GERKONIAMOUNT" as "GerkoniAmount",
"Upakovka_173"."NAME" as "FF_399",
"ZAYAVKINADVERI"."UPAKOVKAAMOUNT" as "UpakovkaAmount",
"ZAYAVKINADVERI"."ISSHUMOIZOLACIA" as "IsShumoizolacia",
"ZAYAVKINADVERI"."SHUMOIZOLACIAAMOUNT" as "ShumoizolaciaAmount",
"ZAYAVKINADVERI"."ISGERMANSKIYUPLOTNITEL" as "IsGermanskiyUplotnitel",
"ZAYAVKINADVERI"."GERMANSKIYUPLOTNITELAMOUNT" as "GermanskiyUplotnitelAmount",
"Zvonki_174"."NAME" as "FF_400",
"ZAYAVKINADVERI"."ZVONOKAMOUNT" as "ZvonokAmount",
"ZAYAVKINADVERI"."ZVONOKNAVISOTE" as "ZvonokNaVisote",
"RazmeshenieZvonka_175"."NAME" as "FF_401",
"ZAYAVKINADVERI"."GLAZOKNAVISOTE" as "GlazokNaVisote",
"PanelSides_21"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_402",
"PanelSides_21"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_403",
"PanelSides_34"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_404",
"PanelSides_34"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_405",
"PanelSides_49"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_406",
"PanelSides_49"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_407",
"PanelSides_62"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_408",
"PanelSides_62"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_409",
"PanelSides_77"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_410",
"PanelSides_77"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_411",
"PanelSides_90"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_412",
"PanelSides_90"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_413",
"PanelSides_105"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_414",
"PanelSides_105"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_415",
"PanelSides_118"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_416",
"PanelSides_118"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_417",
"PanelSides_133"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_418",
"PanelSides_133"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_419",
"PanelSides_146"."ISMDFSZERKALNIMIVSTAVKAMI" as "FF_420",
"PanelSides_146"."ISMDFSCVETNIMIVSTAVKAMI" as "FF_421",
"ZAYAVKINADVERI"."ISLEVAYAFRAMUGASJEMNAYA" as "IsLevayaFramugaSjemnaya",
"ZAYAVKINADVERI"."ISPRAVAYAFRAMUGASJEMNAYA" as "IsPravayaFramugaSjemnaya",
"ZAYAVKINADVERI"."ISVERHFRAMUGASJEMNAYA" as "IsVerhFramugaSjemnaya",
"ZAYAVKINADVERI"."ISMINERALNAYAPLITA" as "IsMineralnayaPlita",
"ZAYAVKINADVERI"."ISPOLOTNO80MM" as "IsPolotno80MM",
"ZAYAVKINADVERI"."POLOTNO80MMSTOIMOST" as "Polotno80MMStoimost"
from "ZAYAVKINADVERI"
left join "MODELIDVEREI" "ModeliDverei_1" on ("ModeliDverei_1".id = "ZAYAVKINADVERI"."MODELDVERIID")
left join "NAVESKI" "Naveski_2" on ("Naveski_2".id = "ZAYAVKINADVERI"."NAVESKAID")
left join "ZAMKI" "Zamki_3" on ("Zamki_3".id = "ZAYAVKINADVERI"."OSNZAMOKID")
left join "CILINDRI" "Cilindri_4" on ("Cilindri_4".id = "ZAYAVKINADVERI"."OSNCILINDRID")
left join "KLUCHEVINI" "Kluchevini_5" on ("Kluchevini_5".id = "ZAYAVKINADVERI"."OSNKLUCHEVINAID")
left join "ZAMKI" "Zamki_6" on ("Zamki_6".id = "ZAYAVKINADVERI"."DOPZAMOKID")
left join "CILINDRI" "Cilindri_7" on ("Cilindri_7".id = "ZAYAVKINADVERI"."DOPCILINDRID")
left join "KLUCHEVINI" "Kluchevini_8" on ("Kluchevini_8".id = "ZAYAVKINADVERI"."DOPKLUCHEVINAID")
left join "RUCHKI" "Ruchki_9" on ("Ruchki_9".id = "ZAYAVKINADVERI"."RUCHKAID")
left join "ZADVIJKI" "Zadvijki_10" on ("Zadvijki_10".id = "ZAYAVKINADVERI"."ZADVIJKAID")
left join "GLAZKI" "Glazki_11" on ("Glazki_11".id = "ZAYAVKINADVERI"."GLAZOKID")
left join "TORCEVIESHPINGALETI" "TorcevieShpingaleti_12" on ("TorcevieShpingaleti_12".id = "ZAYAVKINADVERI"."TORCEVIESHPINGALETIID")
left join "DOVODCHIKI" "Dovodchiki_13" on ("Dovodchiki_13".id = "ZAYAVKINADVERI"."DOVODCHIKID")
left join "TIPIUSTANOVKIDOVODCHIKA" "TipiUstanovkiDovodchika_14" on ("TipiUstanovkiDovodchika_14".id = "ZAYAVKINADVERI"."TIPUSTANOVKIDOVODCHIKAID")
left join "TIPIDEMONTAJA" "TipiDemontaja_15" on ("TipiDemontaja_15".id = "ZAYAVKINADVERI"."TIPDEMONTAJAID")
left join "BRONI" "Broni_16" on ("Broni_16".id = "ZAYAVKINADVERI"."OSNBRONID")
left join "BRONI" "Broni_17" on ("Broni_17".id = "ZAYAVKINADVERI"."DOPBRONID")
left join "CVETA" "Cveta_18" on ("Cveta_18".id = "ZAYAVKINADVERI"."CVETPOLOTNAID")
left join "CVETA" "Cveta_19" on ("Cveta_19".id = "ZAYAVKINADVERI"."CVETKOROBAID")
left join "PANELS" "Panels_20" on ("Panels_20".id = "ZAYAVKINADVERI"."OSNSTVORKAID")
left join "PANELSIDES" "PanelSides_21" on ("PanelSides_21".id = "Panels_20"."NARUJN")
left join "OTDELKA" "Otdelka_22" on ("Otdelka_22".id = "PanelSides_21"."OTDELKAID")
left join "CVETA" "Cveta_23" on ("Cveta_23".id = "PanelSides_21"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_24" on ("MaterialMdfPanelei_24".id = "PanelSides_21"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_25" on ("RisunkiFrezerovkiMdf_25".id = "PanelSides_21"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_26" on ("MaterialLdspPanelei_26".id = "PanelSides_21"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_27" on ("RisunkiFilenki_27".id = "PanelSides_21"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_28" on ("RusunkiNakladok_28".id = "PanelSides_21"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_29" on ("Cveta_29".id = "PanelSides_21"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_30" on ("RisunkiPerforacii_30".id = "PanelSides_21"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_31" on ("Cveta_31".id = "PanelSides_21"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_32" on ("RisunkiKovki_32".id = "PanelSides_21"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_33" on ("Cveta_33".id = "PanelSides_21"."CVETKOVKIID")
left join "PANELSIDES" "PanelSides_34" on ("PanelSides_34".id = "Panels_20"."VNUTR")
left join "OTDELKA" "Otdelka_35" on ("Otdelka_35".id = "PanelSides_34"."OTDELKAID")
left join "CVETA" "Cveta_36" on ("Cveta_36".id = "PanelSides_34"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_37" on ("MaterialMdfPanelei_37".id = "PanelSides_34"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_38" on ("RisunkiFrezerovkiMdf_38".id = "PanelSides_34"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_39" on ("MaterialLdspPanelei_39".id = "PanelSides_34"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_40" on ("RisunkiFilenki_40".id = "PanelSides_34"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_41" on ("RusunkiNakladok_41".id = "PanelSides_34"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_42" on ("Cveta_42".id = "PanelSides_34"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_43" on ("RisunkiPerforacii_43".id = "PanelSides_34"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_44" on ("Cveta_44".id = "PanelSides_34"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_45" on ("RisunkiKovki_45".id = "PanelSides_34"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_46" on ("Cveta_46".id = "PanelSides_34"."CVETKOVKIID")
left join "STEKLOPAKETI" "Steklopaketi_47" on ("Steklopaketi_47".id = "Panels_20"."STEKLOPAKETID")
left join "PANELS" "Panels_48" on ("Panels_48".id = "ZAYAVKINADVERI"."DOPSTVORKAID")
left join "PANELSIDES" "PanelSides_49" on ("PanelSides_49".id = "Panels_48"."NARUJN")
left join "OTDELKA" "Otdelka_50" on ("Otdelka_50".id = "PanelSides_49"."OTDELKAID")
left join "CVETA" "Cveta_51" on ("Cveta_51".id = "PanelSides_49"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_52" on ("MaterialMdfPanelei_52".id = "PanelSides_49"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_53" on ("RisunkiFrezerovkiMdf_53".id = "PanelSides_49"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_54" on ("MaterialLdspPanelei_54".id = "PanelSides_49"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_55" on ("RisunkiFilenki_55".id = "PanelSides_49"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_56" on ("RusunkiNakladok_56".id = "PanelSides_49"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_57" on ("Cveta_57".id = "PanelSides_49"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_58" on ("RisunkiPerforacii_58".id = "PanelSides_49"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_59" on ("Cveta_59".id = "PanelSides_49"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_60" on ("RisunkiKovki_60".id = "PanelSides_49"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_61" on ("Cveta_61".id = "PanelSides_49"."CVETKOVKIID")
left join "PANELSIDES" "PanelSides_62" on ("PanelSides_62".id = "Panels_48"."VNUTR")
left join "OTDELKA" "Otdelka_63" on ("Otdelka_63".id = "PanelSides_62"."OTDELKAID")
left join "CVETA" "Cveta_64" on ("Cveta_64".id = "PanelSides_62"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_65" on ("MaterialMdfPanelei_65".id = "PanelSides_62"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_66" on ("RisunkiFrezerovkiMdf_66".id = "PanelSides_62"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_67" on ("MaterialLdspPanelei_67".id = "PanelSides_62"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_68" on ("RisunkiFilenki_68".id = "PanelSides_62"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_69" on ("RusunkiNakladok_69".id = "PanelSides_62"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_70" on ("Cveta_70".id = "PanelSides_62"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_71" on ("RisunkiPerforacii_71".id = "PanelSides_62"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_72" on ("Cveta_72".id = "PanelSides_62"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_73" on ("RisunkiKovki_73".id = "PanelSides_62"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_74" on ("Cveta_74".id = "PanelSides_62"."CVETKOVKIID")
left join "STEKLOPAKETI" "Steklopaketi_75" on ("Steklopaketi_75".id = "Panels_48"."STEKLOPAKETID")
left join "PANELS" "Panels_76" on ("Panels_76".id = "ZAYAVKINADVERI"."LEVAYAFRAMUGAID")
left join "PANELSIDES" "PanelSides_77" on ("PanelSides_77".id = "Panels_76"."NARUJN")
left join "OTDELKA" "Otdelka_78" on ("Otdelka_78".id = "PanelSides_77"."OTDELKAID")
left join "CVETA" "Cveta_79" on ("Cveta_79".id = "PanelSides_77"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_80" on ("MaterialMdfPanelei_80".id = "PanelSides_77"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_81" on ("RisunkiFrezerovkiMdf_81".id = "PanelSides_77"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_82" on ("MaterialLdspPanelei_82".id = "PanelSides_77"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_83" on ("RisunkiFilenki_83".id = "PanelSides_77"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_84" on ("RusunkiNakladok_84".id = "PanelSides_77"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_85" on ("Cveta_85".id = "PanelSides_77"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_86" on ("RisunkiPerforacii_86".id = "PanelSides_77"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_87" on ("Cveta_87".id = "PanelSides_77"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_88" on ("RisunkiKovki_88".id = "PanelSides_77"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_89" on ("Cveta_89".id = "PanelSides_77"."CVETKOVKIID")
left join "PANELSIDES" "PanelSides_90" on ("PanelSides_90".id = "Panels_76"."VNUTR")
left join "OTDELKA" "Otdelka_91" on ("Otdelka_91".id = "PanelSides_90"."OTDELKAID")
left join "CVETA" "Cveta_92" on ("Cveta_92".id = "PanelSides_90"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_93" on ("MaterialMdfPanelei_93".id = "PanelSides_90"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_94" on ("RisunkiFrezerovkiMdf_94".id = "PanelSides_90"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_95" on ("MaterialLdspPanelei_95".id = "PanelSides_90"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_96" on ("RisunkiFilenki_96".id = "PanelSides_90"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_97" on ("RusunkiNakladok_97".id = "PanelSides_90"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_98" on ("Cveta_98".id = "PanelSides_90"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_99" on ("RisunkiPerforacii_99".id = "PanelSides_90"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_100" on ("Cveta_100".id = "PanelSides_90"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_101" on ("RisunkiKovki_101".id = "PanelSides_90"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_102" on ("Cveta_102".id = "PanelSides_90"."CVETKOVKIID")
left join "STEKLOPAKETI" "Steklopaketi_103" on ("Steklopaketi_103".id = "Panels_76"."STEKLOPAKETID")
left join "PANELS" "Panels_104" on ("Panels_104".id = "ZAYAVKINADVERI"."PRAVAYAFRAMUGAID")
left join "PANELSIDES" "PanelSides_105" on ("PanelSides_105".id = "Panels_104"."NARUJN")
left join "OTDELKA" "Otdelka_106" on ("Otdelka_106".id = "PanelSides_105"."OTDELKAID")
left join "CVETA" "Cveta_107" on ("Cveta_107".id = "PanelSides_105"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_108" on ("MaterialMdfPanelei_108".id = "PanelSides_105"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_109" on ("RisunkiFrezerovkiMdf_109".id = "PanelSides_105"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_110" on ("MaterialLdspPanelei_110".id = "PanelSides_105"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_111" on ("RisunkiFilenki_111".id = "PanelSides_105"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_112" on ("RusunkiNakladok_112".id = "PanelSides_105"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_113" on ("Cveta_113".id = "PanelSides_105"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_114" on ("RisunkiPerforacii_114".id = "PanelSides_105"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_115" on ("Cveta_115".id = "PanelSides_105"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_116" on ("RisunkiKovki_116".id = "PanelSides_105"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_117" on ("Cveta_117".id = "PanelSides_105"."CVETKOVKIID")
left join "PANELSIDES" "PanelSides_118" on ("PanelSides_118".id = "Panels_104"."VNUTR")
left join "OTDELKA" "Otdelka_119" on ("Otdelka_119".id = "PanelSides_118"."OTDELKAID")
left join "CVETA" "Cveta_120" on ("Cveta_120".id = "PanelSides_118"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_121" on ("MaterialMdfPanelei_121".id = "PanelSides_118"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_122" on ("RisunkiFrezerovkiMdf_122".id = "PanelSides_118"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_123" on ("MaterialLdspPanelei_123".id = "PanelSides_118"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_124" on ("RisunkiFilenki_124".id = "PanelSides_118"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_125" on ("RusunkiNakladok_125".id = "PanelSides_118"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_126" on ("Cveta_126".id = "PanelSides_118"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_127" on ("RisunkiPerforacii_127".id = "PanelSides_118"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_128" on ("Cveta_128".id = "PanelSides_118"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_129" on ("RisunkiKovki_129".id = "PanelSides_118"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_130" on ("Cveta_130".id = "PanelSides_118"."CVETKOVKIID")
left join "STEKLOPAKETI" "Steklopaketi_131" on ("Steklopaketi_131".id = "Panels_104"."STEKLOPAKETID")
left join "PANELS" "Panels_132" on ("Panels_132".id = "ZAYAVKINADVERI"."VERHFRAMUGAID")
left join "PANELSIDES" "PanelSides_133" on ("PanelSides_133".id = "Panels_132"."NARUJN")
left join "OTDELKA" "Otdelka_134" on ("Otdelka_134".id = "PanelSides_133"."OTDELKAID")
left join "CVETA" "Cveta_135" on ("Cveta_135".id = "PanelSides_133"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_136" on ("MaterialMdfPanelei_136".id = "PanelSides_133"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_137" on ("RisunkiFrezerovkiMdf_137".id = "PanelSides_133"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_138" on ("MaterialLdspPanelei_138".id = "PanelSides_133"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_139" on ("RisunkiFilenki_139".id = "PanelSides_133"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_140" on ("RusunkiNakladok_140".id = "PanelSides_133"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_141" on ("Cveta_141".id = "PanelSides_133"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_142" on ("RisunkiPerforacii_142".id = "PanelSides_133"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_143" on ("Cveta_143".id = "PanelSides_133"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_144" on ("RisunkiKovki_144".id = "PanelSides_133"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_145" on ("Cveta_145".id = "PanelSides_133"."CVETKOVKIID")
left join "PANELSIDES" "PanelSides_146" on ("PanelSides_146".id = "Panels_132"."VNUTR")
left join "OTDELKA" "Otdelka_147" on ("Otdelka_147".id = "PanelSides_146"."OTDELKAID")
left join "CVETA" "Cveta_148" on ("Cveta_148".id = "PanelSides_146"."DRUGOICVETIDPOVERHNOSTI")
left join "MATERIALMDFPANELEI" "MaterialMdfPanelei_149" on ("MaterialMdfPanelei_149".id = "PanelSides_146"."MATERIALMDFPANELIID")
left join "RISUNKIFREZEROVKIMDF" "RisunkiFrezerovkiMdf_150" on ("RisunkiFrezerovkiMdf_150".id = "PanelSides_146"."RISUNOKFREZEROVKIMDFID")
left join "MATERIALLDSPPANELEI" "MaterialLdspPanelei_151" on ("MaterialLdspPanelei_151".id = "PanelSides_146"."MATERIALLDSPPANELIID")
left join "RISUNKIFILENKI" "RisunkiFilenki_152" on ("RisunkiFilenki_152".id = "PanelSides_146"."RISUNOKFILENKIID")
left join "RUSUNKINAKLADOK" "RusunkiNakladok_153" on ("RusunkiNakladok_153".id = "PanelSides_146"."RISUNOKNAKLADKIID")
left join "CVETA" "Cveta_154" on ("Cveta_154".id = "PanelSides_146"."CVETRISUNKANAKLADKIID")
left join "RISUNKIPERFORACII" "RisunkiPerforacii_155" on ("RisunkiPerforacii_155".id = "PanelSides_146"."RISUNOKPERFORACIIID")
left join "CVETA" "Cveta_156" on ("Cveta_156".id = "PanelSides_146"."CVETRISUNKAPERFORACIIID")
left join "RISUNKIKOVKI" "RisunkiKovki_157" on ("RisunkiKovki_157".id = "PanelSides_146"."RISUNOKKOVKIID")
left join "CVETA" "Cveta_158" on ("Cveta_158".id = "PanelSides_146"."CVETKOVKIID")
left join "STEKLOPAKETI" "Steklopaketi_159" on ("Steklopaketi_159".id = "Panels_132"."STEKLOPAKETID")
left join "Users" "Users_160" on ("Users_160".id = "ZAYAVKINADVERI"."SOZDATELID")
left join "PROFILISTOEK" "ProfiliStoek_161" on ("ProfiliStoek_161".id = "ZAYAVKINADVERI"."PROFILLEVOISTOIKIID")
left join "PROFILISTOEK" "ProfiliStoek_162" on ("ProfiliStoek_162".id = "ZAYAVKINADVERI"."PROFILPRAVOISTOIKIID")
left join "PROFILISTOEK" "ProfiliStoek_163" on ("ProfiliStoek_163".id = "ZAYAVKINADVERI"."PROFILVERHNEISTOIKIID")
left join "PROFILISTOEK" "ProfiliStoek_164" on ("ProfiliStoek_164".id = "ZAYAVKINADVERI"."PROFILNIJNEISTOIKIID")
left join "RISUNKIDVEREI" "RisunkiDverei_165" on ("RisunkiDverei_165".id = "ZAYAVKINADVERI"."RISUNOKDVERIID")
left join "BRONISTEKLOPAKETA" "BroniSteklopaketa_166" on ("BroniSteklopaketa_166".id = "Panels_20"."BRONSTEKLOPAKETAID")
left join "BRONISTEKLOPAKETA" "BroniSteklopaketa_167" on ("BroniSteklopaketa_167".id = "Panels_48"."BRONSTEKLOPAKETAID")
left join "BRONISTEKLOPAKETA" "BroniSteklopaketa_168" on ("BroniSteklopaketa_168".id = "Panels_76"."BRONSTEKLOPAKETAID")
left join "BRONISTEKLOPAKETA" "BroniSteklopaketa_169" on ("BroniSteklopaketa_169".id = "Panels_104"."BRONSTEKLOPAKETAID")
left join "BRONISTEKLOPAKETA" "BroniSteklopaketa_170" on ("BroniSteklopaketa_170".id = "Panels_132"."BRONSTEKLOPAKETAID")
left join "DVERIVRABOTE" "DveriVRabote_171" on ("DveriVRabote_171".id = "ZAYAVKINADVERI"."DVERIVRABOTEID")
left join "GERKONI" "Gerkoni_172" on ("Gerkoni_172".id = "ZAYAVKINADVERI"."GERKONIID")
left join "UPAKOVKA" "Upakovka_173" on ("Upakovka_173".id = "ZAYAVKINADVERI"."UPAKOVKAID")
left join "ZVONKI" "Zvonki_174" on ("Zvonki_174".id = "ZAYAVKINADVERI"."ZVONOKID")
left join "RAZMESHENIEZVONKA" "RazmeshenieZvonka_175" on ("RazmeshenieZvonka_175".id = "ZAYAVKINADVERI"."RAZMESHENIEZVONKAID")
where ("ZAYAVKINADVERI"."ID" = :Id0)
Запрашиваются не все поля, а только те, которые нужны для печати одного единственного листа. SQL генерируется не ручками.
Я вас так же уверяю, что форма ввода всего этого сделана вполне удобно. |
