Boehringer Ingelheim
Фильтры
1064.8,
"1380"
487.9,
"4622"
289.4,
"4622"
364.4,
"4622"
90.7,
"6217"
317.7,
"5222"
312.5,
"5222"
219.1,
"1945"
156.1,
"6217"
368.1,
"1945"
113.2,
"5992"
188.1,
"1945"
130.9,
"4566"
88.6,
"5992"
378.9,
"5190"
Сортировка по:
{"api_key":0,"limit":21,"count":1,"total":15,"page":1,"prev":false,"next":false,"rows":[{"num":1}],"hash":{},"opt":{"count":1,"sql1":1,"order":"is_image,cdate desc","page":1,"limit":21,"query":"iscategory=false and price is not null and producer=''2267608691752567908'' and enabled","opd_id":"2267608691752567908","tag":"aptekar_catalog","table":"(select * from crm_order.product t left join lateral (select user_data->>''morion_code'' as morion_code) morion_code on 1=1 left join lateral (select max(price) as price_sql from crm_order.product_price where product_id=t.product_id and cdate=(select max(cdate) from crm_order.product_price where product_id=t.product_id)) price_sql on 1=1 left join lateral (select (case when image is not null then true else false end) as is_image) is_image on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where product_id=t.product_id) product_partition on 1=1 left join lateral (select count(*) as count_childrens, json_agg(jsonb_build_object(''alias'', alias, ''product_name'', product_name, ''localization'', localization)) as childrens from crm_order.product where parent_id=t.product_id) children_products on 1=1 )q","path":"/brands/boehringer-ingelheim-2267608691752567908","query_text":"iscategory=false and price is not null and producer=''{{opt.opd_id}}'' and enabled","_table":"site.aptekar.product.table","table_text":"(select * from crm_order.product t left join lateral (select user_data->>''morion_code'' as morion_code) morion_code on 1=1 left join lateral (select max(price) as price_sql from crm_order.product_price where product_id=t.product_id and cdate=(select max(cdate) from crm_order.product_price where product_id=t.product_id)) price_sql on 1=1 left join lateral (select (case when image is not null then true else false end) as is_image) is_image on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where product_id=t.product_id) product_partition on 1=1 left join lateral (select count(*) as count_childrens, json_agg(jsonb_build_object(''alias'', alias, ''product_name'', product_name, ''localization'', localization)) as childrens from crm_order.product where parent_id=t.product_id) children_products on 1=1 )q","_id":"A8PsHfxvKbJkLPEQALTjutuMvAY-","table_q":"(select * from crm_order.product t left join lateral (select user_data->>''morion_code'' as morion_code) as morion_code on 1=1 left join lateral (select max(price) as price_sql from crm_order.product_price where product_id=t.product_id and cdate=(select max(cdate) from crm_order.product_price where product_id=t.product_id)) as price_sql on 1=1 left join lateral (select (case when image is not null then true else false end) as is_image) as is_image on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where product_id=t.product_id) as product_partition on 1=1 left join lateral (select count(*) as count_childrens, json_agg(jsonb_build_object(''alias'', alias, ''product_name'', product_name, ''localization'', localization)) as childrens from crm_order.product where parent_id=t.product_id) as children_products on 1=1 where enabled and product_id in (select product_id from crm_order.product_price where price is not null))q"},"domain":"aptekar.ua","req":{"query":{}}}