error[E0271]: type mismatch resolving `<table as AppearsInFromClause<table>>::Count == Once`
    --> src/main.rs:33:15
     |
33   |         .load(conn)
     |          ---- ^^^^ expected `Once`, found `Never`
     |          |
     |          required by a bound introduced by this call
     |
note: required for `posts::columns::published` to implement `AppearsOnTable<users::table>`
    --> src/main.rs:22:9
     |
22   |         published -> Bool,
     |         ^^^^^^^^^
     = note: associated types for the current `impl` cannot be restricted in `where` clauses
     = note: 2 redundant requirements hidden
     = note: required for `Grouped<Eq<published, Bound<Bool, bool>>>` to implement `AppearsOnTable<users::table>`
     = note: required for `WhereClause<Grouped<Eq<published, ...>>>` to implement `diesel::query_builder::where_clause::ValidWhereClause<FromClause<users::table>>`
     = note: required for `SelectStatement<FromClause<...>, ..., ..., ...>` to implement `Query`
     = note: required for `SelectStatement<FromClause<...>, ..., ..., ...>` to implement `LoadQuery<'_, _, _>`
note: required by a bound in `diesel::RunQueryDsl::load`
    --> $HOME/.cargo/registry/src/index.crates.io-1949cf8c6b5b557f/diesel-2.1.6/src/query_dsl/mod.rs:1542:15
     |
1540 |     fn load<'query, U>(self, conn: &mut Conn) -> QueryResult<Vec<U>>
     |        ---- required by a bound in this associated function
1541 |     where
1542 |         Self: LoadQuery<'query, Conn, U>,
     |               ^^^^^^^^^^^^^^^^^^^^^^^^^^ required by this bound in `RunQueryDsl::load`
     = note: the full name for the type has been written to '/private/tmp/bad-select/target/debug/deps/bad_select-a667b986b9e69ba3.long-type-2129132941735277502.txt'
     = note: consider using `--verbose` to print the full type name to the console

For more information about this error, try `rustc --explain E0271`.
error: could not compile `bad-select` (bin "bad-select") due to 1 previous error