Surabaya, Padangkita.com – Ketua DPD RI, AA LaNyalla Mahmud Mattalitti memantau persiapan pra PON Jawa Timur disela-sela tugas reses ke KONI Jat...
Tag: PON XIX
Galat basis data WordPress: [Table 'padangkita_prod.wp_posts' doesn't exist]
SELECT
(
SELECT MAX(c.count) as found_posts
from (
SELECT
count(cb.post_id) as count
FROM
`pdgkitanews_tray_post_views` cb
INNER JOIN wp_posts w on (
w.ID = cb.post_id
and w.post_status = 'publish'
)
WHERE
cb.`post_date_gmt` >= '2024-11-22'
GROUP BY cb.`post_id`
) as c
) as found_posts,
(
SELECT
SUM(`at`.`view_count`)
FROM
`pdgkitanews_tray_post_views` as at
INNER JOIN wp_posts w on (
w.ID = at.post_id AND w.post_status = 'publish'
)
WHERE at.`post_date_gmt` >= '2024-11-22'
) as `total_views`,
(
SELECT
SUM(`view_count`)
FROM `pdgkitanews_tray_post_views` as bt
WHERE
(tb.post_id = bt.post_id AND bt.`post_date_gmt` >= '2024-11-22')
) as post_views,
tb.`post_id`
FROM `pdgkitanews_tray_post_views` as tb
INNER JOIN wp_posts wp on (
wp.ID = tb.post_id AND wp.post_status = 'publish'
)
WHERE
tb.post_date_gmt >= '2024-11-22'
GROUP BY
tb.post_id
LIMIT 5 OFFSET 0