Advanced Vital Enzymes
Фильтры
111.7,
"23343"
111.6,
"23343"
209,
"23343"
210,
"23343"
210.9,
"23343"
77.7,
"23343"
142.2,
"23343"
Сортировка по:
{"api_key":0,"limit":21,"count":1,"total":7,"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=''2385666536422508172'' and enabled","opd_id":"2385666536422508172","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/advanced-vital-enzymes","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":"KWcNLr6188MwdH1bQi9c8u3xUag-","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":{}}}