SELECT brds.brddesc,prds.prddesc,dat.art,dat.cntry,date_format(dat.sdat,'%d/%m/%Y') as sdat,
						dat.lan,dat.mt,dat.med,dat.pg,dat.siz,dat.phsz,dat.pgpos,dat.col,dat.pgdet,dat.sub,dat.ser,
						dat.val/10 as val1,(dat.val/10)*3.5 as val2,dat.fn,date_format(dat.sdatupl,'%d/%m/%Y %h:%i:%s %p' ) as udate,tbl_circ.circ,'0' as frequency,dat.bcode
						FROM tbl_artothtree dat 
						LEFT JOIN tbl_brd brds ON left( dat.bcode, 8 ) = brds.brdcd 
						LEFT JOIN tbl_prd prds ON left( dat.bcode, 4 ) = prds.prdcd 
						LEFT JOIN tbl_subbrd subbrd ON dat.bcode = subbrd.subbrdcd 
						LEFT JOIN tbl_circ ON  ucase(trim(dat.med))  = ucase(trim(tbl_circ.med))
						WHERE (dat.sdatupl >= now() - INTERVAL 24 HOUR)  and ( dat.bcode like '52372208%'  or  dat.bcode like '57116717%' )  and ( dat.cntry like 'P%'  or  dat.cntry like 'S%' )  and (fn like '%2007.jpg' or fn like '%200701.jpg%') order by brds.brddesc,dat.sdat desc,5