The color got lost:

The both queries are, first incorrect:

insert into HT_Foo select foo0_.id as id from Foo foo0_ inner join Business foo0_1_ on foo0_.id=foo0_1_.id where id in (select foouserreg1_2_.business_id from FooUserRegistration foouserreg1_ inner join FooUser foouserreg1_1_ on foouserreg1_.id=foouserreg1_1_.id inner join BaseUser foouserreg1_2_ on foouserreg1_.id=foouserreg1_2_.id where foouserreg1_2_.creationDate<'2015-08-28 21:12:01.81');

Correct one:

insert into HT_Foo select foo0_.id as id from Foo foo0_ inner join Business foo0_1_ on foo0_.id=foo0_1_.id where foo0_.id in (select foouserreg1_2_.business_id from FooUserRegistration foouserreg1_ inner join FooUser foouserreg1_1_ on foouserreg1_.id=foouserreg1_1_.id inner join BaseUser foouserreg1_2_ on foouserreg1_.id=foouserreg1_2_.id where foouserreg1_2_.creationDate<'2015-08-28 21:12:01.81');