View Single Post
  #6  
Old 02-01-2015, 05:01 AM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

You might have a ton of lootdrops where the item doesnt exist now btw.. not sure if that is gonna break anything.. but this should show you the lootdrop_entries that do not exist as items.

Code:
SELECT lde.* FROM lootdrop_entries lde 
LEFT JOIN items i ON i.id = lde.item_id
WHERE i.id IS NULL;
Reply With Quote