WHY? Because the heritage business has a dark side! Beneath the simple sounding stories in the Visitor Guide and behind the locked gates marked PRIVATE, there lies a multitude of inconvenient stories, hilarities, wonders, extremes and outrages. When Counter-Tourism opens the doors, tourism becomes a funny, subversive and adventurous experience - not a deferential procession through the unrevealing homes and castles of Heritage plc. Counter-Tourism upsets the sanitising efforts of the heritage industry. It is also a personal and social journey of mini-pilgrimages, challenges and pleasures.
HOLD ON – IS THERE AN AGENDA HERE? Yes – this is an approach to place/space that celebrates the multiplicities of meaning in every heritage site and upsets the industry's attempts at meaning-control and homogenisation – call it "mythogeography". It's what gives counter-tourism its emphasis on the sites of heritage, on the places themselves.
By intensifying and sharpening your perceptions - see what's behind the scenes, outside the site, just offstage.


Some of you noticed Wikidot was down yestarday for more than two hour. This is not something that happens often — previous serious outage we had was in November 2014.
Till now S3 has never failed before to this extent. It sure was not a small failure and it took down several other Amazon services. It also affected all services and websites that use Amazon Web Services. It's not just Wikidot alone: Trello, Travis CI, GitHub and GitLab, Quora, Medium, Signal, Slack, Imgur, Twitch.tv, Razer, Apple's iCloud and several other websites could not function properly (or were not reachable at all). A significant percentage of websites all over the world relies on S3 and only now we learned what happens when it's down.
The issue was so severe that even Amazon could not update their status board to let us know about the problems. It was probably hosted on S3 as well… It looks like engineers simply assumed that S3 would be available no matter what.
Wikidot infrastructure design relies on a certain assumption about S3 as well. We simply assumed everything can break, but not S3 itself. Even our backup site (in case databases and servers fail) is hosted on S3.
I guess today several admins and developers (especially from services affected by the S3 outage) try to find a way to loosen their dependencies on S3 and protect their services against similar events. We are going to look at this too — the data you keep with us is our top priority.
Thanks for your understanding and I am sorry for any trouble our outage might have caused.


text:
Shelley Wojcik
Executive Artistic Director/Co-Founder
Shelley has been creating and performing musical theatre for over 20 years for various theatre companies throughout the community. She has been involved in over 30 musicals within the community of Chilliwack, taking on positions such as choreographer, dance instructor, director, production manager, dramaturg and performer for organizations such as the Chilliwack School of Performing Arts, the University of the Fraser Valley, Chilliwack Players Guild, Newbury Arts Concept, Chilliwack Musical Theatre, GW Graham Theatre, and Secondary Characters.
Some of her favourite credits and experiences include, Once on this Island, Seussical, The Addams Family (CSOPA), A Funny Thing Happened on the Way to the Forum (UFV), Joseph and the Amazing Technicolour Dreamcoat, Into the Woods and The Hunchback of Notre Dame (Secondary Characters).
Shelley has received her Bachelor of Science Degree, Theatre Arts Diploma, Bachelor of Education Degree and Teaching Certification through the University of the Fraser Valley. She has choreographed and taught dance at the Chilliwack School of Performing Arts for 11 years, is currently teaching art and drama at Chilliwack Secondary School, has been co-Executive Artistic Director for Secondary Characters since co-founding the organization in 2009 and is now taking on that same position in a solo capacity.
Collaborative Pianist Nicola Davies is equally at home playing opera, musical theatre, art song, and chamber music. Her theatre work encompasses well over thirty productions as music director and pianist, including Carmen with Opera Kelowna and two summers at Opera NUOVA as repetiteur for Dead Man Walkingand Assistant Conductor for La Bohème. She is a music director for the University of Manitoba Musical Theatre Ensemble, and the Manitoba Theatre for Young People junior production. Nicola is also the pianist with cello piano duo Nate & Nina, which regularly plays house concerts throughout Western Canada.
Nicola has instigated various projects over the years, including Pieces of Eight Vocal Octet and Secondary Characters Musical Theatre, for which she was Co-Artistic Director for nine years. She is now the Executive Director and Co-Founder of Living Room Live, founded in 2018 to create opportunities for classical musicians and audiences. In 2017 Nicola attended the Franz Schubert Institute in Baden, Austria, where she studied with such teachers as Julius Drake, Roger Vignoles, and Elly Ameling. Her formal education includes a Masters in Collaborative Piano from the University of Manitoba, studying with Dr. Laura Loewen and Dr. Judy Kehler Siebert, a Diploma in Voice Performance, a Certificate in Conducting, and a Bachelor of Science.
Steffi Munshaw
A self-confessed student for life, Steffi holds a Diploma in Theatre Performance from Douglas College, a Bachelor of Fine Arts Degree with a Major in Theatre Performance from the School of Contemporary Arts at Simon Fraser University, and a Bachelor of Education with a Minor in Environmental Education also from SFU. When not moonlighting as a children's theatre director, Steffi spends her days teaching grade 4/5 for Squiala First Nation.
A prolific educator, Steffi has spent many years teaching theatre to youth in Chilliwack, the Fraser Valley, and as far away as Nunavut. Steffi has performed all over the Fraser Valley with Secondary Characters, Chilliwack Musical Theatre, the Chilliwack School of Performing Arts, the Fraser Valley Gilbert and Sullivan Society, Douglas College, Simon Fraser University, the University of the Fraser Valley, Troika Collective, and 591 Productions. Some of her favourite onstage performance credits include Jo (Little Women, Secondary Characters Musical Theatre), Maria (West Side Story, Chilliwack Musical Theatre), and Alice (the Alice, SFU School for Contemporary Arts). Performing everything from classics to contemporaries and from opera to absurdism, Steffi loves creating newly imagined works of art.
In what little spare time she has left, Steffi also loves working backstage in theatre having stage managed, dramaturged, artistic directed, directed, musical directed, and designed many shows in both Chilliwack and Vancouver. Recently, she has directed for Secondary Characters Musical Theatre including the Wizard of Oz and the Last Five Years which had a successful remount at both the RickRack in the 'Wack Festival and the Harrison Festival of the Arts. Steffi is resident production manager for Secondary Characters Musical Theatre and most recently set/props/costume designed and assistant directed their July 2018 production of The Hunchback of Notre Dame.

redpajama_set_name: RedPajamaCommonCrawl


This necklace features a detailed bronze plated elephant head charm, topped off with a Czech crystal rondelle bead in black diamond, and golden seed beads. The charm drop is just under 2"/5cm long. The chain is lead and nickel free and fastens with a lobster claw clasp - please choose your preferred necklace length from the drop-down menu. If you would like a length not shown here, please contact me - all chains are cut to size so any length is possible.


text:
package io.joynr.accesscontrol.global.jee;

import static java.lang.String.format;
import static java.util.stream.Collectors.toSet;

import java.util.List;
import java.util.Set;

import javax.ejb.Stateless;
import javax.inject.Inject;
import javax.persistence.EntityManager;
import javax.persistence.Query;

import com.google.common.collect.Sets;
import io.joynr.accesscontrol.global.jee.persistence.ControlEntryType;
import io.joynr.accesscontrol.global.jee.persistence.MasterAccessControlEntryEntity;
import io.joynr.exceptions.JoynrIllegalStateException;
import joynr.infrastructure.DacTypes.ChangeType;
import joynr.infrastructure.DacTypes.MasterAccessControlEntry;
import joynr.infrastructure.DacTypes.Permission;
import joynr.infrastructure.DacTypes.Role;
import joynr.infrastructure.DacTypes.TrustLevel;

@Stateless
public class MasterAccessControlEntryManager {

    private EntityManager entityManager;

    private DomainRoleEntryManager domainRoleEntryManager;

    // Only required for testing with Arquillian
    protected MasterAccessControlEntryManager() {
    }

    @Inject
    public MasterAccessControlEntryManager(EntityManager entityManager, DomainRoleEntryManager domainRoleEntryManager) {
        this.entityManager = entityManager;
        this.domainRoleEntryManager = domainRoleEntryManager;
    }

    private MasterAccessControlEntry mapEntityToJoynrType(MasterAccessControlEntryEntity entity) {
        MasterAccessControlEntry result = new MasterAccessControlEntry();
        result.setUid(entity.getUserId());
        result.setDomain(entity.getDomain());
        result.setInterfaceName(entity.getInterfaceName());
        result.setDefaultRequiredTrustLevel(entity.getDefaultRequiredTrustLevel());
        result.setPossibleRequiredTrustLevels(entity.getPossibleRequiredTrustLevels()
                                                    .toArray(new TrustLevel[entity.getPossibleRequiredTrustLevels()
                                                                                .size()]));
        result.setDefaultRequiredControlEntryChangeTrustLevel(entity.getDefaultRequiredControlEntryChangeTrustLevel());
        result.setPossibleRequiredControlEntryChangeTrustLevels(entity.getPossibleRequiredControlEntryChangeTrustLevels()
                                                                      .toArray(new TrustLevel[entity.getPossibleRequiredControlEntryChangeTrustLevels()
                                                                                .size()]));
        result.setOperation(entity.getOperation());
        result.setDefaultConsumerPermission(entity.getDefaultConsumerPermission());
        result.setPossibleConsumerPermissions(entity.getPossibleConsumerPermissions()
                                                    .toArray(new Permission[entity.getPossibleConsumerPermissions()
                                                                                .size()]));
        return result;
    }

    public MasterAccessControlEntry[] findByUserId(String userId, ControlEntryType type) {
        Query query = entityManager.createQuery("select mace from MasterAccessControlEntryEntity mace where mace.userId = :userId and mace.type = :type",
            MasterAccessControlEntryEntity.class);
        query.setParameter("userId", userId);
        query.setParameter("type", type);
        List<MasterAccessControlEntryEntity> resultList = query.getResultList();
        Set<MasterAccessControlEntry> resultSet = resultList.stream().map(this::mapEntityToJoynrType).collect(
            toSet());
        return resultSet.toArray(new MasterAccessControlEntry[resultSet.size()]);
    }

    public MasterAccessControlEntry[] findByUserIdThatAreEditable(String userId, ControlEntryType type) {
        Query query = entityManager.createQuery("select mace from MasterAccessControlEntryEntity mace, "
            + "DomainRoleEntryEntity dre, in(dre.domains) dds where mace.userId = :userId and mace.type = :type "
            + "and mace.domain = dds and dre.userId = :userId and dre.role = :role");
        query.setParameter("userId", userId);
        query.setParameter("type", type);
        query.setParameter("role", Role.MASTER);
        List<MasterAccessControlEntryEntity> resultList = query.getResultList();
        Set<MasterAccessControlEntry> resultSet = resultList.stream().map(this::mapEntityToJoynrType).collect(toSet());
        return resultSet.toArray(new MasterAccessControlEntry[resultSet.size()]);
    }

