Skip to main content

View Cart
My Cart

There is 0 item(s) in your cart.
Sub-total
0.00
inv_cur_key=;CustomerKey=00000000-0000-0000-0000-000000000000;listwhere=; pager= SELECT prd_key, prd_name, [isbn] = ISNULL(pub_isbn_number, ''), [description] = substring(prd_description,0, 200), [descMoreLinkText] = case when substring(prd_description,0, 200) != convert(nvarchar(210),prd_description) then 'more»' else '' end, [newIcon] = case when prd_show_as_new_until is not null and prd_show_as_new_until > dbo.nf_get_date() then 'New' else '' end, [productURL] = 'DynamicPage.aspx?Action=Add&ObjectKeyFrom=1A83491A-9853-4C87-86A4-F7D95601C2E2&WebCode=ProdDetailAdd&DoNotSave=yes&ParentObject=CentralizedOrderEntry&ParentDataObject=Invoice Detail&ivd_formkey=69202792-63d7-4ba2-bf4e-a0da41270555&ivd_cst_key=' + convert(varchar(50),00000000-0000-0000-0000-000000000000) + '&ivd_cst_ship_key=' + convert(varchar(50),00000000-0000-0000-0000-000000000000) + '&ivd_prc_prd_key=' + convert(varchar(50),prd_key), [productImage] = case when doc_url is not null then doc_url else 'images/DEMO1/notavailable.jpg' end, [qtyAvailable] = case when prd_track_inventory_flag = 1 then convert(nvarchar(50),Convert(int,ivw_qty_available)) else '' end, [outOfStockMessage] = case when prd_track_inventory_flag = 1 and ivw_qty_available < 1 and prd_allow_backorder !=1 THEN isnull(prd_out_of_stock_override_message, 'Out of stock') ELSE '' END, [backOrderMessage] = case when prd_track_inventory_flag = 1 and ivw_qty_available < 1 and prd_allow_backorder = 1 THEN isnull(prd_out_of_stock_override_message, 'Item ON backorder') ELSE '' END, [ShowWishList] = case when cwl_key is null and cst_type = 'Individual' then '1' else '0' end, [addToWishListURL] = 'DynamicPage.aspx?ObjectKeyFrom=1A83491A-9853-4C87-86A4-F7D95601C2E2&WebCode=CSCAddToWishList&DoNotSave=yes&ParentObject=CentralizedOrderEntry&ParentDataObject=Invoice Detail&ivd_formkey=69202792-63d7-4ba2-bf4e-a0da41270555&ivd_cst_key=' + convert(varchar(50),'00000000-0000-0000-0000-000000000000') + '&ivd_prc_prd_key=' + convert(varchar(50),prd_key), [addToWishListButton] = '', [addToCartButton] = case when prd_track_inventory_flag = 1 and ivw_qty_available < 1 and prd_allow_backorder !=1 then '' else '' end, [AvgRating] = case when vcr_rating = 0 then '???' else str(vcr_rating,3,1) end, [PurchaseCstKey] = case when vpr_cpr_key is null then vpr_cst_key else null end from oe_product (nolock) join oe_product_type ptp (nolock) on ptp.ptp_key = prd_ptp_key join co_customer (nolock) on cst_key = left join oe_publication (nolock) on pub_prd_key = prd_key left join co_document (nolock) on prd_thumbnail_doc_key = doc_key left join oe_merchandise (nolock) on mer_prd_key=prd_key left join oe_product_kit (nolock) ON kit_prd_key=prd_key left join oe_product_category (nolock) on ptc_key = prd_ptc_key left join co_customer_wish_list (nolock) on cwl_prd_key=prd_key and cwl_ind_cst_key= left join vw_oe_product_purchases (nolock) on vpr_prd_key = prd_key and vpr_cst_key = left join vw_co_customer_product_rating (nolock) on vcr_prd_key = prd_key left join (select ivw_prd_key, sum(ivw_qty_available_cp) as ivw_qty_available from oe_inventory_x_warehouse (nolock) group by ivw_prd_key) as ivw_prd_available_qty on prd_key = ivw_prd_key where prd_delete_flag = 0 and prd_sell_online = 1 and ((prd_start_date < dbo.nf_get_date() or prd_start_date is null) and (prd_end_date+1 > dbo.nf_get_date() or prd_end_date is null)) and (ptp_code = 'Publication') and (mer_delete_flag is null or mer_delete_flag=0) and (kit_delete_flag is null or kit_delete_flag=0) and prd_key in (select prc_prd_key from oe_price where prc_prd_key = prd_key and prc_sell_online = 1 and (false='false' or prc_cur_key is null or isnull(,prc_cur_key)=prc_cur_key )) and ( is null or prd_name like '%'++'%') order by prd_name SELECT [price] = case when EXISTS(SELECT pat_member_flag FROM oe_price_attribute WHERE pat_prc_key = prc_key AND pat_member_flag = 1) then '<span class="price" title="Member Price"> ' + case when false='true' then convert(nvarchar(50),dbo.av_format_currency(prc_price ,isnull(prc_cur_key,cc.cur_key))) else '$' + convert(nvarchar(50),prc_price) end + '</span>' else '<span class="price muted">$' + case when false='true' then convert(nvarchar(50),dbo.av_format_currency(prc_price ,isnull(prc_cur_key,cc.cur_key))) else convert(nvarchar(50),prc_price) end + '</span>' end from oe_price (nolock) join oe_product (nolock) on prd_key = prc_prd_key join ac_company (nolock) on prd_atc_key=atc_key left join ac_currency pc (nolock) on prc_cur_key=pc.cur_key left join ac_currency (nolock) cc on cc.cur_code=isnull(atc_currency_code,'USD') where prc_sell_online = 1 and prc_delete_flag = 0 and ((prc_start_date < dbo.nf_get_date() or prc_start_date is null) and (prc_end_date > dbo.nf_get_date() or prc_end_date is null)) and prd_key = and (false='false' or prc_cur_key is null or isnull(,prc_cur_key)=prc_cur_key ) order by price prd_name publications-pager-bookmark
Publications
Show Per Page
View as
  • /
    Search Publications (Enter a keyword, publication name or description):

    Please login to see your wish list or add items.