>>select distinct pagetitle,logicalgageno,imagepath,map,maps,mapl,ifnull(title,' ') as title,pagedate,a.editioncode from epaper a inner join editions b where a.editioncode=b.editioncode and pagedate='2023-02-02' and a.editioncode ='1' order by logicalgageno asc