Warning: pg_query_params(): Query failed: FATAL: terminating connection due to administrator command
CONTEXT: SQL statement "create temp table __r_mpn as
select
'mpn' as query,
0 as ta_cnt,
mpn.*,
-- ct.medical_product_name_check_type, -- уже есть в mpn.*
ct.medical_product_name_check_ban_flag::int,
ct.medical_product_name_check_iname,
ct.medical_product_name_check_hint,
case when mpn.medical_product_count = 1 then mp.medical_product_name else '' end as medical_product_name,
-- i_n.international_name_id, -- уже есть в mpn.*
i_n.international_name_name,
i_n.international_name_latin,
i_n.moderation_flag::int,
--case when i_n.moderation_flag::int = 1 or mpn.medical_product_name_id = 2225 then 1 else 0 end as new_template,
0 as new_template,
-- pg.pharmacological_group_id, -- уже есть в mpn.*
pg.pharmacological_group_name,
-- ig2.international_group2_id,
ig2.international_group2_name,
ig2.international_group2_latin,
ig1.internation in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 252
Error information:
Message: FATAL: terminating connection due to administrator command
CONTEXT: SQL statement "create temp table __r_mpn as
select
'mpn' as query,
0 as ta_cnt,
mpn.*,
-- ct.medical_product_name_check_type, -- уже есть в mpn.*
ct.medical_product_name_check_ban_flag::int,
ct.medical_product_name_check_iname,
ct.medical_product_name_check_hint,
case when mpn.medical_product_count = 1 then mp.medical_product_name else '' end as medical_product_name,
-- i_n.international_name_id, -- уже есть в mpn.*
i_n.international_name_name,
i_n.international_name_latin,
i_n.moderation_flag::int,
--case when i_n.moderation_flag::int = 1 or mpn.medical_product_name_id = 2225 then 1 else 0 end as new_template,
0 as new_template,
-- pg.pharmacological_group_id, -- уже есть в mpn.*
pg.pharmacological_group_name,
-- ig2.international_group2_id,
ig2.international_group2_name,
ig2.international_group2_latin,
ig1.international_group_id, -- уже есть в mpn.*
ig1.international_group_name,
ig1.international_group_latin,
ig1.international_group_choose_title,
ig1.international_group_ofIg1,
ig1.international_group_delivery_flag::int,
ig1.igPresenseText as "igPresenseText",
ig1.igMpText as "igMpText",
ig1.igMpTxtOnline as "igMpTxtOnline",
ig1.igMpTextS as "igMpTextS",
ig1.igMpTextOnlineS as "igMpTextOnlineS",
ig1.ig_goods_flag::int,
ig1.igIsFirm as "igIsFirm",
ig1.igHasForm as "igHasForm",
ig1.igFormsText as "igFormsText",
ig1.igMpsText as "igMpsText",
ig1.igMpsTextRod as "igMpsTextRod",
ig1.igDisclaimerText as "igDisclaimerText",
ig1.igFarmBlockShow as "igFarmBlockShow",
d.drugstore_name,
d.drugstore_latin,
d.drugstore_in_1_name,
d.drugstore_in_name,
d.drugstore_online_in_1_name,
d.drugstore_online_in_name,
f.firm_id,
f.firm_latin,
f.firm_name,
a_mpn.delivery_online_cnt,
a_mpn.online_presence_cnt as online_cnt,
price_round(a_mpn.online_price_min) as online_price_min,
a_mpn.online_order_presence_cnt as online_order_cnt,
price_round(a_mpn.online_order_price_min) as online_order_price_min,
a_mpn.order_presence_cnt as order_cnt,
price_round(a_mpn.order_price_min) as order_price_min,
price_round(a_mpn.order_price_max) as order_price_max,
a_mpn.map_presence_cnt as cnt,
a_mpn.map_presence_cnt as map_cnt,
price_round(a_mpn.map_price_min) as price_min,
price_round(a_mpn.map_price_max) as price_max,
price_round(a_mpn.map_price_min) as map_price_min,
price_round(a_mpn.map_price_max) as map_price_max,
__area_online_first as area_online_first,
-- блок дозировок
mp_1.medical_product_id as mp_1_id,
a_mpn.mp_1_cnt,
a_mpn.mp_1_price_min,
a_mpn.mp_1_online_cnt,
a_mpn.mp_1_online_price_min,
a_mpn.mp_1_order_cnt,
a_mpn.mp_1_order_price_min,
mp_1.medical_product_latin as mp_1_latin,
mp_1.medical_product_name as mp_1_name,
case when mp_1_img.image_cnt is null then 0 else mp_1_img.image_cnt end as mp_1_img,
mp_1.medical_form_id as mp_1_medical_form_id,
case when mp_1_f_img.image_cnt is null then 0 else mp_1_f_img.image_cnt end as mp_1_f_img,
mp_1.recept_id as mp_1_recept_id,
mp_1.thermolabil_id as mp_1_thermolabil_id,
mp_1.vendor_id as mp_1_vendor_id,
mp_1.vendor_iname as mp_1_vendor_iname,
mp_1.country_iname as mp_1_country_iname,
mp_1_i.international_name_id as mp_1_international_name_id,
mp_1_i.international_name_name as mp_1_international_name_name,
mp_1_i.international_name_latin as mp_1_international_name_latin,
mp_1_i.moderation_flag::int as mp_1_moderation_flag,
--------------------
mp_2.medical_product_id as mp_2_id,
a_mpn.mp_2_cnt,
a_mpn.mp_2_price_min,
a_mpn.mp_2_online_cnt,
a_mpn.mp_2_online_price_min,
a_mpn.mp_2_order_cnt,
a_mpn.mp_2_order_price_min,
mp_2.medical_product_latin as mp_2_latin,
mp_2.medical_product_name as mp_2_name,
case when mp_2_img.image_cnt is null then 0 else mp_2_img.image_cnt end as mp_2_img,
mp_2.medical_form_id as mp_2_medical_form_id,
case when mp_2_f_img.image_cnt is null then 0 else mp_2_f_img.image_cnt end as mp_2_f_img,
mp_2.recept_id as mp_2_recept_id,
mp_2.thermolabil_id as mp_2_thermolabil_id,
mp_2.vendor_id as mp_2_vendor_id,
mp_2.vendor_iname as mp_2_vendor_iname,
mp_2.country_iname as mp_2_country_iname,
mp_2_i.international_name_id as mp_2_international_name_id,
mp_2_i.international_name_name as mp_2_international_name_name,
mp_2_i.international_name_latin as mp_2_international_name_latin,
mp_2_i.moderation_flag::int as mp_2_moderation_flag,
--------------------
mp_3.medical_product_id as mp_3_id,
a_mpn.mp_3_cnt,
a_mpn.mp_3_price_min,
a_mpn.mp_3_online_cnt,
a_mpn.mp_3_online_price_min,
a_mpn.mp_3_order_cnt,
a_mpn.mp_3_order_price_min,
mp_3.medical_product_latin as mp_3_latin,
mp_3.medical_product_name as mp_3_name,
case when mp_3_img.image_cnt is null then 0 else mp_3_img.image_cnt end as mp_3_img,
mp_3.medical_form_id as mp_3_medical_form_id,
case when mp_3_f_img.image_cnt is null then 0 else mp_3_f_img.image_cnt end as mp_3_f_img,
mp_3.recept_id as mp_3_recept_id,
mp_3.thermolabil_id as mp_3_thermolabil_id,
mp_3.vendor_id as mp_3_vendor_id,
mp_3.vendor_iname as mp_3_vendor_iname,
mp_3.country_iname as mp_3_country_iname,
mp_3_i.international_name_id as mp_3_international_name_id,
mp_3_i.international_name_name as mp_3_international_name_name,
mp_3_i.international_name_latin as mp_3_international_name_latin,
mp_3_i.moderation_flag::int as mp_3_moderation_flag,
--------------------
mp_4.medical_product_id as mp_4_id,
a_mpn.mp_4_cnt,
a_mpn.mp_4_price_min,
a_mpn.mp_4_online_cnt,
a_mpn.mp_4_online_price_min,
a_mpn.mp_4_order_cnt,
a_mpn.mp_4_order_price_min,
mp_4.medical_product_latin as mp_4_latin,
mp_4.medical_product_name as mp_4_name,
case when mp_4_img.image_cnt is null then 0 else mp_4_img.image_cnt end as mp_4_img,
mp_4.medical_form_id as mp_4_medical_form_id,
case when mp_4_f_img.image_cnt is null then 0 else mp_4_f_img.image_cnt end as mp_4_f_img,
mp_4.recept_id as mp_4_recept_id,
mp_4.thermolabil_id as mp_4_thermolabil_id,
mp_4.vendor_id as mp_4_vendor_id,
mp_4.vendor_iname as mp_4_vendor_iname,
mp_4.country_iname as mp_4_country_iname,
mp_4_i.international_name_id as mp_4_international_name_id,
mp_4_i.international_name_name as mp_4_international_name_name,
mp_4_i.international_name_latin as mp_4_international_name_latin,
mp_4_i.moderation_flag::int as mp_4_moderation_flag,
--------------------
a_mpn.dd_online_1_id,
a_mpn.dd_online_1_prior,
a_mpn.dd_online_1_delivery_flag::int,
ddo_1.firm_id as firm_ddo_1_id,
im_1.image_cnt as image_ddo_1_cnt,
case when ddo_1.dd_logo_name > '' then ddo_1.dd_logo_name else ddo_1_f.firm_logo_name end as dd_logo_1_name,
case when ddo_1.dd_logo_text > '' then ddo_1.dd_logo_text else ddo_1_f.firm_logo_text end as dd_logo_1_text,
ddo_1.drugstore_department_latin as drugstore_department_1_latin,
case when dd_dis_a_1.distrib_cnt > 0 then ddo_1.drugstore_department_API_lhs_flag::int else 0 end as "drugstore_department_API_lhs_1_flag",
cast(ddo_1.dd_advert_flag_href as int) as gosite_1_flag,
do_1.drugstore_virtual_flag::int as drugstore_virtual_1_flag,
a_mpn.dd_online_v_1_id,
case when ac_ddo_1.action_unconditional_flag::int = 1 and a_mpn.dd_online_1_action_price > 0 and a_mpn.dd_online_1_price > a_mpn.dd_online_1_action_price then a_mpn.dd_online_1_action_price else a_mpn.dd_online_1_price end as dd_online_1_price,
a_mpn.dd_online_1_price as dd_online_1_price_simple_min,
a_mpn.dd_online_1_action_price as dd_online_1_price_action_min,
a_mpn.dd_online_1_action_id,
ac_ddo_1.action_type_id as dd_online_1_action_type_id,
ac_ddo_1.action_name as dd_online_1_action_name,
ac_ddo_1.action_unconditional_flag::int as dd_online_1_action_unconditional_flag,
act_ddo_1.action_type_code as dd_online_1_action_type_code,
case when dlv_1.dd_delivery_min_cost is null then null else case when a_mpn.dd_online_1_price > 0 and (a_mpn.dd_online_1_price < dlv_1.dd_delivery_free_sum or dlv_1.dd_delivery_free_sum = 0) then dlv_1.dd_delivery_min_cost else 0 end end as delivery_price_1_min,
ddo_1.drugstore_department_delivery_home as drugstore_department_1_delivery_home,
case when ddo_1.fastOrderSum::int > 0 then ddo_1.fastOrderSum::int
else
case when ddo_1.fastOrderSum::int = -1 then 0
else
case when ddo_1_f.fastOrderSum::int > 0 then ddo_1_f.fastOrderSum::int
else
case when ddo_1_f.fastOrderSum::int = -1 then 0
else
case when a.fastOrderSum::int > 0 then a.fastOrderSum::int
else 0
end
end
end
end
end as "dd_online_1_fastOrderSum",
a_mpn.dd_online_2_id,
a_mpn.dd_online_2_prior,
a_mpn.dd_online_2_delivery_flag::int,
ddo_2.firm_id as firm_ddo_2_id,
im_2.image_cnt as image_ddo_2_cnt,
case when ddo_2.dd_logo_name > '' then ddo_2.dd_logo_name else ddo_2_f.firm_logo_name end as dd_logo_2_name,
case when ddo_2.dd_logo_text > '' then ddo_2.dd_logo_text else ddo_2_f.firm_logo_text end as dd_logo_2_text,
ddo_2.drugstore_department_latin as drugstore_department_2_latin,
case when dd_dis_a_2.distrib_cnt > 0 then ddo_2.drugstore_department_API_lhs_flag::int else 0 end as "drugstore_department_API_lhs_2_flag",
cast(ddo_2.dd_advert_flag_href as int) as gosite_2_flag,
do_2.drugstore_virtual_flag::int as drugstore_virtual_2_flag,
a_mpn.dd_online_v_2_id,
case when ac_ddo_2.action_unconditional_flag::int = 1 and a_mpn.dd_online_2_action_price > 0 and a_mpn.dd_online_2_price > a_mpn.dd_online_2_action_price then a_mpn.dd_online_2_action_price else a_mpn.dd_online_2_price end as dd_online_2_price,
a_mpn.dd_online_2_price as dd_online_2_price_simple_min,
a_mpn.dd_online_2_action_price as dd_online_2_price_action_min,
a_mpn.dd_online_2_action_id,
ac_ddo_2.action_type_id as dd_online_2_action_type_id,
ac_ddo_2.action_name as dd_online_2_action_name,
ac_ddo_2.action_unconditional_flag::int as dd_online_2_action_unconditional_flag,
case when dlv_2.dd_delivery_min_cost is null then null else case when a_mpn.dd_online_2_price > 0 and (a_mpn.dd_online_2_price < dlv_2.dd_delivery_free_sum or dlv_2.dd_delivery_free_sum = 0) then dlv_2.dd_delivery_min_cost else 0 end end as delivery_price_2_min,
ddo_2.drugstore_department_delivery_home as drugstore_department_2_delivery_home,
case when ddo_2.fastOrderSum::int > 0 then ddo_2.fastOrderSum::int
else
case when ddo_2.fastOrderSum::int = -1 then 0
else
case when ddo_2_f.fastOrderSum::int > 0 then ddo_2_f.fastOrderSum::int
else
case when ddo_2_f.fastOrderSum::int = -1 then 0
else
case when a.fastOrderSum::int > 0 then a.fastOrderSum::int
else 0
end
end
end
end
end as "dd_online_2_fastOrderSum",
a_mpn.dd_online_3_id,
a_mpn.dd_online_3_prior,
a_mpn.dd_online_3_delivery_flag::int,
ddo_3.firm_id as firm_ddo_3_id,
im_3.image_cnt as image_ddo_3_cnt,
case when ddo_3.dd_logo_name > '' then ddo_3.dd_logo_name else ddo_3_f.firm_logo_name end as dd_logo_3_name,
case when ddo_3.dd_logo_text > '' then ddo_3.dd_logo_text else ddo_3_f.firm_logo_text end as dd_logo_3_text,
ddo_3.drugstore_department_latin as drugstore_department_3_latin,
case when dd_dis_a_3.distrib_cnt > 0 then ddo_3.drugstore_department_API_lhs_flag::int else 0 end as "drugstore_department_API_lhs_3_flag",
cast(ddo_3.dd_advert_flag_href as int) as gosite_3_flag,
do_3.drugstore_virtual_flag::int as drugstore_virtual_3_flag,
a_mpn.dd_online_v_3_id,
case when ac_ddo_3.action_unconditional_flag::int = 1 and a_mpn.dd_online_3_action_price > 0 and a_mpn.dd_online_3_price > a_mpn.dd_online_3_action_price then a_mpn.dd_online_3_action_price else a_mpn.dd_online_3_price end as dd_online_3_price,
a_mpn.dd_online_3_price as dd_online_3_price_simple_min,
a_mpn.dd_online_3_action_price as dd_online_3_price_action_min,
a_mpn.dd_online_3_action_id,
ac_ddo_3.action_type_id as dd_online_3_action_type_id,
ac_ddo_3.action_name as dd_online_3_action_name,
ac_ddo_3.action_unconditional_flag::int as dd_online_3_action_unconditional_flag,
case when dlv_3.dd_delivery_min_cost is null then null else case when a_mpn.dd_online_3_price > 0 and (a_mpn.dd_online_3_price < dlv_3.dd_delivery_free_sum or dlv_3.dd_delivery_free_sum = 0) then dlv_3.dd_delivery_min_cost else 0 end end as delivery_price_3_min,
ddo_3.drugstore_department_delivery_home as drugstore_department_3_delivery_home,
case when ddo_3.fastOrderSum::int > 0 then ddo_3.fastOrderSum::int
else
case when ddo_3.fastOrderSum::int = -1 then 0
else
case when ddo_3_f.fastOrderSum::int > 0 then ddo_3_f.fastOrderSum::int
else
case when ddo_3_f.fastOrderSum::int = -1 then 0
else
case when a.fastOrderSum::int > 0 then a.fastOrderSum::int
else 0
end
end
end
end
end as "dd_online_3_fastOrderSum",
a_mpn.dd_online_4_id,
a_mpn.dd_online_4_prior,
a_mpn.dd_online_4_delivery_flag::int,
ddo_4.firm_id as firm_ddo_4_id,
im_4.image_cnt as image_ddo_4_cnt,
case when ddo_4.dd_logo_name > '' then ddo_4.dd_logo_name else ddo_4_f.firm_logo_name end as dd_logo_4_name,
case when ddo_4.dd_logo_text > '' then ddo_4.dd_logo_text else ddo_4_f.firm_logo_text end as dd_logo_4_text,
ddo_4.drugstore_department_latin as drugstore_department_4_latin,
case when dd_dis_a_4.distrib_cnt > 0 then ddo_4.drugstore_department_API_lhs_flag::int else 0 end as "drugstore_department_API_lhs_4_flag",
cast(ddo_4.dd_advert_flag_href as int) as gosite_4_flag,
do_4.drugstore_virtual_flag::int as drugstore_virtual_4_flag,
a_mpn.dd_online_v_4_id,
case when ac_ddo_4.action_unconditional_flag::int = 1 and a_mpn.dd_online_4_action_price > 0 and a_mpn.dd_online_4_price > a_mpn.dd_online_4_action_price then a_mpn.dd_online_4_action_price else a_mpn.dd_online_4_price end as dd_online_4_price,
a_mpn.dd_online_4_price as dd_online_4_price_simple_min,
a_mpn.dd_online_4_action_price as dd_online_4_price_action_min,
a_mpn.dd_online_4_action_id,
ac_ddo_4.action_type_id as dd_online_4_action_type_id,
ac_ddo_4.action_name as dd_online_4_action_name,
ac_ddo_4.action_unconditional_flag::int as dd_online_4_action_unconditional_flag,
case when dlv_4.dd_delivery_min_cost is null then null else case when a_mpn.dd_online_4_price > 0 and (a_mpn.dd_online_4_price < dlv_4.dd_delivery_free_sum or dlv_4.dd_delivery_free_sum = 0) then dlv_4.dd_delivery_min_cost else 0 end end as delivery_price_4_min,
ddo_4.drugstore_department_delivery_home as drugstore_department_4_delivery_home,
case when ddo_4.fastOrderSum::int > 0 then ddo_4.fastOrderSum::int
else
case when ddo_4.fastOrderSum::int = -1 then 0
else
case when ddo_4_f.fastOrderSum::int > 0 then ddo_4_f.fastOrderSum::int
else
case when ddo_4_f.fastOrderSum::int = -1 then 0
else
case when a.fastOrderSum::int > 0 then a.fastOrderSum::int
else 0
end
end
end
end
end as "dd_online_4_fastOrderSum",
a_mpn.dd_online_5_id,
a_mpn.dd_online_5_prior,
a_mpn.dd_online_5_delivery_flag::int,
ddo_5.firm_id as firm_ddo_5_id,
im_5.image_cnt as image_ddo_5_cnt,
case when ddo_5.dd_logo_name > '' then ddo_5.dd_logo_name else ddo_5_f.firm_logo_name end as dd_logo_5_name,
case when ddo_5.dd_logo_text > '' then ddo_5.dd_logo_text else ddo_5_f.firm_logo_text end as dd_logo_5_text,
ddo_5.drugstore_department_latin as drugstore_department_5_latin,
case when dd_dis_a_5.distrib_cnt > 0 then ddo_5.drugstore_department_API_lhs_flag::int else 0 end as "drugstore_department_API_lhs_5_flag",
cast(ddo_5.dd_advert_flag_href as int) as gosite_5_flag,
do_5.drugstore_virtual_flag::int as drugstore_virtual_5_flag,
a_mpn.dd_online_v_5_id,
case when ac_ddo_5.action_unconditional_flag::int = 1 and a_mpn.dd_online_5_action_price > 0 and a_mpn.dd_online_5_price > a_mpn.dd_online_5_action_price then a_mpn.dd_online_5_action_price else a_mpn.dd_online_5_price end as dd_online_5_price,
a_mpn.dd_online_5_price as dd_online_5_price_simple_min,
a_mpn.dd_online_5_action_price as dd_online_5_price_action_min,
a_mpn.dd_online_5_action_id,
ac_ddo_5.action_type_id as dd_online_5_action_type_id,
ac_ddo_5.action_name as dd_online_5_action_name,
ac_ddo_5.action_unconditional_flag::int as dd_online_5_action_unconditional_flag,
case when dlv_5.dd_delivery_min_cost is null then null else case when a_mpn.dd_online_5_price > 0 and (a_mpn.dd_online_5_price < dlv_5.dd_delivery_free_sum or dlv_5.dd_delivery_free_sum = 0) then dlv_5.dd_delivery_min_cost else 0 end end as delivery_price_5_min,
ddo_5.drugstore_department_delivery_home as drugstore_department_5_delivery_home,
case when ddo_5.fastOrderSum::int > 0 then ddo_5.fastOrderSum::int
else
case when ddo_5.fastOrderSum::int = -1 then 0
else
case when ddo_5_f.fastOrderSum::int > 0 then ddo_5_f.fastOrderSum::int
else
case when ddo_5_f.fastOrderSum::int = -1 then 0
else
case when a.fastOrderSum::int > 0 then a.fastOrderSum::int
else 0
end
end
end
end
end as "dd_online_5_fastOrderSum",
a_sin.sinonim_cnt as sinonim_cnt,
a_sin.sinonim_price_min as sinonim_price_min,
/*a_an.cnt*/ 0 as analog_cnt,
/*a_an.price_min*/ null as analog_price_min,
a_mpn.f_map_1_id,
a_mpn.f_map_1_delivery_flag::int,
a_mpn.f_map_1_dd_id,
a_mpn.f_map_1_dd_cnt,
ifmm_1.image_cnt as f_map_1_image_cnt,
fm_1.firm_logo_name as f_map_1_logo_name,
fm_1.firm_logo_text as f_map_1_logo_text,
a_mpn.f_map_1_price,
a_mpn.f_map_1_action_price,
a_mpn.f_map_1_action_id,
ac_fm_1.action_name as f_map_1_action_name,
ac_fm_1.action_unconditional_flag::int as f_map_1_action_unconditional_flag,
act_fm_1.action_type_code as f_map_1_action_type_code,
fm_1.firm_latin as f_map_1_firm_latin,
d_fm_1.drugstore_latin as f_map_1_drugstore_latin,
a_mpn.f_map_1_prior,
a_mpn.f_map_2_id,
a_mpn.f_map_2_delivery_flag::int,
a_mpn.f_map_2_dd_id,
a_mpn.f_map_2_dd_cnt,
ifmm_2.image_cnt as f_map_2_image_cnt,
fm_2.firm_logo_name as f_map_2_logo_name,
fm_2.firm_logo_text as f_map_2_logo_text,
a_mpn.f_map_2_price,
a_mpn.f_map_2_action_price,
a_mpn.f_map_2_action_id,
ac_fm_2.action_name as f_map_2_action_name,
ac_fm_2.action_unconditional_flag::int as f_map_2_action_unconditional_flag,
act_fm_2.action_type_code as f_map_2_action_type_code,
fm_2.firm_latin as f_map_2_firm_latin,
d_fm_2.drugstore_latin as f_map_2_drugstore_latin,
a_mpn.f_map_2_prior,
a_mpn.f_map_3_id,
a_mpn.f_map_3_delivery_flag::int,
a_mpn.f_map_3_dd_id,
a_mpn.f_map_3_dd_cnt,
ifmm_3.image_cnt as f_map_3_image_cnt,
fm_3.firm_logo_name as f_map_3_logo_name,
fm_3.firm_logo_text as f_map_3_logo_text,
a_mpn.f_map_3_price,
a_mpn.f_map_3_action_price,
a_mpn.f_map_3_action_id,
ac_fm_3.action_name as f_map_3_action_name,
ac_fm_3.action_unconditional_flag::int as f_map_3_action_unconditional_flag,
act_fm_3.action_type_code as f_map_3_action_type_code,
fm_3.firm_latin as f_map_3_firm_latin,
d_fm_3.drugstore_latin as f_map_3_drugstore_latin,
a_mpn.f_map_3_prior,
a_mpn.f_map_4_id,
a_mpn.f_map_4_delivery_flag::int,
a_mpn.f_map_4_dd_id,
a_mpn.f_map_4_dd_cnt,
ifmm_4.image_cnt as f_map_4_image_cnt,
fm_4.firm_logo_name as f_map_4_logo_name,
fm_4.firm_logo_text as f_map_4_logo_text,
a_mpn.f_map_4_price,
a_mpn.f_map_4_action_price,
a_mpn.f_map_4_action_id,
ac_fm_4.action_name as f_map_4_action_name,
ac_fm_4.action_unconditional_flag::int as f_map_4_action_unconditional_flag,
act_fm_4.action_type_code as f_map_4_action_type_code,
fm_4.firm_latin as f_map_4_firm_latin,
d_fm_4.drugstore_latin as f_map_4_drugstore_latin,
a_mpn.f_map_4_prior,
a_mpn.f_map_5_id,
a_mpn.f_map_5_delivery_flag::int,
a_mpn.f_map_5_dd_id,
a_mpn.f_map_5_dd_cnt,
ifmm_5.image_cnt as f_map_5_image_cnt,
fm_5.firm_logo_name as f_map_5_logo_name,
fm_5.firm_logo_text as f_map_5_logo_text,
a_mpn.f_map_5_price,
a_mpn.f_map_5_action_price,
a_mpn.f_map_5_action_id,
ac_fm_5.action_name as f_map_5_action_name,
ac_fm_5.action_unconditional_flag::int as f_map_5_action_unconditional_flag,
act_fm_5.action_type_code as f_map_5_action_type_code,
fm_5.firm_latin as f_map_5_firm_latin,
d_fm_5.drugstore_latin as f_map_5_drugstore_latin,
a_mpn.f_map_5_prior,
a_mpn.f_order_1_id,
a_mpn.f_order_1_dds_id,
d_dd_fo_1.drugstore_virtual_flag::int as f_order_1_drugstore_virtual_flag,
dd_fo_1.drugstore_department_API_lhs_flag::int as "f_order_1_drugstore_department_API_lhs_flag",
REPLACE(dd_fo_1.drugstore_department_adress || case when dd_fo_1.drugstore_department_adress2>'' then ' (' || dd_fo_1.drugstore_department_adress2 || ')' else '' end,'''','`') as f_order_1_drugstore_department_adress,
a_mpn.f_order_1_delivery_flag::int,
ifom_1.image_cnt as f_order_1_image_cnt,
fo_1.firm_logo_name as f_order_1_logo_name,
fo_1.firm_logo_text as f_order_1_logo_text,
a_mpn.f_order_1_price,
a_mpn.f_order_1_action_price,
a_mpn.f_order_1_action_id,
ac_fo_1.action_name as f_order_1_action_name,
ac_fo_1.action_unconditional_flag::int as f_order_1_action_unconditional_flag,
act_fo_1.action_type_code as f_order_1_action_type_code,
fo_1.firm_latin as f_order_1_firm_latin,
d_fo_1.drugstore_latin as f_order_1_drugstore_latin,
a_mpn.f_order_1_prior,
a_mpn.f_order_2_id,
a_mpn.f_order_2_dds_id,
d_dd_fo_2.drugstore_virtual_flag::int as f_order_2_drugstore_virtual_flag,
dd_fo_2.drugstore_department_API_lhs_flag::int as "f_order_2_drugstore_department_API_lhs_flag",
REPLACE(dd_fo_2.drugstore_department_adress || case when dd_fo_2.drugstore_department_adress2>'' then ' (' || dd_fo_2.drugstore_department_adress2 || ')' else '' end,'''','`') as f_order_2_drugstore_department_adress,
a_mpn.f_order_2_delivery_flag::int,
ifom_2.image_cnt as f_order_2_image_cnt,
fo_2.firm_logo_name as f_order_2_logo_name,
fo_2.firm_logo_text as f_order_2_logo_text,
a_mpn.f_order_2_price,
a_mpn.f_order_2_action_price,
a_mpn.f_order_2_action_id,
ac_fo_2.action_name as f_order_2_action_name,
ac_fo_2.action_unconditional_flag::int as f_order_2_action_unconditional_flag,
act_fo_2.action_type_code as f_order_2_action_type_code,
fo_2.firm_latin as f_order_2_firm_latin,
d_fo_2.drugstore_latin as f_order_2_drugstore_latin,
a_mpn.f_order_2_prior,
a_mpn.f_order_3_id,
a_mpn.f_order_3_dds_id,
d_dd_fo_3.drugstore_virtual_flag::int as f_order_3_drugstore_virtual_flag,
dd_fo_3.drugstore_department_API_lhs_flag::int as "f_order_3_drugstore_department_API_lhs_flag",
REPLACE(dd_fo_3.drugstore_department_adress || case when dd_fo_3.drugstore_department_adress2>'' then ' (' || dd_fo_3.drugstore_department_adress2 || ')' else '' end,'''','`') as f_order_3_drugstore_department_adress,
a_mpn.f_order_3_delivery_flag::int,
ifom_3.image_cnt as f_order_3_image_cnt,
fo_3.firm_logo_name as f_order_3_logo_name,
fo_3.firm_logo_text as f_order_3_logo_text,
a_mpn.f_order_3_price,
a_mpn.f_order_3_action_price,
a_mpn.f_order_3_action_id,
ac_fo_3.action_name as f_order_3_action_name,
ac_fo_3.action_unconditional_flag::int as f_order_3_action_unconditional_flag,
act_fo_3.action_type_code as f_order_3_action_type_code,
fo_3.firm_latin as f_order_3_firm_latin,
d_fo_3.drugstore_latin as f_order_3_drugstore_latin,
a_mpn.f_order_3_prior,
a_mpn.f_order_4_id,
a_mpn.f_order_4_dds_id,
d_dd_fo_4.drugstore_virtual_flag::int as f_order_4_drugstore_virtual_flag,
dd_fo_4.drugstore_department_API_lhs_flag::int as "f_order_4_drugstore_department_API_lhs_flag",
REPLACE(dd_fo_4.drugstore_department_adress || case when dd_fo_4.drugstore_department_adress2>'' then ' (' || dd_fo_4.drugstore_department_adress2 || ')' else '' end,'''','`') as f_order_4_drugstore_department_adress,
a_mpn.f_order_4_delivery_flag::int,
ifom_4.image_cnt as f_order_4_image_cnt,
fo_4.firm_logo_name as f_order_4_logo_name,
fo_4.firm_logo_text as f_order_4_logo_text,
a_mpn.f_order_4_price,
a_mpn.f_order_4_action_price,
a_mpn.f_order_4_action_id,
ac_fo_4.action_name as f_order_4_action_name,
ac_fo_4.action_unconditional_flag::int as f_order_4_action_unconditional_flag,
act_fo_4.action_type_code as f_order_4_action_type_code,
fo_4.firm_latin as f_order_4_firm_latin,
d_fo_4.drugstore_latin as f_order_4_drugstore_latin,
a_mpn.f_order_4_prior,
a_mpn.f_order_5_id,
a_mpn.f_order_5_dds_id,
d_dd_fo_5.drugstore_virtual_flag::int as f_order_5_drugstore_virtual_flag,
dd_fo_5.drugstore_department_API_lhs_flag::int as "f_order_5_drugstore_department_API_lhs_flag",
REPLACE(dd_fo_5.drugstore_department_adress || case when dd_fo_5.drugstore_department_adress2>'' then ' (' || dd_fo_5.drugstore_department_adress2 || ')' else '' end,'''','`') as f_order_5_drugstore_department_adress,
a_mpn.f_order_5_delivery_flag::int,
ifom_5.image_cnt as f_order_5_image_cnt,
fo_5.firm_logo_name as f_order_5_logo_name,
fo_5.firm_logo_text as f_order_5_logo_text,
a_mpn.f_order_5_price,
a_mpn.f_order_5_action_price,
a_mpn.f_order_5_action_id,
ac_fo_5.action_name as f_order_5_action_name,
ac_fo_5.action_unconditional_flag::int as f_order_5_action_unconditional_flag,
act_fo_5.action_type_code as f_order_5_action_type_code,
fo_5.firm_latin as f_order_5_firm_latin,
d_fo_5.drugstore_latin as f_order_5_drugstore_latin,
a_mpn.f_order_5_prior,
rc.recept_name,
case when mpn.recept_id > 1 then
case when mpn.recept_all_flag::int = 0 then
'Некоторые ' || LOWER(ig1.igMpsText) || ' ' || LOWER(rc.recept_name)
else
rc.recept_name
end
else
null
end as recept_text,
a_mpn.dd_full_day::int as full_day_bit,
null as tezka_medical_product_name_id,
null as tezka_medical_product_name_latin,
null as tezka_international_group_latin,
null as tezka_international_group2_latin,
null as tezka_medical_product_name_name_full,
null as tezka_gp_name
from
medical_product_name mpn
inner join area a on a.area_id = __area_id
inner join medical_product_name_check_type ct on ct.medical_product_name_check_type = mpn.medical_product_name_check_type
inner join recept rc on rc.recept_id = mpn.recept_id
left join medical_product mp on mp.medical_product_id = mpn.medical_product_id
left join international_name i_n on i_n.international_name_id = mpn.international_name_id
left join pharmacological_group pg on pg.pharmacological_group_id = mpn.pharmacological_group_id
left join international_group2 ig2 on ig2.international_group2_id = mpn.international_group2_id
left join international_group ig1 on ig1.international_group_id = ig2.international_group_id
left join __t_php_a_mpn a_mpn on a_mpn.medical_product_name_id = mpn.medical_product_name_id
and a_mpn.area_id = __area_id
left join php_a_mpn__top5typeattr ta5 on ta5.area_id = __area_id
and ta5.medical_product_name_id = mpn.medical_product_name_id
left join drugstore d on d.drugstore_id = a_mpn.min_drugstore_id
left join firm f on f.firm_id = a_mpn.firm_id
left join __t_syns a_sin on a_sin.medical_product_name_id = mpn.medical_product_name_id
-- дозировки
left join medical_product mp_1 on mp_1.medical_product_id = coalesce(a_mpn.mp_1_id, __t_mp_1)
left join image mp_1_img on mp_1_img.image_type_id = __image_type_mp_id
and mp_1_img.image_size_id = __image_size_mp_id
and mp_1_img.id_value = mp_1.medical_product_id
left join image mp_1_f_img on mp_1_f_img.image_type_id = __image_type_mpf_id
and mp_1_f_img.image_size_id = __image_size_mpf_id
and mp_1_f_img.id_value = mp_1.medical_form_id
left join international_name mp_1_i on mp_1_i.international_name_id = mp_1.international_name_id
------------
left join medical_product mp_2 on mp_2.medical_product_id = coalesce(a_mpn.mp_2_id, __t_mp_2)
left join image mp_2_img on mp_2_img.image_type_id = __image_type_mp_id
and mp_2_img.image_size_id = __image_size_mp_id
and mp_2_img.id_value = mp_2.medical_product_id
left join image mp_2_f_img on mp_2_f_img.image_type_id = __image_type_mpf_id
and mp_2_f_img.image_size_id = __image_size_mpf_id
and mp_2_f_img.id_value = mp_2.medical_form_id
left join international_name mp_2_i on mp_2_i.international_name_id = mp_2.international_name_id
------------
left join medical_product mp_3 on mp_3.medical_product_id = coalesce(a_mpn.mp_3_id, __t_mp_3)
left join image mp_3_img on mp_3_img.image_type_id = __image_type_mp_id
and mp_3_img.image_size_id = __image_size_mp_id
and mp_3_img.id_value = mp_3.medical_product_id
left join image mp_3_f_img on mp_3_f_img.image_type_id = __image_type_mpf_id
and mp_3_f_img.image_size_id = __image_size_mpf_id
and mp_3_f_img.id_value = mp_3.medical_form_id
left join international_name mp_3_i on mp_3_i.international_name_id = mp_3.international_name_id
------------
left join medical_product mp_4 on mp_4.medical_product_id = coalesce(a_mpn.mp_4_id, __t_mp_4)
left join image mp_4_img on mp_4_img.image_type_id = __image_type_mp_id
and mp_4_img.image_size_id = __image_size_mp_id
and mp_4_img.id_value = mp_4.medical_product_id
left join image mp_4_f_img on mp_4_f_img.image_type_id = __image_type_mpf_id
and mp_4_f_img.image_size_id = __image_size_mpf_id
and mp_4_f_img.id_value = mp_4.medical_form_id
left join international_name mp_4_i on mp_4_i.international_name_id = mp_4.international_name_id
------------
left join drugstore_department ddo_1 on ddo_1.drugstore_department_id = a_mpn.dd_online_1_id
left join dd_distrib_area dd_dis_a_1 on dd_dis_a_1.drugstore_department_source_id = ddo_1.drugstore_department_id and dd_dis_a_1.area_distrib_id = __area_id
left join firm ddo_1_f on ddo_1_f.firm_id = ddo_1.firm_id
left join drugstore do_1 on do_1.drugstore_id = ddo_1.drugstore_id
left join dd_delivery_area_region dlv_1 on dlv_1.area_id = __area_id and dlv_1.drugstore_department_id = ddo_1.drugstore_department_id
left join image im_1 on im_1.image_type_id = __image_type_f_id
and im_1.image_size_id = __image_size_f_id
and im_1.id_value = ddo_1.firm_id
left join action ac_ddo_1 on ac_ddo_1.action_id = a_mpn.dd_online_1_action_id
left join action_type act_ddo_1 on act_ddo_1.action_type_id = ac_ddo_1.action_type_id
left join drugstore_department ddo_2 on ddo_2.drugstore_department_id = a_mpn.dd_online_2_id
left join dd_distrib_area dd_dis_a_2 on dd_dis_a_2.drugstore_department_source_id = ddo_2.drugstore_department_id and dd_dis_a_2.area_distrib_id = __area_id
left join firm ddo_2_f on ddo_2_f.firm_id = ddo_2.firm_id
left join drugstore do_2 on do_2.drugstore_id = ddo_2.drugstore_id
left join dd_delivery_area_region dlv_2 on dlv_2.area_id = __area_id and dlv_2.drugstore_department_id = ddo_2.drugstore_department_id
left join image im_2 on im_2.image_type_id = __image_type_f_id
and im_2.image_size_id = __image_size_f_id
and im_2.id_value = ddo_2.firm_id
left join action ac_ddo_2 on ac_ddo_2.action_id = a_mpn.dd_online_2_action_id
left join action_type act_ddo_2 on act_ddo_2.action_type_id = ac_ddo_2.action_type_id
left join drugstore_department ddo_3 on ddo_3.drugstore_department_id = a_mpn.dd_online_3_id
left join dd_distrib_area dd_dis_a_3 on dd_dis_a_3.drugstore_department_source_id = ddo_3.drugstore_department_id and dd_dis_a_3.area_distrib_id = __area_id
left join firm ddo_3_f on ddo_3_f.firm_id = ddo_3.firm_id
left join drugstore do_3 on do_3.drugstore_id = ddo_3.drugstore_id
left join dd_delivery_area_region dlv_3 on dlv_3.area_id = __area_id and dlv_3.drugstore_department_id = ddo_3.drugstore_department_id
left join image im_3 on im_3.image_type_id = __image_type_f_id
and im_3.image_size_id = __image_size_f_id
and im_3.id_value = ddo_3.firm_id
left join action ac_ddo_3 on ac_ddo_3.action_id = a_mpn.dd_online_3_action_id
left join action_type act_ddo_3 on act_ddo_3.action_type_id = ac_ddo_3.action_type_id
left join drugstore_department ddo_4 on ddo_4.drugstore_department_id = a_mpn.dd_online_4_id
left join dd_distrib_area dd_dis_a_4 on dd_dis_a_4.drugstore_department_source_id = ddo_4.drugstore_department_id and dd_dis_a_4.area_distrib_id = __area_id
left join firm ddo_4_f on ddo_4_f.firm_id = ddo_4.firm_id
left join drugstore do_4 on do_4.drugstore_id = ddo_4.drugstore_id
left join dd_delivery_area_region dlv_4 on dlv_4.area_id = __area_id and dlv_4.drugstore_department_id = ddo_4.drugstore_department_id
left join image im_4 on im_4.image_type_id = __image_type_f_id
and im_4.image_size_id = __image_size_f_id
and im_4.id_value = ddo_4.firm_id
left join action ac_ddo_4 on ac_ddo_4.action_id = a_mpn.dd_online_4_action_id
left join action_type act_ddo_4 on act_ddo_4.action_type_id = ac_ddo_4.action_type_id
left join drugstore_department ddo_5 on ddo_5.drugstore_department_id = a_mpn.dd_online_5_id
left join dd_distrib_area dd_dis_a_5 on dd_dis_a_5.drugstore_department_source_id = ddo_5.drugstore_department_id and dd_dis_a_5.area_distrib_id = __area_id
left join firm ddo_5_f on ddo_5_f.firm_id = ddo_5.firm_id
left join drugstore do_5 on do_5.drugstore_id = ddo_5.drugstore_id
left join dd_delivery_area_region dlv_5 on dlv_5.area_id = __area_id and dlv_5.drugstore_department_id = ddo_5.drugstore_department_id
left join image im_5 on im_5.image_type_id = __image_type_f_id
and im_5.image_size_id = __image_size_f_id
and im_5.id_value = ddo_5.firm_id
left join action ac_ddo_5 on ac_ddo_5.action_id = a_mpn.dd_online_5_action_id
left join action_type act_ddo_5 on act_ddo_5.action_type_id = ac_ddo_5.action_type_id
left join firm fm_1 on fm_1.firm_id = a_mpn.f_map_1_id
left join drugstore d_fm_1 on d_fm_1.drugstore_id = fm_1.drugstore_id
left join image ifmm_1 on ifmm_1.image_type_id = __image_type_f_id
and ifmm_1.image_size_id = __image_size_f_id
and ifmm_1.id_value = fm_1.firm_id
left join action ac_fm_1 on ac_fm_1.action_id = a_mpn.f_map_1_action_id
left join action_type act_fm_1 on act_fm_1.action_type_id = ac_fm_1.action_type_id
left join firm fm_2 on fm_2.firm_id = a_mpn.f_map_2_id
left join drugstore d_fm_2 on d_fm_2.drugstore_id = fm_2.drugstore_id
left join image ifmm_2 on ifmm_2.image_type_id = __image_type_f_id
and ifmm_2.image_size_id = __image_size_f_id
and ifmm_2.id_value = fm_2.firm_id
left join action ac_fm_2 on ac_fm_2.action_id = a_mpn.f_map_2_action_id
left join action_type act_fm_2 on act_fm_2.action_type_id = ac_fm_2.action_type_id
left join firm fm_3 on fm_3.firm_id = a_mpn.f_map_3_id
left join drugstore d_fm_3 on d_fm_3.drugstore_id = fm_3.drugstore_id
left join image ifmm_3 on ifmm_3.image_type_id = __image_type_f_id
and ifmm_3.image_size_id = __image_size_f_id
and ifmm_3.id_value = fm_3.firm_id
left join action ac_fm_3 on ac_fm_3.action_id = a_mpn.f_map_3_action_id
left join action_type act_fm_3 on act_fm_3.action_type_id = ac_fm_3.action_type_id
left join firm fm_4 on fm_4.firm_id = a_mpn.f_map_4_id
left join drugstore d_fm_4 on d_fm_4.drugstore_id = fm_4.drugstore_id
left join image ifmm_4 on ifmm_4.image_type_id = __image_type_f_id
and ifmm_4.image_size_id = __image_size_f_id
and ifmm_4.id_value = fm_4.firm_id
left join action ac_fm_4 on ac_fm_4.action_id = a_mpn.f_map_4_action_id
left join action_type act_fm_4 on act_fm_4.action_type_id = ac_fm_4.action_type_id
left join firm fm_5 on fm_5.firm_id = a_mpn.f_map_5_id
left join drugstore d_fm_5 on d_fm_5.drugstore_id = fm_5.drugstore_id
left join image ifmm_5 on ifmm_5.image_type_id = __image_type_f_id
and ifmm_5.image_size_id = __image_size_f_id
and ifmm_5.id_value = fm_5.firm_id
left join action ac_fm_5 on ac_fm_5.action_id = a_mpn.f_map_5_action_id
left join action_type act_fm_5 on act_fm_5.action_type_id = ac_fm_5.action_type_id
left join firm fo_1 on fo_1.firm_id = a_mpn.f_order_1_id
left join drugstore d_fo_1 on d_fo_1.drugstore_id = fo_1.drugstore_id
left join image ifom_1 on ifom_1.image_type_id = __image_type_f_id
and ifom_1.image_size_id = __image_size_f_id
and ifom_1.id_value = fo_1.firm_id
left join action ac_fo_1 on ac_fo_1.action_id = a_mpn.f_order_1_action_id
left join action_type act_fo_1 on act_fo_1.action_type_id = ac_fo_1.action_type_id
left join drugstore_department dd_fo_1 on dd_fo_1.drugstore_department_id = a_mpn.f_order_1_dds_id
left join drugstore d_dd_fo_1 on d_dd_fo_1.drugstore_id = dd_fo_1.drugstore_id
left join firm fo_2 on fo_2.firm_id = a_mpn.f_order_2_id
left join drugstore d_fo_2 on d_fo_2.drugstore_id = fo_2.drugstore_id
left join image ifom_2 on ifom_2.image_type_id = __image_type_f_id
and ifom_2.image_size_id = __image_size_f_id
and ifom_2.id_value = fo_2.firm_id
left join action ac_fo_2 on ac_fo_2.action_id = a_mpn.f_order_2_action_id
left join action_type act_fo_2 on act_fo_2.action_type_id = ac_fo_2.action_type_id
left join drugstore_department dd_fo_2 on dd_fo_2.drugstore_department_id = a_mpn.f_order_2_dds_id
left join drugstore d_dd_fo_2 on d_dd_fo_2.drugstore_id = dd_fo_2.drugstore_id
left join firm fo_3 on fo_3.firm_id = a_mpn.f_order_3_id
left join drugstore d_fo_3 on d_fo_3.drugstore_id = fo_3.drugstore_id
left join image ifom_3 on ifom_3.image_type_id = __image_type_f_id
and ifom_3.image_size_id = __image_size_f_id
and ifom_3.id_value = fo_3.firm_id
left join action ac_fo_3 on ac_fo_3.action_id = a_mpn.f_order_3_action_id
left join action_type act_fo_3 on act_fo_3.action_type_id = ac_fo_3.action_type_id
left join drugstore_department dd_fo_3 on dd_fo_3.drugstore_department_id = a_mpn.f_order_3_dds_id
left join drugstore d_dd_fo_3 on d_dd_fo_3.drugstore_id = dd_fo_3.drugstore_id
left join firm fo_4 on fo_4.firm_id = a_mpn.f_order_4_id
left join drugstore d_fo_4 on d_fo_4.drugstore_id = fo_4.drugstore_id
left join image ifom_4 on ifom_4.image_type_id = __image_type_f_id
and ifom_4.image_size_id = __image_size_f_id
and ifom_4.id_value = fo_4.firm_id
left join action ac_fo_4 on ac_fo_4.action_id = a_mpn.f_order_4_action_id
left join action_type act_fo_4 on act_fo_4.action_type_id = ac_fo_4.action_type_id
left join drugstore_department dd_fo_4 on dd_fo_4.drugstore_department_id = a_mpn.f_order_4_dds_id
left join drugstore d_dd_fo_4 on d_dd_fo_4.drugstore_id = dd_fo_4.drugstore_id
left join firm fo_5 on fo_5.firm_id = a_mpn.f_order_5_id
left join drugstore d_fo_5 on d_fo_5.drugstore_id = fo_5.drugstore_id
left join image ifom_5 on ifom_5.image_type_id = __image_type_f_id
and ifom_5.image_size_id = __image_size_f_id
and ifom_5.id_value = fo_5.firm_id
left join action ac_fo_5 on ac_fo_5.action_id = a_mpn.f_order_5_action_id
left join action_type act_fo_5 on act_fo_5.action_type_id = ac_fo_5.action_type_id
left join drugstore_department dd_fo_5 on dd_fo_5.drugstore_department_id = a_mpn.f_order_5_dds_id
left join drugstore d_dd_fo_5 on d_dd_fo_5.drugstore_id = dd_fo_5.drugstore_id
where
mpn.medical_product_name_id = __medical_product_name_id"
PL/pgSQL function p_get_lp_main_data(integer,integer) line 202 at SQL statement
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.