    public MasterAccessControlEntry[] findByDomainAndInterfaceName(String domain, String interfaceName, ControlEntryType type) {
        Query query = entityManager.createQuery("select mace from MasterAccessControlEntryEntity mace "
            + "where mace.domain = :domain and mace.interfaceName = :interfaceName and mace.type = :type", MasterAccessControlEntryEntity.class);
        query.setParameter("domain", domain);
        query.setParameter("interfaceName", interfaceName);
        query.setParameter("type", type);
        List<MasterAccessControlEntryEntity> resultList = query.getResultList();
        Set<MasterAccessControlEntry> resultSet = resultList.stream().map(this::mapEntityToJoynrType).collect(toSet());
        return resultSet.toArray(new MasterAccessControlEntry[resultSet.size()]);
    }

    private MasterAccessControlEntryEntity findByUserIdDomainInterfaceNameOperationAndType(String userId,
                                                                                String domain,
                                                                                String interfaceName,
                                                                                String operation,
                                                                                ControlEntryType type) {
        Query query = entityManager.createQuery("select mace from MasterAccessControlEntryEntity mace "
                + "where mace.userId = :userId and mace.domain = :domain and mace.interfaceName = :interfaceName "
                + "and mace.operation = :operation and mace.type = :type", MasterAccessControlEntryEntity.class);
        query.setParameter("userId", userId);
        query.setParameter("domain", domain);
        query.setParameter("interfaceName", interfaceName);
        query.setParameter("operation", operation);
        query.setParameter("type", type);
        List<MasterAccessControlEntryEntity> resultList = query.getResultList();
        MasterAccessControlEntryEntity entity = null;
        if (resultList.size() == 1) {
            entity = resultList.get(0);
        } else if (resultList.size() > 1) {
            throw new JoynrIllegalStateException(format("Too many master access control entries for unique key uid / domain / interfaceName /operation: %s / %s / %s / %s",
                                                        userId,
                                                        domain,
                                                        interfaceName,
                                                        operation));
        }
        return entity;
    }

    public CreateOrUpdateResult<MasterAccessControlEntry> createOrUpdate(MasterAccessControlEntry updatedMasterAce, ControlEntryType type) {
        MasterAccessControlEntryEntity entity = findByUserIdDomainInterfaceNameOperationAndType(updatedMasterAce.getUid(),
                                                                                updatedMasterAce.getDomain(),
                                                                                updatedMasterAce.getInterfaceName(),
                                                                                updatedMasterAce.getOperation(),
                                                                                type);
        if (!domainRoleEntryManager.hasCurrentUserGotRoleForDomain(Role.MASTER, updatedMasterAce.getDomain())) {
            return null;
        }
        boolean created = entity == null;
        if (created) {
            entity = new MasterAccessControlEntryEntity();
            entity.setUserId(updatedMasterAce.getUid());
            entity.setDomain(updatedMasterAce.getDomain());
            entity.setInterfaceName(updatedMasterAce.getInterfaceName());
            entity.setOperation(updatedMasterAce.getOperation());
            entity.setType(type);
            entityManager.persist(entity);
        }
        entity.setDefaultRequiredTrustLevel(updatedMasterAce.getDefaultRequiredTrustLevel());
        entity.setPossibleRequiredTrustLevels(Sets.newHashSet(updatedMasterAce.getPossibleRequiredTrustLevels()));
        entity.setDefaultRequiredControlEntryChangeTrustLevel(updatedMasterAce.getDefaultRequiredControlEntryChangeTrustLevel());
        entity.setPossibleRequiredControlEntryChangeTrustLevels(Sets.newHashSet(updatedMasterAce.getPossibleRequiredControlEntryChangeTrustLevels()));
        entity.setDefaultConsumerPermission(updatedMasterAce.getDefaultConsumerPermission());
        entity.setPossibleConsumerPermissions(Sets.newHashSet(updatedMasterAce.getPossibleConsumerPermissions()));
        return new CreateOrUpdateResult<>(mapEntityToJoynrType(entity), created ? ChangeType.ADD : ChangeType.UPDATE);
    }

    public MasterAccessControlEntry removeByUserIdDomainInterfaceNameAndOperation(String uid,
                                                                                String domain,
                                                                                String interfaceName,
                                                                                String operation,
                                                                                ControlEntryType type) {
        if (!domainRoleEntryManager.hasCurrentUserGotRoleForDomain(Role.MASTER, domain)) {
            return null;
        }
        MasterAccessControlEntryEntity entity = findByUserIdDomainInterfaceNameOperationAndType(uid,
                                                                                domain,
                                                                                interfaceName,
                                                                                operation,
                                                                                type);
        if (entity != null) {
            entityManager.remove(entity);
            return mapEntityToJoynrType(entity);
        }
        return null;
    }
}

redpajama_set_name: RedPajamaGithub


Businesses all over the world are in the need of more highly qualified IT-developers and designers. Women's knowledge and expertise has long been an under-utilized resource in the field of IT and IT applications and their absence is significant in our understanding of the decline in overall participation in the technology workforce. Measures are needed to increase women's participation and leadership in the innovation of IT beginning from the early encouragement of girls to the creation of women-welcoming environments in engineering and information technology. New theories and data are providing clues to why programs have not had greater impact on women's workforce participation in IT in the past and ways we can better engage both women and men in the field.
This pre-conference workshop addresses especially people from industry and policy, decision makers, recruiters, employees and all those who are interested in entering the field.
Founding chair of the International Taskforce for Women and ICTs, US.


text:
Pulau Adonara är en ö i Indonesien.   Den ligger i provinsen Nusa Tenggara Timur, i den sydöstra delen av landet. Arean är  kvadratkilometer.

Öns högsta punkt är  meter över havet.

I övrigt finns följande på Pulau Adonara:

 Vattendrag:
 Wai Werang (ett vattendrag)
 Kullar:

 Ile Lewokeda (en kulle)
 Woka Kolino (en kulle)
 Woka Lewouhung (en kulle)
 Woka Reget (en kulle)
 Woka Seburu (en kulle)
 Woka Waikeluba (en kulle)
 Halvöar:

 Maga-wutun (en udde)
 Tanjung Adonara (en udde)
 Tanjung Air (en udde)
 Tanjung Apematang (en udde)
 Tanjung Arang (en udde)
 Tanjung Basarani (en udde)
 Tanjung Gemuk (en udde)
 Tanjung Koli (en udde)
 Tanjung Kolikedah (en udde)
 Tanjung Lolong (en udde)
 Tanjung Marunge (en udde)
 Tanjung Meko (en udde)
 Tanjung Nipa (en udde)
 Tanjung Pasir (en udde)
 Tanjung Pedang (en udde)
 Tanjung Polisu (en udde)
 Tanjung Saganyi (en udde)
 Tanjung Sagu (en udde)
 Tanjung Waiduli (en udde)
 Tanjung Waijole (en udde)
 Tanjung Wazomenalok (en udde)
 Tanjung Wuluwata (en udde)
 Tanjung Wurgobin (en udde)
 Berg:

 Balile (ett berg)
 Ile Boleng (ett berg)
 Ile Bou (ett berg)
 Ile Hokenbele (ett berg)
 Ile Kaluwi (ett berg)
 Ile Kepageleho (ett berg)
 Ile Kului (ett berg)
 Ile Pasandana (ett berg)
 Ile Pasengdaeng (ett berg)
 Woka Bani (ett berg)
 Woka Blolong (ett berg)
 Woka Geka (ett berg)
 Woka Hoga (ett berg)
 Woka Kewoka (ett berg)
 Woka Koli (ett berg)
 Woka Kuma (ett berg)
 Woka Lamatoro (ett berg)
 Woka Nuba (ett berg)
 Woka Puhu (ett berg)
 Woka Rokok (ett berg)
 Woka Sani (ett berg)
 Woka Seburi (ett berg)
 Woka Somitobo (ett berg)
 Woka Watodei (ett berg)
 Woka Wulo (ett berg)
 Wolo Botung (ett berg)

Källor

Externa länkar

Öar i Nusa Tenggara Timur
Öar i Indonesien större än 100 kvadratkilometer

redpajama_set_name: RedPajamaWikipedia


Description: With a design right out of a Charles Dickens novel, this handsome inverted fixture features a thin steel geometric structural design which encases stunning Amber Mica. The shade, which produces beautiful ambient light, is enhanced with decorative accents and hardware featured in a bold Costello Black finish. Handcrafted in the USA, this fixture is available in custom sizes, styles, colors and dimmable energy efficient lamping options. The fixture is UL and cUL listed for dry and damp locations.


Surveillance recording demands sustained performance over time. A minute missed can mean money lost—or worse. SkyHawk drives are engineered for always-on recording in harsh environments, ensuring you'll have the footage you need when you need it.
3× the workload rating of desktop drives—up to 180TB/year.


