我有两个复选框,用于确定活动的最小和最大人员容量范围。例如:0到100、100到200,依此类推。我需要用元查询过滤它们,但目前它似乎不起作用。
array (
\'sort_0\' =>
array (
\'key\' => \'_featured\',
\'type\' => \'CHAR\',
),
\'sort_1\' =>
array (
\'key\' => \'_claimed\',
\'type\' => \'CHAR\',
),
0 =>
array (
\'key\' => \'_min_acik_davet_alani\',
\'value\' =>
array (
0 => \'\',
),
\'compare\' => \'NOT IN\',
),
1 =>
array (
\'key\' => \'_max_acik_davet_alani\',
\'value\' =>
array (
0 => \'\',
),
\'compare\' => \'NOT IN\',
),
2 =>
array (
\'relation\' => \'OR\',
0 =>
array (
0 =>
array (
\'key\' => \'_min_kapali_davet_alani\',
\'value\' => 100,
\'type\' => \'NUMERIC\',
\'compare\' => \'>=\',
),
1 =>
array (
\'key\' => \'_max_kapali_davet_alani\',
\'value\' => 200,
\'type\' => \'NUMERIC\',
\'compare\' => \'<=\',
),
),
1 =>
array (
0 =>
array (
\'key\' => \'_min_kapali_davet_alani\',
\'value\' => 200,
\'type\' => \'NUMERIC\',
\'compare\' => \'>=\',
),
1 =>
array (
\'key\' => \'_max_kapali_davet_alani\',
\'value\' => 300,
\'type\' => \'NUMERIC\',
\'compare\' => \'<=\',
),
),
2 =>
array (
0 =>
array (
\'key\' => \'_min_kapali_davet_alani\',
\'value\' => 300,
\'type\' => \'NUMERIC\',
\'compare\' => \'>=\',
),
1 =>
array (
\'key\' => \'_max_kapali_davet_alani\',
\'value\' => 400,
\'type\' => \'NUMERIC\',
\'compare\' => \'<=\',
),
),
),
)
这是;meta\\u键;输入Wp\\U查询参数。我尝试过滤此阵列的2个索引中的容量,可以同时选择0-100和300-400。考虑到未选择200-300。目前它不起作用。实际上,它在本地返回504错误,mysql过载并失败。我做错什么了吗?