MobileRead Forums - View Single Post - [GUI Plugin] Multi-Column Search

Tanjamuse · 10-20-2017, 07:21 AM

I tried to run the following SQL Query

Code:

SELECT book  FROM books_custom_column_9_link
 WHERE value IN
 ( SELECT value 
 FROM books_custom_column_9_link
 GROUP BY value 
 HAVING COUNT(*) > 1 )

and got this error:

Code:

calibre, version 3.6.0
ERROR: MCS: Raw SQL Query Fatal Error:   SQLError: no such table: books_custom_column_9_link

Since I changed the 9. expression in the Regular Expression tab can I use one of the other expressions and what do I write?

10-20-2017, 07:21 AM	#227
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I tried to run the following SQL Query Code: SELECT book FROM books_custom_column_9_link WHERE value IN ( SELECT value FROM books_custom_column_9_link GROUP BY value HAVING COUNT(*) > 1 ) and got this error: Code: calibre, version 3.6.0 ERROR: MCS: Raw SQL Query Fatal Error: SQLError: no such table: books_custom_column_9_link Since I changed the 9. expression in the Regular Expression tab can I use one of the other expressions and what do I write?