SELECT ws.web_session_cart_id as id , ws.amount , ws.price , ws.cart_type as type , ws.comments , ws.quantity , ws.gc_num , 'AlpineShop.com E-Gift Certificate' as name ,ws.gc_type , (CASE WHEN ws.gc_type = 'pathfinderGC' THEN 'https://www.alpineshop.com//info/pathfinder-e-gift-card' ELSE 'https://www.alpineshop.com//info/alpine-e-gift-card' END) as url , (CASE WHEN ws.gc_type = 'pathfinderGC' THEN 'https://www.alpineshop.com//images/pathfinder_e-gift-card.png' ELSE 'https://www.alpineshop.com//images/alpineshop_e-gift-card.png' END) as image_path ,ws.coupon_lookup ,ws.gc_email FROM web_session_cart ws WHERE 1=1 AND ws.web_session_id = ? AND ws.quantity > 0 AND ws.cart_type IN ('gc') ORDER BY ws.web_session_cart_id DESC