from CatalogItem as item where item.author.name like :name
 
 select * from CATALOG_ITEM i inner join AUTHOR a
 on (a.AUTHOR_ID = i.AUTHOR_ID) 
 where a.NAME like :name