loader
STORE-
SELECT * FROM `promos_store` WHERE FIND_IN_SET(1,`sales_channel`) AND FIND_IN_SET('1',`target_customer_groups`) AND `start_date` < '1758237415' AND (`end_date` = '0' OR `end_date` > '1758237415')


PRODUCT-
SELECT * FROM `promos_products` WHERE FIND_IN_SET(1, `sales_channel`) AND FIND_IN_SET('1',`target_customer_groups`) AND `start_date` < '1758237415' AND (`end_date` = '0' OR `end_date` > '1758237415')


Showing 1–4 of 4 products
Sort by
Filter
CATGEORY-
SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.1", `categories`) OR FIND_IN_SET("1.82", `categories`) OR FIND_IN_SET("1.1.50", `categories`) OR FIND_IN_SET("1.82.83", `categories`) ) AND `start_date` < '1758237415' AND (`end_date` = 0 OR `end_date` > '1758237415') AND FIND_IN_SET('1', `target_customer_groups`)


CATGEORY-
SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.1", `categories`) OR FIND_IN_SET("1.1.50", `categories`) ) AND `start_date` < '1758237415' AND (`end_date` = 0 OR `end_date` > '1758237415') AND FIND_IN_SET('1', `target_customer_groups`)


CATGEORY-
SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.1", `categories`) OR FIND_IN_SET("1.1.50", `categories`) ) AND `start_date` < '1758237415' AND (`end_date` = 0 OR `end_date` > '1758237415') AND FIND_IN_SET('1', `target_customer_groups`)


CATGEORY-
SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.1", `categories`) OR FIND_IN_SET("1.1.50", `categories`) ) AND `start_date` < '1758237415' AND (`end_date` = 0 OR `end_date` > '1758237415') AND FIND_IN_SET('1', `target_customer_groups`)


my account

my setting