the query joins the fields from the item and its details