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 = 'o_results'
AND P.ID is not null
AND 1
AND ( '297' IN ( T.meta_value )
OR '12730' IN ( T.meta_value )
OR '300' IN ( T.meta_value )
OR '299' IN ( T.meta_value )
OR '296' IN ( T.meta_value )
OR '298' IN ( T.meta_value ) )
AND R.channel_id IN (575240)
AND MM.meta_value != 'scout_game_play'
group by T.meta_value
