| 152 |
0.0015 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
| 523 |
0.0009 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
| 427 |
0.0007 |
SELECT guild.* FROM `roster_guild` guild WHERE `guild_id` = "2"; |
| 1028 |
0.0009 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '7' ORDER BY `id` ASC; |
| 55 |
0.017 |
SELECT `s`.*, `p`.`name`, `p`.`clientLocale`, `p`.`member_id` FROM `roster_skills` AS s, `roster_players` AS p WHERE `p`.`member_id` = `s`.`member_id` AND `p`.`guild_id` = '2' AND `skill_name` IN ('Alchemie', 'Kräuterkunde', 'Schmiedekunst', 'Bergbau', 'Lederverarbeitung', 'Juwelenschleifen', 'Kürschnerei', 'Schneiderei', 'Verzauberkunst', 'Ingenieurskunst', 'Inschriftenkunde', 'Runen schmieden', 'Kochkunst', 'Angeln', 'Erste Hilfe', 'Gifte', 'Alchemy', 'Herbalism', 'Blacksmithing', 'Mining', 'Leatherworking', 'Jewelcrafting', 'Skinning', 'Tailoring', 'Enchanting', 'Engineering', 'Inscription', 'Runeforging', 'Cooking', 'Fishing', 'First Aid', 'Poisons', 'Alquimia', 'Botánica', 'HerrerÃa', 'MinerÃa', 'PeleterÃa', 'JoyerÃa', 'Desollar', 'SastrerÃa', 'Encantamiento', 'IngenierÃa', 'Inscripción', 'Forja de runas', 'Cocina', 'Pesca', 'Primeros auxilios', 'Venenos', 'Alchimie', 'Herboristerie', 'Forge', 'Minage', 'Travail du cuir', 'Joaillerie', 'Dépeçage', 'Couture', 'Enchantement', 'Ingénierie', 'Calligraphie', 'Runeforge', 'Cuisine', 'Pêche', 'Secourisme', 'Poisons', 'Alchemy', 'Herbalism', 'Blacksmithing', 'Mining', 'Leatherworking', 'Jewelcrafting', 'Skinning', 'Tailoring', 'Enchanting', 'Engineering', 'Inscription', 'Runeforging', 'Cooking', 'Fishing', 'First Aid', 'Poisons', 'Alchemy', 'Herbalism', 'Blacksmithing', 'Mining', 'Leatherworking', 'Jewelcrafting', 'Skinning', 'Tailoring', 'Enchanting', 'Engineering', 'Inscription', 'Runeforging', 'Cooking', 'Fishing', 'First Aid', 'Poisons', 'Alchemy', 'Herbalism', 'Blacksmithing', 'Mining', 'Leatherworking', 'Jewelcrafting', 'Skinning', 'Tailoring', 'Enchanting', 'Engineering', 'Inscription', 'Runeforging', 'Cooking', 'Fishing', 'First Aid', 'Poisons', 'Alchemy', 'Herbalism', 'Blacksmithing', 'Mining', 'Leatherworking', 'Jewelcrafting', 'Skinning', 'Tailoring', 'Enchanting', 'Engineering', 'Inscription', 'Runeforging', 'Cooking', 'Fishing', 'First Aid', 'Poisons', '') ORDER BY `s`.`skill_type`, (mid(`skill_level` FROM 1 FOR (locate(':', `skill_level`)-1)) + 0) DESC, `s`.`skill_name`, `p`.`name`; |
| 209 |
0.0009 |
SELECT `guild_name`, CONCAT(`region`,'-',`server`), `guild_id` FROM `roster_guild` ORDER BY `region` ASC, `server` ASC, `guild_name` ASC; |
| 184 |
0.0065 |
SELECT count(`member_id`) AS `amount`, IF(`note` LIKE '%alt%',1,0) AS isalt, FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 30 AND `guild_id` = '2' GROUP BY isalt, label; |
| 364 |
0.0012 |
SELECT `mb`.*, `a`.`basename` FROM `roster_menu_button` AS mb LEFT JOIN `roster_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1; |
| 381 |
0.0006 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`; |
|