A PHP Error was encountered

Severity: Notice

Message: Undefined variable: orderby

Filename: controllers/course.php

Line Number: 248

Database Error

A Database Error Occurred

Error Number:

接近關鍵字 'AS' 之處的語法不正確。

SELECT Row_Number() OVER (ORDER BY Online DESC, ) AS sort, * FROM ( SELECT Row_Number() OVER (PARTITION BY a.item_id ORDER BY a.Online DESC, a.OpenDate) AS RN, a.Attribute_id, a.Item_Id, a.Attribute_value, a.Sale_Price, CONVERT(char(10),a.OpenDate,111) AS OpenDate, a.Class_hours, CONVERT(char(10),a.End_Date,111) AS End_Date, a.Zone_Name, CONVERT(text, b.Description_S) AS Description_S, a.Item_Name, a.Zone_ID, a.Online FROM Store_Class_Views AS a INNER JOIN Store_Items AS b ON a.Item_Id = b.Item_Id WHERE (a.Store_ID = '277122022') AND (b.Show = 1) AND (a.Sale_Price = 0) ) AS tb WHERE (tb.RN = 1)