Code: Select all
TemplateId Name TemplateType Quality TagMonster TagTrash GROUP_CONCAT(t2.`PatchId`) Spells
---------- --------------------- ------------ ------- ---------- -------- -------------------------- --------
150855 Bracelet of Arul Saba Armor 80 0 1 12080000 0
150856 Bracelet of Arul Saba Armor 80 0 1 12080000 0
150839 Bracelet of Arul Saba Armor 110 0 1 12080000 0
150851 Bracelet of Arul Saba Armor 110 0 1 12080000 0
150848 Bracelet of Arul Saba Armor 150 0 1 12080000 0
150854 Bracelet of Arul Saba Armor 150 0 1 12080000 0
150849 Bracelet of Arul Saba Armor 180 0 1 12080000 0
150852 Bracelet of Arul Saba Armor 180 0 1 12080000 0
150850 Bracelet of Arul Saba Armor 200 0 1 12080000 0
150853 Bracelet of Arul Saba Armor 200 0 1 12080000 0
Code: Select all
SELECT
t.`TemplateId`,
t.`Name`,
te.`Name` AS 'TemplateType',
t.`Quality`,
tt.`Monster` AS TagMonster,
tt.`Trash` AS TagTrash,
GROUP_CONCAT(t2.`PatchId`),
(SELECT COUNT(*) AS spells FROM TemplateSpells AS ts WHERE ts.TemplateId = t.TemplateID AND ts.TemplatePatchId = t.`PatchId`) AS Spells
FROM
Templates AS t
JOIN Templates AS t2 ON (t2.`TemplateId` = t.`TemplateId`)
LEFT JOIN TemplateTags AS tt ON (tt.`TemplateId`=t.`TemplateId` AND tt.`PatchId`=t.`PatchId`)
LEFT JOIN TemplateEnums AS te ON (te.`Enum`='TemplateGuessedType' AND te.`Value`=t.`TemplateType`)
WHERE
t.`IsCurrent`='1'
AND t.`Name` = 'Bracelet of Arul Saba'
AND t.`Description` NOT LIKE '%have been attached%'
AND (SELECT COUNT(*) FROM TemplateSpells AS ts WHERE ts.TemplateId = t.TemplateID AND ts.TemplatePatchId = t.`PatchId`) = 0
GROUP BY t.`TemplateId`
ORDER BY t.Quality
Code: Select all
TemplateId Name TemplateType QL_or_NCU TagMonster TagTrash
---------- --------------------- ------------ --------- ---------- ----------
150850 Bracelet of Arul Saba Armor 200 0 1
288359 Kyr'Ozch Prison Nano 1 1 0
288439 Viral Pain Nano 1 1 0
288441 Viral Venom Nano 1 1 0
Code: Select all
SELECT
t.`TemplateId`,
t.`Name`,
te.`Name` AS 'TemplateType',
t.`Quality` AS 'QL_or_NCU',
tt.`Monster` AS TagMonster,
tt.`Trash` AS TagTrash
FROM
Templates AS t
LEFT JOIN TemplateTags AS tt ON (tt.`TemplateId`=t.`TemplateId` AND tt.`PatchId`=t.`PatchId`)
LEFT JOIN TemplateEnums AS te ON (te.`Enum`='TemplateGuessedType' AND te.`Value`=t.`TemplateType` )
WHERE
t.`TemplateId` IN (288359, 288439, 288441)
AND t.`IsCurrent`=1