WordPress: SQL Query to retrieve results when meta_key like `modules%_module` and meta_value as a given value...

example.php

<?php
global $wpdb;

$myid = 157;
$views = $wpdb->get_results($wpdb->prepare(
    'SELECT p.ID
    FROM `wp_posts` as p
    LEFT JOIN `wp_postmeta` as m ON p.ID=m.post_id
    WHERE m.meta_id IN (
        SELECT meta_id FROM wp_postmeta
        WHERE  meta_key LIKE "modules%%_module"
    ) AND m.meta_value=%s', [$myid]
));

//$views contains all the posts ID which are linked to a meta_key named like `modules%_module` and with a value equal to $myid...
foreach ($views as $v) {
  $post = get_post($v->ID);
}

request.sql

SELECT p.ID
FROM `wp_posts` as p
LEFT JOIN `wp_postmeta` as m ON p.ID=m.post_id
WHERE m.meta_id IN (
    SELECT meta_id FROM wp_postmeta
    WHERE  meta_key LIKE "modules%_module"
  ) 
AND m.meta_value=157;