Ошибка. Число столбцов в соединениях ограничено 32767 / PostgreSQL

ReSQL.ru

Мобильная версия Контакт Правила FAQ Помощь

Гость

Войти | Регистрация | Профиль | Очистить

Новые сообщения | Избранное

Форумы | Пользователи | Статистика | Мод. лог | Поиск

Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр

Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / Ошибка. Число столбцов в соединениях ограничено 32767

5 сообщений из 5, страница 1 из 1

Ошибка. Число столбцов в соединениях ограничено 32767

#39694085

Visermoz

Гость

Здравствуйте.
Сегодня впервые столкнулся с ошибкой:

Код: plsql

 54000: число столбцов в соединениях ограничено 32767

Попался замысловатый запрос из 70 таблиц(!).
на каждый JOIN приходится примерно такое условие соединения

Код: plsql

1.
2.
3.

...
LEFT JOIN schema1.table3 t3 ON t1.id=t3.master_id AND t3.attr1=12 AND t3.label1=1 AND t3.user IS NULL
...

И при выполнении и при построении плана получаю следующую ошибку.
Поясните пожалуйста про число 32767. В запросе я нашел только 327 столбцов, упоминаемых после ON.
Это максимальное значение для типа smallint, но как это относится к запросу. Не могу понять откуда возникает такое ограничение и откуда берется число 32767.

Я сделал тестовый пример, который создает 400 таблиц, добавляет в каждую запись и формирует SQL-запрос:

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.

create schema test;
set search_path=test;

do
$$
declare
	table_name varchar(40);
	sql_text text;
begin
	for i in 1..400 
	loop
		if i=1 then
			table_name:='main_table';
			sql_text:='select 1 from '||table_name||' n'||i||chr(10);
		else
			table_name:='tab_'||i;
			sql_text:=sql_text||' join '||table_name||' n'||i||' on n'||i||'.parent_key=n1.key and n'||i||'.name=''Текст'' and n'||i||'.key=1000020010975155 and n'||i||'.parent_key=1000020010975155 and n'||i||'.info=''Текст'' '||chr(10);
		end if;
		execute 'drop table if exists '||table_name;
		execute 'create table '||table_name||'(key bigserial primary key, name text, parent_key bigint, info text)';
		execute 'insert into '||table_name||'(key,name,parent_key,info) values(1000020010975155,''Текст'',1000020010975155,''Текст'')';
	end loop;
	raise info '%',sql_text;
end$$;

Запрос в результате. в нем 2394 столбца всего после ON:

Код: plsql

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.

