 |
|
 |
|
ERROR!!!
SQL query:select distinctrow tp.id, tp.title, tp.alt_title, tp.sku, if (tp.base_sale_price>0,tp.base_sale_price,tp.base_price) as price, tp.description, ifnull(tso.title,'n/a') as origin, ifnull(tsd.title,'n/a') as designer
from t_product tp inner join t_sys_type tst on tp.type_id = tst.id and md5(tst.code) = '6c85b67804dd104aeb6a3dc444a541a6'
left outer join t_sys_origin tso on tso.id = tp.origin_id
left outer join t_sys_designer tsd on tsd.id = tp.designer_id
where tp.is_live = 1 order by tp.titleGot error 28 from storage engine
ERROR!!!
SQL query:select price_change from t_product_size where product_id= order by price_change limit 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by price_change limit 1' at line 1
ERROR!!!
SQL query:select image_file from t_product_image where product_id= order by order_no limit 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by order_no limit 1' at line 1
ERROR!!!
SQL query:select tr.title from t_sys_room tr inner join t_product_room tpr on tpr.room_id=tr.id and tpr.product_id=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 '' at line 1
|
Price: $1099.95
|
 |
|
|
| |
|
|
|
ERROR!!!
SQL query:select distinctrow tp.id, tp.title, tp.alt_title, tp.sku, tp.base_price, tp.base_sale_price, tp.description, tp.minimal_amount, ifnull(tso.title,'n/a') as origin, ifnull(tsd.title,'n/a') as designer
from t_product tp inner join t_sys_type tst on tp.type_id = tst.id
inner join t_related_link trl on trl.item_id=tp.id and trl.product_id=98
left outer join t_sys_origin tso on tso.id = tp.origin_id
left outer join t_sys_designer tsd on tsd.id = tp.designer_id
where tp.is_live = 1 order by tp.titleGot error 28 from storage engine
ERROR!!!
SQL query:select price_change from t_product_size where product_id= order by price_change limit 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by price_change limit 1' at line 1
ERROR!!!
SQL query:select image_file from t_product_image where product_id= order by order_no limit 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by order_no limit 1' at line 1
ERROR!!!
SQL query:select tr.title from t_sys_room tr inner join t_product_room tpr on tpr.room_id=tr.id and tpr.product_id=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 '' at line 1
|
ERROR!!!
SQL query:select image_file from t_product_image where product_id= order by order_no limit 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by order_no limit 1' at line 1
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| |
|
|
