Next day delivery only £3.95 on orders over £45 (Subject to T&C)
  • 0208 443 6139
1064 SELECT product.productCode,productline.catagory,manf.ref,catagories.catagoryRef,catagories.catagoryName,description,IFNULL(puffinPrice,ROUND(product.price+((product.price)*IFNULL(seed,80))/100,2)) as calc,product.special,manf.name,product_images.name,product_images.ext,options,thisoption,productline.productLineCode,product.image,cat.catagoryRef,cat.catagoryName,productRange,META,quantityOnHand,longDescription,cat.categoryDescription,catagories.special,catagories.inseason,catagories.hidden,cat.special,cat.inseason,cat.hidden,catThree.catagoryRef,catThree.catagoryName,catThree.special,catThree.inseason,catThree.hidden,extracatagories.breaker,barcode,sellingPrice,suppRef,weight,deptCode,mainSuppCode,per,perSize,productline.hidden,extracatagories.position,actualDeptCode,deptPriceSeed,seasonStart,seasonEnd,onOrder,off,vatRateBand,ratingTotal,lastReview,dateListed,secondimage.name,secondimage.ext,product_images.wide,secondimage.wide,additionalText,offType,answeredQuestions,productline.altDescription,deptName,subDeptName,subSubName FROM productline LEFT JOIN product on productline.productLineCode=product.productLineCode LEFT JOIN manf on productline.manf=manf.ref LEFT JOIN product_images on productline.productLineCode=product_images.name LEFT JOIN product_images AS secondimage on secondimage.name=CONCAT(productline.productLineCode,'_A') LEFT JOIN catagories on productline.catagory=catagories.catagoryRef LEFT JOIN catagories as cat on productline.secondaryCat=cat.catagoryRef LEFT JOIN catagories as catThree on productline.thirdCat=catThree.catagoryRef LEFT JOIN extracatagories on productline.productLineCode=extracatagories.productLineCode LEFT JOIN deptpriceseed on productline.actualDeptCode=deptpriceseed.ref LEFT JOIN reviewtotals on productline.productLineCode=reviewtotals.productLineCode WHERE (extracatagories.catagoryRef='Valentine's Day' AND productline.productLineCode=extracatagories.productLineCode AND (productline.hidden!='true' OR (productline.hidden='true' AND (catagories.catagoryRef IS NOT NULL OR cat.catagoryRef IS NOT NULL)) )) order by position,extracatagories.productLineCode