diff --git a/src/com/android/providers/contacts/LegacyApiSupport.java b/src/com/android/providers/contacts/LegacyApiSupport.java
index af4a74e..604c4ba 100644
--- a/src/com/android/providers/contacts/LegacyApiSupport.java
+++ b/src/com/android/providers/contacts/LegacyApiSupport.java
@@ -118,7 +118,7 @@
     public static final String PRESENCE_JOINS =
             " LEFT OUTER JOIN presence ON ("
             + " presence.presence_id = (SELECT max(presence_id) FROM presence"
-            + " WHERE view_v1_people._id = presence.raw_contact_id))";
+            + " WHERE view_v1_people._id = presence_raw_contact_id))";
 
     private static final String PHONETIC_NAME_SQL = "trim(trim("
             + "ifnull(name." + StructuredName.PHONETIC_GIVEN_NAME + ",' ')||' '||"