Multi meta queries returns no results

Hi, laxmana.

Thank you for your testing.

Maybe a server / php restriction ?

As for max execution time, that could be. But we can’t make sure so far.

FTP and Admin Panel credentials

seems to be the last resort. I hope we can investigate some more details of the problem. You can contact me via email if necessary. Read the copyright notice in sqlite-integration.php. But I ask you not to expect the quick response.

I reconstructed the SQL statement from your dump data. I’d like to know if SQLite Integration rewrites the statement properly or not. So will you do another test, please?

Create a PHP script contains the code below and put it to WordPress installation directory. Then access the file with the browser. If it works, you can see if the PHP is set to safe mode or not and you can also see the rewritten query statement with the result of the executed query. The rewritten query statement is the very thing I’d like to know.

After finishing the test, don’t forget to remove this script from your sever.

Thanks a lot.

@steadybright
Thank you for your advice. I agree with you.

<?php
$mode = ini_get('safe_mode') ? 'safe mode' : 'normal mode';
if (strpos($mode, 'normal') !== false) {
    ini_set('max_execution_time', 60);
}
echo 'PHP is set to ' . $mode . '.<br />';
echo 'The value of the max_execution_time is set to ' . ini_get('max_execution_time');
echo '.<br /><br />';

// if you put this script to another directory, change the path below.
require_once('./wp-load');
require_once('./wp-content/plugins/sqlite-integration/query.class.php');

global $wpdb;
// reconstructed SQL statement
$sql =<<<END_OF_SQL
SELECT SQL_CALC_FOUND_ROWS
    $wpdb->posts.ID
FROM
    $wpdb->posts
INNER JOIN
    $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id)
INNER JOIN
    $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id)
INNER JOIN
    $wpdb->postmeta AS mt1 ON ($wpdb->posts.ID = mt1.post_id)
INNER JOIN
    $wpdb->postmeta AS mt2 ON ($wpdb->posts.ID = mt2.post_id)
WHERE
    1 = 1
AND
    ($wpdb->term_relationships.term_taxonomy_id IN (71))
AND
    $wpdb->posts.post_type = 'learner'
AND
    ($wpdb->posts.post_status = 'publish')
AND
    (($wpdb->postmeta.meta_key = 'rlp_learner_age' AND CAST($wpdb->postmeta.meta_value AS SIGNED) BETWEEN '0' AND '59')
    AND
        (mt1.meta_key = 'rlp_learner_placement_percent' AND CAST(mt1.meta_value AS SIGNED) BETWEEN '14' AND '100')
    AND
        (mt2.meta_key = 'rlp_learner_age_started_spanish' AND CAST(mt2.meta_value SIGNED) BETWEEN '0' AND '49'))
GROUP BY
    $wpdb->posts.ID
ORDER BY
    $wpdb->posts.ID ASC
LIMIT 0, 20
END_OF_SQL;

// check if SQLite Integration do the job properly or no
$engine = new PDOSQLiteDriver();
$rewritten_query = $engine->rewrite_query($sql, 'select');
echo 'This is the SQL statement rewritten by SQLite Integration:<br />';
echo $rewritten_query . '<br /><br />';

// do execute
$results = $wpdb->get_results($sql);
if ($results === false || empty($results)) {
    echo 'Nothing to display';
} else {
    foreach ($results as $result) {
        echo 'post ID = ' . $result->ID . '<br />';
    }
}
?>