SQL=
SELECT COUNT(b.photo_id) FROM  photo_competition a
	INNER JOIN photo_competition_winner cw ON cw.competition_id=a.competition_id
	INNER JOIN photo b ON b.photo_id=cw.photo_id
	INNER JOIN member d ON d.member_id=b.member_id
	WHERE a.fl_show=1 AND cw.fl_show=1 AND b.fl_show=1 AND is_nude=0
	ORDER BY a.competition_id DESC, rank ASC
	
		
Error=
Unknown column 'is_nude' in 'where clause'

Script:
/competition/