Ask your WordPress questions! Pay money and get answers fast! Comodo Trusted Site Seal
Official PayPal Seal

VERY slow queries WordPress

Hi, I am on the MediaTemple GRID cloud platform and ran a slow query analyzer because my site is always crashing. I am on the PRO grid container: http://mediatemple.net/webhosting/shared/faq/. Is this enough RAM for MySQL? (256MB)

Here is the report (I need someone to help re-write these things too):


Created 02:50 PM 05/26/2015

### 30 Queries
### Total time: 297.728762, Average time: 9.92429206666667
### Taking 5.084637 to 20.528942 seconds to complete
### Rows analyzed 1 - 10739
# User@Host: dbXXX_sXXX[dbXXX_sXXX] @ [XXX.XXX.XXX.XXX]

# User@Host: db187284_s360[db187284_s360] @ [205.186.184.16]


### 10 Queries
### Total time: 109.596995, Average time: 10.9596995
### Taking 5.449744 , 6.025223 , 6.909657 , 7.142062 , 8.406788 , 8.719531 , 10.925700 , 15.783443 , 19.705905 , 20.528942 seconds to complete
### Rows analyzed 10723, 10723, 10723, 10737, 10737, 10739, 10739, 10739, 10739 and 10739
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 ) INNER JOIN wp_postmeta AS mtXXX ON ( wp_posts.ID = mtXXX.post_id ) WHERE XXX=XXX AND (
wp_term_relationships.term_taxonomy_id IN (XXX)
) AND (
wp_postmeta.meta_key = 'XXX'
AND
(
( mtXXX.meta_key = 'XXX' AND CAST(mtXXX.meta_value AS DATE) >= 'XXX' )
)
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+XXX ASC LIMIT XXX, XXX;

SET timestamp=1432665447;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (1495)
) AND (
wp_postmeta.meta_key = 'due'
AND
(
( mt1.meta_key = 'Due' AND CAST(mt1.meta_value AS DATE) >= '20150526' )
)
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 10, 10;


### 5 Queries
### Total time: 35.21181, Average time: 7.042362
### Taking 5.084637 , 5.395496 , 7.061999 , 7.150475 , 10.519203 seconds to complete
### Rows analyzed 802, 802, 845, 858 and 870
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 XXX=XXX AND (
wp_term_relationships.term_taxonomy_id IN (XXX)
) AND (
( wp_postmeta.meta_key = 'XXX' AND CAST(wp_postmeta.meta_value AS DATE) >= 'XXX' )
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT XXX, XXX;

SET timestamp=1432571057;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 (1488)
) AND (
( wp_postmeta.meta_key = 'Due' AND CAST(wp_postmeta.meta_value AS DATE) >= '20150525' )
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6;


### 3 Queries
### Total time: 29.944716, Average time: 9.981572
### Taking 5.731044 , 8.446265 , 15.767407 seconds to complete
### Rows analyzed 10678, 10684 and 10684
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 ) INNER JOIN wp_postmeta AS mtXXX ON ( wp_posts.ID = mtXXX.post_id ) WHERE XXX=XXX AND (
(
SELECT COUNT(XXX)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (XXX)
AND object_id = wp_posts.ID
) = XXX
AND
wp_term_relationships.term_taxonomy_id IN (XXX)
) AND (
wp_postmeta.meta_key = 'XXX'
AND
(
( mtXXX.meta_key = 'XXX' AND CAST(mtXXX.meta_value AS DATE) >= 'XXX' )
)
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+XXX ASC LIMIT XXX, XXX;

SET timestamp=1432590763;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (1493)
AND object_id = wp_posts.ID
) = 1
AND
wp_term_relationships.term_taxonomy_id IN (1495)
) AND (
wp_postmeta.meta_key = 'due'
AND
(
( mt1.meta_key = 'Due' AND CAST(mt1.meta_value AS DATE) >= '20150525' )
)
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 10, 10;


### 1 Query
### Total time: 27.489972, Average time: 27.489972
### Taking 27.489972 seconds to complete
### Rows analyzed 10557
# User@Host: dbXXX_st[dbXXX_st] @ [XXX.XXX.XXX.XXX]

# User@Host: db187284_st[db187284_st] @ [205.186.184.34]


### 1 Query
### Total time: 27.489972, Average time: 27.489972
### Taking 27.489972 seconds to complete
### Rows analyzed 10557
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 XXX=XXX AND (
wp_term_relationships.term_taxonomy_id IN (XXX)
) AND (
( wp_postmeta.meta_key = 'XXX' AND CAST(wp_postmeta.meta_value AS DATE) >= 'XXX' )
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX' OR wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT XXX, XXX;

SET timestamp=1432516284;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 (1484)
) AND (
( wp_postmeta.meta_key = 'Due' AND CAST(wp_postmeta.meta_value AS DATE) >= '20150525' )
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6;


### 2 Queries
### Total time: 24.712603, Average time: 12.3563015
### Taking 7.236489 , 17.476114 seconds to complete
### Rows analyzed 6030 and 6692
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS ttXXX ON (wp_posts.ID = ttXXX.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mtXXX ON ( wp_posts.ID = mtXXX.post_id ) WHERE XXX=XXX AND (
wp_term_relationships.term_taxonomy_id IN (XXX)
AND
ttXXX.term_taxonomy_id IN (XXX)
) AND (
wp_postmeta.meta_key = 'XXX'
AND
(
( mtXXX.meta_key = 'XXX' AND CAST(mtXXX.meta_value AS DATE) >= 'XXX' )
)
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+XXX ASC LIMIT XXX, XXX;

SET timestamp=1432585771;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (67)
AND
tt1.term_taxonomy_id IN (1495)
) AND (
wp_postmeta.meta_key = 'due'
AND
(
( mt1.meta_key = 'Due' AND CAST(mt1.meta_value AS DATE) >= '20150525' )
)
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 0, 10;


### 2 Queries
### Total time: 24.144582, Average time: 12.072291
### Taking 7.488504 , 16.656078 seconds to complete
### Rows analyzed 10567 and 10567
use dbXXX_sXXX;
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 XXX=XXX AND (
wp_term_relationships.term_taxonomy_id IN (XXX)
) AND (
( wp_postmeta.meta_key = 'XXX' AND CAST(wp_postmeta.meta_value AS DATE) >= 'XXX' )
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX' OR wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT XXX, XXX;

use db187284_s360;
SET timestamp=1432570318;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 (1484)
) AND (
( wp_postmeta.meta_key = 'Due' AND CAST(wp_postmeta.meta_value AS DATE) >= '20150525' )
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6;


### 1 Query
### Total time: 15.545233, Average time: 15.545233
### Taking 15.545233 seconds to complete
### Rows analyzed 6032
use dbXXX_sXXX;
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS ttXXX ON (wp_posts.ID = ttXXX.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mtXXX ON ( wp_posts.ID = mtXXX.post_id ) WHERE XXX=XXX AND (
wp_term_relationships.term_taxonomy_id IN (XXX)
AND
ttXXX.term_taxonomy_id IN (XXX)
) AND (
wp_postmeta.meta_key = 'XXX'
AND
(
( mtXXX.meta_key = 'XXX' AND CAST(mtXXX.meta_value AS DATE) >= 'XXX' )
)
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+XXX ASC LIMIT XXX, XXX;

use db187284_s360;
SET timestamp=1432633778;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (67)
AND
tt1.term_taxonomy_id IN (1495)
) AND (
wp_postmeta.meta_key = 'due'
AND
(
( mt1.meta_key = 'Due' AND CAST(mt1.meta_value AS DATE) >= '20150526' )
)
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 0, 10;


### 1 Query
### Total time: 10.9257, Average time: 10.9257
### Taking 10.925700 seconds to complete
### Rows analyzed 10739
# User@Host: root[root] @ localhost []

# User@Host: root[root] @ localhost []


### 1 Query
### Total time: 10.599573, Average time: 10.599573
### Taking 10.599573 seconds to complete
### Rows analyzed 971
use dbXXX_sXXX;
SET timestamp=XXX;
SELECT ID
FROM wp_posts
WHERE post_type = 'XXX'
AND post_mime_type LIKE 'XXX'
LIMIT XXX;

use db187284_s360;
SET timestamp=1432585733;
SELECT ID
FROM wp_posts
WHERE post_type = 'attachment'
AND post_mime_type LIKE 'audio%'
LIMIT 1;


### 1 Query
### Total time: 10.038711, Average time: 10.038711
### Taking 10.038711 seconds to complete
### Rows analyzed 25
SET timestamp=XXX;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('XXX', 'XXX', 'XXX', 'XXX', 'XXX') AND tr.object_id IN (XXX) ORDER BY t.name ASC;

SET timestamp=1432585814;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format', 'scholarship_category', 'resource_category') AND tr.object_id IN (10163) ORDER BY t.name ASC;


### 1 Query
### Total time: 9.98645, Average time: 9.98645
### Taking 9.986450 seconds to complete
### Rows analyzed 23
use mysql;
SET timestamp=XXX;
show tables;

use mysql;
SET timestamp=1432630825;
show tables;


### 1 Query
### Total time: 9.187543, Average time: 9.187543
### Taking 9.187543 seconds to complete
### Rows analyzed 6676
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS ttXXX ON (wp_posts.ID = ttXXX.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mtXXX ON ( wp_posts.ID = mtXXX.post_id ) WHERE XXX=XXX AND (
(
SELECT COUNT(XXX)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (XXX)
AND object_id = wp_posts.ID
) = XXX
AND
wp_term_relationships.term_taxonomy_id IN (XXX)
AND
ttXXX.term_taxonomy_id IN (XXX)
) AND (
wp_postmeta.meta_key = 'XXX'
AND
(
( mtXXX.meta_key = 'XXX' AND CAST(mtXXX.meta_value AS DATE) >= 'XXX' )
)
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+XXX ASC LIMIT XXX, XXX;

SET timestamp=1432580590;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (1491)
AND object_id = wp_posts.ID
) = 1
AND
wp_term_relationships.term_taxonomy_id IN (148)
AND
tt1.term_taxonomy_id IN (1495)
) AND (
wp_postmeta.meta_key = 'due'
AND
(
( mt1.meta_key = 'Due' AND CAST(mt1.meta_value AS DATE) >= '20150525' )
)
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 0, 10;


### 1 Query
### Total time: 8.768118, Average time: 8.768118
### Taking 8.768118 seconds to complete
### Rows analyzed 10739
use dbXXX_sXXX;
SET timestamp=XXX;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 ) INNER JOIN wp_postmeta AS mtXXX ON ( wp_posts.ID = mtXXX.post_id ) WHERE XXX=XXX AND (
wp_term_relationships.term_taxonomy_id IN (XXX)
) AND (
wp_postmeta.meta_key = 'XXX'
AND
(
( mtXXX.meta_key = 'XXX' AND CAST(mtXXX.meta_value AS DATE) >= 'XXX' )
)
) AND wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+XXX ASC LIMIT XXX, XXX;

use db187284_s360;
SET timestamp=1432620156;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER 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 ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (1495)
) AND (
wp_postmeta.meta_key = 'due'
AND
(
( mt1.meta_key = 'Due' AND CAST(mt1.meta_value AS DATE) >= '20150526' )
)
) AND wp_posts.post_type = 'scholarship' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 0, 10;


### 1 Query
### Total time: 7.735201, Average time: 7.735201
### Taking 7.735201 seconds to complete
### Rows analyzed 1
use dbXXX_sXXX;
SET timestamp=XXX;
SELECT wp_posts.ID FROM wp_posts WHERE XXX=XXX AND wp_posts.post_parent = XXX AND (wp_posts.post_mime_type LIKE 'XXX') AND wp_posts.post_type = 'XXX' AND ((wp_posts.post_status = 'XXX')) ORDER BY wp_posts.post_date DESC LIMIT XXX, XXX;

use db187284_s360;
SET timestamp=1432498209;
SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 3445 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.post_date DESC LIMIT 0, 5;


### 1 Query
### Total time: 7.504702, Average time: 7.504702
### Taking 7.504702 seconds to complete
### Rows analyzed 199
use dbXXX_st;
SET timestamp=XXX;
SELECT option_name, option_value FROM seamlessthemesoptions WHERE autoload = 'XXX';

use db187284_st;
SET timestamp=1432517468;
SELECT option_name, option_value FROM seamlessthemesoptions WHERE autoload = 'yes';


### 1 Query
### Total time: 6.074759, Average time: 6.074759
### Taking 6.074759 seconds to complete
### Rows analyzed 836
SET timestamp=XXX;
SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'XXX' AND post_type IN ('XXX', 'XXX', 'XXX', 'XXX', 'XXX') ORDER BY post_modified_gmt DESC LIMIT XXX;

SET timestamp=1432498772;
SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment', 'scholarship', 'resource') ORDER BY post_modified_gmt DESC LIMIT 1;


### 1 Query
### Total time: 5.33451, Average time: 5.33451
### Taking 5.334510 seconds to complete
### Rows analyzed 4047
use dbXXX_sXXX;
SET timestamp=XXX;
SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('XXX') AND tt.term_id IN ('XXX') ORDER BY tr.object_id ASC;

use db187284_s360;
SET timestamp=1432654316;
SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('604') ORDER BY tr.object_id ASC;

Answers (1)

2015-05-27

Arnav Joy answers:

i am looking into it.