On 2/11/2012 4:45 PM, Marcello Perathoner wrote:
SELECT books.pk as url, books.title, books.author, books.downloads, books.release_date, books.fk_categories FROM v_appserver_books_categories_2 as books WHERE books.tsvec @@ to_tsquery ('english', E'Struww:*') ORDER BY downloads DESC LIMIT 25
Very good, thank you. This suggests that most of the data on the Bibrec screen comes from the books.fk_categories column. On the other hand, you naming convention suggests that the fk_categories tuple is actually foreign keys into another table. Is this correct? If so, what is the other table? Mr. Newby -- Is this database mirrored to readingroo.ms? If not, can it be? Mr. Perathoner -- Can you post, or point me to, the schema definition of this entire database?