Показать сообщение отдельно
Старый 12.12.2010, 17:40   #2
cyrex
Ученый
 
Регистрация: 06.11.2009
Сообщений: 108
Сказал(а) спасибо: 17
Поблагодарили 28 раз(а) в 27 сообщениях
cyrex На верном пути
По умолчанию

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]%');
cyrex вне форума