(WordPress) get_player_stats()

function get_player_stats( $player_id ) {
    global $wpdb;

    $stats = [];

    $range = range( 1, 11 );
    $stats['apps'] = (int) $wpdb->get_var( $wpdb->prepare( "
        SELECT COUNT(pm.meta_id) FROM {$wpdb->postmeta} pm
            INNER JOIN {$wpdb->posts} p ON p.ID = pm.post_id
        WHERE pm.meta_key IN ('pl" . implode( "', 'pl", $range ) . "')
            AND pm.meta_value = %d
            AND p.post_type   = 'match'
            AND p.post_status = 'publish'
    ", $player_id ) );

    $range = range( 12, 18 );
    $stats['subs'] = (int) $wpdb->get_var( $wpdb->prepare( "
        SELECT COUNT(DISTINCT pm2.meta_key) FROM {$wpdb->postmeta} pm
            INNER JOIN {$wpdb->postmeta} pm2 ON pm2.post_id = pm.post_id
            INNER JOIN {$wpdb->posts} p ON p.ID = pm.post_id
        WHERE 1
            AND (
                pm.meta_key IN ('pl" . implode( "', 'pl", $range ) . "')
                AND pm.meta_value = %d
            )
            AND (
                pm2.meta_key IN ('si" . implode( "', 'si", $range ) . "')
                AND ( SUBSTR(pm2.meta_key, 3) = SUBSTR(pm.meta_key, 3) )
                AND pm2.meta_value+0 > 0
            )
            AND p.post_type   = 'match'
            AND p.post_status = 'publish'
    ", $player_id ) );

    $range = range( 1, 18 );
    $stats['goals'] = (int) $wpdb->get_var( $wpdb->prepare( "
        SELECT COUNT(pm.meta_id) FROM {$wpdb->postmeta} pm
            INNER JOIN {$wpdb->posts} p ON p.ID = pm.post_id
        WHERE pm.meta_key IN ('s" . implode( "', 's", $range ) . "')
            AND pm.meta_value = %d
            AND p.post_type   = 'match'
            AND p.post_status = 'publish'
    ", $player_id ) );

    return $stats;
}