NewTribal

SELECT SQL_CALC_FOUND_ROWS rs_posts.ID FROM rs_posts LEFT JOIN rs_term_relationships ON (rs_posts.ID = rs_term_relationships.object_id) LEFT JOIN rs_term_relationships AS tt1 ON (rs_posts.ID = tt1.object_id) WHERE 1=1 AND rs_posts.ID IN (15042,15036,15030,15024,15016,15009,15002,14996,14990,14984,14978,14972,14966,14961,14954,14944,14937,14930,14924,14918,14911,14904,14898,14891,14882,14874,14864,14854,14844,14834,14798,14768,14822,14812,14757,14750,14744,14735,14729,14723,14716,14708,14702,14696,14689,14683,14676,14670,14662,14655,14645,14638,14636,14626,14624,14615,14613,14607,14592,14566,14556,14536,14526,14516,13346,14500,14490,14480,14470,14460,14453,14444,14437,14430,14423,14417,14411,14404,14397,14390,14382,14375,14368,14362,14355,14348,14335,14315,14313,14305,14297,14285,14271,14259,14257,14249,14241,14228,14220,14218,14210,14199,13745,14147,14135,14117,14105,14092,14080,14067,14055,14020,13996,13984,13972,13960,13948,13936,13923,13910,13897,13885,13873,13860,13844,13832,13820,13807,13795,13783,13771,13759,13704,13688,13682,13676,13664,13658,13651,13645,13633,13627,13625,13619,13604,13592,13586,13576,13574,13568,13558,13552,13550,13543,13533,13521,13513,13503,13401,13383,13358,13326,13315,9392,9382,9372,9362,9352,9317,9310,9303,8978,9286,9279,9272,9176,9171,9166,9161,9156,9151,9146,9140,9135,9130,9125,9119,9114,9109,9103,9098,9093,9052,9031,9029,9027,9020,9009,8995,8989,8973,8964,8959,8935,8930,8925,8910,8882,8878,8874,8865,8861,8857,8511,8510,8506,8512,8358,8360,8359,8357,8356,8355,8354,8352,8351,8350,8349,8348,8347,8346,8345,8344,8341,8343,8342,8340,8230,8229,8228,8227,8226,8225,8224,8223,8222,8221,8220,8219,8218,8217,8011,8010,8009,8005,8006,8008,8007,8004,8003,8002,8001,8000,7999,7998,7997,7996,7995,7993,7992,7991,7990,7994,7989,7988,7987,7792,7791,7790,7789,7788,7787,7785,7784,7782,7781,7780,7779,7777,7776,7775,7773,7771,7769,7767,7765,7762,7760,7521,7520,7518,7517,7519,7516,7515,7514,7513,7512,7511,7510,7509,7508,7507,7506,7505,7504,7502,7501,7503,7500,7499,7498,7497,7496,7495,7494,7493,7492,7491,7490,7486,7489,7488,7487,7485,7338,7337,7336,7335,7334,7333,7332,7331,7330,7329,7328,7327,7326,7324,7325,7047,7046,7045,7044,7043,7042,7041,7040,7039,7038,7037,7036,7035,7034,7033,7032,7031,7030,7029,7028,7027,7026,7025,7024,7023,7022,7021,7016,7020,7019,7018,7017,7015,7014,7013,7012,7011,7010,7009,7008,7007,7006,7005,7004,7003,7002,7001,7000,6998,6997,6996,6995,6994,6993,6992,6991,6990,6989,6988,6987,6986,6982,6984,6983,6981,6743,6742,6741,6740,6739,6738,6586,6585,6584,6583,6580,6578,6582,6581,6575,6574,6573,6577,6576,6570,6569,6568,6567,6566,6565,6523,6522,6521,6520,6519,6518,6202,6201,6200,6199,6198,6197,6195,6194,6193,6192,6191,6196,6190,6189,6188,6187,6186,6185,6184,6183,6182,6181,6180,6179,6178,6177,6176,6175,6174,6173,6172,6171,6170,6169,6168,6167,6166,6165,6163,6162,6161,6160,6164,6159,4850,4849,4848,4847,4846,4845,4844,4843,4842,4841,4839,4838,4837,4836,4835,4834,4833,4832,4831,4830,4829,4828,4827,4826,4597,4600,4599,4598,4596,4595,4594,4593,4592,4591,4590,4589,4588,4587,4586,4581,4585,4584,4583,4582,4580,4053,4052,4051,4050,4048,4047,4046,4045,4044,4043,4041,4037,4040,4039,4038,4035,4034,4031,4033,4029,4028,4027,4026,4025,4024,4023,4022,4020,4019,4017,4015,4014,4013,4016,4012,4011,4008,4007,4006,4004,3999,3998,3992,3991,3989,3986,3984,3982,3981,3985,3980,3977,3740,3739,3738,3737,3736,3735,3734,3733,3731,3730,3728,3727,3725,3724,3723,3722,3713,3707,3498,3497,3496,3495,3494,3493,3492,3491,3488,3487,3486,3489,3485,3484,3483,3398,3397,3396,3395,3394,3393,3388,3392,3391,3390,3389,3387,3386,3385,3384,3383,3382,3381,3380,3379,3199,3198,3197,3193,3192,3196,3195,3194,3191,3190,3189,3188,3187,3186,3185,3184,2931,2930,2929,2928,2927,2925,2926,2924,2923,2922,2921,2920,2919,2918,2917,2916,2915,2914,2913,2909,2908,2912,2911,2910,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2597,2596,2592,2591,2590,2595,2594,2589,2588,2587,2586,2585,2584,2583,2582,2581,2580,2579,2578,2575,2574,2573,2577,2576,2571,2570,2568,2569,2572,2563,2567,2566,2565,2564,2562,2561,2560,2559,2554,2553,2424,2423,2422,2421,2420,2419,2418,2417,2416,2415,2414,2413,2412,2408,2411,2410,2409,2406,2405,2287,2286,2285,2284,2283,2282,2281,2280,2279,2278,2277,2276,2274,2273,2272,2271,2275,2270,2269,2268,2267,2266,2265,1979,1978,1977,1976,1975,1970,1974,1973,1972,1971,1969,1968,1967,1966,1965,1964,1963,1962,1961,1960,1959,1958,1957,1952,1955,1954,1953,1951,1950,1949,1948,1947,1946,1945,1944,1943,1942,1941,1936,1940,1939,1938,1937,1935,1934) AND ( rs_posts.ID NOT IN ( SELECT object_id FROM rs_term_relationships WHERE term_taxonomy_id IN (7) ) AND rs_posts.ID NOT IN ( SELECT object_id FROM rs_term_relationships WHERE term_taxonomy_id IN (108) ) AND rs_term_relationships.term_taxonomy_id IN (34) AND tt1.term_taxonomy_id IN (186) ) AND rs_posts.post_type = 'product' AND (rs_posts.post_status = 'publish' OR rs_posts.post_status = 'acf-disabled') GROUP BY rs_posts.ID ORDER BY rs_posts.post_title ASC LIMIT 0, 30