Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SQL_CALC_FOUND_ROWS
- wp_posts.ID
- FROM
- wp_posts
- LEFT JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id )
- INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
- WHERE
- 1 = 1
- AND (
- wp_term_relationships.term_taxonomy_id IN (
- 5753,
- 5754,
- 5815,
- 5823,
- 5829,
- 6385,
- 6386,
- 6387,
- 6388,
- 6389,
- 6390,
- 6391,
- 6392,
- 6393,
- 6394,
- 6395,
- 6396,
- 6397,
- 6398,
- 6399,
- 6400,
- 6401,
- 6402,
- 6403,
- 6404,
- 6405,
- 6406,
- 6407,
- 6408,
- 6409,
- 6410,
- 6411,
- 6412,
- 6414,
- 6415,
- 6416,
- 6418,
- 6419,
- 6421,
- 6422,
- 6423,
- 6424,
- 6425,
- 6426,
- 6428,
- 6429,
- 6432,
- 6433,
- 6435,
- 6437,
- 6448,
- 6449,
- 6451,
- 6456,
- 6458,
- 6459,
- 6461,
- 6462,
- 6463,
- 6468,
- 6482,
- 6485,
- 6486,
- 6488,
- 6489,
- 6490,
- 6491,
- 6492,
- 6493,
- 6494,
- 6495,
- 6496,
- 6497,
- 6498,
- 6508,
- 6513,
- 6516,
- 6518,
- 6519,
- 6520,
- 6522,
- 6523,
- 6524,
- 6525,
- 6526,
- 6527,
- 6528,
- 6529,
- 6530,
- 6531,
- 6592,
- 6599,
- 6600,
- 6601,
- 7239,
- 7255,
- 7256,
- 7257,
- 7258,
- 7259,
- 7260,
- 7261,
- 7262,
- 7263,
- 7264,
- 8177,
- 8179,
- 8183,
- 8185,
- 8187,
- 8188,
- 8191,
- 8192,
- 8194,
- 8195,
- 8197,
- 8198,
- 8199,
- 8200,
- 8201,
- 8202,
- 8206,
- 8211,
- 8213,
- 8215,
- 8219,
- 8224,
- 8225,
- 8226,
- 8234,
- 8238,
- 8242,
- 8244,
- 8247,
- 8248,
- 8250,
- 8258,
- 8260,
- 8267,
- 8269,
- 8270,
- 8272,
- 8274,
- 8275,
- 8277,
- 8280,
- 8282,
- 8284,
- 8286,
- 8288,
- 8292,
- 8294,
- 8296,
- 8298,
- 8300,
- 8302,
- 8304,
- 8306,
- 8308,
- 8336,
- 8338,
- 8341,
- 8344,
- 8346,
- 8349,
- 8351,
- 8353,
- 8355,
- 8357,
- 8359,
- 8361,
- 8363,
- 8365,
- 8368,
- 8369,
- 8371,
- 8372,
- 8374,
- 8377,
- 8379,
- 8380,
- 8383,
- 8386,
- 8396,
- 8398,
- 8400,
- 8401,
- 8404,
- 8406,
- 8408,
- 8413,
- 8414,
- 8415,
- 8416,
- 8417,
- 8419,
- 8420,
- 8421,
- 8423,
- 8427,
- 8430,
- 8432,
- 8434,
- 8436,
- 8438,
- 8440,
- 8441,
- 8443,
- 8445,
- 8447,
- 8449,
- 8450,
- 8452,
- 8454,
- 8455,
- 8457,
- 8458,
- 8459,
- 8461,
- 8463,
- 8466,
- 8471,
- 8472,
- 8474,
- 8476,
- 8477,
- 8479,
- 8481
- )
- AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN ( 7 ) )
- AND wp_term_relationships.term_taxonomy_id IN (
- 5753,
- 5754,
- 5815,
- 5823,
- 5829,
- 6385,
- 6386,
- 6387,
- 6388,
- 6389,
- 6390,
- 6391,
- 6392,
- 6393,
- 6394,
- 6395,
- 6396,
- 6397,
- 6398,
- 6399,
- 6400,
- 6401,
- 6402,
- 6403,
- 6404,
- 6405,
- 6406,
- 6407,
- 6408,
- 6409,
- 6410,
- 6411,
- 6412,
- 6414,
- 6415,
- 6416,
- 6418,
- 6419,
- 6421,
- 6422,
- 6423,
- 6424,
- 6425,
- 6426,
- 6428,
- 6429,
- 6432,
- 6433,
- 6435,
- 6437,
- 6448,
- 6449,
- 6451,
- 6456,
- 6458,
- 6459,
- 6461,
- 6462,
- 6463,
- 6468,
- 6482,
- 6485,
- 6486,
- 6488,
- 6489,
- 6490,
- 6491,
- 6492,
- 6493,
- 6494,
- 6495,
- 6496,
- 6497,
- 6498,
- 6508,
- 6513,
- 6516,
- 6518,
- 6519,
- 6520,
- 6522,
- 6523,
- 6524,
- 6525,
- 6526,
- 6527,
- 6528,
- 6529,
- 6530,
- 6531,
- 6592,
- 6599,
- 6600,
- 6601,
- 7239,
- 7255,
- 7256,
- 7257,
- 7258,
- 7259,
- 7260,
- 7261,
- 7262,
- 7263,
- 7264,
- 8177,
- 8179,
- 8183,
- 8185,
- 8187,
- 8188,
- 8191,
- 8192,
- 8194,
- 8195,
- 8197,
- 8198,
- 8199,
- 8200,
- 8201,
- 8202,
- 8206,
- 8211,
- 8213,
- 8215,
- 8219,
- 8224,
- 8225,
- 8226,
- 8234,
- 8238,
- 8242,
- 8244,
- 8247,
- 8248,
- 8250,
- 8258,
- 8260,
- 8267,
- 8269,
- 8270,
- 8272,
- 8274,
- 8275,
- 8277,
- 8280,
- 8282,
- 8284,
- 8286,
- 8288,
- 8292,
- 8294,
- 8296,
- 8298,
- 8300,
- 8302,
- 8304,
- 8306,
- 8308,
- 8336,
- 8338,
- 8341,
- 8344,
- 8346,
- 8349,
- 8351,
- 8353,
- 8355,
- 8357,
- 8359,
- 8361,
- 8363,
- 8365,
- 8368,
- 8369,
- 8371,
- 8372,
- 8374,
- 8377,
- 8379,
- 8380,
- 8383,
- 8386,
- 8396,
- 8398,
- 8400,
- 8401,
- 8404,
- 8406,
- 8408,
- 8413,
- 8414,
- 8415,
- 8416,
- 8417,
- 8419,
- 8420,
- 8421,
- 8423,
- 8427,
- 8430,
- 8432,
- 8434,
- 8436,
- 8438,
- 8440,
- 8441,
- 8443,
- 8445,
- 8447,
- 8449,
- 8450,
- 8452,
- 8454,
- 8455,
- 8457,
- 8458,
- 8459,
- 8461,
- 8463,
- 8466,
- 8471,
- 8472,
- 8474,
- 8476,
- 8477,
- 8479,
- 8481
- )
- AND wp_term_relationships.term_taxonomy_id IN (
- 5753,
- 5754,
- 5815,
- 5823,
- 5829,
- 6385,
- 6386,
- 6387,
- 6388,
- 6389,
- 6390,
- 6391,
- 6392,
- 6393,
- 6394,
- 6395,
- 6396,
- 6397,
- 6398,
- 6399,
- 6400,
- 6401,
- 6402,
- 6403,
- 6404,
- 6405,
- 6406,
- 6407,
- 6408,
- 6409,
- 6410,
- 6411,
- 6412,
- 6414,
- 6415,
- 6416,
- 6418,
- 6419,
- 6421,
- 6422,
- 6423,
- 6424,
- 6425,
- 6426,
- 6428,
- 6429,
- 6432,
- 6433,
- 6435,
- 6437,
- 6448,
- 6449,
- 6451,
- 6456,
- 6458,
- 6459,
- 6461,
- 6462,
- 6463,
- 6468,
- 6482,
- 6485,
- 6486,
- 6488,
- 6489,
- 6490,
- 6491,
- 6492,
- 6493,
- 6494,
- 6495,
- 6496,
- 6497,
- 6498,
- 6508,
- 6513,
- 6516,
- 6518,
- 6519,
- 6520,
- 6522,
- 6523,
- 6524,
- 6525,
- 6526,
- 6527,
- 6528,
- 6529,
- 6530,
- 6531,
- 6592,
- 6599,
- 6600,
- 6601,
- 7239,
- 7255,
- 7256,
- 7257,
- 7258,
- 7259,
- 7260,
- 7261,
- 7262,
- 7263,
- 7264,
- 8177,
- 8179,
- 8183,
- 8185,
- 8187,
- 8188,
- 8191,
- 8192,
- 8194,
- 8195,
- 8197,
- 8198,
- 8199,
- 8200,
- 8201,
- 8202,
- 8206,
- 8211,
- 8213,
- 8215,
- 8219,
- 8224,
- 8225,
- 8226,
- 8234,
- 8238,
- 8242,
- 8244,
- 8247,
- 8248,
- 8250,
- 8258,
- 8260,
- 8267,
- 8269,
- 8270,
- 8272,
- 8274,
- 8275,
- 8277,
- 8280,
- 8282,
- 8284,
- 8286,
- 8288,
- 8292,
- 8294,
- 8296,
- 8298,
- 8300,
- 8302,
- 8304,
- 8306,
- 8308,
- 8336,
- 8338,
- 8341,
- 8344,
- 8346,
- 8349,
- 8351,
- 8353,
- 8355,
- 8357,
- 8359,
- 8361,
- 8363,
- 8365,
- 8368,
- 8369,
- 8371,
- 8372,
- 8374,
- 8377,
- 8379,
- 8380,
- 8383,
- 8386,
- 8396,
- 8398,
- 8400,
- 8401,
- 8404,
- 8406,
- 8408,
- 8413,
- 8414,
- 8415,
- 8416,
- 8417,
- 8419,
- 8420,
- 8421,
- 8423,
- 8427,
- 8430,
- 8432,
- 8434,
- 8436,
- 8438,
- 8440,
- 8441,
- 8443,
- 8445,
- 8447,
- 8449,
- 8450,
- 8452,
- 8454,
- 8455,
- 8457,
- 8458,
- 8459,
- 8461,
- 8463,
- 8466,
- 8471,
- 8472,
- 8474,
- 8476,
- 8477,
- 8479,
- 8481
- )
- )
- AND ( wp_postmeta.meta_key = '_stock_status' )
- AND ((
- wp_posts.post_type = 'product'
- AND ( wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'wc-gls-sent' )))
- GROUP BY
- wp_posts.ID
- ORDER BY
- wp_postmeta.meta_value ASC
- LIMIT 0,
- 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement