АЛІФАРМ

{"api_key":41953,"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=''2076727352196335343''","dep_id":"1729067170811348477,2053240826653312345,1763862540078548070,1729057592010868192,1729060246619424237,53,37,39,2590929811400557898,1866165193503934313,67,1729058062544668131,36,1729053535741412827,1867686516696811169,6,2266863334118655206,21,31,5,66,1729058787479782890,12,1728453399264887870,2590928691043239231,1729066156200822267,38,1,24,1729062598164350453,8,1729055826007557598,4,14,1729059785346647532,2410945461390149537,2007419976218052158,2592304669371926389,1729056567812163039,1729068784645309953,2648618338132952748,1858054247061391091,1729064871384843770,2669769227115693069","opd_id":"2076727352196335343","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(''{ 1729067170811348477,2053240826653312345,1763862540078548070,1729057592010868192,1729060246619424237,53,37,39,2590929811400557898,1866165193503934313,67,1729058062544668131,36,1729053535741412827,1867686516696811169,6,2266863334118655206,21,31,5,66,1729058787479782890,12,1728453399264887870,2590928691043239231,1729066156200822267,38,1,24,1729062598164350453,8,1729055826007557598,4,14,1729059785346647532,2410945461390149537,2007419976218052158,2592304669371926389,1729056567812163039,1729068784645309953,2648618338132952748,1858054247061391091,1729064871384843770,2669769227115693069 }'' )) 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":"bOKr7Dunk-xlfFGgRusUJR8pfBc-","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(''{ 1729067170811348477,2053240826653312345,1763862540078548070,1729057592010868192,1729060246619424237,53,37,39,2590929811400557898,1866165193503934313,67,1729058062544668131,36,1729053535741412827,1867686516696811169,6,2266863334118655206,21,31,5,66,1729058787479782890,12,1728453399264887870,2590928691043239231,1729066156200822267,38,1,24,1729062598164350453,8,1729055826007557598,4,14,1729059785346647532,2410945461390149537,2007419976218052158,2592304669371926389,1729056567812163039,1729068784645309953,2648618338132952748,1858054247061391091,1729064871384843770,2669769227115693069 }'' )) as price_json from crm_order.product q)w)q","search_column":null},"domain":"aptekar.ua","uuid":"uFfch9A3WRx","req":{"query":{}}}