An Error Was Encountered

Error Number: 1054

Unknown column '48' in 'order clause'

SELECT P.productID,P.secondaryMarket, CONCAT(LEFT(P.name,15),'...') AS name, P.name AS longName, P.price1, P.extrafield2 AS year, P.extrafield3 AS medium, P.shortDescription, P.keywords, P.scLevel, S.sectionID, CONCAT(LEFT(S.title,15),'...') AS title, S.firstname, S.lastname, P.rrp1 FROM jss_products P INNER JOIN jss_products_tree PT ON P.productID = PT.productID INNER JOIN jss_sections S ON S.sectionID = PT.sectionID WHERE P.price1 > 0 AND P.visible = 'Y' AND (P.keywords LIKE '%colour%' OR P.name LIKE '%colour%' OR P.shortDescription LIKE '%colour%') ORDER BY 48 LIMIT 0, 16