-- AI Car Laravel SQLite/MySQL import dump
-- Generated: 2026-05-21T12:37:07+02:00

DROP TABLE IF EXISTS `market_imports`;
CREATE TABLE `market_imports` (`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY not null, `source` VARCHAR(255) NOT NULL, `source_mode` VARCHAR(255), `imported_at` DATETIME, `coverage` TEXT, `totals` TEXT, `insights` TEXT, `created_at` DATETIME, `updated_at` DATETIME);

INSERT INTO `market_imports` (`id`, `source`, `source_mode`, `imported_at`, `coverage`, `totals`, `insights`, `created_at`, `updated_at`) VALUES ('1', 'https://www.kktcarabam.com', 'live', '2026-05-19 09:15:38', '{"requestedCategories":18,"requestedPagesPerCategory":4,"fetchedPages":17,"blockedPages":18,"liveListings":306,"indexedSnapshotListings":40,"note":"Live public pages were fetched without bypassing access controls."}', '{"usedVehicles":18821,"newVehicles":107,"parts":30767,"corporateCompanies":455}', '{"categories":{"suv":16,"used_automobile":17,"new_vehicle":6,"parts":10,"new_suv":1},"currencies":{"GBP":29,"TL":12,"EUR":3,"USD":1,"CALL":5},"brands":{"Nissan":4,"BMW":2,"Toyota":5,"Mercedes-Benz":7,"Land Rover":4,"Unknown":8,"Hyundai":3,"Mitsubishi":2,"Mazda":4,"Honda":4,"Mini Cooper":1,"Suzuki":2,"Jeep":2,"Ford":2},"averageVisiblePrice":35244,"hiddenPriceCount":17,"highRiskCount":1}', '2026-05-21 10:36:23', '2026-05-21 10:36:23');

DROP TABLE IF EXISTS `vehicle_categories`;
CREATE TABLE `vehicle_categories` (`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY not null, `external_id` VARCHAR(255) NOT NULL, `parent_external_id` VARCHAR(255), `name` VARCHAR(255) NOT NULL, `source_url` VARCHAR(255), `source_count` integer, `icon` VARCHAR(255), `featured` TINYINT(1) NOT NULL default '0', `visible` TINYINT(1) NOT NULL default '1', `sort_order` BIGINT NOT NULL default '0', `seo_title` VARCHAR(255), `seo_description` TEXT, `created_at` DATETIME, `updated_at` DATETIME);

INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('1', 'used_vehicle', NULL, '2. El Araçlar', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '18821', 'Car', '1', '1', '1', '2. El Araçlar | AI Car Marketplace', '2. El Araçlar inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('2', 'used_automobile', 'used_vehicle', 'Otomobil', 'https://www.kktcarabam.com/kategori/satilik-otomobil', NULL, 'CarFront', '1', '1', '2', 'Otomobil | AI Car Marketplace', 'Otomobil inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('3', 'suv', 'used_vehicle', 'Arazi, SUV, Pick-up', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '5992', 'Gauge', '1', '1', '3', 'Arazi, SUV, Pick-up | AI Car Marketplace', 'Arazi, SUV, Pick-up inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('4', 'motorcycle', 'used_vehicle', 'Motosiklet', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-motosiklet', NULL, 'Bike', '0', '1', '4', 'Motosiklet | AI Car Marketplace', 'Motosiklet inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('5', 'minivan_panelvan', 'used_vehicle', 'Minivan & Panelvan', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-minivan-panelvan', NULL, 'Bus', '0', '1', '5', 'Minivan & Panelvan | AI Car Marketplace', 'Minivan & Panelvan inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('6', 'commercial', 'used_vehicle', 'Ticari Araçlar', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-ticari-araclar', NULL, 'Truck', '0', '1', '6', 'Ticari Araçlar | AI Car Marketplace', 'Ticari Araçlar inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('7', 'heavy_equipment', 'used_vehicle', 'İş Makineleri', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-is-makineleri', NULL, 'Construction', '0', '1', '7', 'İş Makineleri | AI Car Marketplace', 'İş Makineleri inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('8', 'atv_utv', 'used_vehicle', 'Atv & Utv', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-atv-utv', NULL, 'Waves', '0', '1', '8', 'Atv & Utv | AI Car Marketplace', 'Atv & Utv inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('9', 'caravan', 'used_vehicle', 'Karavan', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-karavan', NULL, 'Home', '0', '1', '9', 'Karavan | AI Car Marketplace', 'Karavan inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('10', 'classic', 'used_vehicle', 'Klasik Araçlar', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-klasik-araclar', NULL, 'BadgeCheck', '0', '1', '10', 'Klasik Araçlar | AI Car Marketplace', 'Klasik Araçlar inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('11', 'marine', 'used_vehicle', 'Deniz Araçları', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-deniz-araclari', NULL, 'Ship', '0', '1', '11', 'Deniz Araçları | AI Car Marketplace', 'Deniz Araçları inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('12', 'new_vehicle', NULL, '0 Km Araçlar', 'https://www.kktcarabam.com/kategori/sifir-kilometre-araclar', '107', 'Sparkles', '1', '1', '12', '0 Km Araçlar | AI Car Marketplace', '0 Km Araçlar inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('13', 'new_automobile', 'new_vehicle', '0 Km Otomobil', 'https://www.kktcarabam.com/kategori/sifir-kilometre-araclar-otomobil', NULL, 'Car', '0', '1', '13', '0 Km Otomobil | AI Car Marketplace', '0 Km Otomobil inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('14', 'new_suv', 'new_vehicle', '0 Km Arazi, SUV, Pick-Up', 'https://www.kktcarabam.com/kategori/sifir-kilometre-araclar-arazi-suv-pick-up', NULL, 'Gauge', '1', '1', '14', '0 Km Arazi, SUV, Pick-Up | AI Car Marketplace', '0 Km Arazi, SUV, Pick-Up inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('15', 'parts', NULL, 'Yedek Parça & Aksesuar', 'https://www.kktcarabam.com/kategori/otomotiv-yedek-parca', '30767', 'Wrench', '1', '1', '15', 'Yedek Parça & Aksesuar | AI Car Marketplace', 'Yedek Parça & Aksesuar inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('16', 'parts_auto', 'parts', 'Otomobil Yedek Parça', 'https://www.kktcarabam.com/kategori/otomobil-yedek-parca', NULL, 'Wrench', '0', '1', '16', 'Otomobil Yedek Parça | AI Car Marketplace', 'Otomobil Yedek Parça inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('17', 'parts_motorcycle', 'parts', 'Motosiklet Yedek Parça', 'https://www.kktcarabam.com/kategori/motosiklet-yedek-parca', NULL, 'Wrench', '0', '1', '17', 'Motosiklet Yedek Parça | AI Car Marketplace', 'Motosiklet Yedek Parça inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicle_categories` (`id`, `external_id`, `parent_external_id`, `name`, `source_url`, `source_count`, `icon`, `featured`, `visible`, `sort_order`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES ('18', 'parts_commercial', 'parts', 'Ticari Araç Yedek Parça', 'https://www.kktcarabam.com/kategori/ticari-arac-yedek-parca', NULL, 'Wrench', '0', '1', '18', 'Ticari Araç Yedek Parça | AI Car Marketplace', 'Ticari Araç Yedek Parça inventory imported from public competitor structure and upgraded with AI price, trust and fraud intelligence.', '2026-05-21 10:36:23', '2026-05-21 10:36:23');

DROP TABLE IF EXISTS `vehicles`;
CREATE TABLE `vehicles` (`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY not null, `external_id` VARCHAR(255) NOT NULL, `source` VARCHAR(255), `source_url` VARCHAR(255), `title` VARCHAR(255) NOT NULL, `brand` VARCHAR(255) NOT NULL, `model` VARCHAR(255), `year` integer, `price` numeric not null default '0', `currency` VARCHAR(255) NOT NULL default 'USD', `market_value` numeric not null default '0', `category_external_id` VARCHAR(255), `transmission` VARCHAR(255), `fuel_type` VARCHAR(255), `location` VARCHAR(255), `seller` VARCHAR(255), `seo_slug` VARCHAR(255), `price_battery` BIGINT NOT NULL default '0', `ai_confidence` BIGINT NOT NULL default '0', `trust_score` BIGINT NOT NULL default '0', `fraud_probability` numeric not null default '0', `risk_level` VARCHAR(255) NOT NULL default 'low', `price_explanation` TEXT, `homepage_visible` TINYINT(1) NOT NULL default '1', `featured` TINYINT(1) NOT NULL default '0', `status` VARCHAR(255) NOT NULL default 'imported', `imported_at` DATETIME, `created_at` DATETIME, `updated_at` DATETIME);

INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('1', 'KKT-00001-https-www-kktcarabam-com-234459-nissan-navara-gmagusa-di', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/234459-nissan-navara-gmagusa-dizel-otomatik', 'Nissan Navara 2020 Model Otomatik Nissan Navara 24.500 GBP', 'Nissan', 'Navara Navara', '2020', '24500', 'GBP', '22281', 'suv', 'Automatic', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'nissan-navara-2020-model-otomatik-nissan-navara-24-500-gbp', '47', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('2', 'KKT-00002-https-www-kktcarabam-com-234458-nissan-silvia-gmagusa-be', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/234458-nissan-silvia-gmagusa-benzin-duz', 'Nissan Silvia 1996 Model Düz Nissan Silvia 0 TL', 'Nissan', 'Silvia Silvia', '1996', '0', 'TL', '0', 'used_automobile', 'Manual', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'nissan-silvia-1996-model-duz-nissan-silvia-0-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('3', 'KKT-00003-https-www-kktcarabam-com-239713-bmw-5-serisi-gmagusa-diz', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239713-bmw-5-serisi-gmagusa-dizel-otomatik', 'BMW 5 Serisi 2021 Model Otomatik BMW 5 Serisi 35.500 GBP', 'BMW', '5 Serisi 5 Serisi', '2021', '35500', 'GBP', '35319', 'used_automobile', 'Automatic', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'bmw-5-serisi-2021-model-otomatik-bmw-5-serisi-35-500-gbp', '61', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('4', 'KKT-00004-https-www-kktcarabam-com-239711-toyota-corollalefkosa-be', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239711-toyota-corollalefkosa-benzin-otomatik', 'Toyota Corolla 2024 Model Otomatik Toyota Corolla 29.000 GBP', 'Toyota', 'Corolla Corolla', '2024', '29000', 'GBP', '27738', 'used_automobile', 'Automatic', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'toyota-corolla-2024-model-otomatik-toyota-corolla-29-000-gbp', '55', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('5', 'KKT-00005-https-www-kktcarabam-com-239710-mercedes-benz-c-serisi-g', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239710-mercedes-benz-c-serisi-gmagusa-dizel-otomatik', 'Mercedes-Benz C Serisi 2016 Model Otomatik Mercedes-Benz C Serisi 22.000 GBP', 'Mercedes-Benz', 'C Serisi C Serisi', '2016', '22000', 'GBP', '20491', 'used_automobile', 'Automatic', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'mercedes-benz-c-serisi-2016-model-otomatik-mercedes-benz-c-serisi-22-000-gbp', '51', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('6', 'KKT-00006-https-www-kktcarabam-com-239709-mercedes-benz-cla-lefkos', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239709-mercedes-benz-cla-lefkosa-dizel-otomatik', 'Mercedes-Benz CLA 2021 Model Otomatik Mercedes-Benz CLA 0 TL', 'Mercedes-Benz', 'CLA CLA', '2021', '0', 'TL', '0', 'used_automobile', 'Automatic', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'mercedes-benz-cla-2021-model-otomatik-mercedes-benz-cla-0-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('7', 'KKT-00007-https-www-kktcarabam-com-237498-sifir-km-land-rover-rang', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/237498-sifir-km-land-rover-range-rover-velar-lefkosa', 'Land Rover Range Rover Velar Sıfır Km Land Rover Range Rover Velar 92.000 EUR', 'Land Rover', 'Range Rover Velar Range Rover', '2026', '92000', 'EUR', '103334', 'new_vehicle', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'land-rover-range-rover-velar-s-f-r-km-land-rover-range-rover-velar-92-000-eur', '87', '84', '86', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '1', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('8', 'KKT-00008-https-www-kktcarabam-com-173619-sifir-km-lefkosa-benzin-', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/173619-sifir-km-lefkosa-benzin-otomatik', 'Sıfır Km Otomatik 3.500 USD', 'Unknown', 'Unknown', '2026', '3500', 'USD', '3640', 'new_vehicle', 'Automatic', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 's-f-r-km-otomatik-3-500-usd', '76', '84', '86', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '1', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('9', 'KKT-00009-https-www-kktcarabam-com-174114-sifir-km-mercedes-benz-a', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/174114-sifir-km-mercedes-benz-a-serisi-lefkosa', 'Mercedes-Benz A Serisi Sıfır Km Mercedes-Benz A Serisi 44.500 GBP', 'Mercedes-Benz', 'A Serisi A Serisi', '2026', '44500', 'GBP', '49982', 'new_vehicle', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'mercedes-benz-a-serisi-s-f-r-km-mercedes-benz-a-serisi-44-500-gbp', '87', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '1', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('10', 'KKT-00010-https-www-kktcarabam-com-174113-sifir-km-mercedes-benz-a', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/174113-sifir-km-mercedes-benz-a-serisi-lefkosa', 'Mercedes-Benz A Serisi Sıfır Km Mercedes-Benz A Serisi 39.000 GBP', 'Mercedes-Benz', 'A Serisi A Serisi', '2026', '39000', 'GBP', '43805', 'new_vehicle', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'mercedes-benz-a-serisi-s-f-r-km-mercedes-benz-a-serisi-39-000-gbp', '87', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '1', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('11', 'KKT-00011-https-www-kktcarabam-com-235123-sifir-km-land-rover-rang', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/235123-sifir-km-land-rover-range-rover-sport-lefkosa', 'Land Rover Range Rover Sport Sıfır Km Land Rover Range Rover Sport 235.000 EUR', 'Land Rover', 'Range Rover Sport Range Rover', '2026', '235000', 'EUR', '263952', 'new_vehicle', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'land-rover-range-rover-sport-s-f-r-km-land-rover-range-rover-sport-235-000-eur', '87', '84', '86', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '1', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('12', 'KKT-00012-https-www-kktcarabam-com-235100-sifir-km-land-rover-rang', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/235100-sifir-km-land-rover-range-rover-lefkosa', 'Land Rover Range Rover Sıfır Km Land Rover Range Rover 299.000 EUR', 'Land Rover', 'Range Rover Range Rover', '2026', '299000', 'EUR', '335837', 'new_vehicle', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'land-rover-range-rover-s-f-r-km-land-rover-range-rover-299-000-eur', '87', '84', '86', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '1', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('13', 'KKT-00013-https-www-kktcarabam-com-239652-hyundai-i20-direksiyon-s', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239652-hyundai-i20-direksiyon-sargisiairbag-zemberegi', 'Yedek Parça Elektrik Hyundai i20 direksiyon sargısı(airbag zembereği) 2.000 TL', 'Hyundai', 'Elektrik i20 direksiyon sargısı airbag', '2026', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'yedek-parca-elektrik-hyundai-i20-direksiyon-sarg-s-airbag-zemberegi-2-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('14', 'KKT-00014-https-www-kktcarabam-com-239593-2025model-y-juniper-icin', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239593-2025model-y-juniper-icin-spor-spoiler-mat-karbon-boya', 'Aksesuar Dış Aksesuar 2025+ MODEL Y (JUNIPER) IÇIN SPOR SPOILER - MAT KARBON BOYA 5.000 TL', 'Unknown', 'Dış Y JUNIPER IÇIN SPOR', '2025', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'aksesuar-d-s-aksesuar-2025-model-y-juniper-icin-spor-spoiler-mat-karbon-boya-5-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('15', 'KKT-00015-https-www-kktcarabam-com-239589-octavia-2013-2019-icin-u', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239589-octavia-2013-2019-icin-uyumlu-cam-citasi-nikelaj', 'Aksesuar Dış Aksesuar OCTAVIA 2013-2019 IÇIN UYUMLU CAM ÇITASI NIKELAJ 2.000 TL', 'Unknown', 'Dış OCTAVIA - IÇIN UYUMLU', '2013', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'aksesuar-d-s-aksesuar-octavia-2013-2019-icin-uyumlu-cam-citasi-nikelaj-2-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('16', 'KKT-00016-https-www-kktcarabam-com-239527-16-inc-2-aylik-jant-last', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239527-16-inc-2-aylik-jant-lastik', 'Jant&Lastik Aksesuar 16 inç 2 aylık jant lastik 20.000 TL', 'Unknown', 'Jant Lastik 16 inç 2', '2026', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'jant-lastik-aksesuar-16-inc-2-ayl-k-jant-lastik-20-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('17', 'KKT-00017-https-www-kktcarabam-com-239533-qashqai-2014-2020-icin-u', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239533-qashqai-2014-2020-icin-uyumlu-kapi-kolu-kaplama-piano-blacksmart-key', 'Aksesuar Dış Aksesuar QASHQAI 2014-2020 IÇIN UYUMLU KAPI KOLU KAPLAMA - PIANO BLACK ( SMART KEY ) 1.000 TL', 'Unknown', 'Dış QASHQAI - IÇIN UYUMLU', '2014', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'aksesuar-d-s-aksesuar-qashqai-2014-2020-icin-uyumlu-kapi-kolu-kaplama-piano-black-smart-ke', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('18', 'KKT-00018-https-www-kktcarabam-com-239532-qashqai-icin-uyumlu-baga', 'kktcarabam.com live public category import', 'https://www.kktcarabam.com/239532-qashqai-icin-uyumlu-bagaj-alt-citasi', 'Aksesuar Dış Aksesuar QASHQAI IÇIN UYUMLU BAGAJ ALT CITASI 300 TL', 'Unknown', 'Dış QASHQAI IÇIN UYUMLU BAGAJ', '2026', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'aksesuar-d-s-aksesuar-qashqai-icin-uyumlu-bagaj-alt-citasi-300-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('19', 'KKT-00307--kategori-ikinci-el-araclar-2015-model-d-z-mitsubishi-l-', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2015 Model Düz Mitsubishi L 200 Arazi, SUV, Pick-up / Mitsubishi / L 200 / 4x4 G.Mağusa 15.000 GBP Premium Sahibinden Satılık 2015 Düz Silver 164153 G.Mağusa', 'Mitsubishi', 'L 200', '2015', '15000', 'GBP', '12760', 'suv', 'Manual', 'Unknown', 'G.Mağusa', 'Competitor marketplace import', '2015-model-duz-mitsubishi-l-200-arazi-suv-pick-up-mitsubishi-l-200-4x4-g-magusa-15-000-gbp', '35', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('20', 'KKT-00308--kategori-ikinci-el-araclar-2024-model-otomatik-toyota-r', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2024 Model Otomatik Toyota RAV4 Arazi, SUV, Pick-up / Toyota / RAV4 / 2.0 Lefkoşa 34.000 GBP Premium SSY MOTORS 2024 Otomatik Siyah 25000 Lefkoşa', 'Toyota', 'RAV4', '2024', '34000', 'GBP', '32520', 'suv', 'Automatic', 'Unknown', 'Lefkoşa', 'SSY MOTORS', '2024-model-otomatik-toyota-rav4-arazi-suv-pick-up-toyota-rav4-2-0-lefkosa-34-000-gbp-premi', '55', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('21', 'KKT-00309--kategori-ikinci-el-araclar-2017-model-otomatik-mercedes', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2017 Model Otomatik Mercedes-Benz C Serisi Otomobil / Mercedes-Benz / C Serisi / C 250 D Lefkoşa 24.500 GBP MFC MOTORS 2017 Otomatik Bordo Lefkoşa', 'Mercedes-Benz', 'C Serisi', '2017', '24500', 'GBP', '23130', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'MFC MOTORS', '2017-model-otomatik-mercedes-benz-c-serisi-otomobil-mercedes-benz-c-serisi-c-250-d-lefkosa', '53', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('22', 'KKT-00310--kategori-ikinci-el-araclar-2018-model-otomatik-mazda-de', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2018 Model Otomatik Mazda Demio Otomobil / Mazda / Demio / 1.3i Lefkoşa Fiyat İçin Arayınız Arsi Motors 2 2018 Otomatik Bordo Lefkoşa', 'Mazda', 'Demio', '2018', '0', 'CALL', '0', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'Arsi Motors', '2018-model-otomatik-mazda-demio-otomobil-mazda-demio-1-3i-lefkosa-fiyat-icin-aray-n-z-arsi', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('23', 'KKT-00311--kategori-ikinci-el-araclar-2013-model-otomatik-mitsubis', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2013 Model Otomatik Mitsubishi Mirage Otomobil / Mitsubishi / Mirage / 1.0 Mivec Cvt Lefkoşa 5.300 GBP Sahibinden Satılık 2013 Otomatik Beyaz 104000 Lefkoşa', 'Mitsubishi', 'Mirage', '2013', '5300', 'GBP', '4384', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'Competitor marketplace import', '2013-model-otomatik-mitsubishi-mirage-otomobil-mitsubishi-mirage-1-0-mivec-cvt-lefkosa-5-3', '30', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('24', 'KKT-00312--kategori-ikinci-el-araclar-2014-model-otomatik-toyota-v', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2014 Model Otomatik Toyota Vitz Otomobil / Toyota / Vitz / 1.3 Lefkoşa 7.250 GBP Sahibinden Satılık 2014 Otomatik Gri-Met 138000 Lefkoşa', 'Toyota', 'Vitz', '2014', '7250', 'GBP', '6082', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'Competitor marketplace import', '2014-model-otomatik-toyota-vitz-otomobil-toyota-vitz-1-3-lefkosa-7-250-gbp-sahibinden-sat-', '32', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('25', 'KKT-00313--kategori-ikinci-el-araclar-2008-model-otomatik-mercedes', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2008 Model Otomatik Mercedes-Benz C Serisi Mercedes-Benz / C Serisi / C 220 CDI Lefkoşa 9.900 GBP STAR AUTO GALERİ 2008 Otomatik Siyah 1 Lefkoşa', 'Mercedes-Benz', 'C Serisi C 220 CDI', '2008', '9900', 'GBP', '8592', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'STAR AUTO GALERİ', '2008-model-otomatik-mercedes-benz-c-serisi-mercedes-benz-c-serisi-c-220-cdi-lefkosa-9-900-', '38', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('26', 'KKT-00314--kategori-ikinci-el-araclar-2016-model-otomatik-honda-fi', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2016 Model Otomatik Honda Fit Honda / Fit / 1.3 Automatic Lefkoşa 9.500 GBP STAR AUTO GALERİ 2016 Otomatik Yeşil-Metalik 72000 Lefkoşa', 'Honda', 'Fit 1 3 Automatic Lefkoşa', '2016', '9500', 'GBP', '8193', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'STAR AUTO GALERİ', '2016-model-otomatik-honda-fit-honda-fit-1-3-automatic-lefkosa-9-500-gbp-star-auto-galeri-2', '37', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('27', 'KKT-00315--kategori-ikinci-el-araclar-2008-model-otomatik-mini-coo', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2008 Model Otomatik MINI Cooper Otomobil / MINI / Cooper / 1.5 Lefkoşa 4.750 GBP STAR AUTO GALERİ 2008 Otomatik Mavi-Parlement 1 Lefkoşa', 'Mini Cooper', 'MINI Cooper', '2008', '4750', 'GBP', '3817', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'STAR AUTO GALERİ', '2008-model-otomatik-mini-cooper-otomobil-mini-cooper-1-5-lefkosa-4-750-gbp-star-auto-galer', '24', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('28', 'KKT-00316--kategori-ikinci-el-araclar-2011-model-otomatik-mercedes', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2011 Model Otomatik Mercedes-Benz E Serisi Mercedes-Benz / E Serisi / E 220 CDI Lefkoşa 16 GBP STAR AUTO GALERİ 2011 Otomatik Silver Lefkoşa', 'Mercedes-Benz', 'E Serisi E 220 CDI', '2011', '16', 'GBP', '14', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'STAR AUTO GALERİ', '2011-model-otomatik-mercedes-benz-e-serisi-mercedes-benz-e-serisi-e-220-cdi-lefkosa-16-gbp', '40', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('29', 'KKT-00317--kategori-ikinci-el-araclar-2009-model-otomatik-suzuki-s', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2009 Model Otomatik Suzuki Splash Suzuki / Splash / 1.2 GA Lefkoşa 5.000 GBP Bilgin Auto 2009 Otomatik Beyaz 183000 Lefkoşa', 'Suzuki', 'Splash 1 2 GA Lefkoşa', '2009', '5000', 'GBP', '4018', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'Bilgin Auto', '2009-model-otomatik-suzuki-splash-suzuki-splash-1-2-ga-lefkosa-5-000-gbp-bilgin-auto-2009-', '24', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('30', 'KKT-00318--kategori-ikinci-el-araclar-2024-model-otomatik-bmw-x2-a', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2024 Model Otomatik BMW X2 Arazi, SUV, Pick-up / BMW / X2 / 2.0 S Drive Girne 39.900 GBP Girne Oto Galeri 2024 Otomatik Siyah 7000 Girne', 'BMW', 'X2', '2024', '39900', 'GBP', '41217', 'suv', 'Automatic', 'Unknown', 'Girne', 'Girne Oto Galeri', '2024-model-otomatik-bmw-x2-arazi-suv-pick-up-bmw-x2-2-0-s-drive-girne-39-900-gbp-girne-oto', '67', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('31', 'KKT-00319--kategori-ikinci-el-araclar-2011-model-otomatik-hyundai-', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2011 Model Otomatik Hyundai i10 Otomobil / Hyundai / i10 / 1.1 Lefkoşa 4.500 GBP Bilgin Auto 2011 Otomatik Çelik Grisi 81000 Lefkoşa', 'Hyundai', 'i10', '2011', '4500', 'GBP', '3616', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'Bilgin Auto', '2011-model-otomatik-hyundai-i10-otomobil-hyundai-i10-1-1-lefkosa-4-500-gbp-bilgin-auto-201', '24', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('32', 'KKT-00320--kategori-ikinci-el-araclar-2013-model-otomatik-nissan-n', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2013 Model Otomatik Nissan Note Otomobil / Nissan / Note / 1.2 Lefkoşa 6.500 GBP Bilgin Auto 2013 Otomatik Füme 87000 Lefkoşa', 'Nissan', 'Note', '2013', '6500', 'GBP', '5376', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'Bilgin Auto', '2013-model-otomatik-nissan-note-otomobil-nissan-note-1-2-lefkosa-6-500-gbp-bilgin-auto-201', '30', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('33', 'KKT-00321--kategori-ikinci-el-araclar-2010-model-otomatik-mazda-de', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar', '2010 Model Otomatik Mazda Demio Otomobil / Mazda / Demio / 1.3i Lefkoşa 5.000 GBP Bilgin Auto 2010 Otomatik Beyaz 161000 Lefkoşa', 'Mazda', 'Demio', '2010', '5000', 'GBP', '4018', 'used_automobile', 'Automatic', 'Unknown', 'Lefkoşa', 'Bilgin Auto', '2010-model-otomatik-mazda-demio-otomobil-mazda-demio-1-3i-lefkosa-5-000-gbp-bilgin-auto-20', '24', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('34', 'KKT-00322--kategori-ikinci-el-araclar-arazi-suv-pick-up-2023-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2023 Model Otomatik Jeep Gladiator Arazi, SUV, Pick-up / Jeep / Gladiator Girne Fiyat İçin Arayınız', 'Jeep', 'Gladiator Girne Fiyat İçin Arayınız', '2023', '0', 'CALL', '0', 'suv', 'Automatic', 'Unknown', 'Girne', 'Competitor marketplace import', '2023-model-otomatik-jeep-gladiator-arazi-suv-pick-up-jeep-gladiator-girne-fiyat-icin-aray-', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('35', 'KKT-00323--kategori-ikinci-el-araclar-arazi-suv-pick-up-2023-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2023 Model Otomatik Mazda CX-5 Arazi, SUV, Pick-up / Mazda / CX-5 Lefkoşa 27.800 GBP', 'Mazda', 'CX-5 Lefkoşa', '2023', '27800', 'GBP', '26263', 'suv', 'Automatic', 'Unknown', 'Lefkoşa', 'Competitor marketplace import', '2023-model-otomatik-mazda-cx-5-arazi-suv-pick-up-mazda-cx-5-lefkosa-27-800-gbp', '53', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('36', 'KKT-00324--kategori-ikinci-el-araclar-arazi-suv-pick-up-2020-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2020 Model Otomatik Ford Ranger Ford / Ranger / 2.0 EcoBlue Girne Fiyat İçin Arayınız', 'Ford', 'Ranger 2 0 EcoBlue Girne', '2020', '0', 'CALL', '0', 'suv', 'Automatic', 'Unknown', 'Girne', 'Competitor marketplace import', '2020-model-otomatik-ford-ranger-ford-ranger-2-0-ecoblue-girne-fiyat-icin-aray-n-z', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('37', 'KKT-00325--kategori-ikinci-el-araclar-arazi-suv-pick-up-2014-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2014 Model Otomatik Ford Kuga Ford / Kuga / 1.5 EcoBlue G.Mağusa 11.500 GBP', 'Ford', 'Kuga 1 5 EcoBlue G', '2014', '11500', 'GBP', '9647', 'suv', 'Automatic', 'Unknown', 'G.Mağusa', 'Competitor marketplace import', '2014-model-otomatik-ford-kuga-ford-kuga-1-5-ecoblue-g-magusa-11-500-gbp', '32', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('38', 'KKT-00326--kategori-ikinci-el-araclar-arazi-suv-pick-up-2018-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2018 Model Otomatik Jeep Renegade Arazi, SUV, Pick-up / Jeep / Renegade G.Mağusa 15.900 GBP', 'Jeep', 'Renegade G Mağusa', '2018', '15900', 'GBP', '14086', 'suv', 'Automatic', 'Unknown', 'G.Mağusa', 'Competitor marketplace import', '2018-model-otomatik-jeep-renegade-arazi-suv-pick-up-jeep-renegade-g-magusa-15-900-gbp', '42', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('39', 'KKT-00327--kategori-ikinci-el-araclar-arazi-suv-pick-up-2021-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2021 Model Otomatik Honda Vezel Honda / Vezel / 1.5 i-VTEC Hybrid Automatic Girne 23.000 GBP', 'Honda', 'Vezel 1 5 i-VTEC Hybrid', '2021', '23000', 'GBP', '21188', 'suv', 'Automatic', 'Hybrid / Electric', 'Girne', 'Competitor marketplace import', '2021-model-otomatik-honda-vezel-honda-vezel-1-5-i-vtec-hybrid-automatic-girne-23-000-gbp', '49', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('40', 'KKT-00328--kategori-ikinci-el-araclar-arazi-suv-pick-up-2005-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2005 Model Düz Honda HR-V Arazi, SUV, Pick-up / Honda / HR-V G.Mağusa 5.250 GBP', 'Honda', 'HR-V G Mağusa', '2005', '5250', 'GBP', '4219', 'suv', 'Manual', 'Unknown', 'G.Mağusa', 'Competitor marketplace import', '2005-model-duz-honda-hr-v-arazi-suv-pick-up-honda-hr-v-g-magusa-5-250-gbp', '24', '82', '85', '0.16', 'low', 'AI detects above-market pricing; seller should justify mileage, condition or rare specification.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('41', 'KKT-00329--kategori-ikinci-el-araclar-arazi-suv-pick-up-2020-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2020 Model Otomatik Honda Vezel Honda / Vezel / 1.5 i-VTEC CVT Girne 21.500 GBP', 'Honda', 'Vezel 1 5 i-VTEC CVT', '2020', '21500', 'GBP', '19553', 'suv', 'Automatic', 'Unknown', 'Girne', 'Competitor marketplace import', '2020-model-otomatik-honda-vezel-honda-vezel-1-5-i-vtec-cvt-girne-21-500-gbp', '47', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('42', 'KKT-00330--kategori-ikinci-el-araclar-arazi-suv-pick-up-2021-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2021 Model Otomatik Toyota Yaris Cross Arazi, SUV, Pick-up / Toyota / Yaris Cross G.Mağusa Fiyat İçin Arayınız', 'Toyota', 'Yaris Cross G Mağusa Fiyat', '2021', '0', 'CALL', '0', 'suv', 'Automatic', 'Unknown', 'G.Mağusa', 'Competitor marketplace import', '2021-model-otomatik-toyota-yaris-cross-arazi-suv-pick-up-toyota-yaris-cross-g-magusa-fiyat', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('43', 'KKT-00331--kategori-ikinci-el-araclar-arazi-suv-pick-up-2023-model', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/ikinci-el-araclar-arazi-suv-pick-up', '2023 Model Otomatik Mazda CX-60 Mazda / CX-60 / 3.3 Hybrid G.Mağusa 1 GBP', 'Mazda', 'CX-60 3 3 Hybrid G', '2023', '1', 'GBP', '1', 'suv', 'Automatic', 'Hybrid / Electric', 'G.Mağusa', 'Competitor marketplace import', '2023-model-otomatik-mazda-cx-60-mazda-cx-60-3-3-hybrid-g-magusa-1-gbp', '62', '76', '57', '0.78', 'high', 'AI flags this as unusually cheap versus estimated market value; verify VIN, mileage, photos and seller identity.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('44', 'KKT-00332--uye-autopia-motors-2021-model-otomatik-toyota-rav4-araz', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/uye/autopia-motors', '2021 Model Otomatik Toyota RAV4 Arazi, SUV, Pick-up / Toyota / RAV4 / 2.5 Hybrid G.Mağusa 33.500 GBP Autopia Motors', 'Toyota', 'RAV4', '2021', '33500', 'GBP', '30860', 'suv', 'Automatic', 'Hybrid / Electric', 'G.Mağusa', 'Autopia Motors', '2021-model-otomatik-toyota-rav4-arazi-suv-pick-up-toyota-rav4-2-5-hybrid-g-magusa-33-500-g', '49', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('45', 'KKT-00333--uye-carhouse-2024-model-otomatik-land-rover-defender-ar', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/uye/carhouse', '2024 Model Otomatik Land Rover Defender Arazi, SUV, Pick-up / Land Rover / Defender / 110 3.0 TDI Girne Fiyat İçin Arayınız CARHOUSE', 'Land Rover', 'Defender', '2024', '0', 'CALL', '0', 'suv', 'Automatic', 'Unknown', 'Girne', 'CARHOUSE', '2024-model-otomatik-land-rover-defender-arazi-suv-pick-up-land-rover-defender-110-3-0-tdi-', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('46', 'KKT-00340--kategori-sifir-kilometre-araclar-arazi-suv-pick-up-suzu', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/sifir-kilometre-araclar-arazi-suv-pick-up-suzuki', 'Sıfır Km Suzuki Jimny Arazi, SUV, Pick-Up / Suzuki / Jimny / Sierra İskele 29.500 GBP', 'Suzuki', 'Jimny', '2026', '29500', 'GBP', '30680', 'new_suv', 'Unknown', 'Unknown', 'İskele', 'Competitor marketplace import', 's-f-r-km-suzuki-jimny-arazi-suv-pick-up-suzuki-jimny-sierra-iskele-29-500-gbp', '76', '84', '90', '0.04', 'low', 'AI estimated price is within a fair market range for this brand, year and category.', '1', '1', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('47', 'KKT-00341--kategori-otomotiv-yedek-parca-yedek-par-a-elektrik-hyun', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/otomotiv-yedek-parca', 'Yedek Parça Elektrik Hyundai i20 direksiyon sargısı airbag zembereği 2.000 TL', 'Hyundai', 'Elektrik i20 direksiyon sargısı airbag', '2026', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'yedek-parca-elektrik-hyundai-i20-direksiyon-sarg-s-airbag-zemberegi-2-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('48', 'KKT-00342--kategori-otomotiv-yedek-parca-aksesuar-d-aksesuar-2025-', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/otomotiv-yedek-parca', 'Aksesuar Dış Aksesuar 2025+ MODEL Y JUNIPER IÇIN SPOR SPOILER MAT KARBON BOYA 5.000 TL', 'Unknown', 'Dış Y JUNIPER IÇIN SPOR', '2025', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'aksesuar-d-s-aksesuar-2025-model-y-juniper-icin-spor-spoiler-mat-karbon-boya-5-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('49', 'KKT-00345--kategori-otomotiv-yedek-parca-aksesuar-d-aksesuar-nissa', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/otomotiv-yedek-parca', 'Aksesuar Dış Aksesuar Nissan Navara 2016 sonrası Siyah Shark Ön Koruma AQM PST24 10.000 TL', 'Nissan', 'Dış Navara sonrası Siyah Shark', '2016', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'aksesuar-d-s-aksesuar-nissan-navara-2016-sonras-siyah-shark-on-koruma-aqm-pst24-10-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');
INSERT INTO `vehicles` (`id`, `external_id`, `source`, `source_url`, `title`, `brand`, `model`, `year`, `price`, `currency`, `market_value`, `category_external_id`, `transmission`, `fuel_type`, `location`, `seller`, `seo_slug`, `price_battery`, `ai_confidence`, `trust_score`, `fraud_probability`, `risk_level`, `price_explanation`, `homepage_visible`, `featured`, `status`, `imported_at`, `created_at`, `updated_at`) VALUES ('50', 'KKT-00346--kategori-otomotiv-yedek-parca-aksesuar-d-aksesuar-merce', 'kktcarabam.com public indexed snapshot', 'https://www.kktcarabam.com/kategori/otomotiv-yedek-parca', 'Aksesuar Dış Aksesuar Mercedes Vito 06-14 İçin 2014+ W447 Facelift Bodykit 150.000 TL', 'Unknown', 'Dış Mercedes Vito 06-14 İçin', '2014', '0', 'TL', '0', 'parts', 'Unknown', 'Unknown', 'Northern Cyprus', 'Competitor marketplace import', 'aksesuar-d-s-aksesuar-mercedes-vito-06-14-icin-2014-w447-facelift-bodykit-150-000-tl', '45', '61', '58', '0.18', 'medium', 'Competitor listing hides price or uses zero price; AI requires seller confirmation before approval.', '1', '0', 'imported', '2026-05-19 09:15:38', '2026-05-21 10:36:23', '2026-05-21 10:36:23');