citing publications

[marcastell]

Hi,

I would like to search, for every patent I am interested in, the id of patents that cite it. I write the relevant extract of my query:

join tls211_pat_publn t2b ON t2b.appln_id = a.appln_id // retrieving its publication data
join tls212_citation t3 ON t2b.pat_publn_id = t3.cited_pat_publn_id // retrieving info of citing publications
join tls211_pat_publn t4 ON t3.pat_publn_id = t4.pat_publn_id // retrieving appln_id of citing publication

However, this returns me only one citing publication, as if each patent has been cited only once.
Is my query wrong? Can you help me with it?

Thanks!!

[EPO / PATSTAT Support]

Hello Marcastell,
there are plenty of forum posts on this topic.
Have a look here:
forward-and-backward-citation-7892