SELECT 
 ct.optionID
 ,ct.label
 ,ct.url
 ,ct.link
 ,ct.link_tag
 FROM ss_category_option_tags ct 
 WHERE 1
 AND ct.`enabled` = 1
 AND ct.categoryID IN (86) 
 AND ct.optionID = '815' 
 AND ct.link <> ''
 GROUP BY 
 ct.label
 ,ct.url
 ,ct.link
 ,ct.link_tag