СКМ Хербосеютикалс
Фильтры
Сортировка по:
{"api_key":45056,"limit":21,"count":1,"total":1,"page":1,"prev":false,"next":false,"rows":[{"num":1}],"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=''3881''","dep_id":"37,2053240826653312345,1729068784645309953,1729058062544668131,1866165193503934313,2266863334118655206,2410945461390149537,2669769227115693069,2740096901364844330,53,1729064871384843770,1728453399264887870,1858054247061391091,1729053535741412827,1729067170811348477,2590928691043239231,2648618338132952748,1729057592010868192,1729059785346647532,1729060246619424237,1729058787479782890,66,1729062598164350453,2592304669371926389,63,39,1763862540078548070,2590929811400557898,5,14,1729066156200822267,4,2007419976218052158,6,8,12,21,38,1729056567812163039,67,1867686516696811169,1,31,36,1729069163592287746","opd_id":"3881","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(''{ 37,2053240826653312345,1729068784645309953,1729058062544668131,1866165193503934313,2266863334118655206,2410945461390149537,2669769227115693069,2740096901364844330,53,1729064871384843770,1728453399264887870,1858054247061391091,1729053535741412827,1729067170811348477,2590928691043239231,2648618338132952748,1729057592010868192,1729059785346647532,1729060246619424237,1729058787479782890,66,1729062598164350453,2592304669371926389,63,39,1763862540078548070,2590929811400557898,5,14,1729066156200822267,4,2007419976218052158,6,8,12,21,38,1729056567812163039,67,1867686516696811169,1,31,36,1729069163592287746 }'' )) 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":"y4SVYrQjy96uZ4iD0-rA8QI10O8-","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(''{ 37,2053240826653312345,1729068784645309953,1729058062544668131,1866165193503934313,2266863334118655206,2410945461390149537,2669769227115693069,2740096901364844330,53,1729064871384843770,1728453399264887870,1858054247061391091,1729053535741412827,1729067170811348477,2590928691043239231,2648618338132952748,1729057592010868192,1729059785346647532,1729060246619424237,1729058787479782890,66,1729062598164350453,2592304669371926389,63,39,1763862540078548070,2590929811400557898,5,14,1729066156200822267,4,2007419976218052158,6,8,12,21,38,1729056567812163039,67,1867686516696811169,1,31,36,1729069163592287746 }'' )) as price_json from crm_order.product q)w)q","search_column":null},"domain":"admin.aptekar.ua","uuid":"uOvoj8q3Ogi","req":{"query":{}}}