select 1 from main_table n1
 join tab_2 n2 on n2.parent_key=n1.key and n2.name='Текст' and n2.key=1000020010975155 and n2.parent_key=1000020010975155 and n2.info='Текст' 
 join tab_3 n3 on n3.parent_key=n1.key and n3.name='Текст' and n3.key=1000020010975155 and n3.parent_key=1000020010975155 and n3.info='Текст' 
 join tab_4 n4 on n4.parent_key=n1.key and n4.name='Текст' and n4.key=1000020010975155 and n4.parent_key=1000020010975155 and n4.info='Текст' 
 join tab_5 n5 on n5.parent_key=n1.key and n5.name='Текст' and n5.key=1000020010975155 and n5.parent_key=1000020010975155 and n5.info='Текст' 
 join tab_6 n6 on n6.parent_key=n1.key and n6.name='Текст' and n6.key=1000020010975155 and n6.parent_key=1000020010975155 and n6.info='Текст' 
 join tab_7 n7 on n7.parent_key=n1.key and n7.name='Текст' and n7.key=1000020010975155 and n7.parent_key=1000020010975155 and n7.info='Текст' 
 join tab_8 n8 on n8.parent_key=n1.key and n8.name='Текст' and n8.key=1000020010975155 and n8.parent_key=1000020010975155 and n8.info='Текст' 
 join tab_9 n9 on n9.parent_key=n1.key and n9.name='Текст' and n9.key=1000020010975155 and n9.parent_key=1000020010975155 and n9.info='Текст' 
 join tab_10 n10 on n10.parent_key=n1.key and n10.name='Текст' and n10.key=1000020010975155 and n10.parent_key=1000020010975155 and n10.info='Текст' 
 join tab_11 n11 on n11.parent_key=n1.key and n11.name='Текст' and n11.key=1000020010975155 and n11.parent_key=1000020010975155 and n11.info='Текст' 
 join tab_12 n12 on n12.parent_key=n1.key and n12.name='Текст' and n12.key=1000020010975155 and n12.parent_key=1000020010975155 and n12.info='Текст' 
 join tab_13 n13 on n13.parent_key=n1.key and n13.name='Текст' and n13.key=1000020010975155 and n13.parent_key=1000020010975155 and n13.info='Текст' 
 join tab_14 n14 on n14.parent_key=n1.key and n14.name='Текст' and n14.key=1000020010975155 and n14.parent_key=1000020010975155 and n14.info='Текст' 
 join tab_15 n15 on n15.parent_key=n1.key and n15.name='Текст' and n15.key=1000020010975155 and n15.parent_key=1000020010975155 and n15.info='Текст' 
 join tab_16 n16 on n16.parent_key=n1.key and n16.name='Текст' and n16.key=1000020010975155 and n16.parent_key=1000020010975155 and n16.info='Текст' 
 join tab_17 n17 on n17.parent_key=n1.key and n17.name='Текст' and n17.key=1000020010975155 and n17.parent_key=1000020010975155 and n17.info='Текст' 
 join tab_18 n18 on n18.parent_key=n1.key and n18.name='Текст' and n18.key=1000020010975155 and n18.parent_key=1000020010975155 and n18.info='Текст' 
 join tab_19 n19 on n19.parent_key=n1.key and n19.name='Текст' and n19.key=1000020010975155 and n19.parent_key=1000020010975155 and n19.info='Текст' 
 join tab_20 n20 on n20.parent_key=n1.key and n20.name='Текст' and n20.key=1000020010975155 and n20.parent_key=1000020010975155 and n20.info='Текст' 
 join tab_21 n21 on n21.parent_key=n1.key and n21.name='Текст' and n21.key=1000020010975155 and n21.parent_key=1000020010975155 and n21.info='Текст' 
 join tab_22 n22 on n22.parent_key=n1.key and n22.name='Текст' and n22.key=1000020010975155 and n22.parent_key=1000020010975155 and n22.info='Текст' 
 join tab_23 n23 on n23.parent_key=n1.key and n23.name='Текст' and n23.key=1000020010975155 and n23.parent_key=1000020010975155 and n23.info='Текст' 
 join tab_24 n24 on n24.parent_key=n1.key and n24.name='Текст' and n24.key=1000020010975155 and n24.parent_key=1000020010975155 and n24.info='Текст' 
 join tab_25 n25 on n25.parent_key=n1.key and n25.name='Текст' and n25.key=1000020010975155 and n25.parent_key=1000020010975155 and n25.info='Текст' 
 join tab_26 n26 on n26.parent_key=n1.key and n26.name='Текст' and n26.key=1000020010975155 and n26.parent_key=1000020010975155 and n26.info='Текст' 
 join tab_27 n27 on n27.parent_key=n1.key and n27.name='Текст' and n27.key=1000020010975155 and n27.parent_key=1000020010975155 and n27.info='Текст' 
 join tab_28 n28 on n28.parent_key=n1.key and n28.name='Текст' and n28.key=1000020010975155 and n28.parent_key=1000020010975155 and n28.info='Текст' 
 join tab_29 n29 on n29.parent_key=n1.key and n29.name='Текст' and n29.key=1000020010975155 and n29.parent_key=1000020010975155 and n29.info='Текст' 
 join tab_30 n30 on n30.parent_key=n1.key and n30.name='Текст' and n30.key=1000020010975155 and n30.parent_key=1000020010975155 and n30.info='Текст' 
 join tab_31 n31 on n31.parent_key=n1.key and n31.name='Текст' and n31.key=1000020010975155 and n31.parent_key=1000020010975155 and n31.info='Текст' 
 join tab_32 n32 on n32.parent_key=n1.key and n32.name='Текст' and n32.key=1000020010975155 and n32.parent_key=1000020010975155 and n32.info='Текст' 
 join tab_33 n33 on n33.parent_key=n1.key and n33.name='Текст' and n33.key=1000020010975155 and n33.parent_key=1000020010975155 and n33.info='Текст' 
 join tab_34 n34 on n34.parent_key=n1.key and n34.name='Текст' and n34.key=1000020010975155 and n34.parent_key=1000020010975155 and n34.info='Текст' 
 join tab_35 n35 on n35.parent_key=n1.key and n35.name='Текст' and n35.key=1000020010975155 and n35.parent_key=1000020010975155 and n35.info='Текст' 
 join tab_36 n36 on n36.parent_key=n1.key and n36.name='Текст' and n36.key=1000020010975155 and n36.parent_key=1000020010975155 and n36.info='Текст' 
 join tab_37 n37 on n37.parent_key=n1.key and n37.name='Текст' and n37.key=1000020010975155 and n37.parent_key=1000020010975155 and n37.info='Текст' 
 join tab_38 n38 on n38.parent_key=n1.key and n38.name='Текст' and n38.key=1000020010975155 and n38.parent_key=1000020010975155 and n38.info='Текст' 
 join tab_39 n39 on n39.parent_key=n1.key and n39.name='Текст' and n39.key=1000020010975155 and n39.parent_key=1000020010975155 and n39.info='Текст' 
 join tab_40 n40 on n40.parent_key=n1.key and n40.name='Текст' and n40.key=1000020010975155 and n40.parent_key=1000020010975155 and n40.info='Текст' 
 join tab_41 n41 on n41.parent_key=n1.key and n41.name='Текст' and n41.key=1000020010975155 and n41.parent_key=1000020010975155 and n41.info='Текст' 
 join tab_42 n42 on n42.parent_key=n1.key and n42.name='Текст' and n42.key=1000020010975155 and n42.parent_key=1000020010975155 and n42.info='Текст' 
 join tab_43 n43 on n43.parent_key=n1.key and n43.name='Текст' and n43.key=1000020010975155 and n43.parent_key=1000020010975155 and n43.info='Текст' 
 join tab_44 n44 on n44.parent_key=n1.key and n44.name='Текст' and n44.key=1000020010975155 and n44.parent_key=1000020010975155 and n44.info='Текст' 
 join tab_45 n45 on n45.parent_key=n1.key and n45.name='Текст' and n45.key=1000020010975155 and n45.parent_key=1000020010975155 and n45.info='Текст' 
 join tab_46 n46 on n46.parent_key=n1.key and n46.name='Текст' and n46.key=1000020010975155 and n46.parent_key=1000020010975155 and n46.info='Текст' 
 join tab_47 n47 on n47.parent_key=n1.key and n47.name='Текст' and n47.key=1000020010975155 and n47.parent_key=1000020010975155 and n47.info='Текст' 
 join tab_48 n48 on n48.parent_key=n1.key and n48.name='Текст' and n48.key=1000020010975155 and n48.parent_key=1000020010975155 and n48.info='Текст' 
 join tab_49 n49 on n49.parent_key=n1.key and n49.name='Текст' and n49.key=1000020010975155 and n49.parent_key=1000020010975155 and n49.info='Текст' 
 join tab_50 n50 on n50.parent_key=n1.key and n50.name='Текст' and n50.key=1000020010975155 and n50.parent_key=1000020010975155 and n50.info='Текст' 
 join tab_51 n51 on n51.parent_key=n1.key and n51.name='Текст' and n51.key=1000020010975155 and n51.parent_key=1000020010975155 and n51.info='Текст' 
 join tab_52 n52 on n52.parent_key=n1.key and n52.name='Текст' and n52.key=1000020010975155 and n52.parent_key=1000020010975155 and n52.info='Текст' 
 join tab_53 n53 on n53.parent_key=n1.key and n53.name='Текст' and n53.key=1000020010975155 and n53.parent_key=1000020010975155 and n53.info='Текст' 
 join tab_54 n54 on n54.parent_key=n1.key and n54.name='Текст' and n54.key=1000020010975155 and n54.parent_key=1000020010975155 and n54.info='Текст' 
 join tab_55 n55 on n55.parent_key=n1.key and n55.name='Текст' and n55.key=1000020010975155 and n55.parent_key=1000020010975155 and n55.info='Текст' 
 join tab_56 n56 on n56.parent_key=n1.key and n56.name='Текст' and n56.key=1000020010975155 and n56.parent_key=1000020010975155 and n56.info='Текст' 
 join tab_57 n57 on n57.parent_key=n1.key and n57.name='Текст' and n57.key=1000020010975155 and n57.parent_key=1000020010975155 and n57.info='Текст' 
 join tab_58 n58 on n58.parent_key=n1.key and n58.name='Текст' and n58.key=1000020010975155 and n58.parent_key=1000020010975155 and n58.info='Текст' 
 join tab_59 n59 on n59.parent_key=n1.key and n59.name='Текст' and n59.key=1000020010975155 and n59.parent_key=1000020010975155 and n59.info='Текст' 
 join tab_60 n60 on n60.parent_key=n1.key and n60.name='Текст' and n60.key=1000020010975155 and n60.parent_key=1000020010975155 and n60.info='Текст' 
 join tab_61 n61 on n61.parent_key=n1.key and n61.name='Текст' and n61.key=1000020010975155 and n61.parent_key=1000020010975155 and n61.info='Текст' 
 join tab_62 n62 on n62.parent_key=n1.key and n62.name='Текст' and n62.key=1000020010975155 and n62.parent_key=1000020010975155 and n62.info='Текст' 
 join tab_63 n63 on n63.parent_key=n1.key and n63.name='Текст' and n63.key=1000020010975155 and n63.parent_key=1000020010975155 and n63.info='Текст' 
 join tab_64 n64 on n64.parent_key=n1.key and n64.name='Текст' and n64.key=1000020010975155 and n64.parent_key=1000020010975155 and n64.info='Текст' 
 join tab_65 n65 on n65.parent_key=n1.key and n65.name='Текст' and n65.key=1000020010975155 and n65.parent_key=1000020010975155 and n65.info='Текст' 
 join tab_66 n66 on n66.parent_key=n1.key and n66.name='Текст' and n66.key=1000020010975155 and n66.parent_key=1000020010975155 and n66.info='Текст' 
 join tab_67 n67 on n67.parent_key=n1.key and n67.name='Текст' and n67.key=1000020010975155 and n67.parent_key=1000020010975155 and n67.info='Текст' 
 join tab_68 n68 on n68.parent_key=n1.key and n68.name='Текст' and n68.key=1000020010975155 and n68.parent_key=1000020010975155 and n68.info='Текст' 
 join tab_69 n69 on n69.parent_key=n1.key and n69.name='Текст' and n69.key=1000020010975155 and n69.parent_key=1000020010975155 and n69.info='Текст' 
 join tab_70 n70 on n70.parent_key=n1.key and n70.name='Текст' and n70.key=1000020010975155 and n70.parent_key=1000020010975155 and n70.info='Текст' 
 join tab_71 n71 on n71.parent_key=n1.key and n71.name='Текст' and n71.key=1000020010975155 and n71.parent_key=1000020010975155 and n71.info='Текст' 
 join tab_72 n72 on n72.parent_key=n1.key and n72.name='Текст' and n72.key=1000020010975155 and n72.parent_key=1000020010975155 and n72.info='Текст' 
 join tab_73 n73 on n73.parent_key=n1.key and n73.name='Текст' and n73.key=1000020010975155 and n73.parent_key=1000020010975155 and n73.info='Текст' 
 join tab_74 n74 on n74.parent_key=n1.key and n74.name='Текст' and n74.key=1000020010975155 and n74.parent_key=1000020010975155 and n74.info='Текст' 
 join tab_75 n75 on n75.parent_key=n1.key and n75.name='Текст' and n75.key=1000020010975155 and n75.parent_key=1000020010975155 and n75.info='Текст' 
 join tab_76 n76 on n76.parent_key=n1.key and n76.name='Текст' and n76.key=1000020010975155 and n76.parent_key=1000020010975155 and n76.info='Текст' 
 join tab_77 n77 on n77.parent_key=n1.key and n77.name='Текст' and n77.key=1000020010975155 and n77.parent_key=1000020010975155 and n77.info='Текст' 
 join tab_78 n78 on n78.parent_key=n1.key and n78.name='Текст' and n78.key=1000020010975155 and n78.parent_key=1000020010975155 and n78.info='Текст' 
 join tab_79 n79 on n79.parent_key=n1.key and n79.name='Текст' and n79.key=1000020010975155 and n79.parent_key=1000020010975155 and n79.info='Текст' 
 join tab_80 n80 on n80.parent_key=n1.key and n80.name='Текст' and n80.key=1000020010975155 and n80.parent_key=1000020010975155 and n80.info='Текст' 
 join tab_81 n81 on n81.parent_key=n1.key and n81.name='Текст' and n81.key=1000020010975155 and n81.parent_key=1000020010975155 and n81.info='Текст' 
 join tab_82 n82 on n82.parent_key=n1.key and n82.name='Текст' and n82.key=1000020010975155 and n82.parent_key=1000020010975155 and n82.info='Текст' 
 join tab_83 n83 on n83.parent_key=n1.key and n83.name='Текст' and n83.key=1000020010975155 and n83.parent_key=1000020010975155 and n83.info='Текст' 
 join tab_84 n84 on n84.parent_key=n1.key and n84.name='Текст' and n84.key=1000020010975155 and n84.parent_key=1000020010975155 and n84.info='Текст' 
 join tab_85 n85 on n85.parent_key=n1.key and n85.name='Текст' and n85.key=1000020010975155 and n85.parent_key=1000020010975155 and n85.info='Текст' 
 join tab_86 n86 on n86.parent_key=n1.key and n86.name='Текст' and n86.key=1000020010975155 and n86.parent_key=1000020010975155 and n86.info='Текст' 
 join tab_87 n87 on n87.parent_key=n1.key and n87.name='Текст' and n87.key=1000020010975155 and n87.parent_key=1000020010975155 and n87.info='Текст' 
 join tab_88 n88 on n88.parent_key=n1.key and n88.name='Текст' and n88.key=1000020010975155 and n88.parent_key=1000020010975155 and n88.info='Текст' 
 join tab_89 n89 on n89.parent_key=n1.key and n89.name='Текст' and n89.key=1000020010975155 and n89.parent_key=1000020010975155 and n89.info='Текст' 
 join tab_90 n90 on n90.parent_key=n1.key and n90.name='Текст' and n90.key=1000020010975155 and n90.parent_key=1000020010975155 and n90.info='Текст' 
 join tab_91 n91 on n91.parent_key=n1.key and n91.name='Текст' and n91.key=1000020010975155 and n91.parent_key=1000020010975155 and n91.info='Текст' 
 join tab_92 n92 on n92.parent_key=n1.key and n92.name='Текст' and n92.key=1000020010975155 and n92.parent_key=1000020010975155 and n92.info='Текст' 
 join tab_93 n93 on n93.parent_key=n1.key and n93.name='Текст' and n93.key=1000020010975155 and n93.parent_key=1000020010975155 and n93.info='Текст' 
 join tab_94 n94 on n94.parent_key=n1.key and n94.name='Текст' and n94.key=1000020010975155 and n94.parent_key=1000020010975155 and n94.info='Текст' 
 join tab_95 n95 on n95.parent_key=n1.key and n95.name='Текст' and n95.key=1000020010975155 and n95.parent_key=1000020010975155 and n95.info='Текст' 
 join tab_96 n96 on n96.parent_key=n1.key and n96.name='Текст' and n96.key=1000020010975155 and n96.parent_key=1000020010975155 and n96.info='Текст' 
 join tab_97 n97 on n97.parent_key=n1.key and n97.name='Текст' and n97.key=1000020010975155 and n97.parent_key=1000020010975155 and n97.info='Текст' 
 join tab_98 n98 on n98.parent_key=n1.key and n98.name='Текст' and n98.key=1000020010975155 and n98.parent_key=1000020010975155 and n98.info='Текст' 
 join tab_99 n99 on n99.parent_key=n1.key and n99.name='Текст' and n99.key=1000020010975155 and n99.parent_key=1000020010975155 and n99.info='Текст' 
 join tab_100 n100 on n100.parent_key=n1.key and n100.name='Текст' and n100.key=1000020010975155 and n100.parent_key=1000020010975155 and n100.info='Текст' 
 join tab_101 n101 on n101.parent_key=n1.key and n101.name='Текст' and n101.key=1000020010975155 and n101.parent_key=1000020010975155 and n101.info='Текст' 
 join tab_102 n102 on n102.parent_key=n1.key and n102.name='Текст' and n102.key=1000020010975155 and n102.parent_key=1000020010975155 and n102.info='Текст' 
 join tab_103 n103 on n103.parent_key=n1.key and n103.name='Текст' and n103.key=1000020010975155 and n103.parent_key=1000020010975155 and n103.info='Текст' 
 join tab_104 n104 on n104.parent_key=n1.key and n104.name='Текст' and n104.key=1000020010975155 and n104.parent_key=1000020010975155 and n104.info='Текст' 
 join tab_105 n105 on n105.parent_key=n1.key and n105.name='Текст' and n105.key=1000020010975155 and n105.parent_key=1000020010975155 and n105.info='Текст' 
 join tab_106 n106 on n106.parent_key=n1.key and n106.name='Текст' and n106.key=1000020010975155 and n106.parent_key=1000020010975155 and n106.info='Текст' 
 join tab_107 n107 on n107.parent_key=n1.key and n107.name='Текст' and n107.key=1000020010975155 and n107.parent_key=1000020010975155 and n107.info='Текст' 
 join tab_108 n108 on n108.parent_key=n1.key and n108.name='Текст' and n108.key=1000020010975155 and n108.parent_key=1000020010975155 and n108.info='Текст' 
 join tab_109 n109 on n109.parent_key=n1.key and n109.name='Текст' and n109.key=1000020010975155 and n109.parent_key=1000020010975155 and n109.info='Текст' 
 join tab_110 n110 on n110.parent_key=n1.key and n110.name='Текст' and n110.key=1000020010975155 and n110.parent_key=1000020010975155 and n110.info='Текст' 
 join tab_111 n111 on n111.parent_key=n1.key and n111.name='Текст' and n111.key=1000020010975155 and n111.parent_key=1000020010975155 and n111.info='Текст' 
 join tab_112 n112 on n112.parent_key=n1.key and n112.name='Текст' and n112.key=1000020010975155 and n112.parent_key=1000020010975155 and n112.info='Текст' 
 join tab_113 n113 on n113.parent_key=n1.key and n113.name='Текст' and n113.key=1000020010975155 and n113.parent_key=1000020010975155 and n113.info='Текст' 
 join tab_114 n114 on n114.parent_key=n1.key and n114.name='Текст' and n114.key=1000020010975155 and n114.parent_key=1000020010975155 and n114.info='Текст' 
 join tab_115 n115 on n115.parent_key=n1.key and n115.name='Текст' and n115.key=1000020010975155 and n115.parent_key=1000020010975155 and n115.info='Текст' 
 join tab_116 n116 on n116.parent_key=n1.key and n116.name='Текст' and n116.key=1000020010975155 and n116.parent_key=1000020010975155 and n116.info='Текст' 
 join tab_117 n117 on n117.parent_key=n1.key and n117.name='Текст' and n117.key=1000020010975155 and n117.parent_key=1000020010975155 and n117.info='Текст' 
 join tab_118 n118 on n118.parent_key=n1.key and n118.name='Текст' and n118.key=1000020010975155 and n118.parent_key=1000020010975155 and n118.info='Текст' 
 join tab_119 n119 on n119.parent_key=n1.key and n119.name='Текст' and n119.key=1000020010975155 and n119.parent_key=1000020010975155 and n119.info='Текст' 
 join tab_120 n120 on n120.parent_key=n1.key and n120.name='Текст' and n120.key=1000020010975155 and n120.parent_key=1000020010975155 and n120.info='Текст' 
 join tab_121 n121 on n121.parent_key=n1.key and n121.name='Текст' and n121.key=1000020010975155 and n121.parent_key=1000020010975155 and n121.info='Текст' 
 join tab_122 n122 on n122.parent_key=n1.key and n122.name='Текст' and n122.key=1000020010975155 and n122.parent_key=1000020010975155 and n122.info='Текст' 
 join tab_123 n123 on n123.parent_key=n1.key and n123.name='Текст' and n123.key=1000020010975155 and n123.parent_key=1000020010975155 and n123.info='Текст' 
 join tab_124 n124 on n124.parent_key=n1.key and n124.name='Текст' and n124.key=1000020010975155 and n124.parent_key=1000020010975155 and n124.info='Текст' 
 join tab_125 n125 on n125.parent_key=n1.key and n125.name='Текст' and n125.key=1000020010975155 and n125.parent_key=1000020010975155 and n125.info='Текст' 
 join tab_126 n126 on n126.parent_key=n1.key and n126.name='Текст' and n126.key=1000020010975155 and n126.parent_key=1000020010975155 and n126.info='Текст' 
 join tab_127 n127 on n127.parent_key=n1.key and n127.name='Текст' and n127.key=1000020010975155 and n127.parent_key=1000020010975155 and n127.info='Текст' 
 join tab_128 n128 on n128.parent_key=n1.key and n128.name='Текст' and n128.key=1000020010975155 and n128.parent_key=1000020010975155 and n128.info='Текст' 
 join tab_129 n129 on n129.parent_key=n1.key and n129.name='Текст' and n129.key=1000020010975155 and n129.parent_key=1000020010975155 and n129.info='Текст' 
 join tab_130 n130 on n130.parent_key=n1.key and n130.name='Текст' and n130.key=1000020010975155 and n130.parent_key=1000020010975155 and n130.info='Текст' 
 join tab_131 n131 on n131.parent_key=n1.key and n131.name='Текст' and n131.key=1000020010975155 and n131.parent_key=1000020010975155 and n131.info='Текст' 
 join tab_132 n132 on n132.parent_key=n1.key and n132.name='Текст' and n132.key=1000020010975155 and n132.parent_key=1000020010975155 and n132.info='Текст' 
 join tab_133 n133 on n133.parent_key=n1.key and n133.name='Текст' and n133.key=1000020010975155 and n133.parent_key=1000020010975155 and n133.info='Текст' 
 join tab_134 n134 on n134.parent_key=n1.key and n134.name='Текст' and n134.key=1000020010975155 and n134.parent_key=1000020010975155 and n134.info='Текст' 
 join tab_135 n135 on n135.parent_key=n1.key and n135.name='Текст' and n135.key=1000020010975155 and n135.parent_key=1000020010975155 and n135.info='Текст' 
 join tab_136 n136 on n136.parent_key=n1.key and n136.name='Текст' and n136.key=1000020010975155 and n136.parent_key=1000020010975155 and n136.info='Текст' 
 join tab_137 n137 on n137.parent_key=n1.key and n137.name='Текст' and n137.key=1000020010975155 and n137.parent_key=1000020010975155 and n137.info='Текст' 
 join tab_138 n138 on n138.parent_key=n1.key and n138.name='Текст' and n138.key=1000020010975155 and n138.parent_key=1000020010975155 and n138.info='Текст' 
 join tab_139 n139 on n139.parent_key=n1.key and n139.name='Текст' and n139.key=1000020010975155 and n139.parent_key=1000020010975155 and n139.info='Текст' 
 join tab_140 n140 on n140.parent_key=n1.key and n140.name='Текст' and n140.key=1000020010975155 and n140.parent_key=1000020010975155 and n140.info='Текст' 
 join tab_141 n141 on n141.parent_key=n1.key and n141.name='Текст' and n141.key=1000020010975155 and n141.parent_key=1000020010975155 and n141.info='Текст' 
 join tab_142 n142 on n142.parent_key=n1.key and n142.name='Текст' and n142.key=1000020010975155 and n142.parent_key=1000020010975155 and n142.info='Текст' 
 join tab_143 n143 on n143.parent_key=n1.key and n143.name='Текст' and n143.key=1000020010975155 and n143.parent_key=1000020010975155 and n143.info='Текст' 
 join tab_144 n144 on n144.parent_key=n1.key and n144.name='Текст' and n144.key=1000020010975155 and n144.parent_key=1000020010975155 and n144.info='Текст' 
 join tab_145 n145 on n145.parent_key=n1.key and n145.name='Текст' and n145.key=1000020010975155 and n145.parent_key=1000020010975155 and n145.info='Текст' 
 join tab_146 n146 on n146.parent_key=n1.key and n146.name='Текст' and n146.key=1000020010975155 and n146.parent_key=1000020010975155 and n146.info='Текст' 
 join tab_147 n147 on n147.parent_key=n1.key and n147.name='Текст' and n147.key=1000020010975155 and n147.parent_key=1000020010975155 and n147.info='Текст' 
 join tab_148 n148 on n148.parent_key=n1.key and n148.name='Текст' and n148.key=1000020010975155 and n148.parent_key=1000020010975155 and n148.info='Текст' 
 join tab_149 n149 on n149.parent_key=n1.key and n149.name='Текст' and n149.key=1000020010975155 and n149.parent_key=1000020010975155 and n149.info='Текст' 
 join tab_150 n150 on n150.parent_key=n1.key and n150.name='Текст' and n150.key=1000020010975155 and n150.parent_key=1000020010975155 and n150.info='Текст' 
 join tab_151 n151 on n151.parent_key=n1.key and n151.name='Текст' and n151.key=1000020010975155 and n151.parent_key=1000020010975155 and n151.info='Текст' 
 join tab_152 n152 on n152.parent_key=n1.key and n152.name='Текст' and n152.key=1000020010975155 and n152.parent_key=1000020010975155 and n152.info='Текст' 
 join tab_153 n153 on n153.parent_key=n1.key and n153.name='Текст' and n153.key=1000020010975155 and n153.parent_key=1000020010975155 and n153.info='Текст' 
 join tab_154 n154 on n154.parent_key=n1.key and n154.name='Текст' and n154.key=1000020010975155 and n154.parent_key=1000020010975155 and n154.info='Текст' 
 join tab_155 n155 on n155.parent_key=n1.key and n155.name='Текст' and n155.key=1000020010975155 and n155.parent_key=1000020010975155 and n155.info='Текст' 
 join tab_156 n156 on n156.parent_key=n1.key and n156.name='Текст' and n156.key=1000020010975155 and n156.parent_key=1000020010975155 and n156.info='Текст' 
 join tab_157 n157 on n157.parent_key=n1.key and n157.name='Текст' and n157.key=1000020010975155 and n157.parent_key=1000020010975155 and n157.info='Текст' 
 join tab_158 n158 on n158.parent_key=n1.key and n158.name='Текст' and n158.key=1000020010975155 and n158.parent_key=1000020010975155 and n158.info='Текст' 
 join tab_159 n159 on n159.parent_key=n1.key and n159.name='Текст' and n159.key=1000020010975155 and n159.parent_key=1000020010975155 and n159.info='Текст' 
 join tab_160 n160 on n160.parent_key=n1.key and n160.name='Текст' and n160.key=1000020010975155 and n160.parent_key=1000020010975155 and n160.info='Текст' 
 join tab_161 n161 on n161.parent_key=n1.key and n161.name='Текст' and n161.key=1000020010975155 and n161.parent_key=1000020010975155 and n161.info='Текст' 
 join tab_162 n162 on n162.parent_key=n1.key and n162.name='Текст' and n162.key=1000020010975155 and n162.parent_key=1000020010975155 and n162.info='Текст' 
 join tab_163 n163 on n163.parent_key=n1.key and n163.name='Текст' and n163.key=1000020010975155 and n163.parent_key=1000020010975155 and n163.info='Текст' 
 join tab_164 n164 on n164.parent_key=n1.key and n164.name='Текст' and n164.key=1000020010975155 and n164.parent_key=1000020010975155 and n164.info='Текст' 
 join tab_165 n165 on n165.parent_key=n1.key and n165.name='Текст' and n165.key=1000020010975155 and n165.parent_key=1000020010975155 and n165.info='Текст' 
 join tab_166 n166 on n166.parent_key=n1.key and n166.name='Текст' and n166.key=1000020010975155 and n166.parent_key=1000020010975155 and n166.info='Текст' 
 join tab_167 n167 on n167.parent_key=n1.key and n167.name='Текст' and n167.key=1000020010975155 and n167.parent_key=1000020010975155 and n167.info='Текст' 
 join tab_168 n168 on n168.parent_key=n1.key and n168.name='Текст' and n168.key=1000020010975155 and n168.parent_key=1000020010975155 and n168.info='Текст' 
 join tab_169 n169 on n169.parent_key=n1.key and n169.name='Текст' and n169.key=1000020010975155 and n169.parent_key=1000020010975155 and n169.info='Текст' 
 join tab_170 n170 on n170.parent_key=n1.key and n170.name='Текст' and n170.key=1000020010975155 and n170.parent_key=1000020010975155 and n170.info='Текст' 
 join tab_171 n171 on n171.parent_key=n1.key and n171.name='Текст' and n171.key=1000020010975155 and n171.parent_key=1000020010975155 and n171.info='Текст' 
 join tab_172 n172 on n172.parent_key=n1.key and n172.name='Текст' and n172.key=1000020010975155 and n172.parent_key=1000020010975155 and n172.info='Текст' 
 join tab_173 n173 on n173.parent_key=n1.key and n173.name='Текст' and n173.key=1000020010975155 and n173.parent_key=1000020010975155 and n173.info='Текст' 
 join tab_174 n174 on n174.parent_key=n1.key and n174.name='Текст' and n174.key=1000020010975155 and n174.parent_key=1000020010975155 and n174.info='Текст' 
 join tab_175 n175 on n175.parent_key=n1.key and n175.name='Текст' and n175.key=1000020010975155 and n175.parent_key=1000020010975155 and n175.info='Текст' 
 join tab_176 n176 on n176.parent_key=n1.key and n176.name='Текст' and n176.key=1000020010975155 and n176.parent_key=1000020010975155 and n176.info='Текст' 
 join tab_177 n177 on n177.parent_key=n1.key and n177.name='Текст' and n177.key=1000020010975155 and n177.parent_key=1000020010975155 and n177.info='Текст' 
 join tab_178 n178 on n178.parent_key=n1.key and n178.name='Текст' and n178.key=1000020010975155 and n178.parent_key=1000020010975155 and n178.info='Текст' 
 join tab_179 n179 on n179.parent_key=n1.key and n179.name='Текст' and n179.key=1000020010975155 and n179.parent_key=1000020010975155 and n179.info='Текст' 
 join tab_180 n180 on n180.parent_key=n1.key and n180.name='Текст' and n180.key=1000020010975155 and n180.parent_key=1000020010975155 and n180.info='Текст' 
 join tab_181 n181 on n181.parent_key=n1.key and n181.name='Текст' and n181.key=1000020010975155 and n181.parent_key=1000020010975155 and n181.info='Текст' 
 join tab_182 n182 on n182.parent_key=n1.key and n182.name='Текст' and n182.key=1000020010975155 and n182.parent_key=1000020010975155 and n182.info='Текст' 
 join tab_183 n183 on n183.parent_key=n1.key and n183.name='Текст' and n183.key=1000020010975155 and n183.parent_key=1000020010975155 and n183.info='Текст' 
 join tab_184 n184 on n184.parent_key=n1.key and n184.name='Текст' and n184.key=1000020010975155 and n184.parent_key=1000020010975155 and n184.info='Текст' 
 join tab_185 n185 on n185.parent_key=n1.key and n185.name='Текст' and n185.key=1000020010975155 and n185.parent_key=1000020010975155 and n185.info='Текст' 
 join tab_186 n186 on n186.parent_key=n1.key and n186.name='Текст' and n186.key=1000020010975155 and n186.parent_key=1000020010975155 and n186.info='Текст' 
 join tab_187 n187 on n187.parent_key=n1.key and n187.name='Текст' and n187.key=1000020010975155 and n187.parent_key=1000020010975155 and n187.info='Текст' 
 join tab_188 n188 on n188.parent_key=n1.key and n188.name='Текст' and n188.key=1000020010975155 and n188.parent_key=1000020010975155 and n188.info='Текст' 
 join tab_189 n189 on n189.parent_key=n1.key and n189.name='Текст' and n189.key=1000020010975155 and n189.parent_key=1000020010975155 and n189.info='Текст' 
 join tab_190 n190 on n190.parent_key=n1.key and n190.name='Текст' and n190.key=1000020010975155 and n190.parent_key=1000020010975155 and n190.info='Текст' 
 join tab_191 n191 on n191.parent_key=n1.key and n191.name='Текст' and n191.key=1000020010975155 and n191.parent_key=1000020010975155 and n191.info='Текст' 
 join tab_192 n192 on n192.parent_key=n1.key and n192.name='Текст' and n192.key=1000020010975155 and n192.parent_key=1000020010975155 and n192.info='Текст' 
 join tab_193 n193 on n193.parent_key=n1.key and n193.name='Текст' and n193.key=1000020010975155 and n193.parent_key=1000020010975155 and n193.info='Текст' 
 join tab_194 n194 on n194.parent_key=n1.key and n194.name='Текст' and n194.key=1000020010975155 and n194.parent_key=1000020010975155 and n194.info='Текст' 
 join tab_195 n195 on n195.parent_key=n1.key and n195.name='Текст' and n195.key=1000020010975155 and n195.parent_key=1000020010975155 and n195.info='Текст' 
 join tab_196 n196 on n196.parent_key=n1.key and n196.name='Текст' and n196.key=1000020010975155 and n196.parent_key=1000020010975155 and n196.info='Текст' 
 join tab_197 n197 on n197.parent_key=n1.key and n197.name='Текст' and n197.key=1000020010975155 and n197.parent_key=1000020010975155 and n197.info='Текст' 
 join tab_198 n198 on n198.parent_key=n1.key and n198.name='Текст' and n198.key=1000020010975155 and n198.parent_key=1000020010975155 and n198.info='Текст' 
 join tab_199 n199 on n199.parent_key=n1.key and n199.name='Текст' and n199.key=1000020010975155 and n199.parent_key=1000020010975155 and n199.info='Текст' 
 join tab_200 n200 on n200.parent_key=n1.key and n200.name='Текст' and n200.key=1000020010975155 and n200.parent_key=1000020010975155 and n200.info='Текст' 
 join tab_201 n201 on n201.parent_key=n1.key and n201.name='Текст' and n201.key=1000020010975155 and n201.parent_key=1000020010975155 and n201.info='Текст' 
 join tab_202 n202 on n202.parent_key=n1.key and n202.name='Текст' and n202.key=1000020010975155 and n202.parent_key=1000020010975155 and n202.info='Текст' 
 join tab_203 n203 on n203.parent_key=n1.key and n203.name='Текст' and n203.key=1000020010975155 and n203.parent_key=1000020010975155 and n203.info='Текст' 
 join tab_204 n204 on n204.parent_key=n1.key and n204.name='Текст' and n204.key=1000020010975155 and n204.parent_key=1000020010975155 and n204.info='Текст' 
 join tab_205 n205 on n205.parent_key=n1.key and n205.name='Текст' and n205.key=1000020010975155 and n205.parent_key=1000020010975155 and n205.info='Текст' 
 join tab_206 n206 on n206.parent_key=n1.key and n206.name='Текст' and n206.key=1000020010975155 and n206.parent_key=1000020010975155 and n206.info='Текст' 
 join tab_207 n207 on n207.parent_key=n1.key and n207.name='Текст' and n207.key=1000020010975155 and n207.parent_key=1000020010975155 and n207.info='Текст' 
 join tab_208 n208 on n208.parent_key=n1.key and n208.name='Текст' and n208.key=1000020010975155 and n208.parent_key=1000020010975155 and n208.info='Текст' 
 join tab_209 n209 on n209.parent_key=n1.key and n209.name='Текст' and n209.key=1000020010975155 and n209.parent_key=1000020010975155 and n209.info='Текст' 
 join tab_210 n210 on n210.parent_key=n1.key and n210.name='Текст' and n210.key=1000020010975155 and n210.parent_key=1000020010975155 and n210.info='Текст' 
 join tab_211 n211 on n211.parent_key=n1.key and n211.name='Текст' and n211.key=1000020010975155 and n211.parent_key=1000020010975155 and n211.info='Текст' 
 join tab_212 n212 on n212.parent_key=n1.key and n212.name='Текст' and n212.key=1000020010975155 and n212.parent_key=1000020010975155 and n212.info='Текст' 
 join tab_213 n213 on n213.parent_key=n1.key and n213.name='Текст' and n213.key=1000020010975155 and n213.parent_key=1000020010975155 and n213.info='Текст' 
 join tab_214 n214 on n214.parent_key=n1.key and n214.name='Текст' and n214.key=1000020010975155 and n214.parent_key=1000020010975155 and n214.info='Текст' 
 join tab_215 n215 on n215.parent_key=n1.key and n215.name='Текст' and n215.key=1000020010975155 and n215.parent_key=1000020010975155 and n215.info='Текст' 
 join tab_216 n216 on n216.parent_key=n1.key and n216.name='Текст' and n216.key=1000020010975155 and n216.parent_key=1000020010975155 and n216.info='Текст' 
 join tab_217 n217 on n217.parent_key=n1.key and n217.name='Текст' and n217.key=1000020010975155 and n217.parent_key=1000020010975155 and n217.info='Текст' 
 join tab_218 n218 on n218.parent_key=n1.key and n218.name='Текст' and n218.key=1000020010975155 and n218.parent_key=1000020010975155 and n218.info='Текст' 
 join tab_219 n219 on n219.parent_key=n1.key and n219.name='Текст' and n219.key=1000020010975155 and n219.parent_key=1000020010975155 and n219.info='Текст' 
 join tab_220 n220 on n220.parent_key=n1.key and n220.name='Текст' and n220.key=1000020010975155 and n220.parent_key=1000020010975155 and n220.info='Текст' 
 join tab_221 n221 on n221.parent_key=n1.key and n221.name='Текст' and n221.key=1000020010975155 and n221.parent_key=1000020010975155 and n221.info='Текст' 
 join tab_222 n222 on n222.parent_key=n1.key and n222.name='Текст' and n222.key=1000020010975155 and n222.parent_key=1000020010975155 and n222.info='Текст' 
 join tab_223 n223 on n223.parent_key=n1.key and n223.name='Текст' and n223.key=1000020010975155 and n223.parent_key=1000020010975155 and n223.info='Текст' 
 join tab_224 n224 on n224.parent_key=n1.key and n224.name='Текст' and n224.key=1000020010975155 and n224.parent_key=1000020010975155 and n224.info='Текст' 
 join tab_225 n225 on n225.parent_key=n1.key and n225.name='Текст' and n225.key=1000020010975155 and n225.parent_key=1000020010975155 and n225.info='Текст' 
 join tab_226 n226 on n226.parent_key=n1.key and n226.name='Текст' and n226.key=1000020010975155 and n226.parent_key=1000020010975155 and n226.info='Текст' 
 join tab_227 n227 on n227.parent_key=n1.key and n227.name='Текст' and n227.key=1000020010975155 and n227.parent_key=1000020010975155 and n227.info='Текст' 
 join tab_228 n228 on n228.parent_key=n1.key and n228.name='Текст' and n228.key=1000020010975155 and n228.parent_key=1000020010975155 and n228.info='Текст' 
 join tab_229 n229 on n229.parent_key=n1.key and n229.name='Текст' and n229.key=1000020010975155 and n229.parent_key=1000020010975155 and n229.info='Текст' 
 join tab_230 n230 on n230.parent_key=n1.key and n230.name='Текст' and n230.key=1000020010975155 and n230.parent_key=1000020010975155 and n230.info='Текст' 
 join tab_231 n231 on n231.parent_key=n1.key and n231.name='Текст' and n231.key=1000020010975155 and n231.parent_key=1000020010975155 and n231.info='Текст' 
 join tab_232 n232 on n232.parent_key=n1.key and n232.name='Текст' and n232.key=1000020010975155 and n232.parent_key=1000020010975155 and n232.info='Текст' 
 join tab_233 n233 on n233.parent_key=n1.key and n233.name='Текст' and n233.key=1000020010975155 and n233.parent_key=1000020010975155 and n233.info='Текст' 
 join tab_234 n234 on n234.parent_key=n1.key and n234.name='Текст' and n234.key=1000020010975155 and n234.parent_key=1000020010975155 and n234.info='Текст' 
 join tab_235 n235 on n235.parent_key=n1.key and n235.name='Текст' and n235.key=1000020010975155 and n235.parent_key=1000020010975155 and n235.info='Текст' 
 join tab_236 n236 on n236.parent_key=n1.key and n236.name='Текст' and n236.key=1000020010975155 and n236.parent_key=1000020010975155 and n236.info='Текст' 
 join tab_237 n237 on n237.parent_key=n1.key and n237.name='Текст' and n237.key=1000020010975155 and n237.parent_key=1000020010975155 and n237.info='Текст' 
 join tab_238 n238 on n238.parent_key=n1.key and n238.name='Текст' and n238.key=1000020010975155 and n238.parent_key=1000020010975155 and n238.info='Текст' 
 join tab_239 n239 on n239.parent_key=n1.key and n239.name='Текст' and n239.key=1000020010975155 and n239.parent_key=1000020010975155 and n239.info='Текст' 
 join tab_240 n240 on n240.parent_key=n1.key and n240.name='Текст' and n240.key=1000020010975155 and n240.parent_key=1000020010975155 and n240.info='Текст' 
 join tab_241 n241 on n241.parent_key=n1.key and n241.name='Текст' and n241.key=1000020010975155 and n241.parent_key=1000020010975155 and n241.info='Текст' 
 join tab_242 n242 on n242.parent_key=n1.key and n242.name='Текст' and n242.key=1000020010975155 and n242.parent_key=1000020010975155 and n242.info='Текст' 
 join tab_243 n243 on n243.parent_key=n1.key and n243.name='Текст' and n243.key=1000020010975155 and n243.parent_key=1000020010975155 and n243.info='Текст' 
 join tab_244 n244 on n244.parent_key=n1.key and n244.name='Текст' and n244.key=1000020010975155 and n244.parent_key=1000020010975155 and n244.info='Текст' 
 join tab_245 n245 on n245.parent_key=n1.key and n245.name='Текст' and n245.key=1000020010975155 and n245.parent_key=1000020010975155 and n245.info='Текст' 
 join tab_246 n246 on n246.parent_key=n1.key and n246.name='Текст' and n246.key=1000020010975155 and n246.parent_key=1000020010975155 and n246.info='Текст' 
 join tab_247 n247 on n247.parent_key=n1.key and n247.name='Текст' and n247.key=1000020010975155 and n247.parent_key=1000020010975155 and n247.info='Текст' 
 join tab_248 n248 on n248.parent_key=n1.key and n248.name='Текст' and n248.key=1000020010975155 and n248.parent_key=1000020010975155 and n248.info='Текст' 
 join tab_249 n249 on n249.parent_key=n1.key and n249.name='Текст' and n249.key=1000020010975155 and n249.parent_key=1000020010975155 and n249.info='Текст' 
 join tab_250 n250 on n250.parent_key=n1.key and n250.name='Текст' and n250.key=1000020010975155 and n250.parent_key=1000020010975155 and n250.info='Текст' 
 join tab_251 n251 on n251.parent_key=n1.key and n251.name='Текст' and n251.key=1000020010975155 and n251.parent_key=1000020010975155 and n251.info='Текст' 
 join tab_252 n252 on n252.parent_key=n1.key and n252.name='Текст' and n252.key=1000020010975155 and n252.parent_key=1000020010975155 and n252.info='Текст' 
 join tab_253 n253 on n253.parent_key=n1.key and n253.name='Текст' and n253.key=1000020010975155 and n253.parent_key=1000020010975155 and n253.info='Текст' 
 join tab_254 n254 on n254.parent_key=n1.key and n254.name='Текст' and n254.key=1000020010975155 and n254.parent_key=1000020010975155 and n254.info='Текст' 
 join tab_255 n255 on n255.parent_key=n1.key and n255.name='Текст' and n255.key=1000020010975155 and n255.parent_key=1000020010975155 and n255.info='Текст' 
 join tab_256 n256 on n256.parent_key=n1.key and n256.name='Текст' and n256.key=1000020010975155 and n256.parent_key=1000020010975155 and n256.info='Текст' 
 join tab_257 n257 on n257.parent_key=n1.key and n257.name='Текст' and n257.key=1000020010975155 and n257.parent_key=1000020010975155 and n257.info='Текст' 
 join tab_258 n258 on n258.parent_key=n1.key and n258.name='Текст' and n258.key=1000020010975155 and n258.parent_key=1000020010975155 and n258.info='Текст' 
 join tab_259 n259 on n259.parent_key=n1.key and n259.name='Текст' and n259.key=1000020010975155 and n259.parent_key=1000020010975155 and n259.info='Текст' 
 join tab_260 n260 on n260.parent_key=n1.key and n260.name='Текст' and n260.key=1000020010975155 and n260.parent_key=1000020010975155 and n260.info='Текст' 
 join tab_261 n261 on n261.parent_key=n1.key and n261.name='Текст' and n261.key=1000020010975155 and n261.parent_key=1000020010975155 and n261.info='Текст' 
 join tab_262 n262 on n262.parent_key=n1.key and n262.name='Текст' and n262.key=1000020010975155 and n262.parent_key=1000020010975155 and n262.info='Текст' 
 join tab_263 n263 on n263.parent_key=n1.key and n263.name='Текст' and n263.key=1000020010975155 and n263.parent_key=1000020010975155 and n263.info='Текст' 
 join tab_264 n264 on n264.parent_key=n1.key and n264.name='Текст' and n264.key=1000020010975155 and n264.parent_key=1000020010975155 and n264.info='Текст' 
 join tab_265 n265 on n265.parent_key=n1.key and n265.name='Текст' and n265.key=1000020010975155 and n265.parent_key=1000020010975155 and n265.info='Текст' 
 join tab_266 n266 on n266.parent_key=n1.key and n266.name='Текст' and n266.key=1000020010975155 and n266.parent_key=1000020010975155 and n266.info='Текст' 
 join tab_267 n267 on n267.parent_key=n1.key and n267.name='Текст' and n267.key=1000020010975155 and n267.parent_key=1000020010975155 and n267.info='Текст' 
 join tab_268 n268 on n268.parent_key=n1.key and n268.name='Текст' and n268.key=1000020010975155 and n268.parent_key=1000020010975155 and n268.info='Текст' 
 join tab_269 n269 on n269.parent_key=n1.key and n269.name='Текст' and n269.key=1000020010975155 and n269.parent_key=1000020010975155 and n269.info='Текст' 
 join tab_270 n270 on n270.parent_key=n1.key and n270.name='Текст' and n270.key=1000020010975155 and n270.parent_key=1000020010975155 and n270.info='Текст' 
 join tab_271 n271 on n271.parent_key=n1.key and n271.name='Текст' and n271.key=1000020010975155 and n271.parent_key=1000020010975155 and n271.info='Текст' 
 join tab_272 n272 on n272.parent_key=n1.key and n272.name='Текст' and n272.key=1000020010975155 and n272.parent_key=1000020010975155 and n272.info='Текст' 
 join tab_273 n273 on n273.parent_key=n1.key and n273.name='Текст' and n273.key=1000020010975155 and n273.parent_key=1000020010975155 and n273.info='Текст' 
 join tab_274 n274 on n274.parent_key=n1.key and n274.name='Текст' and n274.key=1000020010975155 and n274.parent_key=1000020010975155 and n274.info='Текст' 
 join tab_275 n275 on n275.parent_key=n1.key and n275.name='Текст' and n275.key=1000020010975155 and n275.parent_key=1000020010975155 and n275.info='Текст' 
 join tab_276 n276 on n276.parent_key=n1.key and n276.name='Текст' and n276.key=1000020010975155 and n276.parent_key=1000020010975155 and n276.info='Текст' 
 join tab_277 n277 on n277.parent_key=n1.key and n277.name='Текст' and n277.key=1000020010975155 and n277.parent_key=1000020010975155 and n277.info='Текст' 
 join tab_278 n278 on n278.parent_key=n1.key and n278.name='Текст' and n278.key=1000020010975155 and n278.parent_key=1000020010975155 and n278.info='Текст' 
 join tab_279 n279 on n279.parent_key=n1.key and n279.name='Текст' and n279.key=1000020010975155 and n279.parent_key=1000020010975155 and n279.info='Текст' 
 join tab_280 n280 on n280.parent_key=n1.key and n280.name='Текст' and n280.key=1000020010975155 and n280.parent_key=1000020010975155 and n280.info='Текст' 
 join tab_281 n281 on n281.parent_key=n1.key and n281.name='Текст' and n281.key=1000020010975155 and n281.parent_key=1000020010975155 and n281.info='Текст' 
 join tab_282 n282 on n282.parent_key=n1.key and n282.name='Текст' and n282.key=1000020010975155 and n282.parent_key=1000020010975155 and n282.info='Текст' 
 join tab_283 n283 on n283.parent_key=n1.key and n283.name='Текст' and n283.key=1000020010975155 and n283.parent_key=1000020010975155 and n283.info='Текст' 
 join tab_284 n284 on n284.parent_key=n1.key and n284.name='Текст' and n284.key=1000020010975155 and n284.parent_key=1000020010975155 and n284.info='Текст' 
 join tab_285 n285 on n285.parent_key=n1.key and n285.name='Текст' and n285.key=1000020010975155 and n285.parent_key=1000020010975155 and n285.info='Текст' 
 join tab_286 n286 on n286.parent_key=n1.key and n286.name='Текст' and n286.key=1000020010975155 and n286.parent_key=1000020010975155 and n286.info='Текст' 
 join tab_287 n287 on n287.parent_key=n1.key and n287.name='Текст' and n287.key=1000020010975155 and n287.parent_key=1000020010975155 and n287.info='Текст' 
 join tab_288 n288 on n288.parent_key=n1.key and n288.name='Текст' and n288.key=1000020010975155 and n288.parent_key=1000020010975155 and n288.info='Текст' 
 join tab_289 n289 on n289.parent_key=n1.key and n289.name='Текст' and n289.key=1000020010975155 and n289.parent_key=1000020010975155 and n289.info='Текст' 
 join tab_290 n290 on n290.parent_key=n1.key and n290.name='Текст' and n290.key=1000020010975155 and n290.parent_key=1000020010975155 and n290.info='Текст' 
 join tab_291 n291 on n291.parent_key=n1.key and n291.name='Текст' and n291.key=1000020010975155 and n291.parent_key=1000020010975155 and n291.info='Текст' 
 join tab_292 n292 on n292.parent_key=n1.key and n292.name='Текст' and n292.key=1000020010975155 and n292.parent_key=1000020010975155 and n292.info='Текст' 
 join tab_293 n293 on n293.parent_key=n1.key and n293.name='Текст' and n293.key=1000020010975155 and n293.parent_key=1000020010975155 and n293.info='Текст' 
 join tab_294 n294 on n294.parent_key=n1.key and n294.name='Текст' and n294.key=1000020010975155 and n294.parent_key=1000020010975155 and n294.info='Текст' 
 join tab_295 n295 on n295.parent_key=n1.key and n295.name='Текст' and n295.key=1000020010975155 and n295.parent_key=1000020010975155 and n295.info='Текст' 
 join tab_296 n296 on n296.parent_key=n1.key and n296.name='Текст' and n296.key=1000020010975155 and n296.parent_key=1000020010975155 and n296.info='Текст' 
 join tab_297 n297 on n297.parent_key=n1.key and n297.name='Текст' and n297.key=1000020010975155 and n297.parent_key=1000020010975155 and n297.info='Текст' 
 join tab_298 n298 on n298.parent_key=n1.key and n298.name='Текст' and n298.key=1000020010975155 and n298.parent_key=1000020010975155 and n298.info='Текст' 
 join tab_299 n299 on n299.parent_key=n1.key and n299.name='Текст' and n299.key=1000020010975155 and n299.parent_key=1000020010975155 and n299.info='Текст' 
 join tab_300 n300 on n300.parent_key=n1.key and n300.name='Текст' and n300.key=1000020010975155 and n300.parent_key=1000020010975155 and n300.info='Текст' 
 join tab_301 n301 on n301.parent_key=n1.key and n301.name='Текст' and n301.key=1000020010975155 and n301.parent_key=1000020010975155 and n301.info='Текст' 
 join tab_302 n302 on n302.parent_key=n1.key and n302.name='Текст' and n302.key=1000020010975155 and n302.parent_key=1000020010975155 and n302.info='Текст' 
 join tab_303 n303 on n303.parent_key=n1.key and n303.name='Текст' and n303.key=1000020010975155 and n303.parent_key=1000020010975155 and n303.info='Текст' 
 join tab_304 n304 on n304.parent_key=n1.key and n304.name='Текст' and n304.key=1000020010975155 and n304.parent_key=1000020010975155 and n304.info='Текст' 
 join tab_305 n305 on n305.parent_key=n1.key and n305.name='Текст' and n305.key=1000020010975155 and n305.parent_key=1000020010975155 and n305.info='Текст' 
 join tab_306 n306 on n306.parent_key=n1.key and n306.name='Текст' and n306.key=1000020010975155 and n306.parent_key=1000020010975155 and n306.info='Текст' 
 join tab_307 n307 on n307.parent_key=n1.key and n307.name='Текст' and n307.key=1000020010975155 and n307.parent_key=1000020010975155 and n307.info='Текст' 
 join tab_308 n308 on n308.parent_key=n1.key and n308.name='Текст' and n308.key=1000020010975155 and n308.parent_key=1000020010975155 and n308.info='Текст' 
 join tab_309 n309 on n309.parent_key=n1.key and n309.name='Текст' and n309.key=1000020010975155 and n309.parent_key=1000020010975155 and n309.info='Текст' 
 join tab_310 n310 on n310.parent_key=n1.key and n310.name='Текст' and n310.key=1000020010975155 and n310.parent_key=1000020010975155 and n310.info='Текст' 
 join tab_311 n311 on n311.parent_key=n1.key and n311.name='Текст' and n311.key=1000020010975155 and n311.parent_key=1000020010975155 and n311.info='Текст' 
 join tab_312 n312 on n312.parent_key=n1.key and n312.name='Текст' and n312.key=1000020010975155 and n312.parent_key=1000020010975155 and n312.info='Текст' 
 join tab_313 n313 on n313.parent_key=n1.key and n313.name='Текст' and n313.key=1000020010975155 and n313.parent_key=1000020010975155 and n313.info='Текст' 
 join tab_314 n314 on n314.parent_key=n1.key and n314.name='Текст' and n314.key=1000020010975155 and n314.parent_key=1000020010975155 and n314.info='Текст' 
 join tab_315 n315 on n315.parent_key=n1.key and n315.name='Текст' and n315.key=1000020010975155 and n315.parent_key=1000020010975155 and n315.info='Текст' 
 join tab_316 n316 on n316.parent_key=n1.key and n316.name='Текст' and n316.key=1000020010975155 and n316.parent_key=1000020010975155 and n316.info='Текст' 
 join tab_317 n317 on n317.parent_key=n1.key and n317.name='Текст' and n317.key=1000020010975155 and n317.parent_key=1000020010975155 and n317.info='Текст' 
 join tab_318 n318 on n318.parent_key=n1.key and n318.name='Текст' and n318.key=1000020010975155 and n318.parent_key=1000020010975155 and n318.info='Текст' 
 join tab_319 n319 on n319.parent_key=n1.key and n319.name='Текст' and n319.key=1000020010975155 and n319.parent_key=1000020010975155 and n319.info='Текст' 
 join tab_320 n320 on n320.parent_key=n1.key and n320.name='Текст' and n320.key=1000020010975155 and n320.parent_key=1000020010975155 and n320.info='Текст' 
 join tab_321 n321 on n321.parent_key=n1.key and n321.name='Текст' and n321.key=1000020010975155 and n321.parent_key=1000020010975155 and n321.info='Текст' 
 join tab_322 n322 on n322.parent_key=n1.key and n322.name='Текст' and n322.key=1000020010975155 and n322.parent_key=1000020010975155 and n322.info='Текст' 
 join tab_323 n323 on n323.parent_key=n1.key and n323.name='Текст' and n323.key=1000020010975155 and n323.parent_key=1000020010975155 and n323.info='Текст' 
 join tab_324 n324 on n324.parent_key=n1.key and n324.name='Текст' and n324.key=1000020010975155 and n324.parent_key=1000020010975155 and n324.info='Текст' 
 join tab_325 n325 on n325.parent_key=n1.key and n325.name='Текст' and n325.key=1000020010975155 and n325.parent_key=1000020010975155 and n325.info='Текст' 
 join tab_326 n326 on n326.parent_key=n1.key and n326.name='Текст' and n326.key=1000020010975155 and n326.parent_key=1000020010975155 and n326.info='Текст' 
 join tab_327 n327 on n327.parent_key=n1.key and n327.name='Текст' and n327.key=1000020010975155 and n327.parent_key=1000020010975155 and n327.info='Текст' 
 join tab_328 n328 on n328.parent_key=n1.key and n328.name='Текст' and n328.key=1000020010975155 and n328.parent_key=1000020010975155 and n328.info='Текст' 
 join tab_329 n329 on n329.parent_key=n1.key and n329.name='Текст' and n329.key=1000020010975155 and n329.parent_key=1000020010975155 and n329.info='Текст' 
 join tab_330 n330 on n330.parent_key=n1.key and n330.name='Текст' and n330.key=1000020010975155 and n330.parent_key=1000020010975155 and n330.info='Текст' 
 join tab_331 n331 on n331.parent_key=n1.key and n331.name='Текст' and n331.key=1000020010975155 and n331.parent_key=1000020010975155 and n331.info='Текст' 
 join tab_332 n332 on n332.parent_key=n1.key and n332.name='Текст' and n332.key=1000020010975155 and n332.parent_key=1000020010975155 and n332.info='Текст' 
 join tab_333 n333 on n333.parent_key=n1.key and n333.name='Текст' and n333.key=1000020010975155 and n333.parent_key=1000020010975155 and n333.info='Текст' 
 join tab_334 n334 on n334.parent_key=n1.key and n334.name='Текст' and n334.key=1000020010975155 and n334.parent_key=1000020010975155 and n334.info='Текст' 
 join tab_335 n335 on n335.parent_key=n1.key and n335.name='Текст' and n335.key=1000020010975155 and n335.parent_key=1000020010975155 and n335.info='Текст' 
 join tab_336 n336 on n336.parent_key=n1.key and n336.name='Текст' and n336.key=1000020010975155 and n336.parent_key=1000020010975155 and n336.info='Текст' 
 join tab_337 n337 on n337.parent_key=n1.key and n337.name='Текст' and n337.key=1000020010975155 and n337.parent_key=1000020010975155 and n337.info='Текст' 
 join tab_338 n338 on n338.parent_key=n1.key and n338.name='Текст' and n338.key=1000020010975155 and n338.parent_key=1000020010975155 and n338.info='Текст' 
 join tab_339 n339 on n339.parent_key=n1.key and n339.name='Текст' and n339.key=1000020010975155 and n339.parent_key=1000020010975155 and n339.info='Текст' 
 join tab_340 n340 on n340.parent_key=n1.key and n340.name='Текст' and n340.key=1000020010975155 and n340.parent_key=1000020010975155 and n340.info='Текст' 
 join tab_341 n341 on n341.parent_key=n1.key and n341.name='Текст' and n341.key=1000020010975155 and n341.parent_key=1000020010975155 and n341.info='Текст' 
 join tab_342 n342 on n342.parent_key=n1.key and n342.name='Текст' and n342.key=1000020010975155 and n342.parent_key=1000020010975155 and n342.info='Текст' 
 join tab_343 n343 on n343.parent_key=n1.key and n343.name='Текст' and n343.key=1000020010975155 and n343.parent_key=1000020010975155 and n343.info='Текст' 
 join tab_344 n344 on n344.parent_key=n1.key and n344.name='Текст' and n344.key=1000020010975155 and n344.parent_key=1000020010975155 and n344.info='Текст' 
 join tab_345 n345 on n345.parent_key=n1.key and n345.name='Текст' and n345.key=1000020010975155 and n345.parent_key=1000020010975155 and n345.info='Текст' 
 join tab_346 n346 on n346.parent_key=n1.key and n346.name='Текст' and n346.key=1000020010975155 and n346.parent_key=1000020010975155 and n346.info='Текст' 
 join tab_347 n347 on n347.parent_key=n1.key and n347.name='Текст' and n347.key=1000020010975155 and n347.parent_key=1000020010975155 and n347.info='Текст' 
 join tab_348 n348 on n348.parent_key=n1.key and n348.name='Текст' and n348.key=1000020010975155 and n348.parent_key=1000020010975155 and n348.info='Текст' 
 join tab_349 n349 on n349.parent_key=n1.key and n349.name='Текст' and n349.key=1000020010975155 and n349.parent_key=1000020010975155 and n349.info='Текст' 
 join tab_350 n350 on n350.parent_key=n1.key and n350.name='Текст' and n350.key=1000020010975155 and n350.parent_key=1000020010975155 and n350.info='Текст' 
 join tab_351 n351 on n351.parent_key=n1.key and n351.name='Текст' and n351.key=1000020010975155 and n351.parent_key=1000020010975155 and n351.info='Текст' 
 join tab_352 n352 on n352.parent_key=n1.key and n352.name='Текст' and n352.key=1000020010975155 and n352.parent_key=1000020010975155 and n352.info='Текст' 
 join tab_353 n353 on n353.parent_key=n1.key and n353.name='Текст' and n353.key=1000020010975155 and n353.parent_key=1000020010975155 and n353.info='Текст' 
 join tab_354 n354 on n354.parent_key=n1.key and n354.name='Текст' and n354.key=1000020010975155 and n354.parent_key=1000020010975155 and n354.info='Текст' 
 join tab_355 n355 on n355.parent_key=n1.key and n355.name='Текст' and n355.key=1000020010975155 and n355.parent_key=1000020010975155 and n355.info='Текст' 
 join tab_356 n356 on n356.parent_key=n1.key and n356.name='Текст' and n356.key=1000020010975155 and n356.parent_key=1000020010975155 and n356.info='Текст' 
 join tab_357 n357 on n357.parent_key=n1.key and n357.name='Текст' and n357.key=1000020010975155 and n357.parent_key=1000020010975155 and n357.info='Текст' 
 join tab_358 n358 on n358.parent_key=n1.key and n358.name='Текст' and n358.key=1000020010975155 and n358.parent_key=1000020010975155 and n358.info='Текст' 
 join tab_359 n359 on n359.parent_key=n1.key and n359.name='Текст' and n359.key=1000020010975155 and n359.parent_key=1000020010975155 and n359.info='Текст' 
 join tab_360 n360 on n360.parent_key=n1.key and n360.name='Текст' and n360.key=1000020010975155 and n360.parent_key=1000020010975155 and n360.info='Текст' 
 join tab_361 n361 on n361.parent_key=n1.key and n361.name='Текст' and n361.key=1000020010975155 and n361.parent_key=1000020010975155 and n361.info='Текст' 
 join tab_362 n362 on n362.parent_key=n1.key and n362.name='Текст' and n362.key=1000020010975155 and n362.parent_key=1000020010975155 and n362.info='Текст' 
 join tab_363 n363 on n363.parent_key=n1.key and n363.name='Текст' and n363.key=1000020010975155 and n363.parent_key=1000020010975155 and n363.info='Текст' 
 join tab_364 n364 on n364.parent_key=n1.key and n364.name='Текст' and n364.key=1000020010975155 and n364.parent_key=1000020010975155 and n364.info='Текст' 
 join tab_365 n365 on n365.parent_key=n1.key and n365.name='Текст' and n365.key=1000020010975155 and n365.parent_key=1000020010975155 and n365.info='Текст' 
 join tab_366 n366 on n366.parent_key=n1.key and n366.name='Текст' and n366.key=1000020010975155 and n366.parent_key=1000020010975155 and n366.info='Текст' 
 join tab_367 n367 on n367.parent_key=n1.key and n367.name='Текст' and n367.key=1000020010975155 and n367.parent_key=1000020010975155 and n367.info='Текст' 
 join tab_368 n368 on n368.parent_key=n1.key and n368.name='Текст' and n368.key=1000020010975155 and n368.parent_key=1000020010975155 and n368.info='Текст' 
 join tab_369 n369 on n369.parent_key=n1.key and n369.name='Текст' and n369.key=1000020010975155 and n369.parent_key=1000020010975155 and n369.info='Текст' 
 join tab_370 n370 on n370.parent_key=n1.key and n370.name='Текст' and n370.key=1000020010975155 and n370.parent_key=1000020010975155 and n370.info='Текст' 
 join tab_371 n371 on n371.parent_key=n1.key and n371.name='Текст' and n371.key=1000020010975155 and n371.parent_key=1000020010975155 and n371.info='Текст' 
 join tab_372 n372 on n372.parent_key=n1.key and n372.name='Текст' and n372.key=1000020010975155 and n372.parent_key=1000020010975155 and n372.info='Текст' 
 join tab_373 n373 on n373.parent_key=n1.key and n373.name='Текст' and n373.key=1000020010975155 and n373.parent_key=1000020010975155 and n373.info='Текст' 
 join tab_374 n374 on n374.parent_key=n1.key and n374.name='Текст' and n374.key=1000020010975155 and n374.parent_key=1000020010975155 and n374.info='Текст' 
 join tab_375 n375 on n375.parent_key=n1.key and n375.name='Текст' and n375.key=1000020010975155 and n375.parent_key=1000020010975155 and n375.info='Текст' 
 join tab_376 n376 on n376.parent_key=n1.key and n376.name='Текст' and n376.key=1000020010975155 and n376.parent_key=1000020010975155 and n376.info='Текст' 
 join tab_377 n377 on n377.parent_key=n1.key and n377.name='Текст' and n377.key=1000020010975155 and n377.parent_key=1000020010975155 and n377.info='Текст' 
 join tab_378 n378 on n378.parent_key=n1.key and n378.name='Текст' and n378.key=1000020010975155 and n378.parent_key=1000020010975155 and n378.info='Текст' 
 join tab_379 n379 on n379.parent_key=n1.key and n379.name='Текст' and n379.key=1000020010975155 and n379.parent_key=1000020010975155 and n379.info='Текст' 
 join tab_380 n380 on n380.parent_key=n1.key and n380.name='Текст' and n380.key=1000020010975155 and n380.parent_key=1000020010975155 and n380.info='Текст' 
 join tab_381 n381 on n381.parent_key=n1.key and n381.name='Текст' and n381.key=1000020010975155 and n381.parent_key=1000020010975155 and n381.info='Текст' 
 join tab_382 n382 on n382.parent_key=n1.key and n382.name='Текст' and n382.key=1000020010975155 and n382.parent_key=1000020010975155 and n382.info='Текст' 
 join tab_383 n383 on n383.parent_key=n1.key and n383.name='Текст' and n383.key=1000020010975155 and n383.parent_key=1000020010975155 and n383.info='Текст' 
 join tab_384 n384 on n384.parent_key=n1.key and n384.name='Текст' and n384.key=1000020010975155 and n384.parent_key=1000020010975155 and n384.info='Текст' 
 join tab_385 n385 on n385.parent_key=n1.key and n385.name='Текст' and n385.key=1000020010975155 and n385.parent_key=1000020010975155 and n385.info='Текст' 
 join tab_386 n386 on n386.parent_key=n1.key and n386.name='Текст' and n386.key=1000020010975155 and n386.parent_key=1000020010975155 and n386.info='Текст' 
 join tab_387 n387 on n387.parent_key=n1.key and n387.name='Текст' and n387.key=1000020010975155 and n387.parent_key=1000020010975155 and n387.info='Текст' 
 join tab_388 n388 on n388.parent_key=n1.key and n388.name='Текст' and n388.key=1000020010975155 and n388.parent_key=1000020010975155 and n388.info='Текст' 
 join tab_389 n389 on n389.parent_key=n1.key and n389.name='Текст' and n389.key=1000020010975155 and n389.parent_key=1000020010975155 and n389.info='Текст' 
 join tab_390 n390 on n390.parent_key=n1.key and n390.name='Текст' and n390.key=1000020010975155 and n390.parent_key=1000020010975155 and n390.info='Текст' 
 join tab_391 n391 on n391.parent_key=n1.key and n391.name='Текст' and n391.key=1000020010975155 and n391.parent_key=1000020010975155 and n391.info='Текст' 
 join tab_392 n392 on n392.parent_key=n1.key and n392.name='Текст' and n392.key=1000020010975155 and n392.parent_key=1000020010975155 and n392.info='Текст' 
 join tab_393 n393 on n393.parent_key=n1.key and n393.name='Текст' and n393.key=1000020010975155 and n393.parent_key=1000020010975155 and n393.info='Текст' 
 join tab_394 n394 on n394.parent_key=n1.key and n394.name='Текст' and n394.key=1000020010975155 and n394.parent_key=1000020010975155 and n394.info='Текст' 
 join tab_395 n395 on n395.parent_key=n1.key and n395.name='Текст' and n395.key=1000020010975155 and n395.parent_key=1000020010975155 and n395.info='Текст' 
 join tab_396 n396 on n396.parent_key=n1.key and n396.name='Текст' and n396.key=1000020010975155 and n396.parent_key=1000020010975155 and n396.info='Текст' 
 join tab_397 n397 on n397.parent_key=n1.key and n397.name='Текст' and n397.key=1000020010975155 and n397.parent_key=1000020010975155 and n397.info='Текст' 
 join tab_398 n398 on n398.parent_key=n1.key and n398.name='Текст' and n398.key=1000020010975155 and n398.parent_key=1000020010975155 and n398.info='Текст' 
 join tab_399 n399 on n399.parent_key=n1.key and n399.name='Текст' and n399.key=1000020010975155 and n399.parent_key=1000020010975155 and n399.info='Текст' 
 join tab_400 n400 on n400.parent_key=n1.key and n400.name='Текст' and n400.key=1000020010975155 and n400.parent_key=1000020010975155 and n400.info='Текст'

