/diesel

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table collisions on join #1289

Closed
csharad opened this Issue Nov 2, 2017 · 1 comment

Comments

Assignees
No one assigned
Labels
Projects
None yet
Milestone
No milestone
3 participants
@csharad @sgrif @weiznich
@csharad
Contributor

csharad commented Nov 2, 2017

Setup

Versions

  • Rust: rustc 1.22.0-nightly (6f87d20a7 2017-09-29)
  • Diesel: 0.16.0
  • Database: mysql
  • Operating System: Ubuntu 17.04

Feature Flags

  • diesel: ["mysql", "chrono", "unstable", "numeric"]
  • diesel_codegen: ["mysql"]

Problem Description

When the same table is joined twice, they collide(as expected).

jobs::table
    .left_join(job_categories::table)
    .left_join(companies::table.left_join(addresses::table))
    .left_join(job_companies::table.left_join(addresses::table))
    .load(conn)?;

What are you trying to accomplish?

I am trying to join both of them aliased.

What is the expected output?

The code (may be) with additional modification to execute successfully.

What is the actual output?

error[E0271]: type mismatch resolving `<diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>> as diesel::query_source::AppearsInFromClause<schema::__diesel_infer_schema::infer_addresses::addresses::table>>::Count == diesel::query_source::Never`
  --> src/models/job.rs:74:14
   |
74 |             .left_join(job_companies::table.left_join(addresses::table))
   |              ^^^^^^^^^ expected struct `diesel::query_source::Succ`, found struct `diesel::query_source::Never`
   |
   = note: expected type `diesel::query_source::Succ<diesel::query_source::Never>`
              found type `diesel::query_source::Never`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `schema::__diesel_infer_schema::infer_addresses::addresses::columns::id`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `((schema::__diesel_infer_schema::infer_companies::companies::columns::id, schema::__diesel_infer_schema::infer_companies::companies::columns::name, schema::__diesel_infer_schema::infer_companies::companies::columns::company_type, schema::__diesel_infer_schema::infer_companies::companies::columns::created_internally, schema::__diesel_infer_schema::infer_companies::companies::columns::address_id, schema::__diesel_infer_schema::infer_companies::companies::columns::pan_no, schema::__diesel_infer_schema::infer_companies::companies::columns::contactable_id, schema::__diesel_infer_schema::infer_companies::companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_companies::companies::columns::id, schema::__diesel_infer_schema::infer_companies::companies::columns::name, schema::__diesel_infer_schema::infer_companies::companies::columns::company_type, schema::__diesel_infer_schema::infer_companies::companies::columns::created_internally, schema::__diesel_infer_schema::infer_companies::companies::columns::address_id, schema::__diesel_infer_schema::infer_companies::companies::columns::pan_no, schema::__diesel_infer_schema::infer_companies::companies::columns::contactable_id, schema::__diesel_infer_schema::infer_companies::companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `((schema::__diesel_infer_schema::infer_jobs::jobs::columns::id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::title, schema::__diesel_infer_schema::infer_jobs::jobs::columns::description, schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::salary, schema::__diesel_infer_schema::infer_jobs::jobs::columns::qualification, schema::__diesel_infer_schema::infer_jobs::jobs::columns::deadline, schema::__diesel_infer_schema::infer_jobs::jobs::columns::quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::male_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::female_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::created_by, schema::__diesel_infer_schema::infer_jobs::jobs::columns::posted_on, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id, schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::name)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_companies::companies::columns::id, schema::__diesel_infer_schema::infer_companies::companies::columns::name, schema::__diesel_infer_schema::infer_companies::companies::columns::company_type, schema::__diesel_infer_schema::infer_companies::companies::columns::created_internally, schema::__diesel_infer_schema::infer_companies::companies::columns::address_id, schema::__diesel_infer_schema::infer_companies::companies::columns::pan_no, schema::__diesel_infer_schema::infer_companies::companies::columns::contactable_id, schema::__diesel_infer_schema::infer_companies::companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>)`
   = note: required because of the requirements on the impl of `diesel::QuerySource` for `diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>`
   = note: required because of the requirements on the impl of `diesel::QuerySource` for `diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::select_clause::SelectClauseExpression<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `diesel::query_builder::select_clause::DefaultSelectClause`
   = note: required because of the requirements on the impl of `diesel::query_builder::Query` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::AsQuery` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::InternalJoinDsl<diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>>`

