Quote:
Originally Posted by davidfor
Code:
SELECT name, COUNT(c.contentID)
FROM shelf s LEFT OUTER JOIN shelfContent sc ON s.name = sc.shelfname
LEFT OUTER JOIN content c ON c.contentid = sc.contentid
WHERE (c.contentType = 6 or c.contentType IS NULL)
AND (externalId IS NULL OR externalid = '90164EF8' OR externalid = '')
AND s._IsDeleted = 'false'
AND (sc._IsDeleted = 'false' OR sc._IsDeleted is NULL)
GROUP BY name
ORDER BY name
|
I've browsed most of the executables and libraries in the firmware, and I will admit I don't see any elaborate queries there involving shelves.