View Single Post
Old 12-28-2022, 02:18 AM   #4
tn4w
Enthusiast
tn4w began at the beginning.
 
Posts: 34
Karma: 10
Join Date: Aug 2022
Device: Windows 10
Quote:
Originally Posted by JSWolf View Post
But for now, ASIN extraction is a manual process.
Thanks for the info.

For now, I resort to a third-party SQL program. This query seems to do the job.

Code:
SELECT identifiers.val FROM books LEFT JOIN data ON books.id = data.book LEFT JOIN identifiers ON identifiers.book = books.id WHERE title LIKE '%keyword%' AND data.format IN ( 'AZW3' ) AND data.format NOT IN ( 'ZIP' ) AND data.uncompressed_size >= 20000000 AND identifiers.type = 'asin';
tn4w is offline   Reply With Quote