modify query for chancat and channel