Bad 'table not found' error on nested subqueries

[andy-wm-arthur]

error: 'table not found: dcim_rackgroup, maybe you mean dcim_rackgroup?' for query:

SELECT COUNT(*) FROM (
	SELECT (
		SELECT count(*) 
		FROM (
			SELECT U0.`id` 
			FROM `dcim_rack` U0 
			INNER JOIN `dcim_rackgroup` U1 
			ON (U0.`group_id` = U1.`id`) 
			WHERE (
				U1.`lft` >= `dcim_rackgroup`.`lft` AND 
				U1.`lft` <= `dcim_rackgroup`.`rght` AND 
				U1.`tree_id` = `dcim_rackgroup`.`tree_id`
			)
		) _count
	) AS `rack_count` 
	FROM `dcim_rackgroup` 
	WHERE `dcim_rackgroup`.`id` 
	IN ('418dd0dd47504bb190f354cf23ded6a6', 'd6d30bef4def4b66bcd180d4252eca7d', '34a74e488171481b96b222bf56a55bb9', '289e27c03cee4c299a3fa10517b54c52')
) subquery

schema:

CREATE TABLE `dcim_rackgroup` (
  `id` char(32) NOT NULL,
  `lft` int unsigned NOT NULL,
  `rght` int unsigned NOT NULL,
  `tree_id` int unsigned NOT NULL,
  `level` int unsigned NOT NULL,
  `parent_id` char(32),
  PRIMARY KEY (`id`),
  KEY `dcim_rackgroup_tree_id_9c2ad6f4` (`tree_id`),
  CONSTRAINT `dcim_rackgroup_parent_id_cc315105_fk_dcim_rackgroup_id` FOREIGN KEY (`parent_id`) REFERENCES `dcim_rackgroup` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

CREATE TABLE `dcim_rack` (
  `id` char(32) NOT NULL,
  `group_id` char(32),
  PRIMARY KEY (`id`),
  KEY `dcim_rack_group_id_44e90ea9` (`group_id`),
  CONSTRAINT `dcim_rack_group_id_44e90ea9_fk_dcim_rackgroup_id` FOREIGN KEY (`group_id`) REFERENCES `dcim_rackgroup` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;