но ошибки не возникает.
Пожалуйста поясните про эту ошибку. Какие критерии ее возникновения?

...

Рейтинг:

0 / 0

28.08.2018, 07:47

| Ответить | Цитировать | Написать

Ошибка. Число столбцов в соединениях ограничено 32767

#39694117

Alexius

Участник

Сообщения: 749

Рейтинг: 0 / 0

Visermoz,

Код: plaintext

1.
2.
3.
4.
5.
6.
7.
8.
9.

/*
 * Fail if join has too many columns --- we must be able to reference any
 * of the columns with an AttrNumber.
 */
if (list_length(aliasvars) > MaxAttrNumber)
	ereport(ERROR,
			(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
			 errmsg("joins can have at most %d columns",
					MaxAttrNumber)));

https://github.com/postgres/postgres/blob/322548a8abe225f2cfd6a48e07b99e2711d28ef7/src/backend/parser/parse_relation.c#L1813

я так понял ограничено суммарное число полей со всех таблиц из join (даже если они не выбираются все селектом, максимальное число выбираемых полей в селекте меньше - 1664).
если вам этого значения не хватает - наверняка делаете что-то не то, делать join больше 10-15 таблиц идея не очень.

так можно воспроизвести:

Код: sql

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.

select 'create table a1 (' || string_agg('c' || id || ' char', ',') || ');' from generate_series(1,1600) gs(id);
\gexec
explain select 1 from a1
join a1 a2 on a1.c1=a2.c1
join a1 a3 on a1.c1=a3.c1
join a1 a4 on a1.c1=a4.c1
join a1 a5 on a1.c1=a5.c1
join a1 a6 on a1.c1=a6.c1
join a1 a7 on a1.c1=a7.c1
join a1 a8 on a1.c1=a8.c1
join a1 a9 on a1.c1=a9.c1
join a1 a10 on a1.c1=a10.c1
join a1 a11 on a1.c1=a11.c1
join a1 a12 on a1.c1=a12.c1
join a1 a13 on a1.c1=a13.c1
join a1 a14 on a1.c1=a14.c1
join a1 a15 on a1.c1=a15.c1
join a1 a16 on a1.c1=a16.c1
join a1 a17 on a1.c1=a17.c1
join a1 a18 on a1.c1=a18.c1
join a1 a19 on a1.c1=a19.c1
join a1 a20 on a1.c1=a20.c1
join a1 a21 on a1.c1=a21.c1;

