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

);

-- An index for dctypes
CREATE INDEX dcvalue_dc_type_id_idx  on DCValue(dc_type_id);

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

SELECT Collection2Item.collection_id, ItemsByDate.* 
FROM ItemsByDate, Collection2Item
WHERE ItemsByDate.item_id = Collection2Item.item_id
;

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