Here’s the problem:
My client has added an extra profile field (field_id = 72) asking whether the client would like to receive the monthly newsletter. I suppose it’s saved in cscart_profile_fields_data but how will I link it to a user?
So basically what I need is a query that shows me all the users that want to receive the newsletter and those who don’t.
user1 Y
user2 Y
user3 N
user4 Y