WordPress database error: [Disk full (/tmp/#sql_6990_399.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT pjh_posts.*
FROM pjh_posts LEFT JOIN pjh_term_relationships ON (pjh_posts.ID = pjh_term_relationships.object_id) LEFT JOIN pjh_postmeta ON ( pjh_posts.ID = pjh_postmeta.post_id ) LEFT JOIN pjh_postmeta AS mt1 ON ( pjh_posts.ID = mt1.post_id AND mt1.meta_key = 'tm_meta_disable_categories' ) LEFT JOIN pjh_postmeta AS mt2 ON ( pjh_posts.ID = mt2.post_id ) LEFT JOIN pjh_postmeta AS mt3 ON ( pjh_posts.ID = mt3.post_id AND mt3.meta_key = 'tm_meta_product_exclude_ids' )
WHERE 1=1 AND (
pjh_term_relationships.term_taxonomy_id IN (2297,2299)
OR
pjh_posts.ID NOT IN (
SELECT object_id
FROM pjh_term_relationships
WHERE term_taxonomy_id IN (15,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,97,938,939,1264,1609,1660,1706,1733,1808,1899,2050,2095,2096,2097,2116,2126,2149,2186,2197,2204,2241,2242,2243,2244,2262,2271,2287,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2313,2315,2316,2317,2319,2320,2343,2344,2354,2355,2356,2357,2358,2359,2360,2361,2362,2363,2364,2365,2366,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2385,2395,2399,2542,2575,2608,2668,2767,2921,2934,3104,3116,3600,4024,4211)
)
OR
NOT EXISTS (
SELECT 1
FROM pjh_term_relationships
INNER JOIN pjh_term_taxonomy
ON pjh_term_taxonomy.term_taxonomy_id = pjh_term_relationships.term_taxonomy_id
WHERE pjh_term_taxonomy.taxonomy = 'product_cat'
AND pjh_term_relationships.object_id = pjh_posts.ID
)
) AND (
(
( pjh_postmeta.meta_key = 'tm_meta_disable_categories' AND pjh_postmeta.meta_value != '1' )
OR
mt1.post_id IS NULL
)
AND
(
( mt2.meta_key = 'tm_meta_product_exclude_ids' AND mt2.meta_value NOT LIKE '%\"61624\";%' )
OR
mt3.post_id IS NULL
)
) AND pjh_posts.post_type = 'tm_global_cp' AND ((pjh_posts.post_status = 'publish'))
GROUP BY pjh_posts.ID
ORDER BY pjh_posts.post_date ASC
Reviews
There are no reviews yet.