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 = 5716188 LIMIT 0,1