• Join BOO - V I P Channel (Private) - Daily Update! +50k File Shared Already
    1 MONTH Plan = 259$ — 6 MONTH Plan = 499$ — LIFE TIME Plan = 999$    [Contact on Telegram]
Japanese Real Estate - Village House (villagehouse.jp) Full SQL (180k Records)

boo

Administrator
booCash
16,417
Village House (villagehouse.jp) is a Japanese real estate website specializing in affordable rental apartments throughout Japan. It caters primarily to budget-conscious individuals, offering a wide range of properties in various locations. The company is based in Tokyo, Japan, and focuses on providing low-cost housing solutions with minimal upfront costs, making it accessible for both locals and expatriates. Village House emphasizes ease of access and straightforward rental processes, catering to a diverse clientele seeking cost-effective living options in Japan.



(1, '65add53db15731705891133feea0a87cf', NULL, 'Unit_renovation/getRepairsEstimatedTableData/289967/0/0', '[\"Unit_renovation\", \"getRepairsEstimatedTableData\", \"289967\", \"0\", \"0\"]', 'Unit_renovation', 'getRepairsEstimatedTableData', '289967', '[]', '', '106.186.214.123', 'rtamari@villagehouse.jp', 748, 1705891133, '[]', '[]', '{\"code\": 0, \"message\": \"\"}', 'null', 'null'),
(1, '65add53e41c0e17058911345c24215106', NULL, 'Unit_renovation/get_system_data/289967/true/0', '[\"Unit_renovation\", \"get_system_data\", \"289967\", \"true\", \"0\"]', 'Unit_renovation', 'get_system_data', '289967', '[]', '', '106.186.214.123', 'rtamari@villagehouse.jp', 748, 1705891134, '[]', '[]', '{\"code\": 0, \"message\": \"\"}', 'null', 'null'),
(1, '65add53f64c78170589113507cec5b85c', NULL, 'WorkReporting/RepairsdataFliter', '[\"WorkReporting\", \"RepairsdataFliter\"]', 'WorkReporting', 'RepairsdataFliter', '', '{\"draw\": \"2\", \"start\": \"0\", \"length\": \"25\", \"search\": {\"regex\": \"false\", \"value\": \"RMI0290925\"}, \"columns\": [{\"data\": \"0\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"true\", \"searchable\": \"true\"}, {\"data\": \"1\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"true\", \"searchable\": \"true\"}, {\"data\": \"2\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"true\", \"searchable\": \"true\"}, {\"data\": \"3\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"true\", \"searchable\": \"true\"}, {\"data\": \"4\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"true\", \"searchable\": \"true\"}, {\"data\": \"5\", \"name\": \"\",
(1, '65add540de2911705891136b672f97199', NULL, 'Ajax_response/GetRepairsPopupData', '[\"Ajax_response\", \"GetRepairsPopupData\"]', 'Ajax_response', 'GetRepairsPopupData', '', '{\"draw\": \"1\", \"start\": \"0\", \"length\": \"-1\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"columns\": [{\"data\": \"0\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"1\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"2\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"3\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"4\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"5\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"6\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"7\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"8\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"9\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}, {\"data\": \"10\", \"name\": \"\", \"search\": {\"regex\": \"false\", \"value\": \"\"}, \"orderable\": \"false\", \"searchable\": \"true\"}], \"prop_id\": \"\", \"unit_id\": \"\", \"job_loc_id\": \"\", \"building_id\": \"\", \"reported_location\": \"\"}', 'draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=false&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=false&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=false&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=false&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=false&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=false&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=7&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=false&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=8&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=false&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B9%5D%5Bdata%5D=9&columns%5B9%5D%5Bname%5D=&columns%5B9%5D%5Bsearchable%5D=true&columns%5B9%5D%5Borderable%5D=false&columns%5B9%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B9%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B10%5D%5Bdata%5D=10&columns%5B10%5D%5Bname%5D=&columns%5B10%5D%5Bsearchable%5D=true&columns%5B10%5D%5Borderable%5D=false&columns%5B10%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B10%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=-1&search%5Bvalue%5D=&search%5Bregex%5D=false&prop_id=&building_id=&unit_id=&job_loc_id=&reported_location=', '106.186.214.123', 'mtajima@villagehouse.jp', 756, 1705891136, '[]', '[]', '{\"code\": 0, \"message\": \"\"}', 'null', 'null');
(1, '65add541ed13b1705891137c5e6ae4b4f', NULL, 'Unit_renovation/edit_units_repairsJob/290925/0/0/0/Repairs', '[\"Unit_renovation\", \"edit_units_repairsJob\", \"290925\", \"0\", \"0\", \"0\", \"Repairs\"]', 'Unit_renovation', 'edit_units_repairsJob', '290925', '[]', '', '152.165.115.159', 'dhashimoto@villagehouse.jp', 367, 1705891137, '[\"SELECT GET_LOCK(\'d345133253e050b4924dbe669253052d79d08461_152.165.115.159\', 300) AS ci_session_lock\", \"SELECT `data`\\nFROM `sessions`\\nWHERE `id` = \'d345133253e050b4924dbe669253052d79d08461\'\\nAND `ip_address` = \'152.165.115.159\'\", \"SELECT `id`, CONCAT( last_name, \\\" \\\", first_name) as fullName\\nFROM `user`\", \"SELECT *\\nFROM `translate_language`\", \"SELECT *\\nFROM `translate_alert`\", \"SELECT `id`, `is_deleted` as `delete_status`\\nFROM `repairs_job_card`\\nWHERE `id` = \'290925\'\", \"SELECT `repairs_job_card`.`insertion_date` as `insertion_date`, `repairs_job_card`.`job_id_system_gen`, `repairs_job_card`.`ordering_firm`, `job_location`.`location_name_e`, `job_location`.`location_name_j`, `job_location`.`reported_location` as `job_type`, `vendor_bank_accounts`.`id` as `bank_prim_id`, `vendor_bank_accounts`.`priority`, `repairs_job_card`.`forcasted_compl_date`, `repairs_job_card`.`wrkflow_wrk_job_approved_last_updt_on`, `repairs_job_card`.`emergency`, `repairs_job_card`.`inserted_by`, `repairs_job_card`.`contractor_jw`, `portfolio`.`portfolio_name`, `portfolio`.`portfolio_namej`, CONCAT ( \\\"(\\\", `portfolio`.`jeed_code`, \\\")\\\") as prop_jeed_code, `portfolio`.`jeed_code`, `building`.`BuildingName`, `unit_information`.`unit_no`, `user`.`first_name`, `user`.`last_name`, `CM`.`first_name` as `cm_first_name`, `CM`.`last_name` as `cm_last_name`, `repairs_job_card`.`inserted_by`, `repairs_job_card`.`construction_manager`, `CM`.`phone_number` as `cm_phone_number`, `CM`.`email` as `cm_email`, `third_parties`.`tp_party_name`, `third_parties`.`tp_party_namej`, `third_parties`.`tp_email_address`, `third_parties`.`tp_phone`, `third_parties`.`tp_fax`, `repairs_job_card`.`approval_id_system_gen` as `approval_number`, `repairs_job_card`.`job_name`, `repairsjob_types`.`job_type_name`, `repairsjob_types`.`job_type_name_japanese`, `repairs_job_card`.`job_type_id`, `repairs_job_card`.`vendor_construction_notes`, `repairs_job_card`.`construction_manager`, `repairs_job_card`.`construction_content`, `repairs_job_card`.`notes`, `repairs_job_card`.`construction_reason`, `repairs_job_card`.`tenant_kana`, `repairs_job_card`.`tenant_phone`, `repairs_job_card`.`tenant_email`, `repairs_job_card`.`tenant_move_in_date`, `vendor_bank_accounts`.`bank_no`, `vendor_bank_accounts`.`bank_kana`, `vendor_bank_accounts`.`branch_no`, `vendor_bank_accounts`.`branch_kana`, `vendor_bank_accounts`.`account_type`, `vendor_bank_accounts`.`account_no`, `vendor_bank_accounts`.`account_kana`, `repairs_estimate`.`amount`, `repairs_estimate`.`tax_amount`, `repairs_estimate`.`total_amount`, `unit_info_option`.`opt_name`, `unit_info_option`.`opt_namej`, `portfolio`.`portfolio_namej` as `PropertyName`, `third_parties`.`tp_party_namej` as `vendor_name`, `repairsjob_types`.`job_type_name_japanese` as `job_type_name`, `job_location`.`location_name_j` as `job_locatn_name`, `repairs_payment`.`inv_status`, `building`.`BuildingName`, `building`.`building_long_name`, `building`.`BuildingID`\\nFROM `repairs_job_card`\\nLEFT JOIN `portfolio` ON `portfolio`.`id` = `repairs_job_card`.`prop_id`\\nLEFT JOIN `building` ON `building`.`id` = `repairs_job_card`.`build_id`\\nLEFT JOIN `unit_information` ON `unit_information`.`id` = `repairs_job_card`.`unit_id`\\nLEFT JOIN `third_parties` ON `third_parties`.`id` = `repairs_job_card`.`contractor_jw`\\nLEFT JOIN `repairsjob_types` ON `repairsjob_types`.`id` = `repairs_job_card`.`job_type_id`\\nLEFT JOIN `repairs_estimate` ON `repairs_estimate`.`id` = `repairs_job_card`.`contractor_selected_id`\\nLEFT JOIN `vendor_bank_accounts` ON `vendor_bank_accounts`.`vendor_id` = `repairs_job_card`.`contractor_jw` AND `vendor_bank_accounts`.`is_deleted` != 1\\nLEFT JOIN `user` ON `user`.`id` = `repairs_job_card`.`inserted_by`\\nLEFT JOIN `user` `CM` ON `CM`.`id` = `repairs_job_card`.`construction_manager`\\nLEFT JOIN `unit_info_option` ON `unit_info_option`.`id` = `repairs_job_card`.`ordering_firm`\\nLEFT JOIN `job_location` ON `job_location`.`id` = `repairs_job_card`.`job_loc_id`\\nLEFT JOIN `repairs_payment` ON `repairs_payment`.`job_id` = `repairs_job_card`.`id`\\nWHERE `repairs_job_card`.`id` = \'290925\'\\nORDER BY `repairs_payment`.`id` DESC, `vendor_bank_accounts`.`id` ASC\", \"SELECT `reported_location_id`, `contractor_jw`, `work_order_type`, `phase1_2_completed_by`, `phase1_3_completed_by`, `phase1_4_completed_by`, `local_coi_completed_by`, `job_proposal_completed_by`, `sub_contract_completed_by`, `phase1_5_completed_by`, `phase1_6_completed_by`, `phase1_7_completed_by`, `phase1_8_completed_by`, `phase1_9_completed_by`, `phase3_1_completed_by`, `phase3_2_completed_by`, `phase3_3_completed_by`, `dob_approval_completed_by`, `ll11_approval_completed_by`, `phase3_4_completed_by`, `upgrade`, `dep_approval_completed_by`\\nFROM `repairs_job_card`\\nWHERE `id` = \'290925\'\", \"SELECT `vendor_bank_approval`\\nFROM `user`\\nWHERE `id` = \'367\'\", \"SELECT `unit_info_option`.*\\nFROM `unit_info_option`\\nWHERE `opt_flag` = \'interior_reason_req_flag\' OR `opt_flag` = \'exterior_reason_req_flag\'\\nGROUP BY `opt_namej`\", \"SELECT `repairs_job_card`.*, `repairs_job_card`.`id` as `jobcardkey`\\nFROM `repairs_job_card`\\nWHERE `repairs_job_card`.`id` = \'290925\'\", \"SELECT `id`, `first_name`, `last_name`, `user_approval_level`, `region`, `user_type_id`\\nFROM `user`\\nWHERE `construction_manager_access` = 1 AND regional_office LIKE \'%6%\' AND `is_active` = 1\", \"SELECT `job_approver`, `approver`\\nFROM `user`\\nWHERE `id` = \'367\'\", \"SELECT *\\nFROM `admin_config`\", \"SELECT `approval_logs`.`action`, `approval_date`, `updated_by` as `updated_by_name`\\nFROM `approval_logs`\\nWHERE `approval_logs`.`job_id` = \'290925\'\\nAND `module_name` = \'Interior R&M\'\\nAND `step` = 1\\nAND `is_last` = 1\\nAND `approval_type` = 1\", \"SELECT `approval_logs`.`action`, `approval_date`, `updated_by` as `updated_by_name`\\nFROM `approval_logs`\\nWHERE `approval_logs`.`job_id` = \'290925\'\\nAND `module_name` = \'Interior R&M\'\\nAND `step` = 2\\nAND `is_last` = 1\\nAND `approval_type` = 1\", \"SELECT `approval_logs`.`action`, `approval_date`, `updated_by` as `updated_by_name`\\nFROM `approval_logs`\\nWHERE `approval_logs`.`job_id` = \'290925\'\\nAND `module_name` = \'Interior R&M\'\\nAND `step` = 3\\nAND `is_last` = 1\\nAND `approval_type` = 1\", \"SELECT `approval_logs`.`action`, `approval_date`, `updated_by` as `updated_by_name`\\nFROM `approval_logs`\\nWHERE `approval_logs`.`job_id` = \'290925\'\\nAND `module_name` = \'Interior R&M\'\\nAND `step` = 4\\nAND `is_last` = 1\\nAND `approval_type` = 1\", \"SELECT `id`\\nFROM `approval_level`\\nWHERE `module_id` = 5200\\nAND `level` = 1\\nAND `approval_type` = 1\", \"SELECT `id`\\nFROM `approval_level`\\nWHERE `module_id` = 5200\\nAND `level` = 2\\nAND `approval_type` = 1\", \"SELECT `id`\\nFROM `approval_level`\\nWHERE `module_id` = 5200\\nAND `level` = 3\\nAND `approval_type` = 1\", \"SELECT `id`\\nFROM `approval_level`\\nWHERE `module_id` = 5200\\nAND `level` = 4\\nAND `approval_type` = 1\", \"SELECT `id`, `user_approval_level`\\nFROM `user`\\nWHERE `id` = \'367\'\", \"SELECT `repairs_estimate`.`id`, `repairs_estimate`.`updated_on`, `repairs_estimate`.`submitted_on`, `repairs_estimate`.`is_selected`, `repairs_estimate`.`submitted_by`, `repairs_estimate`.`contractor_id`, `third_parties`.`id` as `vendor_id`, `third_parties`.`tp_email_address`, `third_parties`.`tp_mds_vendor_number`, `third_parties`.`tp_party_name` as `vendor_kana`, `third_parties`.`tp_party_namej` as `vendor_kanji`, `third_parties`.`tp_party_namej` as `vendor_name`\\nFROM `repairs_estimate`\\nLEFT JOIN `third_parties` ON `third_parties`.`id` = `repairs_estimate`.`contractor_id`\\nWHERE `repairs_estimate`.`unit_job_id` = \'290925\'\\nAND `is_temporary` = 1\", \"SELECT `approval_logs`.`approval_date`, `approval_logs`.`updated_by`\\nFROM `repairs_job_card`\\nINNER JOIN `approval_logs` ON `approval_logs`.`id` = `repairs_job_card`.`last_approval_log_id`\\nWHERE `repairs_job_card`.`id` = \'290925\'\\nAND `repairs_job_card`.`approval_status` = 1\", \"SELECT Count(repairs_estimate.id) as total_estimate, `contractor_id`\\nFROM `repairs_estimate`\\nWHERE `repairs_estimate`.`unit_job_id` = \'290925\'\\nAND `repairs_estimate`.`is_deleted` =0\", \"SELECT *\\nFROM `unit_info_option`\\nWHERE `opt_flag` = \'request_source_flag\'\\nORDER BY `id` ASC\", \"SELECT *\\nFROM `unit_info_option`\\nWHERE `opt_flag` = \'ordering_firm_flag\'\\nORDER BY `id` ASC\", \"SELECT `approval_logs`.`updated_by` as `order_approvor_name`, `approval_date`\\nFROM `approval_logs`\\nWHERE `job_id` = \'290925\'\\nAND `module_name` = \'Interior R&M\'\\nAND `approval_type` = 2\\nAND `is_last` = 1\\nAND `action` = \'Approved\'\\nORDER BY `step` DESC\", \"SELECT *\\nFROM `third_parties`\\nWHERE `id` IS NULL\", \"SELECT *\\nFROM `approval_level`\\nWHERE `module_id` = 5200\\nAND `approval_type` = 1\", \"SELECT `contractor_id`\\nFROM `repairs_estimate`\\nWHERE `unit_job_id` = \'290925\'\\nAND `is_selected` = 1\", \"SELECT `committed`\\nFROM `repairs_job_card`\\nWHERE `repairs_job_card`.`id` = \'290925\'\", \"SELECT `approval_level`.*\\nFROM `approval_level`\\nWHERE `level` <= 2\\nAND `approval_type` = 1\\nAND `module_id` = 5200\", \"SELECT Count(id) as total_invoice\\nFROM `repairs_payment`\\nWHERE `job_id` = \'290925\'\\nAND `module_name` = \'Interior_RM\'\\nAND `repairs_payment`.`is_deleted` =0\", \"SELECT Count(id) as pending_invoice\\nFROM `repairs_payment`\\nWHERE `job_id` = \'290925\'\\nAND `module_name` = \'Interior_RM\'\\nAND `repairs_payment`.`is_deleted` =0\\nAND `inv_status` != 2\", \"SELECT sum(inv_amount) as total_invoice_pre_tax_amount, sum(inv_tax) as total_invoice_tax_amount, sum(inv_total_amount) as total_invoice_amount\\nFROM `repairs_payment`\\nWHERE `job_id` = \'290925\'\\nAND `is_deleted` =0\\nAND `is_inv_cancelled` =0\\nAND `module_name` = \'Interior_RM\'\", \"UPDATE `repairs_job_card` SET `billedToDate` = \'328332\', `billedToDatePreTax` = \'320893\'\\nWHERE `id` = \'290925\'\", \"SELECT `id`, `updated_on`\\nFROM `repairs_payment`\\nWHERE `job_id` = \'290925\'\\nAND `module_name` = \'Interior_RM\'\\nAND `inv_status` = 2\", \"SELECT Count(id) as count_rows\\nFROM `jobs_lineitem`\\nWHERE `jobs_lineitem`.`job_id` = \'290925\'\\nAND `jobs_lineitem`.`module_name` = \'Interior_RM\'\\nAND `jobs_lineitem`.`is_deleted` =0\", \"SELECT COUNT(id) as total_no_of_img\\nFROM `repairs_photo`\\nWHERE `jobid` = \'290925\'\\nAND `is_removed` =0\", \"SELECT `edit_job_detail`, `line_item_bulk_import`\\nFROM `roles`\\nWHERE `roles`.`id` = \'9\'\", \"SELECT `job_location`.*\\nFROM `job_location`\\nWHERE `reported_location` = \'5275\'\", \"SELECT `id`, `attch_japenese_name` as `attchmnt_name`\\nFROM `attachments_type`\\nWHERE `is_status` = 1\", \"SELECT *\\nFROM `unit_info_option`\\nWHERE `opt_flag` = \'reported_location\'\", \"SELECT `portfolio`.*\\nFROM `portfolio`\\nLEFT JOIN `prefecture` ON `prefecture`.`id` = `portfolio`.`prefecture_id` \\nWHERE `region_id` IN (1,2,3,4,5,6,7)\\nORDER BY `jeed_code` ASC\", \"SELECT `roles`.*\\nFROM `roles`\\nINNER JOIN `user` ON `user`.`role_id` = `roles`.`id`\\nWHERE `user`.`id` = \'367\'\", \"SELECT `portfolio`.*\\nFROM `portfolio`\\nLEFT JOIN `prefecture` ON `prefecture`.`id` = `portfolio`.`prefecture_id` \\nWHERE `region_id` IN (1,2,3,4,5,6,7) AND `portfolio_namej` != \'\' \\nORDER BY `portfolio_namej` ASC\", \"SELECT `portfolio`.*\\nFROM `portfolio`\\nLEFT JOIN `prefecture` ON `prefecture`.`id` = `portfolio`.`prefecture_id` \\nWHERE `region_id` IN (1,2,3,4,5,6,7) AND `mds_comp_no` != \'\' \\nORDER BY `mds_comp_no` ASC\", \"SELECT `portfolio`.*, `prefecture`.`prefecture_name`, `prefecture`.`prefecture_namej`\\nFROM `portfolio`\\nLEFT JOIN `prefecture` ON `prefecture`.`id` = `portfolio`.`prefecture_id` \\nWHERE `portfolio`.`regional_office_id` IN (1,3,4,5,6,7,8) AND `portfolio_namej` != \'\' \\nORDER BY `portfolio_namej` ASC\", \"SELECT `portfolio`.*, `prefecture`.`prefecture_name`, `prefecture`.`prefecture_namej`\\nFROM
(1, '65add542aac6417058911381a25dc3159', NULL, 'Units/get_vh_bank_acnts', '[\"Units\", \"get_vh_bank_acnts\"]', 'Units', 'get_vh_bank_acnts', '', '{\"bankId\": \"5\"}', 'bankId=5', '92.203.99.55', 'yokusa@villagehouse.jp', 420, 1705891138, '[\"SELECT GET_LOCK(\'6a1ae5aa10d5b7ffccc27810ef3fafd6b199cde1_92.203.99.55\', 300) AS ci_session_lock\", \"SELECT `data`\\nFROM `sessions`\\nWHERE `id` = \'6a1ae5aa10d5b7ffccc27810ef3fafd6b199cde1\'\\nAND `ip_address` = \'92.203.99.55\'\", \"SELECT *\\nFROM `user_rights`\\nWHERE `user_id` = \'420\'\", \"SELECT *\\nFROM `translate_language`\", \"SELECT *\\nFROM `translate_alert`\", \"SELECT *\\nFROM `bank_accounts_ap`\", \"SELECT `unit_info_option`.`id`, `unit_info_option`.`opt_name`, `unit_info_option`.`opt_namej`\\nFROM `unit_info_option`\\nWHERE `opt_flag` = \'withdrawal_type\'\"]', '[0.000077009201049805, 0.060585021972656, 0.00016689300537109, 0.00061202049255371, 0.0006718635559082, 0.00028204917907715, 0.0006251335144043]', '{\"code\": 0, \"message\": \"\"}', 'null', 'null'),
(1, '65add542ac6f01705891138e925bea8f3', NULL, 'Unit_renovation/getJobLocByRepLocation', '[\"Unit_renovation\", \"getJobLocByRepLocation\"]', 'Unit_renovation', 'getJobLocByRepLocation', '', '{\"reported_location\": \"5273\"}', 'reported_location=5273', '106.186.214.123', 'mtajima@villagehouse.jp', 756, 1705891138, '[]', '[]', '{\"code\": 0, \"message\": \"\"}', 'null', 'null'),

The leaked data for Village House, a Japanese real estate company, appears to include detailed SQL logs with sensitive information. Here’s an analysis of the data entries provided:

  1. Entry Details:
    • IP Address: 106.186.214.123
    • User Email: rmatsumura@villagehouse.jp
    • User ID: 800
    • API Endpoint Accessed: Units/getAllUnitsByPropertyBuilding/413/1141/changeunitformat
    • Method: getAllUnitsByPropertyBuilding
    • Portfolio ID: 413
    • Building ID: 1141
    • Executed SQL Queries:
      • Acquire lock: SELECT GET_LOCK('c558cca52a880c65619accbd4bfe814fb0b5fc1b_106.186.214.123', 300) AS ci_session_lock
      • Retrieve session data: SELECT 'data' FROM 'sessions' WHERE 'id' = 'c558cca52a880c65619accbd4bfe814fb0b5fc1b' AND 'ip_address' = '106.186.214.123'
      • Fetch user rights: SELECT * FROM 'user_rights' WHERE 'user_id' = '800'
      • Get translation languages: SELECT * FROM 'translate_language'
      • Fetch translation alerts: SELECT * FROM 'translate_alert'
      • Retrieve unit information: SELECT 'unit_information'.'id', 'unit_information'.'unit_no' FROM 'unit_information' WHERE 'unit_information'.'portfolio_id' = '413' AND 'unit_information'.'building_id' = '1141' GROUP BY 'id' ORDER BY 'unit_no' ASC
    • Execution Times: Various execution times for each SQL query are logged.
  2. Second Entry Details:
    • IP Address: 106.156.94.248
    • User Email: sihara@villagehouse.jp
    • User ID: 454
    • API Endpoint Accessed: Unit_renovation/getAllBankAccountsDataByVendorID
    • Method: getAllBankAccountsDataByVendorID
    • Vendor ID: -1 (Invalid or placeholder ID)
    • Executed SQL Queries: No specific queries logged
 
You must log in or register to reply here.
Back
Top