Sorry if this is answered somewhere, but I've been trying to search and haven't found an answer.. So here goes... I'm querying the visitors table with a specific visitor_id inthe where clause and getting multiple rows. I was under the impression that visitor_id was the PK in this table and there would only be one row per distinct visitor_id. In my example, I get 7 rows with an identical visitor_id, identical visitor_created timestamps, and different updated timestamps. While this is an isolated visitor_id, there are others and I'm ultimately looking to query a few property values and badge values for visitors as of "now" and am having trouble getting unique values. Am I going about it wrong?
... View more