Ransacker

Search Results

You searched for: Alida's f i football boots 
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, 'Alida\''s f50i football boots')>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 '%Alida''''s%' AND P.TITLE LIKE '%f50i%' AND P.TITLE LIKE '%football%' AND P.TITLE LIKE '%boots%' ) OR ( P.DETAIL LIKE '%Alida''''s%' AND P.DETAIL LIKE '%f50i%' AND P.DETAIL LIKE '%football%' AND P.DETAIL LIKE '%boots%' )) 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 f50i football boots')>0, 1, 0) AS TITLE_REL FROM PRICECOMPARISON_CATEGOR' at line 15