WordPress database error: [Can't create/write to file '/tmp/MYzgAPrc' (OS errno 28 - No space left on device)]
WITH RankedResults AS ( SELECT t.NAME AS taxonomy_name, tr.object_id, tt.taxonomy, tt.term_id, t.NAME as name, COUNT(*) AS count FROM es_term_relationships AS tr JOIN es_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id JOIN es_terms AS t ON tt.term_id = t.term_id WHERE tr.object_id IN ( SELECT p.ID FROM es_posts AS p JOIN es_term_relationships AS tr ON p.ID = tr.object_id JOIN es_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id JOIN es_terms AS t ON tt.term_id = t.term_id WHERE p.post_type = 'product' AND p.post_status = 'publish' AND tt.taxonomy = 'product_cat' AND ('baut-mur-torsi-kontrol-tcbolt-en'='' OR t.slug IN ('baut-mur-torsi-kontrol-tcbolt-hitam-en-2')) -- Slug check updated ) AND tt.taxonomy LIKE 'pa_%' GROUP BY t.NAME, tr.object_id, tt.taxonomy, tt.term_id ) SELECT taxonomy_name, object_id, taxonomy, term_id, NAME, count FROM RankedResults ORDER BY NAME;