Sailfish_Contacts_Restore/SQL/Abfragen.sql

SELECT * FROM Contacts;
SELECT * FROM Contacts JOIN EmailAddresses ON Contacts.contactId = EmailAddresses.contactId;

SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId;
SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId WHERE PhoneNumbers.contactId=42;
SELECT * FROM Contacts JOIN Addresses ON Contacts.contactId = Addresses.contactId WHERE displayLabel like '%oduma%';
SELECT * FROM Addresses JOIN Details on Addresses.detailId=Details.detailId WHERE Addresses.contactId=7;
SELECT * from Organizations where contactId = 7;
SELECT * from EmailAddresses JOIN Details on Details.detailId= EmailAddresses.detailId where EmailAddresses.contactId = 8;
SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId where PhoneNumbers.contactId = 4;
SELECT imageURL from Avatars where contactId = 8;