Untitled

mail@pastecode.io avatar
unknown
plain_text
12 days ago
179 kB
7
Indexable
Never
Mon, 02 Sep 2024 19:00:46 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:00:46 GMT+0530          where agents.id = 5753
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '23141' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M013713","updated":true}
Mon, 02 Sep 2024 19:00:46 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" = 'M014669' AND "advertises"."agent_id" = 7115 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7115
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '24148' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M013708","updated":true}
Mon, 02 Sep 2024 19:00:46 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" = 'M014761' AND "advertises"."agent_id" = 7011 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7011
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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" = 'M014775' AND "advertises"."agent_id" = 7472 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7472
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '18949' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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" = 'M014777' AND "advertises"."agent_id" = 6824 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 6824
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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" = 'M014907' AND "advertises"."agent_id" = 7472 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7472
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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" = 'M014914' AND "advertises"."agent_id" = 7472 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7472
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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" = 'M014922' AND "advertises"."agent_id" = 7472 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7472
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '23955' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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" = 'M014959' AND "advertises"."agent_id" = 7012 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7012
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '23955' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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" = 'M014961' AND "advertises"."agent_id" = 7012 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7012
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '23955' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M013868","updated":true}
Mon, 02 Sep 2024 19:00:46 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" = 'M014962' AND "advertises"."agent_id" = 7012 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7012
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '23955' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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" = 'M014964' AND "advertises"."agent_id" = 7012 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7012
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '20276' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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" = 'M014995' AND "advertises"."agent_id" = 7198 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7198
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '10371' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014082","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014224","updated":true}
Mon, 02 Sep 2024 19:00:46 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" = 'M015068' AND "advertises"."agent_id" = 7239 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7239
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '19346' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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" = 'M015139' AND "advertises"."agent_id" = 7078 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7078
Mon, 02 Sep 2024 19:00:46 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:00:46 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" = '19346' LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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" = 'M015141' AND "advertises"."agent_id" = 7078 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7078
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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" = 'M015239' AND "advertises"."agent_id" = 6626 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 6626
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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" = 'M015241' AND "advertises"."agent_id" = 6626 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 6626
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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" = 'M015284' AND "advertises"."agent_id" = 7472 LIMIT 1;
Mon, 02 Sep 2024 19:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 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:00:46 GMT+0530          where agents.id = 7472
Mon, 02 Sep 2024 19:00:46 GMT+0530 POST /api/sync/era/listing 200 5361.561 ms - -
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014326","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014316","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014306","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014328","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014322","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014330","updated":true}
Mon, 02 Sep 2024 19:00:46 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:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014329","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014427","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014463","updated":true}
Mon, 02 Sep 2024 19:00:46 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:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014464","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014465","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014433","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014594","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014659","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014467","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014615","updated":true}
Mon, 02 Sep 2024 19:00:46 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:46 GMT+0530 {"no_listing":"M014660","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014661","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 GET /api/advertises?page=1&size=10&agentType=3&integrasi=era 200 551.608 ms - -
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014669","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014775","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014761","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014907","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014777","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014914","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014922","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014959","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014962","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014961","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M015068","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014964","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M014995","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M015141","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M015139","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M015239","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M015241","updated":true}
Mon, 02 Sep 2024 19:00:47 GMT+0530 ------sukses insert------
Mon, 02 Sep 2024 19:00:47 GMT+0530 {"no_listing":"M015284","updated":true}
Mon, 02 Sep 2024 19:01:38 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" ORDER BY "master_propinsi"."sort" ASC;
Mon, 02 Sep 2024 19:01:38 GMT+0530 GET /api/getProvince 304 18.351 ms - -
Mon, 02 Sep 2024 19:03:58 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:03:58 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:03:58 GMT+0530 GET /api/getCityAll?page=1&size=1000 304 35.847 ms - -
Mon, 02 Sep 2024 19:05:00 GMT+0530 Executing (default): UPDATE history_quota
Mon, 02 Sep 2024 19:05:00 GMT+0530             SET logs = advertises || ' ' || advertises_id
Mon, 02 Sep 2024 19:05:00 GMT+0530 Executing (default): UPDATE agents
Mon, 02 Sep 2024 19:05:00 GMT+0530             SET logs = agents.city || ' ' || agents.province || ' ' || agents.pic_name || ' ' || agents.office
Mon, 02 Sep 2024 19:05:00 GMT+0530             where agents.id is not null
Mon, 02 Sep 2024 19:05: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:05: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 13:35:00.006 +00:00' AND "advertises"."is_publish" = 1 LIMIT 1;
Mon, 02 Sep 2024 19:05: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 13:35:00.006 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:05: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 13:35:00.006 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:05: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:05: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:05:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'trustproperty@yahoo.com';
Mon, 02 Sep 2024 19:05:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'fathan@propertyklik.com';
Mon, 02 Sep 2024 19:05:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'adiparahyangan8@gmail.com';
Mon, 02 Sep 2024 19:05:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'aghatosproperti@gmail.com';
Mon, 02 Sep 2024 19:05: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:05: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:05: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:05:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'confidentpropertyofficial@gmail.com';
Mon, 02 Sep 2024 19:05:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'ptamanahtegumakmur@gmail.com';
Mon, 02 Sep 2024 19:05: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:05:00 GMT+0530 Executing (default): UPDATE "advertises" SET "is_highlights"=$1,"highlight_id"=$2,"updatedAt"=$3 WHERE "id" = $4
Mon, 02 Sep 2024 19:05: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" = 1816;
Mon, 02 Sep 2024 19:06:42 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:06:42 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:06:42 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 27.229 ms - -
Mon, 02 Sep 2024 19:10:00 GMT+0530 Executing (default): UPDATE history_quota
Mon, 02 Sep 2024 19:10:00 GMT+0530             SET logs = advertises || ' ' || advertises_id
Mon, 02 Sep 2024 19:10:00 GMT+0530 Executing (default): UPDATE agents
Mon, 02 Sep 2024 19:10:00 GMT+0530             SET logs = agents.city || ' ' || agents.province || ' ' || agents.pic_name || ' ' || agents.office
Mon, 02 Sep 2024 19:10:00 GMT+0530             where agents.id is not null
Mon, 02 Sep 2024 19:10: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:10: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 13:40:00.008 +00:00' AND "advertises"."is_publish" = 1 LIMIT 1;
Mon, 02 Sep 2024 19:10: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 13:40:00.008 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:10: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 13:40:00.008 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:10: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:10: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:10:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'trustproperty@yahoo.com';
Mon, 02 Sep 2024 19:10:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'fathan@propertyklik.com';
Mon, 02 Sep 2024 19:10:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'adiparahyangan8@gmail.com';
Mon, 02 Sep 2024 19:10:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'aghatosproperti@gmail.com';
Mon, 02 Sep 2024 19:10: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:10: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:10: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:10:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'confidentpropertyofficial@gmail.com';
Mon, 02 Sep 2024 19:10:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'ptamanahtegumakmur@gmail.com';
Mon, 02 Sep 2024 19:10: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:10:00 GMT+0530 Executing (default): UPDATE "advertises" SET "is_highlights"=$1,"highlight_id"=$2,"updatedAt"=$3 WHERE "id" = $4
Mon, 02 Sep 2024 19:10: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" = 1816;
Mon, 02 Sep 2024 19:12:25 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:12:25 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:12:25 GMT+0530 GET /api/getCityAll?page=1&size=1000 304 30.545 ms - -
Mon, 02 Sep 2024 19:13:16 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:13:16 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:13:16 GMT+0530 GET /api/getCityAll?page=1&size=1000 304 28.551 ms - -
Mon, 02 Sep 2024 19:14:46 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:14:46 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:14:46 GMT+0530 GET /api/getCityAll?page=1&size=1000 304 29.870 ms - -
Mon, 02 Sep 2024 19:14:46 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:14:46 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:14:46 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 13.919 ms - -
Mon, 02 Sep 2024 19:15:00 GMT+0530 Executing (default): UPDATE history_quota
Mon, 02 Sep 2024 19:15:00 GMT+0530             SET logs = advertises || ' ' || advertises_id
Mon, 02 Sep 2024 19:15:00 GMT+0530 Executing (default): UPDATE agents
Mon, 02 Sep 2024 19:15:00 GMT+0530             SET logs = agents.city || ' ' || agents.province || ' ' || agents.pic_name || ' ' || agents.office
Mon, 02 Sep 2024 19:15:00 GMT+0530             where agents.id is not null
Mon, 02 Sep 2024 19:15: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:15: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 13:45:00.005 +00:00' AND "advertises"."is_publish" = 1 LIMIT 1;
Mon, 02 Sep 2024 19:15: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 13:45:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:15: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 13:45:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:15: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:15: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:15:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'trustproperty@yahoo.com';
Mon, 02 Sep 2024 19:15:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'fathan@propertyklik.com';
Mon, 02 Sep 2024 19:15:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'adiparahyangan8@gmail.com';
Mon, 02 Sep 2024 19:15:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'aghatosproperti@gmail.com';
Mon, 02 Sep 2024 19:15: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:15: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:15: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:15:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'confidentpropertyofficial@gmail.com';
Mon, 02 Sep 2024 19:15:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'ptamanahtegumakmur@gmail.com';
Mon, 02 Sep 2024 19:15: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:15:00 GMT+0530 Executing (default): UPDATE "advertises" SET "is_highlights"=$1,"highlight_id"=$2,"updatedAt"=$3 WHERE "id" = $4
Mon, 02 Sep 2024 19:15: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" = 2885;
Mon, 02 Sep 2024 19:15:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko" WHERE ("master_kabko"."show_project" = true);
Mon, 02 Sep 2024 19:15:00 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"."show_project" = true) ORDER BY "master_kabko"."sort" ASC LIMIT 8 OFFSET 0;
Mon, 02 Sep 2024 19:15:00 GMT+0530 GET /api/getCityAll?page=1&size=8&show_project=1 200 4.779 ms - -
Mon, 02 Sep 2024 19:15:10 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:15:10 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:15:10 GMT+0530 GET /api/getCityAll?page=1&size=1000 304 14.877 ms - -
Mon, 02 Sep 2024 19:15:41 GMT+0530 GET /api/getCity/31 200 2.124 ms - -
Mon, 02 Sep 2024 19:16:00 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" ORDER BY "master_propinsi"."sort" ASC;
Mon, 02 Sep 2024 19:16:00 GMT+0530 GET /api/getProvince 304 18.037 ms - -
Mon, 02 Sep 2024 19:16:09 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_propinsi" = 36 AND "master_kecamatan"."lokasi_kabupatenkota" = 71 ORDER BY "master_kecamatan"."lokasi_nama" ASC;
Mon, 02 Sep 2024 19:16:09 GMT+0530 GET /api/getSubdistrict/36/71 200 5.795 ms - -
Mon, 02 Sep 2024 19:16:56 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" ORDER BY "master_propinsi"."sort" ASC;
Mon, 02 Sep 2024 19:16:56 GMT+0530 GET /api/getProvince 304 17.459 ms - -
Mon, 02 Sep 2024 19:17:40 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:17:40 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:17:40 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 29.489 ms - -
Mon, 02 Sep 2024 19:18:37 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:18:37 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:18:37 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 30.556 ms - -
Mon, 02 Sep 2024 19:20:00 GMT+0530 Executing (default): UPDATE history_quota
Mon, 02 Sep 2024 19:20:00 GMT+0530             SET logs = advertises || ' ' || advertises_id
Mon, 02 Sep 2024 19:20:00 GMT+0530 Executing (default): UPDATE agents
Mon, 02 Sep 2024 19:20:00 GMT+0530             SET logs = agents.city || ' ' || agents.province || ' ' || agents.pic_name || ' ' || agents.office
Mon, 02 Sep 2024 19:20:00 GMT+0530             where agents.id is not null
Mon, 02 Sep 2024 19:20: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:20: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 13:50:00.004 +00:00' AND "advertises"."is_publish" = 1 LIMIT 1;
Mon, 02 Sep 2024 19:20: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 13:50:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:20: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 13:50:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:20: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:20: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:20:00 GMT+0530 Executing (default): UPDATE "advertises" SET "is_highlights"=$1,"highlight_id"=$2,"updatedAt"=$3 WHERE "id" = $4
Mon, 02 Sep 2024 19:20:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'trustproperty@yahoo.com';
Mon, 02 Sep 2024 19:20:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'fathan@propertyklik.com';
Mon, 02 Sep 2024 19:20:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'adiparahyangan8@gmail.com';
Mon, 02 Sep 2024 19:20:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'aghatosproperti@gmail.com';
Mon, 02 Sep 2024 19:20: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:20: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:20: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:20:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'confidentpropertyofficial@gmail.com';
Mon, 02 Sep 2024 19:20:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'ptamanahtegumakmur@gmail.com';
Mon, 02 Sep 2024 19:20: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:20: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" = 7755;
Mon, 02 Sep 2024 19:20:13 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:20:13 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:20:13 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 30.782 ms - -
Mon, 02 Sep 2024 19:23:48 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:23:48 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:23:48 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 30.074 ms - -
Mon, 02 Sep 2024 19:25:00 GMT+0530 Executing (default): UPDATE history_quota
Mon, 02 Sep 2024 19:25:00 GMT+0530             SET logs = advertises || ' ' || advertises_id
Mon, 02 Sep 2024 19:25:00 GMT+0530 Executing (default): UPDATE agents
Mon, 02 Sep 2024 19:25:00 GMT+0530             SET logs = agents.city || ' ' || agents.province || ' ' || agents.pic_name || ' ' || agents.office
Mon, 02 Sep 2024 19:25:00 GMT+0530             where agents.id is not null
Mon, 02 Sep 2024 19:25: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:25: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 13:55:00.005 +00:00' AND "advertises"."is_publish" = 1 LIMIT 1;
Mon, 02 Sep 2024 19:25: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 13:55:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:25: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 13:55:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:25: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:25: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:25:00 GMT+0530 Executing (default): UPDATE "advertises" SET "is_highlights"=$1,"highlight_id"=$2,"updatedAt"=$3 WHERE "id" = $4
Mon, 02 Sep 2024 19:25:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'trustproperty@yahoo.com';
Mon, 02 Sep 2024 19:25:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'fathan@propertyklik.com';
Mon, 02 Sep 2024 19:25:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'adiparahyangan8@gmail.com';
Mon, 02 Sep 2024 19:25:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'aghatosproperti@gmail.com';
Mon, 02 Sep 2024 19:25: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:25: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:25: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:25:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'confidentpropertyofficial@gmail.com';
Mon, 02 Sep 2024 19:25:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'ptamanahtegumakmur@gmail.com';
Mon, 02 Sep 2024 19:25: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:25: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" = 7755;
Mon, 02 Sep 2024 19:25:17 GMT+0530 Executing (default): SELECT "id", "name", "profile", "email", "password", "role", "createdAt", "updatedAt" FROM "admins" AS "admins" WHERE "admins"."email" = 'admin@xyz.com';
Mon, 02 Sep 2024 19:25:17 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:25:17 GMT+0530 POST /api/login 200 101.086 ms - -
Mon, 02 Sep 2024 19:25:17 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "building_types" AS "building_types";
Mon, 02 Sep 2024 19:25:17 GMT+0530 Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" ORDER BY "building_types"."createdAt" DESC LIMIT 10 OFFSET 0;
Mon, 02 Sep 2024 19:25:17 GMT+0530 GET /api/buildingtype?page=1&size=10 304 6.397 ms - -
Mon, 02 Sep 2024 19:25:17 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, 1, 2, 3, 4)) WHERE "advertises"."deletedAt" IS NULL;
Mon, 02 Sep 2024 19:25:17 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3, 4) AND "agents"."is_pic" = false);
Mon, 02 Sep 2024 19:25:17 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", CASE WHEN type_agent = '3' THEN 'Agent Corporate'  WHEN type_agent = '4' THEN 'Property Developer' ELSE '-' END AS "type_agent_label" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3, 4) AND "agents"."is_pic" = false) ORDER BY "agents"."createdAt" DESC LIMIT 10 OFFSET 0;
Mon, 02 Sep 2024 19:25:17 GMT+0530 Executing (default): SELECT "id", "title", "logo", "desc", "email", "phone", "address", "fb", "twitter", "ig", "yt", "linknd", "wa", "tiktok", "icon_wa", "icon_mail", "icon_phone", "icon_address", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."id" = 1;
Mon, 02 Sep 2024 19:25:17 GMT+0530 GET /api/agent?page=1&size=10&level=3,4 304 61.538 ms - -
Mon, 02 Sep 2024 19:25:17 GMT+0530 GET /api/company/1 304 19.528 ms - -
Mon, 02 Sep 2024 19:25:18 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, 1, 2, 3, 4)) WHERE "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:25:19 GMT+0530 GET /api/advertises?page=1&size=10 200 1728.986 ms - -
Mon, 02 Sep 2024 19:25:28 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3) AND "agents"."is_pic" = false AND "agents"."id_agent_era" IS NOT NULL);
Mon, 02 Sep 2024 19:25:28 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", CASE WHEN type_agent = '3' THEN 'Agent Corporate'  WHEN type_agent = '4' THEN 'Property Developer' ELSE '-' END AS "type_agent_label" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3) AND "agents"."is_pic" = false AND "agents"."id_agent_era" IS NOT NULL) ORDER BY "agents"."createdAt" DESC LIMIT 10 OFFSET 0;
Mon, 02 Sep 2024 19:25:28 GMT+0530 GET /api/agent?page=1&size=10&level=3&integrasi=era 304 22.699 ms - -
Mon, 02 Sep 2024 19:25:44 GMT+0530 Executing (default): SELECT "id", "title", "logo", "desc", "email", "phone", "address", "fb", "twitter", "ig", "yt", "linknd", "wa", "tiktok", "icon_wa", "icon_mail", "icon_phone", "icon_address", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."id" = 1;
Mon, 02 Sep 2024 19:25:44 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:25:44 GMT+0530 GET /api/company/1 304 22.720 ms - -
Mon, 02 Sep 2024 19:25:44 GMT+0530 GET /api/permission/?role=17 304 45.116 ms - -
Mon, 02 Sep 2024 19:25:44 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3) AND "agents"."is_pic" = false AND "agents"."id_agent_era" IS NOT NULL);
Mon, 02 Sep 2024 19:25:44 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", CASE WHEN type_agent = '3' THEN 'Agent Corporate'  WHEN type_agent = '4' THEN 'Property Developer' ELSE '-' END AS "type_agent_label" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3) AND "agents"."is_pic" = false AND "agents"."id_agent_era" IS NOT NULL) ORDER BY "agents"."createdAt" DESC LIMIT 10 OFFSET 0;
Mon, 02 Sep 2024 19:25:44 GMT+0530 GET /api/agent?page=1&size=10&level=3&integrasi=era 304 27.634 ms - -
Mon, 02 Sep 2024 19:25:54 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
Mon, 02 Sep 2024 19:25:54 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:25:54 GMT+0530 GET /api/highlight?page=1&size=500 304 14.836 ms - -
Mon, 02 Sep 2024 19:25:54 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:25:54 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:25:55 GMT+0530 GET /api/advertises?page=1&size=10&agentType=3&integrasi=era 304 534.292 ms - -
Mon, 02 Sep 2024 19:26:12 GMT+0530 GET /api/permission/?role=17 304 6.224 ms - -
Mon, 02 Sep 2024 19:26:13 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:26:13 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:26:13 GMT+0530 GET /api/advertises?page=1&size=10&agentType=3&integrasi=era 304 553.438 ms - -
Mon, 02 Sep 2024 19:28:36 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:28:36 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:28:36 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 38.280 ms - -
Mon, 02 Sep 2024 19:29:05 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:29:05 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:29:05 GMT+0530 GET /api/getCityAll?page=1&size=1000 304 39.246 ms - -
Mon, 02 Sep 2024 19:29:51 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "master_kabkos" AS "master_kabko";
Mon, 02 Sep 2024 19:29: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" ORDER BY "master_kabko"."sort" ASC LIMIT 1000 OFFSET 0;
Mon, 02 Sep 2024 19:29:51 GMT+0530 GET /api/getCityAll?page=1&size=1000 200 31.727 ms - -
Mon, 02 Sep 2024 19:30:00 GMT+0530 Executing (default): UPDATE history_quota
Mon, 02 Sep 2024 19:30:00 GMT+0530             SET logs = advertises || ' ' || advertises_id
Mon, 02 Sep 2024 19:30:00 GMT+0530 Executing (default): UPDATE agents
Mon, 02 Sep 2024 19:30:00 GMT+0530             SET logs = agents.city || ' ' || agents.province || ' ' || agents.pic_name || ' ' || agents.office
Mon, 02 Sep 2024 19:30:00 GMT+0530             where agents.id is not null
Mon, 02 Sep 2024 19:30: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:30: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:00:00.004 +00:00' AND "advertises"."is_publish" = 1 LIMIT 1;
Mon, 02 Sep 2024 19:30: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:00:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:30: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:00:00.005 +00:00' LIMIT 1;
Mon, 02 Sep 2024 19:30: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:30: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:30:00 GMT+0530 Executing (default): UPDATE "advertises" SET "is_highlights"=$1,"highlight_id"=$2,"updatedAt"=$3 WHERE "id" = $4
Mon, 02 Sep 2024 19:30:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'trustproperty@yahoo.com';
Mon, 02 Sep 2024 19:30:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'fathan@propertyklik.com';
Mon, 02 Sep 2024 19:30:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'adiparahyangan8@gmail.com';
Mon, 02 Sep 2024 19:30:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'aghatosproperti@gmail.com';
Mon, 02 Sep 2024 19:30: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:30: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:30: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:30:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'confidentpropertyofficial@gmail.com';
Mon, 02 Sep 2024 19:30:00 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "partners" AS "partners" WHERE "partners"."email" = 'ptamanahtegumakmur@gmail.com';
Mon, 02 Sep 2024 19:30: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:30: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" = 7755;
Mon, 02 Sep 2024 19:32:27 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:27 GMT+0530 Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
Mon, 02 Sep 2024 19:32:27 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:32:27 GMT+0530 GET /api/highlight?page=1&size=500 304 24.413 ms - -
Mon, 02 Sep 2024 19:32:27 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:27 GMT+0530 GET /api/advertises?page=1&size=10&agentType=3&integrasi=era 200 572.534 ms - -
Leave a Comment