select pp.*,date_format(pp.fdate, '%b %D,%Y') as fdate,
date_format(pp.fdate, '%Y%m%d') as date,
pp.ftitle as ftitle,pp.ftitleconfirmed as titleconf
from atuserpicture up
inner join atpicture pp on pp.fid = up.frpicture where (fconfirmed in (1)) order by RAND(),fid desc limit 6 offset 0
Send FREE TEXT
