Adventure
Lỗi cơ sở dữ liệu WordPress: [Subquery returns more than 1 row]SELECT p.ID, p.post_title, p.post_date,
COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') as views,
(SELECT COUNT(*) FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish') as chap_count,
(SELECT post_title FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1) as latest_chap
FROM wp_posts p
WHERE p.post_type = 'post'
AND p.post_status = 'publish'
AND p.post_date >= '2026-07-24 00:00:00'
ORDER BY
CAST(COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') AS UNSIGNED) DESC,
p.post_date DESC
LIMIT 7
Lỗi cơ sở dữ liệu WordPress: [Subquery returns more than 1 row]SELECT p.ID, p.post_title, p.post_date,
COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') as views,
(SELECT COUNT(*) FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish') as chap_count,
(SELECT post_title FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1) as latest_chap
FROM wp_posts p
WHERE p.post_type = 'post'
AND p.post_status = 'publish'
AND p.post_date >= '2026-08-16 00:00:00'
ORDER BY
CAST(COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') AS UNSIGNED) DESC,
p.post_date DESC
LIMIT 7
Lỗi cơ sở dữ liệu WordPress: [Subquery returns more than 1 row]SELECT p.ID, p.post_title, p.post_date,
COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') as views,
(SELECT COUNT(*) FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish') as chap_count,
(SELECT post_title FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1) as latest_chap
FROM wp_posts p
WHERE p.post_type = 'post'
AND p.post_status = 'publish'
AND p.post_date >= '2026-08-21 00:00:00'
ORDER BY
CAST(COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') AS UNSIGNED) DESC,
p.post_date DESC
LIMIT 7
Lỗi cơ sở dữ liệu WordPress: [Subquery returns more than 1 row]SELECT p.ID, p.post_title, p.post_date,
COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') as views,
(SELECT COUNT(*) FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish') as chap_count,
(SELECT post_title FROM wp_posts WHERE post_parent = p.ID AND post_type = 'chap' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1) as latest_chap
FROM wp_posts p
WHERE p.post_type = 'post'
AND p.post_status = 'publish'
AND p.post_date >= '2026-08-16 00:00:00'
ORDER BY
CAST(COALESCE((SELECT meta_value FROM wp_postmeta WHERE post_id = p.ID AND meta_key = 'tw_views_post'), '0') AS UNSIGNED) DESC,
p.post_date DESC
LIMIT 7