(case when (wr_10 = 1 or SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'popular||', -1), '||', 2) = 1) then (case when ((wr_content LIKE '%premium_date1%' and wr_content LIKE '%premium_date2%') or (wr_content LIKE '%popular_date1%' and wr_content LIKE '%popular_date2%')) then (case when (SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'premium_date1||', -1), '||', 2) <= DATE(NOW()) and SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'premium_date2||', -1), '||', 2) >= DATE(NOW()) or SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'popular_date1||', -1), '||', 2) <= DATE(NOW()) and SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'popular_date2||', -1), '||', 2) >= DATE(NOW())) then wr_10 when (SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'premium_date1||', -1), '||', 2) > DATE(NOW()) or SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'premium_date2||', -1), '||', 2) < DATE(NOW()) or SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'popular_date1||', -1), '||', 2) > DATE(NOW()) or SUBSTRING_INDEX(SUBSTRING_INDEX(wr_content, 'popular_date2||', -1), '||', 2) < DATE(NOW())) then wr_datetime END) else wr_10 END) END) desc, wr_datetime desc
