SELECT
			tbl_channels.entity_id
			, tbl_channel_members.fld_channel_member_id
			, tbl_channel_members.fld_active
			, clay_golfclub.entity_id
			, clay_golfclub.status
			, clay_golfclub.publish_data
		FROM
			claymore.tbl_channel_members
			, claymore.tbl_channels
			, claymore.clay_golfclub
		WHERE (
			tbl_channels.entity_id = 6
			AND tbl_channels.entity_id = tbl_channel_members.fld_rel_channel_id
			AND tbl_channel_members.fld_rel_entity_id = clay_golfclub.entity_id
			AND clay_golfclub.status = 'active'
			AND clay_golfclub.publish_data  = 'y'
			AND tbl_channel_members.fld_rel_entity_type = 'golfclub'
			AND tbl_channel_members.fld_rel_entity_id = 36
			AND tbl_channel_members.fld_active = 1
			AND UNIX_TIMESTAMP(tbl_channel_members.fld_membership_expiry_date) >= UNIX_TIMESTAMP(CURDATE())
			);	
	<br /><br />