Untitled
unknown
plain_text
4 months ago
197 kB
5
Indexable
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'TANAH SAREAL' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7598
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B26' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24871' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016523' AND "advertises"."agent_id" = 7598 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'JAWA BARAT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'BGR' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'PABATON' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7598
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B66' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '23919' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016547' AND "advertises"."agent_id" = 7338 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'DKI JAKARTA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'JKT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'KARET' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%APARTEMEN%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7338;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7338;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7338
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B62' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24545' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016553' AND "advertises"."agent_id" = 7154 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'BANTEN' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'BTS' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'CIPUTAT TIMUR' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7154;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7154;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7154
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B62' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24545' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016418","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016574' AND "advertises"."agent_id" = 7154 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'BANTEN' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'BTS' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'CIPUTAT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%APARTEMEN%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7154;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7154;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7154
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'A79' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '23837' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016626' AND "advertises"."agent_id" = 6626 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'DAERAH ISTIMEWA YOGYAKARTA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'YOGYAKARTA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'TEGALREJO' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%TANAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 6626;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016521","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 6626;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 6626
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B26' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24871' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016655' AND "advertises"."agent_id" = 7598 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'JAWA BARAT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'SUKABUMI' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'CICURUG' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%PABRIK%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016523","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7598
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = '162' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '23640' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016679' AND "advertises"."agent_id" = 5724 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 5724
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = '349' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '22083' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016697' AND "advertises"."agent_id" = 7199 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7199
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B62' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '23872' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016707' AND "advertises"."agent_id" = 7472 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'JAWA BARAT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'DPK' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'CINERE' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7472;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016547","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7472;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7472
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'A79' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '20670' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016713' AND "advertises"."agent_id" = 6611 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'DAERAH ISTIMEWA YOGYAKARTA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'SLEMAN' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'CATURTUNGGAL' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016553","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 6611;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 6611;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 6611
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = '162' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '23640' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016714' AND "advertises"."agent_id" = 5724 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 5724
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = '162' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '21200' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016715' AND "advertises"."agent_id" = 5763 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 5763
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B26' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24871' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016732' AND "advertises"."agent_id" = 7598 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'JAWA BARAT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'BGR' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'KEDUNGWARINGIN' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%TANAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016626","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7598;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7598
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B66' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24633' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016745' AND "advertises"."agent_id" = 7342 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'DKI JAKARTA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'JAKARTA SELATAN' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'CILANDAK' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%APARTEMEN%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7342;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7342;
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016574","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7342
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = '364' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24477' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016756' AND "advertises"."agent_id" = 7068 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'DKI JAKARTA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'JKT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'JAGAKARSA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7068;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7068;
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016655","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7068
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B62' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '24819' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:26 GMT+0530 {"no_listing":"M016679","updated":true}
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016762' AND "advertises"."agent_id" = 7448 LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'DKI JAKARTA' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'JKT' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'CIRENDEU' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7448;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7448;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:32:26 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:32:26 GMT+0530 where agents.id = 7448
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B68' LIMIT 1;
Mon, 02 Sep 2024 19:32:26 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '22471' LIMIT 1;
Mon, 02 Sep 2024 19:32:27 GMT+0530 Error: WHERE parameter "agent_id" has invalid "undefined" value
Mon, 02 Sep 2024 19:32:27 GMT+0530 at PostgresQueryGenerator.whereItemQuery (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at /app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25
Mon, 02 Sep 2024 19:32:27 GMT+0530 at Array.forEach (<anonymous>)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at PostgresQueryGenerator.whereItemsQuery (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at PostgresQueryGenerator.getWhereConditions (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at PostgresQueryGenerator.selectQuery (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:988:28)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at PostgresQueryInterface.select (/app/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:59)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at advertises.findAll (/app/node_modules/sequelize/lib/model.js:1140:47)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
Mon, 02 Sep 2024 19:32:27 GMT+0530 at async advertises.findOne (/app/node_modules/sequelize/lib/model.js:1240:12)
Mon, 02 Sep 2024 19:32:27 GMT+0530 [0mPOST /api/sync/era/listing [32m200[0m 8033.291 ms - 0[0m
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016697","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016714","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016707","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016713","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016745","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016715","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016732","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016756","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:32:27 GMT+0530 {"no_listing":"M016762","updated":true}
Mon, 02 Sep 2024 19:32:27 GMT+0530 Executing (default): SELECT "roles"."id", "roles"."name", "roles"."createdAt", "roles"."updatedAt", "permissions"."id" AS "permissions.id", "permissions"."role_id" AS "permissions.role_id", "permissions"."menu_id" AS "permissions.menu_id", "permissions"."createdAt" AS "permissions.createdAt", "permissions"."updatedAt" AS "permissions.updatedAt", "permissions->menu_role"."id" AS "permissions.menu_role.id", "permissions->menu_role"."name" AS "permissions.menu_role.name", "permissions->menu_role"."type" AS "permissions.menu_role.type", "permissions->menu_role"."position" AS "permissions.menu_role.position", "permissions->menu_role"."parent_id" AS "permissions.menu_role.parent_id", "permissions->menu_role"."icon" AS "permissions.menu_role.icon", "permissions->menu_role"."link" AS "permissions.menu_role.link", "permissions->menu_role"."sort" AS "permissions.menu_role.sort", "permissions->menu_role"."createdAt" AS "permissions.menu_role.createdAt", "permissions->menu_role"."updatedAt" AS "permissions.menu_role.updatedAt" FROM "roles" AS "roles" LEFT OUTER JOIN "permissions" AS "permissions" ON "roles"."id" = "permissions"."role_id" LEFT OUTER JOIN "menu_roles" AS "permissions->menu_role" ON "permissions"."menu_id" = "permissions->menu_role"."id" WHERE ("roles"."id" = 17);
Mon, 02 Sep 2024 19:32:27 GMT+0530 [0mGET /api/permission/?role=17 [36m304[0m 34.394 ms - -[0m
Mon, 02 Sep 2024 19:32:28 GMT+0530 Executing (default): SELECT count("advertises"."id") AS "count" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND ("agent"."type_agent" IN (0, 3)) WHERE ("advertises"."listing_code_era" IS NOT NULL) AND "advertises"."deletedAt" IS NULL;
Mon, 02 Sep 2024 19:32:28 GMT+0530 Executing (default): SELECT "advertises".*, "advertises_media"."id" AS "advertises_media.id", "advertises_media"."agent_id" AS "advertises_media.agent_id", "advertises_media"."is_cover" AS "advertises_media.is_cover", "advertises_media"."advertises_id" AS "advertises_media.advertises_id", "advertises_media"."image" AS "advertises_media.image", "advertises_media"."project_id" AS "advertises_media.project_id", "advertises_media"."createdAt" AS "advertises_media.createdAt", "advertises_media"."updatedAt" AS "advertises_media.updatedAt", "advertise_facilities"."id" AS "advertise_facilities.id", "advertise_facilities"."agent_id" AS "advertise_facilities.agent_id", "advertise_facilities"."advertise_id" AS "advertise_facilities.advertise_id", "advertise_facilities"."facility_id" AS "advertise_facilities.facility_id", "advertise_facilities"."createdAt" AS "advertise_facilities.createdAt", "advertise_facilities"."updatedAt" AS "advertise_facilities.updatedAt", "building_type"."id" AS "building_type.id", "building_type"."name" AS "building_type.name", "building_type"."createdAt" AS "building_type.createdAt", "building_type"."updatedAt" AS "building_type.updatedAt", "agent->office_agent"."id" AS "agent.office_agent.id", "agent->office_agent"."id_era" AS "agent.office_agent.id_era", "agent->office_agent"."corporate_id" AS "agent.office_agent.corporate_id", "agent->office_agent"."hightlight_category" AS "agent.office_agent.hightlight_category", "agent->office_agent"."quota_category" AS "agent.office_agent.quota_category", "agent->office_agent"."nib" AS "agent.office_agent.nib", "agent->office_agent"."type" AS "agent.office_agent.type", "agent->office_agent"."tagline" AS "agent.office_agent.tagline", "agent->office_agent"."name" AS "agent.office_agent.name", "agent->office_agent"."subscription" AS "agent.office_agent.subscription", "agent->office_agent"."start_date" AS "agent.office_agent.start_date", "agent->office_agent"."end_date" AS "agent.office_agent.end_date", "agent->office_agent"."address" AS "agent.office_agent.address", "agent->office_agent"."pic" AS "agent.office_agent.pic", "agent->office_agent"."phone" AS "agent.office_agent.phone", "agent->office_agent"."npwp" AS "agent.office_agent.npwp", "agent->office_agent"."email" AS "agent.office_agent.email", "agent->office_agent"."image" AS "agent.office_agent.image", "agent->office_agent"."desc" AS "agent.office_agent.desc", "agent->office_agent"."is_official_developer" AS "agent.office_agent.is_official_developer", "agent->office_agent"."is_trusted_developer" AS "agent.office_agent.is_trusted_developer", "agent->office_agent"."is_trusted_prop_agency" AS "agent.office_agent.is_trusted_prop_agency", "agent->office_agent"."link" AS "agent.office_agent.link", "agent->office_agent"."twitter" AS "agent.office_agent.twitter", "agent->office_agent"."ig" AS "agent.office_agent.ig", "agent->office_agent"."yt" AS "agent.office_agent.yt", "agent->office_agent"."fb" AS "agent.office_agent.fb", "agent->office_agent"."createdAt" AS "agent.office_agent.createdAt", "agent->office_agent"."updatedAt" AS "agent.office_agent.updatedAt" FROM (SELECT "advertises"."id", "advertises"."office_id", "advertises"."ads_id", "advertises"."agent_id", "advertises"."project_id", "advertises"."listing_code_era", "advertises"."rental_type", "advertises"."is_publish", "advertises"."is_highlights", "advertises"."province_id", "advertises"."city_id", "advertises"."district_id", "advertises"."nib", "advertises"."location", "advertises"."lat", "advertises"."long", "advertises"."zip", "advertises"."regency", "advertises"."subdistrict", "advertises"."province", "advertises"."property_type", "advertises"."ownership_certificate", "advertises"."listing_type", "advertises"."name", "advertises"."desc", "advertises"."price", "advertises"."building_type_id", "advertises"."size_land", "advertises"."size_building", "advertises"."rooms", "advertises"."bathroom", "advertises"."carport", "advertises"."garage", "advertises"."electricity", "advertises"."highlight_id", "advertises"."report_desc", "advertises"."user_report", "advertises"."unit", "advertises"."logs", "advertises"."deletedAt", "advertises"."reason", "advertises"."youtube", "advertises"."matterport", "advertises"."exp_heighlight", "advertises"."last_update_heighlight", "advertises"."location_search", "advertises"."created_by", "advertises"."updated_by", "advertises"."analytic_views", "advertises"."analytic_leads", "advertises"."analytic_favorite", "advertises"."analytic_share", "advertises"."slug", "advertises"."meta_desc", "advertises"."canonical", "advertises"."is_superhighlight", "advertises"."createdAt", "advertises"."updatedAt", (SELECT CASE WHEN is_publish = 0 THEN 'pending' WHEN is_publish = 1 THEN 'aktif' WHEN is_publish = 2 THEN 'draf' WHEN is_publish = 3 THEN 'arsif' WHEN is_publish = 4 THEN 'terjual' WHEN is_publish = 5 THEN 'tolak' ELSE 'block' END) AS "status_ads", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."nib" AS "agent.nib", "agent"."id_office_era" AS "agent.id_office_era", "agent"."id_agent_era" AS "agent.id_agent_era", "agent"."asosiasi" AS "agent.asosiasi", "agent"."document" AS "agent.document", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."tlp_office_agent" AS "agent.tlp_office_agent", "agent"."is_pic" AS "agent.is_pic", "agent"."logs" AS "agent.logs", "agent"."analytic_listing_views" AS "agent.analytic_listing_views", "agent"."analytic_listing_leads" AS "agent.analytic_listing_leads", "agent"."analytic_listing_share" AS "agent.analytic_listing_share", "agent"."created_by" AS "agent.created_by", "agent"."updated_by" AS "agent.updated_by", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND ("agent"."type_agent" IN (0, 3)) WHERE ("advertises"."listing_code_era" IS NOT NULL) AND "advertises"."deletedAt" IS NULL ORDER BY "advertises"."createdAt" DESC LIMIT 10 OFFSET 0) AS "advertises" LEFT OUTER JOIN "advertises_media" AS "advertises_media" ON "advertises"."id" = "advertises_media"."advertises_id" LEFT OUTER JOIN "advertise_facilities" AS "advertise_facilities" ON "advertises"."id" = "advertise_facilities"."advertise_id" LEFT OUTER JOIN "building_types" AS "building_type" ON "advertises"."building_type_id" = "building_type"."id" LEFT OUTER JOIN "office_agents" AS "agent->office_agent" ON "agent.office_id" = "agent->office_agent"."id" ORDER BY "advertises"."createdAt" DESC;
Mon, 02 Sep 2024 19:32:28 GMT+0530 [0mGET /api/advertises?page=1&size=10&agentType=3&integrasi=era [36m304[0m 527.817 ms - -[0m
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'A79' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '21630' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M013457' AND "advertises"."agent_id" = 7076 LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B62' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '23872' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M013473' AND "advertises"."agent_id" = 7472 LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B57' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '21795' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."listing_code_era" = 'M016319' AND "advertises"."agent_id" = 7327 LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" WHERE "master_propinsi"."lokasi_nama" = 'BANTEN' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_nama" = 'BTS' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_nama" = 'SERPONG' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" WHERE "building_types"."name" ILIKE '%RUMAH%' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): INSERT INTO "advertises" ("id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","unit","logs","matterport","location_search","created_by","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43) RETURNING "id","office_id","ads_id","agent_id","project_id","listing_code_era","rental_type","is_publish","is_highlights","province_id","city_id","district_id","nib","location","lat","long","zip","regency","subdistrict","province","property_type","ownership_certificate","listing_type","name","desc","price","building_type_id","size_land","size_building","rooms","bathroom","carport","garage","electricity","highlight_id","report_desc","user_report","unit","logs","deletedAt","reason","youtube","matterport","exp_heighlight","last_update_heighlight","location_search","created_by","updated_by","analytic_views","analytic_leads","analytic_favorite","analytic_share","slug","meta_desc","canonical","is_superhighlight","createdAt","updatedAt";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7327;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): INSERT INTO "advertises_media" ("id","agent_id","is_cover","advertises_id","image","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6) RETURNING "id","agent_id","is_cover","advertises_id","image","project_id","createdAt","updatedAt";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): UPDATE "agents" SET "quota"=$1,"updatedAt"=$2 WHERE "id" = $3
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 7327;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): INSERT INTO "history_quota" ("id","agent_id","advertises_id","advertises","transaction_date","status","createdAt","updatedAt") VALUES (DEFAULT,$1,$2,$3,$4,$5,$6,$7) RETURNING "id","agent_id","cobroke_id","advertises_id","advertises","transaction_date","status","status_ads","createdAt","updatedAt";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): update agents set tot_listing = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:33:51 GMT+0530 tot_sell = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:33:51 GMT+0530 tot_rent = (SELECT COUNT(*) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 4 and advertises.listing_type = 2 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:33:51 GMT+0530 price_min = (SELECT min(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:33:51 GMT+0530 price_end = (SELECT max(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null),
Mon, 02 Sep 2024 19:33:51 GMT+0530 price_avg = (SELECT avg(price) FROM advertises where advertises.agent_id = agents.id and advertises.is_publish = 1 and advertises."deletedAt" is null)
Mon, 02 Sep 2024 19:33:51 GMT+0530 where agents.id = 7327
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "id_era", "corporate_id", "hightlight_category", "quota_category", "nib", "type", "tagline", "name", "subscription", "start_date", "end_date", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agents" WHERE "office_agents"."id_era" = 'B68' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id_agent_era" = '22471' LIMIT 1;
Mon, 02 Sep 2024 19:33:51 GMT+0530 Error: WHERE parameter "agent_id" has invalid "undefined" value
Mon, 02 Sep 2024 19:33:51 GMT+0530 at PostgresQueryGenerator.whereItemQuery (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at /app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25
Mon, 02 Sep 2024 19:33:51 GMT+0530 at Array.forEach (<anonymous>)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at PostgresQueryGenerator.whereItemsQuery (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at PostgresQueryGenerator.getWhereConditions (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at PostgresQueryGenerator.selectQuery (/app/node_modules/sequelize/lib/dialects/abstract/query-generator.js:988:28)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at PostgresQueryInterface.select (/app/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:59)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at advertises.findAll (/app/node_modules/sequelize/lib/model.js:1140:47)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
Mon, 02 Sep 2024 19:33:51 GMT+0530 at async advertises.findOne (/app/node_modules/sequelize/lib/model.js:1240:12)
Mon, 02 Sep 2024 19:33:51 GMT+0530 [0mPOST /api/sync/era/listing [32m200[0m 4122.006 ms - 0[0m
Mon, 02 Sep 2024 19:33:51 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:33:51 GMT+0530 {"no_listing":"M016319","updated":true}
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
Mon, 02 Sep 2024 19:33:51 GMT+0530 Executing (default): SELECT "highlights"."id", "highlights"."agent_id", "highlights"."office_id", "highlights"."name", "highlights"."icon", "highlights"."price", "highlights"."duration", "highlights"."category", "highlights"."desc", "highlights"."createdAt", "highlights"."updatedAt", "office_agent"."id" AS "office_agent.id", "office_agent"."id_era" AS "office_agent.id_era", "office_agent"."corporate_id" AS "office_agent.corporate_id", "office_agent"."hightlight_category" AS "office_agent.hightlight_category", "office_agent"."quota_category" AS "office_agent.quota_category", "office_agent"."nib" AS "office_agent.nib", "office_agent"."type" AS "office_agent.type", "office_agent"."tagline" AS "office_agent.tagline", "office_agent"."name" AS "office_agent.name", "office_agent"."subscription" AS "office_agent.subscription", "office_agent"."start_date" AS "office_agent.start_date", "office_agent"."end_date" AS "office_agent.end_date", "office_agent"."address" AS "office_agent.address", "office_agent"."pic" AS "office_agent.pic", "office_agent"."phone" AS "office_agent.phone", "office_agent"."npwp" AS "office_agent.npwp", "office_agent"."email" AS "office_agent.email", "office_agent"."image" AS "office_agent.image", "office_agent"."desc" AS "office_agent.desc", "office_agent"."is_official_developer" AS "office_agent.is_official_developer", "office_agent"."is_trusted_developer" AS "office_agent.is_trusted_developer", "office_agent"."is_trusted_prop_agency" AS "office_agent.is_trusted_prop_agency", "office_agent"."link" AS "office_agent.link", "office_agent"."twitter" AS "office_agent.twitter", "office_agent"."ig" AS "office_agent.ig", "office_agent"."yt" AS "office_agent.yt", "office_agent"."fb" AS "office_agent.fb", "office_agent"."createdAt" AS "office_agent.createdAt", "office_agent"."updatedAt" AS "office_agent.updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."nib" AS "agent.nib", "agent"."id_office_era" AS "agent.id_office_era", "agent"."id_agent_era" AS "agent.id_agent_era", "agent"."asosiasi" AS "agent.asosiasi", "agent"."document" AS "agent.document", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."tlp_office_agent" AS "agent.tlp_office_agent", "agent"."is_pic" AS "agent.is_pic", "agent"."logs" AS "agent.logs", "agent"."analytic_listing_views" AS "agent.analytic_listing_views", "agent"."analytic_listing_leads" AS "agent.analytic_listing_leads", "agent"."analytic_listing_share" AS "agent.analytic_listing_share", "agent"."created_by" AS "agent.created_by", "agent"."updated_by" AS "agent.updated_by", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt" FROM "highlights" AS "highlights" LEFT OUTER JOIN "office_agents" AS "office_agent" ON "highlights"."office_id" = "office_agent"."id" LEFT OUTER JOIN "agents" AS "agent" ON "highlights"."agent_id" = "agent"."id" ORDER BY "highlights"."createdAt" DESC LIMIT 500 OFFSET 0;
Mon, 02 Sep 2024 19:33:51 GMT+0530 [0mGET /api/highlight?page=1&size=500 [36m304[0m 14.649 ms - -[0m
Mon, 02 Sep 2024 19:33:52 GMT+0530 Executing (default): SELECT count("advertises"."id") AS "count" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND ("agent"."type_agent" IN (0, 3)) WHERE ("advertises"."listing_code_era" IS NOT NULL) AND "advertises"."deletedAt" IS NULL;
Mon, 02 Sep 2024 19:33:52 GMT+0530 Executing (default): SELECT "advertises".*, "advertises_media"."id" AS "advertises_media.id", "advertises_media"."agent_id" AS "advertises_media.agent_id", "advertises_media"."is_cover" AS "advertises_media.is_cover", "advertises_media"."advertises_id" AS "advertises_media.advertises_id", "advertises_media"."image" AS "advertises_media.image", "advertises_media"."project_id" AS "advertises_media.project_id", "advertises_media"."createdAt" AS "advertises_media.createdAt", "advertises_media"."updatedAt" AS "advertises_media.updatedAt", "advertise_facilities"."id" AS "advertise_facilities.id", "advertise_facilities"."agent_id" AS "advertise_facilities.agent_id", "advertise_facilities"."advertise_id" AS "advertise_facilities.advertise_id", "advertise_facilities"."facility_id" AS "advertise_facilities.facility_id", "advertise_facilities"."createdAt" AS "advertise_facilities.createdAt", "advertise_facilities"."updatedAt" AS "advertise_facilities.updatedAt", "building_type"."id" AS "building_type.id", "building_type"."name" AS "building_type.name", "building_type"."createdAt" AS "building_type.createdAt", "building_type"."updatedAt" AS "building_type.updatedAt", "agent->office_agent"."id" AS "agent.office_agent.id", "agent->office_agent"."id_era" AS "agent.office_agent.id_era", "agent->office_agent"."corporate_id" AS "agent.office_agent.corporate_id", "agent->office_agent"."hightlight_category" AS "agent.office_agent.hightlight_category", "agent->office_agent"."quota_category" AS "agent.office_agent.quota_category", "agent->office_agent"."nib" AS "agent.office_agent.nib", "agent->office_agent"."type" AS "agent.office_agent.type", "agent->office_agent"."tagline" AS "agent.office_agent.tagline", "agent->office_agent"."name" AS "agent.office_agent.name", "agent->office_agent"."subscription" AS "agent.office_agent.subscription", "agent->office_agent"."start_date" AS "agent.office_agent.start_date", "agent->office_agent"."end_date" AS "agent.office_agent.end_date", "agent->office_agent"."address" AS "agent.office_agent.address", "agent->office_agent"."pic" AS "agent.office_agent.pic", "agent->office_agent"."phone" AS "agent.office_agent.phone", "agent->office_agent"."npwp" AS "agent.office_agent.npwp", "agent->office_agent"."email" AS "agent.office_agent.email", "agent->office_agent"."image" AS "agent.office_agent.image", "agent->office_agent"."desc" AS "agent.office_agent.desc", "agent->office_agent"."is_official_developer" AS "agent.office_agent.is_official_developer", "agent->office_agent"."is_trusted_developer" AS "agent.office_agent.is_trusted_developer", "agent->office_agent"."is_trusted_prop_agency" AS "agent.office_agent.is_trusted_prop_agency", "agent->office_agent"."link" AS "agent.office_agent.link", "agent->office_agent"."twitter" AS "agent.office_agent.twitter", "agent->office_agent"."ig" AS "agent.office_agent.ig", "agent->office_agent"."yt" AS "agent.office_agent.yt", "agent->office_agent"."fb" AS "agent.office_agent.fb", "agent->office_agent"."createdAt" AS "agent.office_agent.createdAt", "agent->office_agent"."updatedAt" AS "agent.office_agent.updatedAt" FROM (SELECT "advertises"."id", "advertises"."office_id", "advertises"."ads_id", "advertises"."agent_id", "advertises"."project_id", "advertises"."listing_code_era", "advertises"."rental_type", "advertises"."is_publish", "advertises"."is_highlights", "advertises"."province_id", "advertises"."city_id", "advertises"."district_id", "advertises"."nib", "advertises"."location", "advertises"."lat", "advertises"."long", "advertises"."zip", "advertises"."regency", "advertises"."subdistrict", "advertises"."province", "advertises"."property_type", "advertises"."ownership_certificate", "advertises"."listing_type", "advertises"."name", "advertises"."desc", "advertises"."price", "advertises"."building_type_id", "advertises"."size_land", "advertises"."size_building", "advertises"."rooms", "advertises"."bathroom", "advertises"."carport", "advertises"."garage", "advertises"."electricity", "advertises"."highlight_id", "advertises"."report_desc", "advertises"."user_report", "advertises"."unit", "advertises"."logs", "advertises"."deletedAt", "advertises"."reason", "advertises"."youtube", "advertises"."matterport", "advertises"."exp_heighlight", "advertises"."last_update_heighlight", "advertises"."location_search", "advertises"."created_by", "advertises"."updated_by", "advertises"."analytic_views", "advertises"."analytic_leads", "advertises"."analytic_favorite", "advertises"."analytic_share", "advertises"."slug", "advertises"."meta_desc", "advertises"."canonical", "advertises"."is_superhighlight", "advertises"."createdAt", "advertises"."updatedAt", (SELECT CASE WHEN is_publish = 0 THEN 'pending' WHEN is_publish = 1 THEN 'aktif' WHEN is_publish = 2 THEN 'draf' WHEN is_publish = 3 THEN 'arsif' WHEN is_publish = 4 THEN 'terjual' WHEN is_publish = 5 THEN 'tolak' ELSE 'block' END) AS "status_ads", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."nib" AS "agent.nib", "agent"."id_office_era" AS "agent.id_office_era", "agent"."id_agent_era" AS "agent.id_agent_era", "agent"."asosiasi" AS "agent.asosiasi", "agent"."document" AS "agent.document", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."tlp_office_agent" AS "agent.tlp_office_agent", "agent"."is_pic" AS "agent.is_pic", "agent"."logs" AS "agent.logs", "agent"."analytic_listing_views" AS "agent.analytic_listing_views", "agent"."analytic_listing_leads" AS "agent.analytic_listing_leads", "agent"."analytic_listing_share" AS "agent.analytic_listing_share", "agent"."created_by" AS "agent.created_by", "agent"."updated_by" AS "agent.updated_by", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt" FROM "advertises" AS "advertises" INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id" AND ("agent"."type_agent" IN (0, 3)) WHERE ("advertises"."listing_code_era" IS NOT NULL) AND "advertises"."deletedAt" IS NULL ORDER BY "advertises"."createdAt" DESC LIMIT 10 OFFSET 0) AS "advertises" LEFT OUTER JOIN "advertises_media" AS "advertises_media" ON "advertises"."id" = "advertises_media"."advertises_id" LEFT OUTER JOIN "advertise_facilities" AS "advertise_facilities" ON "advertises"."id" = "advertise_facilities"."advertise_id" LEFT OUTER JOIN "building_types" AS "building_type" ON "advertises"."building_type_id" = "building_type"."id" LEFT OUTER JOIN "office_agents" AS "agent->office_agent" ON "agent.office_id" = "agent->office_agent"."id" ORDER BY "advertises"."createdAt" DESC;
Mon, 02 Sep 2024 19:33:52 GMT+0530 [0mGET /api/advertises?page=1&size=10&agentType=3&integrasi=era [36m304[0m 539.086 ms - -[0m
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): UPDATE history_quota
Mon, 02 Sep 2024 19:35:00 GMT+0530 SET logs = advertises || ' ' || advertises_id
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): UPDATE agents
Mon, 02 Sep 2024 19:35:00 GMT+0530 SET logs = agents.city || ' ' || agents.province || ' ' || agents.pic_name || ' ' || agents.office
Mon, 02 Sep 2024 19:35:00 GMT+0530 where agents.id is not null
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE ("agents"."type_agent" = 3 AND "agents"."is_active" = 1) AND "agents"."logs" IS NULL ORDER BY "agents"."createdAt" DESC LIMIT 10 OFFSET 0;
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT "id", "office_id", "ads_id", "agent_id", "project_id", "listing_code_era", "rental_type", "is_publish", "is_highlights", "province_id", "city_id", "district_id", "nib", "location", "lat", "long", "zip", "regency", "subdistrict", "province", "property_type", "ownership_certificate", "listing_type", "name", "desc", "price", "building_type_id", "size_land", "size_building", "rooms", "bathroom", "carport", "garage", "electricity", "highlight_id", "report_desc", "user_report", "unit", "logs", "deletedAt", "reason", "youtube", "matterport", "exp_heighlight", "last_update_heighlight", "location_search", "created_by", "updated_by", "analytic_views", "analytic_leads", "analytic_favorite", "analytic_share", "slug", "meta_desc", "canonical", "is_superhighlight", "createdAt", "updatedAt" FROM "advertises" AS "advertises" WHERE "advertises"."deletedAt" IS NULL AND "advertises"."is_highlights" = true AND "advertises"."exp_heighlight" < '2024-09-02 14:05:00.007 +00:00' AND "advertises"."is_publish" = 1 LIMIT 1;
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."duration_qouta" < '2024-03-06 14:05:00.007 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."duration_qouta" < '2023-09-10 14:05:00.007 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT "id", "project_id", "advertise_id", "type_ads", "province_id", "city_id", "subdistrict_id", "start_date", "end_date", "is_publish", "logs", "created_by", "updated_by", "createdAt", "updatedAt" FROM "ads_impressions" AS "ads_impressions" WHERE "ads_impressions"."start_date" = '2024-09-02' LIMIT 1;
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT "id", "project_id", "advertise_id", "type_ads", "province_id", "city_id", "subdistrict_id", "start_date", "end_date", "is_publish", "logs", "created_by", "updated_by", "createdAt", "updatedAt" FROM "ads_impressions" AS "ads_impressions" WHERE "ads_impressions"."end_date" = '2024-09-02' LIMIT 1;
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): UPDATE "advertises" SET "is_highlights"=$1,"highlight_id"=$2,"updatedAt"=$3 WHERE "id" = $4
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'trustproperty@yahoo.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'fathan@propertyklik.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'adiparahyangan8@gmail.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'aghatosproperti@gmail.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'remax.pik@gmail.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'listing.remaxpremier@gmail.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'signature.kuningan@raywhite.co.id';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'confidentpropertyofficial@gmail.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'ptamanahtegumakmur@gmail.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'c21.airis@gmail.com';
Mon, 02 Sep 2024 19:35:00 GMT+0530 Executing (default): SELECT "id", "office_id", "nib", "id_office_era", "id_agent_era", "asosiasi", "document", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "tlp_office_agent", "is_pic", "logs", "analytic_listing_views", "analytic_listing_leads", "analytic_listing_share", "created_by", "updated_by", "createdAt", "updatedAt" FROM "agents" AS "agents" WHERE "agents"."id" = 3602;
Mon, 02 Sep 2024 19:36:39 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:36:39 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" ORDER BY "master_kabko"."sort" ASC LIMIT 1000 OFFSET 0;
Mon, 02 Sep 2024 19:36:39 GMT+0530 [0mGET /api/getCityAll?page=1&size=1000 [32m200[0m 38.147 ms - -[0m
Mon, 02 Sep 2024 19:38:03 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
Mon, 02 Sep 2024 19:38:03 GMT+0530 Executing (default): SELECT "roles"."id", "roles"."name", "roles"."createdAt", "roles"."updatedAt", "permissions"."id" AS "permissions.id", "permissions"."role_id" AS "permissions.role_id", "permissions"."menu_id" AS "permissions.menu_id", "permissions"."createdAt" AS "permissions.createdAt", "permissions"."updatedAt" AS "permissions.updatedAt", "permissions->menu_role"."id" AS "permissions.menu_role.id", "permissions->menu_role"."name" AS "permissions.menu_role.name", "permissions->menu_role"."type" AS "permissions.menu_role.type", "permissions->menu_role"."position" AS "permissions.menu_role.position", "permissions->menu_role"."parent_id" AS "permissions.menu_role.parent_id", "permissions->menu_role"."icon" AS "permissions.menu_role.icon", "permissions->menu_role"."link" AS "permissions.menu_role.link", "permissions->menu_role"."sort" AS "permissions.menu_role.sort", "permissions->menu_role"."createdAt" AS "permissions.menu_role.createdAt", "permissions->menu_role"."updatedAt" AS "permissions.menu_role.updatedAt" FROM "roles" AS "roles" LEFT OUTER JOIN "permissions" AS "permissions" ON "roles"."id" = "permissions"."role_id" LEFT OUTER JOIN "menu_roles" AS "permissions->menu_role" ON "permissions"."menu_id" = "permissions->menu_role"."id" WHERE ("roles"."id" = 17);
Mon, 02 Sep 2024 19:38:03 GMT+0530 Executing (default): SELECT "highlights"."id", "highlights"."agent_id", "highlights"."office_id", "highlights"."name", "highlights"."icon", "highlights"."price", "highlights"."duration", "highlights"."category", "highlights"."desc", "highlights"."createdAt", "highlights"."updatedAt", "office_agent"."id" AS "office_agent.id", "office_agent"."id_era" AS "office_agent.id_era", "office_agent"."corporate_id" AS "office_agent.corporate_id", "office_agent"."hightlight_category" AS "office_agent.hightlight_category", "office_agent"."quota_category" AS "office_agent.quota_category", "office_agent"."nib" AS "office_agent.nib", "office_agent"."type" AS "office_agent.type", "office_agent"."tagline" AS "office_agent.tagline", "office_agent"."name" AS "office_agent.name", "office_agent"."subscription" AS "office_agent.subscription", "office_agent"."start_date" AS "office_agent.start_date", "office_agent"."end_date" AS "office_agent.end_date", "office_agent"."address" AS "office_agent.address", "office_agent"."pic" AS "office_agent.pic", "office_agent"."phone" AS "office_agent.phone", "office_agent"."npwp" AS "office_agent.npwp", "office_agent"."email" AS "office_agent.email", "office_agent"."image" AS "office_agent.image", "office_agent"."desc" AS "office_agent.desc", "office_agent"."is_official_developer" AS "office_agent.is_official_developer", "office_agent"."is_trusted_developer" AS "office_agent.is_trusted_developer", "office_agent"."is_trusted_prop_agency" AS "office_agent.is_trusted_prop_agency", "office_agent"."link" AS "office_agent.link", "office_agent"."twitter" AS "office_agent.twitter", "office_agent"."ig" AS "office_agent.ig", "office_agent"."yt" AS "office_agent.yt", "office_agent"."fb" AS "office_agent.fb", "office_agent"."createdAt" AS "office_agent.createdAt", "office_agent"."updatedAt" AS "office_agent.updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."nib" AS "agent.nib", "agent"."id_office_era" AS "agent.id_office_era", "agent"."id_agent_era" AS "agent.id_agent_era", "agent"."asosiasi" AS "agent.asosiasi", "agent"."document" AS "agent.document", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."tlp_office_agent" AS "agent.tlp_office_agent", "agent"."is_pic" AS "agent.is_pic", "agent"."logs" AS "agent.logs", "agent"."analytic_listing_views" AS "agent.analytic_listing_views", "agent"."analytic_listing_leads" AS "agent.analytic_listing_leads", "agent"."analytic_listing_share" AS "agent.analytic_listing_share", "agent"."created_by" AS "agent.created_by", "agent"."updated_by" AS "agent.updated_by", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt" FROM "highlights" AS "highlights" LEFT OUTER JOIN "office_agents" AS "office_agent" ON "highlights"."office_id" = "office_agent"."id" LEFT OUTER JOIN "agents" AS "agent" ON "highlights"."agent_id" = "agent"."id" ORDER BY "highlights"."createdAt" DESC LIMIT 500 OFFSET 0;
Mon, 02 Sep 2024 19:38:03 GMT+0530 [0mGET /api/highlight?page=1&size=500 [36m304[0m 65.718 ms - -[0m
Mon, 02 Sep 2024 19:38:03 GMT+0530 [0mGET /api/permission/?role=17 [36m304[0m 101.968 ms - -[0m
Mon, 02 Sep 2024 19:38:53 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:38:53 GMT+0530 Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" ORDER BY "master_kabko"."sort" ASC LIMIT 1000 OFFSET 0;
Mon, 02 Sep 2024 19:38:53 GMT+0530 [0mGET /api/getCityAll?page=1&size=1000 [32m200[0m 32.224 ms - -[0m
Leave a Comment