MySQL Query help

SELECT DISTINCT productid
FROM T_Product_Codes
WHERE code1, code2, code3 IN (
    SELECT code1, code2, code3
    FROM T_Product_Codes
    WHERE productid = '12345652'
)

//PHP code
//get all different code combinations (code1 code2 code3)
$alternativeproducts = array();
$codecombinations = get_codes_for_id($productid);
if (!empty($codecombinations)) {
    //go through every one of the code combinations and see if there is a product that matches it, 
    //  it also has to be a product that was found in all previous code combination matches.
    foreach ($codecombinations as $codecombination) {
        $alternativeproducts = get_productids_for_codes(trim($codecombination["code1"]), trim($codecombination["code2"]), trim($codecombination["code3"]), $alternativeproducts);
    }
}

//PDO query like this
SELECT DISTINCT zi_id 
FROM T_Producteigenschappen
WHERE code1 = ?
AND code2 = ?
AND code3 = ?
AND productid IN //all of the previously found productids

//PHP code:
$codecombinations = get_codes_for_id($productid);
$alternativeproducts = get_comparableproducts_for_codecombinations($codecombinations);

//PDO code
function get_codes_for_id($productid) {
    require("_inc/database.inc.php");
    $resultarray = array();
    try {
        $query = "SELECT DISTINCT code1, code2, code3 FROM T_Product_Codes WHERE productid = :productid";

        $results = $db_mnet->prepare($query);
        $results->bindParam(': productid',$productid,PDO::PARAM_STR);
        $results->execute();
    } catch (Exception $e) {
        //echo "Data could not be retrieved from the database.";
        //exit;
    }
    $resultarray = $results->fetchAll(PDO::FETCH_ASSOC);
    return $resultarray;
}

function get_comparableproducts_for_codecombinations ($codecombinations) {
    require("_inc/database.inc.php");
    $resultarray = array();
    try {
        if (!empty($codecombinations)) {
                        $unionallquery = "";
            foreach ($codecombinations as $codecombination) {
                if ($unionallquery != "") { $unionallquery .= " UNION ALL "; }
                $unionallquery .= "SELECT DISTINCT a.productid
                            FROM T_Product_Codes a
                                    INNER JOIN T_Product_Codes b
                                    USING (code1, code2, code3)
                                    WHERE a.code1 = ? and a.code2 = ? and a.code3 = ?";
            }
            $query = "SELECT t1.productid
                    FROM ($unionallquery) t1
                        GROUP BY productid
                    HAVING COUNT(t1.productid) = ?";

            $results = $db_mnet->prepare($query);
            $paramid = 1;
            foreach ($codecombinations as $codecombination) {
                $results->bindValue($paramid,$codecombination["code1"],PDO::PARAM_STR);
                $paramid++;
                $results->bindValue($paramid,$codecombination["code2"],PDO::PARAM_STR);
                $paramid++;
                $results->bindValue($paramid,$codecombination["code3"],PDO::PARAM_STR);
                $paramid++;
            }
            $results->bindParam($paramid,count($codecombinations),PDO::PARAM_INT);
            $results->execute();
        }
    } catch (Exception $e) {
        //echo "Data could not be retrieved from the database.";
        //exit;
    }
    $resultarray = $results->fetchAll(PDO::FETCH_ASSOC);
    return $resultarray;
}