0 items in your cart | View Cart
888-LIVER01 (548-3701)
You are here: Home PageDistributor Info

Distributor Info

If you are interested in distributing EThistle™ or would like to learn
more, please contact us via email at the following:

Retailer/Wholesaler inquiries: Contact us via email at:
Physician/Medical Office(s) wholesale@casslabs.com

United States Chain Stores/Distributors (Drug, Health, Vitamin, Convenience, Grocery) distribution@casslabs.com

International Distribution Inquiries international@casslabs.com

 

 

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'betterli_clmaster.ax.sort_order' which is not in SELECT list; this is incompatible with DISTINCT

select distinct a.products_id, a.products_image, ad.products_name from articles_xsell ax, products a, products_description ad where ax.articles_id = '37' and ax.xsell_id = a.products_id and a.products_id = ad.products_id and ad.language_id = '1' and a.products_status = '1' order by ax.sort_order asc limit 6

[TEP STOP]