WordPress データベースエラー: [Disk full (/tmp/#sql_640_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT
p.*,
imp_count.meta_value AS ad_imp_count,
imp_limit.meta_value AS ad_imp_limit,
start_date.meta_value AS ad_start_date,
end_date.meta_value AS ad_end_date
FROM appsuke_posts p
LEFT JOIN appsuke_postmeta AS imp_limit
ON p.ID = imp_limit.post_id
AND imp_limit.meta_key = '_dfads_impression_limit'
LEFT JOIN appsuke_postmeta AS imp_count
ON p.ID = imp_count.post_id
AND imp_count.meta_key = '_dfads_impression_count'
LEFT JOIN appsuke_postmeta AS start_date
ON p.ID = start_date.post_id
AND start_date.meta_key = '_dfads_start_date'
LEFT JOIN appsuke_postmeta AS end_date
ON p.ID = end_date.post_id
AND end_date.meta_key = '_dfads_end_date'
LEFT JOIN appsuke_term_relationships AS tr ON (p.ID = tr.object_id) LEFT JOIN appsuke_term_taxonomy AS tax ON (tr.term_taxonomy_id = tax.term_taxonomy_id)
WHERE p.post_status = 'publish'
AND p.post_type = 'dfads'
AND (
CAST(imp_limit.meta_value AS UNSIGNED) = 0
OR CAST(imp_count.meta_value AS UNSIGNED) < CAST(imp_limit.meta_value AS UNSIGNED)
OR CAST(imp_count.meta_value AS UNSIGNED) IS NULL
)
AND (
CAST(start_date.meta_value AS UNSIGNED) IS NULL
OR 1527179339 >= CAST(start_date.meta_value AS UNSIGNED)
)
AND (
CAST(end_date.meta_value AS UNSIGNED) IS NULL
OR 1527179339 <= CAST(end_date.meta_value AS UNSIGNED)
)
AND tax.taxonomy = 'dfads_group' AND tax.term_id IN(318)
GROUP BY p.ID
ORDER BY RAND() ASC
LIMIT 1