QW Error

[GoogleCodeExporter]

Busted Search:

where charging
You feel protected from disease.
SELECT r.uid as uid, r.name as name, 1 as DisplayOrder FROM rooms r INNER JOIN 
areas a ON r.area = a.uid WHERE r.name =  'se.' AND (a.name = 'cataclysm' OR 
a.uid = 'cataclysm') UNION SELECT r.uid, r.name, 0 FROM rooms r INNER JOIN 
areas a ON r.area = a.uid WHERE r.name <> 'se.' AND r.name LIKE '%se.%' AND 
(a.name = 'cataclysm' OR a.uid = 'cataclysm') ORDER BY DisplayOrder DESC 
No matching rooms found.

Working next time I did it:

where charging
A Charging Demon             Behind Valkur's Lines
SELECT r.uid as uid, r.name as name, 1 as DisplayOrder FROM rooms r INNER JOIN 
areas a ON r.area = a.uid WHERE r.name =  'Behind Valkur''s Lines' AND (a.name 
= 'cataclysm' OR a.uid = 'cataclysm') UNION SELECT r.uid, r.name, 0 FROM rooms 
r INNER JOIN areas a ON r.area = a.uid WHERE r.name <> 'Behind Valkur''s Lines' 
AND r.name LIKE '%Behind Valkur''s Lines%' AND (a.name = 'cataclysm' OR a.uid = 
'cataclysm') ORDER BY DisplayOrder DESC 
  1 (20000) Behind Valkur's Lines
  2 (20001) Behind Valkur's Lines
  3 (20002) Behind Valkur's Lines
  4 (20003) Behind Valkur's Lines
  5 (20004) Behind Valkur's Lines

I didn't move or do anything different

Original issue reported on code.google.com by jvhagg...@gmail.com on 11 Jul 2011 at 6:41

[GoogleCodeExporter]

where Virigoth
FnAqBroke Virigoth           An Intersection Past the Wall
SELECT r.uid as uid, r.name as name, 1 as DisplayOrder FROM rooms r INNER JOIN 
areas a ON r.area = a.uid WHERE r.name =  'An Intersection Past the Wall' AND 
(a.name = 'empyrean' OR a.uid = 'empyrean') UNION SELECT r.uid, r.name, 0 FROM 
rooms r INNER JOIN areas a ON r.area = a.uid WHERE r.name <> 'An Intersection 
Past the Wall' AND r.name LIKE '%An Intersection Past the Wall%' AND (a.name = 
'empyrean' OR a.uid = 'empyrean') ORDER BY DisplayOrder DESC 
No matching rooms found.

Original comment by jvhagg...@gmail.com on 11 Jul 2011 at 6:46