combo 2008 SPECIAL

owner,id,if (display = 1,concat(replace(id,' ','_'),'.jpg'),'noimage.jpg') as IMGid,if (length(brand) > 1,concat(replace(brand,' ','_'),'.jpg'),'noimage.jpg') as IMGbrand,cat,subcat,replace(trim(name), '
', ' ') as name,replace(description, '`','\'') as description,brand,price as price1,price2,price3,price4,price5,price6,misc as weight,special,showprod as showProduct,related,display,misc1,misc2,misc3,misc4,misc5,opt1,opt2,opt3,opt4,opt5,opt6,gst,misc6,misc7,misc8,misc9,misc10,opt7,opt8,newItem,outOfStock,gstType,specialPrice,orderBy,specialStartDate,specialEndDate,insertDate,lastUpdated,if (specialStartDate <= curdate() and specialEndDate >= curdate() and specialPrice > 0 and special = 1,1,NULL) as isOnSpecial,stockLevel,postage,itemsPerCarton,quoteOnly