 SELECT Community2Item.community_id, ItemsByAuthor.* 
 FROM ItemsByAuthor, Community2Item
 WHERE ItemsByAuthor.item_id = Community2Item.item_id
-ORDER BY Author, ItemsByAuthor.item_id
 ;
 
 -------------------------------------------------------

SELECT Collection2Item.collection_id, ItemsByAuthor.* 
FROM ItemsByAuthor, Collection2Item
WHERE ItemsByAuthor.item_id = Collection2Item.item_id
ORDER BY Author, ItemsByAuthor.item_id
;

-------------------------------------------------------

-- ItemsByTitle view
----------------------------------------

DROP TABLE ItemsByTitle;

CREATE TABLE ItemsByTitle
(
   items_by_title_id  INTEGER PRIMARY KEY,
   item_id            INTEGER REFERENCES Item(item_id),
   title              TEXT,
   sort_title         TEXT
);

-------------------------------------------------------
--  CollectionItemsByTitle view
