{ "title": "mysqli_sql_exception", "type": "mysqli_sql_exception", "code": 500, "message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-15, 15' at line 13", "file": "/home/comkatartur/public_html/system/Database/MySQLi/Connection.php", "line": 329, "trace": [ { "file": "/home/comkatartur/public_html/system/Database/MySQLi/Connection.php", "line": 329, "function": "query", "class": "mysqli", "type": "->", "args": [ "SELECT `tours`.`tour_id`, `tours`.`name`, `tours`.`small_description`, `tours`.`seo`, `tours`.`travel_type`, `tours`.`hotel_accomodation`, `tours`.`day_count`, `tours`.`night_count`, `tours`.`description`, `tours`.`normal_price`, `tours`.`discount_percent`, `tours`.`discounted_price`, `tours`.`concept_name`, `tours`.`child_discount`, `tours`.`currency`, `tours`.`has_price`, `tours`.`general_info`, `tours`.`template_id`, `tours_templates`.`tour_type`, `tours_templates`.`places_to_visit`, `tours_templates`.`depart_from`, `tours_templates`.`arrival_to`, `tours_templates`.`main_photo`\nFROM `tours`\nJOIN `tours_templates` ON `tours_templates`.`template_id`=`tours`.`template_id`\nJOIN `tours_thems_tours` ON `tours_thems_tours`.`tour_id`=`tours`.`tour_id`\nWHERE `tours_templates`.`tour_type` = '4'\nAND `tours`.`status` = 1\nAND `tours`.`sales_start` <= '2024-03-19'\nAND `tours`.`sales_end` >= '2024-03-19'\nAND `tours_templates`.`status` = 1\nAND `tours_templates`.`deleted` IS NULL\nAND `tours_templates`.`lang` = 'tr'\nAND `tours_thems_tours`.`theme_id` = '10'\nAND `tours`.`deleted` IS NULL\nGROUP BY `tours`.`tour_id`\nORDER BY `tours`.`has_price` DESC, `tours_thems_tours`.`sort` ASC\n LIMIT -15, 15" ] }, { "file": "/home/comkatartur/public_html/system/Database/BaseConnection.php", "line": 732, "function": "execute", "class": "CodeIgniter\\Database\\MySQLi\\Connection", "type": "->", "args": [ "SELECT `tours`.`tour_id`, `tours`.`name`, `tours`.`small_description`, `tours`.`seo`, `tours`.`travel_type`, `tours`.`hotel_accomodation`, `tours`.`day_count`, `tours`.`night_count`, `tours`.`description`, `tours`.`normal_price`, `tours`.`discount_percent`, `tours`.`discounted_price`, `tours`.`concept_name`, `tours`.`child_discount`, `tours`.`currency`, `tours`.`has_price`, `tours`.`general_info`, `tours`.`template_id`, `tours_templates`.`tour_type`, `tours_templates`.`places_to_visit`, `tours_templates`.`depart_from`, `tours_templates`.`arrival_to`, `tours_templates`.`main_photo`\nFROM `tours`\nJOIN `tours_templates` ON `tours_templates`.`template_id`=`tours`.`template_id`\nJOIN `tours_thems_tours` ON `tours_thems_tours`.`tour_id`=`tours`.`tour_id`\nWHERE `tours_templates`.`tour_type` = '4'\nAND `tours`.`status` = 1\nAND `tours`.`sales_start` <= '2024-03-19'\nAND `tours`.`sales_end` >= '2024-03-19'\nAND `tours_templates`.`status` = 1\nAND `tours_templates`.`deleted` IS NULL\nAND `tours_templates`.`lang` = 'tr'\nAND `tours_thems_tours`.`theme_id` = '10'\nAND `tours`.`deleted` IS NULL\nGROUP BY `tours`.`tour_id`\nORDER BY `tours`.`has_price` DESC, `tours_thems_tours`.`sort` ASC\n LIMIT -15, 15" ] }, { "file": "/home/comkatartur/public_html/system/Database/BaseConnection.php", "line": 647, "function": "simpleQuery", "class": "CodeIgniter\\Database\\BaseConnection", "type": "->", "args": [ "SELECT `tours`.`tour_id`, `tours`.`name`, `tours`.`small_description`, `tours`.`seo`, `tours`.`travel_type`, `tours`.`hotel_accomodation`, `tours`.`day_count`, `tours`.`night_count`, `tours`.`description`, `tours`.`normal_price`, `tours`.`discount_percent`, `tours`.`discounted_price`, `tours`.`concept_name`, `tours`.`child_discount`, `tours`.`currency`, `tours`.`has_price`, `tours`.`general_info`, `tours`.`template_id`, `tours_templates`.`tour_type`, `tours_templates`.`places_to_visit`, `tours_templates`.`depart_from`, `tours_templates`.`arrival_to`, `tours_templates`.`main_photo`\nFROM `tours`\nJOIN `tours_templates` ON `tours_templates`.`template_id`=`tours`.`template_id`\nJOIN `tours_thems_tours` ON `tours_thems_tours`.`tour_id`=`tours`.`tour_id`\nWHERE `tours_templates`.`tour_type` = '4'\nAND `tours`.`status` = 1\nAND `tours`.`sales_start` <= '2024-03-19'\nAND `tours`.`sales_end` >= '2024-03-19'\nAND `tours_templates`.`status` = 1\nAND `tours_templates`.`deleted` IS NULL\nAND `tours_templates`.`lang` = 'tr'\nAND `tours_thems_tours`.`theme_id` = '10'\nAND `tours`.`deleted` IS NULL\nGROUP BY `tours`.`tour_id`\nORDER BY `tours`.`has_price` DESC, `tours_thems_tours`.`sort` ASC\n LIMIT -15, 15" ] }, { "file": "/home/comkatartur/public_html/system/Database/BaseBuilder.php", "line": 1881, "function": "query", "class": "CodeIgniter\\Database\\BaseConnection", "type": "->", "args": [ "SELECT `tours`.`tour_id`, `tours`.`name`, `tours`.`small_description`, `tours`.`seo`, `tours`.`travel_type`, `tours`.`hotel_accomodation`, `tours`.`day_count`, `tours`.`night_count`, `tours`.`description`, `tours`.`normal_price`, `tours`.`discount_percent`, `tours`.`discounted_price`, `tours`.`concept_name`, `tours`.`child_discount`, `tours`.`currency`, `tours`.`has_price`, `tours`.`general_info`, `tours`.`template_id`, `tours_templates`.`tour_type`, `tours_templates`.`places_to_visit`, `tours_templates`.`depart_from`, `tours_templates`.`arrival_to`, `tours_templates`.`main_photo`\nFROM `tours`\nJOIN `tours_templates` ON `tours_templates`.`template_id`=`tours`.`template_id`\nJOIN `tours_thems_tours` ON `tours_thems_tours`.`tour_id`=`tours`.`tour_id`\nWHERE `tours_templates`.`tour_type` = :tours_templates.tour_type:\nAND `tours`.`status` = :tours.status:\nAND `tours`.`sales_start` <= :tours.sales_start:\nAND `tours`.`sales_end` >= :tours.sales_end:\nAND `tours_templates`.`status` = :tours_templates.status:\nAND `tours_templates`.`deleted` IS NULL\nAND `tours_templates`.`lang` = :tours_templates.lang:\nAND `tours_thems_tours`.`theme_id` = :tours_thems_tours.theme_id:\nAND `tours`.`deleted` IS NULL\nGROUP BY `tours`.`tour_id`\nORDER BY `tours`.`has_price` DESC, `tours_thems_tours`.`sort` ASC\n LIMIT -15, 15", { "tours_templates.tour_type": [ "4", true ], "tours.status": [ 1, true ], "tours.sales_start": [ "2024-03-19", true ], "tours.sales_end": [ "2024-03-19", true ], "tours_templates.status": [ 1, true ], "tours_templates.lang": [ "tr", true ], "tours_thems_tours.theme_id": [ "10", true ] }, false ] }, { "file": "/home/comkatartur/public_html/system/Model.php", "line": 197, "function": "get", "class": "CodeIgniter\\Database\\BaseBuilder", "type": "->", "args": [] }, { "file": "/home/comkatartur/public_html/system/BaseModel.php", "line": 603, "function": "doFindAll", "class": "CodeIgniter\\Model", "type": "->", "args": [ 15, -15 ] }, { "file": "/home/comkatartur/public_html/app/Modules/Tours/Models/ToursModel.php", "line": 247, "function": "findAll", "class": "CodeIgniter\\BaseModel", "type": "->", "args": [ 15, -15 ] }, { "file": "/home/comkatartur/public_html/app/Modules/Tours/Controllers/Tours.php", "line": 43, "function": "SearchTour", "class": "App\\Modules\\Tours\\Models\\ToursModel", "type": "->", "args": [ { "TourlId": "0", "theme": "10", "TourType": "4", "Category": "0", "DepartCity": "0", "filter": { "sorting": "popular_ASC", "DepartCity": [], "TourTypes": [], "TravelTypes": [], "tourNameorCode": null }, "page": "0" } ] }, { "file": "/home/comkatartur/public_html/app/Modules/Home/Controllers/Home.php", "line": 207, "function": "TourSearch", "class": "App\\Modules\\Tours\\Controllers\\Tours", "type": "->", "args": [ { "criteria": { "TourlId": "0", "theme": "10", "TourType": "4", "Category": "0", "DepartCity": "0" }, "siteInfo": { "site_id": "1", "name": "Katar Tur", "url": "http://www.katartur.com/", "theme": "astra", "logo": "/medias/logos/orjinal/logo-aUBVR6hIWj4p5d8k9rDeiKwczLlbsN0vZX7.png", "call_center": "0850 495 59 74", "phone": "+90 256 613 23 46", "phone2": "0 539 660 90 77", "phone3": "0 533 467 90 77", "whatsapp": "+90 539 660 90 77", "fax": "+90 256 612 12 25", "email": "info@katartur.com", "email1": "ozgul.yavasca@katartur.com", "facebook": "https://facebook.com/Katarturizm", "twitter": "https://twitter.com/katarturizm", "youtube": "", "instagram": "https://www.instagram.com/katarturizm/", "linkedin": "https://tr.linkedin.com/in/katar-turizm-731b7510a", "foursquare": "https://tr.foursquare.com/katarturcom", "pinterest": "https://tr.pinterest.com/katarturizm/", "telegram": null, "tripadvisor": null, "user_id": "63", "header_codes": "\r\n\r\n\r\n\r\n", "footer_codes": "", "footer_logos": "
\n\n\n", "footer_codes_2": null, "body_codes": "\r\n\r\n", "reservation_remarketing": "", "call_request_remarketing": "", "tursab_dds": "", "copyright": "2019- Katartur.Com", "google_map_api": "", "company_name": "KATARTUR", "address": "İnönü Caddesi Camikebir Mah. No:58/A ", "city": "KUSADASI", "town": "Aydin", "google_lat": "", "google_lng": "", "recaptcha_site_key": "6LcmxawUAAAAAJm7PuyiU92BZIzPpzYtzgZ8XSRu", "recaptcha_secret_key": "6LcmxawUAAAAALu13I-YqbX7oUcEnWu4s7J8hSvJ", "criteo_homepage_tag": null, "criteo_category_listing_tag": null, "criteo_product_tag": null, "criteo_basket_cart_tag": null, "criteo_sales_tag": null, "deleted": null, "deleted_by": "0", "ipstack_api": "", "ip_based_price": "0", "language_support": "0", "main_lang": "tr", "title_abstract": null, "footer_copyright": null, "payment_template": "{domainname}payment/{token}", "reservation_css": null, "isMobile": 0, "ThemeSettings": { "footer_bottom_content": "Her hakkı saklıdır. Site Kullanım Sözleşmesi | Gizlilik Sözleşmesi Katar Tur web sitesi, kişisel bilgisayarınıza bilgi depolamak amacıyla tanımlama bilgilerini kullanır.
\r\nBilgilerin bir kısmı sitenin çalışmasında asıl rolü üstlenirken bazı kısımları ise kullanıcı deneyimlerinin daha da iyileştirilmesine yardımcı olur.
\r\nSitemizi kullanarak bu tanımlama bilgilerinin yerleştirilmesine izin vermiş olursunuz. Detaylı bilgi için Gizlilik Politikamızı okuyunuz.
Katar Tur, yurtiçi tatil programları, yurtdışı paket turlar, Kıbrıs gezileri, kültür turları, cruise (gemi) turları , yurtiçi ve yurtdışı uçak biletleri, şehir otelleri, ulaşım, eğlence organizasyonları, incentive toplantı grupları, bayi teşvik gezileri ile hizmet vermektedir.
\r\n\r\nKatar Tur Yurt İçi Otel: Akdeniz ve Ege sahil şeridinde oda kahvaltıdan, Ultra Herşey Dahile kadar seçkin resort oteller ve tatil köyleri rezervasyonu,
\r\nKatar Tur Yurt Dışı Otel: Dünyanın her bölgesinde, her kategoride anında otel rezervasyonu,
\r\nKatar Tur Kıbrıs Otelleri: Uçak ulaşım ve transfer hizmetleri ile Girne, Magosa, Bafra ve Lefkoşa’da otel rezervasyonları,
\r\nKatar Tur Kültür Turları: Tren, Otobüs veya Uçak ile yeni bir şehri ziyaret ederek, yerel halkın yaşayış şekli, sokakların mimarisi, doğal güzellikleri ve kültürü ve tarihi yakından tanımak için Kültür turları rezervasyonları,
\r\nKatar Tur Yurt Dışı Turları: Katar Tur Elit Turlar olmak üzere Tüm Avrupa, Amerika, Afrika ve Uzakdoğu Turları rezervasyonları,
\r\nKatar Tur Gemi Turları: Yüzen otel mantığında her gün farklı bir limana uğrayan, her kategoride cruise gemileri ile Dünyayı gezme imkanı,
\r\nKatar Tur Uçak Bileti: Dünyanın her noktasına ve yurt içinde tüm hava yollarında anında uçak bileti rezervasyonu,
\r\nKatar Tur MICE: Açılışlar, ürün lansmanları, bayi toplantıları, motivasyon gezileri, kurumsal organizasyonlar, davet organizasyonları v.b. tüm etkinliklerde, kurum kimliğini yansıtan özgün çözümleriyle müşterilerinin rekabette fark yaratmasına yardımcı oluyor.