WordPress database error: [Unknown column 'MM.meta_value' in 'WHERE']
select T.meta_value , count( DISTINCT T.post_id ) as total
from wp_lhaw_tagups T
left join wp_lhaw_posts P on P.ID = T.post_id
left join wp_lhaw_relations R on ( R.video_id = T.post_id AND R.video_id is not null )
where
T.meta_key = 'd_results'
AND P.ID is not null
AND 1
AND ( '3866' IN ( T.meta_value )
OR '3867' IN ( T.meta_value ) )
AND R.channel_id IN (353844)
AND MM.meta_value != 'scout_game_play'
group by T.meta_value
