Ticket #46281: bug.txt

Array
(
    [post_type] => product
    [posts_per_page] => -1
    [post_status] => publish
    [tax_query] => Array
        (
            [0] => Array
                (
                    [taxonomy] => product_cat
                    [field] => term_id
                    [terms] => Array ( [0] => Array ( [taxonomy] => product_cat [field] => term_id [terms] => Array ( [0] => 627 [1] => 549 [2] => 550 [3] => 626 [4] => 578 [5] => 624 [6] => 580 [7] => 546 [8] => 579 [9] => 583 [10] => 577 [11] => 582 [12] => 581 [13] => 548 [14] => 547 [15] => 471 [16] => 528 [17] => 533 [18] => 529 [19] => 530 [20] => 532 [21] => 531 [22] => 230 [23] => 512 [24] => 511 [25] => 513 [26] => 510 [27] => 514 [28] => 219 [29] => 537 [30] => 534 [31] => 536 [32] => 535 [33] => 538 [34] => 231 [35] => 232 [36] => 515 [37] => 516 [38] => 518 [39] => 517 [40] => 220 [41] => 504 [42] => 506 [43] => 507 [44] => 503 [45] => 505 [46] => 222 [47] => 223 [48] => 137 [49] => 498 [50] => 496 [51] => 497 [52] => 224 [53] => 519 [54] => 226 [55] => 227 [56] => 228 [57] => 509 [58] => 508 [59] => 521 [60] => 229 [61] => 482 [62] => 481 [63] => 483 [64] => 539 [65] => 542 [66] => 541 [67] => 540 [68] => 221 [69] => 501 [70] => 502 [71] => 499 [72] => 500 [73] => 113 [74] => 126 [75] => 125 [76] => 119 [77] => 127 [78] => 114 [79] => 115 [80] => 116 [81] => 117 [82] => 118 [83] => 120 [84] => 121 [85] => 123 [86] => 122 [87] => 124 [88] => 128 [89] => 168 [90] => 163 [91] => 129 [92] => 165 [93] => 166 [94] => 167 [95] => 162 [96] => 164 [97] => 131 [98] => 158 [99] => 132 [100] => 159 [101] => 160 [102] => 134 [103] => 161 [104] => 138 [105] => 139 [106] => 140 [107] => 141 [108] => 133 [109] => 142 [110] => 143 [111] => 144 [112] => 145 [113] => 135 [114] => 146 [115] => 147 [116] => 148 [117] => 149 [118] => 150 [119] => 136 [120] => 151 [121] => 152 [122] => 153 [123] => 154 [124] => 155 [125] => 156 [126] => 157 [127] => 169 [128] => 130 [129] => 211 [130] => 212 [131] => 213 [132] => 215 [133] => 216 [134] => 217 [135] => 233 [136] => 234 [137] => 235 [138] => 236 [139] => 474 [140] => 171 [141] => 172 [142] => 173 [143] => 174 [144] => 175 [145] => 176 [146] => 177 [147] => 178 [148] => 179 [149] => 180 [150] => 181 [151] => 182 [152] => 544 [153] => 183 [154] => 186 [155] => 196 [156] => 197 [157] => 198 [158] => 192 [159] => 193 [160] => 194 [161] => 195 [162] => 201 [163] => 210 [164] => 242 [165] => 247 [166] => 248 [167] => 249 [168] => 243 [169] => 244 [170] => 245 [171] => 246 [172] => 473 [173] => 214 [174] => 187 [175] => 191 [176] => 188 [177] => 189 [178] => 190 [179] => 199 [180] => 209 [181] => 543 [182] => 185 [183] => 184 [184] => 202 [185] => 203 [186] => 204 [187] => 205 [188] => 200 [189] => 206 [190] => 207 [191] => 208 [192] => 472 ),
                     [operator] => NOT IN
                )

        )

)

$query->request
(Eg 239 is in array, which shouldn't)

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,219,220,221,222,223,224,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,471,472,473,474,481,482,483,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,521,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,546,547,548,549,550,577,578,579,580,581,582,583,624,626,627) ) ) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC