Tag: Unand

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