Announcements

xCRUDUnknown column 'ys_athlete_in_competition.competition_Type_ID' in 'IN/ALL/ANY subquery'

SELECT COUNT(*) AS `count`  
 FROM `ys_interactive_messageboard`
 
 WHERE ((ys_interactive_messageboard.competition_ID IN (SELECT cs.competition_ID FROM ys_competition_setup cs WHERE cs.competition_Start_Timestamp > UNIX_TIMESTAMP(NOW())-86400*2 AND cs.competition_Start_Timestamp < UNIX_TIMESTAMP(NOW())+86400*2)) AND `ys_athlete_in_competition`.`competition_Type_ID`='6')