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


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


Showing 1–30 of 41 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.2", `categories`) OR FIND_IN_SET("1.1.7", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


product
  • $29.99
    • 10 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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $59.99
    • 1 Style
    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.85", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $12.59
  • $24.99
    • 1 Style
    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.1.7", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $32.99
    • 7 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.1.5", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $30.99
    • 14 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.1.7", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $30.99
    • 13 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.1.7", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $64.99
    • 2 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.85", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $38.49
  • $54.99
    • 1 Style
    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.1.7", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $64.99
    • 1 Style
    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.85", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $90.99
  • $129.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.85", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $38.49
  • $54.99
    • 1 Style
    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.85", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $48.99
  • $69.99
    • 1 Style
    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.85", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
    on sale
  • $38.49
  • $54.99
    • 1 Style
    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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $49.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.1.8", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $69.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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $59.99
    • 1 Style
    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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $24.99
    • 1 Style
    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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $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.14", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $39.99
    • 11 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.1.7", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $29.99
    • 5 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.1.7", `categories`) OR FIND_IN_SET("1.2.116", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $100.00
    • 1 Style
    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.1.7", `categories`) OR FIND_IN_SET("1.2.116", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $100.00
    • 1 Style
    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.1.7", `categories`) OR FIND_IN_SET("1.2.116", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $199.99
    • 1 Style
    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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $29.99
    • 1 Style
    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.1.7", `categories`) OR FIND_IN_SET("1.2.85", `categories`) OR FIND_IN_SET("1.2.102", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $14.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.1.8", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $49.99
    • 7 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.1.7", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $54.99
    • 1 Style
    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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $24.99
    • 1 Style
    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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $24.99
    • 1 Style
    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.1.8", `categories`) OR FIND_IN_SET("1.2.85", `categories`) ) AND `start_date` < '1758237768' AND (`end_date` = 0 OR `end_date` > '1758237768') AND FIND_IN_SET('1', `target_customer_groups`)


    product
  • $59.99
    • 2 Styles

    my account

    my setting