Accurate as of Sun. June 24, 2018. Please be sure to place all orders within a day to ensure as much product availability as possible. Our fax number is 978-282-8812.

Ship To: ________________________________________    Today's Date: __________    Ship Date: __________
Address: ________________________________________    Telephone: __________________
City: __________________________,   ____   __________    Email: __________________

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND ( wholesale_retail="W" OR wholesale_retail="B" ) AND (' at line 1
SELECT product_options.*, abs(substring(item_code, 2)) as just_numbers FROM product_options LEFT JOIN inventory_items USING(item_code) WHERE product_id= AND ( wholesale_retail="W" OR wholesale_retail="B" ) AND ("y" AND inventory_items.on_hand >= 12) AND back_order="n" ORDER BY option_sort_value, option_name

Color/Stock#Qty. Color/Stock#Qty. Color/Stock#Qty.