Dr. Maurinsh Vein Center

Таблиця	id	post_type	post_author	post_title	post_content
leshaabr_posts	int(1217)	string(6) "clinic"	int(1) сюди просто "1" ставте.	string(40) "Indimasi Ayurveda & Healing Village" це колонка "name" в старому парсері.	string(554) " Indimasi Healing Village is a sanctuary of tranquility nestled in the serene outskirts of Trivandrum City, surrounded by lush vegetation and fertile agricultural lands. Founded by Yogi Shivan, Indimasi is a realization of his dream, aiming to share the benefits of ancient healing practices with the world. At its core, Indimasi seeks to empower individuals to unlock their inner potential and embark on a transformative journey towards self-realization through the ancient Siddha yoga method. " це колонка "full_description" в старому парсері.

Таблиця	post_id	meta_key	meta_value
leshaabr_postmeta	int(1217)	clinic_id	string(3) "370"
leshaabr_postmeta	int(1217)	original_url	string(57) "https://us-uk.bookimed.com/clinic/dr-maurinsh-vein-center"
leshaabr_postmeta	int(1217)	geo	string(128) "{"latitude": 57.001433, "longitude": 24.159731, "country": "Latvia", "city": "Riga", "address": " Kokneses prospekts 18A, Riga"}"
leshaabr_postmeta	int(1217)	statistics	string(249) "{"year_foundation": 2001, "employees_number": 0, "doctors_number": 9, "patient_per_year": 20000, "number_of_beds": 0, "number_of_departments": 4, "operations_per_year": 2500, "children_per_year": 0, "number_of_buildings": 0, "number_of_reviews": 12}"
leshaabr_postmeta	int(1217)	accreditations	string(412) "[{"name": "Certification according to DIN EN ISO 9001 by T\u00dcV NORD CERT", "description": "T\u00dcV NORD DIN EN ISO evaluates quality management system, certifies and performs audits.", "abbreviation": "T\u00dcV NORD CERT", "logo": "https://s3.eu-central-1.amazonaws.com/bookimed/accreditations/5ceb725522d15.jpeg", "web_site_link": "https://www.tuev-nord.de/en/company/certification/", "country_code": "DE"}]"
leshaabr_postmeta	int(1217)	licences	string(286) "[{"url": "https://s3.eu-central-1.amazonaws.com/bookimed/license/67c1a1f40cd007.30136489.jpeg", "expires_at": "2028-12-30T23:00:00.000+00:00"}, {"url": "https://s3.eu-central-1.amazonaws.com/bookimed/license/67c1ae3c490497.04159108.jpeg", "expires_at": "2027-12-30T23:00:00.000+00:00"}]"
leshaabr_postmeta	int(1217)	illnesses	string(2870) "[{"illness": {"name": "Orthopedics", "alias": "orthopedics-and-traumatology"}, "operation_prices": [{"name": "Knee Arthroscopy", "alias": "therapeutic-arthroscopy-of-the-knee--including-the-necessary-supplies", "price_to": 1752.989284978209, "price_from": 1252.1352035558637, "currency": "USD"}, {"name": "Anterior cruciate ligament reconstruction", "alias": "anterior-cruciate-ligament-reconstruction", "price_to": 3505.978569956418, "price_from": 3005.1244885340725, "currency": "USD"}, {"name": "Rotator cuff repair surgery", "alias": "rotator-cuff-repair-surgery", "price_to": 3005.1244885340725, "price_from": 2504.2704071117273, "currency": "USD"}, {"name": "Shoulder replacement", "alias": "shoulder-replacement", "price_to": 7512.8112213351815, "price_from": 6761.530099201664, "currency": "USD"}, {"name": "Knee replacement", "alias": "knee-replacement", "price_to": 7763.238262046354, "price_from": 7011.957139912836, "currency": "USD"}], "diagnostic_prices": []}, {"illness": {"name": "Plastic Surgery", "alias": "plastic-surgery"}, "operation_prices": [{"name": "Breast lift", "alias": "mastopexy-breast-lift-contour-plastics", "price_to": 4257.259692089936, "price_from": 4006.832651378764, "currency": "USD"}, {"name": "Facelift", "alias": "tightening-of-facial-skin-facelift", "price_to": 5258.967854934627, "price_from": 3756.4056106675907, "currency": "USD"}, {"name": "Rhinoplasty (nose job)", "alias": "rhinoplasty-nose-job", "price_to": 3756.4056106675907, "price_from": 2504.2704071117273, "currency": "USD"}, {"name": "Liposuction", "alias": "liposuction", "price_to": 2879.910968178486, "price_from": 1252.1352035558637, "currency": "USD"}, {"name": "Tummy tuck", "alias": "abdominoplasty", "price_to": 5008.540814223455, "price_from": 3005.1244885340725, "currency": "USD"}], "diagnostic_prices": []}, {"illness": {"name": "Weight Loss Surgery", "alias": "weight-loss-surgery"}, "operation_prices": [{"name": "Gastric bypass", "alias": "roux-en-y-gastric-bypass", "price_to": 6511.103058490491, "price_from": 6260.6760177793185, "currency": "USD"}, {"name": "Gastric sleeve surgery (Sleeve gastrectomy)", "alias": "sleeve-resection", "price_to": 6260.6760177793185, "price_from": 5509.3948956458, "currency": "USD"}, {"name": "Gastric balloon", "alias": "gastric-balloon", "price_to": 2504.2704071117273, "price_from": 2253.8433664005547, "currency": "USD"}], "diagnostic_prices": []}, {"illness": {"name": "Rehabilitation", "alias": "rehabilitation"}, "operation_prices": [{"name": "Orthopedic rehabilitation (per 1 day)", "alias": "orthopedic-rehabilitation-per-1-day", "price_to": 200.34163256893817, "price_from": 100.17081628446908, "currency": "USD"}, {"name": "Orthopedic Rehabilitation", "alias": "orthopedic-rehabilitation", "price_to": 200.34163256893817, "price_from": 100.17081628446908, "currency": "USD"}], "diagnostic_prices": []}]"
leshaabr_postmeta	int(1217)	offers	string(8194) "[{"type": "procedure", "name": "Gynecomastia Surgery with top surgeon Dr. Lukasz Warchol ALL INCLUDED High European Standards", "for_who": " \n Included Services: 24-hour nurse services, consultation with a plastic surgeon, 3-star hotel, VIP transfer. \n Stay Info: 1-day hospital stay, 3-day hotel stay included in the price. \n ", "duration": "1", "post_operationCare": "", "other_services": "Premium Gynaecomastia treatment in Poland 2025 ALL INCLUSIVE PACKAGE High European Standards. This surgery is perfomed by top surgeon in Poland.", "procedure_description": "", "implant": "No implant applicable", "transport": "", "accommodation": "", "illnesses": [], "operations": [{"name": "Gynecomastia surgery", "alias": "gynecomastia-surgery"}], "diagnostics": [], "currency": "USD", "special_price": {"expires": "2025-05-14T22:00:00.000+00:00", "for_bookimed_only": true, "percent": 0, "price_usd": 2513, "starts": "2025-02-05T23:00:00.000+00:00"}, "package_price": 2879, "level": "basic", "main_diagnostic": null, "main_operation": {"name": "Gynecomastia surgery", "alias": "gynecomastia-surgery"}, "equipments": [], "services": [{"id": "24-hr-nurse-services", "type": "common", "name": "24-hr nurse services"}, {"id": "consultation-with-a-plastic-surgeron", "type": "medical", "name": "Consultation with a plastic surgeron"}, {"id": "3-hotel", "type": "accommodation", "name": "3* Hotel"}, {"id": "vip-transfer", "type": "transfer", "name": "VIP transfer (premium vehicle service, all transfers between airport, hotel and clinic)"}], "duration_hotel": 3, "calculated_price": {"from": 0, "to": 0}, "actual_price": 2513, "people_interested_count": 9}, {"type": "procedure", "name": "Premium Mommy Makeover - Breast Lift with Tummy Tuck ALL INCLUSIVE PACKAGE High European Standards", "for_who": " \n Method: Premium Mommy Makeover - Breast Lift with Tummy Tuck all-inclusive package \n Lukasz Warchol is renowned for his expertise in transformative procedures like breast augmentation and body sculpting. \n AllMedica Surgery in Poland serves 20,000 patients annually, attracting individuals from Europe, USA, and beyond. \n Included Services: 24-hour nurse services, post-operative care, hotel, video or text consultation, consultation with a doctor, general anesthesia, preoperative tests, blood tests, post-op medications, consultation with an anesthesiologist, chest X-ray, anti-HIV test, anti-HBC test, anti-HCVAb test, ultrasound, consultation with a surgeon, follow-up visit, consultation with a plastic surgeon, lymphatic massage, VIP transfer. \n Stay Info: 1-day hospital stay, 6-day hotel stay included in the price. \n ", "duration": "1", "post_operationCare": "", "other_services": "Premium Mommy Makeover - Breast Lift with Tummy Tuck ALL INCLUSIVE PREMIUM PACKAGE High European Standards", "procedure_description": "", "implant": "No implant applicable", "transport": "", "accommodation": "", "illnesses": [], "operations": [{"name": "Mommy makeover", "alias": "mommy-makeover"}], "diagnostics": [], "currency": "USD", "special_price": {"expires": "2025-05-14T00:00:00.000+00:00", "for_bookimed_only": true, "percent": 0, "price_usd": 7389, "starts": "2025-02-05T00:00:00.000+00:00"}, "package_price": 8013, "level": "basic", "main_diagnostic": null, "main_operation": {"name": "Mommy makeover", "alias": "mommy-makeover"}, "equipments": [], "services": [{"id": "24-hr-nurse-services", "type": "common", "name": "24-hr nurse services"}, {"id": "post-operative-care", "type": "medical", "name": "Post-operative care"}, {"id": "hotel", "type": "retreat_accommodation", "name": "Hotel"}, {"id": "video-or-text-consultation", "type": "medical", "name": "Video or text consultation"}, {"id": "consultation-with-a-doctor", "type": "medical", "name": "Consultation with a doctor"}, {"id": "general-anesthesia", "type": "medical", "name": "General anesthesia"}, {"id": "preoperative-tests", "type": "medical", "name": "Preoperative tests"}, {"id": "blood-tests", "type": "medical", "name": "Blood tests"}, {"id": "post-op-medications", "type": "medical", "name": "Post-op medications"}, {"id": "consultation-with-an-anesthesiologist", "type": "medical", "name": "Consultation with an anesthesiologist"}, {"id": "chest-x-ray", "type": "medical", "name": "Chest X-ray "}, {"id": "anti-hiv-test", "type": "medical", "name": "Anti-HIV test"}, {"id": "anti-hbc-test", "type": "medical", "name": "Anti-HBC test "}, {"id": "anti-hcvab-test", "type": "medical", "name": "Anti-HCVAb test"}, {"id": "ultrasound", "type": "medical", "name": "Ultrasound"}, {"id": "consultation-with-a-surgeon", "type": "medical", "name": "Consultation with a surgeon"}, {"id": "follow-up-visit", "type": "medical", "name": "Follow-up visit"}, {"id": "consultation-with-a-plastic-surgeron", "type": "medical", "name": "Consultation with a plastic surgeron"}, {"id": "lymphatic-massage", "type": "medical", "name": "Lymphatic massage"}, {"id": "3-hotel", "type": "accommodation", "name": "3* Hotel"}, {"id": "vip-transfer", "type": "transfer", "name": "VIP transfer (premium vehicle service, all transfers between airport, hotel and clinic)"}], "duration_hotel": 6, "calculated_price": {"from": 0, "to": 0}, "actual_price": 7389, "people_interested_count": 3}, {"type": "procedure", "name": "Standard Liposuction 3 body areas with No implant applicable All Included", "for_who": " \n Technique: Standard liposuction 3 body areas, no implant applicable \n Dr. Lukasz Warchol is renowned for his expertise in advanced body sculpting techniques like liposuction. \n AllMedica Surgery in Poland is chosen by 20,000 patients annually, including elite athletes and dancers. \n Included Services: 24-hr nurse services, medical examination, post-operative care, general anesthesia, preoperative tests, consultation, follow-up visit, 3* hotel, transfer. \n Stay Info: 1-day hospital stay and 3-day hotel stay included in the price. \n ", "duration": "1", "post_operationCare": "", "other_services": "360\u00b0 liposuction targets your waist area comprehensively, including the abdomen, love handles, and lower back", "procedure_description": "", "implant": "No implant applicable", "transport": "", "accommodation": "", "illnesses": [], "operations": [{"name": "Liposuction 3 body areas", "alias": "liposuction-2-3-body-areas"}], "diagnostics": [], "currency": "USD", "special_price": {"expires": "2025-06-29T22:00:00.000+00:00", "for_bookimed_only": true, "percent": 0, "price_usd": 4178, "starts": "2025-01-01T00:00:00.000+00:00"}, "package_price": 4257, "level": "standard", "main_diagnostic": null, "main_operation": {"name": "Liposuction 3 body areas", "alias": "liposuction-2-3-body-areas"}, "equipments": [], "services": [{"id": "24-hr-nurse-services", "type": "common", "name": "24-hr nurse services"}, {"id": "medical-examination-for-pre-operation", "type": "medical", "name": "Medical Examination for pre-operation"}, {"id": "post-operative-care", "type": "medical", "name": "Post-operative care"}, {"id": "relax", "type": "retreat", "name": "Relax"}, {"id": "general-anesthesia", "type": "medical", "name": "General anesthesia"}, {"id": "preoperative-tests", "type": "medical", "name": "Preoperative tests"}, {"id": "follow-up-examination", "type": "medical", "name": "Follow-up examination"}, {"id": "anti-hiv-test", "type": "medical", "name": "Anti-HIV test"}, {"id": "anti-hbc-test", "type": "medical", "name": "Anti-HBC test "}, {"id": "anti-hcvab-test", "type": "medical", "name": "Anti-HCVAb test"}, {"id": "consultation-with-a-surgeon", "type": "medical", "name": "Consultation with a surgeon"}, {"id": "follow-up-visit", "type": "medical", "name": "Follow-up visit"}, {"id": "3-hotel", "type": "accommodation", "name": "3* Hotel"}, {"id": "transfer-airport-hotel-clinic-airport", "type": "transfer", "name": "Transfer airport-hotel-clinic-airport"}], "duration_hotel": 3, "calculated_price": {"from": 0, "to": 0}, "actual_price": 4178, "people_interested_count": 5}]"

Хвороби клінік зберігаються як таксономії для фільтрування та для архівів (term) й окремо в leshaabr_postmeta просто в як обʼєкт (вище вивів).
Я так розумію, що у хвороби мають ділитися по ієрархії в залежності від напрямку. Відповідно при парсингу хвороб треба робити їх градацію відповідно до батьківського елемента. Наприклад, Orthopedics -> Rotator cuff repair surgery.

Таблиця	term_taxonomy_id	object_id
leshaabr_term_relationships	int(30)	int(1217)

Таблиця	term_id	Name
leshaabr_terms	int(30)	string() "Facelift"

https://www.dropbox.com/scl/fi/gccri3f6oeqvoi7tcgfl4/Screenshot-2025-03-04-at-11.19.16.png?rlkey=hy79byvsj4epk2n54pk8zxsgv&dl=0