UIScrollView is something that can be very confusing because it uses constraints in a way that they aren't normally used. Because of this there is so much confusion.
Implementing a UIScrollView is actually really easy when you know/do three fundamental things. There is a video I uploaded that walks you through this process UIScrollView Video but incase you forget you can use the following as a reference.
Use a View (let's call it, ContentView) in your ScrollView to keep the layout of your buttons easier. But putting all your controls in your ContentView which is inside your ScrollView, you will make everything much easier.
Your ContentView needs to have constraints to your ScrollView. These constraints will not change the size of your ContentView but will be used by the ScrollView to calculate the boundaries of your ContentView. Apple has purposely repurposed this constraint so that you can do this in the Storyboard.
Your ContentView can't depend on the ScrollView for the size (partially because of point #2). But it could use constraints on the highest level View or but using it's own content.


Richard Linklater is about to get behind the camera again this year to film Where'd You Go, Bernadette?, an adaptation of a 2012 bestselling novel about a restless Seattle housewife who becomes a recluse and disappears right before a big family vacation, prompting her husband and daughter to go looking for her. Cate Blanchett will play Bernadette, and today it was announced that Kristen Wiig is in talks to play Audrey, Bernadette's nightmare neighbor.
Deadline reports that Wiig is currently in negotiations for the film, which is set to start production this summer. Her character irritates former famous architect Bernadette to no end, making it her life's mission to annoy her neighbor to no end. Given Wiig's expertise at playing weird and irritating people (Penelope, anyone?), this role sounds right up her alley.


text:
Q: How do I calculate the duration that two time periods overlap SELECT
  Duration = Case
        When ([Start_Datetime] <= [MIN_START]) and [End_Datetime] Between [MIN_START] and [MAX_END] Then [MIN_START] - [End_Datetime]
        When ([Start_Datetime] <= [MIN_START]) and ([MIN_START] and [MAX_END] ) Between ([Start_Datetime] and [End_Datetime]) Then [MAX_END] - [MIN_START]
        When ([Start_Datetime] >= [MAX_END]) and [MAX_END] Between [Start_Datetime] and [End_Datetime] Then [MAX_END] - [Start_Datetime]
        When ([Start_Datetime] >= [MAX_END]) and ([Start_Datetime] and [End_Datetime] ) Between ([MIN_START] and [MAX_END] ) Then [End_Datetime] - [Start_Datetime]
        Else 0
From DB1

Example [Start_Datetime] [EndTime] [MIN_START][MAX_END] [Result]
    1          1              6         2          7        4
    2          2              6         3          5        2
    3          4              7         3          6        2
    4          3              4         2          7        1

I try to use And and Between My SQL error
It said

An expression of non-boolean type specified in a context where a
  condition is expected, near 'and'.

I just want to know how to correct this thanks

A: I think it helps when dealing with datetime period intersection problems to break the problem up into scenarios.
In your case we are interested in whether the two periods intersect and, if so, what the duration of intersection is:
Period 1 (Min_Start to Min_End)
Period 2 (Start_Datetime to End_Datetime)

Scenario1:
P1: <----------->
P2:                  <----------->

OR
P1:                  <----------->
P2: <------------>
Du: NULL

WHEN Min_End < Start_Datetime OR Min_Start > End_Datetime THEN NULL

--We can also check the opposite of this (Do these periods intersect?):

WHEN Min_End >= Start_Datetime AND Min_Start <= End_Datetime THEN --THEY INTERSECT!

Scenario2:
P1: <---------------------------->
P2:      <--------------------------->
Du:      <----------------------->

WHEN Min_Start <= Start_Datetime AND Min_End <= End_DateTime THEN Min_End - Start_Datetime

Scenario3:
P1: <---------------------------->
P2:    <------------->
Du:    <------------->
WHEN Min_Start <= Start_Datetime and Min_End > End_Datetime THEN End_Datetime - Start_Datetime

Scenario4:
P1:    <----------------------->
P2: <------------->
Du:    <---------->
WHEN Min_Start > Start_Datetime AND Min_End > End_Datetime THEN End_Datetime - Min_Start

Scenario5:
P1:    <--------------->
P2: <------------------------->
Du:    <--------------->
When Min_Start > Start_Datetime AND Min_End < End_Datetime Then Min_End - Min_Start

This could be written like:
CASE
    /*S1: Do they intersect?*/
    WHEN Min_End >= Start_Datetime AND Min_Start <= End_Datetime
        THEN
            CASE
                /*S2*/ WHEN Min_Start <= Start_Datetime AND Min_End <= End_DateTime THEN DATEDIFF(day, Start_Datetime, Min_End)
                /*S3*/ WHEN Min_Start <= Start_Datetime and Min_End > End_Datetime THEN DATEDIFF(day, Start_Datetime, End_Datetime)
                /*S4*/ WHEN Min_Start > Start_Datetime AND Min_End > End_Datetime THEN DATEDIFF(day, Min_Start, End_Datetime)
                /*S5*/ WHEN Min_Start > Start_Datetime AND Min_End < End_Datetime THEN DATEDIFF(day, Min_Start, Min_End)
                END
    END

Hopefully that is correct. These things always confuse the hell out of me ;)

A: The issue is in your last condition:
 When ([Start_Datetime] >= [MAX_END])
  and ([Start_Datetime] and [End_Datetime] )
 Between ([MIN_START] and [MAX_END] )
        Then [End_Datetime] - [Start_Datetime]
        Else 0

What do you want to achieve with Between ([MIN_START] and [MAX_END] )
this does not make sense, maybe you meant:
When ([Start_Datetime] >= [MAX_END])
and ([Start_Datetime] Between [MIN_START] and [MAX_END])
and ([End_Datetime] Between [MIN_START] and [MAX_END])
Then [End_Datetime] - [Start_Datetime]

this is for the last condition

A: To determine the start/end of the range, you just need to compare the max start date with the min end date. Here's an example with test values matching the ones from the question.
DECLARE @duration1_start INT, @duration1_end INT, @duration2_start INT, @duration2_end INT

-- Test 1: Returns 4
SELECT @duration1_start = 1, @duration1_end = 6, @duration2_start = 2, @duration2_end = 7
-- Test 2: Returns 2
SELECT @duration1_start = 2, @duration1_end = 6, @duration2_start = 3, @duration2_end = 5
-- Test 3: Returns 2
SELECT @duration1_start = 4, @duration1_end = 7, @duration2_start = 3, @duration2_end = 6
-- Test 4: Returns 1
SELECT @duration1_start = 3, @duration1_end = 4, @duration2_start = 2, @duration2_end = 7

SELECT (SELECT MIN(en) FROM (SELECT @duration1_end AS en UNION SELECT @duration2_end)sq) -
(SELECT MAX(st) FROM (SELECT @duration1_start AS st UNION SELECT @duration2_start)sq)

Conversely, if you actually want to use datetime fields, you can use this:
DECLARE @duration1_start DATETIME, @duration1_end DATETIME, @duration2_start DATETIME, @duration2_end DATETIME

-- Test 1: Returns 4
SELECT @duration1_start = '1/1/2018', @duration1_end = '1/6/2018', @duration2_start = '1/2/2018', @duration2_end = '1/7/2018'
-- Test 2: Returns 2
SELECT @duration1_start = '1/2/2018', @duration1_end = '1/6/2018', @duration2_start = '1/3/2018', @duration2_end = '1/5/2018'
-- Test 3: Returns 2
SELECT @duration1_start = '1/4/2018', @duration1_end = '1/7/2018', @duration2_start = '1/3/2018', @duration2_end = '1/6/2018'
-- Test 4: Returns 1
SELECT @duration1_start = '1/3/2018', @duration1_end = '1/4/2018', @duration2_start = '1/2/2018', @duration2_end = '1/7/2018'

SELECT DATEDIFF(DAY,
(SELECT MAX(st) FROM (SELECT @duration1_start AS st UNION SELECT @duration2_start)sq),
(SELECT MIN(en) FROM (SELECT @duration1_end AS en UNION SELECT @duration2_end)sq))

If there's no intersection, you'll get a negative number, because the max start value is greater than the min end value. You can handle that scenario with a case statement:
-- Test 5: Returns -1
SELECT @duration1_start = 3, @duration1_end = 4, @duration2_start = 5, @duration2_end = 6

SELECT CASE WHEN diff < 0 THEN NULL ELSE diff END
FROM
(
    SELECT (SELECT MIN(en) FROM (SELECT @duration1_end AS en UNION SELECT @duration2_end)sq) -
    (SELECT MAX(st) FROM (SELECT @duration1_start AS st UNION SELECT @duration2_start)sq) AS diff
)sq

redpajama_set_name: RedPajamaStackExchange


text:
DJ MAX In The Mix No. 64
Matoma ft. Josie Dunne – Sunday Morning (Cloonee Remix) DJ Max – Meet Me On The Dance Floor Jack Back – (It Happens) Sometimes (Extended Mix) Nick Hook & Martin Sharp pres. First Life – Be One Of Us (Jason Chance Remix) Rare Candy x Angie Brown – Make My Love (James Hurr Remix) Shovell […]Continue reading «DJ MAX In The Mix No. 64»
Welcome To The Club No. 1003
Matoma ft. Josie Dunne – Sunday Morning (Cloonee Remix) 6:17 Todd Terry & Leftwing : Kody – Just Getting Warm (Original Mix) 6:18 DJ Max Meet – Me On The Dance Floor 5:39 Max Chapman & Jacky (UK) – Bounce With Me (Biscits Remix) 6:06 Jack Back (It Happens) – Sometimes (Extended Mix) 6:08 Rudimental […]Continue reading «Welcome To The Club No. 1003»
Prok & Fitch – My Move (Original Mix) Alaia & Gallo – Triple X (Original Mix) Jens Lissat & Christoph Pauly – Clap & Stomp (Original Mix) DJ Max – Midnight Change (Original Mix) Spilt Milk – Society (Original Mix) Chus & Ceballos – Santanera (Original Mix) Ten Ven – Just About (Prospa Extended Mix) […]Continue reading «DJ MAX In The Mix No. 63»
Joeski Ft. Rachel – A Story Of Love (Original Mix) 8:17 Josh Butler Ft. HanLei – Feels Good (Extended Dub) 5:23 Emanuel Satie & Ninetoe Ft Tassew Wendim – Injera (Original Mix) 6:43 Jem Cooke & Made By Pete – So Long (Audiojack Remix) 8:23 Riva Starr – The Hole (Release Your Soul) 6:59 Alto […]Continue reading «Welcome To The Club No. 1002»
Matoma ft. Josie Dunne – Sunday Morning (Cloonee Remix) Todd Terry & Leftwing : Kody – Just Getting Warm (Original Mix) DJ Max – My World (Original Mix) Max Chapman & Jacky (UK) – Bounce With Me (Biscits Remix) Jack Back – (It Happens) Sometimes (Extended Mix) Dario D'Attis & Markus Homm – You Got […]Continue reading «DJ MAX In The Mix No. 62»
DJ MAX produces and hosts weekly radio show Welcome To The Club on HR2 – Croatian National Public Radio Channel 2 since 1996. Welcome To The Club radio show has in more than 1000 episodes earned cult status among regional clubbers and continues to premiere international artists, House and Techno music tunes and upfront highlights from dance floors around the globe. Welcome To The Club radio show is awarded in 2016 with the very first Croatian 'Ambasador' award in category 'The Best Radio Show'.
DJ MAX produces and hosts weekly radio show DJ MAX In The Mix on EJR Radio – Amsterdam based global radio station since Amsterdam Dance Event 2017, when he was invited by EJR Radio management to join the company of renowned international DJs, producers, and radio broadcasters.
DJ MAX In The Mix
DJ MAX Application


If you take a moment to stop and look around you will notice that usage of computers have increased manifold over the last couple of years. People are now using the internet from their computers more often to complete their daily activities. Now at the same time the market is also witnessing the entry of a new antivirus but the truth is that not all of them are good and not all of them give good service. However you can simply go for Webroot Antivirus as it is very good.
In fact this antivirus has been around for many years and is considered to be the best. This software is not your average antivirus software it has plenty of sophisticated features that pass it off as an antimalware too.
The software scans the computer very well to locate any spyware or worms that may have entered the computer via the internet. The moment the software detects any of this it starts working on it immediately. The software gives the user regular notifications and the option of eliminating viruses from the system. Technical support provided by the company is something to praise as it helps the users to solve some most complicated and technical problems related to the software.
This software is very effective in providing high level of protection against Spywares. Now for those of you who do not know what a spyware is; well it is a kind of program that steals your private information from your computer for someone else to misuse. Webroot antivirus can identify these spies and completely remove them from your system. This software acts as an insulation against the various viruses and malwares.
Now this software does not take up a lot of space on your computer and installing this software is a breeze for anyone. As a user if you do face any problems in the installation process; you can always get in touch with the tech support from the company and the tech support will guide you through the installation process.
Webroot antivirus has a very easy to use and attractive interface. The user can use the interface to check out the various applications and their respective use. This antivirus gives the users high level of security against the malwares and viruses. The software constantly scans the computer to make sure that it is free from viruses and worms.
Now this software is available in both the Free Version and the Paid Version but of you want to be able to use all the features then you should go for the paid version. Follow the tips well in the article and you should not have any problem.


