我试图查询一个自定义帖子类型“jogos”，其中的元值“data\\u de\\u lancamento”（发布日期）为<；=该字段使用的格式为dd/mm/yy。

然后，从该查询返回的帖子必须按自定义字段“视图”降序排列。

我当前的代码是：

date_default_timezone_set(\'Europe/Lisbon\');
$data = date("d/m/y");
global $wpdb;

$sql = "SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta, $wpdb->postmeta wpostmeta2
WHERE wposts.ID = wpostmeta.post_id
AND wposts.ID = wpostmeta2.post_id
AND wpostmeta.meta_key = \'views\'
AND wpostmeta2.meta_key = \'data_de_lancamento\'
AND wpostmeta2.meta_value < $data
AND wposts.post_type = \'jogos\'
AND wposts.post_status = \'publish\'
ORDER BY wpostmeta.meta_value ASC";

$resultado = $wpdb->get_results($sql, OBJECT);