Знайдіть свій розмір разом з нашим повним довідником розмірів.
Довідник розмірів
Тип фігури
Об’єм грудей, см
Об’єм талії, см
Об’єм бедер, см
S
79-87
60-67
85-92
M
87-95
67-74
92-99
L
95-103
74-81
99-106
Груди
Оберніть сантиметр навколо об'ємної частини грудей, наполовину вдихніть і зафіксуйте об'єм.
Талія
Оберніть сантиметр навколо найтоншої частини талії. Стрічка паралельно підлозі.
Бедра
Оберніть стегна у точках, що найбільш виступають. Ноги разом, стрічка паралельно підлозі.
Нижче подана інформація за типами фігури.
Трикутник (Груша)
Витончені вузькі плечі та талія, добре виділяются стегна.
Перевернутий трикутник (Т-силует)
Характерні широкі плечі і відносно вузькі стегна (наприклад, 95 і 90 сантиметрів відповідно).
Коло (Яблуко)
Мають прямий силует без вираженої талії. Основна частина об’єму знаходиться у верхній частині тіла.
Прямокутник
Рівні за обсягом груди та стегна, а талія виражена слабо або не виражена зовсім.
Пісковий годинник
Особливостями X-подібного силуету є гармонія пропорцій грудей, талії і стегон. Талія добре виражена, плечі та стегна виділяються.
Опис
Ті самі резинки для спорту, що не врізаються у тіло, гарно розтягуються і змусять м’язи палати під час кожного підходу.
Підійдуть для занять спортом вдома чи у спортзалі
Матеріал: нейлон та шкіра, мають зсередини силіконові стрічки
Розмір: 76*8*0.2cm
Колір: блакитний, графітовий та бежевий
Використання та догляд
Використання: уникайте подряпин гострими та твердими предметами.
Очищення: наберіть воду у будь-яку ємність та додайте краплю рідини для миття посуду. Зволожте брудну ділянку губкою, приберіть зайву вологу та протріть сухою ганчіркою.
Сушіння: розкладіть резинки на сушці у горизонтальному положенні, уникаючи прямого потрапляння сонця.
Зберігання: радимо зберігати резинки у місці, де немає прямих сонячних променів.
Повернення та обмін
Повернути чи обміняти товар належної якості можна протягом 14 днів з моменту покупки або отримання посилки. Для цього потрібно звернутися у Відділ турботи. Зверніть увагу, що поверненню та обміну підлягають речі без слідів носіння, плям, пошкоджень тощо. Вартість доставки сплачує покупець.
Технологія
Резинки створені з нейлону та шкіри, з використанням силіконових стрічок всередині. Це дозволяє їм гарно фіксуватися на ногах та не ковзати. Резинки не перетискають шкіру і не залишають болісних відчуттів під час тренування. Мають три рівня складності, завдяки цьому підійдуть як для початківців, так і для профі.
Матеріал резинок дуже міцний, тому вони не порвуться під час користування.
Ми будемо тримати вас у курсі усіх новин та пропозицій, аби ви нічого не пропустили
ЗАЛИШТЕ EMAIL ТА ОТРИМАЙТЕ ЗНИЖКУ 10%
YOUR COOKIE PREFERENCES
Continue without accepting
You can change your preferences at any time by going to the "Cookies" module or to the "Privacy Policy" sub-section of the "LEGAL & PRIVACY" section. They are accessible through links at the bottom of any eu.sistersaroma.com website page.
select `code`, `domen`, `systems_store`.`store_id`, (SELECT `code` FROM `language` WHERE `id` = systems_store.language_default) as language_default from `systems_store` leftjoin `store_language` on `store_language`.`store_id` = `systems_store`.`store_id` leftjoin `language` on `language`.`id` = `store_language`.`language_id` where (SELECT `code` FROM `language` WHERE `id` = systems_store.language_default) <> `language`.`code` OR `systems_store`.`store_id` =4
select IFNULL(CONCAT(products.id,"_",products_options.option_id,"_",products_options.value_id),CONCAT(products.id,"_","_")) as id, IFNULL(CONCAT(products.id,"_",products_options.option_id,"_",products_options.value_id),CONCAT(products.id,"_","_")) as product_id, `products_descriptions`.`name`, `products_options`.`option_id`, `products_options`.`value_id`, `products`.`type_product`, IF(products.show =1, 1,(SELECTCOUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, `products`.`sort` as `index`, `products_descriptions`.`name` as `alt`, IFNULL(products_options.articl,(SELECT vendor FROM `products_store` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` LIMIT 1)) as articl , concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) LIMIT 1),"/",`products_store`.`url`,"/") as link, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as item_list_name, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) as category_id, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) as item_list_id, (SELECT `pl_available` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) LIMIT 1) as pl_available, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, "0" as quantity, "₴" as currency, IFNULL(
(SELECT `sell_id` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `sale_id` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1)
) as sell_id, IFNULL(products_options.weight,products_store.weight) as weight, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price, IFNULL(
(SELECT `bonus` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1),
(SELECT `bonus` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
) as bonus, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax, ROUND(IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
)) as sell_price, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "cart" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"") as cart, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover from `products` leftjoin `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` leftjoin `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` =1)) leftjoin `products_store` on `products_store`.`product_id` = `products`.`id` where (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1) and1<>1groupby IFNULL(CONCAT(products.id,"_",products_options.option_id,"_",products_options.value_id),CONCAT(products.id,"_","_"))
select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show =1, 1,(SELECTCOUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product =4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECTCOUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as item_list_name, (SELECTAVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECTCOUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" ORDERBY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` leftjoin `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` leftjoin `products_store` on `products_store`.`product_id` = `products`.`id` leftjoin `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` =1)) leftjoin `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` =1)) where (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and `products_store`.`available` =1and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) >0) and0=1and (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and IFNUll( IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1)
), 0) <>0) orderby `products_options`.`sort` asc
select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show =1, 1,(SELECTCOUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product =4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECTCOUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as item_list_name, (SELECTAVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECTCOUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" ORDERBY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax, (SELECT `available` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category_available, (SELECTCount(*) FROM `categories_role` WHERE categories_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category_role_available, (SELECTCount(*) FROM `product_role` WHERE product_id = `products`.`id`) as product_role_available, ROUND(IFNULL(
(SELECT TIMESTAMPDIFF(SECOND, NOW(), `end`) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT TIMESTAMPDIFF(SECOND, NOW(), `end`) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
)) as sell_time, IF(products_store.products_status =8,(SELECTCOUNT(*) FROM `promo_code` WHERE `date_start` >= products_store.local_start AND `date_start` <= products_store.local_end)*3,0) as local_count, products_store.color_products from `products` leftjoin `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` leftjoin `products_store` on `products_store`.`product_id` = `products`.`id` leftjoin `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` =1)) leftjoin `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` =1)) where (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and `products_store`.`available` =1and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) >0) and (`products_store`.`url` ='rezinki-dlya-sportu'and (SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) ='sisters-sport') orderby `products_options`.`sort` asc, `quantityMax` desc limit 1
select `timer_descriptions`.`description` as `countdown_text_title`, `timers`.`status_time`, `timers`.`color_text`, `timers`.`color_bg`, TIMESTAMPDIFF(SECOND, NOW(), `timers`.`time_end`) as countdown_time, IFNULL(concat(product_id,"_",option_id,"_",value_id),concat(product_id,"__")) as id_product from `timers` leftjoin `timer_descriptions` on `timer_descriptions`.`timer_id` = `timers`.`id` leftjoin `timer_products` on `timer_products`.`product_id` = "589" where (`timers`.`status` =1and `timers`.`store_id` =1and `timers`.`time_start` <='2025-04-08 05:32:26'and `timers`.`time_end` >='2025-04-08 05:32:26'and `timer_descriptions`.`language_id` =1) and ( "589" IN (SELECT `product_id` FROM `timer_products` WHERE `timer_id` = `timers`.`id` )OR "110" IN (SELECT `category_id` FROM `timer_categories` WHERE `timer_id` = `timers`.`id` )OR "65" IN (SELECT `category_id` FROM `timer_categories` WHERE `timer_id` = `timers`.`id` )OR "125" IN (SELECT `category_id` FROM `timer_categories` WHERE `timer_id` = `timers`.`id` )OR "58" IN (SELECT `category_id` FROM `timer_categories` WHERE `timer_id` = `timers`.`id` ))
select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show =1, 1,(SELECTCOUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product =4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECTCOUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as item_list_name, (SELECTAVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECTCOUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" ORDERBY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` leftjoin `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` leftjoin `products_store` on `products_store`.`product_id` = `products`.`id` leftjoin `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` =1)) leftjoin `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` =1)) where (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and `products_store`.`available` =1and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) >0) and `products`.`id` in ('583', '586', '588', '609') and (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and IFNUll( IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1)
), 0) <>0) orderby `products_options`.`sort` asc
select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show =1, 1,(SELECTCOUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product =4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECTCOUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as item_list_name, (SELECTAVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECTCOUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" ORDERBY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` leftjoin `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` leftjoin `products_store` on `products_store`.`product_id` = `products`.`id` leftjoin `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` =1)) leftjoin `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` =1)) where (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and `products_store`.`available` =1and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) >0) and `products`.`id` in (589) and `products`.`id` <>589and (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and IFNUll( IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1)
), 0) <>0) orderby `products_options`.`sort` asc
select*from `reviews_filter_value` leftjoin `reviews_filter_value_description` on `reviews_filter_value_description`.`value_id` = `reviews_filter_value`.`id` where (`reviews_filter_value_description`.`language_id` =1) and `value_id` IN (SELECT `reviews_value_id` FROM `reviews_value`
WHERE `review_id` = (SELECT `id` FROM `reviews` WHERE `product_id` = "589__" AND `type_id` =1AND `answer_id` =0AND `store_id` = "1" AND `language_id` = "1" LIMIT 1)) and `parent_id` IN (SELECT `reviews_filter_id` FROM `reviews_value`
WHERE `review_id` = (SELECT `id` FROM `reviews` WHERE `product_id` = "589__" AND `type_id` =1AND `answer_id` =0AND `store_id` = "1" AND `language_id` = "1" LIMIT 1))
select `id` from `categories` whereexists (select*from `categories_store` where `categories`.`id` = `categories_store`.`categorie_id` and (`store_id` =1and `available` =1)) and (`stock` isnulland `status` =1and `parent` =0) and `id` notin (select `categories_id` from `categories_role` where `role` =3or `role` ='60') and `id` <>21
selectcount(*) as aggregate from `categories` where (`id` =17and `status` =1and (SELECT `available` FROM `categories_store` WHERE `categorie_id` =17AND `store_id` = "1") =1)
select IFNULL(CONCAT(products.id,"_",`products_options`.`option_id`,"_",`products_options`.`value_id`),CONCAT(products.id,"_","_")) as id, `products`.`id` as `product_id`, `products`.`sort`, IF(products.show =1, 1,(SELECTCOUNT(*) FROM `product_role` WHERE `product_id` = products.id AND `role` IN (3,60))) as not_show, IF(products.type_product =4, 1,0) as notAddToCard, `stikers_descriptions`.`title` as `custom_label`, `stikers_descriptions`.`custom_label_size`, `stikers_descriptions`.`custom_label_size_mob`, `stikers_descriptions`.`sub_title` as `custom_label_sub`, `stikers_descriptions`.`custom_label_sub_size`, `stikers_descriptions`.`custom_label_sub_size_mob`, `stikers_descriptions`.`text_color` as `custom_label_color`, `stikers_descriptions`.`text_stiker` as `custom_label_background`, `products`.`date_edit` as `date`, `products_descriptions`.`name`, `products_descriptions`.`seo_title`, `products_descriptions`.`seo_description`, `products_descriptions`.`title_description`, `products_store`.`color`, `products_store`.`products_status` as `labelType`, "" as opt, REPLACE((SELECT `name` FROM `product_status_description` WHERE `status_id` = `products_store`.`products_status` AND `store_id` = "1" AND `language_id` = "1" LIMIT 1), "(Local)", "") as labelText, products_options.id as value_id, "" as mob_url, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/",`products_store`.`url`,"/") as link, concat("/",(SELECT `url` FROM `categories_store` WHERE categories_store.store_id = products_descriptions.store_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)),"/") as link_cat, products_store.credit, products_store.qty_products_set, products_store.recommen_products as recommend, products.type_product, products_descriptions.seconde_description , (SELECTCOUNT(*) FROM `users_favorites` WHERE `product_id` = `products`.`id` AND `user_id` = "0") as favorite, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as item_list_name, (SELECTAVG(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_star, (SELECTCOUNT(`rating`) FROM `reviews` WHERE `reviews`.`product_id` = `products`.`id` AND `reviews`.`type_id` =1AND `reviews`.`status` = "1" AND `reviews`.`store_id` = "1" AND `reviews`.`language_id` = "1" ) as reviews_count, (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1 LIMIT 1) as item_list_id, (SELECT `name` FROM `categories_descriptions` WHERE categories_descriptions.store_id = products_descriptions.store_id AND categories_descriptions.language_id = products_descriptions.language_id AND categorie_id = (SELECT `categorie_id` FROM `products_categories` WHERE `product_id` = `products`.`id` AND `type` =1)) as category, "0" as type, products.sort as sort_banner, "0" as alt, "₴" as currency, IFNULL(
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `hidden_sell_sticker` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as hidden_sell_sticker, IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) as price,
IFNULL(IFNULL(
(SELECT `sell_show` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `sell_show` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1)
), 0) as sell_show, IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
IFNULL(
(SELECT GROUP_CONCAT(ROUND(IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`))) ORDERBYstartDESC SEPARATOR ",") FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1ANDend<= "2025-04-08 05:32:26"),
"0"
)
) as old_sell_price, CAST(IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`value`),((`value`/`price`)*100)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
) AS UNSIGNED) as sell_price_proc, ROUND(IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
IFNULL(
(SELECT IF(`type` =1,(`price`-((`price`/100)*`value`)),(`price`-`value`)) FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
"0"
)
)) as sell_price, CONCAT(
(SELECT `name` FROM `option_descriptions` WHERE `language_id` = "1" AND `option_id` = `products_options`.`option_id` LIMIT 1),
":",
(SELECT `name` FROM `option_value_descriptions` WHERE `language_id` = "1" AND `value_id` = `products_options`.`value_id` LIMIT 1)
) as optionName, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "catalog" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as url, IFNULL((SELECT `url` FROM `products_images` WHERE `type` = "main" AND `store_id` = `products_store`.`store_id` AND `product_id` = `products`.`id` LIMIT 1),"/img/no_image.png") as hover, IFNULL(IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" ORDERBY qty DESC LIMIT 1),
IFNULL((SELECT `max_quantity` FROM `product_quantity_role` WHERE `product_id` = `products`.`id` AND `role` = "3" LIMIT 1),(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1))
),0) as quantityMax from `products` leftjoin `products_descriptions` on `products_descriptions`.`product_id` = `products`.`id` leftjoin `products_store` on `products_store`.`product_id` = `products`.`id` leftjoin `products_options` on ((`products_options`.`product_id` = products.id and `products_options`.`store_id` =1)) leftjoin `stikers_descriptions` on ((`stikers_descriptions`.`stiker_id` = products_store.stiker_products and `stikers_descriptions`.`language_id` =1)) where (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and `products_store`.`available` =1and IFNULL(
IFNULL(
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_options_price` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
),
IFNULL(
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" AND `sell_status` =1AND `start` <= "2025-04-08 05:32:26" ANDend>= "2025-04-08 05:32:26" LIMIT 1),
(SELECT `price` FROM `products_price` WHERE `product_id` = `products`.`id` AND `store_id` = `products_store`.`store_id` AND `group_id` = "3" AND `currency_id` = "2" LIMIT 1)
)
) >0) and `products`.`id` in (589) and (`products`.`status` =1and `products_descriptions`.`store_id` =1and `products_descriptions`.`language_id` =1and `products_store`.`store_id` =1and IFNUll( IFNULL(
(SELECT `qty` FROM `products_options_partners_qty` WHERE `product_id` = `products`.`id` AND `product_option_id` = `products_options`.`id` AND `partner_id` = "1" LIMIT 1),
(SELECT `qty` FROM `products_partners_qty` WHERE `product_id` = `products`.`id` AND `partner_id` = "1" LIMIT 1)
), 0) <>0) orderby `products_options`.`sort` asc