Clearance Casters and Glides
----- (mysql): SELECT DISTINCT a.prod_id, a.master_cat, a.prod_type_id, a.prod_subtype_id, a.wheel_dia, b.c4l_price_a, b.c4l_price_w_rigid_a, b.c4l_price_w_swivel_a, b.c4l_clear_a, b.c4l_clear_w_rigid_a, b.c4l_clear_w_swivel_a FROM products AS a, prod_prices AS b WHERE a.prod_id=b.prod_id AND b.c4l_clear_sale_start_date = '2024-04-19' AND (a.master_cat=1 OR a.master_cat=2) ORDER BY a.master_cat ASC, prod_type_id ASC, prod_subtype_id ASC -----We have no clearance items at this time. Please check back, as this can change frequently.