ป้ายกำกับ: CMS Workflow

SET @start_date = '2026-10-24 07:00:00'; -- วันเสาร์แรกหลังจาก 17 ต.ค. 2026 INSERT INTO `wp_posts` (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count) SELECT n.id_seq, 1, -- post_author (สมมติว่าเป็น Admin ID: 1) DATE_ADD (@start_date, INTERVAL (ROW_NUMBER () OVER (ORDER BY n.id_seq) - 1) * 7 DAY) , DATE_ADD (@start_date, INTERVAL (ROW_NUMBER () OVER (ORDER BY n.id_seq) - 1) * 7 DAY) , '', -- post_content n.id_seq, -- post_title '', -- post_excerpt 'future', -- post_status 'open', 'open', n.id_seq, -- post_name (slug) '', '', NOW () , NOW () , '', 0, '', 0, 'post', '', 0
FROM (-- สร้างลำดับตัวเลข 1 ถึง 11876 SELECT (t4.n*1000 + t3.n*100 + t2.n*10 + t1.n) AS id_seq FROM (SELECT 0 AS n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS t1 CROSS JOIN (SELECT 0 AS n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS t2 CROSS JOIN (SELECT 0 AS n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS t3 CROSS JOIN (SELECT 0 AS n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 AS n UNION SELECT 10 UNION SELECT 11) AS t4) AS n
LEFT JOIN `wp_posts` p ON n.id_seq = p.ID
WHERE n.id_seq BETWEEN 1 AND 11876 AND p.ID IS NULL; -- เงื่อนไข: เฉพาะ ID ที่ไม่มีอยู่ในตารางเท่านั้น SET @start_date = NULL;