select *,date_format(modify_date,'%Y-%m-%d') as md from tbl_post where (photo <> '' ) and view = 'y' and seq_local = '1' order by modify_date desc limit 4;
COMMIT