Back

SELECT o.options_id AS oid, o.model, o.description, o.us_out_of_stock AS stock, p.name, p.category, p.sh_desc, p.products_id AS pid, lower(p.title) AS title, us_ret AS price, us_ret_s AS special, DATE_FORMAT(c.ETA,'%b. %e/%y') AS ETA FROM products p, options o, prices_us c, categories cat WHERE o.product_id = p.products_id AND full_display = 'yes' AND lower(p.name) REGEXP '^[l-n]' AND p.us_active='yes' AND o.us_active = 'yes' AND c.prices_us_id = o.options_id AND cat.category = p.category ORDER BY cat.order_val, p.category, p.display_order, p.name, o.display_order
PRODUCT LISTING (13 products)
Product
Model
Price
 
Fitness
Latex-Free Tubing Back to Top
TB-S
$29.95
Buy Now! Add to Cart
Medicine Balls Back to Top
MB-02
$19.98
Buy Now! Add to Cart
MB-04
$24.98
Buy Now! Add to Cart
MB-06
$34.98
Buy Now! Add to Cart
MB-08
$39.98
Buy Now! Add to Cart
MB-12
$58.98
Buy Now! Add to Cart
E-MBW
$26.95
$19.95
Buy Now! Add to Cart
Wellness
Massage Balls Back to Top
TPMB
$19.99
Buy Now! Add to Cart
MB-S
$19.99
Buy Now! Add to Cart
MB-6
$3.99
Buy Now! Add to Cart
MB-7
$4.99
Buy Now! Add to Cart
MB-8
$5.99
Buy Now! Add to Cart
MB-9
$6.99
Buy Now! Add to Cart