How to get SQL table data by multiple conditions?

Question

SQL

Can't get table data in WP, what did I write wrong?

SELECT `meta_value`
FROM {$wpdb->postmeta}
WHERE `post_id`={$post->ID}
AND `meta_key`={$post->meta_key}

meta_value - you need to get data from the
$wpdb->postmeta column - table name
post_id - if the post ID is equal
to meta_key - and if it is equal to the value So...

Answer 1

the first thing to do is to separately generate and display a request, after that, firstly, you will see what got there, and secondly, you can insert the script into the console or into the phpmyadmin and execute, maybe there is stupidly no such data there.
The output of errors and warnings is also needed so that it is clear in general what and where does not work correctly.