SELECT pname, name, description, command FROM (
SELECT a.id, p.id pid, p.name pname, a.name name, a.description, a.command FROM achievements a, players p, stats s WHERE
s.player_id = p.id AND CAST(s.type AS CHAR) = a.type AND s.block = a.block AND s.data = a.data AND s.value >= a.value
UNION SELECT a.id, p.id pid, p.name, a.name name, a.description, a.command FROM achievements a, players p WHERE
(a.type = \'MINECART_ENTER\' AND p.MINECART_ENTER >= a.value) OR
(a.type = \'MINECART\' AND p.MINECART >= a.value) OR
(a.type = \'BOAT_ENTER\' AND p.BOAT_ENTER >= a.value) OR
(a.type = \'BOAT\' AND p.BOAT >= a.value) OR
(a.type = \'KILLS_TOTAL\' AND p.KILLS_TOTAL >= a.value) OR
(a.type = \'BLOCKDESTROY_TOTAL\' AND p.BLOCKDESTROY_TOTAL >= a.value) OR
(a.type = \'BLOCKCREATE_TOTAL\' AND p.BLOCKCREATE_TOTAL >= a.value) OR
(a.type = \'MOVE\' AND p.MOVE >= a.value) OR
(a.type = \'ARMSWING\' AND p.ARMSWING >= a.value) OR
(a.type = \'DEATHS\' AND p.DEATHS >= a.value) OR
(a.type = \'OPENCHEST\' AND p.OPENCHEST >= a.value) OR
(a.type = \'LIGHTER\' AND p.LIGHTER >= a.value) OR
(a.type = \'EGGTHROW\' AND p.EGGTHROW >= a.value) OR
(a.type = \'SNOWBALLTHROW\' AND p.SNOWBALLTHROW >= a.value) OR
(a.type = \'CHAT\' AND p.CHAT >= a.value) OR
(a.type = \'CHATLETTERS\' AND p.CHATLETTERS >= a.value) OR
(a.type = \'COMMAND\' AND p.COMMAND >= a.value) OR
(a.type = \'TELEPORT\' AND p.TELEPORT >= a.value) OR
(a.type = \'RESPAWN\' AND p.RESPAWN >= a.value) OR
(a.type = \'KICK\' AND p.KICK >= a.value) OR
(a.type = \'LASTLOGIN\' AND p.LASTLOGIN >= a.value) OR
(a.type = \'LASTLOGOUT\' AND p.LASTLOGOUT >= a.value) OR
(a.type = \'LOGIN\' AND p.LOGIN >= a.value)
) k WHERE (SELECT 1 FROM player_achievements pa WHERE pa.achievement_id = id AND pa.player_id = pid) IS NULL