error[E0271]: type mismatch resolving `<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner> as diesel::query_source::AppearsInFromClause<schema::__diesel_infer_schema::infer_addresses::addresses::table>>::Count == diesel::query_source::Succ<diesel::query_source::Never>`
  --> src/models/job.rs:74:14
   |
74 |             .left_join(job_companies::table.left_join(addresses::table))
   |              ^^^^^^^^^ expected struct `diesel::query_source::Succ`, found struct `diesel::query_source::Never`
   |
   = note: expected type `diesel::query_source::Succ<diesel::query_source::Succ<diesel::query_source::Never>>`
              found type `diesel::query_source::Succ<diesel::query_source::Never>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `schema::__diesel_infer_schema::infer_addresses::addresses::columns::id`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::Inner>>` for `((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `((schema::__diesel_infer_schema::infer_jobs::jobs::columns::id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::title, schema::__diesel_infer_schema::infer_jobs::jobs::columns::description, schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::salary, schema::__diesel_infer_schema::infer_jobs::jobs::columns::qualification, schema::__diesel_infer_schema::infer_jobs::jobs::columns::deadline, schema::__diesel_infer_schema::infer_jobs::jobs::columns::quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::male_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::female_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::created_by, schema::__diesel_infer_schema::infer_jobs::jobs::columns::posted_on, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id, schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::name)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_companies::companies::columns::id, schema::__diesel_infer_schema::infer_companies::companies::columns::name, schema::__diesel_infer_schema::infer_companies::companies::columns::company_type, schema::__diesel_infer_schema::infer_companies::companies::columns::created_internally, schema::__diesel_infer_schema::infer_companies::companies::columns::address_id, schema::__diesel_infer_schema::infer_companies::companies::columns::pan_no, schema::__diesel_infer_schema::infer_companies::companies::columns::contactable_id, schema::__diesel_infer_schema::infer_companies::companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>)`
   = note: required because of the requirements on the impl of `diesel::QuerySource` for `diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>`
   = note: required because of the requirements on the impl of `diesel::QuerySource` for `diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::select_clause::SelectClauseExpression<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `diesel::query_builder::select_clause::DefaultSelectClause`
   = note: required because of the requirements on the impl of `diesel::query_builder::Query` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::AsQuery` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::InternalJoinDsl<diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>>`

error[E0271]: type mismatch resolving `<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter> as diesel::query_source::AppearsInFromClause<schema::__diesel_infer_schema::infer_addresses::addresses::table>>::Count == diesel::query_source::Succ<diesel::query_source::Never>`
  --> src/models/job.rs:74:14
   |
74 |             .left_join(job_companies::table.left_join(addresses::table))
   |              ^^^^^^^^^ expected struct `diesel::query_source::Succ`, found struct `diesel::query_source::Never`
   |
   = note: expected type `diesel::query_source::Succ<diesel::query_source::Succ<diesel::query_source::Never>>`
              found type `diesel::query_source::Succ<diesel::query_source::Never>`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `schema::__diesel_infer_schema::infer_addresses::addresses::columns::id`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>>` for `((schema::__diesel_infer_schema::infer_jobs::jobs::columns::id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::title, schema::__diesel_infer_schema::infer_jobs::jobs::columns::description, schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::salary, schema::__diesel_infer_schema::infer_jobs::jobs::columns::qualification, schema::__diesel_infer_schema::infer_jobs::jobs::columns::deadline, schema::__diesel_infer_schema::infer_jobs::jobs::columns::quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::male_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::female_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::created_by, schema::__diesel_infer_schema::infer_jobs::jobs::columns::posted_on, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id, schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::name)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_companies::companies::columns::id, schema::__diesel_infer_schema::infer_companies::companies::columns::name, schema::__diesel_infer_schema::infer_companies::companies::columns::company_type, schema::__diesel_infer_schema::infer_companies::companies::columns::created_internally, schema::__diesel_infer_schema::infer_companies::companies::columns::address_id, schema::__diesel_infer_schema::infer_companies::companies::columns::pan_no, schema::__diesel_infer_schema::infer_companies::companies::columns::contactable_id, schema::__diesel_infer_schema::infer_companies::companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>)`
   = note: required because of the requirements on the impl of `diesel::QuerySource` for `diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>`
   = note: required because of the requirements on the impl of `diesel::QuerySource` for `diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::select_clause::SelectClauseExpression<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `diesel::query_builder::select_clause::DefaultSelectClause`
   = note: required because of the requirements on the impl of `diesel::query_builder::Query` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::AsQuery` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::InternalJoinDsl<diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>>`

