Query - MySQL - WordPress | Change Status Private to Publish

query_mysql_change_status_post_private_to_publish_WP.sql

UPDATE wp_posts
SET post_status = 'publish'
WHERE ID IN (
2804, 2808, 2812, 2816, 2821, 2823, 8676, 8677, 8678, 8701, 8702, 2829, 2831, 2833, 
2836, 2838, 2840, 2842, 2844, 2846, 2848, 2850, 2852, 2854, 2856, 2858, 2860, 2862, 
2864, 2868, 2959, 2961, 2963, 2965, 2968, 2970, 2972, 2974, 2976, 2978, 2980, 2982, 
2985, 2987, 4368, 4370, 4375, 4377, 4379, 4381, 4383, 4389, 4393, 4395, 4397, 4399, 
4401, 4403, 4405, 8564, 8566, 8567, 8565, 8568, 8569, 8570, 8571, 8572, 8573, 8883, 
8884, 8885, 8886, 8887, 8888, 8951, 8952, 8953, 8954, 8956, 8957, 8958, 8959, 8960, 
8961, 8955, 8962, 8963, 8964, 9094, 9095, 9096, 9097, 9098, 9099, 9100, 9101, 9102, 
9103, 9204, 9205, 9206, 9207, 9208, 9209, 9210, 9211, 9212, 548, 649, 662, 764, 785, 
539, 794, 6025, 6027, 6473, 6477, 6480, 6484, 6486, 6488, 6490, 6492, 6495, 6498, 
6501, 6504, 6506, 6509)
AND post_status = 'private';