SELECT
			tbl_channels.entity_id
			, tbl_channel_members.fld_channel_member_id
			, tbl_channel_members.fld_active
			, clay_hotel.entity_id
			, clay_hotel.status
			, clay_hotel.publish_data
		FROM
			claymore.tbl_channel_members
			, claymore.tbl_channels
			, claymore.clay_hotel
		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_hotel.entity_id
			AND clay_hotel.status = 'active'
			AND clay_hotel.publish_data  = 'y'
			AND tbl_channel_members.fld_rel_entity_type = 'hotel'
			AND tbl_channel_members.fld_rel_entity_id = 84
			AND tbl_channel_members.fld_active = 1
			AND UNIX_TIMESTAMP(tbl_channel_members.fld_membership_expiry_date) >= UNIX_TIMESTAMP(CURDATE())
			);	
	<br /><br />