常連

@Queryアノテーションを用いて3つのテーブルを結合した結果をDBから取得したいのですが、うまくいきません。
実行すると以下のようなエラーがでます。

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: 'i.category' [SELECT i.id,i.name,i.image,i.price, c.name, COUNT(i.id)FROM jp.co.sss.shop.entity.OrderItem oi INNER JOIN  oi.item iINNER JOIN i.category c GROUP BY i.id,i.name,i.image, i.price, c.name ORDER BY count(i.id) DESC ]


```ItemRepository
package jp.co.sss.shop.repository;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import jp.co.sss.shop.entity.Category;
import jp.co.sss.shop.entity.Item;
import java.util.List;
/**
 * itemsテーブル用リポジトリ
 *
 * @author System Shared
 */
@Repository
public interface ItemRepository extends JpaRepository<Item, Integer> {

	//一覧表示（売れ筋順）
	@Query("SELECT i.id,i.name,i.image,i.price, c.name, COUNT(i.id)" + 
			"FROM OrderItem oi INNER JOIN  oi.item i" + 
			"INNER JOIN i.category c " + 
			"GROUP BY i.id,i.name,i.image, i.price, c.name " + 
			"ORDER BY count(i.id) DESC ")
	public List<Item> sortByOrderCount();
	
}
```

```Item
package jp.co.sss.shop.entity;

import java.sql.Date;
import java.util.List;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

/**
 * 商品情報のエンティティクラス
 *
 * @author SystemShared
 */
@Entity
@Table(name = "items")
@NamedQuery(name="OrderById", query="SELECT i FROM Item i INNER JOIN i.category c ORDER BY i.id DESC")
public class Item {
	/**
	 * 商品ID
	 */
	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq_items_gen")
	@SequenceGenerator(name = "seq_items_gen", sequenceName = "seq_items", allocationSize = 1)
	private Integer			id;

	/**
	 * 商品名
	 */
	@Column
	private String			name;

	/**
	 * 価格
	 */
	@Column
	private Integer			price;

	/**
	 * 商品説明
	 */
	@Column
	private String			description;

	/**
	 * 在庫数
	 */
	@Column
	private Integer			stock;

	/**
	 * 商品画像ファイル名
	 */
	@Column
	private String			image;

	/**
	 * 削除フラグ
	 */
	@Column(insertable = false)
	private Integer			deleteFlag;

	/**
	 * 登録日付
	 */
	@Column(insertable = false, updatable = false)
	private Date			insertDate;

	/**
	 * カテゴリ情報
	 */
	@ManyToOne
	@JoinColumn(name = "category_id", referencedColumnName = "id")
	private Category		category;

	/**
	 * 注文商品情報
	 */
	@OneToMany(mappedBy = "item")
	private List<OrderItem>	orderItemList;

	/**
	 * コンストラクタ
	 */
	public Item() {
	}

	/**
	 * コンストラクタ
	 * @param id 商品ID
	 * @param name 商品名
	 * @param description 商品説明
	 * @param image 画像ファイル名
	 * @param category_name カテゴリ名
	 */
	public Item(Integer id, String name, String description, String image, String category_name) {
		this.id = id;
		this.name = name;
		this.description = description;
		this.image = image;
		this.category = new Category();
		this.category.setName(category_name);
	}

	/**
	 * コンストラクタ
	 * @param id 商品ID
	 * @param name 商品名
	 * @param price 価格
	 * @param description 商品説明
	 * @param image 画像ファイル名
	 * @param category_name カテゴリ名
	 */
	public Item(Integer id, String name, Integer price, String description, String image, String category_name) {
		this.id = id;
		this.name = name;
		this.price = price;
		this.description = description;
		this.image = image;
		this.category = new Category();
		this.category.setName(category_name);
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public Integer getPrice() {
		return price;
	}

	public void setPrice(Integer price) {
		this.price = price;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public Integer getStock() {
		return stock;
	}

	public void setStock(Integer stock) {
		this.stock = stock;
	}

	public String getImage() {
		return image;
	}

	public void setImage(String image) {
		this.image = image;
	}

	public Integer getDeleteFlag() {
		return deleteFlag;
	}

	public void setDeleteFlag(Integer deleteFlag) {
		this.deleteFlag = deleteFlag;
	}

	public Date getInsertDate() {
		return insertDate;
	}

	public void setInsertDate(Date insertDate) {
		this.insertDate = insertDate;
	}

	public Category getCategory() {
		return category;
	}

	public void setCategory(Category category) {
		this.category = category;
	}

	public List<OrderItem> getOrderItemsList() {
		return orderItemList;
	}

	public void setOrderItemsList(List<OrderItem> orderItemList) {
		this.orderItemList = orderItemList;
	}

}

```

```OrderItem
package jp.co.sss.shop.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQuery;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

/**
 * 注文商品情報のエンティティクラス
 *
 * @author SystemShared
 */
@Entity
@Table(name = "order_items")
//@NamedQuery(name="findByOrderQuantity", query="SELECT o FROM order_items WHERE o.quantity >= 1 ORDER BY o.quantity DESC")
public class OrderItem {

	/**
	 * 注文商品ID
	 */
	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq_order_items_gen")
	@SequenceGenerator(name = "seq_order_items_gen", sequenceName = "seq_order_items", allocationSize = 1)
	private Integer	id;

	/**
	 * 注文個数
	 */
	@Column
	private Integer	quantity;

	/**
	 * 注文情報
	 */
	@ManyToOne
	@JoinColumn(name = "order_id", referencedColumnName = "id")
	private Order	order;

	/**
	 * 商品情報
	 */
	@ManyToOne
	@JoinColumn(name = "item_id", referencedColumnName = "id")
	private Item	item;

	
	/**
	 * 注文時点商品単価
	 */
	@Column
	private int price;
	
	
	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public Integer getQuantity() {
		return quantity;
	}

	public void setQuantity(Integer quantity) {
		this.quantity = quantity;
	}

	public Order getOrder() {
		return order;
	}

	public void setOrder(Order order) {
		this.order = order;
	}

	public Item getItem() {
		return item;
	}

	public void setItem(Item item) {
		this.item = item;
	}

	public int getPrice() {
		return price;
	}

	public void setPrice(int price) {
		this.price = price;
	}
	
	
}

```

```Category
package jp.co.sss.shop.entity;

import java.sql.Date;
import java.util.List;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

/**
 * カテゴリ情報のエンティティクラス
 *
 * @author SystemShared
 */
@Entity
@Table(name = "categories")
public class Category {
	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq_categories_gen")
	@SequenceGenerator(name = "seq_categories_gen", sequenceName = "seq_categories", allocationSize = 1)
	/**
	 * カテゴリID
	 */
	private Integer		id;

	/**
	 * カテゴリ名
	 */
	@Column
	private String		name;

	/**
	 * カテゴリ説明
	 */
	@Column
	private String		description;

	/**
	 * 削除フラグ 0:未削除、1:削除済み
	 */
	@Column(insertable = false)
	private Integer		deleteFlag;

	/**
	 * 登録日付
	 */
	@Column(insertable = false)
	private Date		insertDate;

	/**
	 * 商品リスト
	 */
	@OneToMany(mappedBy = "category")
	private List<Item>	itemList;

	/**
	 * コンストラクタ
	 */
	public Category() {
	}

	/**
	 * コンストラクタ
	 * @param name カテゴリ名
	 */
	public Category(String name) {
		this.name = name;
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public Integer getDeleteFlag() {
		return deleteFlag;
	}

	public void setDeleteFlag(Integer deleteFlag) {
		this.deleteFlag = deleteFlag;
	}

	public Date getInsertDate() {
		return insertDate;
	}

	public void setInsertDate(Date insertDate) {
		this.insertDate = insertDate;
	}

	public List<Item> getItemList() {
		return itemList;
	}

	public void setItemList(List<Item> itemList) {
		this.itemList = itemList;
	}
}

```

質問編集履歴