View source for Template:ITEM ALL DROPLISTS

<noinclude>
This is the text displayed on the Template page
</noinclude>

<includeonly>
{{#get_db_data:
 db=Derp
 |from=mob_droplist, mob_groups, item_basic, item_names
 |where=mob_groups.mg_name = REPLACE('{{PAGENAME}}', ' ', '_')
AND mob_droplist.md_dropId = mob_groups.mg_dropid
AND item_basic.ib_itemid = mob_droplist.md_itemId
AND item_basic.ib_itemid = item_names.in_item_id
 |order by=mg_name, md_dropId, md_groupId, md_itemId
 |data=
groupID=md_groupID, itemID=md_itemId, itemDisplayName=in_properFullName, itemSearchName=REPLACE(in_shortName,' ','_'), itemRate=ROUND(md_itemRate / 10, 1)
}}

{| class="wikitable"
! scope="row" colspan="5" | Drops
|-
! Group ID !! Item ID !! BG Wiki !! FFXIAH !! Item Rate
{{#for_external_table:|
{{!}}-
{{!}} {{{groupID}}}
{{!}} {{{itemID}}}
{{!}} [[{{{itemDisplayName}}}{{#createpageifnotex:{{{itemDisplayName}}}|The content of test page 1}}]]
{{!}} [https://www.bg-wiki.com/ffxi/{{{itemSearchName|}}} {{{itemDisplayName}}}]
{{!}} [https://www.ffxiah.com/item/{{{itemID|}}} {{ucfirst:{{{itemDisplayName}}}}}]
{{!}} {{{itemRate}}}%
}}
|}
</includeonly>