offer gone!SELECT id,program,(CASE WHEN frontendlink LIKE '%//%' AND link_status = 1 THEN frontendlink ELSE trackinglink END) AS trackinglink FROM wp_1001coupons WHERE post_status IN('publish','expired') AND id = 1218626 LIMIT 0,1