Select dat.cl,dat.sucl,dat.cntry,date_format(dat.sdat,'%d/%m/%Y') as sdat,dat.bcode,dat.med,dat.pg,dat.nbpg,dat.siz,dat.phsz,dat.pgpos,dat.col,
						dat.pgdet,dat.sub,dat.ser,dat.art,dat.mt,dat.lan,dat.val,dat.spc,dat.grps1,dat.grps2,dat.grps3,
						dat.grps4,date_format(dat.sdatupl,'%d/%m/%Y %h:%i:%s %p' ) as udate,dat.emailed,dat.val/10 as val1,(dat.val/10)*3.5 as val2,dat.fn,0 as circ,
						left( dat.bcode, 8 ),'' as brddesc,left( dat.bcode, 4 ),'' as prddesc,'' as prdlongdesc,
						'' as subbrdcd,'' as subbrddesc,left( dat.grps2,6) as med_cd,'' as med_desc,'' as mt_detail
						FROM tbl_artothtree dat 
					WHERE (dat.sdatupl >= now() - INTERVAL 24 HOUR)  and ( dat.bcode like '%' )  and (fn like '%2007.jpg' or fn like '%200701.jpg%')