Hunter

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 (1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2405,2406,2408,2409,2410,2411,2412,2413,2414,2415,2416,2417,2418,2419,2420,2421,2422,2423,2424,2553,2554,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,2930,2931,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3483,3484,3485,3486,3487,3488,3489,3491,3492,3493,3494,3495,3496,3497,3498,3707,3713,3716,3722,3723,3724,3725,3727,3728,3730,3731,3733,3734,3735,3736,3737,3738,3739,3740,3977,3980,3981,3982,3984,3985,3986,3989,3991,3992,3998,3999,4004,4006,4007,4008,4009,4011,4012,4013,4014,4015,4016,4017,4019,4020,4022,4023,4024,4025,4026,4027,4028,4029,4031,4033,4034,4035,4037,4038,4039,4040,4041,4043,4044,4045,4046,4047,4048,4050,4051,4052,4053,4580,4581,4582,4583,4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4596,4597,4598,4599,4600,4826,4827,4828,4829,4830,4831,4832,4833,4834,4835,4836,4837,4838,4839,4840,4841,4842,4843,4844,4845,4846,4847,4848,4849,4850,6159,6160,6161,6162,6163,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,6176,6177,6178,6179,6180,6181,6182,6183,6184,6185,6186,6187,6188,6189,6190,6191,6192,6193,6194,6195,6196,6197,6198,6199,6200,6201,6202,6518,6519,6520,6521,6522,6523,6565,6566,6567,6568,6569,6570,6573,6574,6575,6576,6577,6578,6580,6581,6582,6583,6584,6585,6586,6738,6739,6740,6741,6742,6743,6981,6982,6983,6984,6985,6986,6987,6988,6989,6990,6991,6992,6993,6994,6995,6996,6997,6998,7000,7001,7002,7003,7004,7005,7006,7007,7008,7009,7010,7011,7012,7013,7014,7015,7016,7017,7018,7019,7020,7021,7022,7023,7024,7025,7026,7027,7028,7029,7030,7031,7032,7033,7034,7035,7036,7037,7038,7039,7040,7041,7042,7043,7044,7045,7046,7047,7048,7324,7325,7326,7328,7329,7330,7331,7332,7333,7334,7335,7336,7337,7338,7485,7486,7487,7488,7489,7490,7491,7492,7493,7494,7495,7496,7497,7498,7499,7500,7501,7502,7503,7504,7505,7506,7507,7508,7509,7510,7511,7512,7513,7514,7515,7516,7517,7518,7519,7520,7521,7760,7762,7765,7767,7769,7771,7773,7775,7776,7777,7778,7779,7780,7781,7782,7784,7785,7787,7788,7789,7790,7791,7792,7987,7988,7989,7990,7991,7992,7993,7994,7995,7996,7997,7998,7999,8000,8001,8002,8003,8004,8005,8006,8007,8008,8009,8010,8011,8217,8218,8219,8220,8221,8222,8223,8224,8225,8226,8227,8228,8229,8230,8340,8341,8342,8343,8344,8345,8346,8347,8348,8349,8350,8351,8352,8354,8355,8356,8357,8358,8359,8360,8506,8510,8511,8512,8857,8861,8865,8874,8878,8882,8910,8925,8930,8935,8959,8964,8973,8978,8989,8995,9009,9020,9027,9029,9031,9052,9093,9098,9103,9109,9114,9119,9125,9130,9135,9140,9146,9151,9156,9161,9166,9171,9176,9272,9279,9286,9303,9310,9317,9352,9362,9372,9382,9392,13315,13326,13346,13358,13383,13401,13503,13513,13521,13533,13543,13550,13558,13568,13574,13576,13586,13604,13619,13625,13627,13633,13639,13651,13658,13676,13682,13688,13745,13759,13771,13783,13795,13807,13820,13832,13844,13860,13873,13885,13897,13910,13923,13936,13948,13960,13972,13984,13996,14020,14055,14067,14080,14092,14105,14117,14135,14147,14199,14210,14220,14228,14249,14271,14297,14305,14313,14315,14335,14348,14355,14368,14382,14390,14397,14404,14411,14417,14423,14430,14437,14444,14453,14460,14470,14480,14490,14500,14516,14526,14536,14556,14566,14592,14607,14613,14615,14624,14626,14636,14638,14645,14655,14662,14664,14670,14676,14683,14689,14696,14702,14716,14723,14729,14735,14744,14750,14757,14768,14798,14812,14822,14834,14844,14854,14864,14882,14891,14898,14904,14911,14918,14924,14930,14937,14944,14961,14972,14978,14984,14990,14996,15002,15009,15024,15030,15036,15042,15057,15072,15228,15238,15248,15258,15268,15278,15288,15298,15308,15318,15328,15338,15348,15358,15368,15378,15388,15398,15408,15418,15428,15438,15448,15458,15468,15478,15488,15498,15508,15518,15528,15538,15548,15558,15568,15578,15588,15598,15608,15618,15628,15638,15648,15658,15668,15685,15691,15703,15711,15721,15727,15733,15739,15745,15752,15758,15769,15790,15810,15820,15830,15871,15881,15891,15902,15912,15922,15932,15942,15952,15962,15982,16014,16088,16098,16108,16122,16132,16145,16162,16172,16182,16206,16237,16240,16242,16245,16248,16251,16254,16257,16260,16274,16284,16294,16304,16314,16324,16352,16362,16372,16382,16392,16402,16412,16422,16432,16549,16597,16607,16617,16627,16637,16647,16657,16667,16677,16687,16697,16708,16718,16729,16739,16749,16760,16786,16798,16805,16820,16825,16830,16857,16872,16897,16908,16926,16941,16951,16968,16978,17004,17017,17022,17027,17038,17049,17054,17057,17080,17092,17095,17098,17103,17110,17122,17146,17156,17167,17183,17193,17203,17221,17233,17247,17257,17269,17307,17328,17338,17348,17358,17368,17378,17388,17462,17468,17471,17474,17483,17529,17544,17547,17562,17602,17605,17608,17610,17616,17619,17624,17627,17632,17636,17645,17652,17655,17660,17664,17667,17672,17675,17677,17693,17702,17726,17731,17734,17742,17754,17759,17762,17764,17768,17771,17774,17779,17784,17788,17794,17799,17803,17808,17813,17818,17844,17849,17851,17867,17877,17893,17919,17924,17935,17945,17948,17950,17954,17956,17961,17969,17974,17988,17992,17994,17996,18001,18012,18015,18019,18023,18026,18031,18036,18041,18045,18048,18051,18055,18060,18065,18082,18085,18128,18142,18144,18146,18151,18175,18178,18180,18209,18214,18238,18243,18264,18266,18270,18273,18276,18278,18282,18285,18290,18292,18297,18307,18310,18312,18317,18327,18331,18335,18339,18343,18347,18351,18353,18369,18385,18395,18406,18409,18412,18415,18418,18423,18427,18429,18435,18441,18445,18452,18454,18463,18465,18487,18492,18499,18514,18517,18523,18528,18533,18538,18543,18549,18554,18559,18561,18569,18573,18578,18583,18589,18593,18598,18600,18609,18611,18617,18623,18628,18633,18638,18643,18648,18653,18657,18662,18667,18672,18674,18679,18688,18693,18695,18703,18705,18711,18716,18719,18722,18727,18732,18738,18743,18752,18757,18759,18764,18769,18779,18784,18786,18792,18795,18800,18802,18808,18813,18815,18846,18860,18864,18866,18872,18896,18909,18926,18929,18931,18942,18971,18981,18995,19010,19022,19033,19047,19057,19071,19081,19095,19108,19122,19132,19144,19183,19193,19203,19213,19223,19233,19243,19253,19255,19257,19259,19261,19263,19266,19288,19293,19299,19302,19304,19308,19310,19314,19317,19322,19326,19328,19332,19336,19340,19356,19358,19360,19362,19364,19369,19374,19379,19414,19416,19421,19426,19428,19434,19439,19444,19466,19471,19477,19480,19486,19489,19493,19497,19499,19505,19508,19512,19516,19520,19526,19534,19541,19545,19550,19555,19558,19564,19567,19570,19573,19580,19585,19590,19593,19599,19604,19607,19611,19616,19621,19626,19628,19636,19642,19647,19649,19656,19658,19669,19674,19677,19681,19686,19690,19694,19699,19702,19707,19711,19716,19720,19724,19728,19733,19738,19743,19753,19762,19769,19771,19778,19805,19808,19816,19827,19835,19841,19881,19887,19895,19905,19913,19918,19937,19944,19948,19953,19956,19960,19970,19976,19978,19988,19992,19994,20001,20003,20008,20014,20050,20053,20084,20086,20094,20099,20101,20130,20141,20144,20162,20178,20184,20208,20218,20226,20228,20249,20253,20257,20263,20267,20272,20276,20281,20286,20290,20295,20300,20308,20313,20315,20320,20324,20328,20330,20337,20342,20347,20349,20357,20362,20368,20373,20378,20382,20386,20391,20396,20401,20406,20411,20416,20420,20424,20429,20433,20437,20440,20445,20447,20455,20457,20459,20481,20483,20485,20487,20489,20491,20493,20495,20510,20512,20514,20516,20518,20526,20542,20544,20546,20548,20550,20552,20554,20585,20587,20590,20592,20594,20595,20597,20600,20602,20604,20608,20613,20616,20619,20624,20626,20631,20635,20638,20640,20648,20654,20658,20661,20664,20666,20669,20675,20683,20685,20687,20690,20692,20699,20702,20710,20712,20717,20722,20727,20732,20751,20756,20760,20768,20770,20779,20784,20789,20794,20799,20804,20808,20820,20825,20829,20834,20836,20842,20859,20865,20870,20875,20879,20881,20887,20892,20895,20899,20903,20908,20912,20916,20920,20924,20928,20932,20935,20939,20943,20947,20960,20966,20971,20974,20979,20984,20988,20992,20995,21001,21011,21016,21019,21024,21027,21032,21037,21042,21045,21050,21054,21060,21065,21070,21073,21075,21079,21084,21093,21098,21101,21105,21110,21114,21118,21124,21128,21131,21137,21142,21146,21150,21155,21159,21164,21166,21190,21194,21203,21206,21223,21225,21227,21257,21264,21266,21274,21279,21284,21308,21344,21346,21348,21367,21378,21380,21382,21384,21386,21388,21391,21397,21407,21435,21448,21450,21452,21457,21471,21477,21505,21515,21527,21537,21547,21557,21567,21577,21605,21614,21627,21638,21645,21663,21664,21683,21693,21711,21712,21731,21746,21756,21772,21779,21784,21788,21794,21801,21808,21810,21820,21837,21840,21889,21892,21894,21897,21899,21901,21903,21922,21929,21937,21945,21952,21960,21967,21975,22052,22060,22128,22131,22142,22144,22149,22156,22161,22179,22184,22200,22221,22233,22277,22287,22297,22307,22308,22346,22364,22374,22506,22524,22527,22529,22531,22533,22535,22537,22540,22548,22558,22576,22586,22596,22623,22636,22647,22732,22737,22740,22744,22747,22750,22756,22758,22762,22767,22822,22826,22869,22871,22873,22876,22878,22880,22882,22886,22888,22890,22892,22894,22902,22906,22917,22919,22921,22923,22927,22934,22948,22978,22999,23010,23020,23030,23050,23053,23170,23171,23190,23200,23213,23223,23233,23243,23253,23263,23273,23283,23293,23303,23313,23323,23333,23347,23357,23367,23377,23425,23456,23466,23480,23481,23501,23520,23531,23533,23535,23537,23539,23541,23543,23553,23563,23575,23587,23604,23621,23631,23689,23699,23713,23723,23734,23798,23816,23827,23844,23867,23889,23913,24140,24421,24520,24540,24600,24636,24649,24651,24653,24656,24768,24778,24788,24847,25419,25760,25779,26055,26112,26113,26159,26169,26179,26189,26199,26209,26219,26242,26252,26262,26419,26429,26439,26449,26466,26478,26488,26498,26508,26518,26528,26539,26549,26605,26676,26694,26710,26726,26746,26773,26787,26799,26800,27503,27513,27523,27533,27553,27563,27583,27593,27611,27618,27631,27646,27666,27676,27713,27717,27721,27729,27732,27743,27756,27766,27778,27860,27871,27882,27892,27902,27912,27922,27932,27942,27952,27962,27972,27982,27995,28452,28463,28484,28495,28511,28532,28544,28565,28655,28671,28710,28736,28752,28764,28788,28812,28876,28883,28893,28900,28908,28919,28923,28940,28944,28974,28976,28978,28980,28982,28984,28986,28988,28990,28994,28996,28999,29001,29003,29006,29008,29010,29013,29015,29017,29019,29021,29023,29025,29027,29029,29032,29034,29036,29080,29286,29292,29295,29299,29302,29305,29307,29310,29314,29360,29522,29532,29550,29580,29597,29617,29674,29684,29694,29704,29714,29724,29734,29781,29791,29803,29813,29824,29835,29846,29858,29868,29879,29891,29902,29913,29924,29934,29945,29956,30081,30102,30117,30132,30152,30211,30222,30233,30244,30328,30338,30348,30359,30369,30379,30389,30410,30446,30462,30478,30515,30526,30537,30539,30541,30543,30615,30637,30653,30659,30661,30663,30665,30667,30668,30669,30709,30719,30731,30741,30751,30761,30910,30930,30941,30971,30981,30991,31001,31021,31031,31046,31076,31088,31100,31113,31195,31197,31199,31201,31203,31205,31207,31209,31211,31213,31215,31217,31219,31221,31297,31302,31305,31308,31311,31314,31317,31322,31344,31404,31415,31424,31433,31442,31451) AND ( rs_posts.ID NOT IN ( SELECT object_id FROM rs_term_relationships WHERE term_taxonomy_id IN (271,244,270,196,108,195,15) ) AND rs_term_relationships.term_taxonomy_id IN (43) ) 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.post_title ASC LIMIT 0, 60