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_origin tso on tp.origin_id = tso.id and md5(tso.code) = 'ec0cad0993f48a6eec0f9a64cd013856' left outer join t_sys_designer tsd on tsd.id = tp.designer_id where tp.is_live = 1 order by tp.title limit 0,10Got 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