You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
=> 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:
The text was updated successfully, but these errors were encountered: