SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('60096')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%Towelettes' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Towelettes' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Towelettes' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Towelettes"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Towelettes"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Towelettes"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Towelettes"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Towelettes' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Towelettes',`category_4` ='Towelettes') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Towelettes,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Towelettes', `pinfo`.`desc_title`)) DESC
<
GO
Currently Filtered by
Category
Towelettes
Refine Search
GO
Brand
Crayola(55)
Prang(31)
Cra-Z-Art(2)
Creativity Street(1)
Creative Arts(1)
Packaged Quantity
1 Each(3)
For Use With
Creative Arts 40508 Watercolor Set(1)
Volume Capacity
16 oz(49)
1 gal(15)
2 oz(3)
32 oz(3)
2.2 oz(1)
3 oz(1)
8 oz(1)
1 oz(1)
Paint Color
Phthalo Green(1)
Brilliant Blue(1)
Brilliant Yellow(1)
Chemical Compound
Tempera(3)
Water Based(1)
Paint Volume
16 fl oz(3)
Country of Origin
US(51)
MX(31)
CN(5)
United States(3)
Color(s)
Assorted(14)
Blue(9)
White(8)
Red(7)
Green(7)
Black(7)
Yellow(7)
Orange(6)
Brown(5)
Violet(4)
Magenta(3)
Peach(2)
Turquoise Blue(2)
Titanium White(1)
Assorted Classic(1)
Turquoise(1)
Assorted Bright(1)
Assorted Neon(1)
Assorted Metallic(1)
Packing Type
Bottle(3)
Capacity (Volume)
16 oz(3)
1 gal(1)
Finish
Matte(3)
Age Recommendation
Ages 3 and Up(5)
Ages 5 and Up(2)
Number of Colors
1(65)
8(6)
6(4)
16(3)
12(2)
7(1)
18(1)
3(1)
Search Results 90
Filtered By Sort by
- <
- of 3
- >
Current Page 1 of 3
Result Per Page