Сергей Шевченко

{
  "query": {
    "bool": {
      "must": [
        {
          "terms": {
            "id": [
                 111,
                 222,
                 333
            ]
          }
        },
        {
          "bool": {
            "should": [
              {
                "match": {
                  "name": {
                    "query": "курс"
                  }
                }
              },
              {
                "nested": {
                  "path": "tags",
                  "query": {
                    "match": {
                      "tags.name": {
                        "query": "курс"
                      }
                    }
                  }
                }
              }
            ]
          }
        }
      ]
    }
  }
}

SELECT *
FROM user as u
WHERE (
    DATE_FORMAT(u.birthday, '%m%d') >= (
        SELECT
            CONCAT(LEFT(`h`.`date_start`, 2), RIGHT(`h`.`date_start`, 2))
        FROM horoscope h
        WHERE h.name = 'Capricorn'
    ) AND DATE_FORMAT(u.birthday, '%m%d') <= 1231
) OR (
    DATE_FORMAT(u.birthday, '%m%d') >= 101 AND DATE_FORMAT(u.birthday, '%m%d') <= (
        SELECT
            CONCAT(LEFT(`h`.`date_end`, 2), RIGHT(`h`.`date_end`, 2))
        FROM horoscope h
        WHERE h.name = 'Capricorn'
    )
);

echo '<p style="color: red">' . $res['inf'] . '</p>' ;

/**
     * {@inheritDoc}
     */
    protected function _validationRules()
    {
        $qntValidSelect = new Zend_Db_Select(Zend_Db_Table_Abstract::getDefaultAdapter());
        $qntValidSelect
            ->from(OptionTableMap::TABLE_NAME)
            ->where('Name = ?', $this->getData('name'))
            ->where('ThingId = ?', $this->getData('thingId'));

        return [
            'name' => [
                self::PRESENCE => self::PRESENCE_REQUIRED,
                'NotEmpty',
                [
                    'StringLength',
                    ['max' => 255],
                ],
            ],

            'slug' => [
                self::PRESENCE => self::PRESENCE_REQUIRED,
                'NotEmpty',
                [
                    'StringLength',
                    ['max' => 255],
                ],
            ],

            'thingId' => [
                self::PRESENCE => self::PRESENCE_REQUIRED,
                'NotEmpty',
                [
                    'StringLength',
                    ['max' => 11],
                ],
                [
                    'Regex',
                    ['pattern' => '/^[1-9]\d*$/'],
                ],
                [
                    'DB_RecordExists',
                    [
                        'table' => ThingTableMap::getTableMap()->getName(),
                        'field' => ThingTableMap::getTableMap()->getColumn('id')->getName(),
                    ]
                ],
            ],

            'select' => [
                [
                    'Regex',
                    ['pattern' => '/^[01]*$/'],
                ],
            ],

            'accounting' => [
                [
                    'Regex',
                    ['pattern' => '/^[01]*$/'],
                ],
            ],
        ];
    }

array_to_string("map_points"[1:1], '{') AS "gps",
                array_to_string("map_points"[2:2], '{') AS "name",

$offer['name'] = preg_replace('/[\{\}]/', ' ', $offer['name']);