just an idea and i'll give a shot at it in a few minutes waking up from my 4 hour nap hehe =).  compare the items_ vs items where items_.id=items.id and run a query to verify inconsistency.  could have been someone changed something in their packetcollected logs or changed source or just a flukey bug that introduced it if the data in those two tables is different.  first cup of coffee and going to monkey with it a bit if this is for specific fields only that would help tremendously in cutting down my query structures. 
Darkwaters 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 |