CODE EXAMPLE FOR SQL

group_concat order by

SELECT 	li.client_id, 
		group_concat(li.percentage ORDER BY li.views ASC) AS views, 
		group_concat(li.percentage ORDER BY li.percentage ASC) 
FROM li 
GROUP BY client_id