查询最新一条数据

点击查看代码

SELECT
	`t1`.*, `t2`.`name` `company_name`
FROM
	`product_label_data` `t1`
LEFT JOIN `company` `t2` ON `t2`.`pk_corp` = `t1`.`pk_corp`
INNER JOIN (
SELECT
	SUBSTRING_INDEX(
   GROUP_CONCAT(id ORDER BY create_time DESC),
   ',',
   1
  ) alias_id
FROM
	product_label_data
GROUP BY
	invcode
) t3 ON `t3`.`alias_id` = `t1`.`id`
WHERE
	`t1`.`label_exist` = 1
AND `t1`.`invcode` <> ''
GROUP BY
	`t1`.`label_type`,
	`t1`.`label_exist`,
	`t1`.`label_beyond`,
	`t1`.`is_click`,
	`t1`.`pk_corp`