Which articles are read when a certain article has also been read

[#1]

I've tried searching the forum for an answer, but honestly I wouldn't even know what keywords to use for this problem. My problem is as follows:

On our company website customers can find articles or content about common problems they encounter with products. These articles are in our database with a unique id (Article_ID).

Each visit is logged in a database as a Visitor_ID. Each content item/article that has been clicked on is also entered in the database with Type_ID (in this case 6) and Type_Value with the used Article ID. If during a visit a customer clicks on more then artickle it would look like this:

Visitor_ID	Type_ID	Type_Value
1	6	99
1	6	33
1	6	13
1	6	1340
2	6	99
2	6	19
3	6	99
3	6	125
3	6	8
4	6	7
4	6	125

What I would like to know is our customers have read/clicked on Article_ID 99, which other articles have they also read/clicked on.

For example when Article_ID 99 has been read, it should come back with 33, 13, 1349,19,125 and 8. When Article_ID 125 has been read, it should come back with 7 and 8.

The answer is probably very simple, but I can't wrap my head around this one.

[#2 · Accepted solution]

I dont' think the answer is simple.

Look at the attachment.

I just duplicated all the value (cartesian product) to create a new field type_value2 link to type_value by the Visitor_Id.

I'm not sure it's what you want. I suppose you have to take in consideration the order of items.

regards

jj