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.9", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$59.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.5", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$34.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.5", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$24.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.14", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$34.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.8", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$20.99
$39.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.81", `categories`) OR FIND_IN_SET("1.1.8", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.81.97", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$24.99
$34.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.8", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$16.99
$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.5", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$25.98
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.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$29.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.1.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$29.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.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$99.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.1.7", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.102", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$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.8", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$29.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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$39.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.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$34.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.7", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$39.99
8 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.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$14.99
$19.99
6 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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$19.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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$19.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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$14.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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$14.99
$19.99
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.2.95", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.105", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$13.49
1 Style
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.2.95", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.105", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$13.49
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.14", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$29.99
8 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.95", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$34.99
$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.8", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$29.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.16", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$29.99
6 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.81.97", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$29.99
$39.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.81.97", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
$34.99
3 Styles
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.9", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.14", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.95", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
on sale
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.95", `categories`) OR FIND_IN_SET("1.81.97", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.102", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.18", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.12", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.105", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
SELECT * FROM `tcbadmin`.`promos_category` WHERE FIND_IN_SET('1', `sales_channel`) AND ( FIND_IN_SET("1.2", `categories`) OR FIND_IN_SET("1.2.95", `categories`) OR FIND_IN_SET("1.2.78", `categories`) OR FIND_IN_SET("1.2.105", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.14", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.95", `categories`) OR FIND_IN_SET("1.81.93", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
on sale
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`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.16", `categories`) OR FIND_IN_SET("1.2.95", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.81.97", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)
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.81.97", `categories`) ) AND `start_date` < '1758242288' AND (`end_date` = 0 OR `end_date` > '1758242288') AND FIND_IN_SET('1', `target_customer_groups`)