KR or WO as countries publication

[CarlosPB50]

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?

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]

Dear Carlos
if you want to select all patents coming via PCT route from any country just add in selection criteria
APPLN_AUTH = 'WO'

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 KR pct applications, just add RECEIVING_OFFICE = "KR"

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")