Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
-
CarlosPB50
- Posts: 1
- Joined: Tue May 17, 2022 9:31 pm
Post
by CarlosPB50 » Thu May 19, 2022 2:27 pm
I'm trying to extract the patents that have Artificial intelligence in the title or abs filed in Korea or WO, besides that use distintct, so i dont double the inventions, but i dont know how to include WO and where put distinct. Can you guys help me?
Code: Select all
SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%' OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND APP.APPLN_AUTH = 'KR'
-
gianluca.tarasconi
- Posts: 63
- Joined: Mon Nov 09, 2009 8:48 pm
- Location: Italy
-
Contact:
Post
by gianluca.tarasconi » Fri Jun 24, 2022 2:14 pm
Dear Carlos
if you want to select all patents coming via PCT route from any country just add in your selection criteria
APPLN_AUTH = 'WO'
Code: Select all
SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%'
OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%'
OR ABS.APPLN_ABSTRACT LIKE '%인공 지능'
OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND ( APP.APPLN_AUTH = 'KR' or APP.APPLN_AUTH = 'WO')
if instead you need the pct applications filed via the Korean patent office, just add RECEIVING_OFFICE = "KR"
Code: Select all
SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%'
OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%'
OR ABS.APPLN_ABSTRACT LIKE '%인공 지능'
OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND ( APP.APPLN_AUTH = 'KR' or RECEIVING_OFFICE = "KR")