с последним join упадет с той ошибкой.

...

Рейтинг:

0 / 0

28.08.2018, 10:13

| Ответить | Цитировать | Написать

Ошибка. Число столбцов в соединениях ограничено 32767

#39694137

Visermoz

Гость

Alexius, большое спасибо за развернутый ответ!

...

Рейтинг:

0 / 0

28.08.2018, 10:48

| Ответить | Цитировать | Написать

Ошибка. Число столбцов в соединениях ограничено 32767

#39700377

bff7755a

Гость

Если в джойнится таблиц больше, чем значение параметра geqo_threshold (по умолчанию - 12), pg будет использовать genetic query optimization. Другими словами, будет подбирать рандомные способы соединения таблиц в надежде на то, что наткнётся на оптимальным способ. А вероятность, что он найдёт такой способ не очень высока. Поэтому джойнить большое количество таблиц идея плохая сама по себе.

https://www.postgresql.org/docs/current/static/runtime-config-query.html#GUC-GEQO-THRESHOLD

...

Рейтинг:

0 / 0

10.09.2018, 13:01

| Ответить | Цитировать | Написать

Ошибка. Число столбцов в соединениях ограничено 32767

#39700703

Visermoz

Гость

bff7755a,
спасибо вам за подсказку. Раньше не обращал внимание на эту настройку совсем. Попробую поиграть с этой настройкой и посмотреть планы.
Согласен, что соединять столько таблиц- очень плохая идея, но такая модель данных досталась и пока приходится её использовать, постепенно упрощая.

