RETURNING *""")
print("* ["+("%07.6g"%round(time.time() - TS_START, 5))+"] "+str(cur.rowcount)+" updated non-empty channel lastpostat.")
-# remove prop:"{"disable_group_highlight":true}" - its only set by the webapp, not by the android app. Doing... unsure what.
-#cur.execute("""UPDATE posts SET props='{}' WHERE props='{"disable_group_highlight":true}' RETURNING *""")
-#print("* ["+("%07.6g"%round(time.time() - TS_START, 5))+"] "+str(cur.rowcount)+" removed obscure post-properti(y/ies).")
-
# good enough approach: channelmembers msgcount and lastviewedat (mm sometimes checks diffrences in msg counts and sometimes its lastviewedat. 0 for both is ok)
cur.execute("""UPDATE channelmembers SET msgcount = totalmsgcount, msgcountroot = totalmsgcountroot, lastviewedat = lastpostat FROM channels
WHERE channelid = channels.id AND (msgcount > totalmsgcount OR msgcountroot > totalmsgcountroot OR lastviewedat > lastpostat) RETURNING *""")