Get interests for contact

Some tooltip text!

• 1 minute to read

 • 1 minute to read

To get a list of interests checked off for a contact:

SELECT * FROM contactinterest WHERE contact_id = 123

To get the names of the checked-off interests for a contact:

SELECT * FROM contactinterest, contint
WHERE contactinterest.contact_id = 123
AND contactinterest.cinterest_idx = contint.contint_id

contactinterest_id	contact_id	cinterest_idx	>	ContInt_id	name	rank	tooltip	deleted
53459	123	594		594	SAP	142		0
53640	123	1569		1569	Developers	195	This company has...	0