...

Рейтинг:

0 / 0

11.09.2018, 06:53

| Ответить | Цитировать | Написать

5 сообщений из 5, страница 1 из 1

Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / Ошибка. Число столбцов в соединениях ограничено 32767

Цитировать

Написать

Автор*:

Ввести пароль для входа

Тема*:

Сообщение

Данное сообщение тематическое

Сообщение содержит картинки или видео 18+

Автор:

ВНИМАНИЕ! На данном подфоруме действуют строгие правила. Удостоверьтесь, что ваше сообщение соответствует им!

Форум или тема закрыты для гостей. Необходима авторизация!

Загрузить последнюю сохраненную версию

Вложение:

Вставить как галерею

Максимальный размер вложений: 4,0 МБ, аудио/видео: 8,0 МБ. Картинки большего размера ужимаются, если возможно.

Введите код, изображенный на картинке. Если код нечитаемый, кликните картинку, чтобы загрузить другой вариант.

Отправляя сообщение, я выражаю свое согласие с правилами форума и принимаю пользовательское соглашение.

Читали тему (0):

Читали форум (0):

Пользователи онлайн (0):

start [/forum/topic.php?fid=53&gotonew=1&tid=1995597]:	0ms
get settings:	11ms
get forum list:	15ms
check forum access:	4ms
check topic access:	4ms
track hit:	33ms
get topic data:	12ms
get first new msg:	7ms
get forum data:	2ms
get page messages:	55ms
get tp. blocked users:	2ms
others:	15ms

total:	160ms