error[E0271]: type mismatch resolving `<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>> as diesel::query_source::AppearsInFromClause<schema::__diesel_infer_schema::infer_addresses::addresses::table>>::Count == diesel::query_source::Succ<diesel::query_source::Never>`
  --> src/models/job.rs:74:14
   |
74 |             .left_join(job_companies::table.left_join(addresses::table))
   |              ^^^^^^^^^ expected struct `diesel::query_source::Succ`, found struct `diesel::query_source::Never`
   |
   = note: expected type `diesel::query_source::Succ<diesel::query_source::Succ<diesel::query_source::Never>>`
              found type `diesel::query_source::Succ<diesel::query_source::Never>`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `schema::__diesel_infer_schema::infer_addresses::addresses::columns::id`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)`
   = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>`
   = note: required because of the requirements on the impl of `diesel::SelectableExpression<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `((schema::__diesel_infer_schema::infer_jobs::jobs::columns::id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::title, schema::__diesel_infer_schema::infer_jobs::jobs::columns::description, schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::salary, schema::__diesel_infer_schema::infer_jobs::jobs::columns::qualification, schema::__diesel_infer_schema::infer_jobs::jobs::columns::deadline, schema::__diesel_infer_schema::infer_jobs::jobs::columns::quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::male_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::female_quantity, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id, schema::__diesel_infer_schema::infer_jobs::jobs::columns::created_by, schema::__diesel_infer_schema::infer_jobs::jobs::columns::posted_on, schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id, schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::name)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_companies::companies::columns::id, schema::__diesel_infer_schema::infer_companies::companies::columns::name, schema::__diesel_infer_schema::infer_companies::companies::columns::company_type, schema::__diesel_infer_schema::infer_companies::companies::columns::created_internally, schema::__diesel_infer_schema::infer_companies::companies::columns::address_id, schema::__diesel_infer_schema::infer_companies::companies::columns::pan_no, schema::__diesel_infer_schema::infer_companies::companies::columns::contactable_id, schema::__diesel_infer_schema::infer_companies::companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>, diesel::expression::nullable::Nullable<((schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::name, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::contactable_id, schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::created_by), diesel::expression::nullable::Nullable<(schema::__diesel_infer_schema::infer_addresses::addresses::columns::id, schema::__diesel_infer_schema::infer_addresses::addresses::columns::location)>)>)`
   = note: required because of the requirements on the impl of `diesel::QuerySource` for `diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::select_clause::SelectClauseExpression<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` for `diesel::query_builder::select_clause::DefaultSelectClause`
   = note: required because of the requirements on the impl of `diesel::query_builder::Query` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::query_builder::AsQuery` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>`
   = note: required because of the requirements on the impl of `diesel::InternalJoinDsl<diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>` for `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>>`

error[E0599]: no method named `load` found for type `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>>` in the current scope
  --> src/models/job.rs:75:14
   |
75 |             .load(conn)?;
   |              ^^^^
   |
   = note: the method `load` exists but the following trait bounds were not satisfied:
           `diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>> : diesel::LoadDsl<_>`
           `&diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>> : diesel::LoadDsl<_>`
           `&mut diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_jobs::jobs::table, schema::__diesel_infer_schema::infer_job_categories::job_categories::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_category_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_categories::job_categories::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_companies::companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_companies::companies::columns::id>>>, diesel::query_builder::SelectStatement<diesel::query_source::joins::JoinOn<diesel::query_source::joins::Join<schema::__diesel_infer_schema::infer_job_companies::job_companies::table, schema::__diesel_infer_schema::infer_addresses::addresses::table, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::address_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_addresses::addresses::columns::id>>>>, diesel::query_source::joins::LeftOuter>, diesel::expression::operators::Eq<diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_jobs::jobs::columns::job_company_id>, diesel::expression::nullable::Nullable<schema::__diesel_infer_schema::infer_job_companies::job_companies::columns::id>>>> : diesel::LoadDsl<_>`

error: aborting due to 5 previous errors

Checklist

  • I have already looked over the issue tracker for similar issues.

@weiznich weiznich added hole in api needs milestone labels Nov 7, 2017

@sgrif

This comment has been minimized.

Sign in to view
Member

sgrif commented Nov 8, 2017

We do not currently support allowing the same table to appear multiple times in a single query. This is a duplicate of the table aliasing feature

@sgrif sgrif closed this Nov 8, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment