SELECT `vehicle_id` as `ID`, IF(strcmp(UCASE(TRIM(UCASE(CONCAT_WS(' ',`make_name`,'')))),''),UCASE(TRIM(UCASE(CONCAT_WS(' ',`make_name`,'')))),'OTHER') as `MakeN`, IF(strcmp(UCASE(TRIM(UCASE(CONCAT_WS(' ',`model_name`,TRIM(`model_text`))))),''),UCASE(TRIM(UCASE(CONCAT_WS(' ',`model_name`,TRIM(`model_text`))))),'OTHER') as `ModelN`,`style` as `BodyStyleN`
FROM `tbl_vehicle`
LEFT OUTER JOIN `lu_vehicle_make` ON `tbl_vehicle`.`make`=`lu_vehicle_make`.`id`
LEFT OUTER JOIN `lu_vehicle_model` ON `tbl_vehicle`.`model`=`lu_vehicle_model`.`id`
LEFT OUTER JOIN `lu_vehicle_body_style` ON `tbl_vehicle`.`body`=`lu_vehicle_body_style`.`id`
LEFT OUTER JOIN `lu_vehicle_trim` ON `tbl_vehicle`.`trim`=`lu_vehicle_trim`.`id`
LEFT OUTER JOIN `tbl_users` ON `tbl_vehicle`.`user_id`=`tbl_users`.`tbl_users_id`
LEFT OUTER JOIN `tbl_users_data` ON `tbl_users`.`tbl_users_id`=`tbl_users_data`.`user_id`
LEFT OUTER JOIN `lu_vehicle_condition` ON `tbl_vehicle`.`condition`=`lu_vehicle_condition`.`id`
LEFT OUTER JOIN `lu_state` ON `tbl_users_data`.`state_id`=`lu_state`.`id`
WHERE ((`tbl_vehicle`.`dealer_id` = '26') ) AND (`YEAR`>='2007') vehicle_id='2696713' ORDER BY `MakeN` ASC , `ModelN` ASC , `year` ASC LIMIT 0,10: 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 'vehicle_id='2696713' ORDER BY `MakeN` ASC , `ModelN` ASC , `year` ASC L' at line 13