SELECT DISTINCT a.idProduct, a.SKU,a.potency,a.quantity,a.Description, a.DescriptionLong,a.ListPrice, a.Price,a.SmallImageUrl,a.Stock, a.fileName,a.noShipCharge FROM products a, categories_products b WHERE a.idProduct = b.idProduct AND b.idCategory = 87 AND a.active = -1 ORDER BY a.description
No records were found matching your request.
|