Order your supplies and pay via secure credit card transaction.
OR
if you have a plan that covers the cost of your supplies, enroll with us—we will file most health plan claims for you, as well as any other paperwork that is required.
Diabetes Products
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'diabetic_mini2minicart.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT
select distinct pd.products_name, pd.products_id, p.products_id,p.manufacturers_id, p.products_image, p.prod_sub, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products_to_categories p2c, products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1' and pd.products_id=p.products_id order by p.products_date_added desc
