Untitled

SELECT 
    "history_quota"."id", 
    "history_quota"."agent_id", 
    "history_quota"."project_id", 
    "history_quota"."advertises_id", 
    "history_quota"."office_id", 
    "history_quota"."advertises", 
    "history_quota"."transaction_date", 
    "history_quota"."status", 
    "history_quota"."createdAt", 
    "history_quota"."updatedAt", 
    (SELECT id FROM advertises where advertises.ads_id = history_quota.advertises_id ) AS "id_ads", 
    (SELECT is_publish FROM advertises where advertises.ads_id = history_quota.advertises_id ) AS "status_ads", 
    (SELECT CASE WHEN advertises.is_publish != 0 and advertises.is_publish != 2 THEN advertises."createdAt" + INTERVAL '90 days' ELSE NULL END FROM advertises where advertises.ads_id = history_quota.advertises_id) AS "exp_date", 
    "advertise"."id" AS "advertise.id", 
    "advertise"."office_id" AS "advertise.office_id", 
    "advertise"."corporate_id" AS "advertise.corporate_id", 
    "advertise"."order_code" AS "advertise.order_code", 
    "advertise"."ads_id" AS "advertise.ads_id", 
    "advertise"."agent_id" AS "advertise.agent_id", 
    "advertise"."agent_old" AS "advertise.agent_old", 
    "advertise"."project_id" AS "advertise.project_id", 
    "advertise"."rental_type" AS "advertise.rental_type", 
    "advertise"."is_publish" AS "advertise.is_publish", 
    "advertise"."is_highlights" AS "advertise.is_highlights", 
    "advertise"."province_id" AS "advertise.province_id", 
    "advertise"."city_id" AS "advertise.city_id", 
    "advertise"."district_id" AS "advertise.district_id", 
    "advertise"."nib" AS "advertise.nib", 
    "advertise"."location" AS "advertise.location", 
    "advertise"."lat" AS "advertise.lat", 
    "advertise"."long" AS "advertise.long", 
    "advertise"."zip" AS "advertise.zip", 
    "advertise"."regency" AS "advertise.regency", 
    "advertise"."subdistrict" AS "advertise.subdistrict", 
    "advertise"."province" AS "advertise.province", 
    "advertise"."property_type" AS "advertise.property_type", 
    "advertise"."ownership_certificate" AS "advertise.ownership_certificate", 
    "advertise"."listing_type" AS "advertise.listing_type", 
    "advertise"."name" AS "advertise.name", 
    "advertise"."location_search" AS "advertise.location_search", 
    "advertise"."logs" AS "advertise.logs", 
    "advertise"."desc" AS "advertise.desc", 
    "advertise"."price" AS "advertise.price", 
    "advertise"."building_type_id" AS "advertise.building_type_id", 
    "advertise"."size_land" AS "advertise.size_land", 
    "advertise"."size_building" AS "advertise.size_building", 
    "advertise"."rooms" AS "advertise.rooms", 
    "advertise"."bathroom" AS "advertise.bathroom", 
    "advertise"."carport" AS "advertise.carport", 
    "advertise"."garage" AS "advertise.garage", 
    "advertise"."electricity" AS "advertise.electricity", 
    "advertise"."highlight_id" AS "advertise.highlight_id", 
    "advertise"."report_desc" AS "advertise.report_desc", 
    "advertise"."user_report" AS "advertise.user_report", 
    "advertise"."unit" AS "advertise.unit", 
    "advertise"."deletedAt" AS "advertise.deletedAt", 
    "advertise"."reason" AS "advertise.reason", 
    "advertise"."exp_heighlight" AS "advertise.exp_heighlight", 
    "advertise"."score" AS "advertise.score", 
    "advertise"."youtube" AS "advertise.youtube", 
    "advertise"."matterport" AS "advertise.matterport", 
    "advertise"."analytic_views" AS "advertise.analytic_views", 
    "advertise"."analytic_leads" AS "advertise.analytic_leads", 
    "advertise"."analytic_favorite" AS "advertise.analytic_favorite", 
    "advertise"."analytic_share" AS "advertise.analytic_share", 
    "advertise"."slug" AS "advertise.slug", 
    "advertise"."meta_desc" AS "advertise.meta_desc", 
    "advertise"."canonical" AS "advertise.canonical", 
    "advertise"."is_copy" AS "advertise.is_copy", 
    "advertise"."createdAt" AS "advertise.createdAt", 
    "advertise"."updatedAt" AS "advertise.updatedAt"
FROM "history_quota" AS "history_quota"
LEFT OUTER JOIN "advertises" AS "advertise" ON "history_quota"."advertises_id" = "advertise"."ads_id"
WHERE "history_quota"."agent_id" = 1753
ORDER BY "history_quota"."createdAt" DESC;