SELECT MAX(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(value, 's:5:"views";i:', -1), ';', 1) AS SIGNED)) AS mx FROM emlog_deep_navi WHERE value LIKE '%views%'
error: 2006 , MySQL server has gone away
SELECT MAX(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(value, 's:5:"views";i:', -1), ';', 1) AS SIGNED)) AS mx FROM emlog_deep_navi WHERE value LIKE '%views%'
error: 2006 , MySQL server has gone away