select "tenants".*, (selectcount(*) from "tenant_reviews" where "tenants"."id" = "tenant_reviews"."tenant_id" and "tenant_reviews"."deleted_at" isnull limit 0) as "reviews_count" from "tenants" where "slug" ='phinisi-utami-logistik'and "tenants"."deleted_at" isnull limit 1
select*from "tenant_addresses" where "type" ='head_office'and "tenant_addresses"."tenant_id" in ('9c9f3a5e-68be-4288-afbb-fd668b9d5bfc') and "tenant_addresses"."deleted_at" isnull
select "categories".*, "tenant_categories"."tenant_id" as "pivot_tenant_id", "tenant_categories"."category_id" as "pivot_category_id" from "categories" innerjoin "tenant_categories" on "categories"."id" = "tenant_categories"."category_id" where "tenant_categories"."tenant_id" ='9c9f3a5e-68be-4288-afbb-fd668b9d5bfc'and "categories"."deleted_at" isnull
select "tenant_review_rates".*, "tenant_reviews"."tenant_id" as "laravel_through_key" from "tenant_review_rates" innerjoin "tenant_reviews" on "tenant_reviews"."id" = "tenant_review_rates"."tenant_review_id" where "tenant_reviews"."tenant_id" ='9c9f3a5e-68be-4288-afbb-fd668b9d5bfc'and "tenant_reviews"."deleted_at" isnull