WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9b8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9be.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9bf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9c0.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-12-01 13:34:36' 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;
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9c2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9c4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_woocommerce_tax_rates`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9c5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_woocommerce_tax_rates`
Italiensk luksus Filotea Fettuccine pasta Linguine 250 g. - Dragør Vinhandel
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9cb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9c9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT dS7jEzpZe_posts.*
FROM dS7jEzpZe_posts LEFT JOIN dS7jEzpZe_term_relationships ON (dS7jEzpZe_posts.ID = dS7jEzpZe_term_relationships.object_id)
WHERE 1=1 AND (
dS7jEzpZe_term_relationships.term_taxonomy_id IN (17)
) AND dS7jEzpZe_posts.post_type = 'nav_menu_item' AND ((dS7jEzpZe_posts.post_status = 'publish'))
GROUP BY dS7jEzpZe_posts.ID
ORDER BY dS7jEzpZe_posts.menu_order ASC
No menu items
No menu items
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9ca.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT dS7jEzpZe_posts.*
FROM dS7jEzpZe_posts LEFT JOIN dS7jEzpZe_term_relationships ON (dS7jEzpZe_posts.ID = dS7jEzpZe_term_relationships.object_id)
WHERE 1=1 AND (
dS7jEzpZe_term_relationships.term_taxonomy_id IN (92)
) AND dS7jEzpZe_posts.post_type = 'nav_menu_item' AND ((dS7jEzpZe_posts.post_status = 'publish'))
GROUP BY dS7jEzpZe_posts.ID
ORDER BY dS7jEzpZe_posts.menu_order ASC
No menu items
No menu items
Italiensk luksus Filotea Fettuccine pasta Linguine 250 g.
Italiensk luksus Filotea Fettuccine pasta Linguine 250 g.
Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /var/www/vhosts/dragoervinhandel.dk/httpdocs/wp-content/themes/colibri-wp/inc/src/BuilderComponents/WooContent.php on line 53
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9cd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9ce.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
Italiensk luksus Filotea Fettuccine pasta Linguine 250 g.
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9d2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9d3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
DKK 39,00
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9d4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
Samme længde som spaghetti, dog fladere. Passer perfekt til fiskeretter eller med den traditionelle “Pesto alla genovese”
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9d6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`
WordPress databasefejl: [Disk full (/tmp/#sql-temptable-be14-2497e-c9d7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `dS7jEzpZe_options`