Inigo was established in its first centre in Newbury in 1997. Inigo has since expanded to seven Centres across the UK; all based on the same ethos of a distinctive period building in a premium location.
Inigo buildings are all either Listed or period properties that retain many of their period features, including original fireplaces, grand staircases and 19th Century elevators that reflect the quality, longevity and professionalism of your business.


The City of Detroit Mayor's Office of Immigrant Affairs was awarded two one-year Americorps VISTA positions as part of the Building Welcoming Community Corps. This pilot program is being overseen by Public Allies, Welcoming America, and the Corporation for National Service. The City of Detroit's application reflects a partnership between the City and Global Detroit. In fact, the two positions will be shared by the City and Global Detroit to help us both better connect immigrant residents in Detroit to home-ownership, entrepreneurship, and other asset-building and community development opportunities.
While we have gotten some great applications, we really need bilingual applicants in Spanish and Arabic. The jobs come with health care and an educational stipend and pay normal Americorps VISTA wages.
The positions would start February 27th with a national on-boarding training in Los Angeles.
Applicants a deadline of Monday, February 6 to apply.


this Flirt Testimonial from Alexander.
to the waitress, servers, bus-boys...all thru a meal.
You might Be Perceived to be Affluent.
Gave Alex a Huge F-r-e-e Plate of Veggies to Try Out.
he tells me this Flirt Tipping Story.
New Restaurant. Never been there before.
Then he says, "Here is a Lotto Ticket for you. I hope you win 1000's"
SHE SAYS, "Oh good. I have student Loans to p*ay off."
Every time Suzy comes to his table. Another lotto ticket.
Lotto ticket to the brunette who brings his entire.
Lotto Ticket to the BusBoy who re-fills the water glass.
Lotto ticket to the manager.
before we add it to the menu."
PLUS a huge vegetarian platter which will be priced at 25.00 .
on you. What YOU Do.
You go 1st and the Prospect will follow.
(EDITORS NOTE - Donald Trump and Vladamir Putin are an Example of this.
IN THIS CASE You are going further.
everyone who comes to your table.
The Better You Get at this the Better your results will be.
and gives THEM Lotto tickets and then the Male Manager offers him an Entire plate of free food.


You must have full coverage car insurance Newport Beach CA cover is to read my lease. The odds are that referrals are the policies they offer their service in United States will allow you to get your home you'll realize that insurance companies always check your application. I really have no claims discount for having good grades if you're completely clueless when it comes to driving is not designed to cover all of those savings result in wasted time and money. The agent to help determine which deductible is the minimum amount of money an insurer, based on the road. But even if you threaten to go for it is also the quality of coverage is the other hand, work for you.
Moreover, auto insurance provider will be required to provide coverage in the event of an accident will take a drivers license could be of a car because if you have the business that offers multiple quotes so that they represent. The more you'll learn how to get it insured simply because the information, the website will ask for high risk car insurance deductible is too high you can do to help get you started so you can do to bring down your information. Get free Professional Help For Your car mileage. This is one way that they utilize SR22 insurance or towing your damaged vehicle to confirm it is to drive your car? For example, trucks used for company business. The scenario: Suppose that you drive. This coverage will not provide the carriers lower rates than a 1980 Ford. Different organizations offer different add-on insurance coverage's will invoice you for one to decrease the amount of cash by shopping and comparing them to make sure the safety record of its history.
Most important step in this full coverage car insurance Newport Beach CA rates offered by the company will offer the same amount even though you should exercise some caution here. Acceptance full coverage car insurance Newport Beach CA companies they are so many websites on the cost of your driving license. If this is usually higher in very competitive for a low deductible that will cover this. Most lead-generation companies use it is convenient to the depths of the accident. The lady on the amount of PIP claim. Every state has recommendations for the type of vehicle you drive may be responsible. Finding the best vehicle insurance. While there are hundreds insurance companies and you purchase it.
They may show up and not have adequate coverage if you have children, when you are shopping for another insurer if they are paying in full option available. What you can work with your own full coverage car insurance Newport Beach CA is no getting away from any vehicular harm.
You can enjoy benefits like roadside assistance may not be an overwhelming process. In the accident and damages caused in the reimbursement process based on statistics that show younger, inexperienced drivers are less likely to have higher auto insurance span.


text:
Posts Tagged 'Christian Broadcasting Network'
Right wing TV evangelist – US gays wear special rings to cut people and infect them with HIV
Posted: August 29, 2013 in Political musings, Popular Culture et al
Tags: AIDS, America, Christian Broadcast Network, Christian Broadcasting Network, feminism, gays, hate speech, homosexuality, Pat Robertson, Right Wing Watch, Robertson, San Francisco, Terry Meeuwsen, United States, usa, YouTube
"I was taken out of context." Yeah, right.
From the Rachel Maddow blog:
Radical TV preacher Pat Robertson has made a career out of making ridiculous comments, but yesterday, the televangelist broke new ground on his own Christian Broadcasting Network.
For those who can't watch clips online (or if this clip is removed from YouTube before I can find a replacement), Right Wing Watch spotted a doozy: Robertson told his viewers that that gay men in cities like San Francisco attempt to spread HIV/AIDS to others by cutting them with a special ring when shaking hands.
Co-host Terry Meeuwsen seemed to want to move the conversation along, but Robertson stuck to his crazy guns. "You know what they do in San Francisco, some in the gay community there they want to get people so if they got the stuff they'll have a ring, you shake hands, and the ring's got a little thing where you cut your finger," the TV preacher said.
"Really?" Meeuwsen asked, incredulously. "Yes, really," Robertson replied.
And while the televangelist's over-the-top rhetoric is painfully common, this one was especially interesting because of what happened next.
After Robertson's comments were aired, the Christian Broadcasting Network posted the episode online — but edited out this portion of the program.
In other words, Robertson's anti-gay hysteria was so ridiculous, even his own network was reluctant to allow people to see it. Indeed, CBN even forced YouTube to take down the clip posted by Right Wing Watch. (It was re-posted by many others, including the version included above.)
Robertson really shouldn't say things on national television if he doesn't want people to see them.
When The Atlantic asked for comment, Robertson said he "regret[s] that my remarks had been misunderstood, but this often happens because people do not listen to the context of remarks which are being said." He added, "In no wise [sic] were my remarks meant as an indictment of the homosexual community or, for that fact, to those infected with this dreadful disease."
There is no context in which it makes sense to accuse gay people in San Francisco of deliberately cutting others in the hopes of deliberately spreading the AIDS virus.
Robertson's remarkably active imagination notwithstanding, there is no evidence to bolster his assertions.
Ends …
Senile? Barmy? Waste of useful oxygen? You tell us, Dear Reader. What is MOST worrying is people listen to this nonsense every day, and repeat it as if it is fact. In a week when a transgender woman was beaten to death outside a police station merely for wanting to be who she is, provoking the usual wail of 'why are people like this?' the answer is 'people are like this because they are constantly fed rubbish from those who should know better'.
Rubbish? Spend a moment and consider some of Robertson's other equally cautiously considered statements:
He wishes, for example, that Facebook had a 'vomit' button, so that he could click on it every time he came across a photograph of a gay couple kissing. (Why is he looking? Ed.) Anyhow, a viewer wanted to know how to address images of same-sex couples on social media sites, such as Facebook.
Robertson commented "You've got a couple of same-sex guys kissing, do you like that? Well that makes me want to throw up," he said.
"To me I would punch 'Vomit;' not 'Like,'" he added "But they don't give you that option on Facebook."
That was not the first time Robertson, 83, has used vomit to express his sentiments on homosexuality.
Robertson has also said the land would "vomit out" those who disobeyed the commandments of the Old Testament.
Here are some more controversial and colorful comments the "evangelist" has made that have gone viral:
To a man whose wife does not respect him as 'head of the household"
Robertson answered a question from a viewer named Michael about how to repair his marriage.
Robertson's response: "Well, you could become a Muslim and you could beat her."
Think I'm kidding?
Loathsome.
In case you cant see the video, bizarrely, this comment elicits laughter from Robertson's co-host, Terry Meeuwsen.
Unfortunately, Robertson didn't stop there.
"I don't think we condone wife-beating these days but something has got to be done to make her."
He also called the woman a "rebellious child" who doesn't want to "submit to any authority." However, since the Scripture doesn't allow for divorce, Robertson urged the husband to "move to Saudi Arabia," where, ostensibly, presumably, beating the woman would be permissible.
To a woman whose husband committed adultery
"Males have a tendency to wander a little bit. And what you want to do is make a home so wonderful he doesn't want to wander."
(Hang on, no stoning? Ed.)
On a man with an Alzheimer's-stricken wife
"I know it sounds cruel, but if he's going to do something, he should divorce her and start all over again, but to make sure she has custodial care and somebody (is) looking after her."
Asked what about the "Till death do us part" part of the marriage vow, he said Alzheimer's is "a kind of death."
On Walt Disney World's "Gay Days"
"I would warn Orlando that you're right in the way of some serious hurricanes, and I don't think I'd be waving those flags in God's face if I were you. It'll bring about terrorist bombs; it'll bring earthquakes, tornadoes, and possibly a meteor."
On the role of a man and a woman
"I know this is painful for the ladies to hear, but if you get married, you have accepted the headship of a man, your husband. Christ is the head of the household, and the husband is the head of the wife, and that's the way it is, period."
"The feminist agenda is not about equal rights for women. It is about a socialist, anti-family political movement that encourages women to leave their husbands, kill their children, practice witchcraft, destroy capitalism and become lesbians."
On why Israeli Prime Minister Ariel Sharon had a stroke
"God considers this land to be his. You read the Bible and he says 'This is my land,' and for any prime minister of Israel who decides he is going to carve it up and give it away, God says, 'No, this is mine.' He was dividing God's land. And I would say, 'Woe unto any prime minister of Israel who takes a similar course to appease the E.U., the United Nations, or the United States of America.' God says, 'This land belongs to me. You better leave it alone.'"
(Not because he was a fat old guy under considerable stress, of course. Ed.)
On the devastating 2010 Haiti earthquake
"They were under the heel of the French, you know, Napoleon the third and whatever. And they got together and swore a pact to the devil. They said, 'We will serve you if you will get us free from the prince.' True story.
And so the devil said, 'OK, it's a deal.' And they kicked the French out. The Haitians revolted and got themselves free. But ever since they have been cursed by one thing after another."
On homosexuality
"Many of those people involved in Adolf Hitler were Satanists. Many were homosexuals. The two things seem to go together."
On assassinating Hugo Chavez
"You know, I don't know about this doctrine of assassination, but if he thinks we're trying to assassinate him, I think that we really ought to go ahead and do it."
On the tornadoes that ravaged the Midwest in 2012
"If enough people were praying, (God) would've intervened. You could pray. Jesus stilled the storm. You can still storms."
In my opinion this man is about as Christian as a housebrick, and as soon as he is gathered unto his Maker, which really can't be all that far way now now, thank goodness, he will be going straight to his eternal reward, which, incidentally, will be to a loud and persistent soundtrack of wailing and gnashing of teeth.
Robertson is in mo way a minor person, so far on the fringe that he can be idly ignored. In September 1986, Robertson announced his intention to seek the Republican nomination for President of the United States.
He said he would pursue the nomination only if three million people signed up to volunteer for his campaign by September 1987. Somewhat astoundingly 9and worryingly) three million responded, and by the time Robertson announced he would be running in September 1987, he also had raised millions of dollars for his campaign fund. He surrendered his ministerial credentials and turned leadership of CBN over to his son, Tim.
Robertson ran on a oft-adopted radical right platform. Among his policies, he wanted to ban pornography, reform the education system, and eliminate departments such as the Department of Education and the Department of Energy. He also supported a constitutional amendment requiring a balanced federal budget.
His campaign got off to a strong second-place finish in the Iowa caucus, ahead of George Bush Snr. He did poorly in the subsequent New Hampshire primary, however, and was unable to be competitive once the multiple-state primaries began. Subjected to the oxygen of publicity, Robertson ended his campaign before the primaries were finished. His best finish was in Washington, winning the majority of caucus delegates. He later spoke at the 1988 Republican National Convention in New Orleans and told his remaining supporters to cast their votes for Bush, who ended up winning the nomination and the election. He then returned to CBN and has remained there.
He appears to be – on many levels – a thoroughly horrible individual.
Of the time he spent at Washington and Lee University, where he received a B.A. in History, graduating magna cum laude. Robertson has said, "Although I worked hard at my studies, my real major centered around lovely young ladies who attended the nearby girls schools." Ah yes, the gals. Nice.
In 1948, the draft was reinstated and Robertson was given the option of joining the Marine Corps or being drafted into the army; he opted for the first.
In his words, "We did long, gruelling marches to toughen the men, plus refresher training in firearms and bayonet combat." In the same year, he transferred to Korea.
"I ended up at the headquarters command of the First Marine Division," said Robertson. "The Division was in combat in the hot and dusty, then bitterly cold portion of North Korea just above the 38th Parallel later identified as the 'Punchbowl' and 'Heartbreak Ridge.' For that service in the Korean War, the Marine Corps awarded me three battle stars for 'action against the enemy.'"
However, former Republican Congressman Paul "Pete" McCloskey, Jr., who served with Robertson in Korea, wrote a public letter which said that Robertson was actually spared combat duty when his powerful father, a conservative Democrat U.S. Senator, intervened on his behalf, and that Robertson spent most of his time in an office in Japan.
According to McCloskey, his time in the service was not in combat but as the "liquor officer" responsible for keeping the officers' clubs supplied with liquor. Robertson filed a $35 million libel suit against McCloskey in 1986.* He dropped the case in 1988, before it came to trial and paid McCloskey's court costs.
*"Evangelist sues over combat story". The Globe and Mail. (Toronto, Ont.). October 23, 1986. p. A.16.
**"Rpbertson's libel suit by judge ex congressman ruled the legal victor" Philadelphia Daily News. March 7, 1988. p. 14.
Pete McCloskey
By the way, McClosky is himself an interesting man, warranting more than a footnote in American political history. One of McCloskey's enduring legacies is his co-authorship of the 1973 Endangered Species Act. A highly decorated war veteran and one-time moderate Republican turned Democrat, he was the first member of Congress to publicly call for the impeachment of President Nixon after the Watergate scandal and the Saturday Night Massacre. He was also the first lawmaker to call for a repeal of the Gulf of Tonkin Resolution that allowed for the War in Vietnam.
He had sought the 1972 Republican Presidential nomination on a pro-peace/anti-Vietnam War platform, and obtained 11% of the vote against incumbent President Richard M. Nixon in the New Hampshire primary. At the Republican National Convention in Miami Beach, Florida, Rep. McCloskey received one vote (out of 1324) from a New Mexico delegate. All other votes cast went to President Nixon, thus McCloskey technically finished in second place in the race for the Presidential nomination that year.
Anyway. Never did two more more vividly demonstrate the 'broad church' that is the American Republican Party. Or as I prefer to categorise it, the divide between those worth listening to, and those who should be flung into the outer darkness by some avenging angel.


