added calculated publishing status query