 had been judging season 6 and season 7 with rose-colored glasses. Even when things got lackluster in season 5 and parts of season 6 I didn't mind so much because sadly that happens with many shows. It was still good enough to watch. 

I didn't enjoy season 7 the first time I watched it but really hoped season 8 could stick the landing. Then I would have been able to overlook season 7.

The first huge red flag for me was the Battle of the Bastards. Yes, it was beautiful but it was also nonsensical and in hindsight it showed the shallow poorly written direction the show was heading in. 

I'm sure if I went back and watched season 5 onwards without my rose-colored glasses I'd see far, far more red flags but I can't bring myself to rewatch GoT.Q: how to filter magento 2 collection with 'or', 'and' combination? For example, the search query is'samsung lcd'. it can match with product name or SKU.
I have below product names.
1.samsung xyz lcd.

2.samsung lcd pack.

3.samsung mobile

4.screen lcd.

so when I filter I need to get only
 1.samsung xyz lcd.

 2.samsung lcd pack.

where name like '%samsung lcd%' or sku like '%samsung lcd%' or (name like '%samsung%' or sku like '%samsung%' and(name like '%lcd%' or sku like '%lcd%'))

but now I'm getting all above product names.
Could you please help me with this.
$term = $this->getRequest()->getParam('term');
$termArr = explode(' ', $term);
$search = array();
$search[] = array('attribute' =>'sku', 'like' => '%'. $term. '%');
$search[] = array('attribute' => 'name', 'like' => '%'. $term. '%');
        foreach ($termArr as $termc) {
            $search[] = array(
                'attribute' => 'name', 'like' => '%'. $termc. '%');
            $search[] = array(
                'attribute' =>'sku', 'like' => '%'. $termc. '%');
        }

  $objectManager = \Magento\Framework\App\ObjectManager::getInstance();
        $collection = $objectManager->create('\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory')->create();
        $collection->addAttributeToSelect('name');
        $collection->addFieldToFilter($search);
        $collection->addAttributeToFilter('status',\Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED);
        $collection->setPageSize(10);   

update:
The following code is working fine, but not optimized.
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
    $term = $this->getRequest()->getParam('term');
    $termArr = explode(' ', $term);      
    $pids = array();
    if (count($termArr)) {
        $collection1 = $objectManager->create('\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory')->create();
        foreach ($termArr as $termc) {
            $termc = trim($termc);
            if ($termc == '')
                continue;

            $search1 = array();
            $search1[] = array(
                'attribute' => 'name', 'like' => '%'. $termc. '%');
            $search1[] = array(
                'attribute' =>'sku', 'like' => '%'. $termc. '%');
            $collection1->addFieldToFilter($search1);
        }
        $collection1->getSelect()->reset(\Zend_Db_Select::COLUMNS);
        $collection1->getSelect()->columns(['entity_id']);           
        $pids = $collection1->getAllIds();
    }
    $collection = $objectManager->create('\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory')->create();
    $collection->addAttributeToSelect('name');
    $search = array();
    $search[] = array('attribute' =>'sku', 'like' => '%'. $term. '%');
    $search[] = array('attribute' => 'name', 'like' => '%'. $term. '%');
    if (count($pids)) {
        $search[] = array('attribute' => 'entity_id', 'in' => $pids);
    }
    $collection->addFieldToFilter($search);
    $collection->addAttributeToFilter('status', \Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED);
    $collection->setPageSize(10);


A: Try with below code :

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$collection = $objectManager->create('\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory')->create();
$collection->addAttributeToSelect('name');
$collection->addAttributeToFilter('name', array('like' => '%'.$term.'%'));
$collection->addAttributeToFilter('sku', array('like' => '%'.$term.'%'));
$collection->addAttributeToFilter('status',\Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED);
$collection->setPageSize(10);   

As gaming technology has advanced, the music industry has had the opportunity to release games with instrument and dance mat controls that let people sing, play and dance along to popular tunes. Here are a few examples of the top music-based games ever made.
This is a game from 2009, where you employ instrument game controls, to sing or ‘play’ along with the songs onscreen. The focus is on Metallica in the modern day, but there are songs from throughout their career (including Enter Sandman and Nothing Else Matters), while you can play as band members or other rock bands featured in the game.
This game takes you down through the career of the legendary band, using guitar or drum controls to simulate the songs. Every song is here, along with superb graphics covering all stages of the Beatles career, and a choice of levels, depending on your skill level.
The control in this game is the mat you dance on, and it provides you with a workout mode, if you actually want to use it to keep fit. You can also pick a character to dance as, as you try to keep up with tunes like So Good and I Will Survive, and you can dance in training mode if you are new to the game.
This online casino musical slot game has a 1950s rock ‘n’ roll theme and reels featuring dancing shoes, a rocker and glitterballs. The range of payout sizes, from 300 coins to the 1000 maximum jackpot and the bursts of music that accompany the game play really make this game – although the Grease-style graphics are pretty good too. This one can also be enjoyed from your smartphone too on a mobile or iphone casino site.
This 2010 game lets you sing and dance along to Jackson hits, either in single or multi-player modes – with onscreen lyrics optional. Songs include Billie Jean and Bad, and your score depends on how accurate you are with the words and dance moves.
This is surely the only game that lets you showcase your DJ skills, including crossfading, scratching and mixing. The control is a moveable turntable and it employs the same score attack style of game play as Guitar Hero. Tunes to work with include Around the World by Daft Punk and Boom by Grandmaster Flash.
This 2008 game is a kind of karaoke game, where you use motion sensitive microphone game controls to sing along with hit songs. You can do duets or use multiplayer gaming modes, and you win points based on things like pitch, rhythm and vibrato.
This 2010 game is karaoke involving rapping, rather than singing, as you have to show off your skills and win points by delivering classic raps from Def Jam hip hop hits like Hot in Here and Gin and Juice. You also get the original videos and five different gaming modes to play in, plus a choice of swearing or not!baby lettuce mix, spinach, bok choy, radish, turnips, a selection of 4 mustard greens including arugula, mizuna, red rain and tatsoi, cilantro, green onions, alfalfa sprouts and beet greens.
lettuce, spinach, bok choy, mustard greens and beet greens are all apparently super foods! (According to post I saw on facebook a while ago – so don’t quote me on that yet). This is super food week!
As always, if you have any great recipe suggestions please send them to me and I can post them to the blog.
If you like spicy mustard