Add a Default value
OK... this is the statement that is causing things to Die.... What can i do about this
SELECT DISTINCT ps3_products.ProductID, COALESCE(ps3_productoptions.GroupingID,ps3_products.ProductID) AS GroupingID FROM ps3_products LEFT OUTER JOIN ps3_productoptions ON ps3_productoptions.ProductID = ps3_products.ProductID WHERE ps3_productoptions.GroupingID = (SELECT GroupingID FROM ps3_productoptions WHERE ProductID = 7504 LIMIT 1 ) OR ps3_products.ProductID = 7504
I broke a part this sql statement into sections and at first I thought it was the Coalesce,,, but it looks like the issue is with the Left Outer Join...