SELECT title,description,retail,sale,up_sell,idx,thum,free_shipping,categories FROM products WHERE productcode=''