CiviCRM Stale Contacts Query

gistfile1.sql

SELECT * 
FROM civicrm_contact
WHERE id NOT 
IN ( 1 ) 

SELECT * 
FROM civicrm_log
WHERE entity_table='civicrm_contact'
LEFT_JOIN civicrm_contact ON civicrm_log.entity_id=civicrm_contact.id


SELECT civicrm_log.entity_id, civicrm_contact.first_name FROM civicrm_log 
LEFT JOIN civicrm_contact ON civicrm_log.entity_id=civicrm_contact.id
WHERE civicrm_log.entity_table='civicrm_contact'


SELECT first_name, last_name from civicrm_contact 
WHERE id NOT IN 
(
	SELECT entity_id
	FROM civicrm_log
	WHERE entity_table='civicrm_contact'
	AND modified_date > '2011-02-16 17:16:41'
)