SphinxQL-Query-Builder

Posted 7 years ago - updated 7 years ago

$statement  = SphinxQL::create($connection)
        ->select(['sku', 'price', 'normal_price', 'rating'])
        ->from(SPHINX_PRODUCTS_INDEX)
        ->match('*', $query)
        ->groupBy('id_catalog_config')
        ->orderBy('WEIGHT()', 'DESC')
        ->orderBy('is_new', 'DESC')
        ->limit($limit * $iteration, $limit)
        ->option('max_matches', self::MAX_ITERATIONS * $limit);

Write your own

SphinxQL::create($conn)->query($sql)->execute()