How to get fast Wordpress data using wpdb->get_results

Question

Personal the code below it lists the results without repeating the post however need it to list containing the custom field with the following values:
meta_key "type"
meta_value "snack"

<?php
    global $wpdb, $table_prefix;
    $arquivos = $wpdb->get_results( '
        SELECT *
        FROM '.$table_prefix.'posts
        WHERE
            post_type = "arquivos"
            AND post_status = "publish"
        GROUP BY post_title
    ' );
?>
<?php foreach ( $arquivos as $key => $value ): ?>
    <?php echo $value->post_title ?>
<?php endforeach ?>

Answer 1

You can make this query using Wp_query

$args = array(
    'post_type' => 'arquivos',
    'post_status' => array('publish'),
    'meta_query' => array(
        array(
            'key'     => 'tipo',
            'value'   => 'lanche',
            'compare' => '=',
        ),
    ),
);

$arquivos = new WP_Query($args);
foreach ($arquivos as $key => $value){
    echo $value->post_title;
}