Apivita

{"api_key":42158,"limit":21,"count":8,"total":155,"page":1,"prev":false,"next":"/brands/apivita-1836365461718042415/page-2","rows":[{"num":1,"href":"/brands/apivita-1836365461718042415","active":true},{"num":2,"href":"/brands/apivita-1836365461718042415/page-2","active":false},{"num":3,"href":"/brands/apivita-1836365461718042415/page-3","active":false},{"dots":true},{"num":6,"href":"/brands/apivita-1836365461718042415/page-6","active":false},{"num":7,"href":"/brands/apivita-1836365461718042415/page-7","active":false},{"num":8,"href":"/brands/apivita-1836365461718042415/page-8","active":false}],"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=''1836365461718042415''","dep_id":"1729067170811348477,2053240826653312345,1763862540078548070,1729057592010868192,1729060246619424237,53,37,39,2590929811400557898,1866165193503934313,67,1729058062544668131,36,1729053535741412827,1867686516696811169,6,21,31,5,66,1729058787479782890,12,1728453399264887870,2590928691043239231,1729066156200822267,38,1,24,1729062598164350453,8,1729055826007557598,4,14,2410945461390149537,2007419976218052158,2592304669371926389,1729056567812163039,1729068784645309953,2648618338132952748,1858054247061391091,1729064871384843770,2669769227115693069,63,1729069163592287746,1729059785346647532,2266863334118655206","opd_id":"1836365461718042415","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,21,31,5,66,1729058787479782890,12,1728453399264887870,2590928691043239231,1729066156200822267,38,1,24,1729062598164350453,8,1729055826007557598,4,14,2410945461390149537,2007419976218052158,2592304669371926389,1729056567812163039,1729068784645309953,2648618338132952748,1858054247061391091,1729064871384843770,2669769227115693069,63,1729069163592287746,1729059785346647532,2266863334118655206 }'' )) 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":"plGcxX-3wUOOEOo0Fy03jmXlG30-","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,21,31,5,66,1729058787479782890,12,1728453399264887870,2590928691043239231,1729066156200822267,38,1,24,1729062598164350453,8,1729055826007557598,4,14,2410945461390149537,2007419976218052158,2592304669371926389,1729056567812163039,1729068784645309953,2648618338132952748,1858054247061391091,1729064871384843770,2669769227115693069,63,1729069163592287746,1729059785346647532,2266863334118655206 }'' )) as price_json from crm_order.product q)w)q","search_column":null},"domain":"aptekar.ua","uuid":"u09FKEqh6vP","req":{"query":{}}}