Error: Table 'a4e_shared.Kills' doesn't exist
SELECT `invTypes`.`groupID` AS id, COUNT(DISTINCT(`Kills`.`killID`)) AS rank_value
FROM `a4e_shared`.`Kills`
JOIN a4e_eve_dump.`invTypes` ON `invTypes`.`typeID` = `Kills`.`typeKilledID` JOIN a4e_eve_dump.`invGroups` ON `invGroups`.`groupID` = `invTypes`.`groupID`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16' AND `invGroups`.`categoryID` = 65
AND `invTypes`.`groupID` > 0
GROUP BY id
ORDER BY rank_value DESC
LIMIT 5Error: Table 'a4e_shared.Kills' doesn't exist
SELECT `killTime` AS date, COUNT(DISTINCT(`Kills`.`killID`)) AS vals
FROM `a4e_shared`.`Kills`
JOIN a4e_eve_dump.`invTypes` ON `invTypes`.`typeID` = `typeKilledID` JOIN a4e_eve_dump.`invGroups` ON `invGroups`.`groupID` = `invTypes`.`groupID`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16'
AND `invGroups`.`categoryID` = 65
GROUP BY date
ORDER BY date ASCError: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `invGroups`.`categoryID` = 65
GROUP BY date, id
ORDER BY da...' at line 6
SELECT `killTime` AS date, `invTypes`.`groupID` AS id, COUNT(DISTINCT(`Kills`.`killID`)) AS vals
FROM `a4e_shared`.`Kills`
JOIN a4e_eve_dump.`invTypes` ON `invTypes`.`typeID` = `Kills`.`typeKilledID` JOIN a4e_eve_dump.`invGroups` ON `invGroups`.`groupID` = `invTypes`.`groupID`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16'
AND () AND `invGroups`.`categoryID` = 65
GROUP BY date, id
ORDER BY date ASCError: Table 'a4e_shared.Kills' doesn't exist
SELECT `killTime` AS date, COUNT(DISTINCT(`Kills`.`killID`)) AS vals
FROM `a4e_shared`.`Kills`
JOIN a4e_eve_dump.`invTypes` ON `invTypes`.`typeID` = `Kills`.`typeKilledID` JOIN a4e_eve_dump.`invGroups` ON `invGroups`.`groupID` = `invTypes`.`groupID`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16'
AND `invGroups`.`categoryID` = 65
GROUP BY date
ORDER BY date ASC
| Top 5 ship groups by losses of ship category 'Structure' |
Source: zKillboard; averaged across 1 days; 12 months history; historic sum; ranked across shown history |
|
|
|
|
|
|
Copyright notice: If the source (being Adam4Eve.eu) is mentioned/linked or for tweets @AdamFourEve included, then the publication of screenshots of this graph is allowed. Direct links are allowed without restriction. Data scraping is NOT allowed and suspicious IPs will be blocked without notice.
|