Quote:
Originally Posted by JSWolf
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';