CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_ec_table_booking_system ON cscart_ec_table_booking_system.product_id = products.product_id  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND cscart_categories.category_id IN (5684, 5699, 5709, 5750, 5791, 5824, 5849, 5873, 5885, 5916, 5935, 5955, 5987, 9032, 6056, 6088, 6118, 6149, 6177, 5732, 5739, 5751, 5766, 5776, 5788, 5799, 5810, 5954, 8565, 8585, 8591, 8597, 5820, 5830, 5846, 5854, 5867, 5875, 5913, 5919, 5934, 5980, 5990, 6004, 9049, 6018, 6032, 6044, 6078, 6107, 6129, 6144, 6161, 6182, 6200, 6339, 6216, 6257, 6301, 6352, 6378, 6417, 6467, 6514, 6532, 6589, 6402, 6422, 6440, 6528, 6652, 6734, 6781, 6823, 6906, 6987, 7058, 7185, 7361, 7398, 7598, 7629, 7647, 7653, 7666, 7673, 7679, 9034, 7725, 7818, 7829, 7854, 7897, 7958, 7991, 8011, 8019, 8044, 8056, 8071, 9036, 7886, 7903, 7912, 7951, 8012, 8020, 8041, 8054, 8088, 8106, 8111, 8149, 8165, 8174, 8185, 8200, 8207, 8215, 8227, 8089, 8141, 8161, 8172, 8176, 8192, 8253, 8262, 8273, 8278, 8287, 8307, 8340, 8352, 8360, 8282, 8289, 8311, 8366, 8378, 8391, 8405, 8373, 8386, 8401, 8408, 8417, 8423, 8524, 8526, 8531, 8541, 8542, 8566, 8575, 8577, 8589, 8600, 8613, 9039, 8513, 8525, 8529, 8532, 8534, 8537, 8543, 8548, 8538, 8540, 8645, 8651, 8661, 8666, 8676, 8687, 8696, 8708, 8734, 8737, 8740, 8746, 8751, 8756, 8761, 8764, 8544, 8547, 8551, 8555, 8558, 8560, 8564, 8569, 8571, 8582, 8587, 8592, 8594, 8598, 8606, 8609, 8552, 8556, 8624, 8267, 8627, 8650, 8667, 8674, 8680, 8688, 8700, 8704, 8707, 8711, 8714, 8736, 8745, 8749, 8759, 8765, 8770, 8772, 8773, 8775, 8776, 8778, 8779, 8780, 8781, 8640, 7745, 6536, 6552, 6582, 6616, 6660, 6691, 6730, 6773, 6806, 6835, 6859, 6890, 6917, 6955, 6988, 7019, 7064, 7126, 7166, 7206, 7245, 7277, 7303, 7324, 7365, 7568, 7579, 7588, 7599, 7611, 7625, 7635, 7641, 7648, 7657, 7665, 7675, 7682, 7716, 7723, 7731, 7737, 7744, 7753, 7770, 7775, 7788, 7793, 7843, 7851, 7746, 7752, 8155, 8171, 8183, 7767, 7773, 7786, 7799, 7813, 7823, 7833, 7842, 7856, 7805, 8279, 8305, 8316, 8322, 8337, 8371, 8429, 8438, 8456, 8461, 8462, 8468, 8471, 8472, 8475, 8477, 8480, 8485, 8489, 8499, 8501, 8502, 8580, 8586, 8596, 8604, 8503, 8507, 8508, 9099, 8491, 8494, 8497, 8514, 8545, 8621, 8735, 8631, 8637, 8554, 8671, 8675, 8679, 8743, 8753, 8755, 8767, 8683, 8685, 8691, 8562, 8646, 8648, 8658, 8662, 8522, 8695, 8699, 8705, 7888, 7902, 7914, 7960, 7983, 7994, 8010, 8018, 8040, 8058, 8069, 8075, 8100, 8109, 8135, 8144, 8160, 8169, 8177, 8188, 8199, 8205, 8212, 8221, 8254, 8266, 8276, 8288, 8306, 8312, 8321, 8328, 8341, 8349, 8357, 8359, 8385, 8390, 8395, 8406, 8412, 8418, 8427, 8433, 8441, 8506, 8517, 8521, 8527, 8535, 8546, 8553, 8559, 8568, 8573, 8579, 8583, 8590, 8599, 8603, 8607, 8611, 8616, 8622, 8629, 8634, 8639, 8643, 8653, 8657, 8664, 8689, 8693, 8739, 8741, 8744, 8750, 8738, 8742, 8747, 8752, 8754, 8757, 8760, 8768, 8771, 8774, 8777, 8758, 8762, 8763, 8766, 8769, 7896, 7910, 7950, 7963, 7985, 7996, 8016, 8037, 8057, 8070, 8077, 8102, 8108, 8134, 8145, 8159, 8167, 8179, 8191, 8206, 8217, 8250, 8263, 8272, 8286, 8302, 7993, 8047, 8067, 8087, 8101, 8138, 8162, 8170, 8182, 8196, 8203, 8216, 8194, 8204, 8218, 8260, 8274, 8339, 8353, 8256, 8268, 8281, 8290, 8309, 8315, 8320, 8329, 8335, 8345, 8317, 8326, 8336, 8346, 8351, 8008, 8046, 8098, 8400, 8419, 8059, 8110, 8154, 8195, 8258, 8187, 8201, 8210, 8228, 8261, 8275, 8334, 8364, 8380, 8313, 8318, 8323, 8330, 8344, 8350, 8358, 8365, 8374, 8435, 8443, 8451, 8454, 8457, 8355, 8361, 8370, 8375, 8381, 8382, 8387, 8388, 8389, 8403, 8410, 8414, 8425, 8434, 8392, 8398, 8404, 8411, 8421, 8428, 8432, 8437, 8444, 8450, 8446, 8458, 8460, 8464, 8470, 8473, 8356, 8362, 8397, 8440, 8445, 8482, 8498, 8504, 8511, 8516, 8530, 8536, 8439, 8486, 8496, 8520, 8533, 8567, 8572, 8578, 8581, 8588, 8539, 8549, 8561, 8570, 8576, 8584, 8593, 8601, 8612, 8617, 8626, 8595, 8602, 8608, 8610, 8615, 8619, 8614, 8618, 8623, 8630, 8633, 8655, 8659, 8663, 8669, 8673, 8678, 8681, 8694, 8698, 8701, 8625, 8632, 8635, 8641, 8644, 8647, 8649, 8652, 8656, 8660, 8665, 8668, 8672, 8677, 8682, 8686, 8690, 8692, 8697, 8703, 8710, 8713, 8717, 8720, 8722, 8725, 8728, 8709, 8712, 8716, 8719, 8723, 8724, 8727, 8729, 8730, 8426, 8442, 8447, 8453, 8455, 8459, 8463, 8469, 8474, 8476, 8478, 8479, 8481, 8483, 8484, 8487, 8488, 8490, 8492, 8493, 8495, 8500, 8505, 8510, 8512, 8515, 8518, 8519, 8523, 6540, 6556, 6578, 6603, 6617, 6653, 6676, 6724, 6754, 6787, 6832, 6869, 6926, 6957, 6986, 7014, 7071, 7219, 7278, 7297, 7339, 7351, 7375, 7544, 7546, 7549, 7550, 7553, 7557, 7560, 7564, 7567, 7573, 7576, 7583, 7589, 7594, 7600, 7608, 7612, 7643, 7669, 7674, 7724, 9056, 7729, 7736, 7774, 7782, 7789, 7791, 7796, 7804, 7814, 7820, 7826, 7832, 7840, 7846, 7852, 7885, 7892, 7900, 7907, 7915, 7952, 7961, 7969, 7988, 7995, 8009, 8014, 8022, 8042, 8055, 8073, 8086, 8096, 8103, 8107, 8128, 8133, 8142, 8148, 8158, 8164, 8166, 8173, 8180, 8186, 8189, 8202, 8208, 8211, 8224, 8251, 8259, 8265, 8271, 8284, 8291, 8303, 8310, 8314, 8319, 8327, 8332, 8343, 8348) AND companies.status IN ('A') AND products.company_id IN (1, 25, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 108, 109, 110, 111, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 196, 197, 198, 199, 200, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 263, 264, 266, 268, 269, 271, 272, 273, 276, 277, 278, 279, 280, 281, 282, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 377, 378, 379, 380, 381, 382, 383, 384, 385, 387, 388, 389, 391, 392, 393, 394, 395, 396, 397, 398, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 439, 440, 443, 445, 447, 448, 449, 450, 451, 452, 454, 455, 457, 458, 459, 460, 461, 462, 463, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 476, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 501, 503, 504, 505, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 518, 519, 520, 522, 524, 525, 526, 527, 528, 531, 532, 533, 535, 537, 539, 540, 541, 542, 543, 545, 546, 547, 548, 549, 550, 551, 553, 554, 556, 557, 558, 559, 560, 561, 562, 563, 564, 566, 567, 568, 569, 575, 576, 577, 579, 580, 582, 583, 585, 586, 587, 588, 590, 591, 592, 593, 594, 595, 596, 597, 598, 600, 602, 603, 604, 606, 607, 609, 610, 611, 613, 618, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 639, 641, 642, 643, 644, 646, 647, 649, 655, 660, 661, 662, 663, 665, 668, 669, 670, 671, 672, 673, 674, 675, 676, 678, 679, 680, 681, 682, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 707, 719, 0) AND products.company_id = 298  AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND products.company_id = 298  ORDER BY NULL