armor,etcitem,weapon一覧

鯖内weapon一覧表

SELECT
`items`.`item_id`,
`weapon`.`crystal_type`,
`weapon`.`name`,
Sum(`items`.`count`) AS `ItemCount`,
`items`.`enchant_level` AS `最高強化ﾚﾍﾞﾙ`
FROM
`items`
Inner Join `weapon` ON `items`.`item_id` = `weapon`.`item_id`
GROUP BY
`items`.`item_id`,
`weapon`.`crystal_type`,
`weapon`.`name`
ORDER BY
`ItemCount` DESC,
`items`.`item_id` ASC

鯖内armor一覧表

SELECT
`items`.`item_id`,
`armor`.`crystal_type`,
`armor`.`name`,
Sum(`items`.`count`) AS `ItemCount`,
`items`.`enchant_level` AS `最高強化ﾚﾍﾞﾙ`
FROM
`items`
Inner Join `armor` ON `items`.`item_id` = `armor`.`item_id`
GROUP BY
`items`.`item_id`,
`armor`.`crystal_type`,
`armor`.`name`
ORDER BY
`ItemCount` DESC,
`items`.`item_id` ASC

鯖内etcitem一覧表

SELECT
`items`.`item_id`,
`etcitem`.`crystal_type`,
`etcitem`.`name`,
Sum(`items`.`count`) AS `ItemCount`
FROM
`items`
Inner Join `etcitem` ON `items`.`item_id` = `etcitem`.`item_id`
GROUP BY
`items`.`item_id`,
`etcitem`.`crystal_type`,
`etcitem`.`name`
ORDER BY
`ItemCount` DESC