Микола

andWhere( 'date >= 2018-04-01 00:00:00  AND date <= 2018-08-01 23:59:59')

<code lang="php">
andWhere(['>=',  'date', strtotime('2018-04-01 00:00:00')])->andWhere(['<=', 'date', strtotime('2018-08-01 23:59:59')]);
</code>

$fullarray = [.....]; //Массив с данными
 $fields = ['product_id','name','group_id','manufacturer','fullname','code'];
       
$db = Yii::$app->db;
$sql = $db->queryBuilder->batchInsert(self::tableName(), $fields, $fullarray);
$product_insert_count = $db->createCommand($sql . ' ON DUPLICATE KEY UPDATE name = VALUES(name), group_id = VALUES(group_id), manufacturer = VALUES(manufacturer), fullname = VALUES(fullname), code = VALUES(code)')->execute();

SELECT `field1`, `field2` FROM `table` WHERE `id` <> 5

UPDATE products p 
    JOIN update_info ui ON t.id =  ui.id
SET p.price = ui.price

.your_block{
background: url(images/q_up.gif) no-repeat 0% 0%,
                url(images/q_down.gif) repeat-y 100% 100%; 
padding: 100px;
}