cc.id=pc.asid and cc.status=1 and pc.status=1 and pc.edit_date>date_format(date_add(now(),interval - 30 day),'%Y-%m-%d 00:00:00') order by pc.edit_date desc