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


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


Showing 1–15 of 15 products
Sort by
Filter
CATGEORY-
SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


product
on sale
  • $8.39
  • $11.98
  • 2 Styles
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $5.59
  • $7.99
  • 4 Styles
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.2.103", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $11.89
  • $19.99
  • 4 Styles
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.2.103", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $11.89
  • $19.99
  • 5 Styles
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.105", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.105", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
    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.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.1.7", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $41.99
  • $59.99
  • 3 Styles
    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.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.1.7", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $11.89
  • $19.99
  • 40 Styles
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $11.19
  • $19.99
  • 4 Styles
    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.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.1.7", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
    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.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.1.7", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $11.89
  • $19.99
  • 58 Styles
    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.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.1.8", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $41.99
  • $59.99
  • 16 Styles
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.105", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.105", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $6.99
  • $9.99
  • 6 Styles
    CATGEORY-
    SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.81", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.105", `categories`) OR FIND_IN_SET("1.2.104", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237576' AND (`end_date` = 0 OR `end_date` > '1758237576') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale

    my account

    my setting