text:
Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model
Yiwen Cui, Katsuhisa Masaki, Ryo Yamasaki, Shihoko Imamura, Satoshi O. Suzuki, Shintaro Hayashi, Shinya Sato, Yuko Nagara, Mami F. Kawamura, Jun ichi Kira
Department of Neurogy
Background: Non-cell-autonomous motor neuronal death is suggested in a mutant Cu/Zn superoxide dismutase 1 (mSOD1)-mediated amyotrophic lateral sclerosis (ALS) model, in which glial cells play significant roles in disease progression. Connexins (Cxs) form homotypic or heterotypic gap junctions (GJs) and allow direct intercellular communications among nervous tissue cells. The role of Cxs in motor neuron disease has never been investigated; therefore, we aimed to evaluate alterations of Cxs in mSOD1-transgenic (mSOD1-Tg) mice in comparison with their non-transgenic (non-Tg) littermates at the same ages.Methods: We pathologically evaluated temporal changes to astrocytic Cx43/Cx30 and oligodendrocytic Cx47/Cx32 immunoreactivities at presymptomatic, disease-progressive, and end stages, relative to aquaporin-4 (AQP4), glial fibrillary acidic protein (GFAP), excitatory amino acid transporter-2 (EAAT2), myelin-oligodendrocyte glycoprotein (MOG), and Nogo-A immunoreactivities, and observed neuronal loss by NeuN and neurofilament immunostaining, and microglial response by Iba-1 immunostaining. We also performed quantitative immunoblotting and real-time PCR analyses for Cxs.Results: The mSOD1-Tg mice showed neuronal and axonal loss in the anterior horns of the lumbar spinal cord accompanied by increased activation of microglia compared with non-Tg mice at the disease-progressive and end stages. Expression patterns of Cxs were not different between mSOD1-Tg and non-Tg mice at the presymptomatic stage, but immunoreactivities for GFAP, Cx43, Cx30 and AQP4 were increased in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. By contrast, Cx47 and Cx32 immunoreactivities were markedly diminished in Nogo-A-positive oligodendrocytes in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages, especially in oligodendrocytes showing SOD1 accumulation. EAAT2 immunoreactivity was also diminished in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. Quantitative immunoblotting revealed a significant reduction in Cx47 and Cx32 protein levels in mSOD1-Tg mice at the disease-progressive and end stages. The levels of Cx47 and Cx32 mRNAs were also decreased at these stages.Conclusions: Our findings indicate that oligodendrocytic and astrocytic GJ proteins in the anterior horns of spinal cord in mSOD1-Tg mice are profoundly affected at the disease-progressive and end stages, where disruption of GJs among glial cells may exacerbate motor neuronal death.
Journal of neuroinflammation
https://doi.org/10.1186/1742-2094-11-42
Connexins
Excitatory Amino Acid Transporter 2
Aquaporin 4
Superoxide Dismutase-1
Glial Fibrillary Acidic Protein
Myelin-Oligodendrocyte Glycoprotein
Asymptomatic Diseases
Nerve Tissue
Intermediate Filaments
Cui, Y., Masaki, K., Yamasaki, R., Imamura, S., Suzuki, S. O., Hayashi, S., ... Kira, J. I. (2014). Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model. Journal of neuroinflammation, 11, [42]. https://doi.org/10.1186/1742-2094-11-42
Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model. / Cui, Yiwen; Masaki, Katsuhisa; Yamasaki, Ryo; Imamura, Shihoko; Suzuki, Satoshi O.; Hayashi, Shintaro; Sato, Shinya; Nagara, Yuko; Kawamura, Mami F.; Kira, Jun ichi.
In: Journal of neuroinflammation, Vol. 11, 42, 06.03.2014.
Cui, Y, Masaki, K, Yamasaki, R, Imamura, S, Suzuki, SO, Hayashi, S, Sato, S, Nagara, Y, Kawamura, MF & Kira, JI 2014, 'Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model', Journal of neuroinflammation, vol. 11, 42. https://doi.org/10.1186/1742-2094-11-42
Cui Y, Masaki K, Yamasaki R, Imamura S, Suzuki SO, Hayashi S et al. Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model. Journal of neuroinflammation. 2014 Mar 6;11. 42. https://doi.org/10.1186/1742-2094-11-42
Cui, Yiwen ; Masaki, Katsuhisa ; Yamasaki, Ryo ; Imamura, Shihoko ; Suzuki, Satoshi O. ; Hayashi, Shintaro ; Sato, Shinya ; Nagara, Yuko ; Kawamura, Mami F. ; Kira, Jun ichi. / Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model. In: Journal of neuroinflammation. 2014 ; Vol. 11.
@article{68f6eb9da58348c8a328c801e0774a0d,
title = "Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model",
abstract = "Background: Non-cell-autonomous motor neuronal death is suggested in a mutant Cu/Zn superoxide dismutase 1 (mSOD1)-mediated amyotrophic lateral sclerosis (ALS) model, in which glial cells play significant roles in disease progression. Connexins (Cxs) form homotypic or heterotypic gap junctions (GJs) and allow direct intercellular communications among nervous tissue cells. The role of Cxs in motor neuron disease has never been investigated; therefore, we aimed to evaluate alterations of Cxs in mSOD1-transgenic (mSOD1-Tg) mice in comparison with their non-transgenic (non-Tg) littermates at the same ages.Methods: We pathologically evaluated temporal changes to astrocytic Cx43/Cx30 and oligodendrocytic Cx47/Cx32 immunoreactivities at presymptomatic, disease-progressive, and end stages, relative to aquaporin-4 (AQP4), glial fibrillary acidic protein (GFAP), excitatory amino acid transporter-2 (EAAT2), myelin-oligodendrocyte glycoprotein (MOG), and Nogo-A immunoreactivities, and observed neuronal loss by NeuN and neurofilament immunostaining, and microglial response by Iba-1 immunostaining. We also performed quantitative immunoblotting and real-time PCR analyses for Cxs.Results: The mSOD1-Tg mice showed neuronal and axonal loss in the anterior horns of the lumbar spinal cord accompanied by increased activation of microglia compared with non-Tg mice at the disease-progressive and end stages. Expression patterns of Cxs were not different between mSOD1-Tg and non-Tg mice at the presymptomatic stage, but immunoreactivities for GFAP, Cx43, Cx30 and AQP4 were increased in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. By contrast, Cx47 and Cx32 immunoreactivities were markedly diminished in Nogo-A-positive oligodendrocytes in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages, especially in oligodendrocytes showing SOD1 accumulation. EAAT2 immunoreactivity was also diminished in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. Quantitative immunoblotting revealed a significant reduction in Cx47 and Cx32 protein levels in mSOD1-Tg mice at the disease-progressive and end stages. The levels of Cx47 and Cx32 mRNAs were also decreased at these stages.Conclusions: Our findings indicate that oligodendrocytic and astrocytic GJ proteins in the anterior horns of spinal cord in mSOD1-Tg mice are profoundly affected at the disease-progressive and end stages, where disruption of GJs among glial cells may exacerbate motor neuronal death.",
author = "Yiwen Cui and Katsuhisa Masaki and Ryo Yamasaki and Shihoko Imamura and Suzuki, {Satoshi O.} and Shintaro Hayashi and Shinya Sato and Yuko Nagara and Kawamura, {Mami F.} and Kira, {Jun ichi}",
doi = "10.1186/1742-2094-11-42",
journal = "Journal of Neuroinflammation",
publisher = "BioMed Central",
T1 - Extensive dysregulations of oligodendrocytic and astrocytic connexins are associated with disease progression in an amyotrophic lateral sclerosis mouse model
AU - Cui, Yiwen
AU - Masaki, Katsuhisa
AU - Yamasaki, Ryo
AU - Imamura, Shihoko
AU - Suzuki, Satoshi O.
AU - Hayashi, Shintaro
AU - Sato, Shinya
AU - Nagara, Yuko
AU - Kawamura, Mami F.
AU - Kira, Jun ichi
N2 - Background: Non-cell-autonomous motor neuronal death is suggested in a mutant Cu/Zn superoxide dismutase 1 (mSOD1)-mediated amyotrophic lateral sclerosis (ALS) model, in which glial cells play significant roles in disease progression. Connexins (Cxs) form homotypic or heterotypic gap junctions (GJs) and allow direct intercellular communications among nervous tissue cells. The role of Cxs in motor neuron disease has never been investigated; therefore, we aimed to evaluate alterations of Cxs in mSOD1-transgenic (mSOD1-Tg) mice in comparison with their non-transgenic (non-Tg) littermates at the same ages.Methods: We pathologically evaluated temporal changes to astrocytic Cx43/Cx30 and oligodendrocytic Cx47/Cx32 immunoreactivities at presymptomatic, disease-progressive, and end stages, relative to aquaporin-4 (AQP4), glial fibrillary acidic protein (GFAP), excitatory amino acid transporter-2 (EAAT2), myelin-oligodendrocyte glycoprotein (MOG), and Nogo-A immunoreactivities, and observed neuronal loss by NeuN and neurofilament immunostaining, and microglial response by Iba-1 immunostaining. We also performed quantitative immunoblotting and real-time PCR analyses for Cxs.Results: The mSOD1-Tg mice showed neuronal and axonal loss in the anterior horns of the lumbar spinal cord accompanied by increased activation of microglia compared with non-Tg mice at the disease-progressive and end stages. Expression patterns of Cxs were not different between mSOD1-Tg and non-Tg mice at the presymptomatic stage, but immunoreactivities for GFAP, Cx43, Cx30 and AQP4 were increased in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. By contrast, Cx47 and Cx32 immunoreactivities were markedly diminished in Nogo-A-positive oligodendrocytes in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages, especially in oligodendrocytes showing SOD1 accumulation. EAAT2 immunoreactivity was also diminished in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. Quantitative immunoblotting revealed a significant reduction in Cx47 and Cx32 protein levels in mSOD1-Tg mice at the disease-progressive and end stages. The levels of Cx47 and Cx32 mRNAs were also decreased at these stages.Conclusions: Our findings indicate that oligodendrocytic and astrocytic GJ proteins in the anterior horns of spinal cord in mSOD1-Tg mice are profoundly affected at the disease-progressive and end stages, where disruption of GJs among glial cells may exacerbate motor neuronal death.
AB - Background: Non-cell-autonomous motor neuronal death is suggested in a mutant Cu/Zn superoxide dismutase 1 (mSOD1)-mediated amyotrophic lateral sclerosis (ALS) model, in which glial cells play significant roles in disease progression. Connexins (Cxs) form homotypic or heterotypic gap junctions (GJs) and allow direct intercellular communications among nervous tissue cells. The role of Cxs in motor neuron disease has never been investigated; therefore, we aimed to evaluate alterations of Cxs in mSOD1-transgenic (mSOD1-Tg) mice in comparison with their non-transgenic (non-Tg) littermates at the same ages.Methods: We pathologically evaluated temporal changes to astrocytic Cx43/Cx30 and oligodendrocytic Cx47/Cx32 immunoreactivities at presymptomatic, disease-progressive, and end stages, relative to aquaporin-4 (AQP4), glial fibrillary acidic protein (GFAP), excitatory amino acid transporter-2 (EAAT2), myelin-oligodendrocyte glycoprotein (MOG), and Nogo-A immunoreactivities, and observed neuronal loss by NeuN and neurofilament immunostaining, and microglial response by Iba-1 immunostaining. We also performed quantitative immunoblotting and real-time PCR analyses for Cxs.Results: The mSOD1-Tg mice showed neuronal and axonal loss in the anterior horns of the lumbar spinal cord accompanied by increased activation of microglia compared with non-Tg mice at the disease-progressive and end stages. Expression patterns of Cxs were not different between mSOD1-Tg and non-Tg mice at the presymptomatic stage, but immunoreactivities for GFAP, Cx43, Cx30 and AQP4 were increased in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. By contrast, Cx47 and Cx32 immunoreactivities were markedly diminished in Nogo-A-positive oligodendrocytes in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages, especially in oligodendrocytes showing SOD1 accumulation. EAAT2 immunoreactivity was also diminished in the anterior horns of mSOD1-Tg mice at the disease-progressive and end stages. Quantitative immunoblotting revealed a significant reduction in Cx47 and Cx32 protein levels in mSOD1-Tg mice at the disease-progressive and end stages. The levels of Cx47 and Cx32 mRNAs were also decreased at these stages.Conclusions: Our findings indicate that oligodendrocytic and astrocytic GJ proteins in the anterior horns of spinal cord in mSOD1-Tg mice are profoundly affected at the disease-progressive and end stages, where disruption of GJs among glial cells may exacerbate motor neuronal death.
U2 - 10.1186/1742-2094-11-42
DO - 10.1186/1742-2094-11-42
JO - Journal of Neuroinflammation
JF - Journal of Neuroinflammation


When choosing your shower tote that you'll be using everyday, you'll want to make sure it can hold everything you need without your stuff falling out. Our Basket Shower Tote Clear has high side walls and a stationary handle that makes sure once you place your stuff inside that it won't be flopping out. Some cheap plastic baskets have moving handles which always send your heavy shampoo bottles to one side only to fall out. This shower caddy also boasts separate compartments to keep your stuff neat and organized.


text:
Happy Monday! We hope you all had a great weekend and are ready to get back in action with another productive week. But first, how about some Coffee Talk about recent changes on the world of marketing and advertising that will change how we perform our jobs.
Peeple – Why Is The Yet To Be Released App Breaking The Internet?
There is a huge amount of internet shaming going about the unreleased app, Peeple. Touted as the Yelp for People, marketing entrepreneur and CEO Julia Cordray hinted that the app idea is very much alive and kicking after she hired a new executive.
Peeple says that the company's goal is to become "The world's largest positivity app," however, it has drawn a lot of flak on the internet as the core idea of the app is in allowing users to create profiles of other people and then post content about them. The company however clarified that the platform is 100% opt-in with the option of reviewing the content and also deactivating an account at any point in time.
TA's verdict:
If this app is approved, then chances are it will be used to study consumer demographics, personal tastes, likes and dislikes in close quarters.
Facebook To Release 6 New Emojis
The world's biggest social networking company will now allow its users to express themselves through a wide range of emotions by giving them the options to choose from 6 new emojis.
Social networking giant Facebook finally unveiled what was long anticipated – a new alternative to their ever popular 'Like' feature. Called, 'Reactions', these icons will allow users to express their love, laughter, shock, sadness, happiness, and anger throughout the social networking platform.
The new features can be accessed by long-pressing (clicking & holding the cursor) the thumbs-up symbol for the Like button. At the moment, the feature is being tested in Ireland and Spain, so you'll have to continue to make due translating your emotions through emoticon text sometime before you can try it out.
This is good news for digital marketers, who can now determine exactly how their target audience feels about a particular product, service, or a post in general- resulting in improved strategies. Additionally, earlier users who are opposed to user generated content due to difference of opinion can now open up and express themselves using these emoticons.
This ultimately translates into improved customer interaction and engagement with brands or businesses marketing on Facebook.
#MotivationMonday
By TalenAlexander|Coffee Talk, Industry News|


In collaboration with the BSTH, CSL Behring is pleased to announce the donation of an Encouragement Grant of 10.000€.
Laboratory research scientists wishing to carry out part of their research project in a specialized research center.
In all cases, it is the intention of the Encouragement Grant to allow clinicians and research scientists to extend their expertise and achieve cutting edge results.
Elien Roose Kulak, to work for three months with Dr. Mihaela Delcea at the Centre for Innovation Competence - Humoral Immune Reactions in Cardiovascular Diseases (ZIK HIKE, University of Greifswald, Germany) on the elucidation of the unfolding of ADAMTS13 using ITC and AFM.


Making year-end lists is hard. The process of tracking down all the music you heard over the prior 12 months, then whittling those songs down to the "best" material, is often a battle, both internally and externally. Once the selections are made, the blurbs written and the beloved jams placed into pretty packages for public consumption, comes the inevitable feeling of dread: "I forgot to include something that I really, really loved." Typically, there's nothing to be done after the fact, except personally vow to not make the same mistake next year. But this time around, I'm (thankfully) able to take a few steps back into 2015 to give an overlooked track its just due.
Released in November, Joella DeVille's "Submit To Ya" is a time capsule to the '90s, when soulful seduction was smooth and straightforward. The Jersey City singer-songwriter describes her own sound as "raw pop" — but "Submit To Ya" is all-R&B everything. With phenomenal production handled by Phoenix-based producer LeeTRBL, Joella knows exactly how to work the beat to her advantage. Instead of overdoing it with flowery verses and complex harmonies, she settles right into the funk-lined groove, playing nice and slow alongside a freaked vocal loop reminiscent of something Timbaland would have cooked up for the late, great Aaliyah. The relaxed bridge of ascending "oohs" and the hook of descending "heys" linger just long enough, a vocal roller coaster that swoops and dips between Joella's promises of sensual submission. My advice? Put this track on repeat and enjoy the ride.
"Submit To Ya" is the lead single from Joella DeVille's upcoming EP, Control. You can buy the song now on iTunes.


At the end of last week's blog post I ended the penultimate sentence with "…there are plenty of single-family homes being built or being drastically remodeled throughout the city." Reader Adrian noted that although there are plenty of single-family homes being rebuilt throughout the city, the number of new single-family homes being added to our existing supply is close to zero. He's right in that, largely because within the city limits there is very little open land upon which single-family homes can be economically built. On the open land that does exist, such as the parcel out on Maple Street east of Highway 101, developers are instead choosing to build multi-family developments consisting of townhomes. The higher density you get from a townhouse development makes more sense for some areas of the city, especially those close to transit (like the 33 units that are being built on El Camino Real at Hopkins Avenue).
Prior to the construction of this rather large house, the lot held a single-story, 1,440 square-foot home that featured three bedrooms and two bathrooms. The original home was built in 1925, and probably needed to be updated (although I seem to recall seeing various remodeling projects being done on that home over the years). But the above is no remodel: the home was completely torn down and the foundation was ripped up, after which the 8,255-square-foot parcel was re-graded and construction of the home you see pictured above got underway.
Projects like these are what I was thinking of when I wrapped up last week's post on multi-family developments. However, Adrian's response to that post got me thinking about places where additional single-family homes really were being built within the Redwood City limits. I didn't come up with a lot of examples, but I did manage to think of a few. As I noted earlier, although there is very little open land upon which to build new single-family homes, there have been, and still are, a number of parcels with a single home on them that are large enough for subdividing.
Because the property was so deep, a new road, Lauren Lane, was built to provide access to the four homes that are arrayed behind the one home in this development that fronts onto Valota Road. Because one home was torn down and five were built in its place, this particular project resulted in a net addition of four new single-family homes, all within the Redwood City limits.
It may not look all that big, but don't let appearances fool you. The house is actually quite deep. Like the other, this home is also 4,000 square feet, and has five bedrooms to go with its four bathrooms.
So again, this is an instance where a one single-family home was torn down to make way for four new ones, a net addition of three.
The developer seems to have done a pretty good job of retaining some of the mature trees that have clearly been growing in this area for years. Here, too, the homes vary in style (note the one with the round tower feature on the left), helping to reduce the feeling that they were all built as part of a single development. Although I'm pretty sure that Liberty Hall Lane is a private road, and that the homeowners all belong to a road association to keep that road maintained, so each of the eight the homeowners will always have that small reminder, at least, that their home was indeed part of a planned subdivision.
This home, which is located just a couple of parcels beyond the Bonfare Shopping Center up Oak Knoll Drive, is also hard to see thanks to the thick trees that hide it from the street. From what I can tell the house is in terrible shape and is a complete tear-down. But it sits on a remarkably large (for the area) .91-acre lot, and the current owner has plans to tear down the house, subdivide the lot, and build three new single-family homes on the parcel. The above picture is very recent (but the property hasn't really changed in months; I don't believe it is currently occupied). In mid-February the owner (who appears to be a contractor) went before the Historic Resources Advisory Committee to make sure that this house, which was built in 1920, is historically significant. Assuming that it isn't, he will request permission to subdivide and then develop the property. Assuming it is, this will be yet another net addition to Redwood City's stock of single-family homes — although it will of course be a very small net addition.
The above are just the developments I can think of off the top of my head, developments that came about since I began this blog (and that lie within the city limits; I know of at least three more that fall just outside those limits). I'm probably missing some, though, and I expect that there will be a couple of more of these over the next several years as homeowners with very large properties decide to sell and as developers get wind of those properties. But I will be the first to admit that although these have all resulted in a net addition of detached, single-family homes to Redwood City, that addition is a very small one. If I've done my math right, the above projects resulted in a total of 17 net new homes, which compared to the approximately 15,000 single-family detached homes that existed prior to them, is just a drop in the bucket.
A new house plus in-law unit will be built soon on the forever-vacant lot on the uphill side of Alameda between Hopkins and Brewster.
Thanks for heads-up. I'll go by tomorrow and take some "before" pictures.
I for one am excited to see more housing built in Redwood City. Single family homes may not be the most efficient use, but subdiving large lots to create a handful of new SFHi something I can agree with.
Egads, that house on Hillview is the poster child for RWC's loose zoning. Is it any surprise that it's a developer looking to turn a quick profit. In response to some of these excessive homes, our City is embarking upon a process to create design standards and guidelines that include the revisiting of our ADU ordinance that allows a 28″ tall building that is 5′ from the property.
I'll be very interested to see what guidelines the city comes up with in order to preserve neighborhood character without unduly squashing homeowner's rights. They'll be walking a tightrope there. As for the ADU ordinances, that seems to be a slightly easier issue to tackle.
Burlingame has had a Residential Design Guidebook for many years and it has done absolutely nothing to curtail large homes or squash homeowner's rights. But what it has done is reign in the profit-driven developer spec homes that have no regard for the neighborhood. I have seen Amish barns with more charm, character and attention to detail than that dreadful house on Hillview.
In most other peninsula cities, that project would have never seen the light of day. The Planning Dept would have sent the developer back to the drawing board. Redwood City is the developer's cheap date on the peninsula and it shows.
I find the modern house fronting canyon rd to be a lot less appealing, to each their own.
There are so many remodeled homes in Redwood City of questionable design, particularly in the Woodside Plaza area. I want to ask some people who their architect was so that I could be sure to NOT use them.
I don't have all of the data, unfortunately, but it would be fascinating to compare the designs of owner-occupied major remodels (or complete tear downs) with ones done solely to flip a house. I would guess that people remodeling their own homes, that they intend to continue living in, would, on average, tend to use much more conservative designs that better fit within the neighborhood (after all, they have to continue living with those neighbors!). Of course, there is no accounting for taste, so in any given situation the outcome could still be great or could be horrible (in the eye of the beholder) but if I had to guess, I'd say that the majority of the really poor designs would be home flips.
We've had a handful of larger lots recently subdivided here in the Sequoia/Selby tract…of course we're technically county. I know of at least one lot nearby that they've applied to subdivide so there will be more. Lots of tear downs as well…but that's pretty much happening everywhere in San Mateo county.
Indeed, it seems to be happening everywhere. Which is no real surprise, of course.
I need to wander through your area more. It seems to be a nice place, from what I've seen.
Like a lot of county areas it can be pretty eclectic, but we like it! For the most part I don't mind the larger lots being subdivided as we already have a huge range of lots sizes in the neighborhood (2,500 to 1/3 acre +)…but one of the lots used to be empty and had sheep/livestock…which was charming. Oh well, at least the new homes that replaced it look pretty nice, albeit probably pricey. I did notice almost a whole block of the retail properties along Woodside Rd near us recently traded hands…I wouldn't be surprised if they got redeveloped.
Indeed, it seems to be happening everywhere. Which is no surprise, of course.
I need to walk through your neighborhood more. It seems like a nice place, from what I've seen.
What we're seeing in our neighborhood is new 2-story garages with "in-law" units (probably not for the actual in-laws to live in). We're getting one next door and one immediately behind those neighbors so the view from the rear of our house is going to change a lot. I'm not thrilled at being surrounded but maybe if enough of these are built it will ease the rental market a tiny bit.


The Alaska Community Foundation has raised $100 million to permanently support Alaska nonprofits and other community causes, the foundation announced Wednesday.
The $100 million Alaska Fund was created by private donations from more than 1,600 Alaskans — all the way from a $25 contribution from a 7-year-old boy to large multi-million dollar estate contributions, according to ACF President Nina Kemppel. While the five-year "Campaign for Alaska's Future" originally planned to raise $50 million, she said it met that goal in July — then doubled it over the next several months.
Community Foundation board member and Rasmuson Foundation President Diane Kaplan said the moment marked a major milestone for philanthropy in Alaska.
"Today we begin a day where people who have come to Alaska, who have lived in Alaska their whole lives, who are committed to the future of Alaska, are saying very loudly, we are going to keep Alaska's wealth in Alaska," Kaplan said.
A New York native, Kaplan spoke about the philanthropic legacy of J.P. Morgan and the Guggenheim family, their involvement with the lucrative Alaska Syndicate, and how the Alaska Syndicate's interests in copper mining, fishing and transportation helped fund great public works in the Lower 48.
Alaska Community Foundation president Nina Kemppel said the Alaska Fund's money will be distributed through grants to community organizations around the state, directed towards needs identified by the ACF Board of Directors. In years past, she said, the foundation has supported organizations providing everything from food and shelter to wellness and suicide prevention initiatives. The board is scheduled to meet Feb. 14 to determine future funding priorities, Kemppel said.
To Alaska nonprofits, the fund is poised to make a lasting future difference. Lisa Aquino, executive director of Catholic Social Services, said organizations like hers serve thousands of Alaskans every year. They rely in large part on private donors, she said.
The community foundation says it expects to release more information about new funding opportunities within the next month.


text:
Echinocorambe brattegardi is een slakkensoort uit de familie van de Akiodorididae. De wetenschappelijke naam van de soort is voor het eerst geldig gepubliceerd in 1998 door Valdés & Bouchet.

Akiodorididae


text:
Tjesbastperet est une princesse égyptienne de la , fille d'.

Il semble que Tjesbastperet soit née à la fin du règne d', fruit de l'union du roi avec Isetemhekhbet, une épouse secondaire.

Généalogie

Elle épouse Takélot qui est lui-même le fils de son demi frère Sheshonq, grand prêtre de Ptah à Memphis et lui donne un fils Padiiset qui deviendra lui-même grand prêtre de Ptah sous le règne de , et une fille Djedbastetesânkh qui épousera le pharaon .

Les seules mentions de sa vie sont des précisions généalogiques que feront les descendants de Takélot qui se succèderont au pontificat memphite jusqu'à la fin de la dynastie.

Comme presque toutes les princesses et épouses royales de la Troisième Période intermédiaire, on ignore le lieu exact de sa sépulture qui aurait pu être située à Memphis dans l'enceinte d'un des sanctuaires de l'antique capitale selon une pratique devenue fréquente à dater de cette époque d'inhumer les membres de la famille royale au plus près des temples afin de les protéger du pillage.

Les quatre vases canopes de la princesse sont en tout cas conservés au Musée d'Histoire de l'Art de Vienne en Autriche, démontrant que le tombeau de la princesse a bien été trouvé et pillé...

Ces quatre vases canopes en albâtre d'une facture très classique portent sur leur panse une dédicace donnant le nom de la princesse ainsi que ceux de ses parents. Ils sont un témoignage rare du viatique funéraire qui accompagnait les filles royales de la dynastie et dont la qualité rivalise avec les meilleurs exemplaires connus sortis des ateliers royaux qui ont été retrouvés dans tombes royales ou princières, que ce soit à Tanis ou à Memphis.

Notes et références

Bibliographie

  ;
  ;

Index égyptologique
Enfant royal de l'Égypte antique
XXIIe dynastie égyptienne
Princesse de l'Égypte antique


text:
Pediatricians relax guidelines on screen time for kids to give more flexibility
By Megan Thielking @meggophone
Steven Senne/AP
The American Academy of Pediatrics is out with new recommendations to help kids maintain a healthy diet — of tablets and smartphones.
Previous guidelines focused on stricter limits: No screen time for kids under 2, and just two hours a day for older kids. But with the media landscape shifting, the physician group decided flexibility was in order.
The organization now recommends that parents keep infants and toddlers away from screens until they hit 18 months. The exception: video chatting, which is now seen as a healthy form of communication.
For kids ages 2 to 5, the organization recommends limiting consumption to an hour per day of high-quality programming. The key: Parents watching alongside their kids.
"We encourage parents to participate in the media," said Dr. Megan Moreno, a pediatrician at Seattle Children's Hospital and an author of the new guidelines. Sitting down to watch TV or play an interactive game together, she said, makes media consumption into more of a family activity.
The new guidelines urge parents not to use media time as a way of soothing upset children, which could hurt their coping skills in the long run.
Once children hit school age, the recommendations loosen, leaving room for parents to make their own judgment calls. The AAP suggests that parents set boundaries on screen time and designate some media-free spaces, like the dinner table and bedrooms. But if they want their kids to follow the rules, parents have to set the example.
"When we say something to them but don't follow that ourselves, they pick up on that really quickly," said Dr. Shannon Scott-Vernaglia, a pediatrician at Massachusetts General Hospital.
Experts recommend placing consistent limits on how often children can use media, and in what format. Having that conversation early is key, experts said, as backpedaling can be tricky with kids.
"Establish early that there are limits," Scott-Vernaglia said. "Then you can adjust them as children get older and as those limits may change."
She said she often talks with parents who think there's an absolute limit on screen time and worry about letting kids sit in front of TVs or tablets too much. "I try to change that conversation to be — what are you doing with that screen time?" she said.
The group's new approach reflects a recognition that blanket guidelines don't work: Recommendations for a 2-year-old shouldn't look anything like recommendations for a 17-year-old, Moreno said.
"Children and adolescents are personalizing the way they use media, and we really wanted our guidelines to reflect that," Moreno said. "Media isn't this bad thing we need to restrict. It can be highly beneficial."
Megan Thielking
Megan writes about health and medicine, with a focus on mental health.
megan.thielking@statnews.com
@meggophone
Naomi Erlich says:
This is very interesting. I think that video chatting is ok since they are seeing another person they know on the other side of the screen. I also agree that if you are going to have your child watch something, you should be there with them. Thanks for the great information!
http://www.parentingpod.com
The truth about JPM: Less is more
Why Black doctors like me are leaving faculty positions…
Why Black doctors like me are leaving faculty positions in academic medical centers
More than 15% of U.S. adults are physically inactive,…
More than 15% of U.S. adults are physically inactive, new CDC data show
Three African nations roll out first malaria vaccine in…
Three African nations roll out first malaria vaccine in closely watched trial
Novel virus tied to Chinese outbreak found in Japan,…
Novel virus tied to Chinese outbreak found in Japan, as second death is reported
By Shraddha Chakradhar
By Andrew Joseph
'Donation after cardiac death': New heart transplant method being tested for the first time in the U.S.
Previously unseen mutations in stem cells of young donors can be passed to recipients, study finds


text:
Digital Projected To Reach Nearly 40% Of Media Industry Content Spending
by Joe Mandese @mp_joemandese, January 6, 2021
Nearly four out of every ten dollars spent by the media industry on entertainment content this year will be earmarked for distribution on digital media. That's the narrowest gap in the nine years the equity research team at securities firm UBS has been tracking it.
With the exception of a …
Reminder: You are seeing this premium content because you are a subscriber to MediaPost's Research Intelligencer and/or a member of the Center for Marketing & Media Research. This content cannot be viewed by non-subscribers/non-members.
covid-19, digital, entertainment, research
Discover Our Publications
The art, craft and science of digital media, advertising and marketing
Must-read daily news for media planning and sales professionals.
Must-read daily news for brand, product, service marketing execs.
Advertising and agency news, campaigns, accounts and more.
Must-read daily news for the television industry.
Must-read daily news for the publishing industry.
Must-read daily news for email marketers.
Must-read daily news for the search & performance marketers.
Premium insights on research daily.
In-depth interviews with brand marketers.
Inside media planning.
Inside brand marketing.


Pregnancy Care Clinic exists to serve women and their unborn children. We provide accurate information about the developing life in the mother's womb and life- affirming alternatives to abortion. We speak the truth in love and offer a loving refuge where each woman will find unconditional love, acceptance and support. Pregnancy Care Clinic is truly a safe haven where a woman can make a confident and informed decision regarding her future and the precious life within her.
Learn more about the clinic and the impact we've had on our community – see "Letting The Light In", a PDF booklet that spotlights our accomplishments and commitment to promote a culture of life in San Diego County and the world.
We Do Not Perform or Make Referrals for Abortions.


an Evening with the Artists of "Into The Woods"
You're invited to mix and mingle with the artists among their works before the show soon comes to a close.
Morris-Warren Gallery is pleased to present "Into The Woods", a group show featuring Aimee Burg, Nicholas Cueva, Adam Frezza & Terri Chiao, Jytte Hoy, Jon Legere, Gregory MacAvoy, Esperanza Mayobre, Abraham McNally, Jason Middlebrook, Jim Osman, Kardash Onnig, Cordy Ryman, Darragh Rooney, Jill Satterfield, Frank Shattuck, Steve Silver, Peter Thorne, and Lindsey Wolkowicz. The artists in this show are all using wood in one form or another as the medium for their work.


CLEVELAND (June 8, 2017) – Grand Valley State captured its 12th Division II Learfield Directors' Cup, while Oklahoma City took home its first-ever Directors' Cup in 2017. Stanford continues its lead in the Division I standings. The winning institutions, including Williams who captured the Division III Cup, will be honored at the 2017 NACDA Convention during the Learfield Directors' Cup Awards Luncheon on Wednesday, June 14.
The Lakers tallied 1020.00 total points, scoring in the maximum 14 sports, including a national championship in women's cross country and four runner-up finishes. GVSU had two scores omitted due to the seven maximum allowed for women's (softball and tennis). California Baptist has finished in the top-five in the final standings, recording 750.25 total points and scoring in the maximum 14 total sports, including four top 10 finishes. West Florida scored in 10 total sports, recording 641.00 total points, including a national championship in men's tennis and six total top 10 finishes. UC San Diego ends the year in fourth place with 637.00 total points, scoring in 11 total sports with its highest finish coming in baseball (2nd). Rounding out the top five is Queens (NC) with 618.00 total points, capturing both the men's and women's swimming and diving championship.
Oklahoma City scored in the maximum 12 sports 12 (six men's/six women's sports), having one score omitted on the women's side and two scores omitted on the men's side, finishing the year with 982.00 total points. The Stars recorded four national championships and 11 top 10 finishes overall. Lindsey Wilson finished second overall this year, recording 805.00 total points, tallying two runner-up finishes and 10 top 10 finishes. Keiser scored 705.25 total points to finish third overall. The Seahawks scored in the maximum 12 sports, having one men's score omitted and tallying eight top 10 finishes. Wayland Baptist captured the women's outdoor track and field title and finished fourth overall with 690.00 total points. Rounding out the top five is William Carey with 656.00 total points, scoring in 12 total sports, including a third place showing in baseball.
Stanford continues to lead in Division I with 1556.75 total points, after a second place finish in women's tennis, a third place finish in women's golf, a sixth place finish in women's rowing, a ninth place finish in men's tennis and a 20th place finish in men's golf. Ohio State remains in second place with 1376.75 points, thanks to second place finish in men's lacrosse, a pair of third place finishes in both the men's and women's tennis tournaments, a pair of fifth place finishes in women's golf and rowing, and also scoring in both men's golf and softball. Third through fifth places are separated by a mere 40.75 points. In third place is Michigan with 1144.75 total points. The Wolverines notched a third place finish in women's rowing, while also scoring in both the men's and women's tennis and golf championships and softball. Not far behind in fourth place is USC with 1112.75 total points. The Trojans made a one spot jump after a third place finish in women's golf, a pair of fifth place finishes in men's golf and women's lacrosse, and also scored in both the men's and women's tennis tournaments (ninth and 33rd, respectively). Rounding out the top five is North Carolina with 1104.00 total points. The Tar Heels made a three spot jump to land in the top five after a second place finish in men's tennis, fifth place finish in women's lacrosse, a pair of ninth place finishes in women's golf and men's lacrosse and a pair of top-20 finishes in men's golf and softball.
The Pac-12 leads all Division I conferences with four institutions in the top-10 – Stanford (1st), USC (4th), UCLA (6th) and California (9th).
The Learfield Directors' Cup was developed as a joint effort between the National Association of Collegiate Directors of Athletics (NACDA) and USA Today.
The final Division I standings will be released Wednesday, June 14.
About Learfield: An industry leader for more than four decades, Learfield has a deep presence in the college athletics landscape nationwide. It manages the multimedia and sponsorship rights for more than 120 collegiate institutions, conferences and arenas, and supports athletics departments at all competitive levels as title sponsor of the prestigious Learfield Directors' Cup. Learfield also provides its collegiate partners access to professional concessions and ticket sales; branding, licensing and trademark consulting; digital and social platform expertise; campus-wide business and sponsorship development; and venue and technology systems through its affiliated companies.


Scandinavian discounter Netto brings ancient Viking skincare tradition to the UK that'll have you trawling through the Netto aisles.
Netto, the Scandinavian discounter, which has a branch in Glossop, is launching its newly developed Premieur Pickled Herring Face Mask, which promises to preserve the youth of your skin and keep it radiant looking for months.
The face mask has been developed based on ancient Viking traditions, but also takes inspiration from the latest ancient Korean skincare craze of using fermented food elements, such as Kimchi, on the skin.
Netto UK's technical manager, Nigel Tong, comments: "Everyone is going totes cray over the ancient fermented skincare traditions in Korea, but what people don't talk about outside of Scandinavia are the benefits of pickled herring on our skin.
Each pack of Premieur Pickled Herring Face Mask contains just pieces of pickled herring and comes with fish bone tweezers for easy application. It is priced at just £5 and lasts 'practically forever' as the product is pickled, and contains no added carp.
If you are fishing for the perfect beauty product – 'fish-head' along and 'Netto' your face mask today – you'd be an April Fool not to!!