Bedroom storage
Order
WordPress database error: [Query execution was interrupted, maximum statement execution time exceeded]SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN (
SELECT tr.object_id
FROM wp_term_relationships tr
JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
JOIN wp_terms t ON t.term_id = tt.term_id
WHERE t.slug = 'barker-and-stonehouse'
AND tt.taxonomy = 'pa_retailer'
) AS feed_retailer_rank ON feed_retailer_rank.object_id = wp_posts.ID LEFT JOIN (
SELECT tr.object_id
FROM wp_term_relationships tr
JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
JOIN wp_terms t ON t.term_id = tt.term_id
WHERE t.slug IN ('out-of-stock', 'removed-by-retailer')
AND tt.taxonomy = 'pa_stockstatus'
) AS feed_inactive ON feed_inactive.object_id = wp_posts.ID WHERE 1=1 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 (1627,1672,1673,1674)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY feed_inactive.object_id ASC, feed_retailer_rank.object_id DESC, wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 24
