-- apps_master.getProductTerkait (PROCEDURE)
begin
SELECT os.ProductID, ProductName, ProductImage, OutletProductPrice, OutletProductStockQty, ProductDescription,
ProductIndicationUsage, ProductIngredients, ProductDosage, ProductHowToUse, ProductPackage, ProductClassification, 
ProductContraindication, ProductStorage, ProductRecipe, PrincipalName, CategoryID
FROM m_outlet1 o1 
JOIN outlet_stock os ON o1.OutletID = os.OutletID
JOIN m_product1 p1 ON os.ProductID = p1.ProductID
JOIN m_product2 p2 ON p1.ProductID = p2.ProductID
JOIN m_product3 p3 ON p2.ProductID = p3.ProductID
JOIN bridging_category_product bcp ON os.ProductID = bcp.ProductID
WHERE CategoryID = categoryID1 AND o1.outletID = outletID1 AND os.ProductID != productID1;
end