Unknown column 'P.ProdID' in 'on clause'Invalid SQL: SELECT P.ProdID,P.Weight,P.Name,P.Sku,COL.ID,P.image_type,P.image_type_thumbnail,COL.nickname,P.Price,COL.qty,S.SalesPrice,S.SalesStart,S.SalesStop,P.Alteration
failed in /home/sam/cart_2007/mysql.inc at line 39
Invalid SQL: SELECT P.ProdID,P.Weight,P.Name,P.Sku,COL.ID,P.image_type,P.image_type_thumbnail,COL.nickname,P.Price,COL.qty,S.SalesPrice,S.SalesStart,S.SalesStop,P.Alteration FROM Product AS P, CartOrderLine_201804 AS COL LEFT JOIN Sales AS S ON P.ProdID=S.ProdID WHERE P.Sku = COL.sku AND COL.orderid = '5ad95a397f87b' AND P.VendorID = '32767' ORDER BY P.sort_order, COL.ID