WordPress 資料庫錯誤: [Out of memory (Needed 413878272 bytes)]SELECT DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) INNER JOIN wp_wc_product_meta_lookup AS product_lookup ON wp_posts.ID = product_lookup.product_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 (5798)
) AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'etheme_mega_menus' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'etheme_slides' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'staticblocks' AND (wp_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'zh-hant' OR (
wpml_translations.language_code = 'zh-hant'
AND wp_posts.post_type IN ( 'elementor_library','product' )
AND ( (
( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'zh-hant'
) = 0 ) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'zh-hant' AND ( p.post_status = 'publish' OR p.post_status = 'private' OR ( p.post_type='attachment' AND p.post_status = 'inherit' ) )
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','elementor_library','staticblocks','product','product_variation' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','elementor_library','staticblocks','product','product_variation' ) ) ORDER BY product_lookup.stock_status ASC, wp_posts.post_date DESC, wp_posts.ID DESC
WordPress 資料庫錯誤: [Out of memory (Needed 413878272 bytes)]SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_posts AS p2 ON (wp_posts.post_parent = p2.ID) LEFT JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) INNER JOIN wp_wc_product_meta_lookup AS product_lookup ON wp_posts.ID = product_lookup.product_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 (5798)
) AND wp_posts.post_type = 'product' AND (((wp_posts.post_status = 'publish') OR (wp_posts.post_status = 'inherit' AND (p2.post_status = 'publish')))) AND ( ( ( wpml_translations.language_code = 'zh-hant' OR (
wpml_translations.language_code = 'zh-hant'
AND wp_posts.post_type IN ( 'elementor_library','product' )
AND ( (
( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'zh-hant'
) = 0 ) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'zh-hant' AND ( p.post_status = 'publish' OR p.post_status = 'private' OR ( p.post_type='attachment' AND p.post_status = 'inherit' ) )
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','elementor_library','staticblocks','product','product_variation' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','elementor_library','staticblocks','product','product_variation' ) ) ORDER BY product_lookup.stock_status ASC, wp_posts.post_date DESC, wp_posts.ID DESC LIMIT 0, 30