Insurance for unexpected expenses in case of complications during treatment and 48 months after treatment Coverage up to 200,000 EUR
Clinic 51
| Таблиця | id | post_type | post_author | post_title | post_content |
|---|---|---|---|---|---|
| leshaabr_posts | int(9808) | string(6) "clinic" |
int(1)
сюди просто "1" ставте. |
string(9) "Clinic 51"
це колонка "name" в старому парсері. |
string(492) " Clinic 14 is based in Istanbul, Turkey. It provides medical services in dental treatment, plastic surgery, weight loss surgery, aesthetic medicine and cosmetology. It is the largest and one of the most famous Turkish private medical care groups. It has grown to 35 partner hospitals and clinics in 17 cities worldwide, employing more than 14,000 employees. The clinic, which has hosted many celebrities from Africa, UAE, the USA and Europe, has 100%-success for provided procedures. "це колонка "full_description" в старому парсері. |
| Таблиця | post_id | meta_key | meta_value |
|---|---|---|---|
| leshaabr_postmeta | int(9808) | clinic_id | string(4) "3594" |
| leshaabr_postmeta | int(9808) | original_url | string(43) "https://us-uk.bookimed.com/clinic/clinic-14" |
| leshaabr_postmeta | int(9808) | geo | string(174) "{"latitude": 41.0082376, "longitude": 28.9783589, "country": "Turkey", "city": "Istanbul", "address": "Alemdar, Yerebatan Cd. No:38, 34110 Fatih/\u0130stanbul, T\u00fcrkiye"}" |
| leshaabr_postmeta | int(9808) | statistics | string(142) "{"year_foundation": 2018, "doctors_number": 0, "patient_per_year": 0, "number_of_beds": 0, "number_of_departments": 0, "number_of_reviews": 0}" |
| leshaabr_postmeta | int(9808) | accreditations | string(2) "[]" |
| leshaabr_postmeta | int(9808) | licences | NULL |
| leshaabr_postmeta | int(9808) | illnesses | string(269) "[{"name": "Obesity", "alias": "obesity"}, {"name": "Gynaecomastia", "alias": "gynaecomastia"}, {"name": "Deviated septum", "alias": "deviated-septum"}, {"name": "Jaw cyst", "alias": "jaw-cyst"}, {"name": "Fibrocystic breast disease", "alias": "fibrocystic-mastopathy"}]" |
| leshaabr_postmeta | int(9808) | offers | string(2) "[]" |
Хвороби клінік зберігаються як таксономії для фільтрування та для архівів (term) й окремо в leshaabr_postmeta просто в як обʼєкт (вище вивів).
Я так розумію, що у хвороби мають ділитися по ієрархії в залежності від напрямку. Відповідно при парсингу хвороб треба робити їх градацію відповідно до батьківського елемента. Наприклад, Orthopedics -> Rotator cuff repair surgery.
| Таблиця | term_taxonomy_id | object_id |
|---|---|---|
| leshaabr_term_relationships | int(30) | int(9808) |
| Таблиця | 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