SELECT * FROM (
(
SELECT p2.*, '2' tdr_blog_id, u.display_name tdr_author, o2.option_value tdr_siteurl, o2_2.option_value tdr_theme_mods
FROM wp_2_posts p2
INNER JOIN wp_users u ON p2.post_author = u.ID
INNER JOIN wp_2_options o2 ON o2.option_name = 'siteurl'
INNER JOIN wp_2_options o2_2 ON o2_2.option_name = 'theme_mods_frog-wp-child'
WHERE p2.post_type = 'post' AND p2.post_status = 'publish' ORDER BY p2.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p7.*, '7' tdr_blog_id, u.display_name tdr_author, o7.option_value tdr_siteurl, o7_2.option_value tdr_theme_mods
FROM wp_7_posts p7
INNER JOIN wp_users u ON p7.post_author = u.ID
INNER JOIN wp_7_options o7 ON o7.option_name = 'siteurl'
INNER JOIN wp_7_options o7_2 ON o7_2.option_name = 'theme_mods_frog-wp-child'
WHERE p7.post_type = 'post' AND p7.post_status = 'publish' ORDER BY p7.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p8.*, '8' tdr_blog_id, u.display_name tdr_author, o8.option_value tdr_siteurl, o8_2.option_value tdr_theme_mods
FROM wp_8_posts p8
INNER JOIN wp_users u ON p8.post_author = u.ID
INNER JOIN wp_8_options o8 ON o8.option_name = 'siteurl'
INNER JOIN wp_8_options o8_2 ON o8_2.option_name = 'theme_mods_frog-wp-child'
WHERE p8.post_type = 'post' AND p8.post_status = 'publish' ORDER BY p8.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p9.*, '9' tdr_blog_id, u.display_name tdr_author, o9.option_value tdr_siteurl, o9_2.option_value tdr_theme_mods
FROM wp_9_posts p9
INNER JOIN wp_users u ON p9.post_author = u.ID
INNER JOIN wp_9_options o9 ON o9.option_name = 'siteurl'
INNER JOIN wp_9_options o9_2 ON o9_2.option_name = 'theme_mods_frog-wp-child'
WHERE p9.post_type = 'post' AND p9.post_status = 'publish' ORDER BY p9.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p19.*, '19' tdr_blog_id, u.display_name tdr_author, o19.option_value tdr_siteurl, o19_2.option_value tdr_theme_mods
FROM wp_19_posts p19
INNER JOIN wp_users u ON p19.post_author = u.ID
INNER JOIN wp_19_options o19 ON o19.option_name = 'siteurl'
INNER JOIN wp_19_options o19_2 ON o19_2.option_name = 'theme_mods_frog-wp-child'
WHERE p19.post_type = 'post' AND p19.post_status = 'publish' ORDER BY p19.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p33.*, '33' tdr_blog_id, u.display_name tdr_author, o33.option_value tdr_siteurl, o33_2.option_value tdr_theme_mods
FROM wp_33_posts p33
INNER JOIN wp_users u ON p33.post_author = u.ID
INNER JOIN wp_33_options o33 ON o33.option_name = 'siteurl'
INNER JOIN wp_33_options o33_2 ON o33_2.option_name = 'theme_mods_frog-wp-child'
WHERE p33.post_type = 'post' AND p33.post_status = 'publish' ORDER BY p33.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p36.*, '36' tdr_blog_id, u.display_name tdr_author, o36.option_value tdr_siteurl, o36_2.option_value tdr_theme_mods
FROM wp_36_posts p36
INNER JOIN wp_users u ON p36.post_author = u.ID
INNER JOIN wp_36_options o36 ON o36.option_name = 'siteurl'
INNER JOIN wp_36_options o36_2 ON o36_2.option_name = 'theme_mods_frog-wp-child'
WHERE p36.post_type = 'post' AND p36.post_status = 'publish' ORDER BY p36.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p10.*, '10' tdr_blog_id, u.display_name tdr_author, o10.option_value tdr_siteurl, o10_2.option_value tdr_theme_mods
FROM wp_10_posts p10
INNER JOIN wp_users u ON p10.post_author = u.ID
INNER JOIN wp_10_options o10 ON o10.option_name = 'siteurl'
INNER JOIN wp_10_options o10_2 ON o10_2.option_name = 'theme_mods_frog-wp-child'
WHERE p10.post_type = 'post' AND p10.post_status = 'publish' ORDER BY p10.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p13.*, '13' tdr_blog_id, u.display_name tdr_author, o13.option_value tdr_siteurl, o13_2.option_value tdr_theme_mods
FROM wp_13_posts p13
INNER JOIN wp_users u ON p13.post_author = u.ID
INNER JOIN wp_13_options o13 ON o13.option_name = 'siteurl'
INNER JOIN wp_13_options o13_2 ON o13_2.option_name = 'theme_mods_frog-wp-child'
WHERE p13.post_type = 'post' AND p13.post_status = 'publish' ORDER BY p13.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p16.*, '16' tdr_blog_id, u.display_name tdr_author, o16.option_value tdr_siteurl, o16_2.option_value tdr_theme_mods
FROM wp_16_posts p16
INNER JOIN wp_users u ON p16.post_author = u.ID
INNER JOIN wp_16_options o16 ON o16.option_name = 'siteurl'
INNER JOIN wp_16_options o16_2 ON o16_2.option_name = 'theme_mods_frog-wp-child'
WHERE p16.post_type = 'post' AND p16.post_status = 'publish' ORDER BY p16.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p17.*, '17' tdr_blog_id, u.display_name tdr_author, o17.option_value tdr_siteurl, o17_2.option_value tdr_theme_mods
FROM wp_17_posts p17
INNER JOIN wp_users u ON p17.post_author = u.ID
INNER JOIN wp_17_options o17 ON o17.option_name = 'siteurl'
INNER JOIN wp_17_options o17_2 ON o17_2.option_name = 'theme_mods_frog-wp-child'
WHERE p17.post_type = 'post' AND p17.post_status = 'publish' ORDER BY p17.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p21.*, '21' tdr_blog_id, u.display_name tdr_author, o21.option_value tdr_siteurl, o21_2.option_value tdr_theme_mods
FROM wp_21_posts p21
INNER JOIN wp_users u ON p21.post_author = u.ID
INNER JOIN wp_21_options o21 ON o21.option_name = 'siteurl'
INNER JOIN wp_21_options o21_2 ON o21_2.option_name = 'theme_mods_frog-wp-child'
WHERE p21.post_type = 'post' AND p21.post_status = 'publish' ORDER BY p21.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p23.*, '23' tdr_blog_id, u.display_name tdr_author, o23.option_value tdr_siteurl, o23_2.option_value tdr_theme_mods
FROM wp_23_posts p23
INNER JOIN wp_users u ON p23.post_author = u.ID
INNER JOIN wp_23_options o23 ON o23.option_name = 'siteurl'
INNER JOIN wp_23_options o23_2 ON o23_2.option_name = 'theme_mods_frog-wp-child'
WHERE p23.post_type = 'post' AND p23.post_status = 'publish' ORDER BY p23.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p18.*, '18' tdr_blog_id, u.display_name tdr_author, o18.option_value tdr_siteurl, o18_2.option_value tdr_theme_mods
FROM wp_18_posts p18
INNER JOIN wp_users u ON p18.post_author = u.ID
INNER JOIN wp_18_options o18 ON o18.option_name = 'siteurl'
INNER JOIN wp_18_options o18_2 ON o18_2.option_name = 'theme_mods_frog-wp-child'
WHERE p18.post_type = 'post' AND p18.post_status = 'publish' ORDER BY p18.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p24.*, '24' tdr_blog_id, u.display_name tdr_author, o24.option_value tdr_siteurl, o24_2.option_value tdr_theme_mods
FROM wp_24_posts p24
INNER JOIN wp_users u ON p24.post_author = u.ID
INNER JOIN wp_24_options o24 ON o24.option_name = 'siteurl'
INNER JOIN wp_24_options o24_2 ON o24_2.option_name = 'theme_mods_frog-wp-child'
WHERE p24.post_type = 'post' AND p24.post_status = 'publish' ORDER BY p24.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p27.*, '27' tdr_blog_id, u.display_name tdr_author, o27.option_value tdr_siteurl, o27_2.option_value tdr_theme_mods
FROM wp_27_posts p27
INNER JOIN wp_users u ON p27.post_author = u.ID
INNER JOIN wp_27_options o27 ON o27.option_name = 'siteurl'
INNER JOIN wp_27_options o27_2 ON o27_2.option_name = 'theme_mods_frog-wp-child'
WHERE p27.post_type = 'post' AND p27.post_status = 'publish' ORDER BY p27.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p31.*, '31' tdr_blog_id, u.display_name tdr_author, o31.option_value tdr_siteurl, o31_2.option_value tdr_theme_mods
FROM wp_31_posts p31
INNER JOIN wp_users u ON p31.post_author = u.ID
INNER JOIN wp_31_options o31 ON o31.option_name = 'siteurl'
INNER JOIN wp_31_options o31_2 ON o31_2.option_name = 'theme_mods_frog-wp-child'
WHERE p31.post_type = 'post' AND p31.post_status = 'publish' ORDER BY p31.post_date DESC LIMIT 25
)
UNION ALL
(
SELECT p32.*, '32' tdr_blog_id, u.display_name tdr_author, o32.option_value tdr_siteurl, o32_2.option_value tdr_theme_mods
FROM wp_32_posts p32
INNER JOIN wp_users u ON p32.post_author = u.ID
INNER JOIN wp_32_options o32 ON o32.option_name = 'siteurl'
INNER JOIN wp_32_options o32_2 ON o32_2.option_name = 'theme_mods_frog-wp-child'
WHERE p32.post_type = 'post' AND p32.post_status = 'publish' ORDER BY p32.post_date DESC LIMIT 25
)
) p
WHERE
p.post_type = 'post'
AND p.post_status = 'publish'
ORDER BY post_date DESC
