gistfile1.aw

// DB-Kram einbinden

$tunings = $db->get_results("SELECT * FROM tunings");

$by_component = array();

foreach($tunings AS $tuning) {
    $by_component[$tuning['component']] = $tuning;
}

$delete = array();

foreach($by_component AS $component AS $ctunings) {
    $keep = array();
    foreach($ctunings AS $tuning) {
        if(!isset($keep[$tuning['name']])) {
            $keep[$tuning['name']] = true; // wir checken eh nur den Key, also reicht hier irgendwas !== null
        } else {
            $delete[] = $tuning['id'];
        }
    }
}

var_dump($delete);