A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 1

Filename: models/Ad_model.php

Line Number: 167

Backtrace:

File: /home/motorscoth/domains/motors.co.th/public_html/application/modules/cars/models/Ad_model.php
Line: 167
Function: _error_handler

File: /home/motorscoth/domains/motors.co.th/public_html/application/modules/cars/controllers/Cars.php
Line: 431
Function: Search

File: /home/motorscoth/domains/motors.co.th/public_html/index.php
Line: 292
Function: require_once

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND ad.ad_approved=1 AND ad.ad_deleted = 0 AND ad.ad_deleted_forever = 0 ...' at line 69

SELECT ad.ad_id, ad.ad_url_name, ad.ad_car_year, ad.ad_car_price, ad.ad_car_mileage, ad.ad_car_doors, ad.ad_car_engine_size, ad.ad_car_body_type_id, ad.ad_car_fuel_id, ad.ad_car_transmission_id, ad.ad_car_lat, ad.ad_car_lon, ad.ad_car_province_id, ad.ad_car_amphur_id, CONCAT(car_make.car_make_name,' ',car_model.car_model_name,' (',ad.ad_car_year,')') AS title, car_make.car_make_name, car_model.car_model_name, car_condition.car_condition_name_en, car_body_type.car_body_type_name_en, car_transmission.car_transmission_name_en, car_fuel.car_fuel_name_en, car_drive_type.car_drive_type_name_en, car_color.car_color_name_en, mem.mem_type, mem.mem_name, mem.mem_mobile, mem.mem_phone, mem.mem_company_logo, mem.mem_company_name_en, province.province_name_en, province.province_name_th, amphur.amphur_name_en, amphur.amphur_name_th, ( SELECT ad_photo.ad_photo_name FROM ad_photo WHERE ad_photo.ad_id=ad.ad_id ORDER BY ad_photo.ad_photo_order_no ASC LIMIT 1 ) AS cover, ( SELECT COUNT(ad_photo.ad_photo_id) FROM ad_photo WHERE ad_photo.ad_id=ad.ad_id ) AS photos FROM ad INNER JOIN mem ON ad.ad_mem_id = mem.mem_id LEFT JOIN car_make ON ad.ad_car_make_id = car_make.car_make_id LEFT JOIN car_model ON ad.ad_car_model_id = car_model.car_model_id LEFT JOIN car_serie ON car_serie.car_serie_id = car_model.car_serie_id LEFT JOIN car_condition ON ad.ad_car_condition_id = car_condition.car_condition_id LEFT JOIN car_body_type ON ad.ad_car_body_type_id = car_body_type.car_body_type_id LEFT JOIN car_transmission ON ad.ad_car_transmission_id = car_transmission.car_transmission_id LEFT JOIN car_fuel ON ad.ad_car_fuel_id = car_fuel.car_fuel_id LEFT JOIN car_drive_type ON ad.ad_car_drive_type_id = car_drive_type.car_drive_type_id LEFT JOIN car_color ON ad.ad_car_color_id = car_color.car_color_id LEFT JOIN province_area ON ad.ad_car_province_area_id = province_area.province_area_id LEFT JOIN province ON ad.ad_car_province_id = province.province_id LEFT JOIN amphur ON ad.ad_car_amphur_id = amphur.amphur_id WHERE ad.ad_show_motors=1 AND ad.ad_car_price BETWEEN 3000000%3B10000000 AND AND ad.ad_approved=1 AND ad.ad_deleted = 0 AND ad.ad_deleted_forever = 0 AND ad.ad_expired=0 AND ad.ad_offline=0 AND mem.mem_deleted = 0 ORDER BY ad.ad_id DESC

Filename: modules/cars/models/Ad_model.php

Line Number: 310