|
|
|
Invalid query: 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 '%20model limit 0 , 11' at line 10: select `id`,`car_type`,`prod_cat`,`brand`,`model`,`seat`,`volume`,`transmission`,
`years`,`license_plate_numbers`,`homophonic`,`belonger`,`phone_number`,`brand_new`,case when `discount_price` = '0.00'
then `selling_price` else `discount_price` end `order_price`, `selling_price`, `discount_price`,`color`,`fuel`,`classification`,`tonnage`
,(select `pid` from `address` where `product`.`district` = `address`.`id` ) as region
,`member_id`,`is_sold_out`,`is_disabled`,`is_deleted`,`car_youtube_code`,`car_youtube_code2`,`car_youtube_code3`,`userid`,`adminid`,`stamp`,`district`,`franchise`,`garage_id`,
(select count(*) from `comment` where `comment`.`product_id` = `product`.`id` ) as comment_count,
(select count(*) from `browse` where `browse`.`product_id` = `product`.`id`) as browse_count,
(select `lang_value` from `multi_lang` where `multi_lang`.`db_table_id` = `product`.`brand` and `lang_code` = '2' and `db_table` = 'listitem') as brand_name,
(select `lang_value` from `multi_lang` where `multi_lang`.`db_table_id` = `product`.`garage_id` and `lang_code` = '' and `db_table` = 'listitem') as garage_name
from `product` where 1 and `is_deleted`=0 and `product`.`car_type`='49' and `product`.`is_disabled`='0' and `product`.`is_deleted`='0' and `product`.`prod_cat` in (3) order by brand_name%20,%20model limit 0 , 11 |
