Thread: Making wish list public
View Single Post
Old 09-21-2013, 07:17 PM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Sorry, I don't know what is happening. I don't have any book rows in the content table that don't have an attribution. But, I probably should have had the condition "AND BookID IS NULL". It shouldn't make a difference, but it is slightly more correct.

But, when I looked at the above query, I couldn't work out why I gave you that one. The Wishlist in the current firmware is handled as a shelf. I think the following is a better query:

Code:
SELECT *
FROM ShelfContent s JOIN content c USING(ContentId)
WHERE ShelfName = "Wishlist"
AND _IsDeleted = 'false'
When I checked this by adding a couple of items to the wishlist on my Glo, I found that the ContentURL was set for these books. The previous items have been on my wishlist for a while, so maybe there has been a change in how they are handled.
davidfor is offline   Reply With Quote