Error: Table 'a4e_shared.Kills' doesn't exist
SELECT `Kills`.`typeKilledID` AS id, COUNT(DISTINCT(`Kills`.`killID`)) AS rank_value
FROM `a4e_shared`.`Kills`
JOIN a4e_eve_dump.`invTypes` ON `invTypes`.`typeID` = `typeKilledID`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16' AND `invTypes`.`groupID` = 1657
AND `Kills`.`typeKilledID` > 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`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16'
AND `invTypes`.`groupID` = 1657
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 `invTypes`.`groupID` = 1657
GROUP BY date, id
ORDER BY date...' at line 6
SELECT `killTime` AS date, `Kills`.`typeKilledID` AS id, COUNT(DISTINCT(`Kills`.`killID`)) AS vals
FROM `a4e_shared`.`Kills`
JOIN a4e_eve_dump.`invTypes` ON `invTypes`.`typeID` = `typeKilledID`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16'
AND () AND `invTypes`.`groupID` = 1657
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` = `typeKilledID`
WHERE `killTime` < '2026-05-16'
AND `killTime` >= '2025-05-16'
AND `invTypes`.`groupID` = 1657
GROUP BY date
ORDER BY date ASC
| Top 5 ship types by losses of ship group 'Citadel' |
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.
|