This one will check if the quest is related to anything AND will also do the check above:
Код:
SELECT entry,title FROM quest_template WHERE entry NOT IN (select quest FROM gameobject_involvedrelation) AND entry NOT IN (select quest FROM creature_involvedrelation) AND entry NOT IN (select quest FROM gameobject_questrelation) AND entry NOT IN (select quest FROM creature_questrelation) AND entry NOT IN (select quest FROM game_event_creature_quest) AND entry NOT IN (select quest FROM game_event_gameobject_quest) AND (title like '%[%' OR title like '%EPRECATE%' OR title like '%REUSE%' OR title like '%<NYI>%' OR title like '%<CHANGE TO GOSSIP>%' OR title like '%COPY' OR title like '%UNUSED%' OR title like '%<TXT>%' OR title like '%[PH]%');