Mysql排序的字段值相同时，相同的数据顺序是随机的

SELECT
	m.*,
	IFNULL( c.like_sum, 0 ) AS numberOfLikes 
FROM
	match_activity_works m
	LEFT JOIN litemall_collect_sum c ON m.design_id = c.value_id 
WHERE
	m.is_pass = 1 
	AND m.deleted = 0 
ORDER BY
	c.like_sum DESC 
LIMIT 16,8;

执行上面sql的时候会发现在like_sum相同的数据的顺序是随机的，所以要再加一个排序条件固定顺序

SELECT
	m.*,
	IFNULL( c.like_sum, 0 ) AS numberOfLikes 
FROM
	match_activity_works m
	LEFT JOIN litemall_collect_sum c ON m.design_id = c.value_id 
WHERE
	m.is_pass = 1 
	AND m.deleted = 0 
ORDER BY
	c.like_sum DESC , m.id
LIMIT 16,8;