How to add second condition in wordpress sql query?

Question

WordPress

There is a request:

$wpdb->get_results( "
  SELECT post_id from $wpdb->postmeta 
    WHERE meta_key = 'id_iiko_rovara' AND meta_value = '".$add_id_iico2."'", 
ARRAY_A );

It on ACF to a field searches for record id. How can I add a condition to search for another 1 acf field here?

Answer 1

$wpdb->get_results( "SELECT post_id from $wpdb->postmeta WHERE meta_key = 'id_iiko_rovara' AND meta_value = '".$add_id_iico2."' AND acf = '".$You_value."'", ARRAY_A);

Perhaps the answer lies in the question?
AND acf = '".$You_value."'
or I didn't understand what you piled up