Query Advisor Results


What does this mean?

SELECT wp_yASdr_posts.ID FROM wp_yASdr_posts INNER JOIN wp_yASdr_term_relationships ON (wp_yASdr_posts.ID = wp_yASdr_term_relationships.object_id) INNER JOIN wp_yASdr_term_relationships AS tt1 ON (wp_yASdr_posts.ID = tt1.object_id) WHERE 1=1 AND wp_yASdr_posts.ID NOT IN (336896,336889,336883,336872,336870,336835,336859,336823,336826,336819,336804,336792,336797,336791,336777,336766,336774,336761,336751,336749,336731,336738,336571,335527,334433,333935,333216,336647,336583,336376,336521,336435,336410,336391,336297) AND ( wp_yASdr_term_relationships.term_taxonomy_id IN (4) AND tt1.term_taxonomy_id IN (43,56,57,58) ) AND wp_yASdr_posts.post_type = ‘post’ AND (wp_yASdr_posts.post_status = ‘publish’) GROUP BY wp_yASdr_posts.ID ORDER BY wp_yASdr_posts.post_date DESC LIMIT 0, 4;

By the way, this query is slow. Please help to optimize it. Thanks

Why you should consider using virtual assistant services offered by us?

We provide our valuable clients with administrative, creative and technical support from our dedicated offices at different geographical locations, using advanced technological modes of communication and data delivery. Hence, saving our clients the expense of office space and equipment as well as helping them stay focused on their core business activity and enjoy their personal life.