Нутра Мануфектуринг
Фільтри
Сортування по:
{"api_key":44766,"limit":21,"count":null,"total":null,"page":1,"prev":false,"next":false,"rows":[],"hash":{},"opt":{"count":1,"sql1":1,"order":"is_image,ord","page":1,"limit":21,"fields":"*, (case when image is not null then 1 else null end) as is_image","query":"iscategory=false and json_array_length(price_json)>0 and producer=''2242848566127101823''","dep_id":"2053240826653312345,2007419976218052158,1729066156200822267,2669769227115693069,67,2410945461390149537,2740096901364844330,1729068784645309953,39,1729056567812163039,38,1729058062544668131,1866165193503934313,2266863334118655206,2590928691043239231,1729064871384843770,1867686516696811169,1728453399264887870,53,1858054247061391091,1729067170811348477,4,2648618338132952748,21,1729053535741412827,1729058787479782890,8,6,1729059785346647532,1729060246619424237,1729057592010868192,36,63,1,2592304669371926389,14,1729062598164350453,1729069163592287746,66,5,2590929811400557898,12,1763862540078548070","opd_id":"2242848566127101823","tag":"aptekar_catalog","table":"(select *,(select min((v->>''price'')::decimal) from json_array_elements(price_json)v)price from (select product_id, product_name, enabled, image, iscategory, tags, producer, alias, article, localization, ord,parent_id, (select json_agg(row_to_json(b)) from crm_order.product_price b where b.product_id=q.product_id and department_id = any(''{ 2053240826653312345,2007419976218052158,1729066156200822267,2669769227115693069,67,2410945461390149537,2740096901364844330,1729068784645309953,39,1729056567812163039,38,1729058062544668131,1866165193503934313,2266863334118655206,2590928691043239231,1729064871384843770,1867686516696811169,1728453399264887870,53,1858054247061391091,1729067170811348477,4,2648618338132952748,21,1729053535741412827,1729058787479782890,8,6,1729059785346647532,1729060246619424237,1729057592010868192,36,63,1,2592304669371926389,14,1729062598164350453,1729069163592287746,66,5,2590929811400557898,12,1763862540078548070 }'' )) as price_json from crm_order.product q)w)q","query_text":"iscategory=false and json_array_length(price_json)>0 and producer=''{{opt.opd_id}}''","_table":"home_tag_view","table_text":"(select *,(select min((v->>''price'')::decimal) from json_array_elements(price_json)v)price from (select product_id, product_name, enabled, image, iscategory, tags, producer, alias, article, localization, ord,parent_id, (select json_agg(row_to_json(b)) from crm_order.product_price b where b.product_id=q.product_id and department_id = any(''{ {{opt.dep_id}} }'' )) as price_json from crm_order.product q)w)q","_id":"hZ-ExTC1nx3eDum-v0qyHLJCnT8-","limit_base":21,"table_q":"(select *,(select min((v->>''price'')::decimal) from json_array_elements(price_json)v)price from (select product_id, product_name, enabled, image, iscategory, tags, producer, alias, article, localization, ord,parent_id, (select json_agg(row_to_json(b)) from crm_order.product_price b where b.product_id=q.product_id and department_id = any(''{ 2053240826653312345,2007419976218052158,1729066156200822267,2669769227115693069,67,2410945461390149537,2740096901364844330,1729068784645309953,39,1729056567812163039,38,1729058062544668131,1866165193503934313,2266863334118655206,2590928691043239231,1729064871384843770,1867686516696811169,1728453399264887870,53,1858054247061391091,1729067170811348477,4,2648618338132952748,21,1729053535741412827,1729058787479782890,8,6,1729059785346647532,1729060246619424237,1729057592010868192,36,63,1,2592304669371926389,14,1729062598164350453,1729069163592287746,66,5,2590929811400557898,12,1763862540078548070 }'' )) as price_json from crm_order.product q)w)q","search_column":null},"domain":"admin.aptekar.ua","uuid":"uLSz9BsrPLY","req":{"query":{}}}