A Database Error Occurred

Error Number: 1054

Unknown column '20BETWEEN' in 'where clause'

select * from ( SELECT PREFIX,PRODUCT_ID ,ONSTOCKSTATUS,PRODUCT_ID_PK,CASE WHEN INSTR(PRODUCT_NAME,'-')=0 THEN PRODUCT_NAME ELSE RTRIM(REPLACE(LEFT(PRODUCT_NAME,INSTR(PRODUCT_NAME,'-')),'-','')) END AS PRODUCT_NAME,CATEGORYONWEB,TYPEONWEB,PICTURE,NEWAVAILABLESTATUS,LASTUPDATED,PRODUCT_SELLING_PRICE,UNITTYPE FROM ( SELECT CASE WHEN (LEFT(PRODUCT_ID,1)) REGEXP '[0-9]+'=0 AND SUBSTRING(PRODUCT_ID,3,1) REGEXP '[0-9]+'=1 AND LENGTH(PRODUCT_ID)>=6 THEN LEFT(PRODUCT_ID,2) ELSE LEFT(PRODUCT_ID,3) END AS PREFIX, CASE WHEN (LEFT(PRODUCT_ID,1)) REGEXP '[0-9]+'=0 AND SUBSTRING(PRODUCT_ID,3,1) REGEXP '[0-9]+'=1 AND LENGTH(PRODUCT_ID)>=6 THEN LEFT(PRODUCT_ID,6) ELSE LEFT(PRODUCT_ID,7) END AS PRODUCT_ID, ONSTOCKSTATUS,PRODUCT_NAME,CATEGORYONWEB,TYPEONWEB,PICTURE,NEWAVAILABLESTATUS,LASTUPDATED,PRODUCT_SELLING_PRICE,UNITTYPE,PRODUCT_ID as PRODUCT_ID_PK, @rn := IF(@g1 = CASE WHEN (LEFT(PRODUCT_ID,1)) REGEXP '[0-9]+'=0 AND SUBSTRING(PRODUCT_ID,3,1) REGEXP '[0-9]+'=1 AND LENGTH(PRODUCT_ID)>=6 THEN LEFT(PRODUCT_ID,6) ELSE LEFT(PRODUCT_ID,7) END AND @g2 = CATEGORYONWEB AND @g3 = TYPEONWEB, @rn + 1, 1) AS RN, @g1 := CASE WHEN (LEFT(PRODUCT_ID,1)) REGEXP '[0-9]+'=0 AND SUBSTRING(PRODUCT_ID,3,1) REGEXP '[0-9]+'=1 AND LENGTH(PRODUCT_ID)>=6 THEN LEFT(PRODUCT_ID,6) ELSE LEFT(PRODUCT_ID,7) END, @g2 := CATEGORYONWEB, @g3 := TYPEONWEB FROM product_onweb JOIN (SELECT @rn := 0) AS vars WHERE SHOWONWEBSTATUS='Y' AND DEFAULTPICTUREONWEBSTATUS='Y' AND OnStockStatus='Y' AND ((LEFT(PRODUCT_ID,1) REGEXP '[0-9]+'=0 AND SUBSTRING(PRODUCT_ID,3,1) REGEXP '[0-9]+'=1 AND LENGTH(PRODUCT_ID)>=6) OR (LEFT(PRODUCT_ID,1) REGEXP '[0-9]+'=0 AND SUBSTRING(PRODUCT_ID,3,1)REGEXP '[0-9]+'=0 AND LENGTH(PRODUCT_ID)>=7)) ORDER BY CASE WHEN (LEFT(PRODUCT_ID,1)) REGEXP '[0-9]+'=0 AND SUBSTRING(PRODUCT_ID,3,1) REGEXP '[0-9]+'=1 AND LENGTH(PRODUCT_ID)>=6 THEN LEFT(PRODUCT_ID,6) ELSE LEFT(PRODUCT_ID,7) END,CATEGORYONWEB,TYPEONWEB) PRODUCT WHERE RN = 1) prod where TYPEONWEB='ER' and (PRODUCT_SELLING_PRICE%20BETWEEN%20500%20AND%201000)

Filename: /home/siamjobit/domains/siwancrystal.com/public_html/models/datamodel.php

Line Number: 39