WordPress databasefejl: [Error writing file './wp_milvu/#sql-alter-8124-1aa694.frm' (Errcode: 28 "No space left on device")]ALTER TABLE dS7jEzpZe_wa_payment_log CHANGE COLUMN `id` id INT(6) UNSIGNED AUTO_INCREMENT
WordPress databasefejl: [Error writing file './wp_milvu/#sql-alter-8124-1aa694.frm' (Errcode: 28 "No space left on device")]ALTER TABLE dS7jEzpZe_wa_payment_log CHANGE COLUMN `paymentid` paymentid INT
WordPress databasefejl: [Error writing file './wp_milvu/#sql-alter-8124-1aa694.frm' (Errcode: 28 "No space left on device")]ALTER TABLE dS7jEzpZe_wa_payment_log CHANGE COLUMN `created_at` created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
WordPress databasefejl: [Table 'dS7jEzpZe_wa_payment' already exists]CREATE TABLE dS7jEzpZe_wa_payment (
id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
paymentid INT,
name varchar(30),
email varchar(120),
orderno varchar(30),
amount VARCHAR(30),
currency varchar(30),
status varchar(30),
action varchar(30),
action_id varchar(30),
card_used varchar(30),
card_issued_to varchar(30),
card_bin varchar(30),
card_last4 varchar(30),
card_month varchar(30),
card_year varchar(30),
acquirer varchar(30),
type varchar(30),
transid int,
qp_status_code varchar(30),
qp_status_msg varchar(30),
aq_status_code varchar(30),
aq_status_msg varchar(30),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress databasefejl: [Can't change size of file (Errcode: 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-10-21 03:23:57' 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;