SELECT  items.itemnumber,items.coded_location_qualifier FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)   WHERE biblio.datecreated >= '2024-07-22' AND biblio.datecreated <= '2024-07-22'