Hi, I have another question concerning my search query. First search query: SELECT DISTINCT a.* FROM tls201_appln a JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id JOIN tls206_person p on pa.person_id = p.person_id WHERE appln_auth = 'EP' AND a.appln_id < 900000000 -- exclude artificial applic...

Thanks for your help. I adjusted the query to the following code: SELECT DISTINCT * FROM tls201_appln a JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id JOIN tls206_person p on pa.person_id = p.person_id WHERE a.appln_id < 900000000 -- exclude artificial applications (see PATSTAT Data Catalog f...

Thanks for your reply! I have another question: With the query above I only get the EP applications filed by the German company "Siemens". SELECT DISTINCT a.* FROM tls201_appln a JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id JOIN tls206_person p on pa.person_id = p.person_id WHERE ...

Hello everyone, concerning my recent research project I need the following data: the number of patents applied concerning a specific company in a specific year. For example: Company: Siemens Year: 2013 Therefore I found this query which works great. SELECT DISTINCT a.* FROM tls201_appln a JOIN tls20...

Hi, concerning my recent research project I need the following data: the number of patents applied concerning a specific company in a specific year. Example for Advanced search of Espacenet: Application number: 2010 Applicants: "Robert Bosch GmbH" To promote the understanding of my questio...

Hi, concerning my recent research project I need the following data: the number of patents granted/applied concerning a specific company in a specific year. For example: Company: Robert Bosch GmbH Year: 2010 To promote the understanding of my question this link may help: https://www.epo.org/about-us...