SELECT * FROM (SELECT n.address, c.id, c.storages, c.disk_path, CONCAT_WS('/', LEFT(u.username, 2), u.username, CONCAT(c.key, '.code')) c_disk_path FROM codes c INNER JOIN users u ON c.user_id = u.id INNER JOIN namespaces n ON u.id = n.owner_id) t WHERE t.address != t.storages OR t.disk_path != t.c_disk_path;