Lines Matching refs:CONTACT_ID
219 + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)";
263 + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)";
310 + SettingsColumns.CONCRETE_ACCOUNT_TYPE + "," + RawContacts.CONTACT_ID;
341 " WHERE " + RawContacts.CONTACT_ID + "=" + ContactsColumns.CONCRETE_ID +
342 " GROUP BY " + RawContacts.CONTACT_ID;
422 Tables.RAW_CONTACTS + "." + RawContacts.CONTACT_ID;
571 String CONTACT_ID = "presence_contact_id";
575 String CONTACT_ID = "presence_contact_id";
577 String CONCRETE_CONTACT_ID = Tables.AGGREGATED_PRESENCE + "." + CONTACT_ID;
667 public static final String CONTACT_ID = "contact_id";
876 PresenceColumns.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," +
887 + Tables.PRESENCE + " (" + PresenceColumns.CONTACT_ID + ");");
891 AggregatedPresenceColumns.CONTACT_ID
902 + " WHERE " + AggregatedPresenceColumns.CONTACT_ID + " = " +
903 "(SELECT " + PresenceColumns.CONTACT_ID +
910 " WHERE " + PresenceColumns.CONTACT_ID
911 + "=OLD." + PresenceColumns.CONTACT_ID +
918 + AggregatedPresenceColumns.CONTACT_ID + ", "
922 + PresenceColumns.CONTACT_ID + ","
933 + " WHERE " + PresenceColumns.CONTACT_ID
934 + "=NEW." + PresenceColumns.CONTACT_ID
936 + " AND " + PresenceColumns.CONTACT_ID + "=NEW." + PresenceColumns.CONTACT_ID + ";";
1006 RawContacts.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," +
1041 RawContacts.CONTACT_ID +
1401 + SearchIndexColumns.CONTACT_ID + " INTEGER REFERENCES contacts(_id) NOT NULL,"
1429 + " WHERE " + Contacts._ID + "=OLD." + RawContacts.CONTACT_ID
1431 + " WHERE " + RawContacts.CONTACT_ID + "=OLD." + RawContacts.CONTACT_ID
1434 + " WHERE " + Contacts._ID + "=OLD." + RawContacts.CONTACT_ID
1436 + " WHERE " + RawContacts.CONTACT_ID + "=OLD." + RawContacts.CONTACT_ID
1439 + " WHERE " + Contacts._ID + "=OLD." + RawContacts.CONTACT_ID
1441 + " WHERE " + RawContacts.CONTACT_ID + "=OLD." + RawContacts.CONTACT_ID
1505 " SELECT " + RawContacts.CONTACT_ID +
1511 " SELECT " + RawContacts.CONTACT_ID +
1521 " SELECT " + RawContacts.CONTACT_ID +
1682 + RawContactsColumns.CONCRETE_CONTACT_ID + " AS " + RawContacts.CONTACT_ID + ", "
1725 + RawContacts.CONTACT_ID + ", "
1780 + RawContacts.CONTACT_ID + ", "
1813 + RawContactsColumns.CONCRETE_CONTACT_ID + " AS " + RawContacts.CONTACT_ID + ", "
1855 + RawContactsColumns.CONCRETE_CONTACT_ID + " AS " + RawContacts.CONTACT_ID + ", "
1873 ContactsColumns.CONCRETE_ID + " AS " + StreamItems.CONTACT_ID + ", " +
2621 " WHERE contact_id NOT NULL" +
2622 " AND contact_id NOT IN (SELECT _id FROM contacts)");
2637 " WHERE " + RawContacts.CONTACT_ID + "=" + ContactsColumns.CONCRETE_ID +
2655 " WHERE " + RawContacts.CONTACT_ID + "=" + ContactsColumns.CONCRETE_ID +
2674 " WHERE " + Contacts._ID + "=" + RawContacts.CONTACT_ID + ")" +
2675 " WHERE " + RawContacts.CONTACT_ID + " NOT NULL"
3044 "SELECT DISTINCT contact_id " +
3055 "WHERE contact_id=? " +
3112 "WHERE NOT EXISTS (SELECT 1 FROM raw_contacts WHERE contact_id=contacts._id)");
3548 " SELECT contact_id " +
3555 " SELECT contact_id " +
3568 " SELECT contact_id " +
4002 "contact_id INTEGER PRIMARY KEY," +
4606 "SELECT " + RawContacts.CONTACT_ID +
4611 " WHERE " + RawContacts.CONTACT_ID + "=?1" +
4616 " WHERE " + RawContacts.CONTACT_ID + "=?1" +
4627 " WHERE " + RawContacts.CONTACT_ID + "=?1" +
4652 " WHERE " + SearchIndexColumns.CONTACT_ID + "=CAST(? AS int)",
4710 "SELECT " + RawContacts.CONTACT_ID +
4764 + "." + RawContacts.CONTACT_ID + ")" +
4817 + " ON (contacts_view._id = raw_contacts.contact_id)");
5163 " WHERE " + RawContacts.CONTACT_ID + "=(" +
5164 "SELECT " + RawContacts.CONTACT_ID +
5485 " WHERE " + RawContacts.CONTACT_ID + " =(" +
5486 "SELECT " + RawContacts.CONTACT_ID +
5617 " WHERE " + SearchIndexColumns.CONTACT_ID + "=CAST(? AS int)",
5626 " WHERE " + SearchIndexColumns.CONTACT_ID + "=CAST(? AS int)",
