Каталент Франсе Бенайм СА (Франція)
Фільтри
Сортування по:
{"api_key":54293,"limit":21,"count":1,"total":2,"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=''2017573617511958140''","dep_id":"2053240826653312345,1729068784645309953,2410945461390149537,1729058062544668131,1866165193503934313,2266863334118655206,2669769227115693069,2740096901364844330,1729053535741412827,1729064871384843770,1729067170811348477,1728453399264887870,1858054247061391091,1729057592010868192,1729059785346647532,2590928691043239231,2648618338132952748,66,1729058787479782890,1729060246619424237,39,63,1729062598164350453,2592304669371926389,2590929811400557898,14,1729066156200822267,2007419976218052158,8,12,1867686516696811169,38,1729056567812163039,67,31,36,1729069163592287746,1,4,5,6,21,37,53,1763862540078548070","opd_id":"2017573617511958140","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,1729068784645309953,2410945461390149537,1729058062544668131,1866165193503934313,2266863334118655206,2669769227115693069,2740096901364844330,1729053535741412827,1729064871384843770,1729067170811348477,1728453399264887870,1858054247061391091,1729057592010868192,1729059785346647532,2590928691043239231,2648618338132952748,66,1729058787479782890,1729060246619424237,39,63,1729062598164350453,2592304669371926389,2590929811400557898,14,1729066156200822267,2007419976218052158,8,12,1867686516696811169,38,1729056567812163039,67,31,36,1729069163592287746,1,4,5,6,21,37,53,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":"S-J4umi6UCbmnFWk1adpUGN-E8c-","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,1729068784645309953,2410945461390149537,1729058062544668131,1866165193503934313,2266863334118655206,2669769227115693069,2740096901364844330,1729053535741412827,1729064871384843770,1729067170811348477,1728453399264887870,1858054247061391091,1729057592010868192,1729059785346647532,2590928691043239231,2648618338132952748,66,1729058787479782890,1729060246619424237,39,63,1729062598164350453,2592304669371926389,2590929811400557898,14,1729066156200822267,2007419976218052158,8,12,1867686516696811169,38,1729056567812163039,67,31,36,1729069163592287746,1,4,5,6,21,37,53,1763862540078548070 }'' )) as price_json from crm_order.product q)w)q","search_column":null},"domain":"aptekar.ua","uuid":"uFZOHoFdmIA","req":{"query":{}}}