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) INNER JOIN rs_postmeta ON ( rs_posts.ID = rs_postmeta.post_id ) WHERE 1=1 AND rs_posts.ID IN (31344,31322,31317,31314,31311,31308,31305,31302,31297,31221,31219,31217,31215,31213,31211,31209,31207,31205,31203,31201,31199,31197,31195,31113,31100,31088,31076,31046,31031,31021,31001,30991,30981,30971,30941,30930,30910,30761,30751,30741,30731,30719,30709,30669,30668,30667,30665,30663,30661,30659,30653,30637,30615,30543,30541,30539,30537,30526,30515,30478,30462,30446,30410,30389,30379,30369,30359,30348,30338,30328,30244,30233,30222,30211,30152,30132,30117,30102,30081,29956,29945,29934,29924,29913,29902,29891,29879,29868,29858,29846,29835,29824,29813,29803,29791,29781,29734,29724,29714,29704,29694,29684,29674,29617,29597,29580,29550,29532,29522,29314,29310,29307,29305,29302,29299,29295,29292,29286,29080,29036,29034,29032,29029,29027,29025,29023,29021,29019,29017,29015,29013,29010,29008,29006,29003,29001,28999,28996,28994,28990,28988,28986,28984,28982,28980,28978,28976,28974,28944,28940,28923,28919,28908,28900,28893,28883,28876,28812,28788,28764,28752,28736,28710,28655,28565,28544,28532,28511,28495,28484,28463,28452,27995,27982,27972,27962,27952,27942,27932,27922,27912,27902,27892,27882,27871,27860,27778,27766,27756,27743,27732,27729,27721,27717,27713,27676,27666,27646,27631,27618,27611,27593,27583,27563,27553,27533,27523,27513,27503,26800,26799,26787,26773,26746,26726,26710,26694,26676,26605,26549,26539,26528,26508,26498,26488,26478,26466,26449,26439,26429,26419,26262,26252,26242,26209,26199,26189,26179,26169,26159,26055,23050,25779,25760,25419,24788,24778,24768,24656,24653,24651,24649,24636,24600,24540,24520,24421,23913,23889,23867,23844,23827,23816,23798,23734,23723,23713,23699,23689,23631,23621,23604,23587,23575,23553,23543,23541,23539,23537,23535,23533,23531,23520,23501,23481,23480,23466,23456,23425,23377,23367,23357,23333,23323,23313,23303,23293,23283,23273,23263,23253,23243,23233,23223,23213,23200,23190,23171,23170,23053,23030,23020,23010,22999,19047,22978,22934,22927,22923,22921,22919,22917,22906,22902,22894,22892,22890,22888,22886,22882,22880,22878,22876,22873,22871,22869,22826,22822,22767,22762,22758,22756,22750,22744,22740,22737,22647,22636,22623,22596,22586,22576,22558,22548,22540,22537,22535,22533,22531,22529,22527,22524,22506,22374,22364,22346,22308,22307,22297,22287,22277,21975,21967,21952,21937,21929,21922,21901,21840,21837,21225,21223,21808,21801,21794,21788,21756,21746,21731,21712,21711,21693,21683,21664,21663,21645,21638,21627,21614,21605,21577,21567,21557,21547,21537,21527,21515,21505,21477,21471,21457,21452,21450,21448,21435,21407,21397,21391,21388,21386,21384,21382,21380,21378,21367,21348,21346,21344,21308,21284,21279,21274,21266,21264,21257,21206,21203,21194,21190,21159,21155,21150,21146,21137,21131,21128,21124,21118,21114,21110,21105,21098,21093,21084,21075,21073,21070,21065,21054,21050,21045,21042,21037,21032,21027,21024,21019,21016,21011,21001,20995,20992,20988,20984,20979,20974,20971,20966,20960,20947,20943,20939,20935,20932,20928,20924,20920,20916,20912,20908,20903,20899,20895,20892,20887,20881,20875,20870,20865,20859,20842,20836,20834,20829,20825,20820,20808,20804,20799,20794,20789,20784,20779,20770,20768,20760,20756,20751,20727,20722,20717,20712,20710,20702,20699,20692,20690,20687,20685,20683,20669,20661,20658,20654,20648,20640,20638,20635,20626,20624,20619,20616,20613,20608,20604,20600,20597,20595,20594,20592,20590,20587,20585,20554,20552,20550,20548,20546,20544,20542,20526,20518,20516,20514,20512,20510,20495,20493,20491,20487,20485,20483,20459,20457,20455,20447,20445,20440,20437,20433,20429,20424,20420,20411,20406,20401,20396,20391,20386,20382,20378,20373,20368,20362,20357,20347,20342,20337,20328,20324,20320,20315,20313,20308,20300,20276,20272,20267,20263,20257,20253,20249,20228,20226,20218,20208,20184,20178,20162,20144,20130,20101,20099,20094,20086,20084,20053,20050,20014,20008,20003,20001,19994,19992,19988,19976,19970,19960,19956,19953,19948,19944,19918,19913,19905,19895,19841,19835,19827,19816,19808,19805,19778,19771,19769,19762,19753,19743,19738,19733,19728,19724,19720,19716,19711,19707,19702,19699,19694,19690,19686,19677,19674,19669,19658,19656,19649,19647,19642,19636,19628,19626,19621,19616,19611,19607,19604,19599,19593,19590,19585,19580,19573,19570,19567,19564,19558,19555,19550,19545,19541,19534,19526,19520,19516,19512,19508,19505,19499,19497,19493,19489,19486,19480,19477,19471,19466,19444,19439,19434,19428,19426,19421,19379,19374,19364,19362,19360,19358,19356,19340,19336,19332,19328,19322,19317,19314,19310,19308,19304,19302,19299,19293,19266,19263,19261,19259,19257,19255,19253,19243,19233,19223,19213,19203,19193,19183,19144,19132,19122,19108,19095,19081,19071,19057,19033,19022,19010,18995,18981,18971,18942,18931,18929,18926,18909,18896,18872,18866,18864,18860,18846,18815,18813,18808,18802,18800,18792,18786,18784,18779,18769,18764,18759,18757,18752,18743,18738,18732,18727,18722,18719,18716,18711,18703,18695,18693,18688,18679,18674,18667,18662,18657,18653,18648,18643,18638,18633,18628,18623,18617,18598,18593,18589,18583,18578,18573,18569,18561,18559,18554,18549,18543,18538,18533,18528,18523,18517,18514,18499,18492,18487,18465,18454,18452,18441,18435,18429,18427,18423,18418,18415,18412,18406,18395,18385,18369,18353,18351,18347,18343,18339,18335,18317,18312,18310,18307,18297,18292,18290,18285,18282,18278,18276,18273,18270,18266,18264,18243,18238,18214,18180,18178,18175,18144,18142,18128,18085,18082,18065,18060,18055,18051,18045,18041,18036,18031,18026,18023,18019,18015,18012,17996,17994,17992,17988,17974,17969,17961,17956,17954,17950,17948,17935,17919,17893,17877,17867,17851,17849,17844,17813,17808,17803,17660,17636,26112,17562,17547,17544,17529,17388,17378,17368,17358,17348,17338,17328,17307,17269,17257,17247,17233,17221,17203,17193,17183,17167,17156,17146,17110,17103,17092,17080,17027,17022,16872,16830,16798,16786,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,15721,15711,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,15030,15024,15009,15002,14996,14990,14978,14972,14961,14944,14937,14930,14924,14918,14911,14904,14898,14891,14882,14864,14854,14844,14834,14798,14768,14822,14812,14757,14750,14744,14735,14729,14723,14716,14702,14696,14689,14683,14676,14670,14664,14662,14645,14638,14636,14624,14615,14613,14592,14566,14556,14536,14526,14516,13346,14500,14490,14480,14470,14460,14453,14444,14437,14430,14423,14417,14411,14404,14397,14390,14382,14368,14348,14335,14315,14313,14305,14297,14249,14228,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,13604,13586,13576,13574,13568,13558,13550,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,8359,8360,8354,8355,8356,8357,8349,8350,8351,8352,8344,8345,8346,8347,8348,8341,8342,8343,8340,8227,8228,8229,8230,8222,8223,8224,8225,8226,8219,8220,8221,8218,8217,8009,8010,8011,8004,8005,8006,8007,8008,7999,8000,8001,8002,8003,7998,7995,7996,7997,7990,7991,7992,7993,7994,7987,7988,7989,7790,7791,7792,7788,7789,7787,7782,7784,7785,7779,7780,7781,7773,7775,7776,7777,7769,7771,7765,7767,7762,7760,7520,7521,7517,7518,7519,7515,7516,7513,7514,7509,7510,7511,7512,7507,7508,7504,7505,7506,7501,7502,7503,7499,7500,7497,7498,7494,7495,7496,7491,7492,7493,7490,7486,7487,7488,7489,7485,7337,7338,7331,7332,7333,7335,7336,7328,7329,7330,7326,7324,7325,7046,7047,7048,7042,7043,7044,7045,7041,7038,7039,7040,7036,7037,7033,7034,7035,7029,7030,7031,7032,7027,7028,7024,7025,7026,7021,7022,7023,7020,7016,7017,7018,7019,7011,7012,7013,7014,7015,7006,7007,7008,7009,7010,7004,7005,7001,7002,7003,6996,6997,6998,7000,6991,6992,6993,6994,6995,6987,6988,6989,6990,6986,6982,6983,6984,6985,6981,6743,6739,6740,6741,6742,6738,6583,6584,6585,6586,6578,6580,6581,6582,6573,6574,6575,6576,6577,6568,6569,6570,6566,6567,6565,6523,6520,6521,6522,6518,6519,6202,6197,6198,6199,6200,6201,6192,6193,6194,6195,6196,6191,6189,6190,6185,6186,6187,6188,6180,6181,6182,6183,6184,6176,6177,6178,6179,6175,6170,6171,6172,6173,6174,6165,6166,6167,6168,6169,6160,6161,6162,6163,6164,6159,4849,4850,4844,4845,4846,4847,4848,4839,4840,4841,4842,4843,4836,4837,4838,4834,4835,4830,4831,4832,4833,4827,4828,4829,4826,4597,4598,4599,4600,4595,4596,4592,4593,4594,4590,4591,4586,4587,4588,4589,4581,4582,4583,4584,4585,4580,4053,4050,4051,4052,4045,4046,4047,4048,4041,4043,4044,4037,4038,4039,4040,4035,4034,4031,4033,4026,4027,4028,4029,4022,4023,4024,4025,4017,4019,4020,4014,4015,4016,4013,4009,4011,4012,4006,4007,4008,4004,3998,3999,3991,3992,3986,3989,3984,3985,3981,3982,3977,3980,3739,3740,3737,3738,3733,3734,3735,3736,3728,3730,3731,3727,3724,3725,3722,3723,3716,3713,3707,3496,3497,3498,3491,3492,3493,3494,3495,3489,3486,3487,3488,3483,3484,3485,3397,3398,3393,3394,3395,3396,3389,3390,3391,3392,3388,3383,3384,3385,3386,3387,3380,3381,3382,3379,3197,3198,3199,3194,3195,3196,3192,3193,3187,3188,3189,3190,3191,3185,3186,3184,2930,2931,2927,2928,2929,2926,2925,2921,2922,2923,2924,2917,2918,2919,2920,2913,2914,2915,2916,2910,2911,2912,2908,2909,2904,2905,2906,2907,2898,2899,2900,2901,2902,2903,2897,2596,2597,2595,2590,2591,2592,2593,2594,2585,2586,2587,2588,2589,2581,2582,2583,2584,2579,2580,2578,2574,2575,2576,2577,2568,2569,2570,2571,2572,2563,2564,2565,2566,2567,2562,2559,2560,2561,2553,2554,2422,2423,2424,2416,2417,2418,2419,2420,2421,2414,2415,2412,2413,2408,2409,2410,2411,2405,2406,2287,2282,2283,2284,2285,2286,2280,2281,2276,2277,2278,2279,2271,2272,2273,2274,2275,2266,2267,2268,2269,2270,2265,1979,1975,1976,1977,1978,1970,1971,1972,1973,1974,1965,1966,1967,1968,1969,1963,1964,1957,1958,1959,1960,1961,1962,1952,1953,1954,1955,1947,1948,1949,1950,1951,1946,1941,1942,1943,1944,1945,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 (271,244,270,196,195,15) ) AND rs_term_relationships.term_taxonomy_id IN (34) ) AND ( ( rs_postmeta.meta_key = 'hidden_product' AND rs_postmeta.meta_value = '0' ) OR ( rs_postmeta.meta_key = 'hidden_product' AND rs_postmeta.meta_value = '' ) ) 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.menu_order ASC, rs_posts.post_title ASC LIMIT 0, 60