//自己关联自己将子表分组排序然后按照子表的数据排序
SELECT c1.* from cms_tj_out_ticket_templete as c1
RIGHT JOIN (SELECT * from cms_tj_out_ticket_templete where tj_num = 1 GROUP BY org_id ORDER BY create_time) as c2
on c1.org_id = c2.org_id
where c1.tj_num = 1
and org_id LIKE concat(#{orgId},’%’)
ORDER BY c2.create_time desc,c1.create_time desc
limit #{start},#{limit}