SELECT items.barcode as "Inventario", 
CONCAT(biblio.title,' ',COALESCE(biblio.author,""),' .--',COALESCE(biblioitems.place,""),' ',COALESCE(biblioitems.publishercode,""),' ',COALESCE(biblio.copyrightdate,"")) as "Cajita Viajera 1"  
FROM items 
 LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) 
 LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) 
 where items.barcode IN ('ch1','00291','2715','4564','1234')
ORDER BY items.barcode asc