您需要再次从JOIN到wp_postmeta，查找相同的post_id和last_update的meta_key。然后您可以从第二个表中ORDER BYmeta_value：

SELECT wp1.*
FROM wp_postmeta wp1
LEFT JOIN wp_postmeta wp2 ON wp2.post_id = wp1.post_id AND wp2.meta_key = 'last_update'
WHERE wp1.meta_key LIKE 'product_info' AND wp1.meta_value LIKE '%Product data not found%'
ORDER BY COALESCE(wp2.meta_value, 0)

字符串
示例数据的输出：

post_id meta_key        meta_value
19249   product_info    Product data not found
19251   product_info    Product data not found
19248   product_info    Product data not found

型
db-fiddle.com上的演示
请注意，我使用LEFT JOIN和COALESCE来处理任何没有last_update值的帖子。COALESCE中的0值意味着这些帖子将首先排序;如果你想让它们最后排序，请使用COALESCE(wp2.meta_value, 2147483647)。

一个非常常见的方法是在这样的表结构中积累相关数据，执行一个pivot。一个已知列名的pivot查询使查询的开发和维护变得更加容易，因为在从聚合数据中挤出所需的值之后，您可以享受非常简单的访问。
使用GROUP BY和筛选聚合数据的好处最初看起来似乎是很多工作，但是当您开始为单个post_id堆积多行时，这种方法确实会看到它的回报。

Schema（MySQL v8.0）

CREATE TABLE wp_postmeta (
  `post_id` INTEGER,
  `meta_key` VARCHAR(50),
  `meta_value` VARCHAR(50)
);

INSERT INTO wp_postmeta
  (`post_id`, `meta_key`, `meta_value`)
VALUES
  ('19248', 'product_info', 'Product data not found anywhere'),
  ('19248', 'last_update', '1959520849'),
  ('19249', 'product_info', 'This Product data not found'),
  ('19249', 'last_update', '1659520849'),
  ('19250', 'product_info', 'OK'),
  ('19250', 'last_update', '1759520849'),
  ('19251', 'product_info', 'Product data not found ...yes, I looked'),
  ('19251', 'last_update', '1859520849');

字符串

查询View on DB Fiddle

SELECT post_id,
       MAX(CASE meta_key WHEN 'product_info' THEN meta_value END) product_info,
       MAX(CASE meta_key WHEN 'last_update' THEN meta_value END) last_update
FROM wp_postmeta
GROUP BY post_id
HAVING MAX(CASE meta_key WHEN 'product_info' THEN meta_value END) LIKE '%Product data not found%'
ORDER BY last_update;

型
| 发布标识|产品信息|最后更新|
| --|--|--|
| 19249 |未找到此产品数据| 1659520849 |
| 19251 |没有找到产品数据.是的，我看了| 1859520849 |
| 19248 |在任何地方都找不到产品数据| 1959520849 |
我之前就透视表给出的一些相关建议：

• 可能的复制目标候选：Select user having qualifying data on multiple rows in the wp_usermeta table
• How to add 2 columns with same id in 1 array in php?
• Display data from mysql columns as rows in PHP的
• Need help writing SQL SELECT statement that combines two tables的
• How to retrieve RSForm submission data grouped by SubmissionId?
• Return FieldValue Where FieldName Equals Value and ID Equals Number
• MySql SELECT multiple according to form input and publish字符串
• Roles and permissions in php
• Left Join multiple times 2 tables using same column ON
• How to get sum of same value and different value in same row?
• Group query result data by column and set default values for all missing columns in each group
• Charts/Graphs for RSFORM using mysql for VChart and/or PlotaLot
• PlotALOT RSForm Query showing only one result