-
Discussions tagged with 'training'
Viewing 1 - 2 of 2 discussions
WordPress database error: [Unknown column 'wp_posts.post_author' in 'IN/ALL/ANY subquery']
SELECT wp_self_78425_posts.ID
FROM wp_self_78425_posts INNER JOIN wp_self_78425_postmeta ON ( wp_self_78425_posts.ID = wp_self_78425_postmeta.post_id ) LEFT JOIN wp_self_78425_bp_suspend sft ON ( sft.item_type = 'forum_topic' AND sft.item_id = wp_self_78425_posts.ID )
WHERE 1=1 AND (
( wp_self_78425_postmeta.meta_key = '_bbp_forum_id' AND CAST(wp_self_78425_postmeta.meta_value AS SIGNED) NOT IN ('61804','56593','43831','24124','22259','5386','4128') )
) AND wp_self_78425_posts.post_type = 'topic' AND ((wp_self_78425_posts.post_status = 'publish' OR wp_self_78425_posts.post_status = 'closed')) AND ( ( sft.user_suspended = 0 OR sft.user_suspended IS NULL ) AND ( sft.hide_parent = 0 OR sft.hide_parent IS NULL ) AND
( sft.hide_sitewide = 0 OR sft.hide_sitewide IS NULL ) AND ( wp_posts.post_author NOT IN ( SELECT DISTINCT m.user_id FROM wp_self_78425_bp_suspend s LEFT JOIN wp_self_78425_bp_moderation m ON m.moderation_id = s.id WHERE s.item_type = 'user' AND s.item_id = 0 AND s.reported != 0 AND m.user_report != 1 ) ) )
GROUP BY wp_self_78425_posts.ID
ORDER BY wp_self_78425_posts.post_date DESC
LIMIT 0, 5
WordPress database error: [Unknown column 'wp_posts.post_author' in 'IN/ALL/ANY subquery']
SELECT wp_self_78425_posts.ID
FROM wp_self_78425_posts INNER JOIN wp_self_78425_postmeta ON ( wp_self_78425_posts.ID = wp_self_78425_postmeta.post_id ) LEFT JOIN wp_self_78425_bp_suspend sfr ON ( sfr.item_type = 'forum_reply' AND sfr.item_id = wp_self_78425_posts.ID )
WHERE 1=1 AND (
( wp_self_78425_postmeta.meta_key = '_bbp_forum_id' AND CAST(wp_self_78425_postmeta.meta_value AS SIGNED) NOT IN ('61804','56593','43831','24124','22259','5386','4128') )
) AND wp_self_78425_posts.post_type = 'reply' AND ((wp_self_78425_posts.post_status = 'publish' OR wp_self_78425_posts.post_status = 'closed')) AND ( ( sfr.user_suspended = 0 OR sfr.user_suspended IS NULL ) AND ( sfr.hide_parent = 0 OR sfr.hide_parent IS NULL ) AND
( sfr.hide_sitewide = 0 OR sfr.hide_sitewide IS NULL ) AND ( wp_posts.post_author NOT IN ( SELECT DISTINCT m.user_id FROM wp_self_78425_bp_suspend s LEFT JOIN wp_self_78425_bp_moderation m ON m.moderation_id = s.id WHERE s.item_type = 'user' AND s.item_id = 0 AND s.reported != 0 AND m.user_report != 1 ) ) AND ( wp_posts.post_author NOT IN ( SELECT DISTINCT m.user_id FROM wp_self_78425_bp_suspend s LEFT JOIN wp_self_78425_bp_moderation m ON m.moderation_id = s.id WHERE s.item_type = 'user' AND s.item_id = 0 AND s.reported != 0 AND m.user_report != 1 ) ) )
GROUP BY wp_self_78425_posts.ID
ORDER BY wp_self_78425_posts.post_date DESC
LIMIT 0, 5