Jim... I modified the page to the statement you provided and it crapped out the page with the same error that I have been getting all along.... Query executions was interrupted... Jim there is no guaranty that this is where the error is but I am assuming this is.... I can send you (email a copy) of the database if that will make things better...
below is the mod's to the page:
//bolthouse old....
//$query_ExistingProducts = sprintf("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 = %s LIMIT 1 ) OR ps3_products.ProductID = %s", GetSQLValueString($PIDParam_ExistingProducts, "int"),GetSQLValueString($PIDParam_ExistingProducts, "int"));
//webassist new 5-21-10
$query_ExistingProducts = sprintf("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_products.ProductID = %s or ps3_productoptions.GroupingID = (SELECT GroupingID FROM ps3_productoptions WHERE ProductID = %s LIMIT 1 )", GetSQLValueString($PIDParam_ExistingProducts, "int"),GetSQLValueString($PIDParam_ExistingProducts, "int"));
