Search Results
You searched for: Asa's gt| Sort By: |
Could not execute query [SELECT IFNULL(P.PRICE, 0) AS PRICE_MIN,
IFNULL(P.MAX_PRICE, 0) AS PRICE_MAX,
IFNULL(P.STORE_COUNT, 0) AS STORE_COUNT,
P.ID AS ID,
P.TITLE AS TITLE,
P.DETAIL AS DETAIL,
P.FILENAME AS PFILENAME,
((ifnull(PRICECOMPARISON_PRODUCT_MAGAZINE_REVIEW.RATING, 0)) + P.PRODUCT_RATING) as RATING,
P.PRODUCT_RATING as normalRATING,
C.ID AS CID,
C.FILENAME AS CFILENAME,
C.TITLE AS CATEGORY,
IF (INSTR(P.TITLE, 'Asa\''s gt 2150')>0, 1, 0) AS TITLE_REL
FROM PRICECOMPARISON_CATEGORY C,
QueryToGetTheMinPriceValue_XX P
left join PRICECOMPARISON_PRODUCT_MAGAZINE_REVIEW on
PRICECOMPARISON_PRODUCT_MAGAZINE_REVIEW.PRODUCT_ID = P.ID
WHERE C.ID = P.CATEGORY_ID
AND C.ISVALID='Y'
AND P.ISVALID='Y'
AND (( P.TITLE LIKE '%Asa''''s%' AND P.TITLE LIKE '%gt%' AND P.TITLE LIKE '%2150%' )
OR ( P.DETAIL LIKE '%Asa''''s%' AND P.DETAIL LIKE '%gt%' AND P.DETAIL LIKE '%2150%' ))
ORDER BY RATING DESC
] - 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 's gt 2150')>0, 1, 0) AS TITLE_REL
FROM PRICECOMPARISON_CATEGORY C,
Q' at line 15