Caudalie

{"api_key":0,"limit":21,"count":3,"total":45,"page":1,"prev":false,"next":"/brands/caudalie/page=2","rows":[{"num":1,"href":"/brands/caudalie","active":true},{"num":2,"href":"/brands/caudalie/page=2","active":false},{"num":3,"href":"/brands/caudalie/page=3","active":false}],"hash":{},"opt":{"count":1,"sql1":1,"order":"is_image,cdate desc","page":1,"limit":21,"query":"price_sql is not null and producer=''3789'' and enabled","opd_id":"3789","tag":"aptekar_catalog","table":"(select * from crm_order.product t left join lateral (select max(price) as price_sql from crm_order.product_price where product_id=t.product_id) price_sql on 1=1 left join lateral (select (case when image is not null then true else false end) as is_image) is_image on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where product_id=t.product_id) product_partition on 1=1 )q","path":"/brands/caudalie","query_text":"price_sql is not null and producer=''{{opt.opd_id}}'' and enabled","_table":"site.aptekar.product.table","table_text":"(select * from crm_order.product t left join lateral (select max(price) as price_sql from crm_order.product_price where product_id=t.product_id) price_sql on 1=1 left join lateral (select (case when image is not null then true else false end) as is_image) is_image on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where product_id=t.product_id) product_partition on 1=1 )q","_id":"kr6nJt5KOcBINO6EA-RcJRXtXvY-","table_q":"(select * from crm_order.product t left join lateral (select max(price) as price_sql from crm_order.product_price where product_id=t.product_id) as price_sql on 1=1 left join lateral (select (case when image is not null then true else false end) as is_image) as is_image on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where product_id=t.product_id) as product_partition on 1=1 where true)q"},"domain":"aptekar.ua","req":{"query":{}}}