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 (17483,17477,17474,17471,17468,17462,17388,17378,17368,17358,17348,17338,17328,17307,17269,17257,17247,17233,17221,17203,17193,17183,17167,17156,17146,17136,17122,17110,17103,17098,17095,17092,17080,17075,17059,17057,17054,17049,17038,17027,17022,17017,17009,17004,16991,16978,16968,16951,16941,16926,16918,16908,16897,16872,16857,16830,16825,16820,16805,16798,16786,16770,16760,16749,16739,16729,16718,16708,16697,16687,16677,16667,16657,16647,16637,16627,16617,16607,16597,16549,16432,16422,16412,16402,16392,16382,16372,16362,16352,16324,16314,16304,16294,16284,16274,16260,16257,16254,16251,16248,16245,16242,16240,16237,16206,16182,16172,16162,16145,16132,16122,16108,16098,16088,16014,15982,15962,15952,15942,15932,15922,15912,15902,15891,15881,15871,15830,15820,15810,15790,15769,15758,15752,15745,15739,15733,15727,15721,15711,15709,15703,15691,15685,15668,15658,15648,15638,15628,15618,15608,15598,15588,15578,15568,15558,15548,15538,15528,15518,15508,15498,15488,15478,15468,15458,15448,15438,15428,15418,15408,15398,15388,15378,15368,15358,15348,15338,15328,15318,15308,15298,15288,15278,15268,15258,15248,15238,15228,15072,15057,15042,15036,15030,15024,15016,15009,15002,14996,14990,14984,14978,14972,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,14368,14355,14348,14335,14315,14313,14305,14297,14271,14249,14228,14220,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,13688,13682,13676,13658,13651,13639,13633,13627,13625,13619,13604,13586,13576,13574,13568,13558,13550,13543,13533,13521,13513,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,8359,8360,8354,8355,8356,8357,8349,8350,8351,8352,8344,8345,8346,8347,8348,8341,8342,8343,8340,8227,8228,8229,8230,8224,8225,8226,8222,8223,8218,8219,8220,8221,8217,8009,8010,8011,8004,8005,8006,8007,8008,8003,7999,8000,8001,8002,7995,7996,7997,7998,7990,7991,7992,7993,7994,7987,7988,7989,7790,7791,7792,7787,7788,7789,7782,7784,7785,7778,7779,7780,7781,7775,7776,7777,7773,7769,7771,7765,7767,7762,7760,7520,7521,7517,7518,7519,7515,7516,7513,7514,7509,7510,7511,7512,7504,7505,7506,7507,7508,7501,7502,7503,7499,7500,7497,7498,7494,7495,7496,7490,7491,7492,7493,7486,7487,7488,7489,7485,7337,7338,7335,7336,7331,7332,7333,7334,7326,7328,7329,7330,7324,7325,7046,7047,7048,7043,7044,7045,7042,7041,7038,7039,7040,7033,7034,7035,7036,7037,7029,7030,7031,7032,7027,7028,7024,7025,7026,7021,7022,7023,7016,7017,7018,7019,7020,7011,7012,7013,7014,7015,7006,7007,7008,7009,7010,7001,7002,7003,7004,7005,6996,6997,6998,7000,6994,6995,6991,6992,6993,6986,6987,6988,6989,6990,6982,6983,6984,6985,6981,6743,6741,6742,6739,6740,6738,6583,6584,6585,6586,6578,6580,6581,6582,6573,6574,6575,6576,6577,6568,6569,6570,6566,6567,6565,6520,6521,6522,6523,6518,6519,6202,6199,6200,6201,6197,6198,6191,6192,6193,6194,6195,6196,6189,6190,6185,6186,6187,6188,6183,6184,6180,6181,6182,6175,6176,6177,6178,6179,6170,6171,6172,6173,6174,6167,6168,6169,6165,6166,6160,6161,6162,6163,6164,6159,4849,4850,4844,4845,4846,4847,4848,4843,4839,4840,4841,4842,4834,4835,4836,4837,4838,4830,4831,4832,4833,4827,4828,4829,4826,4597,4598,4599,4600,4592,4593,4594,4595,4596,4590,4591,4586,4587,4588,4589,4581,4582,4583,4584,4585,4580,4050,4051,4052,4053,4045,4046,4047,4048,4043,4044,4041,4037,4038,4039,4040,4035,4031,4033,4034,4026,4027,4028,4029,4023,4024,4025,4022,4017,4019,4020,4013,4014,4015,4016,4009,4011,4012,4006,4007,4008,4004,3999,3998,3991,3992,3986,3989,3981,3982,3984,3985,3977,3980,3739,3740,3737,3738,3736,3733,3734,3735,3728,3730,3731,3724,3725,3727,3722,3723,3713,3707,3496,3497,3498,3491,3492,3493,3494,3495,3486,3487,3488,3489,3483,3484,3485,3397,3398,3395,3396,3393,3394,3388,3389,3390,3391,3392,3383,3384,3385,3386,3387,3380,3381,3382,3379,3197,3198,3199,3192,3193,3194,3195,3196,3187,3188,3189,3190,3191,3185,3186,3184,2930,2931,2927,2928,2929,2925,2926,2921,2922,2923,2924,2917,2918,2919,2920,2916,2913,2914,2915,2908,2909,2910,2911,2912,2904,2905,2906,2907,2900,2901,2902,2903,2898,2899,2897,2596,2597,2590,2591,2592,2594,2595,2585,2586,2587,2588,2589,2584,2581,2582,2583,2578,2579,2580,2573,2574,2575,2576,2577,2568,2569,2570,2571,2572,2563,2564,2565,2566,2567,2559,2560,2561,2562,2553,2554,2422,2423,2424,2420,2421,2416,2417,2418,2419,2412,2413,2414,2415,2408,2409,2410,2411,2405,2406,2287,2286,2282,2283,2284,2285,2276,2277,2278,2279,2280,2281,2271,2272,2273,2274,2275,2270,2266,2267,2268,2269,2265,1975,1976,1977,1978,1979,1970,1971,1972,1973,1974,1969,1965,1966,1967,1968,1963,1964,1957,1958,1959,1960,1961,1962,1952,1953,1954,1955,1947,1948,1949,1950,1951,1941,1942,1943,1944,1945,1946,1936,1937,1938,1939,1940,1934,1935) 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 (195,196) ) 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' OR rs_posts.post_status = 'dp-rewrite-republish') GROUP BY rs_posts.ID ORDER BY rs_posts.post_title ASC LIMIT 0, 30