SET @enchant_max = 26;

SELECT
	characters.char_name, 
	characters.charId, 
	items.enchant_level, 
	items.object_id, 
	items.owner_id, 
	items.item_id,
	(SELECT lastIP FROM accounts WHERE login = characters.account_name) AS ultimo_ip,
	
	CONCAT(
		FROM_UNIXTIME((characters.lastAccess / 1000), 
		'%d/%m/%Y \à\s %H:%i:%s'), 
		', ', 
		FLOOR(((UNIX_TIMESTAMP() - (lastAccess / 1000))) / 86400), 
		' dias, ', 
		FLOOR((((UNIX_TIMESTAMP() - (lastAccess / 1000))) % 86400) / 3600), 
		' horas, ', 
		FLOOR((((UNIX_TIMESTAMP() - (lastAccess / 1000))) % 3600) / 60), 
		' minutos, ', 
		FLOOR((((UNIX_TIMESTAMP() - (lastAccess / 1000))) % 3600) % 60), 
		' segundos atrás'
	) AS ultimo_acesso, 
	
	CONCAT(
		FLOOR((UNIX_TIMESTAMP() - (UNIX_TIMESTAMP() - onlinetime)) / 86400), 
		' dias, ', 
		FLOOR(((UNIX_TIMESTAMP() - (UNIX_TIMESTAMP() - onlinetime)) % 86400) / 3600), 
		' horas, ', 
		FLOOR(((UNIX_TIMESTAMP() - (UNIX_TIMESTAMP() - onlinetime)) % 3600) / 60), 
		' minutos, ',
		FLOOR((UNIX_TIMESTAMP() - (UNIX_TIMESTAMP() - onlinetime)) % 60), 
		' segundos'
	) AS tempo_on 
	
	FROM 
		characters, 
		items 
		
	WHERE 
		characters.charId = items.owner_id AND 
		items.enchant_level > @enchant_max AND 
		items.item_id NOT IN (SELECT item_id FROM etcitem)