
До окончания акции
|- д.
- ч
- мин
С 01.08.2022 по 31.08.2022 акция от ТМ Rilastil*
При покупке любого солнцезащитного средства Rilastil в подарок Спрей для тела после загара.
Адреса аптек, в которых проходит акция:
г. Киев, Столичное шоссе 103 ТЦ "Атмосфера"
г. Бровары, Киевская 316 ТРЦ "Терминал"
г. Киев, Лаврухина 4 ТЦ "Район"
г. Киев, Большая Васильковская 72 ТЦ "Олимпийский"
г. Киев, Тимошенко 18
Детали узнавайте у фармацевтов.
{ "opm_id": "2893351209337358042", "opm_name": "Акция от ТМ \"Rilastil\"", "opm_image": "crm.order/promotion/b2287810-0f8f-11ed-94a0-11182ab0c047.jpeg", "localization": { "ru": { "parent_id": "2893351209337358042", "id": "2893352757840840243", "lang": "ru", "menu_title": "Акция от ТМ \"Rilastil\"", "description": "С 01.08.2022 по 31.08.2022 акция от ТМ Rilastil*
При покупке любого солнцезащитного средства Rilastil в подарок Спрей для тела после загара.
Адреса аптек, в которых проходит акция:г. Киев, Столичное шоссе 103 ТЦ \"Атмосфера\"г. Бровары, Киевская 316 ТРЦ \"Терминал\"г. Киев, Лаврухина 4 ТЦ \"Район\"г. Киев, Большая Васильковская 72 ТЦ \"Олимпийский\"г. Киев, Тимошенко 18Детали узнавайте у фармацевтов.", "title": null, "meta_description": null, "keywords": null, "edit": 0 }, "ua": { "id": "2893362193397450197", "lang": "ua", "menu_title": "Акція від ТМ \"Rilastil\"", "description": "З 01.08.2022 по 31.08.2022 акція від ТМ Rilastil*
При купівлі будь-якого сонцезахисного засобу Rilastil у подарунок Спрей для тіла після засмаги.
Адреси аптек, в яких проходить акція:м. Київ, Столичне шосе 103 ТЦ \"Атмосфера\"м. Бровари, Київська 316 ТРЦ \"Термінал\"м. Київ, Лаврухіна 4 ТЦ \"Район\"м. Київ, Велика Васильківська 72 ТЦ \"Олімпійский\"м. Київ, Тимошенка 18Деталі дізнавайтесь у фармацевтів.*Детальніше про ТМ Rilastil - https://www.instagram.com/rilastilukraine/", "title": null, "meta_description": null, "keywords": null, "edit": 1 } }, "opm_start_date": "2022-08-01T00:00:00", "opm_end_date": "2022-09-01T00:00:00", "opm_type": null, "opm_value": null, "cdate": "2022-07-30T01:53:06.672", "uid": "2614019104377406529", "editor_id": "2614019104377406529", "editor_date": "2022-07-30T02:07:57", "alias": "promotion/akcija-ot-tm-rilastil-2893351209337358042", "enabled": true, "files": { "banner": "crm.order/promotion/b49ab090-0f8f-11ed-a705-f9a69109f0f4.jpeg" }, "ord": null, "id": "akcija-ot-tm-rilastil-2893351209337358042", "_list": { "_id": "akcija-ot-tm-rilastil-2893351209337358042", "_like": 0, "_view": 0 }, "forbidden": false, "model": "crm_order.order_promotion", "alias_key": "akcija-ot-tm-rilastil-2893351209337358042", "template": "promotion", "alias_base": "promotion", "domain": "aptekar.ua", "_lang": "ru", "title": "Акция от ТМ "Rilastil"" }
Акционные препараты, Акция от ТМ "Rilastil"
Фильтры
Сортировка по:
{"api_key":54294,"limit":21,"count":null,"total":null,"page":1,"prev":false,"next":false,"rows":[],"hash":{},"opt":{"count":1,"opm_id":"2893351209337358042","cache":1,"sql1":1,"query":"product_id in (SELECT product_id from crm_order.order_promotion_links where opm_id=''2893351209337358042'' ) and 1=(select 1from crm_order.product_price where product_id=q.product_id limit 1) and iscategory=false and enabled","tag":"catalog_aptekar","limit":21,"order":"image is not null desc,ord","table":"(select a.localization,product_id, product_name, enabled, parent_id, a.tags, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, /*coalesce((select min(price) from crm_order.product_price where product_id=a.product_id ), (select min(price) from crm_order.product_price where product_id=a.product_id )) as price1,*/ (select a.price from crm_order.product_price where product_id=a.product_id and department_id in (select department_id from crm_order.order_department where enabled) limit 1) as price, (select a.price * (100 - (data->>''Discount_percent'')::int) / 100 from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date and data->>''Discount_percent'' is not null order by priority limit 1) as price_discount, (select max(amount) from crm_order.product_price where product_id=a.product_id ) as amount, (select json_agg(row_to_json(z)) from (select * from crm_order.product_price where product_id=a.product_id)z ) as price_json,user_data, (select json_agg(json_build_object(''name'', tipe, ''alias'', alias, ''percent'', data->>''Discount_percent'')) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions, row_to_json(c) as partition from crm_order.product a left join (select ''{ }''::text[] as city_dep) b on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where a.product_id=product_id limit 1)c on 1=1 where a.enabled )q","page":1,"timing1":1,"query_text":"product_id in (SELECT product_id from crm_order.order_promotion_links where opm_id=''{{opt.opm_id}}'' ) and 1=(select 1from crm_order.product_price where product_id=q.product_id limit 1) and iscategory=false and enabled","_table":"product_view","table_text":"(select a.localization,product_id, product_name, enabled, parent_id, a.tags, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, /*coalesce((select min(price) from crm_order.product_price where {{#if opt.city_dep}}department_id = any(b.city_dep) and {{/if}} product_id=a.product_id ), (select min(price) from crm_order.product_price where product_id=a.product_id )) as price1,*/ (select a.price from crm_order.product_price where product_id=a.product_id and department_id in (select department_id from crm_order.order_department where enabled) limit 1) as price, (select a.price * (100 - (data->>''Discount_percent'')::int) / 100 from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date and data->>''Discount_percent'' is not null order by priority limit 1) as price_discount, (select max(amount) from crm_order.product_price where {{#if opt.city_dep}}department_id = any(b.city_dep) and {{/if}} product_id=a.product_id ) as amount, (select json_agg(row_to_json(z)) from (select * from crm_order.product_price where {{#if opt.city_dep}}department_id = any(b.city_dep) and {{/if}} product_id=a.product_id)z ) as price_json,user_data, (select json_agg(json_build_object(''name'', tipe, ''alias'', alias, ''percent'', data->>''Discount_percent'')) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions, row_to_json(c) as partition from crm_order.product a left join (select ''{ {{opt.city_dep}} }''::text[] as city_dep) b on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where a.product_id=product_id limit 1)c on 1=1 where a.enabled )q","_id":"M4RrqJfSDehq68jhAp-afM8OciY-","limit_base":21,"fields":"*","table_q":"(select a.localization,product_id, product_name, enabled, parent_id, a.tags, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, /*coalesce((select min(price) from crm_order.product_price where product_id=a.product_id ), (select min(price) from crm_order.product_price where product_id=a.product_id )) as price1,*/ (select a.price from crm_order.product_price where product_id=a.product_id and department_id in (select department_id from crm_order.order_department where enabled) limit 1) as price, (select a.price * (100 - (data->>''Discount_percent'')::int) / 100 from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date and data->>''Discount_percent'' is not null order by priority limit 1) as price_discount, (select max(amount) from crm_order.product_price where product_id=a.product_id ) as amount, (select json_agg(row_to_json(z)) from (select * from crm_order.product_price where product_id=a.product_id)z ) as price_json,user_data, (select json_agg(json_build_object(''name'', tipe, ''alias'', alias, ''percent'', data->>''Discount_percent'')) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions, row_to_json(c) as partition from crm_order.product a left join (select ''{ }''::text[] as city_dep) b on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where a.product_id=product_id limit 1)c on 1=1 where a.enabled )q","search_column":null},"domain":"aptekar.ua","uuid":"u679oTXQRJ9","req":{"query":{}}}