localized-fields-bug-fix-build-3671.php

<?php

include("../../pimcore/cli/startup.php");

$db = Pimcore\Resource::get();
$tables = $db->fetchAll("SHOW TABLES LIKE 'object_localized_query_%'");

echo "\n\n";

foreach ($tables as $table) {
    $t = current($table);

    preg_match("/object_localized_query_([0-9]+)_/", $t, $matches);

    $classId = $matches[1];

    echo "Cleaning up " . $t . " ...";
    $db->query("DELETE FROM " . $t . " WHERE ooo_id NOT IN (SELECT o_id FROM objects WHERE o_classId = " . $classId . ")");
    echo "done!\n";
}

echo "\n\n";
echo "Done!";