WordPress databasefejl: [Disk full (/tmp/#sql-temptable-cddc-3d2be-14e9e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT * -- ,(SELECT GROUP_CONCAT(DISTINCT post_title) FROM dS7jEzpZe_posts WHERE FIND_IN_SET(ID,product_ids)>0)product FROM ( SELECT p.ID post_id,post_title coupon_code ,MAX(CASE WHEN pm.meta_key='product_ids' THEN pm.meta_value END)product_ids ,MAX(CASE WHEN pm.meta_key='exclude_product_ids' THEN pm.meta_value END)exc_prds ,MAX(CASE WHEN pm.meta_key='product_categories' THEN pm.meta_value END)cats ,MAX(CASE WHEN pm.meta_key='exclude_product_categories' THEN pm.meta_value END)exc_cats ,MAX(CASE WHEN pm.meta_key='individual_use' THEN pm.meta_value END)individual ,MAX(CASE WHEN pm.meta_key='coupon_amount' THEN pm.meta_value END)coupon_amount ,MAX(CASE WHEN pm.meta_key='customer_email' THEN pm.meta_value END)c_email ,MAX(CASE WHEN pm.meta_key='_wc_min_qty' THEN pm.meta_value END)min_qty ,MAX(CASE WHEN pm.meta_key='_wc_max_qty' THEN pm.meta_value END)max_qty ,MAX(CASE WHEN pm.meta_key='_wc_qty_ntf' THEN pm.meta_value END)qty_ntf ,MAX(CASE WHEN pm.meta_key='_wc_min_qty_ntf' THEN pm.meta_value END)min_qty_ntf ,MAX(CASE WHEN pm.meta_key='_wc_max_qty_ntf' THEN pm.meta_value END)max_qty_ntf ,MIN(CASE WHEN pm.meta_key LIKE '_wc_%_apply' AND pm.meta_value='yes' THEN pm.meta_key END)apply ,DATE_FORMAT(FROM_UNIXTIME(x.meta_value),'%m-%d-%Y')exp_date ,CASE WHEN FROM_UNIXTIME(x.meta_value)<'2025-07-31 03:56:27' THEN 1 ELSE 0 END exp FROM dS7jEzpZe_posts p LEFT JOIN dS7jEzpZe_postmeta x ON x.post_id=p.ID AND x.meta_key='date_expires' AND LENGTH(x.meta_value)=10 AND x.meta_value REGEXP '[0-9]' LEFT JOIN dS7jEzpZe_postmeta pm ON pm.post_id=p.ID AND (pm.meta_key IN ('product_ids','exclude_product_ids','product_categories','exclude_product_categories','individual_use','coupon_amount','customer_email','_wc_min_qty','_wc_max_qty','_wc_qty_ntf','_wc_min_qty_ntf','_wc_max_qty_ntf') OR pm.meta_key LIKE '_wc_%_apply') WHERE post_type='shop_coupon' AND post_status='publish' GROUP BY p.ID )a WHERE 1=1 AND(individual='yes' OR apply IS NOT NULL OR c_email IS NOT NULL) AND exp=0 ORDER BY individual DESC,exp,CAST(coupon_amount AS SIGNED) DESC;