Advanced Custom Fields - get_post_id_from_repeater_sub_field

gistfile1.txt

function get_post_id_from_repeater_sub_field($parent_name, $child_name, $meta_value){
  global $wpdb;
  $rows = $wpdb->get_results($wpdb->prepare( 
      "
      SELECT wp_posts.ID
      FROM wp_postmeta
      JOIN wp_posts
      ON wp_postmeta.post_id=wp_posts.ID
      WHERE wp_postmeta.meta_key LIKE %s
          AND wp_postmeta.meta_value = %s
          AND wp_posts.post_type != 'revision'
      ",
      $parent_name."_%_".$child_name, // meta_name: $ParentName_$RowNumber_$ChildName
      $meta_value // meta_value: 'type_3' for example
  ));
  return $rows[0]->ID;
}