A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 1

Filename: models/Ad_bike_model.php

Line Number: 101

Backtrace:

File: /home/motorscoth/domains/motors.co.th/public_html/application/modules/bikes/models/Ad_bike_model.php
Line: 101
Function: _error_handler

File: /home/motorscoth/domains/motors.co.th/public_html/application/modules/bikes/controllers/Bikes.php
Line: 402
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 'ORDER BY ad_bike.ad_id DESC' at line 30

SELECT *, CONCAT(bike_make.bike_make_name,' ',bike_model.bike_model_name,' (',ad_bike.ad_bike_year,')') AS title, ( SELECT ad_bike_photo.ad_photo_name FROM ad_bike_photo WHERE ad_bike_photo.ad_id=ad_bike.ad_id GROUP BY ad_bike_photo.ad_id ORDER BY ad_bike_photo.ad_photo_order_no ASC LIMIT 1 ) AS cover FROM ad_bike INNER JOIN mem ON ad_bike.ad_mem_id=mem.mem_id LEFT JOIN bike_make ON ad_bike.ad_bike_make_id=bike_make.bike_make_id LEFT JOIN bike_model ON ad_bike.ad_bike_model_id=bike_model.bike_model_id LEFT JOIN bike_condition ON ad_bike.ad_bike_condition_id=bike_condition.bike_condition_id LEFT JOIN bike_body_type ON ad_bike.ad_bike_body_type_id=bike_body_type.bike_body_type_id LEFT JOIN bike_color ON ad_bike.ad_bike_color_id=bike_color.bike_color_id LEFT JOIN amphur ON amphur.amphur_id=ad_bike.ad_bike_amphur_id LEFT JOIN province ON province.province_id=ad_bike.ad_bike_province_id WHERE ad_bike.ad_show_motors = 1 AND ad_bike.ad_approved = 1 AND ad_bike.ad_deleted = 0 AND ad_bike.ad_deleted_forever = 0 AND ad_bike.ad_expired = 0 AND ad_bike.ad_offline = 0 AND mem.mem_deleted = 0 AND ad_bike.ad_bike_price BETWEEN 100000%7C500000 AND ORDER BY ad_bike.ad_id DESC

Filename: modules/bikes/models/Ad_bike_model.php

Line Number: 245