Query Results Error When I Join Multitable

[trantrinhquocviet]

select
  query_1167.abbreation_name payment_name
  coalesce(query_1182.paid_users,0) paid_users,
  coalesce(query_1175.total_users,0) total_users,
  coalesce(query_1179.deactivate_users,0) deactivate_users,
  coalesce(query_1176.organization_users,0) organization_users,
  coalesce(query_1182.paid_users,0) - coalesce(query_1176.organization_users,0) warning,
  coalesce(query_1177.pending_users,0) pending_users,
  coalesce(query_1178.active_user_plus,0) active_user_plus,
  coalesce(query_1180.active_user_minus,0) active_user_minus,
  coalesce(query_1194.active_user_plus_recent,0) active_user_plus_recent
FROM
  query_1167
  LEFT JOIN query_1128 ON query_1128.company_id= query_1167.customer_company_id
  LEFT JOIN query_1175 ON query_1175.company_id = query_1167.customer_company_id
  LEFT JOIN query_1176 ON query_1176.company_id = query_1167.customer_company_id
  LEFT JOIN query_1179 ON query_1179.company_id = query_1167.customer_company_id
  LEFT JOIN query_1177 ON query_1177.company_id = query_1167.customer_company_id
  LEFT JOIN query_1178 ON query_1178.company_id = query_1167.customer_company_id
  LEFT JOIN query_1180 ON query_1180.company_id = query_1167.customer_company_id
  LEFT JOIN query_1182 ON query_1182.company_id = query_1167.customer_company_id
  LEFT JOIN query_1194 ON query_1194.company_id = query_1167.customer_company_id
WHERE
  query_1167.payment_id not in
  (SELECT distinct payment_id FROM query_1129  
    WHERE CURRENT_DATE >= date(started_stage) 
    AND CURRENT_DATE <= date(ended_stage)
    AND status = 'Churn')

=> Error running query: no such column: customer_company_id

I have problem with field customer_company_id when i call more 4 times.

I'm sure the field "customer_company_id" existed in query_results_1167.

I have some questions:

• is them problem to relate the ram?
• what is limited to call query_results?

[mirkan1]

What happens when you call this query on the given database?